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