[Web-erp-svn] SF.net SVN: web-erp:[5325] trunk/SelectOrderItems.php

[<Ex...@us...>]

Revision: 5325
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5325&view=rev
Author:   ExsonQu
Date:     2012-05-08 06:12:35 +0000 (Tue, 08 May 2012)
Log Message:
-----------
8/05/2012 Exson Fix typo and add 'L' type for selection in SelectOrderItems.php.

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

Modified: trunk/SelectOrderItems.php
===================================================================
--- trunk/SelectOrderItems.php	2012-05-08 06:07:46 UTC (rev 5324)
+++ trunk/SelectOrderItems.php	2012-05-08 06:12:35 UTC (rev 5325)
@@ -750,7 +750,7 @@
 								stockmaster.units
 						FROM stockmaster INNER JOIN stockcategory
 						ON stockmaster.categoryid=stockcategory.categoryid
-						WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D' stockcategory.stocktype='L')
+						WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D' OR stockcategory.stocktype='L')
 						AND stockmaster.mbflag <>'G'
 						AND stockmaster.description " . LIKE . " '" . $SearchString . "'
 						AND stockmaster.discontinued=0
@@ -1631,7 +1631,7 @@
 		$SQL="SELECT categoryid,
 						categorydescription
 				FROM stockcategory
-				WHERE stocktype='F' OR stocktype='D'
+				WHERE stocktype='F' OR stocktype='D' OR stocktype='L'
 				ORDER BY categorydescription";
 
 		$result1 = DB_query($SQL,$db);

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.