X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=gl%2Fincludes%2Fdb%2Fgl_db_bank_accounts.inc;h=dbc1e01afdc4c85c313269ef9ee791450d9f315e;hb=28e7dac267b65d8163ca41c452c42706d0ffb2dd;hp=595639aeb1fa2627474c79feee15bf86f07418e7;hpb=43ddf1a424217b1620ac93b02b7e33a48d95140e;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 595639ae..dbc1e01a 100644
--- a/gl/includes/db/gl_db_bank_accounts.inc
+++ b/gl/includes/db/gl_db_bank_accounts.inc
@@ -1,27 +1,51 @@
 <?php
-
+/**********************************************************************
+    Copyright (C) FrontAccounting, LLC.
+	Released under the terms of the GNU General Public License, GPL, 
+	as published by the Free Software Foundation, either version 3 
+	of the License, or (at your option) any later version.
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  
+    See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
+***********************************************************************/
 //---------------------------------------------------------------------------------------------
+function clear_dflt_curr_account($curr_code) {
+	  $sql = "UPDATE ".TB_PREF."bank_accounts SET dflt_curr_act=0 WHERE bank_curr_code="
+	  .db_escape($curr_code);
+	  db_query($sql, "could not update default currency account");
+}
 
-function add_bank_account($account_code, $account_type, $bank_account_name, $bank_name, $bank_account_number,
-	$bank_address, $bank_curr_code)
+function add_bank_account($account_code, $account_type, $bank_account_name,
+	$bank_name, $bank_account_number, $bank_address, $bank_curr_code, 
+	$dflt_curr_act)
 {
-	$sql = "INSERT INTO ".TB_PREF."bank_accounts (account_code, account_type, bank_account_name, bank_name, bank_account_number, bank_address, bank_curr_code)
+	if($dflt_curr_act) 	// only one default account for any currency
+	  clear_dflt_curr_account($bank_curr_code);
+
+	$sql = "INSERT INTO ".TB_PREF."bank_accounts (account_code, account_type, 
+		bank_account_name, bank_name, bank_account_number, bank_address, 
+		bank_curr_code, dflt_curr_act)
 		VALUES (".db_escape($account_code).", $account_type, ".db_escape($bank_account_name).", ".db_escape($bank_name).", ".db_escape($bank_account_number).",
-		".db_escape($bank_address).", '$bank_curr_code')";
+		".db_escape($bank_address).", '$bank_curr_code', '$dflt_curr_act')";
 
 	db_query($sql, "could not add a bank account for $account_code");
 }
 
 //---------------------------------------------------------------------------------------------
 
-function update_bank_account($id, $account_code, $account_type, $bank_account_name, $bank_name, $bank_account_number,
-	$bank_address, $bank_curr_code)
+function update_bank_account($id, $account_code, $account_type, $bank_account_name, 
+	$bank_name, $bank_account_number, $bank_address, $bank_curr_code, $dflt_curr_act)
 {
+	if($dflt_curr_act) 	// only one default account for any currency
+	  clear_dflt_curr_account($bank_curr_code);
+
 	$sql = "UPDATE ".TB_PREF."bank_accounts	SET account_type = $account_type,
 		account_code=".db_escape($account_code).",
 		bank_account_name=".db_escape($bank_account_name).", bank_name=".db_escape($bank_name).",
 		bank_account_number=".db_escape($bank_account_number).", bank_curr_code='$bank_curr_code',
-		bank_address=".db_escape($bank_address)." WHERE id = '$id'";
+		bank_address=".db_escape($bank_address).","
+		."dflt_curr_act='$dflt_curr_act' WHERE id = '$id'";
 
 	db_query($sql, "could not update bank account for $account_code");
 }
@@ -157,12 +181,12 @@ function get_quick_entry($selected_id)
 function get_quick_entry_lines($qid)
 {
 	$sql = "SELECT ".TB_PREF."quick_entry_lines.*, ".TB_PREF."chart_master.account_name,
-			".TB_PREF."item_tax_types.name as tax_name
+			".TB_PREF."tax_types.name as tax_name
 		FROM ".TB_PREF."quick_entry_lines
 		LEFT JOIN ".TB_PREF."chart_master ON
 			".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."chart_master.account_code
-		LEFT JOIN ".TB_PREF."item_tax_types ON
-			".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."item_tax_types.id
+		LEFT JOIN ".TB_PREF."tax_types ON
+			".TB_PREF."quick_entry_lines.dest_id = ".TB_PREF."tax_types.id
 		WHERE 
 			qid=$qid
 		ORDER by id";
@@ -191,4 +215,24 @@ function get_quick_entry_line($selected_id)
 
 //---------------------------------------------------------------------------------------------
 
+function get_default_bank_account($curr)
+{
+	/* default bank account is selected as first found account from:
+		. default account in $curr if any
+		. first defined account in $curr if any
+		. default account in home currency
+		. first defined account in home currency
+	*/
+	$home_curr = get_company_pref('curr_default');
+
+	$sql = "SELECT b.*, b.bank_curr_code='$home_curr' as fall_back FROM "
+		.TB_PREF."bank_accounts b"
+		." WHERE b.bank_curr_code=".db_escape($curr)
+		." OR b.bank_curr_code='$home_curr'
+		ORDER BY fall_back, dflt_curr_act desc";
+
+	$result = db_query($sql, "could not retreive default bank account");
+
+	return db_fetch($result);
+}
 ?>
\ No newline at end of file