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);
}
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"> ', $row->nr, $row->price);
printf('<span class="%s">%d %s %s (%.2f €)</span><br>',