www/prod_beerxml.php

Thu, 27 Jun 2019 13:50:27 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Thu, 27 Jun 2019 13:50:27 +0200
changeset 429
0d2cf505957c
parent 401
4aad74bde00b
child 449
a1d6b9eec988
permissions
-rw-r--r--

Prepared for new yeast types.

177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 require_once('config.php');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require_once('includes/formulas.php');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 //require_once($_SERVER['DOCUMENT_ROOT'].'/config.php');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5 //require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 if (! $link) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 if (! mysqli_set_charset($link, "utf8" )) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 echo "error";
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 return 1;
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 //setlocale ( LC_ALL, 'nl_NL.UTF-8');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 if (isset($_GET["record"]))
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 $record = $_GET["record"];
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20 else
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
21 $record = 78;
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'");
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 $row = mysqli_fetch_array($result);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
24
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
26 $recipetype = array( 'Extract', 'Partial Mash', 'All Grain' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
27 $styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
28 $hoptype = array( 'Bittering', 'Aroma', 'Both' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
29 $hopform = array( 'Pellet', 'Plug', 'Leaf' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
30 $hopuse = array( 'Mash', 'First wort', 'Boil', 'Aroma', 'Whirlpool', 'Dry hop' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
31 $fermentabletype = array( 'Grain', 'Sugar', 'Extract', 'Dry extract', 'Adjunct' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
32 $graintype = array( 'Base', 'Roast', 'Crystal', 'Kilned', 'Sour malt', 'Special', 'No malt' );
429
0d2cf505957c Prepared for new yeast types.
Michiel Broek <mbroek@mbse.eu>
parents: 401
diff changeset
33 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne', 'Other', 'Other', 'Other', 'Other', 'Other' );
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
34 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
35 $yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
36 $misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
37 $miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
38 $mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
39
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
40
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
42 /*
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 * Create beerxml output
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
44 */
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 $xw = xmlwriter_open_memory();
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 xmlwriter_set_indent($xw, 1);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47 $res = xmlwriter_set_indent_string($xw, ' ');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 xmlwriter_start_document($xw, '1.0', 'UTF-8');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 xmlwriter_start_element($xw, 'RECIPES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 xmlwriter_start_element($xw, 'RECIPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 // Recipe basics
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 xmlwriter_text($xw, $row['name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63 xmlwriter_start_element($xw, 'NOTES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 xmlwriter_text($xw, $row['notes']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
68 xmlwriter_text($xw, $recipetype[$row['type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 xmlwriter_start_element($xw, 'BREWER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 xmlwriter_text($xw, 'Anonymous');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 xmlwriter_start_element($xw, 'BATCH_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 xmlwriter_text($xw, sprintf("%.2f",floatval($row['batch_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 xmlwriter_start_element($xw, 'BOIL_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 xmlwriter_text($xw, sprintf("%.2f",floatval($row['boil_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 xmlwriter_start_element($xw, 'BOIL_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 xmlwriter_text($xw, sprintf("%.0f",floatval($row['boil_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 xmlwriter_start_element($xw, 'EFFICIENCY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 xmlwriter_text($xw, sprintf("%.1f",floatval($row['efficiency'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 xmlwriter_start_element($xw, 'OG');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 xmlwriter_text($xw, sprintf("%.3f",floatval($row['og'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 xmlwriter_start_element($xw, 'FG');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 xmlwriter_text($xw, sprintf("%.3f",floatval($row['fg'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98
401
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
99 if ($row['brew_cooling_to'] > 0) {
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
100 xmlwriter_start_element($xw, 'BMS_COOLING_TO');
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
101 xmlwriter_text($xw, sprintf("%.1f",floatval($row['brew_cooling_to'])));
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
102 xmlwriter_end_element($xw);
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
103 }
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
104
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
105 if ($row['brew_whirlpool9'] > 0) {
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
106 xmlwriter_start_element($xw, 'BMS_WHIRLPOOL9');
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
107 xmlwriter_text($xw, sprintf("%.0f",floatval($row['brew_whirlpool9'])));
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
108 xmlwriter_end_element($xw);
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
109 }
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
110 if ($row['brew_whirlpool7'] > 0) {
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
111 xmlwriter_start_element($xw, 'BMS_WHIRLPOOL7');
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
112 xmlwriter_text($xw, sprintf("%.0f",floatval($row['brew_whirlpool7'])));
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
113 xmlwriter_end_element($xw);
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
114 }
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
115 if ($row['brew_whirlpool6'] > 0) {
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
116 xmlwriter_start_element($xw, 'BMS_WHIRLPOOL6');
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
117 xmlwriter_text($xw, sprintf("%.0f",floatval($row['brew_whirlpool6'])));
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
118 xmlwriter_end_element($xw);
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
119 }
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
120 if ($row['brew_whirlpool2'] > 0) {
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
121 xmlwriter_start_element($xw, 'BMS_WHIRLPOOL2');
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
122 xmlwriter_text($xw, sprintf("%.0f",floatval($row['brew_whirlpool2'])));
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
123 xmlwriter_end_element($xw);
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
124 }
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
125
4aad74bde00b In product beerxml export added BMS specific items: cooling_to and whirlpool stages. These should be picked up by the brew computer and should do no harm to the rest of the world.
Michiel Broek <mbroek@mbse.eu>
parents: 400
diff changeset
126
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
127 // Style
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
128 xmlwriter_start_element($xw, 'STYLE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
129
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
130 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
131 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
132 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
133
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
134 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
135 xmlwriter_text($xw, $row['st_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
136 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
137
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
138 xmlwriter_start_element($xw, 'CATEGORY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
139 xmlwriter_text($xw, $row['st_category']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
140 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
141
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
142 xmlwriter_start_element($xw, 'CATEGORY_NUMBER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
143 xmlwriter_text($xw, $row['st_category_number']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
144 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
145
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
146 xmlwriter_start_element($xw, 'STYLE_LETTER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
147 xmlwriter_text($xw, $row['st_letter']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
148 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
149
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
150 xmlwriter_start_element($xw, 'STYLE_GUIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
151 xmlwriter_text($xw, $row['st_guide']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
152 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
153
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
154 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
155 xmlwriter_text($xw, $styletype[$row['st_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
156 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
157
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
158 xmlwriter_start_element($xw, 'OG_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
159 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
160 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
161
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
162 xmlwriter_start_element($xw, 'OG_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
163 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
164 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
165
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
166 xmlwriter_start_element($xw, 'FG_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
167 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
168 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
169
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
170 xmlwriter_start_element($xw, 'OG_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
171 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_fg_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
172 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
173
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
174 xmlwriter_start_element($xw, 'IBU_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
175 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
176 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
178 xmlwriter_start_element($xw, 'IBU_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
179 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
180 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
181
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
182 xmlwriter_start_element($xw, 'COLOR_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
183 xmlwriter_text($xw, sprintf("%.2f",ebc_to_srm(floatval($row['st_color_min']))));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
184 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
185
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
186 xmlwriter_start_element($xw, 'COLOR_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
187 xmlwriter_text($xw, sprintf("%.2f",ebc_to_srm(floatval($row['st_color_max']))));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
188 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
189
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
190 xmlwriter_start_element($xw, 'CARB_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
191 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_carb_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
192 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
193
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
194 xmlwriter_start_element($xw, 'CARB_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
195 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_carb_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
196 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
197
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
198 xmlwriter_start_element($xw, 'ABV_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
199 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_abv_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
200 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
201
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
202 xmlwriter_start_element($xw, 'ABV_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
203 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_abv_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
204 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
205
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
206 xmlwriter_end_element($xw); // STYLE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
207
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
208 xmlwriter_start_element($xw, 'EQUIPMENT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
209
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
210 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
211 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
212 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
213
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
214 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
215 xmlwriter_text($xw, $row['eq_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
216 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
217
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
218 xmlwriter_start_element($xw, 'NOTES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
219 xmlwriter_text($xw, $row['eq_notes']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
220 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
221
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
222 xmlwriter_start_element($xw, 'BATCH_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
223 xmlwriter_text($xw, sprintf("%.2f",floatval($row['eq_batch_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
224 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
225
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
226 xmlwriter_start_element($xw, 'BOIL_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
227 xmlwriter_text($xw, sprintf("%.2f",floatval($row['eq_boil_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
228 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
229
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
230 xmlwriter_start_element($xw, 'BOIL_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
231 xmlwriter_text($xw, sprintf("%.0f",floatval($row['eq_boil_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
232 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
233
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
234 xmlwriter_end_element($xw); // EQUIPMENT
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
235
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
236 xmlwriter_start_element($xw, 'HOPS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
237 $arr = json_decode($row['json_hops'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
238 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
239
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
240 xmlwriter_start_element($xw, 'HOP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
241
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
242 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
243 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
244 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
245
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
246 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
247 xmlwriter_text($xw, $item['h_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
248 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
249
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
250 xmlwriter_start_element($xw, 'ALPHA');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
251 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_alpha'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
252 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
253
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
254 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
255 xmlwriter_text($xw, sprintf("%.4f",floatval($item['h_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
256 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
257
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
258 xmlwriter_start_element($xw, 'USE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
259 xmlwriter_text($xw, $hopuse[$item['h_useat']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
260 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
261
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
262 xmlwriter_start_element($xw, 'TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
263 xmlwriter_text($xw, $item['h_time']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
264 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
265
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
266 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
267 xmlwriter_text($xw, $hoptype[$item['h_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
268 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
269
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
270 xmlwriter_start_element($xw, 'FORM');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
271 xmlwriter_text($xw, $hopform[$item['h_form']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
272 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
273
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
274 xmlwriter_start_element($xw, 'BETA');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
275 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_beta'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
276 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
277
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
278 xmlwriter_start_element($xw, 'HSI');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
279 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_hsi'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
280 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
281
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
282 xmlwriter_start_element($xw, 'ORIGIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
283 xmlwriter_text($xw, $item['h_origin']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
284 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
285
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
286 xmlwriter_end_element($xw); // HOP
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
287 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
288 xmlwriter_end_element($xw); // HOPS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
289
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
290 xmlwriter_start_element($xw, 'FERMENTABLES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
291 $arr = json_decode($row['json_fermentables'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
292 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
293 xmlwriter_start_element($xw, 'FERMENTABLE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
294
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
295 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
296 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
297 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
298
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
299 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
300 xmlwriter_text($xw, $item['f_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
301 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
302
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
303 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
304 xmlwriter_text($xw, $fermentabletype[$item['f_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
305 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
306
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
307 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
308 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
309 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
310
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
311 xmlwriter_start_element($xw, 'YIELD');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
312 xmlwriter_text($xw, sprintf("%.1f",floatval($item['f_yield'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
313 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
314
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
315 xmlwriter_start_element($xw, 'COLOR');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
316 xmlwriter_text($xw, sprintf("%.1f",ebc_to_srm(floatval($item['f_color']))));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
317 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
318
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
319 xmlwriter_start_element($xw, 'ADD_AFTER_BOIL');
400
6d07c51e7540 Fixed beerxml output for fermentables added after the boil.
Michiel Broek <mbroek@mbse.eu>
parents: 301
diff changeset
320 ($item['f_added'] > 1) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
321 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
322
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
323 xmlwriter_start_element($xw, 'ORIGIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
324 xmlwriter_text($xw, $item['f_origin']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
325 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
326
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
327 xmlwriter_start_element($xw, 'SUPPLIER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
328 xmlwriter_text($xw, $item['f_supplier']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
329 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
330
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
331 if (floatval($item['f_coarse_fine_diff'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
332 xmlwriter_start_element($xw, 'COARSE_FINE_DIFF');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
333 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_coarse_fine_diff'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
334 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
335 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
336
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
337 if (floatval($item['f_moisture'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
338 xmlwriter_start_element($xw, 'MOISTURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
339 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_moisture'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
340 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
341 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
342
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
343 if (floatval($item['f_diastatic_power'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
344 xmlwriter_start_element($xw, 'DIASTATIC_POWER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
345 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_diastatic_power'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
346 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
347 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
348
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
349 if (floatval($item['f_protein'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
350 xmlwriter_start_element($xw, 'PROTEIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
351 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_protein'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
352 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
353 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
354
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
355 if (floatval($item['f_max_in_batch'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
356 xmlwriter_start_element($xw, 'MAX_IN_BATCH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
357 xmlwriter_text($xw, sprintf("%.1f",floatval($item['f_max_in_batch'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
358 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
359 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
360
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
361 xmlwriter_start_element($xw, 'RECOMMEND_MASH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
362 ($item['f_recommend_mash']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
363 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
364
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
365 xmlwriter_start_element($xw, 'GRAINTYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
366 xmlwriter_text($xw, $graintype[$item['f_graintype']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
367 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
368
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
369 xmlwriter_end_element($xw); // FERMENTABLE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
370 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
371 xmlwriter_end_element($xw); // FERMENTABLES
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
372
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
373 xmlwriter_start_element($xw, 'MISCS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
374 $arr = json_decode($row['json_miscs'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
375 foreach($arr as $item) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
376
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
377 xmlwriter_start_element($xw, 'MISC');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
378
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
379 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
380 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
381 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
382
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
383 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
384 xmlwriter_text($xw, $item['m_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
385 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
386
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
387 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
388 xmlwriter_text($xw, $misctype[$item['m_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
389 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
390
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
391 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
392 xmlwriter_text($xw, sprintf("%.5f",floatval($item['m_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
393 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
394
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
395 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
396 ($item['m_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
397 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
398
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
399 xmlwriter_start_element($xw, 'USE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
400 xmlwriter_text($xw, $miscuse[$item['m_use_use']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
401 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
402
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
403 xmlwriter_start_element($xw, 'TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
404 xmlwriter_text($xw, sprintf("%.0f",floatval($item['m_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
405 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
406
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
407 xmlwriter_end_element($xw); // MISC
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
408 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
409 xmlwriter_end_element($xw); // MISCS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
410
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
411 xmlwriter_start_element($xw, 'YEASTS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
412 $arr = json_decode($row['json_yeasts'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
413 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
414
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
415 xmlwriter_start_element($xw, 'YEAST');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
416
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
417 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
418 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
419 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
420
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
421 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
422 xmlwriter_text($xw, $item['y_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
423 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
424
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
425 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
426 xmlwriter_text($xw, $yeasttype[$item['y_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
427 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
428
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
429 xmlwriter_start_element($xw, 'FORM');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
430 xmlwriter_text($xw, $yeastform[$item['y_form']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
431 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
432
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
433 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
434 xmlwriter_text($xw, sprintf("%.5f",floatval($item['y_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
435 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
436
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
437 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
438 ($item['y_form'] == 1) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
439 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
440
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
441 xmlwriter_start_element($xw, 'LABORATORY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
442 xmlwriter_text($xw, $item['y_laboratory']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
443 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
444
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
445 xmlwriter_start_element($xw, 'PRODUCT_ID');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
446 xmlwriter_text($xw, $item['y_product_id']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
447 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
448
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
449 xmlwriter_start_element($xw, 'MIN_TEMPERATURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
450 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_min_temperature'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
451 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
452
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
453 xmlwriter_start_element($xw, 'MAX_TEMPERATURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
454 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_max_temperature'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
455 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
456
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
457 xmlwriter_start_element($xw, 'ATTENUATION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
458 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_attenuation'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
459 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
460
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
461 xmlwriter_start_element($xw, 'ADD_TO_SECONDARY');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
462 ($item['y_use'] == 0) ? xmlwriter_text($xw, 'FALSE') : xmlwriter_text($xw, 'TRUE');
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
463 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
464
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
465 xmlwriter_end_element($xw); // YEAST
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
466 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
467 xmlwriter_end_element($xw); // YEASTS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
468
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
469 xmlwriter_start_element($xw, 'WATERS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
470 xmlwriter_start_element($xw, 'WATER'); // Source 1
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
471
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
472 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
473 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
474 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
475
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
476 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
477 xmlwriter_text($xw, $row['w1_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
478 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
479
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
480 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
481 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
482 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
483
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
484 xmlwriter_start_element($xw, 'CALCIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
485 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_calcium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
486 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
487
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
488 xmlwriter_start_element($xw, 'BICARBONATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
489 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
490 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
491
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
492 xmlwriter_start_element($xw, 'SULFATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
493 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_sulfate'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
494 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
495
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
496 xmlwriter_start_element($xw, 'CHLORIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
497 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_chloride'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
498 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
499
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
500 xmlwriter_start_element($xw, 'SODIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
501 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_sodium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
502 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
503
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
504 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
505 xmlwriter_text($xw, sprintf("%.1f",floatval($row['w1_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
506 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
507
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
508 xmlwriter_start_element($xw, 'TOTAL_ALKALINITY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
509 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_total_alkalinity'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
510 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
511
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
512 xmlwriter_end_element($xw); // WATER
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
513
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
514 if (strlen($row['w2_name'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
515 xmlwriter_start_element($xw, 'WATER'); // Source 2
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
516
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
517 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
518 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
519 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
520
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
521 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
522 xmlwriter_text($xw, $row['w2_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
523 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
524
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
525 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
526 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
527 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
528
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
529 xmlwriter_start_element($xw, 'CALCIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
530 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_calcium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
531 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
532
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
533 xmlwriter_start_element($xw, 'BICARBONATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
534 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
535 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
536
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
537 xmlwriter_start_element($xw, 'SULFATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
538 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_sulfate'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
539 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
540
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
541 xmlwriter_start_element($xw, 'CHLORIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
542 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_chloride'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
543 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
544
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
545 xmlwriter_start_element($xw, 'SODIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
546 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_sodium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
547 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
548
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
549 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
550 xmlwriter_text($xw, sprintf("%.1f",floatval($row['w2_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
551 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
552
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
553 xmlwriter_start_element($xw, 'TOTAL_ALKALINITY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
554 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_total_alkalinity'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
555 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
556
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
557 xmlwriter_end_element($xw); // WATER
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
558 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
559 xmlwriter_end_element($xw); // WATERS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
560
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
561 xmlwriter_start_element($xw, 'MASH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
562
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
563 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
564 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
565 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
566
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
567 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
568 xmlwriter_text($xw, $row['mash_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
569 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
570
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
571 xmlwriter_start_element($xw, 'GRAIN_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
572 xmlwriter_text($xw, '10.0');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
573 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
574
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
575 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
576 xmlwriter_text($xw, sprintf("%.1f",floatval($row['sparge_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
577 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
578
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
579 xmlwriter_start_element($xw, 'SPARGE_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
580 xmlwriter_text($xw, sprintf("%.1f",floatval($row['sparge_temp'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
581 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
582
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
583 xmlwriter_start_element($xw, 'MASH_STEPS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
584 $arr = json_decode($row['json_mashs'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
585 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
586 xmlwriter_start_element($xw, 'MASH_STEP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
587
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
588 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
589 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
590 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
591
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
592 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
593 xmlwriter_text($xw, $item['step_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
594 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
595
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
596 xmlwriter_start_element($xw, 'TYPE');
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
597 xmlwriter_text($xw, $mashsteptype[$item['step_type']]);
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
598 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
599
242
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
600 if ($item['step_type'] == 0) {
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
601 xmlwriter_start_element($xw, 'INFUSE_AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
602 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_infuse_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
603 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
604 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
605
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
606 xmlwriter_start_element($xw, 'STEP_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
607 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_temp'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
608 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
609
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
610 xmlwriter_start_element($xw, 'STEP_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
611 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
612 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
613
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
614 xmlwriter_start_element($xw, 'RAMP_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
615 xmlwriter_text($xw, sprintf("%.1f",floatval($item['ramp_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
616 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
617
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
618 xmlwriter_start_element($xw, 'END_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
619 xmlwriter_text($xw, sprintf("%.1f",floatval($item['end_temp'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
620 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
621
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
622 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
623 xmlwriter_text($xw, sprintf("%.1f",floatval($row['mash_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
624 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
625
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
626 xmlwriter_end_element($xw); // MASH_STEP
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
627 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
628 xmlwriter_end_element($xw); // MASH_STEPS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
629 xmlwriter_end_element($xw); // MASH
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
630 xmlwriter_end_element($xw); // RECIPE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
631 xmlwriter_end_element($xw); // RECIPES
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
632 xmlwriter_end_document($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
633
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
634 $beerxml = xmlwriter_output_memory($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
635
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
636 Header('Content-type: text/xml');
272
0c2ea1c2b858 Product beerxml export filename includes beer code.
Michiel Broek <mbroek@mbse.eu>
parents: 242
diff changeset
637 header('Content-Disposition: attachment; filename="' . $row['code'] . ' ' . $row['name'] . '.xml"');
177
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
638 header('Content-Transfer-Encoding: binary');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
639 header('Expires: 0');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
640 header('Pragma: no-cache');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
641 header('Content-Length: '.strlen($beerxml));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
642 exit($beerxml);

mercurial