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         hyperlink_params("$path_to_root/admin/attachments.php", _("Add an Attachment"), "filterType=$trans_type&trans_no=$invoice_no");
  54
  55         display_footer_exit();
  56 }
  57
  58 //---------------------------------------------------------------------------------------------------
  59
  60 if (isset($_GET['New']))
  61 {
  62         if (isset( $_SESSION['supp_trans']))
  63         {
  64                 unset ($_SESSION['supp_trans']->grn_items);
  65                 unset ($_SESSION['supp_trans']->gl_codes);
  66                 unset ($_SESSION['supp_trans']);
  67         }
  68
  69         $_SESSION['supp_trans'] = new supp_trans;
  70         $_SESSION['supp_trans']->is_invoice = false;
  71 }
  72
  73 function clear_fields()
  74 {
  75         global $Ajax;
  76
  77         unset($_POST['gl_code']);
  78         unset($_POST['dimension_id']);
  79         unset($_POST['dimension2_id']);
  80         unset($_POST['amount']);
  81         unset($_POST['memo_']);
  82         unset($_POST['AddGLCodeToTrans']);
  83         $Ajax->activate('gl_items');
  84         set_focus('gl_code');
  85 }
  86 //------------------------------------------------------------------------------------------------
  87 //      GL postings are often entered in the same form to two accounts
  88 //  so fileds are cleared only on user demand.
  89 //
  90 if (isset($_POST['ClearFields']))
  91 {
  92         clear_fields();
  93 }
  94
  95 if (isset($_POST['AddGLCodeToTrans'])){
  96
  97         $Ajax->activate('gl_items');
  98         $input_error = false;
  99
 100         $sql = "SELECT account_code, account_name FROM ".TB_PREF."chart_master WHERE account_code='" . $_POST['gl_code'] . "'";
 101         $result = db_query($sql,"get account information");
 102         if (db_num_rows($result) == 0)
 103         {
 104                 display_error(_("The account code entered is not a valid code, this line cannot be added to the transaction."));
 105                 set_focus('gl_code');
 106                 $input_error = true;
 107         }
 108         else
 109         {
 110                 $myrow = db_fetch_row($result);
 111                 $gl_act_name = $myrow[1];
 112                 if (!check_num('amount'))
 113                 {
 114                         display_error(_("The amount entered is not numeric. This line cannot be added to the transaction."));
 115                         set_focus('amount');
 116                         $input_error = true;
 117                 }
 118         }
 119
 120         if ($input_error == false)
 121         {
 122                 $_SESSION['supp_trans']->add_gl_codes_to_trans($_POST['gl_code'], $gl_act_name,
 123                         $_POST['dimension_id'], $_POST['dimension2_id'],
 124                         input_num('amount'), $_POST['memo_']);
 125                 set_focus('gl_code');
 126         }
 127 }
 128
 129
 130 //---------------------------------------------------------------------------------------------------
 131
 132 function check_data()
 133 {
 134         global $total_grn_value, $total_gl_value;
 135
 136         if (!$_SESSION['supp_trans']->is_valid_trans_to_post())
 137         {
 138                 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."));
 139                 set_focus('');
 140                 return false;
 141         }
 142
 143         if (!references::is_valid($_SESSION['supp_trans']->reference))
 144         {
 145                 display_error(_("You must enter an credit note reference."));
 146                 set_focus('reference');
 147                 return false;
 148         }
 149
 150         if (!is_new_reference($_SESSION['supp_trans']->reference, 21))
 151         {
 152                 display_error(_("The entered reference is already in use."));
 153                 set_focus('reference');
 154                 return false;
 155         }
 156
 157         if (!references::is_valid($_SESSION['supp_trans']->supp_reference))
 158         {
 159                 display_error(_("You must enter a supplier's credit note reference."));
 160                 set_focus('supp_reference');
 161                 return false;
 162         }
 163
 164         if (!is_date($_SESSION['supp_trans']->tran_date))
 165         {
 166                 display_error(_("The credit note as entered cannot be processed because the date entered is not valid."));
 167                 set_focus('tran_date');
 168                 return false;
 169         }
 170         elseif (!is_date_in_fiscalyear($_SESSION['supp_trans']->tran_date))
 171         {
 172                 display_error(_("The entered date is not in fiscal year."));
 173                 set_focus('tran_date');
 174                 return false;
 175         }
 176         if (!is_date( $_SESSION['supp_trans']->due_date))
 177         {
 178                 display_error(_("The invoice as entered cannot be processed because the due date is in an incorrect format."));
 179                 set_focus('due_date');
 180                 return false;
 181         }
 182
 183         if ($_SESSION['supp_trans']->ov_amount < ($total_gl_value + $total_grn_value))
 184         {
 185                 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."));
 186                 return false;
 187         }
 188
 189         return true;
 190 }
 191
 192 //---------------------------------------------------------------------------------------------------
 193
 194 function handle_commit_credit_note()
 195 {
 196         copy_to_trans($_SESSION['supp_trans']);
 197
 198         if (!check_data())
 199                 return;
 200
 201         $invoice_no = add_supp_invoice($_SESSION['supp_trans']);
 202
 203     $_SESSION['supp_trans']->clear_items();
 204     unset($_SESSION['supp_trans']);
 205
 206         meta_forward($_SERVER['PHP_SELF'], "AddedID=$invoice_no");
 207 }
 208
 209 //--------------------------------------------------------------------------------------------------
 210
 211 if (isset($_POST['PostCreditNote']))
 212 {
 213         handle_commit_credit_note();
 214 }
 215
 216 function check_item_data($n)
 217 {
 218         if (!check_num('This_QuantityCredited'.$n, 0))
 219         {
 220                 display_error(_("The quantity to credit must be numeric and greater than zero."));
 221                 set_focus('This_QuantityCredited'.$n);
 222                 return false;
 223         }
 224
 225         if (!check_num('ChgPrice'.$n, 0))
 226         {
 227                 display_error(_("The price is either not numeric or negative."));
 228                 set_focus('ChgPrice'.$n);
 229                 return false;
 230         }
 231
 232         return true;
 233 }
 234
 235 function commit_item_data($n)
 236 {
 237         if (check_item_data($n))
 238         {
 239                 $complete = False;
 240
 241                 $_SESSION['supp_trans']->add_grn_to_trans($n,
 242                 $_POST['po_detail_item'.$n], $_POST['item_code'.$n],
 243                 $_POST['item_description'.$n], $_POST['qty_recd'.$n],
 244                 $_POST['prev_quantity_inv'.$n], input_num('This_QuantityCredited'.$n),
 245                 $_POST['order_price'.$n], input_num('ChgPrice'.$n), $complete,
 246                 $_POST['std_cost_unit'.$n], "");
 247         }
 248 }
 249
 250 //-----------------------------------------------------------------------------------------
 251
 252 $id = find_submit('grn_item_id');
 253 if ($id != -1)
 254 {
 255         commit_item_data($id);
 256 }
 257
 258 if (isset($_POST['InvGRNAll']))
 259 {
 260         foreach($_POST as $postkey=>$postval )
 261     {
 262                 if (strpos($postkey, "qty_recd") === 0)
 263                 {
 264                         $id = substr($postkey, strlen("qty_recd"));
 265                         $id = (int)$id;
 266                         commit_item_data($id);
 267                 }
 268     }
 269 }
 270
 271
 272 //--------------------------------------------------------------------------------------------------
 273 $id3 = find_submit('Delete');
 274 if ($id3 != -1)
 275 {
 276         $_SESSION['supp_trans']->remove_grn_from_trans($id3);
 277         $Ajax->activate('grn_items');
 278         $Ajax->activate('inv_tot');
 279 }
 280
 281 $id4 = find_submit('Delete2');
 282 if ($id4 != -1)
 283 {
 284         $_SESSION['supp_trans']->remove_gl_codes_from_trans($id4);
 285         clear_fields();
 286         $Ajax->activate('gl_items');
 287         $Ajax->activate('inv_tot');
 288 }
 289
 290
 291 //--------------------------------------------------------------------------------------------------
 292
 293 start_form(false, true);
 294
 295 start_table("$table_style width=98%", 8);
 296 echo "<tr><td valign=center>"; // outer table
 297
 298 echo "<center>";
 299
 300 invoice_header($_SESSION['supp_trans']);
 301 if ($_POST['supplier_id']=='')
 302         display_error('No supplier found for entered search text');
 303 else {
 304         echo "</td></tr><tr><td valign=center>"; // outer table
 305
 306         $total_grn_value = display_grn_items($_SESSION['supp_trans'], 1);
 307
 308         $total_gl_value = display_gl_items($_SESSION['supp_trans'], 1);
 309
 310         echo "</td></tr><tr><td align=center colspan=2>"; // outer table
 311         div_start('inv_tot');
 312         invoice_totals($_SESSION['supp_trans']);
 313         div_end();
 314 }
 315 echo "</td></tr>";
 316
 317 end_table(1); // outer table
 318
 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 ?>