purchasing/po_receive_items.php

   1 <?php
   2 $page_security = 11;
   3 $path_to_root="..";
   4 include_once($path_to_root . "/purchasing/includes/po_class.inc");
   5
   6 include_once($path_to_root . "/includes/session.inc");
   7 include_once($path_to_root . "/purchasing/includes/purchasing_db.inc");
   8 include_once($path_to_root . "/purchasing/includes/purchasing_ui.inc");
   9
  10 $js = "";
  11 if ($use_popup_windows)
  12         $js .= get_js_open_window(900, 500);
  13 if ($use_date_picker)
  14         $js .= get_js_date_picker();
  15 page(_("Receive Purchase Order Items"), false, false, "", $js);
  16
  17 //---------------------------------------------------------------------------------------------------------------
  18
  19 if (isset($_GET['AddedID']))
  20 {
  21         $grn = $_GET['AddedID'];
  22         $trans_type = 25;
  23
  24         display_notification_centered(_("Purchase Order Delivery has been processed"));
  25
  26         display_note(get_trans_view_str($trans_type, $grn, _("View this Delivery")));
  27
  28         //echo "<BR>";
  29         //echo get_gl_view_str(25, $grn, _("View the GL Journal Entries for this Delivery"));
  30
  31 //      echo "<br>";
  32         hyperlink_no_params("$path_to_root/purchasing/inquiry/po_search.php", _("Select a different purchase order for receiving items against"));
  33
  34         display_footer_exit();
  35 }
  36
  37 //--------------------------------------------------------------------------------------------------
  38
  39 if ((!isset($_GET['PONumber']) || $_GET['PONumber'] == 0) && !isset($_SESSION['PO']))
  40 //if (isset($_GET['PONumber']) && !$_GET['PONumber'] > 0 && !isset($_SESSION['PO']))
  41 {
  42         die (_("This page can only be opened if a purchase order has been selected. Please select a purchase order first."));
  43 }
  44
  45 //--------------------------------------------------------------------------------------------------
  46
  47 function display_po_receive_items()
  48 {
  49         global $table_style;
  50
  51         div_start('grn_items');
  52     start_table("colspan=7 $table_style width=90%");
  53     $th = array(_("Item Code"), _("Description"), _("Ordered"), _("Units"), _("Received"),
  54         _("Outstanding"), _("This Delivery"), _("Price"), _("Total"));
  55     table_header($th);
  56
  57     /*show the line items on the order with the quantity being received for modification */
  58
  59     $total = 0;
  60     $k = 0; //row colour counter
  61
  62     if (count($_SESSION['PO']->line_items)> 0 )
  63     {
  64         foreach ($_SESSION['PO']->line_items as $ln_itm)
  65         {
  66
  67                         alt_table_row_color($k);
  68
  69                 $qty_outstanding = $ln_itm->quantity - $ln_itm->qty_received;
  70
  71                 if ($ln_itm->receive_qty == 0)
  72                 {   //If no quantites yet input default the balance to be received
  73                 $ln_itm->receive_qty = $qty_outstanding;
  74                 }
  75
  76                 $line_total = ($ln_itm->receive_qty * $ln_itm->price);
  77                 $total += $line_total;
  78
  79                         label_cell($ln_itm->stock_id);
  80                         if ($qty_outstanding > 0)
  81                                 text_cells(null, $ln_itm->stock_id . "Desc", $ln_itm->item_description, 30, 50);
  82                         else
  83                                 label_cell($ln_itm->item_description);
  84                         $dec = get_qty_dec($ln_itm->stock_id);
  85                         qty_cell($ln_itm->quantity, false, $dec);
  86                         label_cell($ln_itm->units);
  87                         qty_cell($ln_itm->qty_received, false, $dec);
  88                         qty_cell($qty_outstanding, false, $dec);
  89
  90                         if ($qty_outstanding > 0)
  91                                 qty_cells(null, $ln_itm->line_no, number_format2($ln_itm->receive_qty, $dec), "align=right", null, $dec);
  92                         else
  93                                 label_cell(number_format2($ln_itm->receive_qty, $dec), "align=right");
  94
  95                         amount_cell($ln_itm->price);
  96                         amount_cell($line_total);
  97                         end_row();
  98         }
  99     }
 100
 101     $display_total = number_format2($total,user_price_dec());
 102     label_row(_("Total value of items received"), $display_total, "colspan=8 align=right",
 103         "nowrap align=right");
 104     end_table();
 105         div_end();
 106 }
 107
 108 //--------------------------------------------------------------------------------------------------
 109
 110 function check_po_changed()
 111 {
 112         /*Now need to check that the order details are the same as they were when they were read into the Items array. If they've changed then someone else must have altered them */
 113         // Sherifoz 22.06.03 Compare against COMPLETED items only !!
 114         // Otherwise if you try to fullfill item quantities separately will give error.
 115         $sql = "SELECT item_code, quantity_ordered, quantity_received, qty_invoiced
 116                 FROM ".TB_PREF."purch_order_details
 117                 WHERE order_no=" . $_SESSION['PO']->order_no . "
 118                 AND (quantity_ordered > quantity_received)
 119                 ORDER BY po_detail_item";
 120
 121         $result = db_query($sql, "could not query purch order details");
 122     check_db_error("Could not check that the details of the purchase order had not been changed by another user ", $sql);
 123
 124         $line_no = 1;
 125         while ($myrow = db_fetch($result))
 126         {
 127                 $ln_item = $_SESSION['PO']->line_items[$line_no];
 128
 129                 // only compare against items that are outstanding
 130                 $qty_outstanding = $ln_item->quantity - $ln_item->qty_received;
 131                 if ($qty_outstanding > 0)
 132                 {
 133                 if ($ln_item->qty_inv != $myrow["qty_invoiced"] ||
 134                         $ln_item->stock_id != $myrow["item_code"] ||
 135                         $ln_item->quantity != $myrow["quantity_ordered"] ||
 136                         $ln_item->qty_received != $myrow["quantity_received"])
 137                 {
 138                         return true;
 139                 }
 140                 }
 141                 $line_no++;
 142         } /*loop through all line items of the order to ensure none have been invoiced */
 143
 144         return false;
 145 }
 146
 147 //--------------------------------------------------------------------------------------------------
 148
 149 function can_process()
 150 {
 151         if (count($_SESSION['PO']->line_items) <= 0)
 152         {
 153         display_error(_("There is nothing to process. Please enter valid quantities greater than zero."));
 154         return false;
 155         }
 156
 157         if (!is_date($_POST['DefaultReceivedDate']))
 158         {
 159                 display_error(_("The entered date is invalid."));
 160                 set_focus('DefaultReceivedDate');
 161                 return false;
 162         }
 163
 164     if (!references::is_valid($_POST['ref']))
 165     {
 166                 display_error(_("You must enter a reference."));
 167                 set_focus('ref');
 168                 return false;
 169         }
 170
 171         if (!is_new_reference($_POST['ref'], 25))
 172         {
 173                 display_error(_("The entered reference is already in use."));
 174                 set_focus('ref');
 175                 return false;
 176         }
 177
 178         $something_received = 0;
 179         foreach ($_SESSION['PO']->line_items as $order_line)
 180         {
 181                 if ($order_line->receive_qty > 0)
 182                 {
 183                         $something_received = 1;
 184                         break;
 185                 }
 186         }
 187
 188     // Check whether trying to deliver more items than are recorded on the actual purchase order (+ overreceive allowance)
 189     $delivery_qty_too_large = 0;
 190         foreach ($_SESSION['PO']->line_items as $order_line)
 191         {
 192                 if ($order_line->receive_qty+$order_line->qty_received >
 193                         $order_line->quantity * (1+ (sys_prefs::over_receive_allowance() / 100)))
 194                 {
 195                         $delivery_qty_too_large = 1;
 196                         break;
 197                 }
 198         }
 199
 200     if ($something_received == 0)
 201     {   /*Then dont bother proceeding cos nothing to do ! */
 202         display_error(_("There is nothing to process. Please enter valid quantities greater than zero."));
 203         return false;
 204     }
 205     elseif ($delivery_qty_too_large == 1)
 206     {
 207         display_error(_("Entered quantities cannot be greater than the quantity entered on the purchase order including the allowed over-receive percentage") . " (" . sys_prefs::over_receive_allowance() ."%)."
 208                 . "<br>" .
 209                 _("Modify the ordered items on the purchase order if you wish to increase the quantities."));
 210         return false;
 211     }
 212
 213         return true;
 214 }
 215
 216 //--------------------------------------------------------------------------------------------------
 217
 218 function process_receive_po()
 219 {
 220         global $path_to_root, $Ajax;
 221
 222         if (!can_process())
 223                 return;
 224
 225         if (check_po_changed())
 226         {
 227                 echo "<br> " . _("This order has been changed or invoiced since this delivery was started to be actioned. Processing halted. To enter a delivery against this purchase order, it must be re-selected and re-read again to update the changes made by the other user.") . "<BR>";
 228
 229                 echo "<center><a href='$path_to_root/purchasing/inquiry/po_search.php?" . SID . "'>" . _("Select a different purchase order for receiving goods against") . "</a></center>";
 230                 echo "<center><a href='$path_to_root/po_receive_items.php?" . SID . "PONumber=" . $_SESSION['PO']->OrderNumber . "'>" . _("Re-Read the updated purchase order for receiving goods against") . "</a></center>";
 231                 unset($_SESSION['PO']->line_items);
 232                 unset($_SESSION['PO']);
 233                 unset($_POST['ProcessGoodsReceived']);
 234                 $Ajax->activate('_page_body');
 235                 exit;
 236         }
 237
 238         $grn = add_grn($_SESSION['PO'], $_POST['DefaultReceivedDate'],
 239                 $_POST['ref'], $_POST['Location']);
 240
 241         unset($_SESSION['PO']->line_items);
 242         unset($_SESSION['PO']);
 243
 244         meta_forward($_SERVER['PHP_SELF'], "AddedID=$grn");
 245 }
 246
 247 //--------------------------------------------------------------------------------------------------
 248
 249 if (isset($_GET['PONumber']) && $_GET['PONumber'] > 0 && !isset($_POST['Update']))
 250 {
 251
 252         create_new_po();
 253
 254         /*read in all the selected order into the Items cart  */
 255         read_po($_GET['PONumber'], $_SESSION['PO']);
 256 }
 257
 258 //--------------------------------------------------------------------------------------------------
 259
 260 if (isset($_POST['Update']) || isset($_POST['ProcessGoodsReceived']))
 261 {
 262
 263         /* if update quantities button is hit page has been called and ${$line->line_no} would have be
 264         set from the post to the quantity to be received in this receival*/
 265         foreach ($_SESSION['PO']->line_items as $line)
 266         {
 267          if( ($line->quantity - $line->qty_received)>0) {
 268                 $_POST[$line->line_no] = max($_POST[$line->line_no], 0);
 269                 if (!check_num($line->line_no))
 270                         $_POST[$line->line_no] = number_format2(0, get_qty_dec($line->stock_id));
 271
 272                 if (!isset($_POST['DefaultReceivedDate']) || $_POST['DefaultReceivedDate'] == "")
 273                         $_POST['DefaultReceivedDate'] = Today();
 274
 275                 $_SESSION['PO']->line_items[$line->line_no]->receive_qty = input_num($line->line_no);
 276
 277                 if (isset($_POST[$line->stock_id . "Desc"]) && strlen($_POST[$line->stock_id . "Desc"]) > 0)
 278                 {
 279                         $_SESSION['PO']->line_items[$line->line_no]->item_description = $_POST[$line->stock_id . "Desc"];
 280                 }
 281          }
 282         }
 283         $Ajax->activate('grn_items');
 284 }
 285
 286 //--------------------------------------------------------------------------------------------------
 287
 288 if (isset($_POST['ProcessGoodsReceived']))
 289 {
 290         process_receive_po();
 291 }
 292
 293 //--------------------------------------------------------------------------------------------------
 294
 295 start_form(false, true);
 296
 297 display_grn_summary($_SESSION['PO'], true);
 298 display_heading(_("Items to Receive"));
 299 display_po_receive_items();
 300
 301 echo '<br>';
 302 submit_center_first('Update', _("Update"), '', true);
 303 submit_center_last('ProcessGoodsReceived', _("Process Receive Items"), _("Clear all GL entry fields"), true);
 304
 305 end_form();
 306
 307 //--------------------------------------------------------------------------------------------------
 308
 309 end_page();
 310 ?>
 311