Mercurial > bms / file comparison

comparison: www/includes/db_product.php

www/includes/db_product.php

changeset 163
4a4cc3497a57
parent 159
6428dae0605d
child 164
0a5abea575a9
equal deleted inserted replaced
162:45248acb6252 163:4a4cc3497a57
54 $sql .= "uuid='" . $_POST['uuid']; 54 $sql .= "uuid='" . $_POST['uuid'];
55 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']); 55 $sql .= "', name='" . mysqli_real_escape_string($connect, $_POST['name']);
56 $sql .= "', code='" . mysqli_real_escape_string($connect, $_POST['code']); 56 $sql .= "', code='" . mysqli_real_escape_string($connect, $_POST['code']);
57 $sql .= "', birth='" . $_POST['birth']; 57 $sql .= "', birth='" . $_POST['birth'];
58 $sql .= "', stage='" . $_POST['stage']; 58 $sql .= "', stage='" . $_POST['stage'];
59 $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']); 59 // $sql .= "', notes='" . mysqli_real_escape_string($connect, $_POST['notes']);
60 ($_POST['log_brew'] == 'true') ? $sql .= "', log_brew='1" : $sql .= "', log_brew='0"; 60 ($_POST['log_brew'] == 'true') ? $sql .= "', log_brew='1" : $sql .= "', log_brew='0";
61 ($_POST['log_fermentation'] == 'true') ? $sql .= "', log_fermentation='1" : $sql .= "', log_fermentation='0"; 61 ($_POST['log_fermentation'] == 'true') ? $sql .= "', log_fermentation='1" : $sql .= "', log_fermentation='0";
62 ($_POST['inventory_reduced'] == 'true') ? $sql .= "', inventory_reduced='1" : $sql .= "', inventory_reduced='0"; 62 ($_POST['inventory_reduced'] == 'true') ? $sql .= "', inventory_reduced='1" : $sql .= "', inventory_reduced='0";
63 ($_POST['locked'] == 'true') ? $sql .= "', locked='1" : $sql .= "', locked='0"; 63 ($_POST['locked'] == 'true') ? $sql .= "', locked='1" : $sql .= "', locked='0";
64 // Equipment 64 // Equipment
75 $sql .= "', eq_evap_rate='" . $_POST['eq_evap_rate']; 75 $sql .= "', eq_evap_rate='" . $_POST['eq_evap_rate'];
76 $sql .= "', eq_boil_time='" . $_POST['eq_boil_time']; 76 $sql .= "', eq_boil_time='" . $_POST['eq_boil_time'];
77 $sql .= "', eq_calc_boil_volume='" . $_POST['eq_calc_boil_volume']; 77 $sql .= "', eq_calc_boil_volume='" . $_POST['eq_calc_boil_volume'];
78 $sql .= "', eq_top_up_kettle='" . $_POST['eq_top_up_kettle']; 78 $sql .= "', eq_top_up_kettle='" . $_POST['eq_top_up_kettle'];
79 $sql .= "', eq_hop_utilization='" . $_POST['eq_hop_utilization']; 79 $sql .= "', eq_hop_utilization='" . $_POST['eq_hop_utilization'];
80 $sql .= "', eq_notes='" . mysqli_real_escape_string($connect, $_POST['eq_notes']); 80 // $sql .= "', eq_notes='" . mysqli_real_escape_string($connect, $_POST['eq_notes']);
81 $sql .= "', eq_lauter_volume='" . $_POST['eq_lauter_volume']; 81 $sql .= "', eq_lauter_volume='" . $_POST['eq_lauter_volume'];
82 $sql .= "', eq_lauter_height='" . $_POST['eq_lauter_height']; 82 $sql .= "', eq_lauter_height='" . $_POST['eq_lauter_height'];
83 $sql .= "', eq_lauter_deadspace='" . $_POST['eq_lauter_deadspace']; 83 $sql .= "', eq_lauter_deadspace='" . $_POST['eq_lauter_deadspace'];
84 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume']; 84 $sql .= "', eq_kettle_volume='" . $_POST['eq_kettle_volume'];
85 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height']; 85 $sql .= "', eq_kettle_height='" . $_POST['eq_kettle_height'];
116 // brew_fermenter_sg 116 // brew_fermenter_sg
117 // brew_fermenter_ibu 117 // brew_fermenter_ibu
118 // brew_date_end 118 // brew_date_end
119 // brew_log_available 119 // brew_log_available
120 } 120 }
121 $sql .= "', og='" . $_POST['og'];
122 $sql .= "', fg='" . $_POST['fg'];
121 123
122 if ($stageno >= 3) { 124 if ($stageno >= 3) {
123 // primary_start_temp 125 // primary_start_temp
124 // primary_max_temp 126 // primary_max_temp
125 // primary_end_temp 127 // primary_end_temp
126 // primary_end_sg 128 // primary_end_sg
127 // primary_end_date 129 // primary_end_date
128 } 130 }
129 131
130 if ($stageno >= 4) { 132 $sql .= "', secondary_temp='" . $_POST['secondary_temp'];
131 // secondary_temp 133 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date'];
132 // secondary_end_date 134 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp'];
133 } 135 $sql .= "', package_date='" . $_POST['package_date'];
134 136 $sql .= "', bottle_amount='" . $_POST['bottle_amount'];
135 if ($stageno >= 5) { 137 $sql .= "', bottle_carbonation='" . $_POST['bottle_carbonation'];
136 // tertiary_temp 138 $sql .= "', bottle_priming_sugar='" . $_POST['bottle_priming_sugar'];
137 } 139 $sql .= "', bottle_priming_amount='" . $_POST['bottle_priming_amount'];
138 140 $sql .= "', bottle_carbonation_temp='" . $_POST['bottle_carbonation_temp'];
139 if ($stageno >= 6) { 141 $sql .= "', keg_amount='" . $_POST['keg_amount'];
140 // package_date 142 $sql .= "', keg_carbonation='" . $_POST['keg_carbonation'];
141 // bottle_amount 143 $sql .= "', keg_priming_sugar='" . $_POST['keg_priming_sugar'];
142 // bottle_carbonation 144 $sql .= "', keg_priming_amount='" . $_POST['keg_priming_amount'];
143 // bottle_priming_sugar 145 $sql .= "', keg_carbonation_temp='" . $_POST['keg_carbonation_temp'];
144 // bottle_priming_amount 146 ($_POST['keg_forced_carb'] == 'true') ? $sql .= "', keg_forced_carb='1" : $sql .= "', keg_forced_carb='0";
145 // bottle_carbonation_temp 147 $sql .= "', keg_pressure='" . $_POST['keg_pressure'];
146 // keg_amount 148 $sql .= "', taste_notes='" . mysqli_real_escape_string($connect, $_POST['taste_notes']);
147 // keg_carbonation 149 $sql .= "', taste_rate='" . $_POST['taste_rate'];
148 // keg_priming_sugar 150 $sql .= "', taste_date='" . $_POST['taste_date'];
149 // keg_priming_amount 151 $sql .= "', taste_color='" . mysqli_real_escape_string($connect, $_POST['taste_color']);
150 // keg_carbonation_temp 152 $sql .= "', taste_transparency='" . mysqli_real_escape_string($connect, $_POST['taste_transparency']);
151 // keg_forced_carb 153 $sql .= "', taste_head='" . mysqli_real_escape_string($connect, $_POST['taste_head']);
152 // keg_pressure 154 $sql .= "', taste_aroma='" . mysqli_real_escape_string($connect, $_POST['taste_aroma']);
153 // keg_priming_factor 155 $sql .= "', taste_taste='" . mysqli_real_escape_string($connect, $_POST['taste_taste']);
154 } 156 $sql .= "', taste_mouthfeel='" . mysqli_real_escape_string($connect, $_POST['taste_mouthfeel']);
155 157 $sql .= "', taste_aftertaste='" . mysqli_real_escape_string($connect, $_POST['taste_aftertaste']);
156 if ($stageno >= 9) {
157 // taste_notes
158 // taste_rate
159 // taste_date
160 // taste_color
161 // taste_transparency
162 // taste_head
163 // taste_aroma
164 // taste_taste
165 // taste_mouthfeel
166 // taste_aftertaste
167 }
168 158
169 /* 159 /*
170 * Recipe part 160 * Recipe part
171 */ 161 */
172 // $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']); 162 $sql .= "', st_name='" . mysqli_real_escape_string($connect, $_POST['st_name']);
173 // $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']); 163 $sql .= "', st_letter='" . mysqli_real_escape_string($connect, $_POST['st_letter']);
174 // $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']); 164 $sql .= "', st_guide='" . mysqli_real_escape_string($connect, $_POST['st_guide']);
175 // $sql .= "', st_type='" . mysqli_real_escape_string($connect, $_POST['st_type']); 165 $sql .= "', st_type='" . mysqli_real_escape_string($connect, $_POST['st_type']);
176 // $sql .= "', st_category='" . mysqli_real_escape_string($connect, $_POST['st_category']); 166 $sql .= "', st_category='" . mysqli_real_escape_string($connect, $_POST['st_category']);
177 // $sql .= "', st_category_number='" . $_POST['st_category_number']; 167 $sql .= "', st_category_number='" . $_POST['st_category_number'];
178 $sql .= "', st_og_min='" . $_POST['st_og_min']; 168 $sql .= "', st_og_min='" . $_POST['st_og_min'];
179 $sql .= "', st_og_max='" . $_POST['st_og_max']; 169 $sql .= "', st_og_max='" . $_POST['st_og_max'];
180 $sql .= "', st_fg_min='" . $_POST['st_fg_min']; 170 $sql .= "', st_fg_min='" . $_POST['st_fg_min'];
181 $sql .= "', st_fg_max='" . $_POST['st_fg_max']; 171 $sql .= "', st_fg_max='" . $_POST['st_fg_max'];
182 $sql .= "', st_ibu_min='" . $_POST['st_ibu_min']; 172 $sql .= "', st_ibu_min='" . $_POST['st_ibu_min'];
424 $brew .= ',"brew_aeration_type":"' . $row['brew_aeration_type']; 414 $brew .= ',"brew_aeration_type":"' . $row['brew_aeration_type'];
425 $brew .= '","brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']); 415 $brew .= '","brew_fermenter_sg":' . floatval($row['brew_fermenter_sg']);
426 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']); 416 $brew .= ',"brew_fermenter_ibu":' . floatval($row['brew_fermenter_ibu']);
427 $brew .= ',"brew_date_end":"' . $row['brew_date_end']; 417 $brew .= ',"brew_date_end":"' . $row['brew_date_end'];
428 $brew .= '","brew_log_available":' . $row['brew_log_available']; 418 $brew .= '","brew_log_available":' . $row['brew_log_available'];
419 $brew .= ',"og":' . floatval($row['og']);
420 $brew .= ',"fg":' . floatval($row['fg']);
429 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']); 421 $brew .= ',"primary_start_temp":' . floatval($row['primary_start_temp']);
430 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']); 422 $brew .= ',"primary_max_temp":' . floatval($row['primary_max_temp']);
431 $brew .= ',"primary_end_temp":' . floatval($row['primary_end_temp']); 423 $brew .= ',"primary_end_temp":' . floatval($row['primary_end_temp']);
432 $brew .= ',"primary_end_sg":' . floatval($row['primary_end_sg']); 424 $brew .= ',"primary_end_sg":' . floatval($row['primary_end_sg']);
433 $brew .= ',"primary_end_date":"' . $row['primary_end_date']; 425 $brew .= ',"primary_end_date":"' . $row['primary_end_date'];
445 $brew .= ',"keg_priming_sugar":"' . str_replace($escapers, $replacements, $row['keg_priming_sugar']); 437 $brew .= ',"keg_priming_sugar":"' . str_replace($escapers, $replacements, $row['keg_priming_sugar']);
446 $brew .= '","keg_priming_amount":' . floatval($row['keg_priming_amount']); 438 $brew .= '","keg_priming_amount":' . floatval($row['keg_priming_amount']);
447 $brew .= ',"keg_carbonation_temp":' . floatval($row['keg_carbonation_temp']); 439 $brew .= ',"keg_carbonation_temp":' . floatval($row['keg_carbonation_temp']);
448 $brew .= ',"keg_forced_carb":' . floatval($row['keg_forced_carb']); 440 $brew .= ',"keg_forced_carb":' . floatval($row['keg_forced_carb']);
449 $brew .= ',"keg_pressure":' . floatval($row['keg_pressure']); 441 $brew .= ',"keg_pressure":' . floatval($row['keg_pressure']);
450 $brew .= ',"keg_priming_factor":' . floatval($row['keg_priming_factor']);
451 $brew .= ',"taste_notes":"' . str_replace($escapers, $replacements, $row['taste_notes']); 442 $brew .= ',"taste_notes":"' . str_replace($escapers, $replacements, $row['taste_notes']);
452 $brew .= '","taste_rate":' . floatval($row['taste_rate']); 443 $brew .= '","taste_rate":' . floatval($row['taste_rate']);
453 $brew .= ',"taste_date":"' . str_replace($escapers, $replacements, $row['taste_date']); 444 $brew .= ',"taste_date":"' . str_replace($escapers, $replacements, $row['taste_date']);
454 $brew .= '","taste_color":"' . str_replace($escapers, $replacements, $row['taste_color']); 445 $brew .= '","taste_color":"' . str_replace($escapers, $replacements, $row['taste_color']);
455 $brew .= '","taste_transparency":"' . str_replace($escapers, $replacements, $row['taste_transparency']); 446 $brew .= '","taste_transparency":"' . str_replace($escapers, $replacements, $row['taste_transparency']);

Mercurial Repository: bms

mercurial