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) {
233 global $states, $parcel_sizes, $parcel_contents;
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 if (! $order->getId() && $order->getBeneficiaryId()) {
278 $contact = get_contact_by_id($order->getBeneficiaryId());
279 if ($contact) option("beneficiary_id", $order->getBeneficiaryId(), $contact->getDisplayname(), $order->getBeneficiaryId());
282 $contacts = get_area_beneficiaries($area_id);
283 foreach ($contacts as $contact) {
284 option("beneficiary_id", $contact->getId(), $contact->getDisplayname(), $order->getBeneficiaryId());
287 echo "</select></td>\n";
292 echo " <td>Hub</td>\n";
293 echo " <td><select name=\"hub_id\">\n";
294 option("hub_id", null, "");
295 $hubs = get_area_hubs();
296 foreach ($hubs as $hub) {
297 option("hub_id", $hub->getId(), $hub->getDisplayname(), $order->getHubId());
299 echo "</select></td>\n";
304 echo " <td>Parcel size</td>\n";
305 echo " <td><select name=\"parcel_size\">\n";
306 $mask = 1 << count($parcel_sizes);
307 for ($i = 0; $i < count($parcel_sizes); $i++) {
308 option("parcel_size", 1 << $i, $parcel_sizes[$i], $order->getParcel() % $mask);
310 echo "</select></td>\n";
313 /* Parcel contents. */
315 echo " <td>Parcel contents</td>\n";
317 for ($i = count($parcel_sizes); $i < count($parcel_contents); $i++) {
318 echo " <input type=\"checkbox\" name=\"parcel_$i\"";
319 if ($order->getParcel() & (1 << $i)) echo " checked";
320 echo ">$parcel_contents[$i]\n";
327 echo " <td>Driver</td>\n";
328 $contacts = get_city_drivers();
329 if (count($contacts)) {
330 echo " <td><select name=\"driver_id\">\n";
331 option("driver_id", null, "");
332 foreach ($contacts as $contact) {
333 option("driver_id", $contact->getId(), $contact->getDisplayname(), $driver_id);
335 echo "</select></td>\n";
337 else echo " <td>No drivers!</td>\n";
341 if ($order->getId()) {
343 echo " <td>State</td>\n";
344 echo " <td><select name=\"state\">\n";
345 for ($i = 0; $i < count($states); $i++) {
346 option("state", $i << 1, ucfirst($states[$i]), $state);
348 echo "</select></td>\n";
353 function show_new_order_form($area_id = null) {
354 if (! check_admin(1)) return;
356 $area = get_area_by_id($area_id);
357 if (! count($area)) {
358 echo "<p>No such <a href=\"/area\">area</a>!</p>\n";
362 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
363 echo "<p>Place an order:</p>\n";
366 show_order_form(null, $area_id);
369 echo " <td colspan=2>"; submit("add_order", "Order"); echo "</td></tr>\n";
375 function show_contact_order_form($contact) {
376 if (! check_admin(1)) return;
378 $area = get_contact_area($contact);
380 echo "<p>No valid <a href=\"/area\">area</a> for contact!</p>\n";
385 $order->setBeneficiaryId($contact->getId());
387 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
388 echo "<p>Placing order for " . $contact->getStrongLink() . ".";
389 $parcel = $contact->getParcel();
391 echo " Suggested parcel type is <span class=\"strong\">" . get_contact_parcel_string($contact) . "</span>";
392 $order->setParcel($parcel);
397 show_order_form($order, $area_id);
400 echo " <td colspan=2>"; submit("add_order", "Order"); echo "</td></tr>\n";
406 function show_add_new_order_form() {
407 if (! check_admin(1)) return;
409 /* We intentionally hide areas with no contacts. */
410 $areas = get_city_areas_with_contacts(null, $GLOBALS['ROLE_BENEFICIARY']);
411 if (! count($areas)) {
412 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";
416 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
417 echo "<p>Place an order in <select name=\"area_id\">\n";
418 foreach ($areas as $area) {
419 option("area_id", $area->getId(), get_area_displayname($area));
422 submit("show_add_order", "Proceed");
427 function update_order(&$order, $new = false) {
428 global $user_id, $parcel_sizes, $parcel_contents;
430 #$date = ymd_to_iso8601("date");
431 $date = $_POST['date'];
432 $requester_id = $_POST['requester_id'];
433 $beneficiary_id = $_POST['beneficiary_id'];
434 $hub_id = $_POST['hub_id'];
435 $quantity = $_POST['quantity'];
436 $driver_id = $_POST['driver_id'];
437 if (! $driver_id) $driver_id = null;
438 $state = $_POST['state'];
439 if (! $state) $state = $GLOBALS['STATE_PLACED'];
440 $parcel = $_POST['parcel_size'];
441 for ($i = count($parcel_sizes); $i < count($parcel_contents); $i++) {
442 if ($_POST['parcel_' . $i] == "on") $parcel |= (1 << $i);
446 list($y, $m, $d) = explode('-', $date);
447 $then = mktime(0, 0, 0, $m, $d, $y);
450 /* XXX: check date */
452 $requester = get_contact_by_id($requester_id);
454 echo "<p>Invalid referrer!</p>\n";
458 $beneficiary = get_contact_by_id($beneficiary_id);
459 if (! $beneficiary) {
460 echo "<p>Invalid beneficiary!</p>\n";
465 $hub = get_hub_by_id($hub_id);
467 echo "<p>Invalid hub!</p>\n";
473 if (! is_numeric($quantity)) {
474 echo "<p>Invalid quantity!</p>\n";
478 if ($new && isset($_POST['recurrence'])) $recurrence = $_POST['recurrence'];
479 if (! $recurrence) $recurrence = 0;
482 for ($i = 0; $i <= $recurrence; $i++) {
484 echo "<p>Creating recurrence $i.</p>\n";
488 $order->setDate($then + 7 * 86400 * $i);
489 $order->setRequesterId($requester_id);
490 $order->setBeneficiaryId($beneficiary_id);
491 $order->setHubId($hub_id);
492 $order->setParcel($parcel);
494 /* XXX: begin/commit */
498 $order_state = new OrderState;
499 $order_state->setUpdated($now);
500 $order_state->setOrderId($order->getId());
501 $order_state->setUserId($user_id);
502 $order_state->setDriverId($driver_id);
503 $order_state->setState($state);
505 $order_state->save();
507 catch (Exception $e) {
508 if ($new) echo "<p>Error placing order.</p>\n";
509 else echo "<p>Error updating order.</p>\n";
510 echo "<p>" . $e->getMessage() . "</p>\n";
518 function add_order() {
519 if (! check_admin(1, "place an order")) return;
522 if (! update_order($order, true)) return false;
523 return $order->getId();
526 function delete_order($id = null) {
527 if (! check_admin(1, "delete an order")) return;
529 if (isset($id)) $order = get_order_by_id($id);
530 if (! $order) return false;
533 $q = new OrderStateQuery;
534 $order_states = $q->filterByOrderId($id)->find();
535 foreach ($order_states as $order_state) $order_state->delete();
537 echo "<p>Deleted order.</p>\n";
539 catch (Exception $e) {
540 echo "<p>Error deleting order $id!</p>\n";
547 function show_order_history($id) {
550 $q = new OrderStateQuery();
551 $order_states = $q->filterByOrderId($id)->orderById()->find();
553 if (! count($order_states)) return;
555 echo "<h3>Order history</h3>\n";
556 foreach ($order_states as $order_state) {
557 $date = $order_state->getUpdated();
559 $user = get_contact_by_id($order_state->getUserId());
560 if ($user) $username = $user->getDisplayname();
561 else $username = "unknown user";
563 $driver_id = $order_state->getDriverId();
564 if ($driver_id) $driver = get_contact_by_id($driver_id);
568 $state = $order_state->getState();
569 for ($i = 0; $i < count($states); $i++) {
570 if ((1 << $i) == $state) {
571 $state = $states[$i];
575 #$state = $states[$order_state->getState()];
576 echo "<p><strong>$username</strong> changed order to state <strong>$state</strong>";
577 if ($driver) echo " for driver " . $driver->getDisplayname();
578 echo " on $date.</p>\n";
582 function show_order(&$id = null) {
583 if (isset($id)) $order = get_order_by_id($id);
584 if (! $order) return;
586 echo "<form method=\"POST\" action=\"" . $_SERVER['REQUEST_URI'] . "\">\n";
587 echo "<p>Order: <span class=\"strong\">" . $order->getId() . "</span>";
588 if (check_admin(1)) {
589 echo " " . $order->getDeleteLink();
595 show_order_form($order);
597 if (check_admin(1)) {
599 echo " <td colspan=2>";
600 submit("update_order", "Update");
608 show_order_history($order->getId());
612 if (count($parameters)) {
613 for ($i = 1; $i < count($parameters); $i++) {
614 if ($parameters[$i] == "state") {
615 /* /order/state/placed+picked */
616 $state_mask = get_order_state_mask($parameters[$i + 1]);
620 if ($parameters[0] == "in") {
621 /* /order/in/area/Romsey+Town/1 */
622 switch ($parameters[1]) {
625 $area_id = $parameters[3];
626 $_POST['area_id'] = $area_id;
628 $area = $q->findOneById($area_id);
629 $city = get_area_city($area);
630 if ($city) $city_id = $city->getId();
631 show_area_orders(0, 10, $parameters[2], $area_id, $state_mask);
635 $city_id = $parameters[3];
636 $_POST['city_id'] = $city_id;
638 $city = $q->findOneById($city_id);
639 show_city_orders(0, 10, $parameters[2], $city_id, $state_mask);
643 else if ($parameters[0] == "from") {
644 /* /order/from/referrer/Iain+Patterson/4 */
645 switch ($parameters[1]) {
647 $contact_id = $parameters[3];
648 $q = new ContactQuery;
649 $contact = $q->findOneById($contact_id);
650 show_requester_orders(0, 10, $parameters[2], $contact_id, $state_mask);
654 else if ($parameters[0] == "to") {
655 /* /order/to/beneficiary/Cambridge+Community+Church/1 */
656 switch ($parameters[1]) {
658 $contact_id = $parameters[3];
659 $q = new ContactQuery;
660 $hub = $q->findOneById($contact_id);
661 show_beneficiary_orders(0, 10, $parameters[2], $contact_id, $state_mask);
665 else if ($parameters[0] == "place") {
666 if ($parameters[1] == "for") {
667 if ($parameters[2] == "beneficiary") {
668 if ($parameters[4]) $contact = get_contact_by_id($parameters[4]);
669 if (! $contact) $contact = get_contact_by_name(urldecode($parameters[3]));
670 if ($contact) show_contact_order_form($contact);
675 list($ignored, $id, $args) = parse_parameters($parameters);
676 //echo "<p>$name($id) " . print_r($args, true) . "</p>\n";
684 else if (isset($id)) show_order($id);
685 else if ($state_mask) show_orders(0, 10, null, null, $state_mask);
687 /* XXX: Shown after adding. */
688 show_order_forms($city_id, $state_mask);
689 show_add_new_order_form($city_id);
692 if (count($parameters)) {
693 show_order_forms($city_id, $state_mask);