- $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];
- }