www/rec_toproduct.php

changeset 303
98c2afc88780
child 304
c0ca21cdd291
equal deleted inserted replaced
302:d0f7b4ab000f 303:98c2afc88780
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;

mercurial