X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=d668dd7024f809ad8a598288bc4fedddab43f0ab;hb=1466764d49233238c6097c95341875be552d7487;hp=93dc8e716062bf8975f002216dde61825568b9b0;hpb=f301d5d26c8915521462bf044f704d139c957a7c;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 93dc8e71..d668dd70 100644
--- a/gl/includes/db/gl_db_bank_accounts.inc
+++ b/gl/includes/db/gl_db_bank_accounts.inc
@@ -76,7 +76,7 @@ function get_bank_account($id)
 
 //---------------------------------------------------------------------------------------------
 
-function get_bank_accounts($show_inactive)
+function get_bank_accounts($show_inactive=false)
 {
 	$sql = "SELECT account.*, gl_account.account_name 
 		FROM ".TB_PREF."bank_accounts account, ".TB_PREF."chart_master gl_account 
@@ -318,14 +318,7 @@ function get_default_bank_account($curr)
 
 function get_default_customer_bank_account($cust_id)
 {
-	if ($cust_id == "")
-	{
-		$sql = "SELECT debtor_no FROM ".TB_PREF."debtors_master WHERE inactive=0 ORDER BY debtor_ref LIMIT 1";
-		$result = db_query($sql, "could not retreive first customer");
-		$row = db_fetch_row($result);
-		$cust_id = $row[0];
-	}
-	$sql = "SELECT curr_code FROM ".TB_PREF."debtors_master WHERE debtor_no=$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]);
@@ -334,13 +327,6 @@ function get_default_customer_bank_account($cust_id)
 
 function get_default_supplier_bank_account($supplier_id)
 {
-	if ($supplier_id == "")
-	{
-		$sql = "SELECT supplier_id FROM ".TB_PREF."suppliers WHERE inactive=0 ORDER BY supp_ref LIMIT 1";
-		$result = db_query($sql, "could not retreive first supplier");
-		$row = db_fetch_row($result);
-		$supplier_id = $row[0];
-	}
 	$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);