From ac6f8bdfc4a5a75aadbe6d63d2e451069fdcf6c9 Mon Sep 17 00:00:00 2001
From: Joe Hunt <joe.hunt.consulting@gmail.com>
Date: Thu, 10 Dec 2015 00:13:10 +0100
Subject: [PATCH] Rerun of stock list search.

---
 inventory/inquiry/stock_list.php | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git a/inventory/inquiry/stock_list.php b/inventory/inquiry/stock_list.php
index d087c41e..c0db0f69 100644
--- a/inventory/inquiry/stock_list.php
+++ b/inventory/inquiry/stock_list.php
@@ -87,7 +87,8 @@ switch ($type) {
     $sql .= " AND mb_flag != 'D' AND mb_flag != 'F' AND  i.item_code=i.stock_id";
     break;
   case "component":
-    $sql .= " AND  i.item_code=i.stock_id AND i.stock_id != ".$_GET['parent']." AND mb_flag != 'F' ";
+  	$parent = $_GET['parent'];
+    $sql .= " AND  i.item_code=i.stock_id AND i.stock_id <> '$parent' AND mb_flag != 'F' ";
     break;
   case "assets":
     $sql .= " AND mb_flag = 'F'";
-- 
2.30.2