purchasing/supplier_credit.php

   1 <?php
   2
   3 $path_to_root="..";
   4
   5 include_once($path_to_root . "/purchasing/includes/supp_trans_class.inc");
   6
   7 $page_security=5;
   8
   9 include_once($path_to_root . "/includes/session.inc");
  10
  11 include_once($path_to_root . "/includes/data_checks.inc");
  12
  13 include_once($path_to_root . "/purchasing/includes/purchasing_db.inc");
  14 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
  15 $js = "";
  16 if ($use_popup_windows)
  17         $js .= get_js_open_window(900, 500);
  18 if ($use_date_picker)
  19         $js .= get_js_date_picker();
  20 page(_("Supplier Credit Note"), false, false, "", $js);
  21
  22 //----------------------------------------------------------------------------------------
  23
  24 check_db_has_suppliers(_("There are no suppliers defined in the system."));
  25
  26 //---------------------------------------------------------------------------------------------------------------
  27 if ($ret = context_restore()) {
  28  // return from supplier editor
  29         copy_from_trans($_SESSION['supp_trans']);
  30         if(isset($ret['supplier_id']))
  31                 $_POST['supplier_id'] = $ret['supplier_id'];
  32 }
  33 if (isset($_POST['_supplier_id_editor'])) {
  34         copy_to_trans($_SESSION['supp_trans']);
  35         context_call($path_to_root.'/purchasing/manage/suppliers.php?supplier_id='.$_POST['supplier_id'], 'supp_trans');
  36 }
  37
  38 //---------------------------------------------------------------------------------------------------------------
  39
  40 if (isset($_GET['AddedID']))
  41 {
  42         $invoice_no = $_GET['AddedID'];
  43         $trans_type = 21;
  44
  45
  46     echo "<center>";
  47     display_notification_centered(_("Supplier credit note has been processed."));
  48     display_note(get_trans_view_str($trans_type, $invoice_no, _("View this Credit Note")));
  49
  50         display_note(get_gl_view_str($trans_type, $invoice_no, _("View the GL Journal Entries for this Credit Note")), 1);
  51
  52     hyperlink_params($_SERVER['PHP_SELF'], _("Enter Another Credit Note"), "New=1");
  53
  54         display_footer_exit();
  55 }
  56
  57 //---------------------------------------------------------------------------------------------------
  58
  59 if (isset($_GET['New']))
  60 {
  61         if (isset( $_SESSION['supp_trans']))
  62         {
  63                 unset ($_SESSION['supp_trans']->grn_items);
  64                 unset ($_SESSION['supp_trans']->gl_codes);
  65                 unset ($_SESSION['supp_trans']);
  66         }
  67
  68         $_SESSION['supp_trans'] = new supp_trans;
  69         $_SESSION['supp_trans']->is_invoice = false;
  70 }
  71
  72 function clear_fields()
  73 {
  74         global $Ajax;
  75
  76         unset($_POST['gl_code']);
  77         unset($_POST['dimension_id']);
  78         unset($_POST['dimension2_id']);
  79         unset($_POST['amount']);
  80         unset($_POST['memo_']);
  81         unset($_POST['AddGLCodeToTrans']);
  82         $Ajax->activate('gl_items');
  83         set_focus('gl_code');
  84 }
  85 //------------------------------------------------------------------------------------------------
  86 //      GL postings are often entered in the same form to two accounts
  87 //  so fileds are cleared only on user demand.
  88 //
  89 if (isset($_POST['ClearFields']))
  90 {
  91         clear_fields();
  92 }
  93
  94 if (isset($_POST['AddGLCodeToTrans'])){
  95
  96         $Ajax->activate('gl_items');
  97         $input_error = false;
  98
  99         $sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
 100         $result = db_query($sql,"get account information");
 101         if (db_num_rows($result) == 0)
 102         {
 103                 display_error(_("The account code entered is not a valid code, this line cannot be added to the transaction."));
 104                 set_focus('gl_code');
 105                 $input_error = true;
 106         }
 107         else
 108         {
 109                 $myrow = db_fetch_row($result);
 110                 $gl_act_name = $myrow[1];
 111                 if (!check_num('amount'))
 112                 {
 113                         display_error(_("The amount entered is not numeric. This line cannot be added to the transaction."));
 114                         set_focus('amount');
 115                         $input_error = true;
 116                 }
 117         }
 118
 119         if ($input_error == false)
 120         {
 121                 $_SESSION['supp_trans']->add_gl_codes_to_trans($_POST['gl_code'], $gl_act_name,
 122                         $_POST['dimension_id'], $_POST['dimension2_id'],
 123                         input_num('amount'), $_POST['memo_']);
 124                 set_focus('gl_code');
 125         }
 126 }
 127
 128
 129 //---------------------------------------------------------------------------------------------------
 130
 131 function check_data()
 132 {
 133         global $total_grn_value, $total_gl_value;
 134
 135         if (!$_SESSION['supp_trans']->is_valid_trans_to_post())
 136         {
 137                 display_error(_("The credit note cannot be processed because the there are no items or values on the invoice.  Credit notes are expected to have a charge."));
 138                 set_focus('');
 139                 return false;
 140         }
 141
 142         if (!references::is_valid($_SESSION['supp_trans']->reference))
 143         {
 144                 display_error(_("You must enter an credit note reference."));
 145                 set_focus('reference');
 146                 return false;
 147         }
 148
 149         if (!is_new_reference($_SESSION['supp_trans']->reference, 21))
 150         {
 151                 display_error(_("The entered reference is already in use."));
 152                 set_focus('reference');
 153                 return false;
 154         }
 155
 156         if (!references::is_valid($_SESSION['supp_trans']->supp_reference))
 157         {
 158                 display_error(_("You must enter a supplier's credit note reference."));
 159                 set_focus('supp_reference');
 160                 return false;
 161         }
 162
 163         if (!is_date($_SESSION['supp_trans']->tran_date))
 164         {
 165                 display_error(_("The credit note as entered cannot be processed because the date entered is not valid."));
 166                 set_focus('tran_date');
 167                 return false;
 168         }
 169         elseif (!is_date_in_fiscalyear($_SESSION['supp_trans']->tran_date))
 170         {
 171                 display_error(_("The entered date is not in fiscal year."));
 172                 set_focus('tran_date');
 173                 return false;
 174         }
 175         if (!is_date( $_SESSION['supp_trans']->due_date))
 176         {
 177                 display_error(_("The invoice as entered cannot be processed because the due date is in an incorrect format."));
 178                 set_focus('due_date');
 179                 return false;
 180         }
 181
 182         if ($_SESSION['supp_trans']->ov_amount < ($total_gl_value + $total_grn_value))
 183         {
 184                 display_error(_("The credit note total as entered is less than the sum of the the general ledger entires (if any) and the charges for goods received. There must be a mistake somewhere, the credit note as entered will not be processed."));
 185                 return false;
 186         }
 187
 188         return true;
 189 }
 190
 191 //---------------------------------------------------------------------------------------------------
 192
 193 function handle_commit_credit_note()
 194 {
 195         copy_to_trans($_SESSION['supp_trans']);
 196
 197         if (!check_data())
 198                 return;
 199
 200         $invoice_no = add_supp_invoice($_SESSION['supp_trans']);
 201
 202     $_SESSION['supp_trans']->clear_items();
 203     unset($_SESSION['supp_trans']);
 204
 205         meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
 206 }
 207
 208 //--------------------------------------------------------------------------------------------------
 209
 210 if (isset($_POST['PostCreditNote']))
 211 {
 212         handle_commit_credit_note();
 213 }
 214
 215 function check_item_data($n)
 216 {
 217         if (!check_num('This_QuantityCredited'.$n, 0))
 218         {
 219                 display_error(_("The quantity to credit must be numeric and greater than zero."));
 220                 set_focus('This_QuantityCredited'.$n);
 221                 return false;
 222         }
 223
 224         if (!check_num('ChgPrice'.$n, 0))
 225         {
 226                 display_error(_("The price is either not numeric or negative."));
 227                 set_focus('ChgPrice'.$n);
 228                 return false;
 229         }
 230
 231         return true;
 232 }
 233
 234 function commit_item_data($n)
 235 {
 236         if (check_item_data($n))
 237         {
 238                 $complete = False;
 239
 240                 $_SESSION['supp_trans']->add_grn_to_trans($n,
 241                 $_POST['po_detail_item'.$n], $_POST['item_code'.$n],
 242                 $_POST['item_description'.$n], $_POST['qty_recd'.$n],
 243                 $_POST['prev_quantity_inv'.$n], input_num('This_QuantityCredited'.$n),
 244                 $_POST['order_price'.$n], input_num('ChgPrice'.$n), $complete,
 245                 $_POST['std_cost_unit'.$n], "");
 246         }
 247 }
 248
 249 //-----------------------------------------------------------------------------------------
 250
 251 $id = find_submit('grn_item_id');
 252 if ($id != -1)
 253 {
 254         commit_item_data($id);
 255 }
 256
 257 if (isset($_POST['InvGRNAll']))
 258 {
 259         foreach($_POST as $postkey=>$postval )
 260     {
 261                 if (strpos($postkey, "qty_recd") === 0)
 262                 {
 263                         $id = substr($postkey, strlen("qty_recd"));
 264                         $id = (int)$id;
 265                         commit_item_data($id);
 266                 }
 267     }
 268 }
 269
 270
 271 //--------------------------------------------------------------------------------------------------
 272 $id = find_submit('Delete');
 273 if ($id != -1)
 274 {
 275         $_SESSION['supp_trans']->remove_grn_from_trans($id);
 276         $Ajax->activate('grn_items');
 277         $Ajax->activate('inv_tot');
 278 }
 279
 280 $id = find_submit('Delete2');
 281 if ($id != -1)
 282 {
 283         $_SESSION['supp_trans']->remove_gl_codes_from_trans($id);
 284         clear_fields();
 285         $Ajax->activate('gl_items');
 286         $Ajax->activate('inv_tot');
 287 }
 288
 289
 290 //--------------------------------------------------------------------------------------------------
 291
 292 start_form(false, true);
 293
 294 start_table("$table_style width=98%", 8);
 295 echo "<tr><td valign=center>"; // outer table
 296
 297 echo "<center>";
 298
 299 invoice_header($_SESSION['supp_trans']);
 300 if ($_POST['supplier_id']=='')
 301         display_error('No supplier found for entered search text');
 302 else {
 303         echo "</td></tr><tr><td valign=center>"; // outer table
 304
 305         $total_grn_value = display_grn_items($_SESSION['supp_trans'], 1);
 306
 307         $total_gl_value = display_gl_items($_SESSION['supp_trans'], 1);
 308
 309         echo "</td></tr><tr><td align=center colspan=2>"; // outer table
 310         div_start('inv_tot');
 311         invoice_totals($_SESSION['supp_trans']);
 312         div_end();
 313 }
 314 echo "</td></tr>";
 315
 316 end_table(1); // outer table
 317
 318 $id = find_submit('grn_item_id');
 319 if ($id != -1)
 320 {
 321         $Ajax->activate('grn_items');
 322         $Ajax->activate('inv_tot');
 323 }
 324
 325 if (get_post('AddGLCodeToTrans'))
 326         $Ajax->activate('inv_tot');
 327
 328
 329 submit_center('PostCreditNote', _("Enter Credit Note"), true, '', true);
 330 echo "<br><br>";
 331
 332 end_form();
 333 end_page();
 334 ?>