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

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

Revision: 5313
          http://web-erp.svn.sourceforge.net/web-erp/?rev=5313&view=rev
Author:   tehonu
Date:     2012-05-04 02:47:55 +0000 (Fri, 04 May 2012)
Log Message:
-----------
Changed order by category description

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

Modified: trunk/InventoryPlanning.php
===================================================================
--- trunk/InventoryPlanning.php	2012-05-03 08:46:12 UTC (rev 5312)
+++ trunk/InventoryPlanning.php	2012-05-04 02:47:55 UTC (rev 5313)
@@ -389,7 +389,7 @@
 		$sql="SELECT categoryid, categorydescription FROM stockcategory ORDER BY categorydescription";
 		$CatResult= DB_query($sql,$db);
 		while ($myrow = DB_fetch_array($CatResult)){
-			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categoryid'] . ' - ' . $myrow['categorydescription'] .'</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select>
 			</td>
@@ -402,7 +402,7 @@
 		DB_data_seek($CatResult,0);
 
 		while ($myrow = DB_fetch_array($CatResult)){
-			echo "<option value='" . $myrow['categoryid'] . "'>" . $myrow['categoryid'] . " - " . $myrow['categorydescription'].'</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select></td>
 			</tr>

Modified: trunk/InventoryValuation.php
===================================================================
--- trunk/InventoryValuation.php	2012-05-03 08:46:12 UTC (rev 5312)
+++ trunk/InventoryValuation.php	2012-05-04 02:47:55 UTC (rev 5313)
@@ -220,7 +220,7 @@
 				
 		$CatResult= DB_query($sql,$db);
 		While ($myrow = DB_fetch_array($CatResult)){
-			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categoryid'] . ' - ' . $myrow['categorydescription'] . '</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select></td>
 			</tr>';
@@ -233,7 +233,7 @@
 		DB_data_seek($CatResult,0);
 
 		While ($myrow = DB_fetch_array($CatResult)){
-			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categoryid'] . ' - ' . $myrow['categorydescription'] . '</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select></td>
 			</tr>';

Modified: trunk/StockCheck.php
===================================================================
--- trunk/StockCheck.php	2012-05-03 08:46:12 UTC (rev 5312)
+++ trunk/StockCheck.php	2012-05-04 02:47:55 UTC (rev 5313)
@@ -270,10 +270,10 @@
 		echo '<tr><td>' . _('From Inventory Category Code') . ':</td>
 					<td><select name="FromCriteria">';
 
-		$sql="SELECT categoryid, categorydescription FROM stockcategory ORDER BY categoryid";
+		$sql="SELECT categoryid, categorydescription FROM stockcategory ORDER BY categorydescription";
 		$CatResult= DB_query($sql,$db);
 		While ($myrow = DB_fetch_array($CatResult)){
-			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categoryid'] . ' - ' . $myrow['categorydescription'] . '</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select></td></tr>';
 
@@ -285,14 +285,14 @@
 		DB_data_seek($CatResult,0);
 
 		While ($myrow = DB_fetch_array($CatResult)){
-			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categoryid'] . ' - ' . $myrow['categorydescription'] . '</option>';
+			echo '<option value="' . $myrow['categoryid'] . '">' . $myrow['categorydescription'] . ' - ' . $myrow['categoryid'] . '</option>';
 		}
 		echo '</select></td></tr>';
 
 		echo '<tr>
 				<td>' . _('For Inventory in Location') . ':</td>
 				<td><select name="Location">';
-		$sql = "SELECT loccode, locationname FROM locations";
+		$sql = "SELECT loccode, locationname FROM locations ORDER BY locationname";
 		$LocnResult=DB_query($sql,$db);
 
 		while ($myrow=DB_fetch_array($LocnResult)){

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