sales/includes/db/branches_db.inc

   1 <?php
   2 /**********************************************************************
   3     Copyright (C) FrontAccounting, LLC.
   4         Released under the terms of the GNU General Public License, GPL,
   5         as published by the Free Software Foundation, either version 3
   6         of the License, or (at your option) any later version.
   7     This program is distributed in the hope that it will be useful,
   8     but WITHOUT ANY WARRANTY; without even the implied warranty of
   9     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
  10     See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
  11 ***********************************************************************/
  12 function add_branch($customer_id, $br_name, $br_ref, $br_address, $phone, $phone2, $fax, $contact_name,
  13         $salesman, $area, $email, $tax_group_id, $sales_account, $sales_discount_account, $receivables_account,
  14         $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no,
  15         $default_ship_via, $notes, $rep_lang)
  16 {
  17         $sql = "INSERT INTO ".TB_PREF."cust_branch (debtor_no, br_name, branch_ref, br_address,
  18                 salesman, phone, phone2, fax,
  19                 contact_name, area, email, tax_group_id, sales_account, receivables_account, payment_discount_account, sales_discount_account, default_location,
  20                 br_post_address, disable_trans, group_no, default_ship_via, notes, rep_lang)
  21                 VALUES (".db_escape($customer_id). ",".db_escape($br_name) . ", "
  22                         .db_escape($br_ref) . ", "
  23                         .db_escape($br_address) . ", ".db_escape($salesman) . ", "
  24                         .db_escape($phone) . ", ".db_escape($phone2) . ", "
  25                         .db_escape($fax) . ","
  26                         .db_escape($contact_name) . ", ".db_escape($area) . ","
  27                         .db_escape($email) . ", ".db_escape($tax_group_id) . ", "
  28                         .db_escape($sales_account) . ", "
  29                         .db_escape($receivables_account) . ", "
  30                         .db_escape($payment_discount_account) . ", "
  31                         .db_escape($sales_discount_account) . ", "
  32                         .db_escape($default_location) . ", "
  33                         .db_escape($br_post_address) . ","
  34                         .db_escape($disable_trans) . ", "
  35                         .db_escape($group_no) . ", "
  36                         .db_escape($default_ship_via). ", "
  37                         .db_escape($notes). ", "
  38                         .db_escape($rep_lang ? $rep_lang : null, true) . ")";
  39         db_query($sql,"The branch record could not be added");
  40 }
  41
  42 function update_branch($customer_id, $branch_code, $br_name, $br_ref, $br_address, $phone, $phone2, $fax, $contact_name,
  43         $salesman, $area, $email, $tax_group_id, $sales_account, $sales_discount_account, $receivables_account,
  44         $payment_discount_account, $default_location, $br_post_address, $disable_trans, $group_no,
  45         $default_ship_via, $notes, $rep_lang)
  46 {
  47         $sql = "UPDATE ".TB_PREF."cust_branch SET br_name = " . db_escape($br_name) . ",
  48                 branch_ref = " . db_escape($br_ref) . ",
  49                 br_address = ".db_escape($br_address). ",
  50                 phone=".db_escape($phone). ",
  51                 phone2=".db_escape($phone2). ",
  52                 fax=".db_escape($fax).",
  53                 contact_name=".db_escape($contact_name) . ",
  54                 salesman= ".db_escape($salesman) . ",
  55                 area=".db_escape($area) . ",
  56                 email=".db_escape($email) . ",
  57                 tax_group_id=".db_escape($tax_group_id). ",
  58                 sales_account=".db_escape($sales_account) . ",
  59                 sales_discount_account=".db_escape($sales_discount_account) . ",
  60                 receivables_account=".db_escape($receivables_account) . ",
  61                 payment_discount_account=".db_escape($payment_discount_account) . ",
  62                 default_location=".db_escape($default_location) . ",
  63                 br_post_address =".db_escape($br_post_address) . ",
  64                 disable_trans=".db_escape($disable_trans) . ",
  65                 group_no=".db_escape($group_no) . ",
  66                 default_ship_via=".db_escape($default_ship_via) . ",
  67                 notes=".db_escape($notes) . ",
  68                 rep_lang=".db_escape($rep_lang ? $rep_lang : null, true) . "
  69                 WHERE branch_code =".db_escape($branch_code) . "
  70                 AND debtor_no=".db_escape($customer_id);
  71         db_query($sql,"The branch record could not be updated");
  72 }
  73
  74 function delete_branch($customer_id, $branch_code)
  75 {
  76         $sql="DELETE FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_code)." AND debtor_no=".db_escape($customer_id);
  77         db_query($sql,"could not delete branch");
  78 }
  79
  80 function branch_in_foreign_table($customer_id, $branch_code, $table)
  81 {
  82         $sql= "SELECT COUNT(*) FROM ".TB_PREF."$table WHERE branch_code=".db_escape($branch_code)
  83                 ." AND debtor_no = ".db_escape($customer_id);
  84         $result = db_query($sql,"could not query $table");
  85         $myrow = db_fetch_row($result);
  86         return ($myrow[0] > 0);
  87 }
  88
  89 function get_branch($branch_id)
  90 {
  91         $sql = "SELECT ".TB_PREF."cust_branch.*,".TB_PREF."salesman.salesman_name
  92                 FROM ".TB_PREF."cust_branch, ".TB_PREF."salesman
  93                 WHERE ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code
  94                 AND branch_code=".db_escape($branch_id);
  95
  96         $result = db_query($sql, "Cannot retreive a customer branch");
  97
  98         return db_fetch($result);
  99 }
 100
 101 function get_cust_branch($customer_id, $branch_code)
 102 {
 103         $sql = "SELECT * FROM ".TB_PREF."cust_branch
 104                 WHERE branch_code=".db_escape($branch_code)."
 105                 AND debtor_no=".db_escape($customer_id);
 106         $result = db_query($sql,"check failed");
 107         return db_fetch($result);
 108 }
 109
 110 function get_branch_accounts($branch_id)
 111 {
 112         $sql = "SELECT receivables_account,sales_account, sales_discount_account, payment_discount_account
 113                 FROM ".TB_PREF."cust_branch WHERE branch_code=".db_escape($branch_id);
 114
 115         $result = db_query($sql, "Cannot retreive a customer branch");
 116
 117         return db_fetch($result);
 118 }
 119
 120 function get_branch_name($branch_id)
 121 {
 122         $sql = "SELECT br_name FROM ".TB_PREF."cust_branch
 123                 WHERE branch_code = ".db_escape($branch_id);
 124
 125         $result = db_query($sql,"could not retreive name for branch" . $branch_id);
 126
 127         $myrow = db_fetch_row($result);
 128         return $myrow[0];
 129 }
 130
 131 function get_cust_branches_from_group($group_no)
 132 {
 133         $sql = "SELECT branch_code, debtor_no FROM ".TB_PREF."cust_branch
 134                 WHERE group_no = ".db_escape($group_no);
 135
 136         return db_query($sql,"could not retreive branches for group " . $group_no);
 137 }
 138
 139 function get_default_info_for_branch($customer_id)
 140 {
 141         $sql = "SELECT name, address, email, debtor_ref, rep_lang
 142                 FROM ".TB_PREF."debtors_master WHERE debtor_no = ".db_escape($customer_id);
 143         $result = db_query($sql,"check failed");
 144         return db_fetch($result);
 145 }
 146
 147 function get_sql_for_customer_branches()
 148 {
 149         $sql = "SELECT "
 150                 ."b.branch_code, "
 151                 ."b.branch_ref, "
 152                 ."b.br_name, "
 153                 ."b.contact_name, "
 154                 ."s.salesman_name, "
 155                 ."a.description, "
 156                 ."b.phone, "
 157                 ."b.fax, "
 158                 ."b.email, "
 159                 ."t.name AS tax_group_name, "
 160                 ."b.inactive
 161                 FROM ".TB_PREF."cust_branch b, "
 162                         .TB_PREF."debtors_master c, "
 163                         .TB_PREF."areas a, "
 164                         .TB_PREF."salesman s, "
 165                         .TB_PREF."tax_groups t
 166                 WHERE b.debtor_no=c.debtor_no
 167                 AND b.tax_group_id=t.id
 168                 AND b.area=a.area_code
 169                 AND b.salesman=s.salesman_code
 170                 AND b.debtor_no = ".db_escape($_POST['customer_id']);
 171
 172         if (!get_post('show_inactive')) $sql .= " AND !b.inactive";
 173         $sql .= " ORDER BY branch_ref";
 174
 175         return $sql;
 176 }
 177 ?>