[Web-erp-svn] SF.net SVN: web-erp:[5246] trunk

[<te...@us...>]

Revision: 5246
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5246&view=rev
Author:   tehonu
Date:     2012-04-16 01:59:04 +0000 (Mon, 16 Apr 2012)
Log Message:
-----------
Ricard: ReorderLevelLocation.php only showing items not discontinued (current).

Modified Paths:
--------------
    trunk/ReorderLevelLocation.php
    trunk/doc/Change.log

Modified: trunk/ReorderLevelLocation.php
===================================================================
--- trunk/ReorderLevelLocation.php	2012-04-15 23:54:56 UTC (rev 5245)
+++ trunk/ReorderLevelLocation.php	2012-04-16 01:59:04 UTC (rev 5246)
@@ -44,6 +44,7 @@
 			ON locstock.stockid = stockmaster.stockid
 			WHERE stockmaster.categoryid = '" . $_POST['StockCat'] . "'
 			AND locstock.loccode = '" . $_POST['StockLocation'] . "'
+			AND stockmaster.discontinued = 0
 			ORDER BY '" . $Sequence . "' ASC";
 
 	$result = DB_query($sql,$db);

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2012-04-15 23:54:56 UTC (rev 5245)
+++ trunk/doc/Change.log	2012-04-16 01:59:04 UTC (rev 5246)
@@ -1,4 +1,5 @@
 webERP Change Log
+16/04/2012 Ricard: ReorderLevelLocation.php only showing items not discontinued (current).
 14/04/2012 Ricard: Adding stock category as filter for selection in TopItems.php
 12/4/2012 TurboPT: Replaced table row bgcolor [or style=background-color] with the appropriate css class.
 11/4/2012 Ricard: Code simplified on TopItems.php 

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