Mercurial > bms / file comparison

comparison: www/import/from_brouwhulp.php

www/import/from_brouwhulp.php

changeset 118
07daa505d309
parent 114
4935e86b2775
child 119
ae5e8d740173
equal deleted inserted replaced
117:9e378e37f20f 118:07daa505d309
50 foreach ($myfermentables->FERMENTABLE as $fermentable) { 50 foreach ($myfermentables->FERMENTABLE as $fermentable) {
51 51
52 $sql = "INSERT INTO inventory_fermentables SET name='" . mysqli_real_escape_string($db, $fermentable->NAME); 52 $sql = "INSERT INTO inventory_fermentables SET name='" . mysqli_real_escape_string($db, $fermentable->NAME);
53 $sql .= "', type='" . $fermentable->TYPE; 53 $sql .= "', type='" . $fermentable->TYPE;
54 if ($fermentable->YIELD) 54 if ($fermentable->YIELD)
55 $sql .= "', yield='" . $fermentable->YIELD; 55 $sql .= "', yield='" . floatval($fermentable->YIELD);
56 if ($fermentable->COLOR) { 56 if ($fermentable->COLOR) {
57 $srm = floatval($fermentable->COLOR); 57 $srm = floatval($fermentable->COLOR);
58 $ebc = srm_to_ebc($srm); 58 $ebc = srm_to_ebc($srm);
59 $sql .= "', color='" . $ebc; 59 $sql .= "', color='" . $ebc;
60 } 60 }
61 ($fermentable->ADD_AFTER_BOIL == "TRUE") ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0"; 61 ($fermentable->ADD_AFTER_BOIL == "TRUE") ? $sql .= "', add_after_boil='1" : $sql .= "', add_after_boil='0";
62 $sql .= "', origin='" . mysqli_real_escape_string($db, $fermentable->ORIGIN); 62 $sql .= "', origin='" . mysqli_real_escape_string($db, $fermentable->ORIGIN);
63 $sql .= "', supplier='" . mysqli_real_escape_string($db, $fermentable->SUPPLIER); 63 $sql .= "', supplier='" . mysqli_real_escape_string($db, $fermentable->SUPPLIER);
64 $sql .= "', notes='" . mysqli_real_escape_string($db, $fermentable->NOTES); 64 $sql .= "', notes='" . mysqli_real_escape_string($db, $fermentable->NOTES);
65 if ($fermentable->COARSE_FINE_DIFF) 65 if ($fermentable->COARSE_FINE_DIFF)
66 $sql .= "', coarse_fine_diff='" . $fermentable->COARSE_FINE_DIFF; 66 $sql .= "', coarse_fine_diff='" . floatval($fermentable->COARSE_FINE_DIFF);
67 if ($fermentable->MOISTURE) 67 if ($fermentable->MOISTURE)
68 $sql .= "', moisture='" . $fermentable->MOISTURE; 68 $sql .= "', moisture='" . floatval($fermentable->MOISTURE);
69 if ($fermentable->DIASTATIC_POWER) 69 if ($fermentable->DIASTATIC_POWER)
70 $sql .= "', diastatic_power='" . $fermentable->DIASTATIC_POWER; 70 $sql .= "', diastatic_power='" . floatval($fermentable->DIASTATIC_POWER);
71 if ($fermentable->PROTEIN) 71 if ($fermentable->PROTEIN)
72 $sql .= "', protein='" . $fermentable->PROTEIN; 72 $sql .= "', protein='" . floatval($fermentable->PROTEIN);
73 if ($fermentable->MAX_IN_BATCH) 73 if ($fermentable->MAX_IN_BATCH)
74 $sql .= "', max_in_batch='" . $fermentable->MAX_IN_BATCH; 74 $sql .= "', max_in_batch='" . floatval($fermentable->MAX_IN_BATCH);
75 ($fermentable->RECOMMEND_MASH == "TRUE") ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0"; 75 ($fermentable->RECOMMEND_MASH == "TRUE") ? $sql .= "', recommend_mash='1" : $sql .= "', recommend_mash='0";
76 if ($fermentable->IBU_GAL_PER_LB) 76 if ($fermentable->IBU_GAL_PER_LB)
77 $sql .= "', ibu_gal_per_lb='" . $fermentable->IBU_GAL_PER_LB; 77 $sql .= "', ibu_gal_per_lb='" . floatval($fermentable->IBU_GAL_PER_LB);
78 ($fermentable->ALWAYS_ON_STOCK == "TRUE") ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; 78 ($fermentable->ALWAYS_ON_STOCK == "TRUE") ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
79 if ($fermentable->INVENTORY) 79 if ($fermentable->INVENTORY)
80 $sql .= "', inventory='" . floatval($fermentable->INVENTORY); 80 $sql .= "', inventory='" . floatval($fermentable->INVENTORY);
81 if ($fermentable->COST) 81 if ($fermentable->COST)
82 $sql .= "', cost='" . floatval($fermentable->COST); 82 $sql .= "', cost='" . floatval($fermentable->COST);
83 /* 83 /*
84 * These are not beerxml standard: 84 * These are not beerxml standard:
85 */ 85 */
86 if ($fermentable->DI_pH) 86 if ($fermentable->DI_pH)
87 $sql .= "', di_ph='" . $fermentable->DI_pH; 87 $sql .= "', di_ph='" . floatval($fermentable->DI_pH);
88 if ($fermentable->{'ACID_TO_pH_5.7'}) 88 if ($fermentable->{'ACID_TO_pH_5.7'})
89 $sql .= "', acid_to_ph_57='" . $fermentable->{'ACID_TO_pH_5.7'}; 89 $sql .= "', acid_to_ph_57='" . floatval($fermentable->{'ACID_TO_pH_5.7'});
90 $sql .= "', graintype='" . $fermentable->GRAINTYPE; 90 $sql .= "', graintype='" . $fermentable->GRAINTYPE;
91 $sql .= "';"; 91 $sql .= "';";
92 if (! $result = mysqli_query($db, $sql)) { 92 if (! $result = mysqli_query($db, $sql)) {
93 printf("Error: %s\n", mysqli_error($db)); 93 printf("Error: %s\n", mysqli_error($db));
94 } 94 }
110 110
111 foreach ($myhops->HOP as $hop) { 111 foreach ($myhops->HOP as $hop) {
112 112
113 $sql = "INSERT INTO inventory_hops SET name='" . mysqli_real_escape_string($db, $hop->NAME); 113 $sql = "INSERT INTO inventory_hops SET name='" . mysqli_real_escape_string($db, $hop->NAME);
114 if ($hop->ALPHA) 114 if ($hop->ALPHA)
115 $sql .= "', alpha='" . $hop->ALPHA; 115 $sql .= "', alpha='" . floatval($hop->ALPHA);
116 if ($hop->BETA) 116 if ($hop->BETA)
117 $sql .= "', beta='" . $hop->BETA; 117 $sql .= "', beta='" . floatval($hop->BETA);
118 if ($hop->HUMULENE) 118 if ($hop->HUMULENE)
119 $sql .= "', humulene='" . $hop->HUMULENE; 119 $sql .= "', humulene='" . floatval($hop->HUMULENE);
120 if ($hop->CARYOPHYLLENE) 120 if ($hop->CARYOPHYLLENE)
121 $sql .= "', caryophyllene='" . $hop->CARYOPHYLLENE; 121 $sql .= "', caryophyllene='" . floatval($hop->CARYOPHYLLENE);
122 if ($hop->COHUMULONE) 122 if ($hop->COHUMULONE)
123 $sql .= "', cohumulone='" . $hop->COHUMULONE; 123 $sql .= "', cohumulone='" . floatval($hop->COHUMULONE);
124 if ($hop->MYCRENE) 124 if ($hop->MYCRENE)
125 $sql .= "', myrcene='" . $hop->MYCRENE; 125 $sql .= "', myrcene='" . floatval($hop->MYCRENE);
126 if ($hop->HSI) 126 if ($hop->HSI)
127 $sql .= "', hsi='" . $hop->HSI; 127 $sql .= "', hsi='" . floatval($hop->HSI);
128 $sql .= "', useat='Boil"; // brouwhulp says Aroma always :) 128 $sql .= "', useat='Boil"; // brouwhulp says Aroma always :)
129 $sql .= "', type='" . $hop->TYPE; 129 $sql .= "', type='" . $hop->TYPE;
130 $sql .= "', form='" . $hop->FORM; 130 $sql .= "', form='" . $hop->FORM;
131 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES); 131 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES);
132 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN); 132 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN);
135 if ($hop->INVENTORY) 135 if ($hop->INVENTORY)
136 $sql .= "', inventory='" . floatval($hop->INVENTORY) / 1000.0; 136 $sql .= "', inventory='" . floatval($hop->INVENTORY) / 1000.0;
137 if ($hop->COST) 137 if ($hop->COST)
138 $sql .= "', cost='" . floatval($hop->COST); 138 $sql .= "', cost='" . floatval($hop->COST);
139 if ($hop->TOTAL_OIL) 139 if ($hop->TOTAL_OIL)
140 $sql .= "', total_oil='" . $hop->TOTAL_OIL; 140 $sql .= "', total_oil='" . floatval($hop->TOTAL_OIL);
141 $sql .= "';"; 141 $sql .= "';";
142 if (! $result = mysqli_query($db, $sql)) { 142 if (! $result = mysqli_query($db, $sql)) {
143 printf("Error: %s\n", mysqli_error($db)); 143 printf("Error: %s\n", mysqli_error($db));
144 } 144 }
145 } 145 }
166 $sql .= "', type='" . $yeast->TYPE; 166 $sql .= "', type='" . $yeast->TYPE;
167 $sql .= "', form='" . $yeast->FORM; 167 $sql .= "', form='" . $yeast->FORM;
168 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY); 168 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY);
169 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID); 169 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID);
170 if ($yeast->MIN_TEMPERATURE) 170 if ($yeast->MIN_TEMPERATURE)
171 $sql .= "', min_temperature='" . $yeast->MIN_TEMPERATURE; 171 $sql .= "', min_temperature='" . floatval($yeast->MIN_TEMPERATURE);
172 if ($yeast->MAX_TEMPERATURE) 172 if ($yeast->MAX_TEMPERATURE)
173 $sql .= "', max_temperature='" . $yeast->MAX_TEMPERATURE; 173 $sql .= "', max_temperature='" . floatval($yeast->MAX_TEMPERATURE);
174 $sql .= "', flocculation='" . $yeast->FLOCCULATION; 174 $sql .= "', flocculation='" . $yeast->FLOCCULATION;
175 if ($yeast->ATTENUATION) 175 if ($yeast->ATTENUATION)
176 $sql .= "', attenuation='" . $yeast->ATTENUATION; 176 $sql .= "', attenuation='" . floatval($yeast->ATTENUATION);
177 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); 177 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES);
178 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); 178 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR);
179 if ($yeast->MAX_REUSE) 179 if ($yeast->MAX_REUSE)
180 $sql .= "', max_reuse='" . $yeast->MAX_REUSE; 180 $sql .= "', max_reuse='" . $yeast->MAX_REUSE;
181 if ($yeast->INVENTORY) 181 if ($yeast->INVENTORY)
221 $sql = "INSERT INTO profile_water SET name='" . mysqli_real_escape_string($db, $water->NAME); 221 $sql = "INSERT INTO profile_water SET name='" . mysqli_real_escape_string($db, $water->NAME);
222 } 222 }
223 223
224 if ($water->NOTES) 224 if ($water->NOTES)
225 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); 225 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES);
226 $sql .= "', calcium='" . $water->CALCIUM; 226 $sql .= "', calcium='" . floatval($water->CALCIUM);
227 $sql .= "', bicarbonate='" . $water->BICARBONATE; 227 $sql .= "', bicarbonate='" . floatval($water->BICARBONATE);
228 $sql .= "', sulfate='" . $water->SULFATE; 228 $sql .= "', sulfate='" . floatval($water->SULFATE);
229 $sql .= "', chloride='" . $water->CHLORIDE; 229 $sql .= "', chloride='" . floatval($water->CHLORIDE);
230 $sql .= "', sodium='" . $water->SODIUM; 230 $sql .= "', sodium='" . floatval($water->SODIUM);
231 $sql .= "', magnesium='" . $water->MAGNESIUM; 231 $sql .= "', magnesium='" . floatval($water->MAGNESIUM);
232 $sql .= "', ph='" . $water->PH; 232 $sql .= "', ph='" . floatval($water->PH);
233 if ($water->TOTAL_ALKALINITY) 233 if ($water->TOTAL_ALKALINITY)
234 $sql .= "', total_alkalinity='" . $water->TOTAL_ALKALINITY; 234 $sql .= "', total_alkalinity='" . floatval($water->TOTAL_ALKALINITY);
235 $sql .= "';"; 235 $sql .= "';";
236 if (! $result = mysqli_query($db, $sql)) { 236 if (! $result = mysqli_query($db, $sql)) {
237 printf("Error: %s\n", mysqli_error($db)); 237 printf("Error: %s\n", mysqli_error($db));
238 } 238 }
239 } 239 }
292 $equipments = simplexml_load_file($brouwhulp . '/equipments.xml'); 292 $equipments = simplexml_load_file($brouwhulp . '/equipments.xml');
293 293
294 foreach ($equipments->EQUIPMENT as $equipment) { 294 foreach ($equipments->EQUIPMENT as $equipment) {
295 295
296 $sql = "INSERT INTO inventory_equipments SET name='" . mysqli_real_escape_string($db, $equipment->NAME); 296 $sql = "INSERT INTO inventory_equipments SET name='" . mysqli_real_escape_string($db, $equipment->NAME);
297 $sql .= "', boil_size='" . $equipment->BOIL_SIZE; 297 $sql .= "', boil_size='" . floatval($equipment->BOIL_SIZE);
298 $sql .= "', batch_size='" . $equipment->BATCH_SIZE; 298 $sql .= "', batch_size='" . floatval($equipment->BATCH_SIZE);
299 $sql .= "', tun_volume='" . $equipment->TUN_VOLUME; 299 $sql .= "', tun_volume='" . floatval($equipment->TUN_VOLUME);
300 $sql .= "', tun_weight='" . $equipment->TUN_WEIGHT; 300 $sql .= "', tun_weight='" . floatval($equipment->TUN_WEIGHT);
301 $sql .= "', tun_specific_heat='" . $equipment->TUN_SPECIFIC_HEAT; 301 $sql .= "', tun_specific_heat='" . floatval($equipment->TUN_SPECIFIC_HEAT);
302 $sql .= "', top_up_water='" . $equipment->TOP_UP_WATER; 302 $sql .= "', tun_material='" . mysqli_real_escape_string($db, $equipment->TUN_MATERIAL);
303 $sql .= "', trub_chiller_loss='" . $equipment->TRUB_CHILLER_LOSS; 303 $sql .= "', tun_height='" . floatval($equipment->TUN_HEIGHT);
304 $sql .= "', top_up_water='" . floatval($equipment->TOP_UP_WATER);
305 $sql .= "', trub_chiller_loss='" . floatval($equipment->TRUB_CHILLER_LOSS);
304 /* 306 /*
305 * Brouwhulp uses a percentage for the evaporation rate. This is wrong 307 * Brouwhulp uses a percentage for the evaporation rate. This is wrong
306 * but was made so because the beerxml standard requires this. What we 308 * but was made so because the beerxml standard requires this. What we
307 * do is calculate the actual evaporation and store that. 309 * do is calculate the actual evaporation and store that.
308 * This is what we use. Brouwhulp calculates this on the fly. 310 * This is what we use. Brouwhulp calculates this on the fly.
309 */ 311 */
310 $sql .= "', evap_rate='" . ($equipment->EVAP_RATE * $equipment->BOIL_SIZE) / 100.0; 312 $sql .= "', evap_rate='" . (floatval($equipment->EVAP_RATE) * floatval($equipment->BOIL_SIZE)) / 100.0;
311 $sql .= "', boil_time='" . $equipment->BOIL_TIME; 313 $sql .= "', boil_time='" . floatval($equipment->BOIL_TIME);
312 ($equipment->CALC_BOIL_VOLUME == 'TRUE') ? $sql .= "', calc_boil_volume='1" : $sql .= "', calc_boil_volume='0"; 314 ($equipment->CALC_BOIL_VOLUME == 'TRUE') ? $sql .= "', calc_boil_volume='1" : $sql .= "', calc_boil_volume='0";
313 $sql .= "', lauter_deadspace='" . $equipment->LAUTER_DEADSPACE; 315 $sql .= "', top_up_kettle='" . floatval($equipment->TOP_UP_KETTLE);
314 $sql .= "', top_up_kettle='" . $equipment->TOP_UP_KETTLE; 316 $sql .= "', hop_utilization='" . floatval($equipment->HOP_UTILIZATION);
315 $sql .= "', hop_utilization='" . $equipment->HOP_UTILIZATION;
316 if ($equipment->NOTES) 317 if ($equipment->NOTES)
317 $sql .= "', notes='" . mysqli_real_escape_string($db, $equipment->NOTES); 318 $sql .= "', notes='" . mysqli_real_escape_string($db, $equipment->NOTES);
318 $sql .= "', lauter_volume='" . $equipment->LAUTER_VOLUME; 319 $sql .= "', lauter_volume='" . floatval($equipment->LAUTER_VOLUME);
319 $sql .= "', kettle_volume='" . $equipment->KETTLE_VOLUME; 320 $sql .= "', lauter_height='" . floatval($equipment->LAUTER_HEIGHT);
320 if ($equipment->TUN_MATERIAL) 321 $sql .= "', lauter_deadspace='" . floatval($equipment->LAUTER_DEADSPACE);
321 $sql .= "', tun_material='" . mysqli_real_escape_string($db, $equipment->TUN_MATERIAL); 322 $sql .= "', kettle_volume='" . floatval($equipment->KETTLE_VOLUME);
322 $sql .= "', tun_height='" . $equipment->TUN_HEIGHT; 323 $sql .= "', kettle_height='" . floatval($equipment->KETTLE_HEIGHT);
323 $sql .= "', kettle_height='" . $equipment->KETTLE_HEIGHT; 324 $sql .= "', mash_volume='" . floatval($equipment->MASH_VOLUME);
324 $sql .= "', lauter_height='" . $equipment->LAUTER_HEIGHT; 325 $sql .= "', efficiency='" . floatval($equipment->EFFICIENCY);
325 $sql .= "', mash_volume='" . $equipment->MASH_VOLUME;
326 $sql .= "', efficiency='" . $equipment->EFFICIENCY;
327
328 $sql .= "';"; 326 $sql .= "';";
329 if (! $result = mysqli_query($db, $sql)) { 327 if (! $result = mysqli_query($db, $sql)) {
330 printf("Error: %s\n", mysqli_error($db)); 328 printf("Error: %s\n", mysqli_error($db));
331 } 329 }
332 } 330 }
419 $steps .= '{"step_name":"' . mysqli_real_escape_string($db, $step->NAME) . '"'; 417 $steps .= '{"step_name":"' . mysqli_real_escape_string($db, $step->NAME) . '"';
420 if ($step->TYPE) { 418 if ($step->TYPE) {
421 $steps .= ',"step_type":"' . $step->TYPE . '"'; 419 $steps .= ',"step_type":"' . $step->TYPE . '"';
422 } 420 }
423 if ($step->STEP_TEMP) { 421 if ($step->STEP_TEMP) {
424 $steps .= ',"step_temp":"' . $step->STEP_TEMP . '"'; 422 $steps .= ',"step_temp":"' . floatval($step->STEP_TEMP) . '"';
425 } 423 }
426 if ($step->STEP_TIME) { 424 if ($step->STEP_TIME) {
427 $steps .= ',"step_time":"' . $step->STEP_TIME . '"'; 425 $steps .= ',"step_time":"' . floatval($step->STEP_TIME) . '"';
428 } 426 }
429 if ($step->RAMP_TIME) { 427 if ($step->RAMP_TIME) {
430 $steps .= ',"ramp_time":"' . $step->RAMP_TIME . '"'; 428 $steps .= ',"ramp_time":"' . floatval($step->RAMP_TIME) . '"';
431 } 429 }
432 if ($step->END_TEMP) { 430 if ($step->END_TEMP) {
433 $steps .= ',"end_temp":"' . $step->END_TEMP . '"'; 431 $steps .= ',"end_temp":"' . floatval($step->END_TEMP) . '"';
434 } 432 }
435 $steps .= "}"; 433 $steps .= "}";
436 } 434 }
437 $steps .= ']'; 435 $steps .= ']';
438 $sql .= "', steps='" . $steps; 436 $sql .= "', steps='" . $steps;

Mercurial Repository: bms

mercurial