示例#1
0
 public static function GetOrderItems($orderId)
 {
     //check whether available and make necessary inventory deductions, then
     $lineItems = array();
     try {
         $sql = 'SELECT * FROM purchase_order_items WHERE order_id = ' . $orderId . ' AND status = 1';
         $res = DatabaseHandler::GetAll($sql);
         foreach ($res as $item) {
             $lineItem = new PurchaseOrderLine($item['order_id'], $item['item_name'], $item['quantity'], $item['unit_price']);
             $lineItem->initId($item['id']);
             $lineItems[] = $lineItem;
         }
         return $lineItems;
     } catch (Exception $e) {
     }
 }