<?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");
}
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";
//---------------------------------------------------------------------------------------------
+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