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);
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 sprintf("%0.2fkg on %s", $order->getQuantity() / 1000, $order->getDate());
+ return sprintf("<span class=\"small\">%s</span> 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 = "<strong>" . ucfirst(get_order_state_string($order_state)) . "</strong> 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) {
return $q->findOneById($address->getAreaId());
}
+ function get_address_map_link($address) {
+ $postcode = trim($address->getPostcode());
+ if ($postcode) {
+ return " " . get_small_link("Map", "http://maps.google.co.uk/maps?q=" . urlencode($postcode));
+ }
+ }
+
function get_contact_address($contact) {
$q = new AddressQuery;
return $q->findOneById($contact->getAddressId());
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);
}
function show_date_form($name, $date = null) {
+ $past = 60;
+ $future = 60;
echo "<select name=\"$name\">\n";
- $now = time();
+ $now = date('Y-m-d', time());
+ list($y, $m, $d) = explode('-', $now);
+ $today = mktime(0, 0, 0, $m, $d, $y);
if (isset($date)) {
list($y, $m, $d) = explode('-', $date);
$then = mktime(0, 0, 0, $m, $d, $y);
- option($name, $date, date('l j F Y', $then), $date);
+ if ($then < $today - 86400 * $past || $then > $today + 86400 * $future) {
+ option($name, $date, date('l j F Y', $then), $date);
+ }
}
- for ($i = 0; $i < 60; $i++) {
- $then = $now + 86400 * $i;
+ else $date = $now;
+ for ($i = -$past; $i < $future; $i++) {
+ $then = $today + 86400 * $i;
option($name, date('Y-m-d', $then), date('l j F Y', $then), $date);
}
echo "</select>\n";
echo "Day: <input name=\"$name" . "_d\" value=\"$d\" size=2 maxlen=2> ";
}
+ function validate_postcode($postcode, &$outward = null, &$inward = null) {
+ /*
+ Valid postcode formats (BS766):
+
+ AN NLL
+ ABN NLL
+ ANN NLL
+ ABNN NLL
+ ABND NLL
+ ANC NLL
+
+ Where N is a number; A is a letter not including Q, V, X;
+ B is a letter not including I, J, Z; C is a letter from the set
+ ABCDEFGHJKSTUW; D is a letter from the set ABEHMNPRVWXY;
+ L is a letter from the set ABDEFGHJLNPQRSTUWXYZ.
+
+ The postcode GIR 0AA is also valid.
+ */
+ $outward = $inward = null;
+
+ /* Treat blank as valid for convenience. */
+ $postcode = trim($postcode);
+ if (! $postcode) return true;
+
+ $A = '[ABCDEFGHIJKLMNOPRSTUWYZ]';
+ $B = '[ABCDEFGHKLMNOPQRSTUVWXY]';
+ $C = '[ABCDEFGHJKSTUW]';
+ $D = '[ABEHMNPRVWXY]';
+ $L = '[ABDEFGHJLNPQRSTUWXYZ]';
+ $N = '\d';
+ if (! preg_match("/^($A$N|$A$B$N|$A$N$N|$A$B$N$N|$A$B$N$D|$A$N$C|GIR)\s*($N$L$L)$/", $postcode, $m)) return false;
+ if ($m[1] == "GIR" && $m[2] != "0AA") return false;
+ list($ignored, $outward, $inward) = $m;
+ return true;
+ }
+
+ function format_postcode($postcode, $complain = true) {
+ if (validate_postcode($postcode, $outward, $inward)) {
+ return "$outward $inward";
+ }
+ if ($complain) {
+ echo "<p>Invalid postcode!</p>\n";
+ return null;
+ }
+ }
+
+ function get_small_link() {
+ /* Args are <alt text>, <format>, [<stuff> ...] */
+ $args = func_get_args();
+ $html = htmlspecialchars(array_shift($args));
+ $url = array_shift($args);
+ return vsprintf("<a class=\"small noprint\" href=\"$url\">$html</a>\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");