X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fbranches_db.inc;h=52c41a786ca8ef51ffd77e07471247897432fe6b;hb=f5bfb4cdc5213e1eca9f5655e7c0442e8862bdb9;hp=09b1fbe4f28af171c013cd574c5bbc028b5bdf9c;hpb=0b63d898491b6577a5a5bf90e771dca0dcbbcf1f;p=fa-stable.git diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc index 09b1fbe4..52c41a78 100644 --- a/sales/includes/db/branches_db.inc +++ b/sales/includes/db/branches_db.inc @@ -11,13 +11,13 @@ ***********************************************************************/ function add_branch($customer_id, $br_name, $br_ref, $br_address, $salesman, $area, $tax_group_id, $sales_account, $sales_discount_account, $receivables_account, - $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no, + $payment_discount_account, $default_location, $br_post_address, $group_no, $default_ship_via, $notes, $bank_account) { $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, branch_ref, br_address, salesman, area, tax_group_id, sales_account, receivables_account, payment_discount_account, sales_discount_account, default_location, - br_post_address, disable_trans, group_no, default_ship_via, notes, bank_account) + br_post_address, group_no, default_ship_via, notes, bank_account) VALUES (".db_escape($customer_id). ",".db_escape($br_name) . ", " .db_escape($br_ref) . ", " .db_escape($br_address) . ", ".db_escape($salesman) . ", " @@ -29,7 +29,6 @@ function add_branch($customer_id, $br_name, $br_ref, $br_address, $salesman, $ar .db_escape($sales_discount_account) . ", " .db_escape($default_location) . ", " .db_escape($br_post_address) . "," - .db_escape($disable_trans) . ", " .db_escape($group_no) . ", " .db_escape($default_ship_via). ", " .db_escape($notes). ", " @@ -39,7 +38,7 @@ function add_branch($customer_id, $br_name, $br_ref, $br_address, $salesman, $ar function update_branch($customer_id, $branch_code, $br_name, $br_ref, $br_address, $salesman, $area, $tax_group_id, $sales_account, $sales_discount_account, $receivables_account, - $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no, + $payment_discount_account, $default_location, $br_post_address, $group_no, $default_ship_via, $notes, $bank_account) { $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = " . db_escape($br_name) . ", @@ -54,7 +53,6 @@ function update_branch($customer_id, $branch_code, $br_name, $br_ref, $br_addres payment_discount_account=".db_escape($payment_discount_account) . ", default_location=".db_escape($default_location) . ", br_post_address =".db_escape($br_post_address) . ", - disable_trans=".db_escape($disable_trans) . ", group_no=".db_escape($group_no) . ", default_ship_via=".db_escape($default_ship_via) . ", notes=".db_escape($notes) . ", @@ -139,7 +137,7 @@ function get_default_info_for_branch($customer_id) return db_fetch($result); } -function get_sql_for_customer_branches() +function get_sql_for_customer_branches($customer_id) { $sql = "SELECT " ."b.branch_code, " @@ -163,7 +161,7 @@ function get_sql_for_customer_branches() WHERE b.tax_group_id=t.id AND b.area=a.area_code AND b.salesman=s.salesman_code - AND b.debtor_no = ".db_escape($_POST['customer_id']); + AND b.debtor_no = ".db_escape($customer_id); if (!get_post('show_inactive')) $sql .= " AND !b.inactive"; $sql .= " GROUP BY b.branch_code ORDER BY branch_ref"; @@ -253,4 +251,3 @@ function _get_branch_contacts($branch_code, $action=null, $customer_id=null, $de return $results; } -?> \ No newline at end of file