-function get_sales_delivery($trans_no)
-{
- $sql = "SELECT ".TB_PREF."debtor_trans.*, cust_branch.*,
- ".TB_PREF."debtors_master.name,
- ".TB_PREF."debtors_master.curr_code,
- ".TB_PREF."debtors_master.payment_terms,
- ".TB_PREF."debtors_master.discount,
- ".TB_PREF."sales_types.sales_type,
- ".TB_PREF."shippers.shipper_name,
- ".TB_PREF."tax_groups.name AS tax_group_name ,
- ".TB_PREF."tax_groups.id AS tax_group_id
- FROM ".TB_PREF."debtor_trans,
- ".TB_PREF."debtors_master,
- ".TB_PREF."sales_types,
- ".TB_PREF."tax_groups,
- ".TB_PREF."cust_branch,
- ".TB_PREF."shippers
- WHERE ".TB_PREF."debtor_trans.type=13
- AND ".TB_PREF."debtor_trans.tpe=".TB_PREF."sales_types.id
- AND ".TB_PREF."cust_branch.branch_code = ".TB_PREF."debtor_trans.branch_code
- AND ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
- AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."shippers.shipper_id = ".TB_PREF."debtor_trans.ship_via
- AND ".TB_PREF."debtor_trans.trans_no = ";
-
- if(is_array($trans_no)) { //assume all transactions are for the same customer/branch
- $sql .= $trans_no[0];
- } else {
- $sql .= $trans_no;
- }
-
- $result = db_query($sql, "delivery Retreival");
-
- $num = db_num_rows($result);
- if ($num > 1)
- {
- display_db_error("FATAL : delivery note query returned a duplicate - " . db_num_rows($result), $sql, true);
- }
- else if ($num == 1)
- {
- return db_fetch($result);
- }
- else
- display_db_error("FATAL : delivery note search return nothing - " . db_num_rows($result), $sql, true);
-
-}
-
-//function get_sales_delivery_details($delivery) {
-// if(!is_array($delivery)) {
-//
-// }
-//}
-//--------------------------------------------------------------------------------------------------
-
-function read_sales_delivery($trans_no, &$cart)
-{
- $myrow = get_sales_delivery($trans_no);
-
- if(!is_array($trans_no)) $trans_no = array($trans_no);
-
- $cart->customer_id = $myrow["debtor_no"];
- $cart->Branch = $myrow["branch_code"];
- $cart->customer_name = $myrow["name"];
- $cart->cust_ref = $myrow["reference"];
- $cart->default_sales_type =$myrow["tpe"];
- $cart->sales_type_name =$myrow["sales_type"];
- $cart->customer_currency = $myrow["curr_code"];
- $cart->default_discount = $myrow["discount"];
- $cart->order_no = $myrow["order_"];
-
-// $cart->Comments = get_comments(13,$trans_no);
-
- $cart->ship_via = $myrow["ship_via"];
- $cart->deliver_to = $myrow["br_name"];
- $cart->delivery_date = sql2date($myrow["due_date"]);
- $cart->freight_cost = $myrow["ov_freight"];
- $cart->delivery_address = $myrow["br_address"];
- $cart->phone = $myrow["phone"];
- $cart->email = $myrow["email"];
-
-// $cart->Location = $myrow["location"];
-// $cart->location_name = $myrow["location_name"];
-
- $cart->orig_order_date = sql2date($myrow["tran_date"]);
-
- $cart->tax_group_name = $myrow["tax_group_name"];
- $cart->tax_group_id = $myrow["tax_group_id"];
-
- $sql = "SELECT ".TB_PREF."debtor_trans_details.stock_id, unit_price,
- debtor_trans_no,
- ".TB_PREF."debtor_trans_details.description,
- ".TB_PREF."debtor_trans_details.id,
- ".TB_PREF."debtor_trans_details.quantity, discount_percent,
- qty_done, ".TB_PREF."stock_master.units,
- ".TB_PREF."stock_master.material_cost + ".TB_PREF."stock_master.labour_cost + ".TB_PREF."stock_master.overhead_cost AS standard_cost
- FROM ".TB_PREF."debtor_trans_details, ".TB_PREF."stock_master
- WHERE ".TB_PREF."debtor_trans_details.debtor_trans_type=13 AND
- " .TB_PREF."debtor_trans_details.stock_id = ".TB_PREF."stock_master.stock_id";
-
- $sql .= ' AND (';
- foreach($trans_no as $key=>$num) {
- if($key!=0) $sql .= ' OR ';
- $sql .= 'debtor_trans_no =' . $num;
- }
- $sql .= ') ORDER BY id';
-
- $result = db_query($sql, "Retreive Delivery Note Items");
-
- if (db_num_rows($result) > 0)
- {
-
- while ($myrow = db_fetch($result))
- {
- $cart->add_to_cart($myrow["stock_id"],-$myrow["quantity"],
- $myrow["unit_price"], $myrow["discount_percent"],
- -$myrow["qty_done"], $myrow["standard_cost"], $myrow["description"],$myrow["id"]);
- }
- }