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 (!(input_num('AmountDebit')!=0 ^ input_num('AmountCredit')!=0) )
 141         {
 142                 display_error(_("You must enter either a debit amount or a credit amount."));
 143                 return false;
 144         }
 145
 146         if (strlen($_POST['AmountDebit']) && !check_num('AmountDebit', 0))
 147         {
 148                 display_error(_("The debit amount entered is not a valid number or is less than zero."));
 149                 return false;
 150         } elseif (strlen($_POST['AmountCredit']) && !check_num('AmountCredit', 0))
 151         {
 152                 display_error(_("The credit amount entered is not a valid number or is less than zero."));
 153                 return false;
 154         }
 155
 156
 157         if ($_SESSION["wa_current_user"]->access != 2 && is_bank_account($_POST['code_id']))
 158         {
 159                 display_error(_("You cannot make a journal entry for a bank account. Please use one of the banking functions for bank transactions."));
 160                 return false;
 161         }
 162
 163         return true;
 164 }
 165
 166 //-----------------------------------------------------------------------------------------------
 167
 168 function handle_update_item()
 169 {
 170     if($_POST['UpdateItem'] != "" && check_item_data())
 171     {
 172         if (input_num('AmountDebit') > 0)
 173                 $amount = input_num('AmountDebit');
 174         else
 175                 $amount = -input_num('AmountCredit');
 176
 177         $_SESSION['journal_items']->update_gl_item($_POST['Index'], $_POST['dimension_id'],
 178                 $_POST['dimension2_id'], $amount, $_POST['LineMemo']);
 179     }
 180 }
 181
 182 //-----------------------------------------------------------------------------------------------
 183
 184 function handle_delete_item()
 185 {
 186         $_SESSION['journal_items']->remove_gl_item($_GET['Delete']);
 187 }
 188
 189 //-----------------------------------------------------------------------------------------------
 190
 191 function handle_new_item()
 192 {
 193         if (!check_item_data())
 194                 return;
 195
 196         if (input_num('AmountDebit') > 0)
 197                 $amount = input_num('AmountDebit');
 198         else
 199                 $amount = -input_num('AmountCredit');
 200
 201         $_SESSION['journal_items']->add_gl_item($_POST['code_id'], $_POST['dimension_id'],
 202                 $_POST['dimension2_id'], $amount, $_POST['LineMemo']);
 203 }
 204
 205 //-----------------------------------------------------------------------------------------------
 206
 207 if (isset($_GET['Delete']) || isset($_GET['Edit']))
 208         copy_from_je();
 209
 210 if (isset($_GET['Delete']))
 211         handle_delete_item();
 212
 213 if (isset($_POST['AddItem']) || isset($_POST['UpdateItem']))
 214         copy_to_je();
 215
 216 if (isset($_POST['AddItem']))
 217         handle_new_item();
 218
 219 if (isset($_POST['UpdateItem']))
 220         handle_update_item();
 221
 222 //-----------------------------------------------------------------------------------------------
 223
 224 if (isset($_GET['NewJournal']) || !isset($_SESSION['journal_items']))
 225 {
 226         handle_new_order();
 227 }
 228
 229 //-----------------------------------------------------------------------------------------------
 230
 231 start_form();
 232
 233 display_order_header($_SESSION['journal_items']);
 234
 235 start_table("$table_style2 width=90%", 10);
 236 start_row();
 237 echo "<td>";
 238 display_gl_items(_("Rows"), $_SESSION['journal_items']);
 239 gl_options_controls();
 240 echo "</td>";
 241 end_row();
 242 end_table(1);
 243
 244 if ($_SESSION['journal_items']->count_gl_items() >= 1 &&
 245         abs($_SESSION['journal_items']->gl_items_total()) < 0.0001)
 246 {
 247     submit_center('Process', _("Process Journal Entry"));
 248 }
 249 else
 250 {
 251         display_note(_("The journal must balance (debits equal to credits) before it can be processed."), 0, 1);
 252 }
 253
 254 end_form();
 255
 256 //------------------------------------------------------------------------------------------------
 257
 258 end_page();
 259
 260 ?>