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_QUICKENTRY';
13 $path_to_root = "../..";
14 include($path_to_root . "/includes/session.inc");
16 page(_($help_context = "Quick Entries"));
18 include($path_to_root . "/gl/includes/gl_db.inc");
20 include($path_to_root . "/includes/ui.inc");
22 simple_page_mode(true);
23 simple_page_mode2(true);
25 function simple_page_mode2($numeric_id = true)
27 global $Ajax, $Mode2, $selected_id2;
29 $default = $numeric_id ? -1 : '';
30 $selected_id2 = get_post('selected_id2', $default);
31 foreach (array('ADD_ITEM2', 'UPDATE_ITEM2', 'RESET2') as $m) {
32 if (isset($_POST[$m])) {
33 $Ajax->activate('_page_body');
35 $selected_id2 = $default;
39 foreach (array('BEd', 'BDel') as $m) {
40 foreach ($_POST as $p => $pvar) {
41 if (strpos($p, $m) === 0) {
42 // $selected_id2 = strtr(substr($p, strlen($m)), array('%2E'=>'.'));
43 unset($_POST['_focus']); // focus on first form entry
44 $selected_id2 = quoted_printable_decode(substr($p, strlen($m)));
45 $Ajax->activate('_page_body');
54 function submit_add_or_update_center2($add=true, $title=false, $async=false)
58 submit('ADD_ITEM2', _("Add new"), true, $title, $async);
60 submit('UPDATE_ITEM2', _("Update"), true, $title, $async);
61 submit('RESET2', _("Cancel"), true, $title, $async);
66 //-----------------------------------------------------------------------------------
68 function can_process()
71 if (strlen($_POST['description']) == 0)
73 display_error( _("The Quick Entry description cannot be empty."));
74 set_focus('description');
77 $bal_type = get_post('bal_type');
78 if ($bal_type == 1 && $_POST['type'] != QE_JOURNAL)
80 display_error( _("You can only use Balance Based together with Journal Entries."));
81 set_focus('base_desc');
84 if (!$bal_type && strlen($_POST['base_desc']) == 0)
86 display_error( _("The base amount description cannot be empty."));
87 set_focus('base_desc');
94 //-----------------------------------------------------------------------------------
96 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
102 if ($selected_id != -1)
104 update_quick_entry($selected_id, $_POST['description'], $_POST['type'],
105 input_num('base_amount'), $_POST['base_desc'], get_post('bal_type', 0));
106 display_notification(_('Selected quick entry has been updated'));
110 add_quick_entry($_POST['description'], $_POST['type'],
111 input_num('base_amount'), $_POST['base_desc'], get_post('bal_type', 0));
112 display_notification(_('New quick entry has been added'));
118 if ($Mode2=='ADD_ITEM2' || $Mode2=='UPDATE_ITEM2')
120 if ($selected_id2 != -1)
122 update_quick_entry_line($selected_id2, $selected_id, $_POST['actn'], $_POST['dest_id'], input_num('amount', 0),
123 $_POST['dimension_id'], $_POST['dimension2_id']);
124 display_notification(_('Selected quick entry line has been updated'));
128 add_quick_entry_line($selected_id, $_POST['actn'], $_POST['dest_id'], input_num('amount', 0),
129 $_POST['dimension_id'], $_POST['dimension2_id']);
130 display_notification(_('New quick entry line has been added'));
135 //-----------------------------------------------------------------------------------
137 if ($Mode == 'Delete')
139 if (!has_quick_entry_lines($selected_id))
141 delete_quick_entry($selected_id);
142 display_notification(_('Selected quick entry has been deleted'));
147 display_error( _("The Quick Entry has Quick Entry Lines. Cannot be deleted."));
148 set_focus('description');
152 if (find_submit('Edit') != -1) {
154 set_focus('description');
156 if (find_submit('BEd') != -1 || get_post('ADD_ITEM2')) {
160 if ($Mode2 == 'BDel')
162 delete_quick_entry_line($selected_id2);
163 display_notification(_('Selected quick entry line has been deleted'));
166 //-----------------------------------------------------------------------------------
167 if ($Mode == 'RESET')
170 $_POST['description'] = $_POST['type'] = '';
171 $_POST['base_desc']= _('Base Amount');
172 $_POST['base_amount'] = price_format(0);
173 $_POST['bal_type'] = 0;
175 if ($Mode2 == 'RESET2')
178 $_POST['actn'] = $_POST['dest_id'] = $_POST['amount'] =
179 $_POST['dimension_id'] = $_POST['dimension2_id'] = '';
181 //-----------------------------------------------------------------------------------
183 $result = get_quick_entries();
185 start_table(TABLESTYLE);
186 $th = array(_("Description"), _("Type"), "", "");
190 while ($myrow = db_fetch($result))
192 alt_table_row_color($k);
193 $type_text = $quick_entry_types[$myrow["type"]];
194 label_cell($myrow['description']);
195 label_cell($type_text);
196 edit_button_cell("Edit".$myrow["id"], _("Edit"));
197 delete_button_cell("Delete".$myrow["id"], _("Delete"));
202 //-----------------------------------------------------------------------------------
205 start_table(TABLESTYLE2);
207 if ($selected_id != -1)
209 if ($Mode == 'Edit') // changed by Joe 2010-11-09
211 $myrow = get_quick_entry($selected_id);
213 $_POST['id'] = $myrow["id"];
214 $_POST['description'] = $myrow["description"];
215 $_POST['type'] = $myrow["type"];
216 $_POST['base_desc'] = $myrow["base_desc"];
217 $_POST['bal_type'] = $myrow["bal_type"];
218 $_POST['base_amount'] = $myrow["bal_type"] ?
219 $myrow["base_amount"] : price_format($myrow["base_amount"]);
221 hidden('selected_id', $selected_id);
224 text_row_ex(_("Description").':', 'description', 50, 60);
226 quick_entry_types_list_row(_("Entry Type").':', 'type', null, true);
228 if (get_post('type') == QE_JOURNAL)
230 yesno_list_row(_("Balance Based"), 'bal_type', null, _("Yes"), _("No"), true);
233 if (list_updated('bal_type') || list_updated('type'))
235 $Ajax->activate('qe');
238 if (get_post('type') == QE_JOURNAL && get_post('bal_type') == 1)
240 yesno_list_row(_("Period"), 'base_amount', null, _("Monthly"), _("Yearly"));
241 gl_all_accounts_list_row(_("Account"), 'base_desc', null, true);
245 text_row_ex(_("Base Amount Description").':', 'base_desc', 50, 60, '');
246 amount_row(_("Default Base Amount").':', 'base_amount', price_format(0));
249 submit_add_or_update_center($selected_id == -1, '', 'both');
253 if ($selected_id != -1)
255 display_heading(_("Quick Entry Lines") . " - " . $_POST['description']);
256 $result = get_quick_entry_lines($selected_id);
258 start_table(TABLESTYLE2);
259 $dim = get_company_pref('use_dimension');
261 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), _("Dimension")." 2", "", "");
263 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), "", "");
265 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), "", "");
269 while ($myrow = db_fetch($result))
271 alt_table_row_color($k);
273 label_cell($quick_actions[$myrow['action']]);
275 $act_type = strtolower(substr($myrow['action'], 0, 1));
277 if ($act_type == 't')
279 label_cells($myrow['tax_name'], '');
283 label_cell($myrow['dest_id'].' '.$myrow['account_name']);
284 if ($act_type == '=')
286 elseif ($act_type == '%')
287 label_cell(number_format2($myrow['amount'], user_exrate_dec()), "nowrap align=right ");
289 amount_cell($myrow['amount']);
292 label_cell(get_dimension_string($myrow['dimension_id'], true));
294 label_cell(get_dimension_string($myrow['dimension2_id'], true));
295 edit_button_cell("BEd".$myrow["id"], _("Edit"));
296 delete_button_cell("BDel".$myrow["id"], _("Delete"));
301 div_start('edit_line');
302 start_table(TABLESTYLE2);
304 if ($selected_id2 != -1)
308 //editing an existing status code
309 $myrow = get_quick_entry_line($selected_id2);
311 $_POST['id'] = $myrow["id"];
312 $_POST['dest_id'] = $myrow["dest_id"];
313 $_POST['actn'] = $myrow["action"];
314 $_POST['amount'] = $myrow["amount"];
315 $_POST['dimension_id'] = $myrow["dimension_id"];
316 $_POST['dimension2_id'] = $myrow["dimension2_id"];
320 quick_actions_list_row(_("Posted").":",'actn', null, true);
321 if (list_updated('actn'))
322 $Ajax->activate('edit_line');
324 $actn = strtolower(substr($_POST['actn'],0,1));
328 //item_tax_types_list_row(_("Item Tax Type").":",'dest_id', null);
329 tax_types_list_row(_("Tax Type").":", 'dest_id', null);
333 gl_all_accounts_list_row(_("Account").":", 'dest_id', null, $_POST['type'] == QE_DEPOSIT || $_POST['type'] == QE_PAYMENT);
337 small_amount_row(_("Part").":", 'amount', price_format(0), null, "%", user_exrate_dec());
339 amount_row(_("Amount").":", 'amount', price_format(0));
343 dimensions_list_row(_("Dimension").":", 'dimension_id', null, true, " ", false, 1);
345 dimensions_list_row(_("Dimension")." 2:", 'dimension2_id', null, true, " ", false, 2);
349 hidden('dimension2_id', 0);
351 hidden('dimension_id', 0);
354 hidden('selected_id', $selected_id);
355 hidden('selected_id2', $selected_id2);
357 submit_add_or_update_center2($selected_id2 == -1, '', true);
361 //------------------------------------------------------------------------------------