Improved hop selection dropdown

Wed, 26 Sep 2018 11:45:10 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Wed, 26 Sep 2018 11:45:10 +0200
changeset 69
ca25fdce3b85
parent 68
2ff83855d574
child 70
4da2414eabbc

Improved hop selection dropdown

www/gethopsources.php file | annotate | diff | comparison | revisions
www/import/from_brouwhulp.php file | annotate | diff | comparison | revisions
www/js/rec_edit.js file | annotate | diff | comparison | revisions
--- a/www/gethopsources.php	Tue Sep 25 20:58:06 2018 +0200
+++ b/www/gethopsources.php	Wed Sep 26 11:45:10 2018 +0200
@@ -1,7 +1,7 @@
 <?php
 require_once('config.php');
 
-$query = "SELECT * FROM inventory_hops ORDER BY name";
+$query = "SELECT * FROM inventory_hops ORDER BY origin,name";
 $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
 if (! $connect) {
 	echo "[]";
--- a/www/import/from_brouwhulp.php	Tue Sep 25 20:58:06 2018 +0200
+++ b/www/import/from_brouwhulp.php	Wed Sep 26 11:45:10 2018 +0200
@@ -106,7 +106,7 @@
 			$sql .= "', myrcene='" . $hop->MYCRENE;
 		if ($hop->HSI)
 			$sql .= "', hsi='" . $hop->HSI;
-		$sql .= "', useat='" . $hop->USE;
+		$sql .= "', useat='Boil";	// brouwhulp says Aroma always :)
 		$sql .= "', type='" . $hop->TYPE;
 		$sql .= "', form='" . $hop->FORM;
 		$sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES);
--- a/www/js/rec_edit.js	Tue Sep 25 20:58:06 2018 +0200
+++ b/www/js/rec_edit.js	Wed Sep 26 11:45:10 2018 +0200
@@ -424,7 +424,12 @@
                                         displayMember: "name",
                                         width: 150,
                                         height: 27,
-                                        dropDownWidth: 300
+                                        dropDownWidth: 500,
+					dropDownHeight: 500,
+					renderer: function (index, label, value) {
+						var datarecord = hoplist.records[index];
+						return datarecord.origin+ " / " + datarecord.name + " (" + datarecord.alpha + "% &alpha;)";
+					}
                                 });
                                 $("#haddrowbutton").on('select', function (event) {
                                         if (event.args) {

mercurial