comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 392
- 544d7d0183b2
- parent 375
- 7f5455806f20
- child 393
- 5020feba78ec
equal
deleted
inserted
replaced
| 391:a1bcebc61ddd | 392:544d7d0183b2 |
|---|---|
| 74 $sql .= "', brew_date_start=NULL"; | 74 $sql .= "', brew_date_start=NULL"; |
| 75 else | 75 else |
| 76 $sql .= "', brew_date_start='" . $_POST['brew_date_start'] . "'"; | 76 $sql .= "', brew_date_start='" . $_POST['brew_date_start'] . "'"; |
| 77 $sql .= ", brew_mash_ph='" . $_POST['brew_mash_ph']; | 77 $sql .= ", brew_mash_ph='" . $_POST['brew_mash_ph']; |
| 78 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; | 78 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; |
| 79 $sql .= "', brew_mash_efficiency='" . $_POST['brew_mash_efficiency']; | |
| 79 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; | 80 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; |
| 80 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; | 81 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; |
| 82 $sql .= "', brew_sparge_est='" . $_POST['brew_sparge_est']; | |
| 81 $sql .= "', brew_sparge_ph='" . $_POST['brew_sparge_ph']; | 83 $sql .= "', brew_sparge_ph='" . $_POST['brew_sparge_ph']; |
| 82 $sql .= "', brew_preboil_volume='" . $_POST['brew_preboil_volume']; | 84 $sql .= "', brew_preboil_volume='" . $_POST['brew_preboil_volume']; |
| 83 $sql .= "', brew_preboil_sg='" . $_POST['brew_preboil_sg']; | 85 $sql .= "', brew_preboil_sg='" . $_POST['brew_preboil_sg']; |
| 84 $sql .= "', brew_preboil_ph='" . $_POST['brew_preboil_ph']; | 86 $sql .= "', brew_preboil_ph='" . $_POST['brew_preboil_ph']; |
| 87 $sql .= "', brew_preboil_efficiency='" . $_POST['brew_preboil_efficiency']; | |
| 85 $sql .= "', brew_aboil_volume='" . $_POST['brew_aboil_volume']; | 88 $sql .= "', brew_aboil_volume='" . $_POST['brew_aboil_volume']; |
| 86 $sql .= "', brew_aboil_sg='" . $_POST['brew_aboil_sg']; | 89 $sql .= "', brew_aboil_sg='" . $_POST['brew_aboil_sg']; |
| 87 $sql .= "', brew_aboil_ph='" . $_POST['brew_aboil_ph']; | 90 $sql .= "', brew_aboil_ph='" . $_POST['brew_aboil_ph']; |
| 88 $sql .= "', brew_aboil_efficiency='" . $_POST['brew_aboil_efficiency']; | 91 $sql .= "', brew_aboil_efficiency='" . $_POST['brew_aboil_efficiency']; |
| 89 $sql .= "', brew_cooling_method='" . $_POST['brew_cooling_method']; | 92 $sql .= "', brew_cooling_method='" . $_POST['brew_cooling_method']; |
| 218 $sql .= "', w2_magnesium='" . $_POST['w2_magnesium']; | 221 $sql .= "', w2_magnesium='" . $_POST['w2_magnesium']; |
| 219 $sql .= "', w2_total_alkalinity='" . $_POST['w2_total_alkalinity']; | 222 $sql .= "', w2_total_alkalinity='" . $_POST['w2_total_alkalinity']; |
| 220 $sql .= "', w2_ph='" . $_POST['w2_ph']; | 223 $sql .= "', w2_ph='" . $_POST['w2_ph']; |
| 221 $sql .= "', w2_cost='" . $_POST['w2_cost']; | 224 $sql .= "', w2_cost='" . $_POST['w2_cost']; |
| 222 } | 225 } |
| 226 $sql .= "', wg_amount='" . $_POST['wg_amount']; | |
| 227 $sql .= "', wg_calcium='" . $_POST['wg_calcium']; | |
| 228 $sql .= "', wg_sulfate='" . $_POST['wg_sulfate']; | |
| 229 $sql .= "', wg_chloride='" . $_POST['wg_chloride']; | |
| 230 $sql .= "', wg_sodium='" . $_POST['wg_sodium']; | |
| 231 $sql .= "', wg_magnesium='" . $_POST['wg_magnesium']; | |
| 232 $sql .= "', wg_total_alkalinity='" . $_POST['wg_total_alkalinity']; | |
| 233 $sql .= "', wg_ph='" . $_POST['wg_ph']; | |
| 234 $sql .= "', wb_calcium='" . $_POST['wb_calcium']; | |
| 235 $sql .= "', wb_sulfate='" . $_POST['wb_sulfate']; | |
| 236 $sql .= "', wb_chloride='" . $_POST['wb_chloride']; | |
| 237 $sql .= "', wb_sodium='" . $_POST['wb_sodium']; | |
| 238 $sql .= "', wb_magnesium='" . $_POST['wb_magnesium']; | |
| 239 $sql .= "', wb_total_alkalinity='" . $_POST['wb_total_alkalinity']; | |
| 240 $sql .= "', wb_ph='" . $_POST['wb_ph']; | |
| 223 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name']; | 241 $sql .= "', wa_acid_name='" . $_POST['wa_acid_name']; |
| 224 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc']; | 242 $sql .= "', wa_acid_perc='" . $_POST['wa_acid_perc']; |
| 225 $sql .= "', wa_base_name='" . $_POST['wa_base_name']; | 243 $sql .= "', wa_base_name='" . $_POST['wa_base_name']; |
| 226 if ($_POST['starter_enable'] == 0) { | 244 if ($_POST['starter_enable'] == 0) { |
| 227 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.040"; | 245 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.040"; |
| 594 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); | 612 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); |
| 595 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); | 613 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); |
| 596 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; | 614 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; |
| 597 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); | 615 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); |
| 598 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); | 616 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); |
| 617 $brew .= ',"brew_mash_efficiency":' . floatval($row['brew_mash_efficiency']); | |
| 599 $brew .= ',"brew_sparge_temperature":' . floatval($row['brew_sparge_temperature']); | 618 $brew .= ',"brew_sparge_temperature":' . floatval($row['brew_sparge_temperature']); |
| 600 $brew .= ',"brew_sparge_volume":' . floatval($row['brew_sparge_volume']); | 619 $brew .= ',"brew_sparge_volume":' . floatval($row['brew_sparge_volume']); |
| 620 $brew .= ',"brew_sparge_est":' . floatval($row['brew_sparge_est']); | |
| 601 $brew .= ',"brew_sparge_ph":' . floatval($row['brew_sparge_ph']); | 621 $brew .= ',"brew_sparge_ph":' . floatval($row['brew_sparge_ph']); |
| 602 $brew .= ',"brew_preboil_volume":' . floatval($row['brew_preboil_volume']); | 622 $brew .= ',"brew_preboil_volume":' . floatval($row['brew_preboil_volume']); |
| 603 $brew .= ',"brew_preboil_sg":' . floatval($row['brew_preboil_sg']); | 623 $brew .= ',"brew_preboil_sg":' . floatval($row['brew_preboil_sg']); |
| 604 $brew .= ',"brew_preboil_ph":' . floatval($row['brew_preboil_ph']); | 624 $brew .= ',"brew_preboil_ph":' . floatval($row['brew_preboil_ph']); |
| 625 $brew .= ',"brew_preboil_efficiency":' . floatval($row['brew_preboil_efficiency']); | |
| 605 $brew .= ',"brew_aboil_volume":' . floatval($row['brew_aboil_volume']); | 626 $brew .= ',"brew_aboil_volume":' . floatval($row['brew_aboil_volume']); |
| 606 $brew .= ',"brew_aboil_sg":' . floatval($row['brew_aboil_sg']); | 627 $brew .= ',"brew_aboil_sg":' . floatval($row['brew_aboil_sg']); |
| 607 $brew .= ',"brew_aboil_ph":' . floatval($row['brew_aboil_ph']); | 628 $brew .= ',"brew_aboil_ph":' . floatval($row['brew_aboil_ph']); |
| 608 $brew .= ',"brew_aboil_efficiency":' . floatval($row['brew_aboil_efficiency']); | 629 $brew .= ',"brew_aboil_efficiency":' . floatval($row['brew_aboil_efficiency']); |
| 609 $brew .= ',"brew_cooling_method":' . $row['brew_cooling_method']; | 630 $brew .= ',"brew_cooling_method":' . $row['brew_cooling_method']; |
| 715 $brew .= ',"w2_sodium":' . floatval($row['w2_sodium']); | 736 $brew .= ',"w2_sodium":' . floatval($row['w2_sodium']); |
| 716 $brew .= ',"w2_magnesium":' . floatval($row['w2_magnesium']); | 737 $brew .= ',"w2_magnesium":' . floatval($row['w2_magnesium']); |
| 717 $brew .= ',"w2_total_alkalinity":' . floatval($row['w2_total_alkalinity']); | 738 $brew .= ',"w2_total_alkalinity":' . floatval($row['w2_total_alkalinity']); |
| 718 $brew .= ',"w2_ph":' . floatval($row['w2_ph']); | 739 $brew .= ',"w2_ph":' . floatval($row['w2_ph']); |
| 719 $brew .= ',"w2_cost":' . floatval($row['w2_cost']); | 740 $brew .= ',"w2_cost":' . floatval($row['w2_cost']); |
| 741 $brew .= ',"wg_amount":' . floatval($row['wg_amount']); | |
| 742 $brew .= ',"wg_calcium":' . floatval($row['wg_calcium']); | |
| 743 $brew .= ',"wg_sulfate":' . floatval($row['wg_sulfate']); | |
| 744 $brew .= ',"wg_chloride":' . floatval($row['wg_chloride']); | |
| 745 $brew .= ',"wg_sodium":' . floatval($row['wg_sodium']); | |
| 746 $brew .= ',"wg_magnesium":' . floatval($row['wg_magnesium']); | |
| 747 $brew .= ',"wg_total_alkalinity":' . floatval($row['wg_total_alkalinity']); | |
| 748 $brew .= ',"wg_ph":' . floatval($row['wg_ph']); | |
| 749 $brew .= ',"wb_calcium":' . floatval($row['wb_calcium']); | |
| 750 $brew .= ',"wb_sulfate":' . floatval($row['wb_sulfate']); | |
| 751 $brew .= ',"wb_chloride":' . floatval($row['wb_chloride']); | |
| 752 $brew .= ',"wb_sodium":' . floatval($row['wb_sodium']); | |
| 753 $brew .= ',"wb_magnesium":' . floatval($row['wb_magnesium']); | |
| 754 $brew .= ',"wb_total_alkalinity":' . floatval($row['wb_total_alkalinity']); | |
| 755 $brew .= ',"wb_ph":' . floatval($row['wb_ph']); | |
| 720 $brew .= ',"wa_acid_name":' . $row['wa_acid_name']; | 756 $brew .= ',"wa_acid_name":' . $row['wa_acid_name']; |
| 721 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc']; | 757 $brew .= ',"wa_acid_perc":' . $row['wa_acid_perc']; |
| 722 $brew .= ',"wa_base_name":' . $row['wa_base_name']; | 758 $brew .= ',"wa_base_name":' . $row['wa_base_name']; |
| 723 $brew .= ',"starter_enable":' . $row['starter_enable']; | 759 $brew .= ',"starter_enable":' . $row['starter_enable']; |
| 724 $brew .= ',"starter_type":' . $row['starter_type']; | 760 $brew .= ',"starter_type":' . $row['starter_type']; |
