gl/gl_journal.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 = 3;
  13 $path_to_root="..";
  14 include_once($path_to_root . "/includes/ui/items_cart.inc");
  15
  16 include_once($path_to_root . "/includes/session.inc");
  17
  18 include_once($path_to_root . "/includes/date_functions.inc");
  19 include_once($path_to_root . "/includes/data_checks.inc");
  20
  21 include_once($path_to_root . "/gl/includes/ui/gl_journal_ui.inc");
  22 include_once($path_to_root . "/gl/includes/gl_db.inc");
  23 include_once($path_to_root . "/gl/includes/gl_ui.inc");
  24
  25 $js = '';
  26 if ($use_popup_windows)
  27         $js .= get_js_open_window(800, 500);
  28 if ($use_date_picker)
  29         $js .= get_js_date_picker();
  30
  31 page(_("Journal Entry"), false, false,'', $js);
  32
  33 //--------------------------------------------------------------------------------------------------
  34 function line_start_focus() {
  35   global        $Ajax;
  36
  37   $Ajax->activate('items_table');
  38   set_focus('_code_id_edit');
  39 }
  40 //-----------------------------------------------------------------------------------------------
  41
  42 if (isset($_GET['AddedID']))
  43 {
  44         $trans_no = $_GET['AddedID'];
  45         $trans_type = systypes::journal_entry();
  46
  47         display_notification_centered( _("Journal entry has been entered") . " #$trans_no");
  48
  49     display_note(get_gl_view_str($trans_type, $trans_no, _("&View this Journal Entry")));
  50
  51         hyperlink_no_params($_SERVER['PHP_SELF'], _("Enter &Another Journal Entry"));
  52
  53         display_footer_exit();
  54 }
  55 //--------------------------------------------------------------------------------------------------
  56
  57 function handle_new_order()
  58 {
  59         if (isset($_SESSION['journal_items']))
  60         {
  61                 $_SESSION['journal_items']->clear_items();
  62                 unset ($_SESSION['journal_items']);
  63         }
  64
  65     session_register("journal_items");
  66
  67     $_SESSION['journal_items'] = new items_cart(systypes::journal_entry());
  68
  69         $_POST['date_'] = new_doc_date();
  70         if (!is_date_in_fiscalyear($_POST['date_']))
  71                 $_POST['date_'] = end_fiscalyear();
  72         $_SESSION['journal_items']->tran_date = $_POST['date_'];
  73 }
  74
  75 //-----------------------------------------------------------------------------------------------
  76
  77 if (isset($_POST['Process']))
  78 {
  79
  80         $input_error = 0;
  81
  82         if ($_SESSION['journal_items']->count_gl_items() < 1) {
  83                 display_error(_("You must enter at least one journal line."));
  84                 set_focus('code_id');
  85                 $input_error = 1;
  86         }
  87         if (abs($_SESSION['journal_items']->gl_items_total()) > 0.0001)
  88         {
  89                 display_error(_("The journal must balance (debits equal to credits) before it can be processed."));
  90                 set_focus('code_id');
  91                 $input_error = 1;
  92         }
  93
  94
  95         if (!is_date($_POST['date_']))
  96         {
  97                 display_error(_("The entered date is invalid."));
  98                 set_focus('date_');
  99                 $input_error = 1;
 100         }
 101         elseif (!is_date_in_fiscalyear($_POST['date_']))
 102         {
 103                 display_error(_("The entered date is not in fiscal year."));
 104                 set_focus('date_');
 105                 $input_error = 1;
 106         }
 107         if (!references::is_valid($_POST['ref']))
 108         {
 109                 display_error( _("You must enter a reference."));
 110                 set_focus('ref');
 111                 $input_error = 1;
 112         }
 113         elseif (references::exists(systypes::journal_entry(), $_POST['ref']))
 114         {
 115                 display_error( _("The entered reference is already in use."));
 116                 set_focus('ref');
 117                 $input_error = 1;
 118         }
 119
 120         if ($input_error == 1)
 121                 unset($_POST['Process']);
 122 }
 123
 124 if (isset($_POST['Process']))
 125 {
 126
 127         $trans_no = add_journal_entries($_SESSION['journal_items']->gl_items,
 128                 $_POST['date_'], $_POST['ref'], check_value('Reverse'), $_POST['memo_']);
 129
 130         $_SESSION['journal_items']->clear_items();
 131         new_doc_date($_POST['date_']);
 132         unset($_SESSION['journal_items']);
 133
 134         meta_forward($_SERVER['PHP_SELF'], "AddedID=$trans_no");
 135 } /*end of process credit note */
 136
 137 //-----------------------------------------------------------------------------------------------
 138
 139 function check_item_data()
 140 {
 141         if (isset($_POST['dimension_id']) && $_POST['dimension_id'] != 0 && dimension_is_closed($_POST['dimension_id']))
 142         {
 143                 display_error(_("Dimension is closed."));
 144                 set_focus('dimension_id');
 145                 return false;
 146         }
 147
 148         if (isset($_POST['dimension2_id']) && $_POST['dimension2_id'] != 0 && dimension_is_closed($_POST['dimension2_id']))
 149         {
 150                 display_error(_("Dimension is closed."));
 151                 set_focus('dimension2_id');
 152                 return false;
 153         }
 154
 155         if (!(input_num('AmountDebit')!=0 ^ input_num('AmountCredit')!=0) )
 156         {
 157                 display_error(_("You must enter either a debit amount or a credit amount."));
 158                 set_focus('AmountDebit');
 159                 return false;
 160         }
 161
 162         if (strlen($_POST['AmountDebit']) && !check_num('AmountDebit', 0))
 163         {
 164                 display_error(_("The debit amount entered is not a valid number or is less than zero."));
 165                 set_focus('AmountDebit');
 166                 return false;
 167         } elseif (strlen($_POST['AmountCredit']) && !check_num('AmountCredit', 0))
 168         {
 169                 display_error(_("The credit amount entered is not a valid number or is less than zero."));
 170                 set_focus('AmountCredit');
 171                 return false;
 172         }
 173
 174
 175         if ($_SESSION["wa_current_user"]->access != 2 && is_bank_account($_POST['code_id']))
 176         {
 177                 display_error(_("You cannot make a journal entry for a bank account. Please use one of the banking functions for bank transactions."));
 178                 set_focus('code_id');
 179                 return false;
 180         }
 181
 182         return true;
 183 }
 184
 185 //-----------------------------------------------------------------------------------------------
 186
 187 function handle_update_item()
 188 {
 189     if($_POST['UpdateItem'] != "" && check_item_data())
 190     {
 191         if (input_num('AmountDebit') > 0)
 192                 $amount = input_num('AmountDebit');
 193         else
 194                 $amount = -input_num('AmountCredit');
 195
 196         $_SESSION['journal_items']->update_gl_item($_POST['Index'], $_POST['dimension_id'],
 197                 $_POST['dimension2_id'], $amount, $_POST['LineMemo']);
 198     }
 199         line_start_focus();
 200 }
 201
 202 //-----------------------------------------------------------------------------------------------
 203
 204 function handle_delete_item($id)
 205 {
 206         $_SESSION['journal_items']->remove_gl_item($id);
 207         line_start_focus();
 208 }
 209
 210 //-----------------------------------------------------------------------------------------------
 211
 212 function handle_new_item()
 213 {
 214         if (!check_item_data())
 215                 return;
 216
 217         if (input_num('AmountDebit') > 0)
 218                 $amount = input_num('AmountDebit');
 219         else
 220                 $amount = -input_num('AmountCredit');
 221
 222         $_SESSION['journal_items']->add_gl_item($_POST['code_id'], $_POST['dimension_id'],
 223                 $_POST['dimension2_id'], $amount, $_POST['LineMemo']);
 224         line_start_focus();
 225 }
 226
 227 //-----------------------------------------------------------------------------------------------
 228 $id = find_submit('Delete');
 229 if ($id != -1)
 230         handle_delete_item($id);
 231
 232 if (isset($_POST['AddItem']))
 233         handle_new_item();
 234
 235 if (isset($_POST['UpdateItem']))
 236         handle_update_item();
 237
 238 if (isset($_POST['CancelItemChanges']))
 239         line_start_focus();
 240
 241 if (isset($_POST['go']))
 242 {
 243         display_quick_entries($_SESSION['journal_items'], $_POST['person_id'], input_num('totamount'), QE_JOURNAL);
 244         $_POST['totamount'] = price_format(0); $Ajax->activate('totamount');
 245         line_start_focus();
 246 }
 247 //-----------------------------------------------------------------------------------------------
 248
 249 if (isset($_GET['NewJournal']) || !isset($_SESSION['journal_items']))
 250 {
 251         handle_new_order();
 252 }
 253
 254 //-----------------------------------------------------------------------------------------------
 255
 256 start_form();
 257
 258 display_order_header($_SESSION['journal_items']);
 259
 260 start_table("$table_style2 width=90%", 10);
 261 start_row();
 262 echo "<td>";
 263 display_gl_items(_("Rows"), $_SESSION['journal_items']);
 264 gl_options_controls();
 265 echo "</td>";
 266 end_row();
 267 end_table(1);
 268
 269 submit_center('Process', _("Process Journal Entry"), true ,
 270         _('Process journal entry only if debits equal to credits'), 'default');
 271
 272 end_form();
 273 //------------------------------------------------------------------------------------------------
 274
 275 end_page();
 276
 277 ?>