+ $duedate = add_days($invdate, $myrow['days_before_due']);
+ return $duedate;
+}
+
+function get_customer_to_order($customer_id) {
+
+ // Now check to ensure this account is not on hold */
+ $sql = "SELECT cust.name,
+ cust.address, "
+ .TB_PREF."credit_status.dissallow_invoices,
+ cust.sales_type AS salestype,
+ cust.dimension_id,
+ cust.dimension2_id,
+ stype.sales_type,
+ stype.tax_included,
+ stype.factor,
+ cust.curr_code,
+ cust.discount,
+ cust.payment_terms,
+ cust.pymt_discount,
+ cust.credit_limit - Sum(IFNULL(IF(trans.type=11 OR trans.type=12 OR trans.type=2,
+ -1, 1) * (ov_amount + ov_gst + ov_freight + ov_freight_tax + ov_discount),0)) as cur_credit
+ FROM ".TB_PREF."debtors_master cust
+ LEFT JOIN ".TB_PREF."debtor_trans trans ON trans.type!=".ST_CUSTDELIVERY." AND trans.debtor_no = cust.debtor_no,"
+ .TB_PREF."credit_status, "
+ .TB_PREF."sales_types stype
+ WHERE cust.sales_type=stype.id
+ AND cust.credit_status=".TB_PREF."credit_status.id
+ AND cust.debtor_no = ".db_escape($customer_id)
+ ." GROUP by cust.debtor_no";
+
+ $result =db_query($sql,"Customer Record Retreive");
+ return db_fetch($result);
+}
+
+function get_branch_to_order($customer_id, $branch_id) {
+
+ // the branch was also selected from the customer selection so default the delivery details from the customer branches table cust_branch. The order process will ask for branch details later anyway
+ $sql = "SELECT ".TB_PREF."cust_branch.br_name, "
+ .TB_PREF."cust_branch.br_address, "
+ .TB_PREF."cust_branch.br_post_address, "
+ ." default_location, location_name, default_ship_via, "
+ .TB_PREF."tax_groups.name AS tax_group_name, "
+ .TB_PREF."tax_groups.id AS tax_group_id
+ FROM ".TB_PREF."cust_branch, "
+ .TB_PREF."tax_groups, "
+ .TB_PREF."locations
+ WHERE ".TB_PREF."cust_branch.tax_group_id = ".TB_PREF."tax_groups.id
+ AND ".TB_PREF."locations.loc_code=default_location
+ AND ".TB_PREF."cust_branch.branch_code=".db_escape($branch_id)."
+ AND ".TB_PREF."cust_branch.debtor_no = ".db_escape($customer_id);
+
+ return db_query($sql,"Customer Branch Record Retreive");