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) { } }