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 SalesOrderLine($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) { } }
public function initializeOrder($amount, $discount, $vat, $freight, $status) { $this->amount = $amount; $this->discount = $discount; $this->vat = $vat; $this->freightCost = $freight; $this->status = $status; $this->lineItems = SalesOrderLine::GetOrderItems($this->id); }