comparison: www/rec_toproduct.php
www/rec_toproduct.php
- branch
- stable
- changeset 665
- 4d01937ae7af
- parent 616
- 2cbf21bb9bdc
- child 734
- 2a90ffaf04b7
equal
deleted
inserted
replaced
| 521:9d1aa6f3a4da | 665:4d01937ae7af |
|---|---|
| 31 $sql .= "', uuid='" . str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); | 31 $sql .= "', uuid='" . str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); |
| 32 $sql .= "', code='" . date("YmdHi"); | 32 $sql .= "', code='" . date("YmdHi"); |
| 33 $sql .= "', birth='" . date("Y-m-d"); | 33 $sql .= "', birth='" . date("Y-m-d"); |
| 34 $sql .= "', stage='1"; | 34 $sql .= "', stage='1"; |
| 35 $sql .= "', notes='" . mysqli_real_escape_string($link, $row['notes']); | 35 $sql .= "', notes='" . mysqli_real_escape_string($link, $row['notes']); |
| 36 $sql .= "', log_brew='0', log_fermentation='0', inventory_reduced='0', locked='0"; | 36 $sql .= "', log_brew='0', log_fermentation='0', log_ispindel='0', log_co2pressure='0', inventory_reduced='0', locked='0"; |
| 37 // Equipment | 37 // Equipment |
| 38 $sql .= "', eq_name='Kies zelf een installatie!"; | 38 $sql .= "', eq_name='Kies zelf een installatie!"; |
| 39 $sql .= "', eq_boil_size='" . $row['boil_size']; | 39 $sql .= "', eq_boil_size='" . $row['boil_size']; |
| 40 $sql .= "', eq_batch_size='" . $row['batch_size']; | 40 $sql .= "', eq_batch_size='" . $row['batch_size']; |
| 41 $sql .= "', eq_tun_volume='20', eq_tun_weight='2', eq_tun_specific_heat='0.11', eq_tun_material='0"; | 41 $sql .= "', eq_tun_volume='20', eq_tun_weight='2', eq_tun_specific_heat='0.11', eq_tun_material='0"; |
| 44 $sql .= "', eq_calc_boil_volume='1', eq_top_up_kettle='0', eq_hop_utilization='100', eq_notes='"; | 44 $sql .= "', eq_calc_boil_volume='1', eq_top_up_kettle='0', eq_hop_utilization='100', eq_notes='"; |
| 45 $sql .= "', eq_lauter_volume='20', eq_lauter_height='20', eq_lauter_deadspace='0.5', eq_kettle_volume='20"; | 45 $sql .= "', eq_lauter_volume='20', eq_lauter_height='20', eq_lauter_deadspace='0.5', eq_kettle_volume='20"; |
| 46 $sql .= "', eq_kettle_height='20', eq_mash_volume='18', eq_mash_max='6', eq_efficiency='75"; | 46 $sql .= "', eq_kettle_height='20', eq_mash_volume='18', eq_mash_max='6', eq_efficiency='75"; |
| 47 // brewdate | 47 // brewdate |
| 48 $sql .= "', brew_date_start=NULL, brew_mash_ph='0.0', brew_mash_sg='1.000"; | 48 $sql .= "', brew_date_start=NULL, brew_mash_ph='0.0', brew_mash_sg='1.000"; |
| 49 $sql .= "', brew_sparge_ph='0.0"; | 49 $sql .= "', brew_mash_efficiency='0.0', brew_sparge_ph='0.0', brew_sparge_temperature='85.0"; |
| 50 $sql .= "', brew_preboil_volume='0', brew_preboil_sg='0', brew_preboil_ph='0.0"; | 50 $sql .= "', brew_preboil_volume='0', brew_preboil_sg='0', brew_preboil_ph='0.0', brew_preboil_efficiency='0"; |
| 51 $sql .= "', brew_aboil_volume='0', brew_aboil_sg='0', brew_aboil_ph='0.0', brew_aboil_efficiency='0"; | 51 $sql .= "', brew_aboil_volume='0', brew_aboil_sg='0', brew_aboil_ph='0.0', brew_aboil_efficiency='0"; |
| 52 $sql .= "', brew_cooling_method='0', brew_cooling_time='0', brew_cooling_to='20"; | 52 $sql .= "', brew_cooling_method='0', brew_cooling_time='0', brew_cooling_to='20"; |
| 53 $sql .= "', brew_whirlpool9='0', brew_whirlpool7='0', brew_whirlpool6='0', brew_whirlpool2='0"; | 53 $sql .= "', brew_whirlpool9='0', brew_whirlpool7='0', brew_whirlpool6='0', brew_whirlpool2='0"; |
| 54 $sql .= "', brew_aeration_time='0', brew_aeration_speed='0', brew_aeration_type='0"; | 54 $sql .= "', brew_aeration_time='0', brew_aeration_speed='0', brew_aeration_type='0"; |
| 55 $sql .= "', brew_fermenter_volume='" . floatval($row['batch_size']) - 0.5; | 55 $sql .= "', brew_fermenter_volume='" . floatval($row['batch_size']) - 0.5; |
| 95 $sql .= "', batch_size='" . $row['batch_size']; | 95 $sql .= "', batch_size='" . $row['batch_size']; |
| 96 $sql .= "', boil_size='" . $row['boil_size']; | 96 $sql .= "', boil_size='" . $row['boil_size']; |
| 97 $sql .= "', boil_time='" . $row['boil_time']; | 97 $sql .= "', boil_time='" . $row['boil_time']; |
| 98 $sql .= "', efficiency='" . $row['efficiency']; | 98 $sql .= "', efficiency='" . $row['efficiency']; |
| 99 $sql .= "', est_og='0.000"; | 99 $sql .= "', est_og='0.000"; |
| 100 $sql .= "', est_og3='0.000"; | |
| 100 $sql .= "', est_fg='0.000"; | 101 $sql .= "', est_fg='0.000"; |
| 101 $sql .= "', est_abv='0.0"; | 102 $sql .= "', est_abv='0.0"; |
| 102 $sql .= "', est_carb='0"; | 103 $sql .= "', est_carb='0"; |
| 103 $sql .= "', est_color='0"; | 104 $sql .= "', est_color='0"; |
| 104 $sql .= "', color_method='0"; | 105 $sql .= "', color_method='0"; |
| 132 $sql .= "', w2_sodium='" . $row['w2_sodium']; | 133 $sql .= "', w2_sodium='" . $row['w2_sodium']; |
| 133 $sql .= "', w2_magnesium='" . $row['w2_magnesium']; | 134 $sql .= "', w2_magnesium='" . $row['w2_magnesium']; |
| 134 $sql .= "', w2_total_alkalinity='" . $row['w2_total_alkalinity']; | 135 $sql .= "', w2_total_alkalinity='" . $row['w2_total_alkalinity']; |
| 135 $sql .= "', w2_ph='" . $row['w2_ph']; | 136 $sql .= "', w2_ph='" . $row['w2_ph']; |
| 136 $sql .= "', w2_cost='" . $row['w2_cost']; | 137 $sql .= "', w2_cost='" . $row['w2_cost']; |
| 138 $sql .= "', wg_amount='" . $row['wg_amount']; | |
| 139 $sql .= "', wg_calcium='" . $row['wg_calcium']; | |
| 140 $sql .= "', wg_sulfate='" . $row['wg_sulfate']; | |
| 141 $sql .= "', wg_chloride='" . $row['wg_chloride']; | |
| 142 $sql .= "', wg_sodium='" . $row['wg_sodium']; | |
| 143 $sql .= "', wg_magnesium='" . $row['wg_magnesium']; | |
| 144 $sql .= "', wg_total_alkalinity='" . $row['wg_total_alkalinity']; | |
| 145 $sql .= "', wg_ph='" . $row['wg_ph']; | |
| 146 $sql .= "', wb_calcium='" . $row['wb_calcium']; | |
| 147 $sql .= "', wb_sulfate='" . $row['wb_sulfate']; | |
| 148 $sql .= "', wb_chloride='" . $row['wb_chloride']; | |
| 149 $sql .= "', wb_sodium='" . $row['wb_sodium']; | |
| 150 $sql .= "', wb_magnesium='" . $row['wb_magnesium']; | |
| 151 $sql .= "', wb_total_alkalinity='" . $row['wb_total_alkalinity']; | |
| 152 $sql .= "', wb_ph='" . $row['wb_ph']; | |
| 137 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; | 153 $sql .= "', wa_acid_name='" . $row['wa_acid_name']; |
| 138 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; | 154 $sql .= "', wa_acid_perc='" . $row['wa_acid_perc']; |
| 139 $sql .= "', wa_base_name='" . $row['wa_base_name']; | 155 $sql .= "', wa_base_name='" . $row['wa_base_name']; |
| 140 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.037', starter_viability='97"; | 156 $sql .= "', starter_enable='0', starter_type='0', starter_sg='1.037', starter_viability='97"; |
| 141 $sql .= "', prop1_type='0', prop1_volume='0', prop2_type='0', prop2_volume='0"; | 157 $sql .= "', prop1_type='0', prop1_volume='0', prop2_type='0', prop2_volume='0"; |
| 142 $sql .= "', prop3_type='0', prop3_volume='0', prop4_type='0', prop4_volume='0"; | 158 $sql .= "', prop3_type='0', prop3_volume='0', prop4_type='0', prop4_volume='0"; |
| 159 $sql .= "', divide_type='0', divide_parts='0', divide_part='0', divide_size='0', divide_factor='1.0"; | |
| 143 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); | 160 $sql .= "', json_fermentables='" . str_replace($rescapers,$rreplacements,$row['json_fermentables']); |
| 144 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); | 161 $sql .= "', json_hops='" . str_replace($rescapers,$rreplacements,$row['json_hops']); |
| 145 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); | 162 $sql .= "', json_miscs='" . str_replace($rescapers,$rreplacements,$row['json_miscs']); |
| 146 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); | 163 $sql .= "', json_yeasts='" . str_replace($rescapers,$rreplacements,$row['json_yeasts']); |
| 147 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); | 164 $sql .= "', json_mashs='" . str_replace($rescapers,$rreplacements,$row['json_mashs']); |
