www/getyeastsources.php@faedcfa0610f (annotated)
www/getyeastsources.php
Sun, 31 Mar 2019 20:14:34 +0200
- author
- Michiel Broek <mbroek@mbse.eu>
- date
- Sun, 31 Mar 2019 20:14:34 +0200
- changeset 337
- faedcfa0610f
- parent 296
- 69fadd1aded2
- child 554
- c62ff53cfc3d
- permissions
- -rw-r--r--
Added command to turn lights on in monitor fermenter when a camera is started. Added the missing tolerance field when selecting a new yeast in a product or recipe.
| 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'], | |
|
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
141
diff
changeset
|
21 | 'flocculation' => $row['flocculation'], |
| 61 | 22 | 'attenuation' => $row['attenuation'], |
|
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
141
diff
changeset
|
23 | 'cells' => $row['cells'], |
| 61 | 24 | 'inventory' => $row['inventory'], |
|
337
faedcfa0610f
Added command to turn lights on in monitor fermenter when a camera is started. Added the missing tolerance field when selecting a new yeast in a product or recipe.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
25 | 'cost' => $row['cost'], |
|
faedcfa0610f
Added command to turn lights on in monitor fermenter when a camera is started. Added the missing tolerance field when selecting a new yeast in a product or recipe.
Michiel Broek <mbroek@mbse.eu>
parents:
296
diff
changeset
|
26 | 'tolerance' => $row['tolerance'] |
| 61 | 27 | ); |
| 28 | } | |
|
296
69fadd1aded2
Updated design document. Add content header application/json to all scripts that produce json output. Chart prints show the beer code and name in the header. Charts don't display the menu anymore.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
29 | header("Content-type: application/json"); |
| 61 | 30 | echo json_encode($yeasts); |
