X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=sales%2Fincludes%2Fdb%2Fbranches_db.inc;h=72a965655746546c949e93bc489b75c9d73c5fbd;hb=2cb57633d2f3e27b0c2b2e7448564f467e21e1fd;hp=2c4eb5228a32840fa70597394c6ea10296ec3d09;hpb=da8311619dd73feae101d246a1957b972e00cbd2;p=fa-stable.git diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc index 2c4eb522..72a96565 100644 --- a/sales/includes/db/branches_db.inc +++ b/sales/includes/db/branches_db.inc @@ -1,6 +1,14 @@ . +***********************************************************************/ function get_branch($branch_id) { $sql = "SELECT ".TB_PREF."cust_branch.*,".TB_PREF."salesman.salesman_name @@ -34,4 +42,11 @@ function get_branch_name($branch_id) return $myrow[0]; } +function get_cust_branches_from_group($group_no) +{ + $sql = "SELECT branch_code, debtor_no FROM ".TB_PREF."cust_branch + WHERE group_no = '$group_no'"; + + return db_query($sql,"could not retreive branches for group " . $group_no); +} ?> \ No newline at end of file