gl/gl_journal.php

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