X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Finquiry%2Fstock_status.php;h=b83c6038e4c63d6f448986d25f2798d1039f2421;hb=c82cbc67f22454e4afd30e53c40043b54a732be3;hp=c683fa950868af4e20df9e77684a40998a109055;hpb=8c83c09db95c22618519f7f0cc7a977c7cbb4068;p=fa-stable.git diff --git a/inventory/inquiry/stock_status.php b/inventory/inquiry/stock_status.php index c683fa95..b83c6038 100644 --- a/inventory/inquiry/stock_status.php +++ b/inventory/inquiry/stock_status.php @@ -9,23 +9,25 @@ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the License here . ***********************************************************************/ -$page_security = 2; -$path_to_root="../.."; +$page_security = 'SA_ITEMSSTATVIEW'; +$path_to_root = "../.."; include_once($path_to_root . "/includes/session.inc"); -if (isset($_GET['stock_id'])){ +$js = ""; +if ($SysPrefs->use_popup_windows && $SysPrefs->use_popup_search) + $js .= get_js_open_window(900, 500); + +if (isset($_GET['stock_id'])) $_POST['stock_id'] = $_GET['stock_id']; - page(_("Inventory Item Status"), true); -} else { - page(_("Inventory Item Status")); -} + +page(_($help_context = "Inventory Item Status"), isset($_GET['stock_id']), false, "", $js); 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"); +include_once($path_to_root . "/includes/db/manufacturing_db.inc"); if (list_updated('stock_id')) $Ajax->activate('status_tbl'); @@ -33,13 +35,16 @@ if (list_updated('stock_id')) check_db_has_stock_items(_("There are no items defined in the system.")); -start_form(false, true); +start_form(); if (!isset($_POST['stock_id'])) $_POST['stock_id'] = get_global_stock_item(); -echo "
" . _("Item:"). " "; -stock_items_list('stock_id', $_POST['stock_id'], false, true); +if (!$page_nested) +{ + echo "
" . _("Item:"). " "; + echo stock_costable_items_list('stock_id', $_POST['stock_id'], false, true); +} echo "
"; echo "
"; @@ -58,7 +63,7 @@ if (is_service($mb_flag)) $loc_details = get_loc_details($_POST['stock_id']); -start_table($table_style); +start_table(TABLESTYLE); if ($kitset_or_service == true) { @@ -79,77 +84,15 @@ while ($myrow = db_fetch($loc_details)) alt_table_row_color($k); - $sql = "SELECT Sum(".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent) AS DEM - FROM ".TB_PREF."sales_order_details, ".TB_PREF."sales_orders - WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no - AND ".TB_PREF."sales_orders.from_stk_loc='" . $myrow["loc_code"] . "' - AND ".TB_PREF."sales_order_details.qty_sent < ".TB_PREF."sales_order_details.quantity - AND ".TB_PREF."sales_order_details.stk_code='" . $_POST['stock_id'] . "'"; - - $demand_result = db_query($sql,"Could not retreive demand for item"); - - if (db_num_rows($demand_result) == 1) - { - $demand_row = db_fetch_row($demand_result); - $demand_qty = $demand_row[0]; - } - else - { - $demand_qty =0; - } - - $sql = "SELECT SUM((".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent)*".TB_PREF."bom.quantity) - AS DemAsm - FROM ".TB_PREF."sales_order_details, - ".TB_PREF."sales_orders, - ".TB_PREF."bom, - ".TB_PREF."stock_master - WHERE ".TB_PREF."sales_order_details.stk_code=".TB_PREF."bom.parent - AND ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no - AND ".TB_PREF."sales_orders.from_stk_loc ='" . $myrow["loc_code"] . "' - AND ".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 - AND ".TB_PREF."bom.component='" . $_POST['stock_id'] . "' - AND ".TB_PREF."stock_master.stock_id=".TB_PREF."bom.parent - AND (".TB_PREF."stock_master.mb_flag='M' OR ".TB_PREF."stock_master.mb_flag='A')"; - - $result = db_query($sql,"No transactions were returned"); - if (db_num_rows($result)==1) - { - $demand_row = db_fetch_row($result); - $demand_qty += $demand_row[0]; - } + $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) { - $sql = "SELECT Sum(".TB_PREF."purch_order_details.quantity_ordered - ".TB_PREF."purch_order_details.quantity_received) AS qoo - FROM ".TB_PREF."purch_order_details INNER JOIN ".TB_PREF."purch_orders ON ".TB_PREF."purch_order_details.order_no=".TB_PREF."purch_orders.order_no - WHERE ".TB_PREF."purch_orders.into_stock_location='" . $myrow["loc_code"] . "' - AND ".TB_PREF."purch_order_details.item_code='" . $_POST['stock_id'] . "'"; - $qoo_result = db_query($sql,"could not receive quantity on order for item"); - - if (db_num_rows($qoo_result) == 1) - { - $qoo_row = db_fetch_row($qoo_result); - $qoo = $qoo_row[0]; - } - else - { - $qoo = 0; - } - $sql = "SELECT Sum(".TB_PREF."workorders.units_reqd * ".TB_PREF."wo_requirements.units_req) AS qoo - FROM ".TB_PREF."wo_requirements INNER JOIN ".TB_PREF."workorders - ON ".TB_PREF."wo_requirements.workorder_id=".TB_PREF."workorders.id - WHERE ".TB_PREF."wo_requirements.loc_code='" . $myrow["loc_code"] . "' - AND ".TB_PREF."wo_requirements.stock_id='" . $_POST['stock_id'] . "' - AND ".TB_PREF."workorders.closed=0"; - $qoo_result = db_query($sql,"could not receive quantity on order for item"); - if (db_num_rows($qoo_result) == 1) - { - $qoo_row = db_fetch_row($qoo_result); - $qoo += $qoo_row[0]; - } + $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); @@ -180,4 +123,3 @@ div_end(); end_form(); end_page(); -?>