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_ctrls');
  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 //-----------------------------------------------------------------------------------------
 235
 236 $id = find_submit('grn_item_id');
 237 if ($id != -1)
 238 {
 239         if (check_item_data($id))
 240         {
 241                 $complete = False;
 242
 243                 //$_SESSION['supp_trans']->add_grn_to_trans($_POST['GRNNumber'],
 244         //      $_POST['po_detail_item'], $_POST['item_code'],
 245         //      $_POST['item_description'], $_POST['qty_recd'],
 246         //      $_POST['prev_quantity_inv'], $_POST['This_QuantityCredited'],
 247         //      $_POST['order_price'], $_POST['ChgPrice'], $complete,
 248         //      $_POST['std_cost_unit'], $_POST['gl_code']);
 249                 $_SESSION['supp_trans']->add_grn_to_trans($id,
 250                 $_POST['po_detail_item'.$id], $_POST['item_code'.$id],
 251                 $_POST['item_description'.$id], $_POST['qty_recd'.$id],
 252                 $_POST['prev_quantity_inv'.$id], input_num('This_QuantityCredited'.$id),
 253                 $_POST['order_price'.$id], input_num('ChgPrice'.$id), $complete,
 254                 $_POST['std_cost_unit'.$id], "");
 255         }
 256 }
 257
 258 //--------------------------------------------------------------------------------------------------
 259 $id = find_submit('Delete');
 260 if ($id != -1)
 261 {
 262         $_SESSION['supp_trans']->remove_grn_from_trans($id);
 263         $Ajax->activate('grn_items');
 264         $Ajax->activate('grn_table');
 265         $Ajax->activate('inv_tot');
 266 }
 267
 268 $id = find_submit('Delete2');
 269 if ($id != -1)
 270 {
 271         $_SESSION['supp_trans']->remove_gl_codes_from_trans($id);
 272         clear_fields();
 273         $Ajax->activate('gl_items');
 274         $Ajax->activate('inv_tot');
 275 }
 276
 277
 278 //--------------------------------------------------------------------------------------------------
 279
 280 start_form(false, true);
 281
 282 start_table("$table_style width=98%", 8);
 283 echo "<tr><td valign=center>"; // outer table
 284
 285 echo "<center>";
 286
 287 invoice_header($_SESSION['supp_trans']);
 288 if ($_POST['supplier_id']=='')
 289         display_error('No supplier found for entered search text');
 290 else {
 291         echo "</td></tr><tr><td valign=center>"; // outer table
 292
 293         $total_grn_value = display_grn_items($_SESSION['supp_trans'], 1);
 294
 295         $total_gl_value = display_gl_items($_SESSION['supp_trans'], 1);
 296
 297         echo "</td></tr><tr><td align=center colspan=2>"; // outer table
 298         div_start('inv_tot');
 299         invoice_totals($_SESSION['supp_trans']);
 300         div_end();
 301 }
 302 echo "</td></tr>";
 303
 304 end_table(1); // outer table
 305
 306 $id = find_submit('grn_item_id');
 307 if ($id != -1)
 308 {
 309         $Ajax->activate('grn_table');
 310         $Ajax->activate('grn_items');
 311         $Ajax->activate('inv_tot');
 312 }
 313
 314 if (get_post('AddGLCodeToTrans'))
 315         $Ajax->activate('inv_tot');
 316
 317
 318 submit_center('PostCreditNote', _("Enter Credit Note"), true, '', true);
 319 echo "<br><br>";
 320
 321 end_form();
 322 end_page();
 323 ?>