Only display outgoing items for reimbursements

diff --git a/class/sales.class.php b/class/sales.class.php
index 60985ba..2a24d72 100644 (file)
--- 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 (file)
--- 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>',