X-Git-Url: http://git.iain.cx/?a=blobdiff_plain;f=lib%2Ffunctions.php;h=511e0cffea903ade8e8c7b0506f76efdbc4462dd;hb=87843f0ab772989647ce3116f2508b781f56f0b6;hp=801ed7806b61e1d0c29c80aed65ade172a0a074b;hpb=0fd77b357d1868a57756e91f9e71dfa3b3db26b8;p=readifood.git

diff --git a/lib/functions.php b/lib/functions.php
index 801ed78..511e0cf 100644
--- a/lib/functions.php
+++ b/lib/functions.php
@@ -175,6 +175,23 @@
     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_contact_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_user_by_contact_id($id, $verbose = true) {
     $q = new UserQuery;
     $user = $q->findOneByContactId($id);