3 if (isset($_POST['show_reports'])) {
4 header(sprintf("Location: http%s://%s/%s/from/%s/to/%s", ($_SERVER['HTTPS']) ? "s" : "", $_SERVER['HTTP_HOST'], $module, $_POST['from'], $_POST['to']));
8 function show_reports_form($from = null, $to = null) {
9 form("noprint standout");
10 echo "<p>Show reports covering the period from ";
12 /* Default to last month. */
13 list($y, $m, $d) = explode('-', date('Y-m-d', time()));
15 $now = mktime(0, 0, 0, $m, $d, $y);
16 $first = mktime(0, 0, 0, $m, 1, $y);
17 $last = $first - 86400;
18 $date = date('Y-m-d', $last);
19 if (is_null($to)) $to = $date;
20 list($y, $m, $d) = explode('-', $date);
21 $first = mktime(0, 0, 0, $m, 1, $y);
22 if (is_null($from)) $from = date('Y-m-d', $first);
24 for ($i = 0; $i < 2; $i++) {
26 list ($y, $m, $d) = explode('-', date('Y-m-d', $date));
27 $date = mktime(0, 0, 0, $m, 1, $y);
29 $oldest = date('Y-m-d', $date);
32 echo "<select name=\"from\">\n";
33 for ($date = $then; $date <= $now; $date += 86400) {
34 option("from", date('Y-m-d', $date), date('j F Y', $date), $from);
36 echo "</select> to <select name=\"to\">\n";
37 for ($date = $then; $date <= $now; $date += 86400) {
38 option("to", date('Y-m-d', $date), date('j F Y', $date), $to);
42 submit("show_reports", "Show");
46 function check_report_dates($from, $to) {
47 list($y, $m, $d) = explode('-', $from);
48 if (! checkdate($m, $d, $y)) {
49 echo "<p>Invalid report start date!</p>\n";
52 $start = mktime(0, 0, 0, $m, $d, $y);
54 list($y, $m, $d) = explode('-', $to);
55 if (! checkdate($m, $d, $y)) {
56 echo "<p>Invalid report end date!</p>\n";
59 $end = mktime(0, 0, 0, $m, $d, $y);
62 echo "<p>Report end date is earlier than start date!</p>\n";
69 function show_requester_report(&$order_ids) {
70 echo "<h3>Orders by referrer</h3>\n";
73 $q->filterById($order_ids);
74 $q->withColumn('count(*)', 'count');
75 $q->groupByRequesterId()->addDescendingOrderByColumn('count');
79 foreach ($rows as $row) {
81 $requester = get_contact_by_id($row->getRequesterId());
82 printf(" <td>%d</td><td> </td><td>%s</td>\n", $row->getCount(), htmlspecialchars($requester->getDisplayname()));
88 function show_reports($from, $to) {
89 if (! check_report_dates($from, $to)) return;
91 echo "<p>Showing reports for the period <strong>$from</strong> to <strong>$to</strong>.</p>\n";
95 /* XXX: Order 51 changed to state delivered in May then updated in June. */
96 $dbh = Propel::getConnection();
97 $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'");
99 $order_states = OrderStatePeer::populateObjects($sth);
100 foreach ($order_states as $order_state) $order_ids[] = $order_state->getOrderId();
102 $q->filterById($order_ids);
104 if (! count($order_ids)) {
105 echo "<p>No results!</p>\n";
109 show_requester_report($order_ids);
112 if (count($parameters)) {
113 if ($parameters[0] == "from") {
114 $from = $parameters[1];
115 if ($parameters[2] == "to") $to = $parameters[3];
116 show_reports($from, $to);
119 show_reports_form($from, $to);