From e9edcdc75487682714ecf16d682d49d0a332abc9 Mon Sep 17 00:00:00 2001 From: Janusz Dobrowolski Date: Thu, 11 Oct 2018 11:15:10 +0200 Subject: [PATCH] [0004735] Search Outstanding Work Orders: voided work orders excluded. --- manufacturing/includes/db/work_orders_db.inc | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/manufacturing/includes/db/work_orders_db.inc b/manufacturing/includes/db/work_orders_db.inc index e1b0329e..5c7210e5 100644 --- a/manufacturing/includes/db/work_orders_db.inc +++ b/manufacturing/includes/db/work_orders_db.inc @@ -312,11 +312,13 @@ function get_sql_for_work_orders($outstanding_only, $stock_id, $location = ALL_T workorder.released, workorder.stock_id, unit.decimals - FROM ".TB_PREF."workorders as workorder," + FROM ".TB_PREF."workorders as workorder + LEFT JOIN ".TB_PREF."voided v ON v.id=workorder.id and v.type=".ST_WORKORDER."," .TB_PREF."stock_master as item," .TB_PREF."item_units as unit," .TB_PREF."locations as location - WHERE workorder.stock_id=item.stock_id + WHERE ISNULL(v.id) + AND workorder.stock_id=item.stock_id AND workorder.loc_code=location.loc_code AND item.units=unit.abbr"; -- 2.30.2