Improved journal trans: added currency support, tax and source document date. Allowed...

[fa-stable.git] / sales / includes / db / branches_db.inc

diff --git a/sales/includes/db/branches_db.inc b/sales/includes/db/branches_db.inc
index 52c41a786ca8ef51ffd77e07471247897432fe6b..80f00a6d253b40969fc9d305a0ac02a1e8c2231e 100644 (file)
--- a/sales/includes/db/branches_db.inc
+++ b/sales/includes/db/branches_db.inc
@@ -251,3 +251,13 @@ function _get_branch_contacts($branch_code, $action=null, $customer_id=null, $de
        return $results;
 }
 
+function get_default_branch($customer_id, $ar_account=null)
+{
+       $sql = "SELECT * 
+               FROM ".TB_PREF."cust_branch WHERE debtor_no = ".db_escape($customer_id);
+       if($ar_account)
+               $sql .= " AND receivables_account=".db_escape($ar_account);
+       $result = db_query($sql,"cannot retrieve default branch");
+       return db_fetch($result);
+}
+