X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=lib%2Ffunctions.php;h=2b35663b66097a8c6613d996943c333abed052e0;hb=7840fb6e5f99fcc6c9b25e05c6f40d73137f6d79;hp=b019e93f62caf3b058034aa5907387a01ceac65e;hpb=6fdbfe32798452ec1c0fdbda57edabb892518409;p=readifood.git diff --git a/lib/functions.php b/lib/functions.php index b019e93..2b35663 100644 --- a/lib/functions.php +++ b/lib/functions.php @@ -175,6 +175,37 @@ return $order; } + function get_order_ids_by_state($state_mask) { + $order_ids = array(); + $dbh = Propel::getConnection(); + $sth = $dbh->prepare("select * from OrderState o where updated=(select max(updated) from OrderState where order_id=o.order_id) and state & $state_mask"); + $sth->execute(); + $order_states = OrderStatePeer::populateObjects($sth); + foreach ($order_states as $order_state) $order_ids[] = $order_state->getOrderId(); + return $order_ids; + } + + function get_beneficiary_orders($contact, $state_mask = null) { + $q = new OrderQuery; + $q->filterByBeneficiaryId($contact->getId()); + if ($state_mask) $q->filterById(get_order_ids_by_state($state_mask)); + return $q->orderByDate()->find(); + } + + function get_requester_orders($contact, $state_mask = null) { + $q = new OrderQuery; + $q->filterByRequesterId($contact->getId()); + if ($state_mask) $q->filterById(get_order_ids_by_state($state_mask)); + return $q->orderByDate()->find(); + } + + function get_contact_orders($contact, $state_mask = null) { + $q = new OrderQuery; + $q->filterByBeneficiaryId($contact->getId())->_or()->filterByRequesterId($contact->getId()); + if ($state_mask) $q->filterById(get_order_ids_by_state($state_mask)); + return $q->orderByDate()->find(); + } + function get_user_by_contact_id($id, $verbose = true) { $q = new UserQuery; $user = $q->findOneByContactId($id); @@ -196,11 +227,86 @@ } function get_donation_displayname($donation) { - return $donation->getQuantity() . "kg on " . $donation->getDate(); + return sprintf("%0.2fkg on %s", $donation->getQuantity() / 1000, $donation->getDate()); + } + + function get_order_parcel_string($order) { + global $parcel_sizes, $parcel_contents; + + $parcel_size = null; + for ($i = 0 ; $i < count($parcel_sizes); $i++) { + if ($order->getParcel() & (1 << $i)) { + $parcel_size = $parcel_sizes[$i]; + break; + } + } + + $selected = array(); + for ($i = count($parcel_sizes); $i < count($parcel_contents); $i++) { + if ($order->getParcel() & (1 << $i)) $selected[] = $parcel_contents[$i]; + } + + $ret = implode(": ", array($parcel_size, implode(", ", $selected))); + $ret = preg_replace('/^: /', '', $ret); + $ret = preg_replace('/: $/', '', $ret); + + return $ret; } function get_order_displayname($order) { - return $order->getQuantity() . "kg on " . $order->getDate(); + return sprintf("%s on %s", get_order_parcel_string($order), $order->getDate()); + } + + function get_order_state_string($order_state = null) { + global $states; + + if (is_null($order_state)) return null; + + for ($i = 0; $i < count($states); $i++) { + if ($order_state->getState() & (1 << $i)) { + return $states[$i]; + } + } + + return "unknown"; + } + + function get_order_state($order) { + $q = new OrderStateQuery(); + return $q->filterByOrderId($order->getId())->orderByUpdated('desc')->findOne(); + } + + function get_order_summary($order) { + $ret = "Order " . $order->getStrongLink($order->getId()) . ": " . get_order_displayname($order); + + if (check_admin(1)) $ret .= " " . $order->getDeleteLink(); + + /* XXX: Should pull from query. */ + $q = new ContactQuery; + $contact = $q->findOneById($order->getRequesterId()); + if ($contact) { + $ret .= " referred by " . $contact->getLink(); + $area = get_contact_area($contact); + if ($area) $ret .= " in " . $area->getLink(); + } + + $q = new ContactQuery; + $contact = $q->findOneById($order->getBeneficiaryId()); + if ($contact) { + $ret .= " for " . $contact->getLink(); + $area = get_contact_area($contact); + if ($area) $ret .= " in " . $area->getLink(); + } + + if ($order->getHubId()) { + $q = new HubQuery; + $hub = $q->findOneById($order->getHubId()); + if ($hub) $ret .= " to hub " . $hub->getLink(); + $area = get_hub_area($hub); + if ($area) $ret .= " in " . $area->getLink(); + } + + return $ret; } function get_address_area($address) { @@ -227,6 +333,11 @@ return get_area_city($area); } + /* Parcel strings are the same so this can work. */ + function get_contact_parcel_string($contact) { + return get_order_parcel_string($contact); + } + /* Hub and Contact are similar enough that this can work. */ function get_hub_address($hub) { return get_contact_address($hub); @@ -285,10 +396,8 @@ return get_city_contacts($city_id, $GLOBALS['ROLE_DRIVER']); } - function get_contact_role_string($contact) { - global $roles; - - $role = $contact->getRole(); + function get_role_string($object, $roles) { + $role = $object->getRole(); $selected = array(); @@ -299,6 +408,22 @@ return implode(", ", $selected); } + function get_contact_role_string($contact) { + return get_role_string($contact, $GLOBALS['contact_roles']); + } + + function get_hub_role_string($hub) { + return get_role_string($hub, $GLOBALS['hub_roles']); + } + + function show_role_form($role, $roles) { + for ($i = 0; $i < count($roles); $i++) { + echo " $roles[$i]\n"; + } + } + function get_area_hubs($area_id = null) { $q = new HubQuery; if (isset($area_id)) $q->useAddressQuery()->filterByAreaId($area_id)->endUse(); @@ -351,15 +476,22 @@ } function show_date_form($name, $date = null) { + $past = 60; + $future = 60; echo "\n"; @@ -372,6 +504,18 @@ echo "Day: "; } + function get_small_link() { + /* Args are , , [ ...] */ + $args = func_get_args(); + $html = htmlspecialchars(array_shift($args)); + $url = array_shift($args); + return vsprintf("$html\n", $args); + } + + function small_link() { + echo call_user_func_array("get_small_link", func_get_args()); + } + include_once("$lib_root/admin.php"); include_once("$lib_root/forms.php");