From 7c5836f0236b223954d803717762a15942ec0ca2 Mon Sep 17 00:00:00 2001
From: Joe <unknown>
Date: Thu, 19 Feb 2015 10:17:41 +0100
Subject: [PATCH] Allow search by Id in search work orders.

---
 manufacturing/includes/db/work_orders_db.inc | 5 +++++
 manufacturing/search_work_orders.php         | 6 ++++++
 2 files changed, 11 insertions(+)

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'].'%');
diff --git a/manufacturing/search_work_orders.php b/manufacturing/search_work_orders.php
index 7610a1cb..024c3b85 100644
--- a/manufacturing/search_work_orders.php
+++ b/manufacturing/search_work_orders.php
@@ -64,10 +64,16 @@ start_form(false, false, $_SERVER['PHP_SELF'] ."?outstanding_only=$outstanding_o
 
 start_table(TABLESTYLE_NOBORDER);
 start_row();
+ref_cells(_("#:"), 'OrderId', '',null, '', true);
 ref_cells(_("Reference:"), 'OrderNumber', '',null, '', true);
 
 locations_list_cells(_("at Location:"), 'StockLocation', null, true);
 
+end_row();
+end_table();
+start_table(TABLESTYLE_NOBORDER);
+start_row();
+
 check_cells( _("Only Overdue:"), 'OverdueOnly', null);
 
 if ($outstanding_only==0)
-- 
2.30.2