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