5 include_once($path_to_root . "/includes/session.inc");
7 page(_("Reorder Levels"));
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");
13 include_once($path_to_root . "/inventory/includes/inventory_db.inc");
15 check_db_has_costable_items(_("There are no inventory items defined in the system (Purchased or manufactured items)."));
17 //------------------------------------------------------------------------------------
19 if (isset($_GET['stock_id']))
21 $_POST['stock_id'] = $_GET['stock_id'];
24 //------------------------------------------------------------------------------------
26 start_form(false, true);
28 if (!isset($_POST['stock_id']))
29 $_POST['stock_id'] = get_global_stock_item();
31 echo "<center>" . _("Item:"). " ";
32 stock_costable_items_list('stock_id', $_POST['stock_id'], false, true);
36 stock_item_heading($_POST['stock_id']);
38 set_global_stock_item($_POST['stock_id']);
40 start_table("$table_style width=30%");
42 $th = array(_("Location"), _("Quantity On Hand"), _("Re-Order Level"));
46 $k=0; //row colour counter
48 $result = get_loc_details($_POST['stock_id']);
50 while ($myrow = db_fetch($result))
53 alt_table_row_color($k);
55 if (isset($_POST['UpdateData']) && is_numeric($_POST[$myrow["loc_code"]]))
58 $myrow["reorder_level"] = $_POST[$myrow["loc_code"]];
59 set_reorder_level($_POST['stock_id'], $myrow["loc_code"], $_POST[$myrow["loc_code"]]);
62 $qoh = get_qoh_on_date($_POST['stock_id'], $myrow["loc_code"]);
64 label_cell($myrow["location_name"]);
65 label_cell(number_format2($qoh,user_qty_dec()), "nowrap align='right'");
66 text_cells(null, $myrow["loc_code"], $myrow["reorder_level"], 10, 10);
78 submit('UpdateData', _("Update"));