X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=lib%2Freport.php;h=b268440f6d5d0eb901ef45840ddb4a5faf8a5a3b;hb=b0347297ea5b4b7a8a4a5c2124c074b53539da6c;hp=e74ac07b34aa16a74adbf762130ebd5a8051213e;hpb=8ed7023cec6e6c090aa4c0776f5b30cad8f59c11;p=readifood.git diff --git a/lib/report.php b/lib/report.php index e74ac07..b268440 100644 --- a/lib/report.php +++ b/lib/report.php @@ -66,10 +66,93 @@ return true; } + function show_order_report(&$order_state_ids) { + echo "
0 | Week %d | \n", $missing_week); + echo "
%d | Week %d | \n", $row->getCount(), $week); + echo "
$total | Total | \n"; + echo "
%d | %s | \n", $row->getCount(), htmlspecialchars($requester->getDisplayname())); + $total += $row->getCount(); + echo "
$total | Total | \n"; + echo "
Showing reports for the period $from to $to.
\n"; + + /* Get orders. */ + $order_ids = array(); + $order_state_ids = array(); + /* XXX: Order 51 changed to state delivered in May then updated in June. */ + $dbh = Propel::getConnection(); + $sth = $dbh->prepare("select * from OrderState o where updated=(select min(updated) from OrderState where order_id=o.order_id and state & " . $GLOBALS['STATE_DELIVERED'] . ") and updated between '$from' and '$to'"); + $sth->execute(); + $order_states = OrderStatePeer::populateObjects($sth); + foreach ($order_states as $order_state) { + $order_ids[] = $order_state->getOrderId(); + $order_state_ids[] = $order_state->getId(); + } + $q = new OrderQuery; + $q->filterById($order_ids); + + if (! count($order_ids)) { + echo "No results!
\n"; + return; + } + + show_order_report($order_state_ids); + show_requester_report($order_ids); } if (count($parameters)) {