X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=1669d20005656ccff82c445f0f24dd4881870ea7;hb=78fe8cb8f56510ba3f6a1720b207a33b5828e071;hp=0850dfe01a8c577cd6e5f45a7adafdf85e065aae;hpb=76ca9fef9bb510236a6a7740fa0f60eb7db384c9;p=fa-stable.git diff --git a/gl/includes/db/gl_db_bank_accounts.inc b/gl/includes/db/gl_db_bank_accounts.inc index 0850dfe0..1669d200 100644 --- a/gl/includes/db/gl_db_bank_accounts.inc +++ b/gl/includes/db/gl_db_bank_accounts.inc @@ -315,6 +315,24 @@ function get_default_bank_account($curr) return db_fetch($result); } + +function get_default_customer_bank_account($cust_id) +{ + $sql = "SELECT curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=".db_escape($cust_id); + $result = db_query($sql, "could not retreive default customer currency code"); + $row = db_fetch_row($result); + $ba = get_default_bank_account($row[0]); + return $ba['id']; +} + +function get_default_supplier_bank_account($supplier_id) +{ + $sql = "SELECT curr_code FROM ".TB_PREF."suppliers WHERE supplier_id=".db_escape($supplier_id); + $result = db_query($sql, "could not retreive default supplier currency code"); + $row = db_fetch_row($result); + $ba = get_default_bank_account($row[0]); + return $ba['id']; +} //--------------------------------------------------------------------------------------------- // // This function returns current allowed bank payment limit, or null if limit is not set.