comparison: www/includes/db_product.php
www/includes/db_product.php
- changeset 164
- 0a5abea575a9
- parent 163
- 4a4cc3497a57
- child 166
- 635033a29c48
equal
deleted
inserted
replaced
| 163:4a4cc3497a57 | 164:0a5abea575a9 |
|---|---|
| 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']; |
| 86 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; | 86 $sql .= "', eq_mash_volume='" . $_POST['eq_mash_volume']; |
| 87 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; | 87 $sql .= "', eq_mash_max='" . $_POST['eq_mash_max']; |
| 88 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; | 88 $sql .= "', eq_efficiency='" . $_POST['eq_efficiency']; |
| 89 | 89 $sql .= "', brew_date_start='" . $_POST['brew_date_start']; |
| 90 if ($stageno >= 2) { | 90 $sql .= "', brew_mash_ph='" . $_POST['brew_mash_ph']; |
| 91 // brew_date_start | 91 $sql .= "', brew_mash_sg='" . $_POST['brew_mash_sg']; |
| 92 // brew_mash_ph | 92 $sql .= "', brew_sparge_temperature='" . $_POST['brew_sparge_temperature']; |
| 93 // brew_mash_sg | 93 $sql .= "', brew_sparge_volume='" . $_POST['brew_sparge_volume']; |
| 94 // brew_sparge_temperature | 94 $sql .= "', brew_sparge_ph='" . $_POST['brew_sparge_ph']; |
| 95 // brew_sparge_volume | 95 $sql .= "', brew_preboil_volume='" . $_POST['brew_preboil_volume']; |
| 96 // brew_sparge_ph | 96 $sql .= "', brew_preboil_sg='" . $_POST['brew_preboil_sg']; |
| 97 // brew_preboil_volume | 97 $sql .= "', brew_preboil_ph='" . $_POST['brew_preboil_ph']; |
| 98 // brew_preboil_sg | 98 $sql .= "', brew_aboil_volume='" . $_POST['brew_aboil_volume']; |
| 99 // brew_preboil_ph | 99 $sql .= "', brew_aboil_sg='" . $_POST['brew_aboil_sg']; |
| 100 // brew_aboil_volume | 100 $sql .= "', brew_aboil_ph='" . $_POST['brew_aboil_ph']; |
| 101 // brew_aboil_sg | 101 $sql .= "', brew_aboil_efficiency='" . $_POST['brew_aboil_efficiency']; |
| 102 // brew_aboil_ph | 102 $sql .= "', brew_cooling_method='" . $_POST['brew_cooling_method']; |
| 103 // brew_aboil_efficiency | 103 $sql .= "', brew_cooling_time='" . $_POST['brew_cooling_time']; |
| 104 // brew_cooling_method | 104 $sql .= "', brew_cooling_to='" . $_POST['brew_cooling_to']; |
| 105 // brew_cooling_time | 105 $sql .= "', brew_whirlpool9='" . $_POST['brew_whirlpool9']; |
| 106 // brew_cooling_to | 106 $sql .= "', brew_whirlpool7='" . $_POST['brew_whirlpool7']; |
| 107 // brew_whirlpool9 | 107 $sql .= "', brew_whirlpool6='" . $_POST['brew_whirlpool6']; |
| 108 // brew_whirlpool7 | 108 $sql .= "', brew_whirlpool2='" . $_POST['brew_whirlpool2']; |
| 109 // brew_whirlpool6 | 109 $sql .= "', brew_aeration_time='" . $_POST['brew_aeration_time']; |
| 110 // brew_whirlpool2 | 110 $sql .= "', brew_aeration_speed='" . $_POST['brew_aeration_speed']; |
| 111 // brew_fermenter_volume | 111 $sql .= "', brew_aeration_type='" . $_POST['brew_aeration_type']; |
| 112 // brew_fermenter_extrawater | 112 $sql .= "', brew_fermenter_volume='" . $_POST['brew_fermenter_volume']; |
| 113 // brew_aeration_time | 113 $sql .= "', brew_fermenter_extrawater='" . $_POST['brew_fermenter_extrawater']; |
| 114 // brew_aeration_speed | 114 $sql .= "', brew_fermenter_sg='" . $_POST['brew_fermenter_sg']; |
| 115 // brew_aeration_type | 115 $sql .= "', brew_fermenter_ibu='" . $_POST['brew_fermenter_ibu']; |
| 116 // brew_fermenter_sg | 116 $sql .= "', brew_date_end='" . $_POST['brew_date_end']; |
| 117 // brew_fermenter_ibu | 117 ($_POST['brew_log_available'] == 'true') ? $sql .= "', brew_log_available='1" : $sql .= "', brew_log_available='0"; |
| 118 // brew_date_end | |
| 119 // brew_log_available | |
| 120 } | |
| 121 $sql .= "', og='" . $_POST['og']; | 118 $sql .= "', og='" . $_POST['og']; |
| 122 $sql .= "', fg='" . $_POST['fg']; | 119 $sql .= "', fg='" . $_POST['fg']; |
| 123 | 120 $sql .= "', primary_start_temp='" . $_POST['primary_start_temp']; |
| 124 if ($stageno >= 3) { | 121 $sql .= "', primary_max_temp='" . $_POST['primary_max_temp']; |
| 125 // primary_start_temp | 122 $sql .= "', primary_end_temp='" . $_POST['primary_end_temp']; |
| 126 // primary_max_temp | 123 $sql .= "', primary_end_sg='" . $_POST['primary_end_sg']; |
| 127 // primary_end_temp | 124 $sql .= "', primary_end_date='" . $_POST['primary_end_date']; |
| 128 // primary_end_sg | |
| 129 // primary_end_date | |
| 130 } | |
| 131 | |
| 132 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; | 125 $sql .= "', secondary_temp='" . $_POST['secondary_temp']; |
| 133 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; | 126 $sql .= "', secondary_end_date='" . $_POST['secondary_end_date']; |
| 134 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; | 127 $sql .= "', tertiary_temp='" . $_POST['tertiary_temp']; |
| 135 $sql .= "', package_date='" . $_POST['package_date']; | 128 $sql .= "', package_date='" . $_POST['package_date']; |
| 136 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; | 129 $sql .= "', bottle_amount='" . $_POST['bottle_amount']; |
| 231 foreach($array as $key => $item){ | 224 foreach($array as $key => $item){ |
| 232 foreach ($disallowed as $disallowed_key) { | 225 foreach ($disallowed as $disallowed_key) { |
| 233 unset($array[$key]["$disallowed_key"]); | 226 unset($array[$key]["$disallowed_key"]); |
| 234 } | 227 } |
| 235 } | 228 } |
| 236 syslog(LOG_NOTICE, "json_fermentables=: ".str_replace($rescapers,$rreplacements,json_encode($array))); | 229 // syslog(LOG_NOTICE, "json_fermentables=: ".str_replace($rescapers,$rreplacements,json_encode($array))); |
| 237 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,json_encode($array)); | 230 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,json_encode($array)); |
| 238 } | 231 } |
| 239 | 232 |
| 240 if (isset($_POST['hops'])) { | 233 if (isset($_POST['hops'])) { |
| 241 $array = $_POST['hops']; | 234 $array = $_POST['hops']; |
| 242 foreach($array as $key => $item){ | 235 foreach($array as $key => $item){ |
| 243 foreach ($disallowed as $disallowed_key) { | 236 foreach ($disallowed as $disallowed_key) { |
| 244 unset($array[$key]["$disallowed_key"]); | 237 unset($array[$key]["$disallowed_key"]); |
| 245 } | 238 } |
| 246 } | 239 } |
| 247 syslog(LOG_NOTICE, "json_hops: ".str_replace($rescapers,$rreplacements,json_encode($array))); | 240 // syslog(LOG_NOTICE, "json_hops: ".str_replace($rescapers,$rreplacements,json_encode($array))); |
| 248 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,json_encode($array)); | 241 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,json_encode($array)); |
| 249 } | 242 } |
| 250 | 243 |
| 251 if (isset($_POST['miscs'])) { | 244 if (isset($_POST['miscs'])) { |
| 252 $array = $_POST['miscs']; | 245 $array = $_POST['miscs']; |
| 253 foreach($array as $key => $item){ | 246 foreach($array as $key => $item){ |
| 254 foreach ($disallowed as $disallowed_key) { | 247 foreach ($disallowed as $disallowed_key) { |
| 255 unset($array[$key]["$disallowed_key"]); | 248 unset($array[$key]["$disallowed_key"]); |
| 256 } | 249 } |
| 257 } | 250 } |
| 258 syslog(LOG_NOTICE, "json_miscs: ".str_replace($rescapers,$rreplacements,json_encode($array))); | 251 // syslog(LOG_NOTICE, "json_miscs: ".str_replace($rescapers,$rreplacements,json_encode($array))); |
| 259 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,json_encode($array)); | 252 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,json_encode($array)); |
| 260 } | 253 } |
| 261 | 254 |
| 262 if (isset($_POST['yeasts'])) { | 255 if (isset($_POST['yeasts'])) { |
| 263 $array = $_POST['yeasts']; | 256 $array = $_POST['yeasts']; |
| 264 foreach($array as $key => $item){ | 257 foreach($array as $key => $item){ |
| 265 foreach ($disallowed as $disallowed_key) { | 258 foreach ($disallowed as $disallowed_key) { |
| 266 unset($array[$key]["$disallowed_key"]); | 259 unset($array[$key]["$disallowed_key"]); |
| 267 } | 260 } |
| 268 } | 261 } |
| 269 syslog(LOG_NOTICE, "json_yeasts: ". str_replace($rescapers,$rreplacements,json_encode($array))); | 262 // syslog(LOG_NOTICE, "json_yeasts: ". str_replace($rescapers,$rreplacements,json_encode($array))); |
| 270 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,json_encode($array)); | 263 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,json_encode($array)); |
| 271 } | 264 } |
| 272 | 265 |
| 273 if (isset($_POST['mashs'])) { | 266 if (isset($_POST['mashs'])) { |
| 274 $array = $_POST['mashs']; | 267 $array = $_POST['mashs']; |
| 275 foreach($array as $key => $item){ | 268 foreach($array as $key => $item){ |
| 276 foreach ($disallowed as $disallowed_key) { | 269 foreach ($disallowed as $disallowed_key) { |
| 277 unset($array[$key]["$disallowed_key"]); | 270 unset($array[$key]["$disallowed_key"]); |
| 278 } | 271 } |
| 279 } | 272 } |
| 280 syslog(LOG_NOTICE, "json_mashs: ".str_replace($rescapers,$rreplacements,json_encode($array))); | 273 // syslog(LOG_NOTICE, "json_mashs: ".str_replace($rescapers,$rreplacements,json_encode($array))); |
| 281 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,json_encode($array)); | 274 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,json_encode($array)); |
| 282 } | 275 } |
| 283 | 276 |
| 284 if (isset($_POST['insert'])) { | 277 if (isset($_POST['insert'])) { |
| 285 $sql .= "';"; | 278 $sql .= "';"; |
