-function getCustQty($stockid, $location)
-{
- $sql = "SELECT SUM(".TB_PREF."sales_order_details.quantity - ".TB_PREF."sales_order_details.qty_sent) AS qty_demand
- FROM ".TB_PREF."sales_order_details,
- ".TB_PREF."sales_orders
- WHERE ".TB_PREF."sales_order_details.order_no=".TB_PREF."sales_orders.order_no AND ";
- if ($location != "")
- $sql .= TB_PREF."sales_orders.from_stk_loc ='$location' AND ";
- $sql .= TB_PREF."sales_order_details.stk_code = '$stockid'";
-
- $TransResult = db_query($sql,"No transactions were returned");
- $DemandRow = db_fetch($TransResult);
- return $DemandRow['qty_demand'];
-}
-
-function getCustAsmQty($stockid, $location)
-{
- $sql = "SELECT SUM((".TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent)*".TB_PREF."bom.quantity)
- AS Dem
- 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 ";
- if ($location != "")
- $sql .= TB_PREF."sales_orders.from_stk_loc ='$location' AND ";
- $sql .= TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 AND
- ".TB_PREF."bom.component='$stockid' AND
- ".TB_PREF."stock_master.stock_id=".TB_PREF."bom.parent AND
- ".TB_PREF."stock_master.mb_flag='A'";
-
- $TransResult = db_query($sql,"No transactions were returned");
- if (db_num_rows($TransResult) == 1)
- {
- $DemandRow = db_fetch_row($TransResult);
- $DemandQty = $DemandRow[0];
- }
- else
- $DemandQty = 0.0;
-
- return $DemandQty;
-}
-
-function getSuppQty($stockid, $location)
-{
- $sql = "SELECT SUM(".TB_PREF."purch_order_details.quantity_ordered - ".TB_PREF."purch_order_details.quantity_received) AS QtyOnOrder
- FROM ".TB_PREF."purch_order_details,
- ".TB_PREF."purch_orders
- WHERE ".TB_PREF."purch_order_details.order_no = ".TB_PREF."purch_orders.order_no
- AND ".TB_PREF."purch_order_details.item_code = '$stockid'";
- if ($location != "")
- $sql .= " AND ".TB_PREF."purch_orders.into_stock_location= '$location'";
-
- $TransResult = db_query($sql,"No transactions were returned");
- $DemandRow = db_fetch($TransResult);
- return $DemandRow['QtyOnOrder'];
-}
-