Mercurial > bms / file comparison

comparison: www/prod_export.php

www/prod_export.php

changeset 242
97c237654ddd
parent 177
325bd6425978
child 272
0c2ea1c2b858
equal deleted inserted replaced
241:e95d2886f49f 242:97c237654ddd
16 16
17 //setlocale ( LC_ALL, 'nl_NL.UTF-8'); 17 //setlocale ( LC_ALL, 'nl_NL.UTF-8');
18 if (isset($_GET["record"])) 18 if (isset($_GET["record"]))
19 $record = $_GET["record"]; 19 $record = $_GET["record"];
20 else 20 else
21 $record = 14; 21 $record = 78;
22 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'"); 22 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'");
23 $row = mysqli_fetch_array($result); 23 $row = mysqli_fetch_array($result);
24
25
26 $recipetype = array( 'Extract', 'Partial Mash', 'All Grain' );
27 $styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' );
28 $hoptype = array( 'Bittering', 'Aroma', 'Both' );
29 $hopform = array( 'Pellet', 'Plug', 'Leaf' );
30 $hopuse = array( 'Mash', 'First wort', 'Boil', 'Aroma', 'Whirlpool', 'Dry hop' );
31 $fermentabletype = array( 'Grain', 'Sugar', 'Extract', 'Dry extract', 'Adjunct' );
32 $graintype = array( 'Base', 'Roast', 'Crystal', 'Kilned', 'Sour malt', 'Special', 'No malt' );
33 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne' );
34 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle' );
35 $yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' );
36 $misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' );
37 $miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' );
38 $mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' );
24 39
25 40
26 41
27 /* 42 /*
28 * Create beerxml output 43 * Create beerxml output
48 xmlwriter_start_element($xw, 'NOTES'); 63 xmlwriter_start_element($xw, 'NOTES');
49 xmlwriter_text($xw, $row['notes']); 64 xmlwriter_text($xw, $row['notes']);
50 xmlwriter_end_element($xw); 65 xmlwriter_end_element($xw);
51 66
52 xmlwriter_start_element($xw, 'TYPE'); 67 xmlwriter_start_element($xw, 'TYPE');
53 xmlwriter_text($xw, $row['type']); 68 xmlwriter_text($xw, $recipetype[$row['type']]);
54 xmlwriter_end_element($xw); 69 xmlwriter_end_element($xw);
55 70
56 xmlwriter_start_element($xw, 'BREWER'); 71 xmlwriter_start_element($xw, 'BREWER');
57 xmlwriter_text($xw, 'Anonymous'); 72 xmlwriter_text($xw, 'Anonymous');
58 xmlwriter_end_element($xw); 73 xmlwriter_end_element($xw);
107 xmlwriter_start_element($xw, 'STYLE_GUIDE'); 122 xmlwriter_start_element($xw, 'STYLE_GUIDE');
108 xmlwriter_text($xw, $row['st_guide']); 123 xmlwriter_text($xw, $row['st_guide']);
109 xmlwriter_end_element($xw); 124 xmlwriter_end_element($xw);
110 125
111 xmlwriter_start_element($xw, 'TYPE'); 126 xmlwriter_start_element($xw, 'TYPE');
112 xmlwriter_text($xw, $row['st_type']); 127 xmlwriter_text($xw, $styletype[$row['st_type']]);
113 xmlwriter_end_element($xw); 128 xmlwriter_end_element($xw);
114 129
115 xmlwriter_start_element($xw, 'OG_MIN'); 130 xmlwriter_start_element($xw, 'OG_MIN');
116 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min']))); 131 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min'])));
117 xmlwriter_end_element($xw); 132 xmlwriter_end_element($xw);
211 xmlwriter_start_element($xw, 'AMOUNT'); 226 xmlwriter_start_element($xw, 'AMOUNT');
212 xmlwriter_text($xw, sprintf("%.4f",floatval($item['h_amount']))); 227 xmlwriter_text($xw, sprintf("%.4f",floatval($item['h_amount'])));
213 xmlwriter_end_element($xw); 228 xmlwriter_end_element($xw);
214 229
215 xmlwriter_start_element($xw, 'USE'); 230 xmlwriter_start_element($xw, 'USE');
216 xmlwriter_text($xw, $item['h_useat']); 231 xmlwriter_text($xw, $hopuse[$item['h_useat']]);
217 xmlwriter_end_element($xw); 232 xmlwriter_end_element($xw);
218 233
219 xmlwriter_start_element($xw, 'TIME'); 234 xmlwriter_start_element($xw, 'TIME');
220 xmlwriter_text($xw, $item['h_time']); 235 xmlwriter_text($xw, $item['h_time']);
221 xmlwriter_end_element($xw); 236 xmlwriter_end_element($xw);
222 237
223 xmlwriter_start_element($xw, 'TYPE'); 238 xmlwriter_start_element($xw, 'TYPE');
224 xmlwriter_text($xw, $item['h_type']); 239 xmlwriter_text($xw, $hoptype[$item['h_type']]);
225 xmlwriter_end_element($xw); 240 xmlwriter_end_element($xw);
226 241
227 xmlwriter_start_element($xw, 'FORM'); 242 xmlwriter_start_element($xw, 'FORM');
228 xmlwriter_text($xw, $item['h_form']); 243 xmlwriter_text($xw, $hopform[$item['h_form']]);
229 xmlwriter_end_element($xw); 244 xmlwriter_end_element($xw);
230 245
231 xmlwriter_start_element($xw, 'BETA'); 246 xmlwriter_start_element($xw, 'BETA');
232 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_beta']))); 247 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_beta'])));
233 xmlwriter_end_element($xw); 248 xmlwriter_end_element($xw);
256 xmlwriter_start_element($xw, 'NAME'); 271 xmlwriter_start_element($xw, 'NAME');
257 xmlwriter_text($xw, $item['f_name']); 272 xmlwriter_text($xw, $item['f_name']);
258 xmlwriter_end_element($xw); 273 xmlwriter_end_element($xw);
259 274
260 xmlwriter_start_element($xw, 'TYPE'); 275 xmlwriter_start_element($xw, 'TYPE');
261 xmlwriter_text($xw, $item['f_type']); 276 xmlwriter_text($xw, $fermentabletype[$item['f_type']]);
262 xmlwriter_end_element($xw); 277 xmlwriter_end_element($xw);
263 278
264 xmlwriter_start_element($xw, 'AMOUNT'); 279 xmlwriter_start_element($xw, 'AMOUNT');
265 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_amount']))); 280 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_amount'])));
266 xmlwriter_end_element($xw); 281 xmlwriter_end_element($xw);
318 xmlwriter_start_element($xw, 'RECOMMEND_MASH'); 333 xmlwriter_start_element($xw, 'RECOMMEND_MASH');
319 ($item['f_recommend_mash']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE'); 334 ($item['f_recommend_mash']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
320 xmlwriter_end_element($xw); 335 xmlwriter_end_element($xw);
321 336
322 xmlwriter_start_element($xw, 'GRAINTYPE'); 337 xmlwriter_start_element($xw, 'GRAINTYPE');
323 xmlwriter_text($xw, $item['f_graintype']); 338 xmlwriter_text($xw, $graintype[$item['f_graintype']]);
324 xmlwriter_end_element($xw); 339 xmlwriter_end_element($xw);
325 340
326 xmlwriter_end_element($xw); // FERMENTABLE 341 xmlwriter_end_element($xw); // FERMENTABLE
327 } 342 }
328 xmlwriter_end_element($xw); // FERMENTABLES 343 xmlwriter_end_element($xw); // FERMENTABLES
340 xmlwriter_start_element($xw, 'NAME'); 355 xmlwriter_start_element($xw, 'NAME');
341 xmlwriter_text($xw, $item['m_name']); 356 xmlwriter_text($xw, $item['m_name']);
342 xmlwriter_end_element($xw); 357 xmlwriter_end_element($xw);
343 358
344 xmlwriter_start_element($xw, 'TYPE'); 359 xmlwriter_start_element($xw, 'TYPE');
345 xmlwriter_text($xw, $item['m_type']); 360 xmlwriter_text($xw, $misctype[$item['m_type']]);
346 xmlwriter_end_element($xw); 361 xmlwriter_end_element($xw);
347 362
348 xmlwriter_start_element($xw, 'AMOUNT'); 363 xmlwriter_start_element($xw, 'AMOUNT');
349 xmlwriter_text($xw, sprintf("%.5f",floatval($item['m_amount']))); 364 xmlwriter_text($xw, sprintf("%.5f",floatval($item['m_amount'])));
350 xmlwriter_end_element($xw); 365 xmlwriter_end_element($xw);
352 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT'); 367 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
353 ($item['m_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE'); 368 ($item['m_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
354 xmlwriter_end_element($xw); 369 xmlwriter_end_element($xw);
355 370
356 xmlwriter_start_element($xw, 'USE'); 371 xmlwriter_start_element($xw, 'USE');
357 xmlwriter_text($xw, $item['m_use_use']); 372 xmlwriter_text($xw, $miscuse[$item['m_use_use']]);
358 xmlwriter_end_element($xw); 373 xmlwriter_end_element($xw);
359 374
360 xmlwriter_start_element($xw, 'TIME'); 375 xmlwriter_start_element($xw, 'TIME');
361 xmlwriter_text($xw, sprintf("%.0f",floatval($item['m_time']))); 376 xmlwriter_text($xw, sprintf("%.0f",floatval($item['m_time'])));
362 xmlwriter_end_element($xw); 377 xmlwriter_end_element($xw);
378 xmlwriter_start_element($xw, 'NAME'); 393 xmlwriter_start_element($xw, 'NAME');
379 xmlwriter_text($xw, $item['y_name']); 394 xmlwriter_text($xw, $item['y_name']);
380 xmlwriter_end_element($xw); 395 xmlwriter_end_element($xw);
381 396
382 xmlwriter_start_element($xw, 'TYPE'); 397 xmlwriter_start_element($xw, 'TYPE');
383 xmlwriter_text($xw, $item['y_type']); 398 xmlwriter_text($xw, $yeasttype[$item['y_type']]);
384 xmlwriter_end_element($xw); 399 xmlwriter_end_element($xw);
385 400
386 xmlwriter_start_element($xw, 'FORM'); 401 xmlwriter_start_element($xw, 'FORM');
387 xmlwriter_text($xw, $item['y_form']); 402 xmlwriter_text($xw, $yeastform[$item['y_form']]);
388 xmlwriter_end_element($xw); 403 xmlwriter_end_element($xw);
389 404
390 xmlwriter_start_element($xw, 'AMOUNT'); 405 xmlwriter_start_element($xw, 'AMOUNT');
391 xmlwriter_text($xw, sprintf("%.5f",floatval($item['y_amount']))); 406 xmlwriter_text($xw, sprintf("%.5f",floatval($item['y_amount'])));
392 xmlwriter_end_element($xw); 407 xmlwriter_end_element($xw);
393 408
394 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT'); 409 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
395 ($item['y_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE'); 410 ($item['y_form'] == 1) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
396 xmlwriter_end_element($xw); 411 xmlwriter_end_element($xw);
397 412
398 xmlwriter_start_element($xw, 'LABORATORY'); 413 xmlwriter_start_element($xw, 'LABORATORY');
399 xmlwriter_text($xw, $item['y_laboratory']); 414 xmlwriter_text($xw, $item['y_laboratory']);
400 xmlwriter_end_element($xw); 415 xmlwriter_end_element($xw);
414 xmlwriter_start_element($xw, 'ATTENUATION'); 429 xmlwriter_start_element($xw, 'ATTENUATION');
415 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_attenuation']))); 430 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_attenuation'])));
416 xmlwriter_end_element($xw); 431 xmlwriter_end_element($xw);
417 432
418 xmlwriter_start_element($xw, 'ADD_TO_SECONDARY'); 433 xmlwriter_start_element($xw, 'ADD_TO_SECONDARY');
419 ($item['y_use'] == 'Secondary') ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE'); 434 ($item['y_use'] == 0) ? xmlwriter_text($xw, 'FALSE') : xmlwriter_text($xw, 'TRUE');
420 xmlwriter_end_element($xw); 435 xmlwriter_end_element($xw);
421 436
422 xmlwriter_end_element($xw); // YEAST 437 xmlwriter_end_element($xw); // YEAST
423 } 438 }
424 xmlwriter_end_element($xw); // YEASTS 439 xmlwriter_end_element($xw); // YEASTS
549 xmlwriter_start_element($xw, 'NAME'); 564 xmlwriter_start_element($xw, 'NAME');
550 xmlwriter_text($xw, $item['step_name']); 565 xmlwriter_text($xw, $item['step_name']);
551 xmlwriter_end_element($xw); 566 xmlwriter_end_element($xw);
552 567
553 xmlwriter_start_element($xw, 'TYPE'); 568 xmlwriter_start_element($xw, 'TYPE');
554 xmlwriter_text($xw, $item['step_type']); 569 xmlwriter_text($xw, $mashsteptype[$item['step_type']]);
555 xmlwriter_end_element($xw); 570 xmlwriter_end_element($xw);
556 571
557 if ($item['step_type'] == 'Infusion') { 572 if ($item['step_type'] == 0) {
558 xmlwriter_start_element($xw, 'INFUSE_AMOUNT'); 573 xmlwriter_start_element($xw, 'INFUSE_AMOUNT');
559 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_infuse_amount']))); 574 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_infuse_amount'])));
560 xmlwriter_end_element($xw); 575 xmlwriter_end_element($xw);
561 } 576 }
562 577

Mercurial Repository: bms

mercurial