comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 149
- ff45488d480e
- parent 121
- 875aeb365e1c
- child 151
- 2c9cfe2f0860
equal
deleted
inserted
replaced
| 148:c0f0bbfefd63 | 149:ff45488d480e |
|---|---|
| 52 $sql .= "', eq_lauter_height='" . $_POST['eq_lauter_height']; | 52 $sql .= "', eq_lauter_height='" . $_POST['eq_lauter_height']; |
| 53 $sql .= "', eq_lauter_deadspace='" . $_POST['eq_lauter_deadspace']; | 53 $sql .= "', eq_lauter_deadspace='" . $_POST['eq_lauter_deadspace']; |
| 54 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; | 54 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; |
| 55 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; | 55 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; |
| 56 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; | 56 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; |
| 57 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; | |
| 57 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; | 58 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; |
| 58 | 59 |
| 60 // brew_date_start | |
| 61 // brew_mash_ph | |
| 62 // brew_mash_sg | |
| 63 // brew_sparge_temperature | |
| 64 // brew_sparge_volume | |
| 65 // brew_sparge_ph | |
| 66 // brew_preboil_volume | |
| 67 // brew_preboil_sg | |
| 68 // brew_preboil_ph | |
| 69 // brew_aboil_volume | |
| 70 // brew_aboil_sg | |
| 71 // brew_aboil_ph | |
| 72 // brew_aboil_efficiency | |
| 73 // brew_cooling_method | |
| 74 // brew_cooling_time | |
| 75 // brew_cooling_to | |
| 76 // brew_whirlpool9 | |
| 77 // brew_whirlpool7 | |
| 78 // brew_whirlpool6 | |
| 79 // brew_whirlpool2 | |
| 80 // brew_fermenter_volume | |
| 81 // brew_fermenter_extrawater | |
| 82 // brew_aeration_time | |
| 83 // brew_aeration_speed | |
| 84 // brew_aeration_type | |
| 85 // brew_fermenter_sg | |
| 86 // brew_fermenter_ibu | |
| 87 // brew_date_end | |
| 88 // brew_log_available | |
| 89 // primary_start_temp | |
| 90 // primary_max_temp | |
| 91 // primary_end_temp | |
| 92 // primary_end_sg | |
| 93 // primary_end_date | |
| 94 // secondary_temp | |
| 95 // secondary_end_date | |
| 96 // tertiary_temp | |
| 97 // package_date | |
| 98 // bottle_amount | |
| 99 // bottle_carbonation | |
| 100 // bottle_priming_sugar | |
| 101 // bottle_priming_amount | |
| 102 // bottle_carbonation_temp | |
| 103 // keg_amount | |
| 104 // keg_carbonation | |
| 105 // keg_priming_sugar | |
| 106 // keg_priming_amount | |
| 107 // keg_carbonation_temp | |
| 108 // keg_forced_carb | |
| 109 // keg_pressure | |
| 110 // keg_priming_factor | |
| 111 // taste_notes | |
| 112 // taste_rate | |
| 113 // taste_date | |
| 114 // taste_color | |
| 115 // taste_transparency | |
| 116 // taste_head | |
| 117 // taste_aroma | |
| 118 // taste_taste | |
| 119 // taste_mouthfeel | |
| 120 // taste_aftertaste | |
| 59 syslog(LOG_NOTICE, $sql); | 121 syslog(LOG_NOTICE, $sql); |
| 60 if (isset($_POST['insert'])) { | 122 if (isset($_POST['insert'])) { |
| 61 $sql .= "';"; | 123 $sql .= "';"; |
| 62 } | 124 } |
| 63 if (isset($_POST['update'])) { | 125 if (isset($_POST['update'])) { |
| 170 $brew .= ',"eq_lauter_height":' . floatval($row['eq_lauter_height']); | 232 $brew .= ',"eq_lauter_height":' . floatval($row['eq_lauter_height']); |
| 171 $brew .= ',"eq_lauter_deadspace":' . floatval($row['eq_lauter_deadspace']); | 233 $brew .= ',"eq_lauter_deadspace":' . floatval($row['eq_lauter_deadspace']); |
| 172 $brew .= ',"eq_kettle_volume":' . floatval($row['eq_kettle_volume']); | 234 $brew .= ',"eq_kettle_volume":' . floatval($row['eq_kettle_volume']); |
| 173 $brew .= ',"eq_kettle_height":' . floatval($row['eq_kettle_height']); | 235 $brew .= ',"eq_kettle_height":' . floatval($row['eq_kettle_height']); |
| 174 $brew .= ',"eq_mash_volume":' . floatval($row['eq_mash_volume']); | 236 $brew .= ',"eq_mash_volume":' . floatval($row['eq_mash_volume']); |
| 237 $brew .= ',"eq_mash_max":' . floatval($row['eq_mash_max']); | |
| 175 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); | 238 $brew .= ',"eq_efficiency":' . floatval($row['eq_efficiency']); |
| 176 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); | 239 $brew .= ',"eq_top_up_water":' . floatval($row['eq_top_up_water']); |
| 177 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; | 240 $brew .= ',"brew_date_start":"' . $row['brew_date_start']; |
| 178 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); | 241 $brew .= '","brew_mash_ph":' . floatval($row['brew_mash_ph']); |
| 179 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); | 242 $brew .= ',"brew_mash_sg":' . floatval($row['brew_mash_sg']); |
| 265 $brew .= ',"est_carb":' . floatval($row['est_carb']); | 328 $brew .= ',"est_carb":' . floatval($row['est_carb']); |
| 266 $brew .= ',"est_color":' . floatval($row['est_color']); | 329 $brew .= ',"est_color":' . floatval($row['est_color']); |
| 267 $brew .= ',"color_method":"' . $row['color_method']; | 330 $brew .= ',"color_method":"' . $row['color_method']; |
| 268 $brew .= '","est_ibu":' . floatval($row['est_ibu']); | 331 $brew .= '","est_ibu":' . floatval($row['est_ibu']); |
| 269 $brew .= ',"ibu_method":"' . $row['ibu_method']; | 332 $brew .= ',"ibu_method":"' . $row['ibu_method']; |
| 270 $brew .= '","mash_sparge_temp":' . $row['mash_sparge_temp']; | 333 $brew .= '","sparge_temp":' . floatval($row['sparge_temp']); |
| 334 $brew .= ',"sparge_ph":' . floatval($row['sparge_ph']); | |
| 335 $brew .= ',"sparge_volume":' . floatval($row['sparge_volume']); | |
| 336 $brew .= ',"sparge_acid_type":"' . $row['sparge_acid_type']; | |
| 337 $brew .= '","sparge_acid_perc":' . floatval($row['sparge_acid_perc']); | |
| 338 $brew .= ',"sparge_acid_amount":' . floatval($row['sparge_acid_amount']); | |
| 271 $brew .= ',"mash_ph":' . $row['mash_ph']; | 339 $brew .= ',"mash_ph":' . $row['mash_ph']; |
| 272 $brew .= ',"mash_name":"' . $row['mash_name']; | 340 $brew .= ',"mash_name":"' . $row['mash_name']; |
| 273 $brew .= '","fermentables":' . $row['json_fermentables']; | 341 $brew .= '","calc_acid":' . $row['calc_acid']; |
| 342 $brew .= ',"w1_name":"' . str_replace($escapers, $replacements, $row['w1_name']); | |
| 343 $brew .= '","w1_amount":' . $row['w1_amount']; | |
| 344 $brew .= ',"w1_calcium":' . $row['w1_calcium']; | |
| 345 $brew .= ',"w1_sulfate":' . $row['w1_sulfate']; | |
| 346 $brew .= ',"w1_chloride":' . $row['w1_chloride']; | |
| 347 $brew .= ',"w1_sodium":' . $row['w1_sodium']; | |
| 348 $brew .= ',"w1_magnesium":' . $row['w1_magnesium']; | |
| 349 $brew .= ',"w1_total_alkalinity":' . $row['w1_total_alkalinity']; | |
| 350 $brew .= ',"w1_ph":' . $row['w1_ph']; | |
| 351 $brew .= ',"w1_cost":' . $row['w1_cost']; | |
| 352 $brew .= ',"w2_name":"' . str_replace($escapers, $replacements, $row['w2_name']); | |
| 353 $brew .= '","w2_amount":' . $row['w2_amount']; | |
| 354 $brew .= ',"w2_calcium":' . $row['w2_calcium']; | |
| 355 $brew .= ',"w2_sulfate":' . $row['w2_sulfate']; | |
| 356 $brew .= ',"w2_chloride":' . $row['w2_chloride']; | |
| 357 $brew .= ',"w2_sodium":' . $row['w2_sodium']; | |
| 358 $brew .= ',"w2_magnesium":' . $row['w2_magnesium']; | |
| 359 $brew .= ',"w2_total_alkalinity":' . $row['w2_total_alkalinity']; | |
| 360 $brew .= ',"w2_ph":' . $row['w2_ph']; | |
| 361 $brew .= ',"w2_cost":' . $row['w2_cost']; | |
| 362 $brew .= ',"fermentables":' . $row['json_fermentables']; | |
| 274 $brew .= ',"hops":' . $row['json_hops']; | 363 $brew .= ',"hops":' . $row['json_hops']; |
| 275 $brew .= ',"miscs":' . $row['json_miscs']; | 364 $brew .= ',"miscs":' . $row['json_miscs']; |
| 276 $brew .= ',"yeasts":' . $row['json_yeasts']; | 365 $brew .= ',"yeasts":' . $row['json_yeasts']; |
| 277 $brew .= ',"waters":' . $row['json_waters']; | |
| 278 $brew .= ',"mashs":' . $row['json_mashs']; | 366 $brew .= ',"mashs":' . $row['json_mashs']; |
| 279 $brew .= '}'; | 367 $brew .= '}'; |
| 280 $brews .= $brew; | 368 $brews .= $brew; |
| 281 } | 369 } |
| 282 $brews .= ']'; | 370 $brews .= ']'; |
