inventory/reorder_level.php

   1 <?php
   2
   3 $page_security = 4;
   4 $path_to_root="..";
   5 include_once($path_to_root . "/includes/session.inc");
   6
   7 page(_("Reorder Levels"));
   8
   9 include_once($path_to_root . "/includes/date_functions.inc");
  10 include_once($path_to_root . "/includes/ui.inc");
  11 include_once($path_to_root . "/includes/data_checks.inc");
  12
  13 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
  14
  15 check_db_has_costable_items(_("There are no inventory items defined in the system (Purchased or manufactured items)."));
  16
  17 //------------------------------------------------------------------------------------
  18
  19 if (isset($_GET['stock_id']))
  20 {
  21         $_POST['stock_id'] = $_GET['stock_id'];
  22 }
  23
  24 if (isset($_POST['_stock_id_update']))
  25         $Ajax->activate('reorders');
  26 //------------------------------------------------------------------------------------
  27
  28 start_form(false, true);
  29
  30 if (!isset($_POST['stock_id']))
  31         $_POST['stock_id'] = get_global_stock_item();
  32
  33 echo "<center>" . _("Item:"). "&nbsp;";
  34 stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
  35
  36 echo "<hr></center>";
  37
  38 stock_item_heading($_POST['stock_id']);
  39
  40 set_global_stock_item($_POST['stock_id']);
  41
  42 div_start('reorders');
  43 start_table("$table_style width=30%");
  44
  45 $th = array(_("Location"), _("Quantity On Hand"), _("Re-Order Level"));
  46 table_header($th);
  47
  48 $j = 1;
  49 $k=0; //row colour counter
  50
  51 $result = get_loc_details($_POST['stock_id']);
  52
  53 while ($myrow = db_fetch($result))
  54 {
  55
  56         alt_table_row_color($k);
  57
  58         if (isset($_POST['UpdateData']) && check_num($myrow["loc_code"]))
  59         {
  60
  61                 $myrow["reorder_level"] = input_num($myrow["loc_code"]);
  62                 set_reorder_level($_POST['stock_id'], $myrow["loc_code"], input_num($myrow["loc_code"]));
  63         }
  64
  65         $qoh = get_qoh_on_date($_POST['stock_id'], $myrow["loc_code"]);
  66
  67         label_cell($myrow["location_name"]);
  68
  69         $_POST[$myrow["loc_code"]] = qty_format($myrow["reorder_level"]);
  70
  71         label_cell(number_format2($qoh,user_qty_dec()), "nowrap align='right'");
  72         qty_cells(null, $myrow["loc_code"]);
  73         end_row();
  74         $j++;
  75         If ($j == 12)
  76         {
  77                 $j = 1;
  78                 table_header($th);
  79         }
  80 }
  81
  82 end_table(1);
  83 div_end();
  84 submit_center('UpdateData', _("Update"));
  85
  86 end_form();
  87 end_page();
  88
  89 ?>