3 if (isset($_POST['show_add_order'])) {
4 $area_id = $_POST['area_id'];
5 show_new_order_form($area_id);
7 else if (isset($_POST['add_order'])) {
10 echo "<p>Order placed.</p>\n";
11 $parameters = array("id", $id);
14 else if (isset($_POST['update_order'])) {
15 list($ignored, $id, $args) = parse_parameters($parameters);
17 $order = $q->findOneById($id);
19 if (update_order($order) !== false) {
20 echo "<p>Updated order.</p>\n";
21 $parameters = array("id", $order->getId());
25 echo "<p>No such contact!</p>\n";
28 else if ($_POST['show_in_area']) {
30 $area = $q->findOneById($_POST['area_id']);
31 header(sprintf("Location: http%s://%s/%s/in/area/%s/%d%s", ($_SERVER['HTTPS']) ? "s" : "", $_SERVER['HTTP_HOST'], $module, urlencode($area->getName()), $_POST['area_id'], get_order_state_uri(get_order_state_mask())));
34 else if ($_POST['show_in_city']) {
36 $city = $q->findOneById($_POST['city_id']);
37 header(sprintf("Location: http%s://%s/%s/in/city/%s/%d%s", ($_SERVER['HTTPS']) ? "s" : "", $_SERVER['HTTP_HOST'], $module, urlencode($city->getName()), $_POST['city_id'], get_order_state_uri(get_order_state_mask())));
41 function show_orders($offset, $per_page, $requester_ids = null, $beneficiary_ids = null, $state_mask = null) {
42 /* XXX: Use Propel methods. */
43 if (isset($state_mask)) {
45 $dbh = Propel::getConnection();
46 $sth = $dbh->prepare("select * from OrderState o where updated=(select max(updated) from OrderState where order_id=o.order_id) and state & $state_mask");
48 $order_states = OrderStatePeer::populateObjects($sth);
49 foreach ($order_states as $order_state) $order_ids[] = $order_state->getOrderId();
52 if (isset($requester_ids)) $q->filterByRequesterId($requester_ids);
53 if (isset($beneficiary_ids)) $q->filterByBeneficiaryId($beneficiary_ids);
55 #if (isset($state_mask)) $q->useOrderStateQuery()->addSelectQuery($latest_state, 'latestState')->where("order_id=latestState.order_id")->where("state & $state_mask")->endUse();
56 if (isset($state_mask)) $q->filterById($order_ids);
57 $orders = $q->orderByDate()->find();
59 foreach ($orders as $order) {
60 echo "<br>\nOrder " . $order->getStrongLink($order->getId()) . ": " . get_order_displayname($order);
62 echo " " . $order->getDeleteLink();
65 /* XXX: Should pull from query. */
66 $q = new ContactQuery;
67 $contact = $q->findOneById($order->getBeneficiaryId());
69 echo " for " . $contact->getLink();
70 $area = get_contact_area($contact);
71 if ($area) echo " in " . $area->getLink();
74 if ($order->getHubId()) {
76 $hub = $q->findOneById($order->getHubId());
77 if ($hub) echo " to hub " . $hub->getLink();
78 $area = get_hub_area($hub);
79 if ($area) echo " in " . $area->getLink();
86 function show_city_orders($offset, $per_page, $city_name, $city_id = null, $state_mask = null) {
87 if (isset($city_id)) $city = get_city_by_id($city_id);
88 else if ($city_name) $city = get_city_by_name($city_name);
90 $contacts = get_city_contacts($city->getId(), $GLOBALS['ROLE_BENEFICIARY']);
91 $beneficiary_ids = array();
92 foreach ($contacts as $contact) $beneficiary_ids[] = $contact->getId();
94 echo "<p>Orders in city " . $city->getLink(get_city_displayname($city)) . ":";
95 return show_orders($offset, $per_page, null, $beneficiary_ids, $state_mask);
97 else echo "<p>No such city!</p>\n";
100 function show_requester_orders($offset, $per_page, $contact_name, $contact_id = null, $state_mask = null) {
101 if (isset($contact_id)) $contact = get_contact_by_id($contact_id);
102 else if ($contact_name) $contact = get_contact_by_name($contact_name);
104 echo "<p>Orders from referrer " . $contact->getLink() . ":";
105 return show_orders($offset, $per_page, $contact->getId(), null, $state_mask);
107 else echo "<p>No such contact!</p>\n";
110 function show_beneficiary_orders($offset, $per_page, $contact_name, $contact_id = null, $state_mask = null) {
111 if (isset($contact_id)) $contact = get_contact_by_id($contact_id);
112 else if ($contact_name) $contact = get_contact_by_name($contact_name);
114 echo "<p>Orders to beneficiary " . $contact->getLink() . ":";
115 return show_orders($offset, $per_page, null, $contact->getId(), $state_mask);
117 else echo "<p>No such contact!</p>\n";
120 function show_area_orders($offset, $per_page, $area_name, $area_id = null, $state_mask = null) {
121 if (isset($area_id)) $area = get_area_by_id($area_id);
122 else if ($area_name) $area = get_area_by_name($area_name);
124 $contacts = get_area_contacts($area->getId(), $GLOBALS['ROLE_BENEFICIARY']);
125 $contact_ids = array();
126 foreach ($contacts as $contact) $contact_ids[] = $contact->getId();
128 echo "<p>Orders in area " . $area->getLink() . ":";
129 return show_orders($offset, $per_page, null, $contact_ids, $state_mask);
131 else echo "<p>No such area!</p>\n";
134 function show_order_state_form($state_mask = null) {
135 global $states, $all_states;
137 if (is_null($state_mask)) $state_mask = $all_states;
139 echo "<p>Restrict to order states:\n";
140 for ($i = 0; $i < count($states); $i++) {
141 echo " <input type=\"checkbox\" name=\"state_$i\"";
142 if ($state_mask & (1 << $i)) echo " checked";
143 echo ">$states[$i]\n";
148 function get_order_state_mask($string = null) {
149 global $states, $all_states;
153 if (isset($string)) {
154 $selected = explode("+", $string);
155 for ($i = 0; $i < count($states); $i++) {
156 if (in_array($states[$i], $selected)) $mask |= (1 << $i);
160 for ($i = 0; $i < count($states); $i++) {
161 if ($_POST['state_' . $i] == "on") $mask |= (1 << $i);
165 if (! $mask) $mask = $all_states;
169 function get_order_state_string($mask) {
174 for ($i = 0; $i < count($states); $i++) {
175 if ($mask & (1 << $i)) $selected[] = $states[$i];
178 return implode("+", $selected);
181 function get_order_state_uri($mask) {
184 if (is_null($mask)) return "";
185 if ($mask == $all_states) return "";
187 return "/state/" . get_order_state_string($mask);
190 function show_order_areas_form($city_id = null) {
191 $areas = get_city_areas($city_id);
192 if (! count($areas)) {
193 echo "<p>No <a href=\"/area\">areas</a>!</p>\n";
197 echo "<p>Show orders in area\n";
198 echo "<select name=\"area_id\">\n";
199 foreach ($areas as $area) {
200 option("area_id", $area->getId(), get_area_displayname($area));
203 echo "<input type=\"submit\" name=\"show_in_area\" value=\"Show\">\n";
206 function show_order_cities_form($city_id = null) {
208 $cities = $q->orderByName()->find();
210 if (! count($cities)) {
211 echo "<p>No <a href=\"/city\">cities</a>!</p>\n";
215 echo "<p>Show orders in city\n";
216 echo "<select name=\"city_id\">\n";
217 foreach ($cities as $city) {
218 option("city_id", $city->getId(), get_city_displayname($city), $city_id);
221 echo "<input type=\"submit\" name=\"show_in_city\" value=\"Show\">\n";
224 function show_order_forms($city_id, $state_mask) {
225 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
226 show_order_state_form($state_mask);
227 show_order_areas_form($city_id);
228 show_order_cities_form($city_id);
232 function show_order_form($order = null, $area_id = null) {
236 $q = new OrderStateQuery;
237 $order_state = $q->filterByOrderId($order->getId())->orderByUpdated('desc')->limit(1)->findOne();
239 $state = $order_state->getState();
240 $driver_id = $order_state->getDriverId();
243 else $order = new Order;
248 echo " <td>Delivery</td>\n";
249 /* XXX: Find suitable dates from area. */
251 show_date_form("date", $order->getDate());
252 if (! $order->getDate()) {
253 echo " and recur for <select name=\"recurrence\">\n";
254 for ($i = 0; $i < 4; $i++) option("recurrence", $i, $i);
255 echo "</select> weeks";
262 echo " <td>Referrer</td>\n";
263 echo " <td><select name=\"requester_id\">\n";
264 option("requester_id", null, "");
265 $contacts = get_area_requesters();
266 foreach ($contacts as $contact) {
267 option("requester_id", $contact->getId(), $contact->getDisplayname(), $order->getRequesterId());
269 echo "</select></td>\n";
274 echo " <td>Beneficiary</td>\n";
275 echo " <td><select name=\"beneficiary_id\">\n";
276 option("beneficiary_id", null, "");
277 $contacts = get_area_beneficiaries($area_id);
278 foreach ($contacts as $contact) {
279 option("beneficiary_id", $contact->getId(), $contact->getDisplayname(), $order->getBeneficiaryId());
281 echo "</select></td>\n";
286 echo " <td>Hub</td>\n";
287 echo " <td><select name=\"hub_id\">\n";
288 option("hub_id", null, "");
289 $hubs = get_area_hubs();
290 foreach ($hubs as $hub) {
291 option("hub_id", $hub->getId(), $hub->getDisplayname(), $order->getHubId());
293 echo "</select></td>\n";
298 echo " <td>Quantity (kg)</td>\n";
299 echo " <td>"; input("quantity", sprintf("%0.2f", $order->getQuantity() / 1000)); echo "</td>\n";
304 echo " <td>Driver</td>\n";
305 $contacts = get_city_drivers();
306 if (count($contacts)) {
307 echo " <td><select name=\"driver_id\">\n";
308 option("driver_id", null, "");
309 foreach ($contacts as $contact) {
310 option("driver_id", $contact->getId(), $contact->getDisplayname(), $driver_id);
312 echo "</select></td>\n";
314 else echo " <td>No drivers!</td>\n";
318 if ($order->getId()) {
320 echo " <td>State</td>\n";
321 echo " <td><select name=\"state\">\n";
322 for ($i = 0; $i < count($states); $i++) {
323 option("state", $i << 1, ucfirst($states[$i]), $state);
325 echo "</select></td>\n";
330 function show_new_order_form($area_id = null) {
331 if (! check_admin(1)) return;
333 $area = get_area_by_id($area_id);
334 if (! count($area)) {
335 echo "<p>No such <a href=\"/area\">area</a>!</p>\n";
339 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
340 echo "<p>Place an order:</p>\n";
343 show_order_form(null, $area_id);
346 echo " <td colspan=2>"; submit("add_order", "Order"); echo "</td></tr>\n";
352 function show_add_new_order_form() {
353 if (! check_admin(1)) return;
355 /* We intentionally hide areas with no contacts. */
356 $areas = get_city_areas_with_contacts(null, $GLOBALS['ROLE_BENEFICIARY']);
357 if (! count($areas)) {
358 echo "<p>Can't place any orders until at least one <a href=\"/area\">area</a> has a <a href=\"/contact\">contact</a>!</p>\n";
362 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
363 echo "<p>Place an order in <select name=\"area_id\">\n";
364 foreach ($areas as $area) {
365 option("area_id", $area->getId(), get_area_displayname($area));
368 submit("show_add_order", "Proceed");
373 function update_order(&$order, $new = false) {
376 #$date = ymd_to_iso8601("date");
377 $date = $_POST['date'];
378 $requester_id = $_POST['requester_id'];
379 $beneficiary_id = $_POST['beneficiary_id'];
380 $hub_id = $_POST['hub_id'];
381 $quantity = $_POST['quantity'];
382 $driver_id = $_POST['driver_id'];
383 if (! $driver_id) $driver_id = null;
384 $state = $_POST['state'];
385 if (! $state) $state = $GLOBALS['STATE_PLACED'];
388 list($y, $m, $d) = explode('-', $date);
389 $then = mktime(0, 0, 0, $m, $d, $y);
392 /* XXX: check date */
394 $requester = get_contact_by_id($requester_id);
396 echo "<p>Invalid referrer!</p>\n";
400 $beneficiary = get_contact_by_id($beneficiary_id);
401 if (! $beneficiary) {
402 echo "<p>Invalid beneficiary!</p>\n";
407 $hub = get_hub_by_id($hub_id);
409 echo "<p>Invalid hub!</p>\n";
415 if (! is_numeric($quantity)) {
416 echo "<p>Invalid quantity!</p>\n";
420 if ($new && isset($_POST['recurrence'])) $recurrence = $_POST['recurrence'];
421 if (! $recurrence) $recurrence = 0;
424 for ($i = 0; $i <= $recurrence; $i++) {
426 echo "<p>Creating recurrence $i.</p>\n";
430 $order->setDate($then + 7 * 86400 * $i);
431 $order->setRequesterId($requester_id);
432 $order->setBeneficiaryId($beneficiary_id);
433 $order->setHubId($hub_id);
434 $order->setQuantity($quantity * 1000);
436 /* XXX: begin/commit */
440 $order_state = new OrderState;
441 $order_state->setUpdated($now);
442 $order_state->setOrderId($order->getId());
443 $order_state->setUserId($user_id);
444 $order_state->setDriverId($driver_id);
445 $order_state->setState($state);
447 $order_state->save();
449 catch (Exception $e) {
450 if ($new) echo "<p>Error placing order.</p>\n";
451 else echo "<p>Error updating order.</p>\n";
452 echo "<p>" . $e->getMessage() . "</p>\n";
460 function add_order() {
461 if (! check_admin(1, "place an order")) return;
464 if (! update_order($order, true)) return false;
465 return $order->getId();
468 function delete_order($id = null) {
469 if (! check_admin(1, "delete an order")) return;
471 if (isset($id)) $order = get_order_by_id($id);
472 if (! $order) return false;
475 $q = new OrderStateQuery;
476 $order_states = $q->filterByOrderId($id)->find();
477 foreach ($order_states as $order_state) $order_state->delete();
479 echo "<p>Deleted order.</p>\n";
481 catch (Exception $e) {
482 echo "<p>Error deleting order $id!</p>\n";
489 function show_order_history($id) {
492 $q = new OrderStateQuery();
493 $order_states = $q->filterByOrderId($id)->orderById()->find();
495 if (! count($order_states)) return;
497 echo "<h3>Order history</h3>\n";
498 foreach ($order_states as $order_state) {
499 $date = $order_state->getUpdated();
501 $user = get_contact_by_id($order_state->getUserId());
502 if ($user) $username = $user->getDisplayname();
503 else $username = "unknown user";
505 $driver_id = $order_state->getDriverId();
506 if ($driver_id) $driver = get_contact_by_id($driver_id);
510 $state = $order_state->getState();
511 for ($i = 0; $i < count($states); $i++) {
512 if ((1 << $i) == $state) {
513 $state = $states[$i];
517 #$state = $states[$order_state->getState()];
518 echo "<p><strong>$username</strong> changed order to state <strong>$state</strong>";
519 if ($driver) echo " for driver " . $driver->getDisplayname();
520 echo " on $date.</p>\n";
524 function show_order(&$id = null) {
525 if (isset($id)) $order = get_order_by_id($id);
526 if (! $order) return;
528 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
529 echo "<p>Order: <span class=\"strong\">" . $order->getId() . "</span>";
530 if (check_admin(1)) {
531 echo " " . $order->getDeleteLink();
537 show_order_form($order);
539 if (check_admin(1)) {
541 echo " <td colspan=2>";
542 submit("update_order", "Update");
550 show_order_history($order->getId());
554 if (count($parameters)) {
555 for ($i = 1; $i < count($parameters); $i++) {
556 if ($parameters[$i] == "state") {
557 /* /order/state/placed+picked */
558 $state_mask = get_order_state_mask($parameters[$i + 1]);
562 if ($parameters[0] == "in") {
563 /* /order/in/area/Romsey+Town/1 */
564 switch ($parameters[1]) {
567 $area_id = $parameters[3];
568 $_POST['area_id'] = $area_id;
570 $area = $q->findOneById($area_id);
571 $city = get_area_city($area);
572 if ($city) $city_id = $city->getId();
573 show_area_orders(0, 10, $parameters[2], $area_id, $state_mask);
577 $city_id = $parameters[3];
578 $_POST['city_id'] = $city_id;
580 $city = $q->findOneById($city_id);
581 show_city_orders(0, 10, $parameters[2], $city_id, $state_mask);
585 else if ($parameters[0] == "from") {
586 /* /order/from/referrer/Iain+Patterson/4 */
587 switch ($parameters[1]) {
589 $contact_id = $parameters[3];
590 $q = new ContactQuery;
591 $contact = $q->findOneById($contact_id);
592 show_requester_orders(0, 10, $parameters[2], $contact_id, $state_mask);
596 else if ($parameters[0] == "to") {
597 /* /order/to/beneficiary/Cambridge+Community+Church/1 */
598 switch ($parameters[1]) {
600 $contact_id = $parameters[3];
601 $q = new ContactQuery;
602 $hub = $q->findOneById($contact_id);
603 show_beneficiary_orders(0, 10, $parameters[2], $contact_id, $state_mask);
608 list($ignored, $id, $args) = parse_parameters($parameters);
609 //echo "<p>$name($id) " . print_r($args, true) . "</p>\n";
617 else if (isset($id)) show_order($id);
618 else if ($state_mask) show_orders(0, 10, null, null, $state_mask);
620 /* XXX: Shown after adding. */
621 show_order_forms($city_id, $state_mask);
622 show_add_new_order_form($city_id);
625 if (count($parameters)) {
626 show_order_forms($city_id, $state_mask);