[Web-erp-svn] SF.net SVN: web-erp:[5437] trunk/InventoryValuation.php

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

Revision: 5437
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5437&view=rev
Author:   tehonu
Date:     2012-06-14 08:05:15 +0000 (Thu, 14 Jun 2012)
Log Message:
-----------
Change ORDER BY to be consistent with stock category description selection

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

Modified: trunk/InventoryValuation.php
===================================================================
--- trunk/InventoryValuation.php	2012-06-12 10:08:35 UTC (rev 5436)
+++ trunk/InventoryValuation.php	2012-06-14 08:05:15 UTC (rev 5437)
@@ -48,7 +48,7 @@
 				HAVING SUM(locstock.quantity)!=0
 				AND stockcategory.categorydescription >= '" . $_POST['FromCriteria'] . "'
 				AND stockcategory.categorydescription <= '" . $_POST['ToCriteria'] . "'
-				ORDER BY stockmaster.categoryid,
+				ORDER BY stockcategory.categorydescription,
 					stockmaster.stockid";
 	} else {
 		$SQL = "SELECT stockmaster.categoryid,
@@ -69,7 +69,7 @@
 				AND stockcategory.categorydescription >= '" . $_POST['FromCriteria'] . "'
 				AND stockcategory.categorydescription <= '" . $_POST['ToCriteria'] . "'
 				AND locstock.loccode = '" . $_POST['Location'] . "'
-				ORDER BY stockmaster.categoryid,
+				ORDER BY stockcategory.categorydescription,
 					stockmaster.stockid";
 	}
 	$InventoryResult = DB_query($SQL,$db,'','',false,true);

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