public static function retrieveOrderSummaryForUser($db, $user_id, $params = array())
{
$orderArray = array();
$select = $db->select();
$select->from('orders', '*')->where('buyer_id = ?', $user_id)->order('ts_created DESC');
//echo $select;
$idArray = $db->fetchAll($select);
foreach ($idArray as $k => $v) {
$select2 = $db->select();
$select2->from(array('o' => 'order_profile'), '*')->where('o.order_id = ?', $v['order_id'])->join(array('s' => 'order_profile_status_and_delivery'), 's.order_profile_id = o.order_profile_id');
$orderProfiles = $db->fetchAll($select2);
foreach ($orderProfiles as $key => $value) {
$select3 = $db->select();
$select3->from(array('pa' => 'order_profile_attribute'), '*')->where('pa.order_profile_attribute_id = ? ', $value['order_profile_attribute_id']);
$orderProfiles[$key]['attributes'] = $db->fetchAll($select3);
}
$orderArray[$v['order_unique_id']] = $orderProfiles;
$messageThreads = array();
foreach ($order->products as $k => $v) {
$MessageSelect = $db->select();
$MessageSelect->from('sender_message', '*')->where('sender_subject = ? ', 'orderID: ' . $order->order_unique_id)->where('product_id = ?', $v['product_id'])->where('product_type_seller = ?', $v['product_market'])->order('ts_created DESC');
//echo $MessageSelect.'<br />';
$productMessageThreads = $db->fetchAll($MessageSelect);
if (count($productMessageThreads) > 0) {
$order->products[$k]['messageThreads'] = $productMessageThreads;
//Zend_Debug::dump($v['messageThreads']);
}
}
$order = new DatabaseObject_Order($db);
$order->load($v['order_id']);
$order->loadOrderProducts();
$orderArray[] = $order;
//Zend_Debug::dump($order->products);
}
return $orderArray;
}
