[Web-erp-svn] SF.net SVN: web-erp:[6356] trunk/SelectCreditItems.php

[<ice...@us...>]

Revision: 6356
          http://sourceforge.net/p/web-erp/reponame/6356
Author:   icedlava
Date:     2013-10-16 04:46:51 +0000 (Wed, 16 Oct 2013)
Log Message:
-----------
Fix - remove  %...% from item code POST var so they do not appear in  search form field.

Modified Paths:
--------------
    trunk/SelectCreditItems.php

Modified: trunk/SelectCreditItems.php
===================================================================
--- trunk/SelectCreditItems.php	2013-10-16 01:12:19 UTC (rev 6355)
+++ trunk/SelectCreditItems.php	2013-10-16 04:46:51 UTC (rev 6356)
@@ -333,7 +333,7 @@
 			}
 
 		} elseif ($_POST['StockCode']!=''){
-			$_POST['StockCode'] = '%' . $_POST['StockCode'] . '%';
+			$SearchString = '%' . $_POST['StockCode'] . '%';
 			if ($_POST['StockCat']=='All'){
 				$SQL = "SELECT stockmaster.stockid,
 						stockmaster.description,
@@ -341,7 +341,7 @@
 					FROM stockmaster INNER JOIN stockcategory
 					ON stockmaster.categoryid=stockcategory.categoryid
 					WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D')
-					AND  stockmaster.stockid " . LIKE . " '" . $_POST['StockCode'] . "'
+					AND  stockmaster.stockid " . LIKE . " '" . $SearchString . "'
 					GROUP BY stockmaster.stockid,
 						stockmaster.description,
 						stockmaster.units
@@ -353,7 +353,7 @@
 						FROM stockmaster INNER JOIN stockcategory
 						ON stockmaster.categoryid=stockcategory.categoryid
 						WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D')
-						AND stockmaster.stockid " . LIKE . " '" . $_POST['StockCode'] . "'
+						AND stockmaster.stockid " . LIKE . " '" . $SearchString . "'
 						AND stockmaster.categoryid='" . $_POST['StockCat'] . "'
 						GROUP BY stockmaster.stockid,
 							stockmaster.description,
@@ -2001,4 +2001,4 @@
 } /*end of process credit note */
 
 include('includes/footer.inc');
-?>
\ No newline at end of file
+?>