comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 252
- b558f3dfcda3
- parent 243
- b43214d218c0
- child 254
- 3d61397fe9cd
equal
deleted
inserted
replaced
| 251:a7f25be71ba8 | 252:b558f3dfcda3 |
|---|---|
| 38 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); | 38 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); |
| 39 $sql .= "', code='" . mysqli_real_escape_string($connect, $_POST['code']); | 39 $sql .= "', code='" . mysqli_real_escape_string($connect, $_POST['code']); |
| 40 $sql .= "', birth='" . $_POST['birth']; | 40 $sql .= "', birth='" . $_POST['birth']; |
| 41 $sql .= "', stage='" . $_POST['stage']; | 41 $sql .= "', stage='" . $_POST['stage']; |
| 42 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); | 42 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); |
| 43 ($_POST['log_brew'] == 'true') ? $sql .= "', log_brew='1" : $sql .= "', log_brew='0"; | 43 $sql .= "', log_brew='" . $_POST['log_brew']; |
| 44 ($_POST['log_fermentation'] == 'true') ? $sql .= "', log_fermentation='1" : $sql .= "', log_fermentation='0"; | 44 $sql .= "', log_fermentation='" . $_POST['log_fermentation']; |
| 45 ($_POST['inventory_reduced'] == 'true') ? $sql .= "', inventory_reduced='1" : $sql .= "', inventory_reduced='0"; | 45 $sql .= "', inventory_reduced='" . $_POST['inventory_reduced']; |
| 46 ($_POST['locked'] == 'true') ? $sql .= "', locked='1" : $sql .= "', locked='0"; | 46 $sql .= "', locked='" . $_POST['locked']; |
| 47 // Equipment | 47 // Equipment |
| 48 $sql .= "', eq_name='" . mysqli_real_escape_string($connect, $_POST['eq_name']); | 48 $sql .= "', eq_name='" . mysqli_real_escape_string($connect, $_POST['eq_name']); |
| 49 $sql .= "', eq_boil_size='" . $_POST['eq_boil_size']; | 49 $sql .= "', eq_boil_size='" . $_POST['eq_boil_size']; |
| 50 $sql .= "', eq_batch_size='" . $_POST['eq_batch_size']; | 50 $sql .= "', eq_batch_size='" . $_POST['eq_batch_size']; |
| 51 $sql .= "', eq_tun_volume='" . $_POST['eq_tun_volume']; | 51 $sql .= "', eq_tun_volume='" . $_POST['eq_tun_volume']; |
| 104 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; | 104 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
| 105 if ($stage > 2) { | 105 if ($stage > 2) { |
| 106 syslog(LOG_NOTICE, "write brewdate data end"); | 106 syslog(LOG_NOTICE, "write brewdate data end"); |
| 107 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; | 107 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; |
| 108 } | 108 } |
| 109 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; | |
| 110 } | 109 } |
| 111 $sql .= "', og='" . $_POST['og']; | 110 $sql .= "', og='" . $_POST['og']; |
| 112 $sql .= "', fg='" . $_POST['fg']; | 111 $sql .= "', fg='" . $_POST['fg']; |
| 113 | 112 |
| 114 if ($stage > 2) { | 113 if ($stage > 2) { |
| 138 $sql .= "', keg_amount='" . $_POST['keg_amount']; | 137 $sql .= "', keg_amount='" . $_POST['keg_amount']; |
| 139 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; | 138 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation']; |
| 140 $sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar']; | 139 $sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar']; |
| 141 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; | 140 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount']; |
| 142 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; | 141 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp']; |
| 143 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0"; | 142 $sql .= "', keg_forced_carb='" . $_POST['keg_forced_carb']; |
| 144 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; | 143 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; |
| 145 } | 144 } |
| 146 | 145 |
| 147 if ($stage > 8) { | 146 if ($stage > 8) { |
| 148 syslog(LOG_NOTICE, "write taste data"); | 147 syslog(LOG_NOTICE, "write taste data"); |
| 199 $sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type']; | 198 $sql .= "', sparge_acid_type='" . $_POST['sparge_acid_type']; |
| 200 $sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc']; | 199 $sql .= "', sparge_acid_perc='" . $_POST['sparge_acid_perc']; |
| 201 $sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount']; | 200 $sql .= "', sparge_acid_amount='" . $_POST['sparge_acid_amount']; |
| 202 $sql .= "', mash_ph='" . $_POST['mash_ph']; | 201 $sql .= "', mash_ph='" . $_POST['mash_ph']; |
| 203 $sql .= "', mash_name='" . $_POST['mash_name']; | 202 $sql .= "', mash_name='" . $_POST['mash_name']; |
| 204 ($_POST['calc_acid'] == 'true') ? $sql .= "', calc_acid='1" : $sql .= "', calc_acid='0"; | 203 $sql .= "', calc_acid='" . $_POST['calc_acid']; |
| 205 if (isset($_POST['w1_name'])) { | 204 if (isset($_POST['w1_name'])) { |
| 206 $sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']); | 205 $sql .= "', w1_name='" . mysqli_real_escape_string($connect, $_POST['w1_name']); |
| 207 $sql .= "', w1_amount='" . $_POST['w1_amount']; | 206 $sql .= "', w1_amount='" . $_POST['w1_amount']; |
| 208 $sql .= "', w1_calcium='" . $_POST['w1_calcium']; | 207 $sql .= "', w1_calcium='" . $_POST['w1_calcium']; |
| 209 $sql .= "', w1_sulfate='" . $_POST['w1_sulfate']; | 208 $sql .= "', w1_sulfate='" . $_POST['w1_sulfate']; |
| 530 $brew .= ',"brew_aeration_speed":' . floatval($row['brew_aeration_speed']); | 529 $brew .= ',"brew_aeration_speed":' . floatval($row['brew_aeration_speed']); |
| 531 $brew .= ',"brew_aeration_type":' . $row['brew_aeration_type']; | 530 $brew .= ',"brew_aeration_type":' . $row['brew_aeration_type']; |
| 532 $brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']); | 531 $brew .= ',"brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']); |
| 533 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']); | 532 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']); |
| 534 $brew .= ',"brew_date_end":"' . $row['brew_date_end']; | 533 $brew .= ',"brew_date_end":"' . $row['brew_date_end']; |
| 535 $brew .= '","brew_log_available":' . $row['brew_log_available']; | 534 $brew .= '","og":' . floatval($row['og']); |
| 536 $brew .= ',"og":' . floatval($row['og']); | |
| 537 $brew .= ',"fg":' . floatval($row['fg']); | 535 $brew .= ',"fg":' . floatval($row['fg']); |
| 538 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']); | 536 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']); |
| 539 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']); | 537 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']); |
| 540 $brew .= ',"primary_end_temp":' . floatval($row['primary_end_temp']); | 538 $brew .= ',"primary_end_temp":' . floatval($row['primary_end_temp']); |
| 541 $brew .= ',"primary_end_sg":' . floatval($row['primary_end_sg']); | 539 $brew .= ',"primary_end_sg":' . floatval($row['primary_end_sg']); |
