Fri, 01 Mar 2019 14:29:09 +0100
Added recipe export menu.
303 | 1 | <?php |
2 | require_once('config.php'); | |
3 | ||
4 | ||
5 | $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
6 | if (! $link) { | |
7 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
8 | } | |
9 | if (! mysqli_set_charset($link, "utf8" )) { | |
10 | echo "error"; | |
11 | return 1; | |
12 | } | |
13 | ||
14 | date_default_timezone_set('Europe/Amsterdam'); | |
15 | if (isset($_GET["record"])) | |
16 | $record = $_GET["record"]; | |
17 | else | |
18 | $record = 78; | |
19 | $result = mysqli_query($link, "SELECT * FROM recipes WHERE record='".$record."'"); | |
20 | $row = mysqli_fetch_array($result); | |
21 | ||
22 | ||
23 | /* | |
24 | * Copy this to a fresh product. | |
25 | */ | |
26 | $sql = "INSERT INTO `products` SET "; | |
27 | $sql .= "name='" . mysqli_real_escape_string($link, $row['name']); | |
28 | $sql .= "', uuid='" . str_replace("\n", "", file_get_contents('/proc/sys/kernel/random/uuid')); | |
29 | $sql .= "', code='" . date("YmdHi"); | |
30 | $sql .= "', birth='" . date("Y-m-d"); | |
31 | $sql .= "', stage='1"; | |
32 | $sql .= "', notes='" . mysqli_real_escape_string($link, $row['notes']); | |
33 | $sql .= "', log_brew='0', log_fermentation='0', inventory_reduced='0', locked='0"; | |
34 | // Equipment | |
35 | $sql .= "', eq_name='Kies zelf een installatie!"; | |
36 | $sql .= "', eq_boil_size='" . $row['boil_size']; | |
37 | $sql .= "', eq_batch_size='" . $row['batch_size']; | |
38 | $sql .= "', eq_tun_volume='20', eq_tun_weight='2', eq_tun_specific_heat='0.11', eq_tun_material='0"; | |
39 | $sql .= "', eq_tun_height='20', eq_top_up_water='0', eq_trub_chiller_loss='0.5', eq_evap_rate='1.8"; | |
40 | $sql .= "', eq_boil_time='" . $row['boil_time']; | |
41 | $sql .= "', eq_calc_boil_volume='1', eq_top_up_kettle='0', eq_hop_utilization='100', eq_notes='"; | |
42 | $sql .= "', eq_lauter_volume='20', eq_lauter_height='20', eq_lauter_deadspace='0.5', eq_kettle_volume='20"; | |
43 | $sql .= "', eq_kettle_height='20', eq_mash_volume='18', eq_mash_max='6', eq_efficiency='75"; | |
44 | // brewdate | |
45 | $sql .= "', brew_date_start=NULL, brew_mash_ph='0.0', brew_mash_sg='1.000"; | |
46 | $sql .= "', brew_sparge_temperature='0', brew_sparge_volume='0', brew_sparge_ph='0.0"; | |
47 | $sql .= "', brew_preboil_volume='0', brew_preboil_sg='0', brew_preboil_ph='0.0"; | |
48 | $sql .= "', brew_aboil_volume='0', brew_aboil_sg='0', brew_aboil_ph='0.0', brew_aboil_efficiency='0"; | |
49 | $sql .= "', brew_cooling_method='0', brew_cooling_time='0', brew_cooling_to='20"; | |
50 | $sql .= "', brew_whirlpool9='0', brew_whirlpool7='0', brew_whirlpool6='0', brew_whirlpool2='0"; | |
51 | $sql .= "', brew_aeration_time='0', brew_aeration_speed='0', brew_aeration_type='0"; | |
52 | $sql .= "', brew_fermenter_volume='" . floatval($row['batch_size']) - 0.5; | |
53 | $sql .= "', brew_fermenter_extrawater='0', brew_fermenter_tcloss='0.5', brew_fermenter_sg='0"; | |
54 | $sql .= "', brew_fermenter_ibu='0', brew_fermenter_color='0', brew_date_end=NULL, og='0', fg='0"; | |
55 | $sql .= "', primary_start_temp='0', primary_max_temp='0', primary_end_temp='0', primary_end_date=NULL, primary_end_sg='0"; | |
56 | $sql .= "', secondary_temp='0', secondary_end_date=NULL, tertiary_temp='0"; | |
57 | $sql .= "', package_date=NULL"; | |
58 | $sql .= ", bottle_amount='0', bottle_carbonation='0', bottle_priming_sugar='0', bottle_priming_amount='0', bottle_carbonation_temp='23"; | |
59 | $sql .= "', keg_amount='0', keg_carbonation='0', keg_priming_sugar='0', keg_priming_amount='0', keg_carbonation_temp='23"; | |
60 | $sql .= "', keg_forced_carb='0', keg_pressure='0"; | |
61 | $sql .= "', taste_notes='"; | |
62 | $sql .= "', taste_rate='0"; | |
63 | $sql .= "', taste_date=NULL"; | |
64 | $sql .= ", taste_color='"; | |
65 | $sql .= "', taste_transparency='"; | |
66 | $sql .= "', taste_head='"; | |
67 | $sql .= "', taste_aroma='"; | |
68 | $sql .= "', taste_taste='"; | |
69 | $sql .= "', taste_mouthfeel='"; | |
70 | $sql .= "', taste_aftertaste='"; | |
71 | // Style | |
72 | $sql .= "', st_name='" . mysqli_real_escape_string($link, $row['st_name']); | |
73 | $sql .= "', st_letter='" . mysqli_real_escape_string($link, $row['st_letter']); | |
74 | $sql .= "', st_guide='" . mysqli_real_escape_string($link, $row['st_guide']); | |
75 | $sql .= "', st_type='" . $row['st_type']; | |
76 | $sql .= "', st_category='" . mysqli_real_escape_string($link, $row['st_category']); | |
77 | $sql .= "', st_category_number='" . $row['st_category_number']; | |
78 | $sql .= "', st_og_min='" . $row['st_og_min']; | |
79 | $sql .= "', st_og_max='" . $row['st_og_max']; | |
80 | $sql .= "', st_fg_min='" . $row['st_fg_min']; | |
81 | $sql .= "', st_fg_max='" . $row['st_fg_max']; | |
82 | $sql .= "', st_ibu_min='" . $row['st_ibu_min']; | |
83 | $sql .= "', st_ibu_max='" . $row['st_ibu_max']; | |
84 | $sql .= "', st_color_min='" . $row['st_color_min']; | |
85 | $sql .= "', st_color_max='" . $row['st_color_max']; | |
86 | $sql .= "', st_carb_min='" . $row['st_carb_min']; | |
87 | $sql .= "', st_carb_max='" . $row['st_carb_max']; | |
88 | $sql .= "', st_abv_min='" . $row['st_abv_min']; | |
89 | $sql .= "', st_abv_max='" . $row['st_abv_max']; | |
90 | $sql .= "', type='" . $row['type']; | |
91 | $sql .= "', batch_size='" . $row['batch_size']; | |
92 | $sql .= "', boil_size='" . $row['boil_size']; | |
93 | $sql .= "', boil_time='" . $row['boil_time']; | |
94 | $sql .= "', efficiency='" . $row['efficiency']; | |
95 | $sql .= "', est_og='0.000"; | |
96 | $sql .= "', est_fg='0.000"; | |
97 | $sql .= "', est_abv='0.0"; | |
98 | $sql .= "', est_carb='0"; | |
99 | $sql .= "', est_color='0"; | |
100 | $sql .= "', color_method='0"; | |
101 | $sql .= "', est_ibu='0"; | |
102 | $sql .= "', ibu_method='0"; | |
103 | $sql .= "', sparge_temp='85"; | |
104 | $sql .= "', sparge_ph='5.8"; | |
105 | $sql .= "', sparge_volume='" . floatval($row['boil_size']) / 2; | |
106 | $sql .= "', sparge_source='0"; | |
107 | $sql .= "', sparge_acid_type='0"; | |
108 | $sql .= "', sparge_acid_perc='80"; | |
109 | $sql .= "', sparge_acid_amount='0"; | |
110 | $sql .= "', mash_ph='5.4"; | |
111 | $sql .= "', mash_name='"; | |
112 | $sql .= "', calc_acid='1"; | |
113 | $sql .= "', w1_name='Tap water"; | |
114 | $sql .= "', w1_amount='18"; | |
115 | $sql .= "', w1_calcium='0"; | |
116 | $sql .= "', w1_sulfate='0"; | |
117 | $sql .= "', w1_chloride='0"; | |
118 | $sql .= "', w1_sodium='0"; | |
119 | $sql .= "', w1_magnesium='0"; | |
120 | $sql .= "', w1_total_alkalinity='0"; | |
121 | $sql .= "', w1_ph='7.0"; | |
122 | $sql .= "', w1_cost='0.0"; | |
123 | $sql .= "', wa_acid_name='0"; | |
124 | $sql .= "', wa_acid_perc='0"; | |
125 | $sql .= "', wa_base_name='0"; | |
126 | $sql .= "', json_fermentables='" . $row['json_fermentables']; | |
127 | $sql .= "', json_hops='" . $row['json_hops']; | |
128 | $sql .= "', json_miscs='" . $row['json_miscs']; | |
129 | $sql .= "', json_yeasts='" . $row['json_yeasts']; | |
130 | $sql .= "', json_mashs='" . $row['json_mashs']; | |
131 | $sql .= "';"; | |
132 | syslog(LOG_NOTICE, $sql); | |
133 | ||
134 | $result = mysqli_query($link, $sql); | |
135 | if (! $result) { | |
136 | syslog(LOG_NOTICE, "rec_toproduct: result: ".mysqli_error($link)); | |
137 | } else { | |
138 | $lastid = mysqli_insert_id($link); | |
139 | syslog(LOG_NOTICE, "rec_toproduct: inserted record ".$lastid); | |
140 | } | |
141 | echo "<script>window.close();</script>"; | |
142 | exit; |