X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=lib%2Ffunctions.php;h=ec0b35ade4763feb1890792972f1f01166b1e107;hb=67672f1de588927289253f9b56270e5336aa537d;hp=801ed7806b61e1d0c29c80aed65ade172a0a074b;hpb=0fd77b357d1868a57756e91f9e71dfa3b3db26b8;p=readifood.git
diff --git a/lib/functions.php b/lib/functions.php
index 801ed78..ec0b35a 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,18 +246,109 @@
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_state = get_order_state($order);
+ if ($order_state) $ret = "" . ucfirst(get_order_state_string($order_state)) . " order ";
+ $ret .= $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());
}
+ function get_address_map_link($address) {
+ $postcode = trim($address->getPostcode());
+ if ($postcode) {
+ # mrt=loc specifies a location search.
+ $map = "maps.google.co.uk/maps?q=" . urlencode($postcode) . "&mrt=loc";
+ $url = "http://$map";
+ # output=embed allows display in an iframe.
+ # iwloc=near hides the popup window for the embedded view.
+ $embed = $GLOBALS['http'] . "://$map&output=embed&iwloc=near";
+ $html = " ";
+ $html .= get_small_link_with_id("map", "Map", $url);
+ $html .= "";
+ return $html;
+ }
+ }
+
function get_contact_address($contact) {
$q = new AddressQuery;
return $q->findOneById($contact->getAddressId());
@@ -331,9 +453,9 @@
function show_role_form($role, $roles) {
for ($i = 0; $i < count($roles); $i++) {
- echo " $roles[$i]\n";
+ echo ">\n";
}
}
@@ -389,32 +511,75 @@
}
function show_date_form($name, $date = null) {
- $past = 60;
- $future = 60;
- echo "\n";
- return;
- if (! isset($date)) $date = date('Y-m-d');
- list($y, $m, $d) = iso8601_to_ymd($date);
-
- echo "Year: ";
- echo "Month: ";
- echo "Day: ";
+ }
+
+ function get_small_link_with_id() {
+ /* Args are , , , [ ...] */
+ $args = func_get_args();
+ $id = array_shift($args);
+ if (isset($id)) $id = " id=\"$id\"";
+ $html = htmlspecialchars(array_shift($args));
+ $url = array_shift($args);
+ return vsprintf("$html\n", $args);
+ }
+
+ function get_small_link() {
+ /* Args are , , [ ...] */
+ $args = func_get_args();
+ array_unshift($args, null);
+ return call_user_func_array("get_small_link_with_id", $args);
+ }
+
+ function small_link() {
+ echo call_user_func_array("get_small_link", func_get_args());
}
include_once("$lib_root/admin.php");