X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=manufacturing%2Fincludes%2Fdb%2Fwork_orders_db.inc;h=d8894401ce1de2a93e98be17324bafc695c46324;hb=7c5836f0236b223954d803717762a15942ec0ca2;hp=0a45ecb747e85156be452614fd0f099301141ac1;hpb=68babd2d144debdc16a783f78c13be4a39d714bb;p=fa-stable.git diff --git a/manufacturing/includes/db/work_orders_db.inc b/manufacturing/includes/db/work_orders_db.inc index 0a45ecb7..d8894401 100644 --- a/manufacturing/includes/db/work_orders_db.inc +++ b/manufacturing/includes/db/work_orders_db.inc @@ -534,6 +534,11 @@ function get_sql_for_work_orders($outstanding_only, $all_items) $sql .= " AND workorder.loc_code=".db_escape($_POST['StockLocation']); } + if (isset($_POST['OrderId']) && $_POST['OrderId'] != "") + { + $sql .= " AND workorder.id LIKE ".db_escape('%'.$_POST['OrderId'].'%'); + } + if (isset($_POST['OrderNumber']) && $_POST['OrderNumber'] != "") { $sql .= " AND workorder.wo_ref LIKE ".db_escape('%'.$_POST['OrderNumber'].'%');