[Web-erp-svn] SF.net SVN: web-erp:[6898] trunk/SalesGraph.php

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

Revision: 6898
          http://sourceforge.net/p/web-erp/reponame/6898
Author:   tehonu
Date:     2014-09-21 10:07:59 +0000 (Sun, 21 Sep 2014)
Log Message:
-----------
Added ORDER BY to area, stock category and sales person drop down (ordered by the field shown to user)

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

Modified: trunk/SalesGraph.php
===================================================================
--- trunk/SalesGraph.php	2014-09-21 05:07:16 UTC (rev 6897)
+++ trunk/SalesGraph.php	2014-09-21 10:07:59 UTC (rev 6898)
@@ -91,7 +91,7 @@
 	}
 	echo '</select></td></tr>';
 
-	$AreasResult = DB_query("SELECT areacode, areadescription FROM areas",$db);
+	$AreasResult = DB_query("SELECT areacode, areadescription FROM areas ORDER BY areadescription",$db);
 
 	if (!isset($_POST['SalesArea'])){
 		$_POST['SalesArea']='';
@@ -113,7 +113,7 @@
 	}
 	echo '</select></td></tr>';
 
-	$CategoriesResult = DB_query("SELECT categoryid, categorydescription FROM stockcategory",$db);
+	$CategoriesResult = DB_query("SELECT categoryid, categorydescription FROM stockcategory ORDER BY categorydescription",$db);
 
 	if (!isset($_POST['CategoryID'])){
 		$_POST['CategoryID']='';
@@ -135,7 +135,7 @@
 	}
 	echo '</select></td></tr>';
 
-	$SalesFolkResult = DB_query("SELECT salesmancode, salesmanname FROM salesman",$db);
+	$SalesFolkResult = DB_query("SELECT salesmancode, salesmanname FROM salesman ORDER BY salesmanname",$db);
 
 	if (! isset($_POST['SalesmanCode'])){
  		$_POST['SalesmanCode'] = '';
@@ -162,7 +162,7 @@
 		</tr>';
 
 	echo '<tr>
-			<td>' . _('Graph Type') . '</td
+			<td>' . _('Graph Type') . '</td>
 			<td><select name="GraphType">
 				<option value="bars">' . _('Bar Graph') . '</option>
 				<option value="stackedbars">' . _('Stacked Bar Graph') . '</option>