[Web-erp-svn] SF.net SVN: web-erp:[6507] trunk/PriceMatrix.php

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

Revision: 6507
          http://sourceforge.net/p/web-erp/reponame/6507
Author:   exsonqu
Date:     2013-12-22 01:21:47 +0000 (Sun, 22 Dec 2013)
Log Message:
-----------
22/12/2013 Exson: Modify the stock select element to a combox box which autocomplete the limited stock ID options to 300. Otherwise, users have to input an stock ID themselves. To avoid a too long stock list as pointed by Tim.

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

Modified: trunk/PriceMatrix.php
===================================================================
--- trunk/PriceMatrix.php	2013-12-21 09:45:05 UTC (rev 6506)
+++ trunk/PriceMatrix.php	2013-12-22 01:21:47 UTC (rev 6507)
@@ -103,21 +103,18 @@
 echo '</select></td></tr>';
 
 
-$sql = "SELECT stockid FROM stockmaster WHERE stockid <>''";
+$sql = "SELECT stockid FROM stockmaster WHERE stockid <>'' LIMIT 300";//if the quantity is over, users have to input it himselves
 $result = DB_query($sql, $db);
 if (DB_num_rows($result) > 0) {
 	echo '<tr>
-			<td>' .  _('Stock Code') .': </td>
-			<td><select name="StockID">';
+		<td>' .  _('Stock Code') .': </td>
+		<td><input type="text" name="StockID" list="StockList" /></td>';
+	echo	'<datalist id="StockList">';
 
 	while ($myrow = DB_fetch_array($result)){
-		if ($myrow['stockid']==$_POST['DiscCat']){
-			echo '<option selected="selected" value="' . $myrow['stockid'] . '">' . $myrow['stockid'] . '</option>';
-		} else {
 			echo '<option value="' . $myrow['stockid'] . '">' . $myrow['stockid'] . '</option>';
-		}
 	}
-	echo '</select></td></tr>';
+		echo '</datalist>';
 } else {
 	echo '<tr><td><input type="hidden" name="StockID" value="" /></td></tr>';
 }