-
- clear_globals();
-
- $_SESSION['InvoiceToCredit'] = $_GET['InvoiceNumber'];
- $_SESSION['Items'] = new cart;
-
- /*read in all the guff from the selected invoice into the Items cart */
-
- // we need a distinct here so that it only returns 1 line - because there can be multiple moves
- // per item (for assemblies, etc)
- $sql = "SELECT DISTINCT ".TB_PREF."debtor_trans.*,
- ".TB_PREF."cust_branch.default_location, ".TB_PREF."cust_branch.default_ship_via,
- ".TB_PREF."debtors_master.name, ".TB_PREF."debtors_master.curr_code,
- ".TB_PREF."tax_groups.name AS tax_group_name, ".TB_PREF."tax_groups.id AS tax_group_id,
- ".TB_PREF."sales_orders.from_stk_loc
- FROM ".TB_PREF."debtor_trans, ".TB_PREF."debtors_master, ".TB_PREF."cust_branch, ".TB_PREF."tax_groups, ".TB_PREF."sales_orders
- WHERE ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."debtors_master.debtor_no
- AND ".TB_PREF."debtor_trans.branch_code = ".TB_PREF."cust_branch.branch_code
- AND ".TB_PREF."debtor_trans.debtor_no = ".TB_PREF."cust_branch.debtor_no
- AND ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
- AND ".TB_PREF."debtor_trans.trans_no = " . $_GET['InvoiceNumber'] . "
- AND ".TB_PREF."debtor_trans.type=10
- AND ".TB_PREF."sales_orders.order_no=".TB_PREF."debtor_trans.order_";
-
- $result = db_query($sql,"The invoice details cannot be retrieved");
-
- if (db_num_rows($result) == 1)
- {
-
- $myrow = db_fetch($result);
-
- $_SESSION['Items']->customer_id = $myrow["debtor_no"];
- $_SESSION['Items']->customer_name = $myrow["name"];
- $_SESSION['Items']->cust_ref = $myrow["reference"];
- $_SESSION['Items']->Branch = $myrow["branch_code"];
- $_SESSION['Items']->customer_currency = $myrow["curr_code"];
-
- $_SESSION['Items']->Comments = "";
- $_SESSION['Items']->default_sales_type =$myrow["tpe"];
- $_SESSION['Items']->Location = $myrow["from_stk_loc"];
-
- $_SESSION['Items']->tax_group_name = $myrow["tax_group_name"];
- $_SESSION['Items']->tax_group_id = $myrow["tax_group_id"];
-
- $_SESSION['Items']->delivery_date = sql2date($myrow["tran_date"]);
- $_SESSION['Items']->freight_cost = $myrow["ov_freight"];
-
- $_SESSION['Items']->ship_via = $myrow["default_ship_via"];
-
- $_SESSION['Order'] = $myrow["order_"];
-
- db_free_result($result);
-
- /*now populate the line items array with the detail records for the invoice*/
-
- $result = get_customer_trans_details(10, $_GET['InvoiceNumber']);
-
- if (db_num_rows($result) > 0)
- {
-
- while ($myrow = db_fetch($result))
- {
-
- $_SESSION['Items']->add_to_cart($myrow["stock_id"],-$myrow["quantity"],
- $myrow["FullUnitPrice"],$myrow["discount_percent"],$myrow["qty_done"],
- $myrow["standard_cost"],$myrow["description"],$myrow["id"]);
-
-