comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 241
- e95d2886f49f
- parent 240
- a85c1d4c4d12
- child 243
- b43214d218c0
equal
deleted
inserted
replaced
| 240:a85c1d4c4d12 | 241:e95d2886f49f |
|---|---|
| 69 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; | 69 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; |
| 70 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; | 70 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; |
| 71 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; | 71 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; |
| 72 | 72 |
| 73 if ($stage > 1) { | 73 if ($stage > 1) { |
| 74 syslog(LOG_NOTICE, "write brewdate data"); | |
| 74 $sql .= "', brew_date_start='" . $_POST['brew_date_start']; | 75 $sql .= "', brew_date_start='" . $_POST['brew_date_start']; |
| 75 $sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph']; | 76 $sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph']; |
| 76 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; | 77 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; |
| 77 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; | 78 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; |
| 78 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; | 79 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; |
| 96 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; | 97 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; |
| 97 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; | 98 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; |
| 98 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; | 99 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; |
| 99 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; | 100 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; |
| 100 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; | 101 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
| 101 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; | 102 if ($stage > 2) { |
| 103 syslog(LOG_NOTICE, "write brewdate data end"); | |
| 104 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; | |
| 105 } | |
| 102 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; | 106 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; |
| 103 } | 107 } |
| 104 $sql .= "', og='" . $_POST['og']; | 108 $sql .= "', og='" . $_POST['og']; |
| 105 $sql .= "', fg='" . $_POST['fg']; | 109 $sql .= "', fg='" . $_POST['fg']; |
| 106 | 110 |
| 107 if ($stage > 2) { | 111 if ($stage > 2) { |
| 112 syslog(LOG_NOTICE, "write primary data"); | |
| 108 $sql .= "', primary_start_temp='" . $_POST['primary_start_temp']; | 113 $sql .= "', primary_start_temp='" . $_POST['primary_start_temp']; |
| 109 $sql .= "', primary_max_temp='" . $_POST['primary_max_temp']; | 114 $sql .= "', primary_max_temp='" . $_POST['primary_max_temp']; |
| 110 $sql .= "', primary_end_temp='" . $_POST['primary_end_temp']; | 115 $sql .= "', primary_end_temp='" . $_POST['primary_end_temp']; |
| 111 $sql .= "', primary_end_sg='" . $_POST['primary_end_sg']; | 116 $sql .= "', primary_end_sg='" . $_POST['primary_end_sg']; |
| 112 $sql .= "', primary_end_date='" . $_POST['primary_end_date']; | 117 $sql .= "', primary_end_date='" . $_POST['primary_end_date']; |
| 113 } | 118 } |
| 114 | 119 |
| 115 if ($stage > 3) { | 120 if ($stage > 3) { |
| 121 syslog(LOG_NOTICE, "write secondary data"); | |
| 116 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; | 122 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; |
| 117 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; | 123 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; |
| 118 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; | 124 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; |
| 119 } | 125 } |
| 120 | 126 |
| 121 if ($stage > 4) { | 127 if ($stage > 4) { |
| 128 syslog(LOG_NOTICE, "write package data"); | |
| 122 $sql .= "', package_date='" . $_POST['package_date']; | 129 $sql .= "', package_date='" . $_POST['package_date']; |
| 123 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; | 130 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; |
| 124 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; | 131 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation']; |
| 125 $sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar']; | 132 $sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar']; |
| 126 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; | 133 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount']; |
| 133 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0"; | 140 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0"; |
| 134 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; | 141 $sql .= "', keg_pressure='" . $_POST['keg_pressure']; |
| 135 } | 142 } |
| 136 | 143 |
| 137 if ($stage > 8) { | 144 if ($stage > 8) { |
| 145 syslog(LOG_NOTICE, "write taste data"); | |
| 138 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); | 146 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']); |
| 139 $sql .= "', taste_rate='" . $_POST['taste_rate']; | 147 $sql .= "', taste_rate='" . $_POST['taste_rate']; |
| 140 $sql .= "', taste_date='" . $_POST['taste_date']; | 148 $sql .= "', taste_date='" . $_POST['taste_date']; |
| 141 $sql .= "', taste_color='" . mysqli_real_escape_string($connect, $_POST['taste_color']); | 149 $sql .= "', taste_color='" . mysqli_real_escape_string($connect, $_POST['taste_color']); |
| 142 $sql .= "', taste_transparency='" . mysqli_real_escape_string($connect, $_POST['taste_transparency']); | 150 $sql .= "', taste_transparency='" . mysqli_real_escape_string($connect, $_POST['taste_transparency']); |
