Wed, 30 Jan 2019 16:40:23 +0100
Added two missing fields in getfermentablesources.php. When getting a single recipe from the database, update the fermentables json data with available inventory and ingredient. Added inventory column in the fermentable grid. Added ingredient selection in the fermentable popup window to replace ingredient.
61 | 1 | <?php |
2 | require_once('config.php'); | |
3 | ||
141
fe9e2a677611
The yeast droplist sorting order changed. Misc ingredients time editor uses minutes or days depending on the use of the ingredient. The yeast editor can now use grams, ml or packs.
Michiel Broek <mbroek@mbse.eu>
parents:
61
diff
changeset
|
4 | $query = "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"; |
61 | 5 | $connect = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
6 | if (! $connect) { | |
7 | echo "[]"; | |
8 | return; | |
9 | } | |
10 | $result = mysqli_query($connect, $query); | |
11 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { | |
12 | $yeasts[] = array( | |
13 | 'record' => $row['record'], | |
14 | 'name' => $row['name'], | |
15 | 'type' => $row['type'], | |
16 | 'form' => $row['form'], | |
17 | 'laboratory' => $row['laboratory'], | |
18 | 'product_id' => $row['product_id'], | |
19 | 'min_temperature' => $row['min_temperature'], | |
20 | 'max_temperature' => $row['max_temperature'], | |
21 | 'attenuation' => $row['attenuation'], | |
22 | 'inventory' => $row['inventory'], | |
23 | 'cost' => $row['cost'] | |
24 | ); | |
25 | } | |
26 | echo json_encode($yeasts); |