gl/manage/gl_quick_entries.php

   1 <?php
   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");
  15
  16 page(_($help_context = "Quick Entries"));
  17
  18 include($path_to_root . "/gl/includes/gl_db.inc");
  19
  20 include($path_to_root . "/includes/ui.inc");
  21
  22 simple_page_mode(true);
  23 simple_page_mode2(true);
  24
  25 function simple_page_mode2($numeric_id = true)
  26 {
  27         global $Ajax, $Mode2, $selected_id2;
  28
  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');
  34                         if ($m == 'RESET2')
  35                                 $selected_id2 = $default;
  36                         $Mode2 = $m; return;
  37                 }
  38         }
  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');
  46                                 $Mode2 = $m;
  47                                 return;
  48                         }
  49                 }
  50         }
  51         $Mode2 = '';
  52 }
  53
  54 function submit_add_or_update_center2($add=true, $title=false, $async=false)
  55 {
  56         echo "<center>";
  57         if ($add)
  58                 submit('ADD_ITEM2', _("Add new"), true, $title, $async);
  59         else {
  60                 submit('UPDATE_ITEM2', _("Update"), true, $title, $async);
  61                 submit('RESET2', _("Cancel"), true, $title, $async);
  62         }
  63         echo "</center>";
  64 }
  65
  66 //-----------------------------------------------------------------------------------
  67
  68 function can_process()
  69 {
  70
  71         if (strlen($_POST['description']) == 0)
  72         {
  73                 display_error( _("The Quick Entry description cannot be empty."));
  74                 set_focus('description');
  75                 return false;
  76         }
  77         $bal_type = get_post('bal_type');
  78         if ($bal_type == 1 && $_POST['type'] != QE_JOURNAL)
  79         {
  80                 display_error( _("You can only use Balance Based together with Journal Entries."));
  81                 set_focus('base_desc');
  82                 return false;
  83         }
  84         if (!$bal_type && strlen($_POST['base_desc']) == 0)
  85         {
  86                 display_error( _("The base amount description cannot be empty."));
  87                 set_focus('base_desc');
  88                 return false;
  89         }
  90
  91         return true;
  92 }
  93
  94 //-----------------------------------------------------------------------------------
  95
  96 if ($Mode=='ADD_ITEM' || $Mode=='UPDATE_ITEM')
  97 {
  98
  99         if (can_process())
 100         {
 101
 102                 if ($selected_id != -1)
 103                 {
 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'));
 107                 }
 108                 else
 109                 {
 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'));
 113                 }
 114                 $Mode = 'RESET';
 115         }
 116 }
 117
 118 if ($Mode2=='ADD_ITEM2' || $Mode2=='UPDATE_ITEM2')
 119 {
 120         if ($selected_id2 != -1)
 121         {
 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'));
 125         }
 126         else
 127         {
 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'));
 131         }
 132         $Mode2 = 'RESET2';
 133 }
 134
 135 //-----------------------------------------------------------------------------------
 136
 137 if ($Mode == 'Delete')
 138 {
 139         if (!has_quick_entry_lines($selected_id))
 140         {
 141                 delete_quick_entry($selected_id);
 142                 display_notification(_('Selected quick entry has been deleted'));
 143                 $Mode = 'RESET';
 144         }
 145         else
 146         {
 147                 display_error( _("The Quick Entry has Quick Entry Lines. Cannot be deleted."));
 148                 set_focus('description');
 149         }
 150 }
 151
 152 if (find_submit('Edit') != -1) {
 153         $Mode2 = 'RESET2';
 154         set_focus('description');
 155 }
 156 if (find_submit('BEd') != -1 || get_post('ADD_ITEM2')) {
 157         set_focus('actn');
 158 }
 159
 160 if ($Mode2 == 'BDel')
 161 {
 162         delete_quick_entry_line($selected_id2);
 163         display_notification(_('Selected quick entry line has been deleted'));
 164         $Mode2 = 'RESET2';
 165 }
 166 //-----------------------------------------------------------------------------------
 167 if ($Mode == 'RESET')
 168 {
 169         $selected_id = -1;
 170         $_POST['description'] = $_POST['type'] = '';
 171         $_POST['base_desc']= _('Base Amount');
 172         $_POST['base_amount'] = price_format(0);
 173         $_POST['bal_type'] = 0;
 174 }
 175 if ($Mode2 == 'RESET2')
 176 {
 177         $selected_id2 = -1;
 178         $_POST['actn'] = $_POST['dest_id'] = $_POST['amount'] =
 179                 $_POST['dimension_id'] = $_POST['dimension2_id'] = '';
 180 }
 181 //-----------------------------------------------------------------------------------
 182
 183 $result = get_quick_entries();
 184 start_form();
 185 start_table(TABLESTYLE);
 186 $th = array(_("Description"), _("Type"), "", "");
 187 table_header($th);
 188
 189 $k = 0;
 190 while ($myrow = db_fetch($result))
 191 {
 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"));
 198         end_row();
 199 }
 200
 201 end_table(1);
 202 //-----------------------------------------------------------------------------------
 203
 204 div_start('qe');
 205 start_table(TABLESTYLE2);
 206
 207 if ($selected_id != -1)
 208 {
 209         if ($Mode == 'Edit') // changed by Joe 2010-11-09
 210         {
 211                 $myrow = get_quick_entry($selected_id);
 212
 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"]);
 220         }
 221         hidden('selected_id', $selected_id);
 222 }
 223
 224 text_row_ex(_("Description").':', 'description', 50, 60);
 225
 226 quick_entry_types_list_row(_("Entry Type").':', 'type', null, true);
 227
 228 if (get_post('type') == QE_JOURNAL)
 229 {
 230         yesno_list_row(_("Balance Based"), 'bal_type', null, _("Yes"), _("No"), true);
 231 }
 232
 233 if (list_updated('bal_type') || list_updated('type'))
 234 {
 235         $Ajax->activate('qe');
 236 }
 237
 238 if (get_post('type') == QE_JOURNAL && get_post('bal_type') == 1)
 239 {
 240         yesno_list_row(_("Period"), 'base_amount', null, _("Monthly"), _("Yearly"));
 241         gl_all_accounts_list_row(_("Account"), 'base_desc', null, true);
 242 }
 243 else
 244 {
 245         text_row_ex(_("Base Amount Description").':', 'base_desc', 50, 60, '');
 246         amount_row(_("Default Base Amount").':', 'base_amount', price_format(0));
 247 }
 248 end_table(1);
 249 submit_add_or_update_center($selected_id == -1, '', 'both');
 250 div_end();
 251
 252
 253 if ($selected_id != -1)
 254 {
 255         display_heading(_("Quick Entry Lines") . " - " . $_POST['description']);
 256         $result = get_quick_entry_lines($selected_id);
 257
 258         start_table(TABLESTYLE2);
 259         $dim = get_company_pref('use_dimension');
 260         if ($dim == 2)
 261                 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), _("Dimension")." 2", "", "");
 262         elseif ($dim == 1)
 263                 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), _("Dimension"), "", "");
 264         else
 265                 $th = array(_("Post"), _("Account/Tax Type"), _("Amount"), "", "");
 266
 267         table_header($th);
 268         $k = 0;
 269         while ($myrow = db_fetch($result))
 270         {
 271                 alt_table_row_color($k);
 272
 273                 label_cell($quick_actions[$myrow['action']]);
 274
 275                 $act_type = strtolower(substr($myrow['action'], 0, 1));
 276
 277                 if ($act_type == 't')
 278                 {
 279                         label_cells($myrow['tax_name'], '');
 280                 }
 281                 else
 282                 {
 283                         label_cell($myrow['dest_id'].' '.$myrow['account_name']);
 284                         if ($act_type == '=')
 285                                 label_cell('');
 286                         elseif ($act_type == '%')
 287                                 label_cell(number_format2($myrow['amount'], user_exrate_dec()), "nowrap align=right ");
 288                         else
 289                                 amount_cell($myrow['amount']);
 290                 }
 291                 if ($dim >= 1)
 292                         label_cell(get_dimension_string($myrow['dimension_id'], true));
 293                 if ($dim > 1)
 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"));
 297                 end_row();
 298         }
 299         end_table(1);
 300
 301         div_start('edit_line');
 302         start_table(TABLESTYLE2);
 303
 304         if ($selected_id2 != -1)
 305         {
 306                 if ($Mode2 == 'BEd')
 307                 {
 308                         //editing an existing status code
 309                         $myrow = get_quick_entry_line($selected_id2);
 310
 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"];
 317                 }
 318         }
 319
 320         quick_actions_list_row(_("Posted").":",'actn', null, true);
 321         if (list_updated('actn'))
 322                 $Ajax->activate('edit_line');
 323
 324         $actn = strtolower(substr($_POST['actn'],0,1));
 325
 326         if ($actn == 't')
 327         {
 328                 //item_tax_types_list_row(_("Item Tax Type").":",'dest_id', null);
 329                 tax_types_list_row(_("Tax Type").":", 'dest_id', null);
 330         }
 331         else
 332         {
 333                 gl_all_accounts_list_row(_("Account").":", 'dest_id', null, $_POST['type'] == QE_DEPOSIT || $_POST['type'] == QE_PAYMENT);
 334                 if ($actn != '=')
 335                 {
 336                         if ($actn == '%')
 337                                 small_amount_row(_("Part").":", 'amount', price_format(0), null, "%", user_exrate_dec());
 338                         else
 339                                 amount_row(_("Amount").":", 'amount', price_format(0));
 340                 }
 341         }
 342         if ($dim >= 1)
 343                 dimensions_list_row(_("Dimension").":", 'dimension_id', null, true, " ", false, 1);
 344         if ($dim > 1)
 345                 dimensions_list_row(_("Dimension")." 2:", 'dimension2_id', null, true, " ", false, 2);
 346
 347         end_table(1);
 348         if ($dim < 2)
 349                 hidden('dimension2_id', 0);
 350         if ($dim < 1)
 351                 hidden('dimension_id', 0);
 352         div_end();
 353
 354         hidden('selected_id', $selected_id);
 355         hidden('selected_id2', $selected_id2);
 356
 357         submit_add_or_update_center2($selected_id2 == -1, '', true);
 358
 359 }
 360 end_form();
 361 //------------------------------------------------------------------------------------
 362
 363 end_page();
 364
 365 ?>