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 ";
+ .TB_PREF."sales_orders.order_no AND ".TB_PREF."sales_orders.trans_type=".ST_SALESORDER." AND
+ ".TB_PREF."sales_orders.trans_type=".TB_PREF."sales_order_details.trans_type AND ";
if ($location != "")
$sql .= TB_PREF."sales_orders.from_stk_loc =".db_escape($location)." AND ";
$sql .= TB_PREF."sales_order_details.stk_code = ".db_escape($stock_id);
$qoh_stock = array();
load_stock_levels($location);
}
- $stock_qty = $qoh_stock[$stock_id];
- if ($stock_qty == NULL) $stock_qty = 0;
+ if (empty($qoh_stock[$stock_id])) $stock_qty = 0;
+ else $stock_qty = $qoh_stock[$stock_id];
if ($qty <= $stock_qty) return $demand;
- $bom = $bom_list[$stock_id];
+ $bom = @$bom_list[$stock_id];
if ($bom == NULL) {
$sql = "SELECT parent, component, quantity FROM "
.TB_PREF."bom WHERE parent = ".db_escape($stock_id);
FROM ".TB_PREF."sales_order_details,
".TB_PREF."sales_orders,
".TB_PREF."stock_master
- WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no AND ";
+ WHERE ".TB_PREF."sales_orders.order_no = ".TB_PREF."sales_order_details.order_no AND
+ ".TB_PREF."sales_orders.trans_type=".ST_SALESORDER." AND
+ ".TB_PREF."sales_orders.trans_type=".TB_PREF."sales_order_details.trans_type AND ";
if ($location != "")
$sql .= TB_PREF."sales_orders.from_stk_loc =".db_escape($location)." AND ";
$sql .= TB_PREF."sales_order_details.quantity-".TB_PREF."sales_order_details.qty_sent > 0 AND
}
//--------------------------------------------------------------------------------------
-function update_bom($selected_parent, $selected_component, $work_centre_added, $loc_code, $quantity)
+function update_bom($selected_parent, $selected_component, $workcentre_added, $loc_code, $quantity)
{
$sql = "UPDATE ".TB_PREF."bom SET workcentre_added=".db_escape($workcentre_added)
. ",loc_code=".db_escape($loc_code) . ",