X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=inventory%2Finquiry%2Fstock_status.php;h=331ea38321fc7290e7f22f166d3ebbafaaa20533;hb=939337a739e521fc7d69ab30a7d89177b51a3bb3;hp=c683fa950868af4e20df9e77684a40998a109055;hpb=8c83c09db95c22618519f7f0cc7a977c7cbb4068;p=fa-stable.git diff --git a/inventory/inquiry/stock_status.php b/inventory/inquiry/stock_status.php index c683fa95..331ea383 100644 --- a/inventory/inquiry/stock_status.php +++ b/inventory/inquiry/stock_status.php @@ -79,77 +79,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);