Mercurial > bms / file comparison

comparison: www/rec_beerxml.php

www/rec_beerxml.php

branch
stable
changeset 665
4d01937ae7af
parent 605
538627a5555c
child 667
1246550451ca
equal deleted inserted replaced
521:9d1aa6f3a4da 665:4d01937ae7af
1 <?php 1 <?php
2 //require_once('config.php');
3 //require_once('includes/formulas.php');
4 require_once($_SERVER['DOCUMENT_ROOT'].'/config.php'); 2 require_once($_SERVER['DOCUMENT_ROOT'].'/config.php');
5 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); 3 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php');
6 4
7 5
8 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); 6 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
34 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle', 'Dry' ); 32 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle', 'Dry' );
35 $yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' ); 33 $yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' );
36 $misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' ); 34 $misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' );
37 $miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' ); 35 $miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' );
38 $mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' ); 36 $mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' );
37 $colormethod = array( 'Morey', 'Mosher', 'Daniels', 'Halberstadt', 'Naudts' );
38 $ibumethod = array( 'Tinseth', 'Rager', 'Daniels', 'Garetz', 'Mosher', 'Noonan' );
39 39
40 40
41 /* 41 /*
42 * Create beerxml output 42 * Create beerxml output
43 */ 43 */
85 85
86 xmlwriter_start_element($xw, 'EFFICIENCY'); 86 xmlwriter_start_element($xw, 'EFFICIENCY');
87 xmlwriter_text($xw, sprintf("%.1f",floatval($row['efficiency']))); 87 xmlwriter_text($xw, sprintf("%.1f",floatval($row['efficiency'])));
88 xmlwriter_end_element($xw); 88 xmlwriter_end_element($xw);
89 89
90 if (floatval($row['est_og']) > 0) {
91 xmlwriter_start_element($xw, 'EST_OG');
92 xmlwriter_text($xw, sprintf("%.3f",floatval($row['est_og'])));
93 xmlwriter_end_element($xw);
94 }
95
96 if (floatval($row['est_fg']) > 0) {
97 xmlwriter_start_element($xw, 'EST_FG');
98 xmlwriter_text($xw, sprintf("%.3f",floatval($row['est_fg'])));
99 xmlwriter_end_element($xw);
100 }
101
102 if (floatval($row['est_abv']) > 0) {
103 xmlwriter_start_element($xw, 'EST_ABV');
104 xmlwriter_text($xw, sprintf("%.1f",floatval($row['est_abv'])));
105 xmlwriter_end_element($xw);
106 }
107
108 if (floatval($row['est_color']) > 0) {
109 xmlwriter_start_element($xw, 'EST_COLOR');
110 xmlwriter_text($xw, sprintf("%.6f", ebc_to_srm(floatval($row['est_color']))));
111 xmlwriter_end_element($xw);
112 xmlwriter_start_element($xw, 'COLOR_METHOD');
113 xmlwriter_text($xw, $colormethod[$row['color_method']]);
114 xmlwriter_end_element($xw);
115 }
116
117 if (floatval($row['est_ibu']) > 0) {
118 xmlwriter_start_element($xw, 'EST_IBU');
119 xmlwriter_text($xw, sprintf("%.1f",floatval($row['est_ibu'])));
120 xmlwriter_end_element($xw);
121 xmlwriter_start_element($xw, 'IBU_METHOD');
122 xmlwriter_text($xw, $ibumethod[$row['ibu_method']]);
123 xmlwriter_end_element($xw);
124 }
125
90 126
91 // Style 127 // Style
92 xmlwriter_start_element($xw, 'STYLE'); 128 xmlwriter_start_element($xw, 'STYLE');
93 129
94 xmlwriter_start_element($xw, 'VERSION'); 130 xmlwriter_start_element($xw, 'VERSION');
126 xmlwriter_start_element($xw, 'OG_MAX'); 162 xmlwriter_start_element($xw, 'OG_MAX');
127 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_max']))); 163 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_max'])));
128 xmlwriter_end_element($xw); 164 xmlwriter_end_element($xw);
129 165
130 xmlwriter_start_element($xw, 'FG_MIN'); 166 xmlwriter_start_element($xw, 'FG_MIN');
131 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min']))); 167 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_fg_min'])));
132 xmlwriter_end_element($xw); 168 xmlwriter_end_element($xw);
133 169
134 xmlwriter_start_element($xw, 'OG_MAX'); 170 xmlwriter_start_element($xw, 'FG_MAX');
135 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_fg_max']))); 171 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_fg_max'])));
136 xmlwriter_end_element($xw); 172 xmlwriter_end_element($xw);
137 173
138 xmlwriter_start_element($xw, 'IBU_MIN'); 174 xmlwriter_start_element($xw, 'IBU_MIN');
139 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_min']))); 175 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_min'])));
251 287
252 288
253 xmlwriter_start_element($xw, 'FERMENTABLES'); 289 xmlwriter_start_element($xw, 'FERMENTABLES');
254 $arr = json_decode($row['json_fermentables'], true); 290 $arr = json_decode($row['json_fermentables'], true);
255 foreach($arr as $item) { //foreach element in $arr 291 foreach($arr as $item) { //foreach element in $arr
292 if ($item['f_added'] <= 3) {
256 xmlwriter_start_element($xw, 'FERMENTABLE'); 293 xmlwriter_start_element($xw, 'FERMENTABLE');
257 294
258 xmlwriter_start_element($xw, 'VERSION'); 295 xmlwriter_start_element($xw, 'VERSION');
259 xmlwriter_text($xw, '1'); 296 xmlwriter_text($xw, '1');
260 xmlwriter_end_element($xw); 297 xmlwriter_end_element($xw);
328 xmlwriter_start_element($xw, 'GRAINTYPE'); 365 xmlwriter_start_element($xw, 'GRAINTYPE');
329 xmlwriter_text($xw, $graintype[$item['f_graintype']]); 366 xmlwriter_text($xw, $graintype[$item['f_graintype']]);
330 xmlwriter_end_element($xw); 367 xmlwriter_end_element($xw);
331 368
332 xmlwriter_end_element($xw); // FERMENTABLE 369 xmlwriter_end_element($xw); // FERMENTABLE
370 }
333 } 371 }
334 xmlwriter_end_element($xw); // FERMENTABLES 372 xmlwriter_end_element($xw); // FERMENTABLES
335 373
336 374
337 xmlwriter_start_element($xw, 'MISCS'); 375 xmlwriter_start_element($xw, 'MISCS');
449 487
450 xmlwriter_start_element($xw, 'CALCIUM'); 488 xmlwriter_start_element($xw, 'CALCIUM');
451 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_calcium']))); 489 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_calcium'])));
452 xmlwriter_end_element($xw); 490 xmlwriter_end_element($xw);
453 491
492 xmlwriter_start_element($xw, 'MAGNESIUM');
493 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_magnesium'])));
494 xmlwriter_end_element($xw);
495
454 xmlwriter_start_element($xw, 'BICARBONATE'); 496 xmlwriter_start_element($xw, 'BICARBONATE');
455 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22)); 497 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22));
456 xmlwriter_end_element($xw); 498 xmlwriter_end_element($xw);
457 499
458 xmlwriter_start_element($xw, 'SULFATE'); 500 xmlwriter_start_element($xw, 'SULFATE');
492 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_amount']))); 534 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_amount'])));
493 xmlwriter_end_element($xw); 535 xmlwriter_end_element($xw);
494 536
495 xmlwriter_start_element($xw, 'CALCIUM'); 537 xmlwriter_start_element($xw, 'CALCIUM');
496 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_calcium']))); 538 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_calcium'])));
539 xmlwriter_end_element($xw);
540
541 xmlwriter_start_element($xw, 'MAGNESIUM');
542 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_magnesium'])));
497 xmlwriter_end_element($xw); 543 xmlwriter_end_element($xw);
498 544
499 xmlwriter_start_element($xw, 'BICARBONATE'); 545 xmlwriter_start_element($xw, 'BICARBONATE');
500 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22)); 546 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22));
501 xmlwriter_end_element($xw); 547 xmlwriter_end_element($xw);

Mercurial Repository: bms

mercurial