From: Joey Schulze <joey@infodrom.org>
Date: Sat, 8 Dec 2018 23:51:51 +0000 (+0100)
Subject: Only display outgoing items for reimbursements
X-Git-Url: https://git.infodrom.org/?p=infodrom.org%2Fservice.infodrom.org;a=commitdiff_plain;h=2904254cc0fe8623aace2a38ed6a38b7c4542f7f

Only display outgoing items for reimbursements
---

diff --git a/class/sales.class.php b/class/sales.class.php
index 60985ba..2a24d72 100644
--- a/class/sales.class.php
+++ b/class/sales.class.php
@@ -8,9 +8,16 @@ class Sales extends DatabaseTable {
     parent::__construct('sales', $id);
   }
 
-  public function getOpenItems($from=false, $to=false)
+  public function getOpenItems($only_in=null)
   {
-      $sql = "SELECT nr,date,description,price * 100 AS price FROM sales WHERE paid = 0 AND visible = 1 ORDER BY date,nr";
+      if (!is_null($only_in)) {
+	  if ($only_in === true)
+	      $cond = 'price >= 0 AND ';
+	  else
+	      $cond = 'price < 0 AND ';
+      }
+      else $cond = '';
+      $sql = "SELECT nr,date,description,price * 100 AS price FROM sales WHERE ${cond}paid = 0 AND visible = 1 ORDER BY date,nr";
       return $this->db->fetchObjectList($sql);
   }
 
diff --git a/src/InfoCon/buch/reimbursement.wml b/src/InfoCon/buch/reimbursement.wml
index 77ffe3b..bb05300 100644
--- a/src/InfoCon/buch/reimbursement.wml
+++ b/src/InfoCon/buch/reimbursement.wml
@@ -15,7 +15,7 @@ span.in:hover, span.out:hover { background: yellow; border: 1px solid #ccc; }
 Titel <input type="text" id="title" name="title" value="" size="20" title="Optionaler Titel der Liste"><br>
 <?php
     $sales = new Sales();
-    foreach ($sales->getOpenItems() as $row) {
+    foreach ($sales->getOpenItems(false) as $row) {
 	$date = substr ($row->date,6,2) . "." . substr ($row->date,4,2) . "." . substr ($row->date,0,4);
 	printf('<input name="nr[]" type="checkbox" value="%d" price="%d">&nbsp;', $row->nr, $row->price);
 	printf('<span class="%s">%d&nbsp;&nbsp;%s %s (%.2f&nbsp;&euro;)</span><br>',