Bugs in sending sales orders as email.

[fa-stable.git] / inventory / inquiry / stock_status.php

diff --git a/inventory/inquiry/stock_status.php b/inventory/inquiry/stock_status.php
index c683fa950868af4e20df9e77684a40998a109055..331ea38321fc7290e7f22f166d3ebbafaaa20533 100644 (file)
--- 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);