. ***********************************************************************/ $page_security = 2; $path_to_root="../.."; include_once($path_to_root . "/includes/session.inc"); if (isset($_GET['stock_id'])){ $_POST['stock_id'] = $_GET['stock_id']; page(_("Inventory Item Status"), true); } else { page(_("Inventory Item Status")); } include_once($path_to_root . "/includes/date_functions.inc"); include_once($path_to_root . "/includes/ui.inc"); include_once($path_to_root . "/includes/manufacturing.inc"); include_once($path_to_root . "/includes/data_checks.inc"); include_once($path_to_root . "/inventory/includes/inventory_db.inc"); if (list_updated('stock_id')) $Ajax->activate('status_tbl'); //---------------------------------------------------------------------------------------------------- check_db_has_stock_items(_("There are no items defined in the system.")); start_form(false, true); if (!isset($_POST['stock_id'])) $_POST['stock_id'] = get_global_stock_item(); echo " " . _("Item:"). " "; stock_items_list('stock_id', $_POST['stock_id'], false, true); echo "
"; echo "

---

"; set_global_stock_item($_POST['stock_id']); $mb_flag = get_mb_flag($_POST['stock_id']); $kitset_or_service = false; div_start('status_tbl'); if (is_service($mb_flag)) { display_note(_("This is a service and cannot have a stock holding, only the total quantity on outstanding sales orders is shown."), 0, 1); $kitset_or_service = true; } $loc_details = get_loc_details($_POST['stock_id']); start_table($table_style); if ($kitset_or_service == true) { $th = array(_("Location"), _("Demand")); } else { $th = array(_("Location"), _("Quantity On Hand"), _("Re-Order Level"), _("Demand"), _("Available"), _("On Order")); } table_header($th); $dec = get_qty_dec($_POST['stock_id']); $j = 1; $k = 0; //row colour counter while ($myrow = db_fetch($loc_details)) { alt_table_row_color($k); $demand_qty = get_demand_qty($_POST['stock_id'], $myrow["loc_code"]); $demand_qty += get_demand_asm_qty($_POST['stock_id'], $myrow["loc_code"]); $qoh = get_qoh_on_date($_POST['stock_id'], $myrow["loc_code"]); if ($kitset_or_service == false) { $qoo = get_on_porder_qty($_POST['stock_id'], $myrow["loc_code"]); $qoo += get_on_worder_qty($_POST['stock_id'], $myrow["loc_code"]); label_cell($myrow["location_name"]); qty_cell($qoh, false, $dec); qty_cell($myrow["reorder_level"], false, $dec); qty_cell($demand_qty, false, $dec); qty_cell($qoh - $demand_qty, false, $dec); qty_cell($qoo, false, $dec); end_row(); } else { /* It must be a service or kitset part */ label_cell($myrow["location_name"]); qty_cell($demand_qty, false, $dec); end_row(); } $j++; If ($j == 12) { $j = 1; table_header($th); } } end_table(); div_end(); end_form(); end_page(); ?>