comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 278
- dc22dd5d77fd
- parent 254
- 3d61397fe9cd
- child 285
- 0ea9dfb3fce9
equal
deleted
inserted
replaced
| 277:7776b3c68c46 | 278:dc22dd5d77fd |
|---|---|
| 228 $sql .= "', w2_cost='" . $_POST['w2_cost']; | 228 $sql .= "', w2_cost='" . $_POST['w2_cost']; |
| 229 } | 229 } |
| 230 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name']; | 230 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name']; |
| 231 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc']; | 231 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc']; |
| 232 $sql .= "', wa_base_name='" . $_POST['wa_base_name']; | 232 $sql .= "', wa_base_name='" . $_POST['wa_base_name']; |
| 233 $sql .= "', starter_enable='" . $_POST['starter_enable']; | |
| 234 $sql .= "', starter_type='" . $_POST['starter_type']; | |
| 235 $sql .= "', starter_sg='" . $_POST['starter_sg']; | |
| 236 $sql .= "', prop1_type='" . $_POST['prop1_type']; | |
| 237 $sql .= "', prop1_volume='" . $_POST['prop1_volume']; | |
| 238 $sql .= "', prop2_type='" . $_POST['prop2_type']; | |
| 239 $sql .= "', prop2_volume='" . $_POST['prop2_volume']; | |
| 240 $sql .= "', prop3_type='" . $_POST['prop3_type']; | |
| 241 $sql .= "', prop3_volume='" . $_POST['prop3_volume']; | |
| 242 $sql .= "', prop4_type='" . $_POST['prop4_type']; | |
| 243 $sql .= "', prop4_volume='" . $_POST['prop4_volume']; | |
| 233 syslog(LOG_NOTICE, $sql); | 244 syslog(LOG_NOTICE, $sql); |
| 234 | 245 |
| 235 $fermentables = '['; | 246 $fermentables = '['; |
| 236 $comma = FALSE; | 247 $comma = FALSE; |
| 237 if (isset($_POST['fermentables'])) { | 248 if (isset($_POST['fermentables'])) { |
| 629 $brew .= ',"w2_ph":' . $row['w2_ph']; | 640 $brew .= ',"w2_ph":' . $row['w2_ph']; |
| 630 $brew .= ',"w2_cost":' . $row['w2_cost']; | 641 $brew .= ',"w2_cost":' . $row['w2_cost']; |
| 631 $brew .= ',"wa_acid_name":' . $row['wa_acid_name']; | 642 $brew .= ',"wa_acid_name":' . $row['wa_acid_name']; |
| 632 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc']; | 643 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc']; |
| 633 $brew .= ',"wa_base_name":' . $row['wa_base_name']; | 644 $brew .= ',"wa_base_name":' . $row['wa_base_name']; |
| 645 $brew .= ',"starter_enable":' . $row['starter_enable']; | |
| 646 $brew .= ',"starter_type":' . $row['starter_type']; | |
| 647 $brew .= ',"starter_sg":' . $row['starter_sg']; | |
| 648 $brew .= ',"prop1_type":' . $row['prop1_type']; | |
| 649 $brew .= ',"prop1_volume":' . $row['prop1_volume']; | |
| 650 $brew .= ',"prop2_type":' . $row['prop2_type']; | |
| 651 $brew .= ',"prop2_volume":' . $row['prop2_volume']; | |
| 652 $brew .= ',"prop3_type":' . $row['prop3_type']; | |
| 653 $brew .= ',"prop3_volume":' . $row['prop3_volume']; | |
| 654 $brew .= ',"prop4_type":' . $row['prop4_type']; | |
| 655 $brew .= ',"prop4_volume":' . $row['prop4_volume']; | |
| 656 | |
| 634 if (isset($_GET['record'])) { | 657 if (isset($_GET['record'])) { |
| 635 // Append stock information. | 658 // Append stock information. |
| 636 $fermentables = json_decode($row['json_fermentables'], true); | 659 $fermentables = json_decode($row['json_fermentables'], true); |
| 637 for ($i = 0; $i < count($fermentables); $i++) { | 660 for ($i = 0; $i < count($fermentables); $i++) { |
| 638 $fermentables[$i]['f_inventory'] = 0; // Not in stock | 661 $fermentables[$i]['f_inventory'] = 0; // Not in stock |
