sales/includes/db/branches_db.inc

   1 <?php
   2
   3
   4 function get_branch($branch_id)
   5 {
   6         $sql = "SELECT ".TB_PREF."cust_branch.*,".TB_PREF."salesman.salesman_name
   7                 FROM ".TB_PREF."cust_branch, ".TB_PREF."salesman
   8                 WHERE ".TB_PREF."cust_branch.salesman=".TB_PREF."salesman.salesman_code
   9                 AND branch_code=$branch_id";
  10
  11         $result = db_query($sql, "Cannot retreive a customer branch");
  12
  13         return db_fetch($result);
  14 }
  15
  16 function get_branch_accounts($branch_id)
  17 {
  18         $sql = "SELECT receivables_account,sales_account, sales_discount_account, payment_discount_account
  19                 FROM ".TB_PREF."cust_branch WHERE branch_code=$branch_id";
  20
  21         $result = db_query($sql, "Cannot retreive a customer branch");
  22
  23         return db_fetch($result);
  24 }
  25
  26 function get_branch_name($branch_id)
  27 {
  28         $sql = "SELECT br_name FROM ".TB_PREF."cust_branch
  29                 WHERE branch_code = '$branch_id'";
  30
  31         $result = db_query($sql,"could not retreive name for branch" . $branch_id);
  32
  33         $myrow = db_fetch_row($result);
  34         return $myrow[0];
  35 }
  36
  37 function get_cust_branches_from_group($group_no)
  38 {
  39         $sql = "SELECT branch_code, debtor_no FROM ".TB_PREF."cust_branch
  40                 WHERE group_no = '$group_no'";
  41
  42         return db_query($sql,"could not retreive branches for group " . $group_no);
  43 }
  44 ?>