From 88532ef3d26c9a5330a5bad832aaafd0440f0553 Mon Sep 17 00:00:00 2001
From: Joey Schulze <joey@infodrom.org>
Date: Mon, 6 Nov 2017 22:25:39 +0100
Subject: [PATCH] Display only visible items

---
 src/InfoCon/buch/index.wml | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/src/InfoCon/buch/index.wml b/src/InfoCon/buch/index.wml
index 6e2fe54..1e2084c 100644
--- a/src/InfoCon/buch/index.wml
+++ b/src/InfoCon/buch/index.wml
@@ -51,7 +51,7 @@ span.in:hover, span.out:hover { background: yellow; border: 1px solid #ccc; }
 
 <?
   $form = 0;
-  $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 ORDER BY date,nr";
+  $query = "SELECT nr,date,description,price FROM sales_dm WHERE paid=0 AND visible=1 ORDER BY date,nr";
   $sth = pg_exec ($dbh, $query);
 
   if (pg_NumRows ($sth) > 0) {
@@ -68,7 +68,7 @@ span.in:hover, span.out:hover { background: yellow; border: 1px solid #ccc; }
     printf (" %d. %s %s (%.2f&nbsp;DM)<br>", $row['nr'], $date, $row['description'], $row['price']);
   }
 
-  $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 ORDER BY date,nr";
+  $query = "SELECT nr,date,description,price FROM sales WHERE paid=0 AND visible=1 ORDER BY date,nr";
   $sth = pg_exec ($dbh, $query);
 
   if (!form && pg_NumRows ($sth) > 0) {
-- 
2.20.1