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

[<ex...@us...>]

Revision: 7272
          http://sourceforge.net/p/web-erp/reponame/7272
Author:   exsonqu
Date:     2015-04-26 02:33:51 +0000 (Sun, 26 Apr 2015)
Log Message:
-----------
26/04/15 Exson: Fixed raw material sellable broken bug introduced by myself in 6720.

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

Modified: trunk/SelectOrderItems.php
===================================================================
--- trunk/SelectOrderItems.php	2015-04-23 14:00:44 UTC (rev 7271)
+++ trunk/SelectOrderItems.php	2015-04-26 02:33:51 UTC (rev 7272)
@@ -727,9 +727,9 @@
 						custitem.cust_part,
 						custitem.cust_description
 				FROM stockmaster INNER JOIN stockcategory
-				ON stockmaster.categoryid=stockcategory.categoryid
+				ON stockmaster.categoryid=stockcategory.categoryid 
 				" . $IncludeCustItem . "
-				WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D' OR stockcategory.stocktype='L')
+				WHERE (stockcategory.stocktype='F' OR stockcategory.stocktype='D' OR stockcategory.stocktype='L' " . $RawMaterialSellable . ")
 				AND stockmaster.mbflag <>'G'
 				AND stockmaster.discontinued=0 ";
 
@@ -1850,4 +1850,4 @@
 		$result = DB_query($sql,$ErrMsg,$DbgMsg);
 		return $result;
 }
-?>
\ No newline at end of file
+?>