2 /**********************************************************************
3 Copyright (C) FrontAccounting, LLC.
4 Released under the terms of the GNU General Public License, GPL,
5 as published by the Free Software Foundation, either version 3
6 of the License, or (at your option) any later version.
7 This program is distributed in the hope that it will be useful,
8 but WITHOUT ANY WARRANTY; without even the implied warranty of
9 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
10 See the License here <http://www.gnu.org/licenses/gpl-3.0.html>.
11 ***********************************************************************/
12 $page_security = 'SA_BANKTRANSFER';
15 include_once($path_to_root . "/includes/session.inc");
17 include_once($path_to_root . "/includes/date_functions.inc");
18 include_once($path_to_root . "/includes/data_checks.inc");
20 include_once($path_to_root . "/gl/includes/gl_db.inc");
21 include_once($path_to_root . "/gl/includes/gl_ui.inc");
24 if ($use_popup_windows)
25 $js .= get_js_open_window(800, 500);
26 if (user_use_date_picker())
27 $js .= get_js_date_picker();
28 page(_($help_context = "Transfer between Bank Accounts"), false, false, "", $js);
30 check_db_has_bank_accounts(_("There are no bank accounts defined in the system."));
32 //----------------------------------------------------------------------------------------
34 if (isset($_GET['AddedID']))
36 $trans_no = $_GET['AddedID'];
37 $trans_type = ST_BANKTRANSFER;
39 display_notification_centered( _("Transfer has been entered"));
41 display_note(get_gl_view_str($trans_type, $trans_no, _("&View the GL Journal Entries for this Transfer")));
43 hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter &Another Transfer"));
45 display_footer_exit();
48 if (isset($_POST['_DatePaid_changed'])) {
49 $Ajax->activate('_ex_rate');
52 //----------------------------------------------------------------------------------------
54 function gl_payment_controls()
58 $home_currency = get_company_currency();
62 start_outer_table(TABLESTYLE2);
66 bank_accounts_list_row(_("From Account:"), 'FromBankAccount', null, true);
68 bank_balance_row($_POST['FromBankAccount']);
70 bank_accounts_list_row(_("To Account:"), 'ToBankAccount', null, true);
72 if (!isset($_POST['DatePaid'])) { // init page
73 $_POST['DatePaid'] = new_doc_date();
74 if (!is_date_in_fiscalyear($_POST['DatePaid']))
75 $_POST['DatePaid'] = end_fiscalyear();
77 date_row(_("Transfer Date:"), 'DatePaid', '', true, 0, 0, 0, null, true);
79 ref_row(_("Reference:"), 'ref', '', $Refs->get_next(ST_BANKTRANSFER));
83 $from_currency = get_bank_account_currency($_POST['FromBankAccount']);
84 $to_currency = get_bank_account_currency($_POST['ToBankAccount']);
85 if ($from_currency != "" && $to_currency != "" && $from_currency != $to_currency)
87 amount_row(_("Amount:"), 'amount', null, null, $from_currency);
88 amount_row(_("Bank Charge:"), 'charge', null, null, $from_currency);
90 amount_row(_("Incoming Amount:"), 'target_amount', null, '', $to_currency, 2);
94 amount_row(_("Amount:"), 'amount');
95 amount_row(_("Bank Charge:"), 'charge');
98 textarea_row(_("Memo:"), 'memo_', null, 40,4);
100 end_outer_table(1); // outer table
102 submit_center('AddPayment',_("Enter Transfer"), true, '', 'default');
107 //----------------------------------------------------------------------------------------
109 function check_valid_entries()
113 if (!is_date($_POST['DatePaid']))
115 display_error(_("The entered date is invalid."));
116 set_focus('DatePaid');
119 if (!is_date_in_fiscalyear($_POST['DatePaid']))
121 display_error(_("The entered date is out of fiscal year or is closed for further data entry."));
122 set_focus('DatePaid');
126 if (!check_num('amount', 0))
128 display_error(_("The entered amount is invalid or less than zero."));
132 if (input_num('amount') == 0) {
133 display_error(_("The total bank amount cannot be 0."));
138 $limit = get_bank_account_limit($_POST['FromBankAccount'], $_POST['DatePaid']);
140 $amnt_tr = input_num('charge') + input_num('amount');
142 if ($limit !== null && floatcmp($limit, $amnt_tr) < 0)
144 display_error(sprintf(_("The total bank amount exceeds allowed limit (%s) for source account."), price_format($limit)));
148 if ($trans = check_bank_account_history(-$amnt_tr, $_POST['FromBankAccount'], $_POST['DatePaid'])) {
150 display_error(sprintf(_("The bank transaction would result in exceed of authorized overdraft limit for transaction: %s #%s on %s."),
151 $systypes_array[$trans['type']], $trans['trans_no'], sql2date($trans['trans_date'])));
156 if (isset($_POST['charge']) && !check_num('charge', 0))
158 display_error(_("The entered amount is invalid or less than zero."));
162 if (isset($_POST['charge']) && input_num('charge') > 0 && get_bank_charge_account($_POST['FromBankAccount']) == '') {
163 display_error(_("The Bank Charge Account has not been set in System and General GL Setup."));
167 if (!$Refs->is_valid($_POST['ref']))
169 display_error(_("You must enter a reference."));
174 if (!is_new_reference($_POST['ref'], ST_BANKTRANSFER))
176 display_error(_("The entered reference is already in use."));
181 if ($_POST['FromBankAccount'] == $_POST['ToBankAccount'])
183 display_error(_("The source and destination bank accouts cannot be the same."));
184 set_focus('ToBankAccount');
188 if (isset($_POST['target_amount']) && !check_num('target_amount', 0))
190 display_error(_("The entered amount is invalid or less than zero."));
191 set_focus('target_amount');
194 if (isset($_POST['target_amount']) && input_num('target_amount') == 0) {
195 display_error(_("The incomming bank amount cannot be 0."));
196 set_focus('target_amount');
200 if (!db_has_currency_rates(get_bank_account_currency($_POST['FromBankAccount']), $_POST['DatePaid']))
203 if (!db_has_currency_rates(get_bank_account_currency($_POST['ToBankAccount']), $_POST['DatePaid']))
209 //----------------------------------------------------------------------------------------
211 function handle_add_deposit()
213 new_doc_date($_POST['DatePaid']);
214 $trans_no = add_bank_transfer($_POST['FromBankAccount'], $_POST['ToBankAccount'],
215 $_POST['DatePaid'], input_num('amount'), $_POST['ref'], $_POST['memo_'], input_num('charge'), input_num('target_amount'));
217 meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no");
220 //----------------------------------------------------------------------------------------
222 if (isset($_POST['AddPayment']))
224 if (check_valid_entries() == true)
226 handle_add_deposit();
230 gl_payment_controls();