X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=lib%2Ffunctions.php;h=2b35663b66097a8c6613d996943c333abed052e0;hb=7840fb6e5f99fcc6c9b25e05c6f40d73137f6d79;hp=3727a65d5aa414e21a4271b920a7bb2e66c73d26;hpb=5f50c624101d671ec4147b3ad974c15178c6ebe5;p=readifood.git diff --git a/lib/functions.php b/lib/functions.php index 3727a65..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); @@ -202,7 +233,7 @@ function get_order_parcel_string($order) { global $parcel_sizes, $parcel_contents; - $parcel_size = ""; + $parcel_size = null; for ($i = 0 ; $i < count($parcel_sizes); $i++) { if ($order->getParcel() & (1 << $i)) { $parcel_size = $parcel_sizes[$i]; @@ -215,13 +246,69 @@ if ($order->getParcel() & (1 << $i)) $selected[] = $parcel_contents[$i]; } - return implode(": ", array($parcel_size, implode(", ", $selected))); + $ret = implode(": ", array($parcel_size, implode(", ", $selected))); + $ret = preg_replace('/^: /', '', $ret); + $ret = preg_replace('/: $/', '', $ret); + + return $ret; } function get_order_displayname($order) { 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) { $q = new AreaQuery; return $q->findOneById($address->getAreaId()); @@ -246,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); @@ -384,15 +476,22 @@ } function show_date_form($name, $date = null) { + $past = 60; + $future = 60; echo "\n"; @@ -405,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");