Removed sparse fields contact_name,disable_trans from cust_branch, added branch bank...
[fa-stable.git] / sales / includes / db / branches_db.inc
index c0da80db44ed68949447e34e9e3328e521afc3ee..52c41a786ca8ef51ffd77e07471247897432fe6b 100644 (file)
 ***********************************************************************/
 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) . ",
@@ -253,4 +251,3 @@ function _get_branch_contacts($branch_code, $action=null, $customer_id=null, $de
        return $results;
 }
 
-?>
\ No newline at end of file