www/prod_export.php

Sun, 06 Jan 2019 23:30:17 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 06 Jan 2019 23:30:17 +0100
changeset 177
325bd6425978
child 242
97c237654ddd
permissions
-rw-r--r--

Added products beerxml export.

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
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 $record = 14;
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
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 /*
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28 * Create beerxml output
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 */
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 $xw = xmlwriter_open_memory();
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
31 xmlwriter_set_indent($xw, 1);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 $res = xmlwriter_set_indent_string($xw, ' ');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
34 xmlwriter_start_document($xw, '1.0', 'UTF-8');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
35
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
36 xmlwriter_start_element($xw, 'RECIPES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
37 xmlwriter_start_element($xw, 'RECIPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
38
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
39 // Recipe basics
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
40 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
42 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
44 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 xmlwriter_text($xw, $row['name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 xmlwriter_start_element($xw, 'NOTES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 xmlwriter_text($xw, $row['notes']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 xmlwriter_text($xw, $row['type']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 xmlwriter_start_element($xw, 'BREWER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 xmlwriter_text($xw, 'Anonymous');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 xmlwriter_start_element($xw, 'BATCH_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 xmlwriter_text($xw, sprintf("%.2f",floatval($row['batch_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 xmlwriter_start_element($xw, 'BOIL_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 xmlwriter_text($xw, sprintf("%.2f",floatval($row['boil_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 xmlwriter_start_element($xw, 'BOIL_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 xmlwriter_text($xw, sprintf("%.0f",floatval($row['boil_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 xmlwriter_start_element($xw, 'EFFICIENCY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 xmlwriter_text($xw, sprintf("%.1f",floatval($row['efficiency'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76 xmlwriter_start_element($xw, 'OG');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 xmlwriter_text($xw, sprintf("%.3f",floatval($row['og'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 xmlwriter_start_element($xw, 'FG');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 xmlwriter_text($xw, sprintf("%.3f",floatval($row['fg'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 // Style
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 xmlwriter_start_element($xw, 'STYLE');
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, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 xmlwriter_text($xw, '1');
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, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 xmlwriter_text($xw, $row['st_name']);
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, 'CATEGORY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 xmlwriter_text($xw, $row['st_category']);
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
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 xmlwriter_start_element($xw, 'CATEGORY_NUMBER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 xmlwriter_text($xw, $row['st_category_number']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103 xmlwriter_start_element($xw, 'STYLE_LETTER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104 xmlwriter_text($xw, $row['st_letter']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
106
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
107 xmlwriter_start_element($xw, 'STYLE_GUIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108 xmlwriter_text($xw, $row['st_guide']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
109 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
110
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
111 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
112 xmlwriter_text($xw, $row['st_type']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
113 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
114
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
115 xmlwriter_start_element($xw, 'OG_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
116 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
117 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
118
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
119 xmlwriter_start_element($xw, 'OG_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
120 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
121 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
122
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
123 xmlwriter_start_element($xw, 'FG_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
124 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_og_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
125 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
126
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
127 xmlwriter_start_element($xw, 'OG_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
128 xmlwriter_text($xw, sprintf("%.3f",floatval($row['st_fg_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
129 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
130
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
131 xmlwriter_start_element($xw, 'IBU_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
132 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
133 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
134
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
135 xmlwriter_start_element($xw, 'IBU_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
136 xmlwriter_text($xw, sprintf("%.0f",floatval($row['st_ibu_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
137 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
138
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
139 xmlwriter_start_element($xw, 'COLOR_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
140 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
141 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
142
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
143 xmlwriter_start_element($xw, 'COLOR_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
144 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
145 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
146
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
147 xmlwriter_start_element($xw, 'CARB_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
148 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_carb_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
149 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
150
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
151 xmlwriter_start_element($xw, 'CARB_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
152 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_carb_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
153 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
154
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
155 xmlwriter_start_element($xw, 'ABV_MIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
156 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_abv_min'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
157 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
158
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
159 xmlwriter_start_element($xw, 'ABV_MAX');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
160 xmlwriter_text($xw, sprintf("%.1f",floatval($row['st_abv_max'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
161 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
162
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
163 xmlwriter_end_element($xw); // STYLE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
164
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
165 xmlwriter_start_element($xw, 'EQUIPMENT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
166
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
167 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
168 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
169 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
170
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
171 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
172 xmlwriter_text($xw, $row['eq_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
173 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
174
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
175 xmlwriter_start_element($xw, 'NOTES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
176 xmlwriter_text($xw, $row['eq_notes']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
177 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
178
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
179 xmlwriter_start_element($xw, 'BATCH_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
180 xmlwriter_text($xw, sprintf("%.2f",floatval($row['eq_batch_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
181 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
182
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
183 xmlwriter_start_element($xw, 'BOIL_SIZE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
184 xmlwriter_text($xw, sprintf("%.2f",floatval($row['eq_boil_size'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
185 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
186
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
187 xmlwriter_start_element($xw, 'BOIL_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
188 xmlwriter_text($xw, sprintf("%.0f",floatval($row['eq_boil_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
189 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
190
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
191 xmlwriter_end_element($xw); // EQUIPMENT
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
192
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
193 xmlwriter_start_element($xw, 'HOPS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
194 $arr = json_decode($row['json_hops'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
195 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
196
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
197 xmlwriter_start_element($xw, 'HOP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
198
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
199 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
200 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
201 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
202
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
203 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
204 xmlwriter_text($xw, $item['h_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
205 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
206
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
207 xmlwriter_start_element($xw, 'ALPHA');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
208 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_alpha'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
209 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
210
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
211 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
212 xmlwriter_text($xw, sprintf("%.4f",floatval($item['h_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
213 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
214
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
215 xmlwriter_start_element($xw, 'USE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
216 xmlwriter_text($xw, $item['h_useat']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
217 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
218
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
219 xmlwriter_start_element($xw, 'TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
220 xmlwriter_text($xw, $item['h_time']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
221 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
222
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
223 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
224 xmlwriter_text($xw, $item['h_type']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
225 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
226
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
227 xmlwriter_start_element($xw, 'FORM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
228 xmlwriter_text($xw, $item['h_form']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
229 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
230
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
231 xmlwriter_start_element($xw, 'BETA');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
232 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_beta'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
233 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
234
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
235 xmlwriter_start_element($xw, 'HSI');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
236 xmlwriter_text($xw, sprintf("%.1f",floatval($item['h_hsi'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
237 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
238
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
239 xmlwriter_start_element($xw, 'ORIGIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
240 xmlwriter_text($xw, $item['h_origin']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
241 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
242
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
243 xmlwriter_end_element($xw); // HOP
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
244 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
245 xmlwriter_end_element($xw); // HOPS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
246
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
247 xmlwriter_start_element($xw, 'FERMENTABLES');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
248 $arr = json_decode($row['json_fermentables'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
249 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
250 xmlwriter_start_element($xw, 'FERMENTABLE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
251
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
252 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
253 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
254 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
255
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
256 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
257 xmlwriter_text($xw, $item['f_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
258 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
259
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
260 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
261 xmlwriter_text($xw, $item['f_type']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
262 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
263
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
264 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
265 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
266 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
267
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
268 xmlwriter_start_element($xw, 'YIELD');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
269 xmlwriter_text($xw, sprintf("%.1f",floatval($item['f_yield'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
270 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
271
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
272 xmlwriter_start_element($xw, 'COLOR');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
273 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
274 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
275
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
276 xmlwriter_start_element($xw, 'ADD_AFTER_BOIL');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
277 ($item['f_add_after_boil']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
278 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
279
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
280 xmlwriter_start_element($xw, 'ORIGIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
281 xmlwriter_text($xw, $item['f_origin']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
282 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
283
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
284 xmlwriter_start_element($xw, 'SUPPLIER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
285 xmlwriter_text($xw, $item['f_supplier']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
286 xmlwriter_end_element($xw);
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 if (floatval($item['f_coarse_fine_diff'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
289 xmlwriter_start_element($xw, 'COARSE_FINE_DIFF');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
290 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_coarse_fine_diff'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
291 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
292 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
293
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
294 if (floatval($item['f_moisture'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
295 xmlwriter_start_element($xw, 'MOISTURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
296 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_moisture'])));
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
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
300 if (floatval($item['f_diastatic_power'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
301 xmlwriter_start_element($xw, 'DIASTATIC_POWER');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
302 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_diastatic_power'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
303 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
304 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
305
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
306 if (floatval($item['f_protein'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
307 xmlwriter_start_element($xw, 'PROTEIN');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
308 xmlwriter_text($xw, sprintf("%.4f",floatval($item['f_protein'])));
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
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
312 if (floatval($item['f_max_in_batch'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
313 xmlwriter_start_element($xw, 'MAX_IN_BATCH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
314 xmlwriter_text($xw, sprintf("%.1f",floatval($item['f_max_in_batch'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
315 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
316 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
317
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
318 xmlwriter_start_element($xw, 'RECOMMEND_MASH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
319 ($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
320 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
321
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
322 xmlwriter_start_element($xw, 'GRAINTYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
323 xmlwriter_text($xw, $item['f_graintype']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
324 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
325
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
326 xmlwriter_end_element($xw); // FERMENTABLE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
327 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
328 xmlwriter_end_element($xw); // FERMENTABLES
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
329
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
330 xmlwriter_start_element($xw, 'MISCS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
331 $arr = json_decode($row['json_miscs'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
332 foreach($arr as $item) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
333
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
334 xmlwriter_start_element($xw, 'MISC');
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 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
337 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
338 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
339
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
340 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
341 xmlwriter_text($xw, $item['m_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
342 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
343
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
344 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
345 xmlwriter_text($xw, $item['m_type']);
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 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
349 xmlwriter_text($xw, sprintf("%.5f",floatval($item['m_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
350 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
351
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
352 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
353 ($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
354 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
355
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
356 xmlwriter_start_element($xw, 'USE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
357 xmlwriter_text($xw, $item['m_use_use']);
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 xmlwriter_start_element($xw, 'TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
361 xmlwriter_text($xw, sprintf("%.0f",floatval($item['m_time'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
362 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
363
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
364 xmlwriter_end_element($xw); // MISC
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
365 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
366 xmlwriter_end_element($xw); // MISCS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
367
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
368 xmlwriter_start_element($xw, 'YEASTS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
369 $arr = json_decode($row['json_yeasts'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
370 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
371
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
372 xmlwriter_start_element($xw, 'YEAST');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
373
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
374 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
375 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
376 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
377
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
378 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
379 xmlwriter_text($xw, $item['y_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
380 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
381
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
382 xmlwriter_start_element($xw, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
383 xmlwriter_text($xw, $item['y_type']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
384 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
385
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
386 xmlwriter_start_element($xw, 'FORM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
387 xmlwriter_text($xw, $item['y_form']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
388 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
389
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
390 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
391 xmlwriter_text($xw, sprintf("%.5f",floatval($item['y_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
392 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
393
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
394 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
395 ($item['y_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
396 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
397
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
398 xmlwriter_start_element($xw, 'LABORATORY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
399 xmlwriter_text($xw, $item['y_laboratory']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
400 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
401
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
402 xmlwriter_start_element($xw, 'PRODUCT_ID');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
403 xmlwriter_text($xw, $item['y_product_id']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
404 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
405
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
406 xmlwriter_start_element($xw, 'MIN_TEMPERATURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
407 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_min_temperature'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
408 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
409
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
410 xmlwriter_start_element($xw, 'MAX_TEMPERATURE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
411 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_max_temperature'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
412 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
413
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
414 xmlwriter_start_element($xw, 'ATTENUATION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
415 xmlwriter_text($xw, sprintf("%.1f",floatval($item['y_attenuation'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
416 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
417
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
418 xmlwriter_start_element($xw, 'ADD_TO_SECONDARY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
419 ($item['y_use'] == 'Secondary') ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
420 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
421
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
422 xmlwriter_end_element($xw); // YEAST
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
423 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
424 xmlwriter_end_element($xw); // YEASTS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
425
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
426 xmlwriter_start_element($xw, 'WATERS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
427 xmlwriter_start_element($xw, 'WATER'); // Source 1
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, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
430 xmlwriter_text($xw, '1');
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, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
434 xmlwriter_text($xw, $row['w1_name']);
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');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
438 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_amount'])));
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, 'CALCIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
442 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_calcium'])));
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, 'BICARBONATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
446 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
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, 'SULFATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
450 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_sulfate'])));
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, 'CHLORIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
454 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_chloride'])));
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, 'SODIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
458 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_sodium'])));
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, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
462 xmlwriter_text($xw, sprintf("%.1f",floatval($row['w1_ph'])));
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_start_element($xw, 'TOTAL_ALKALINITY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
466 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w1_total_alkalinity'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
467 xmlwriter_end_element($xw);
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_end_element($xw); // WATER
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
470
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
471 if (strlen($row['w2_name'])) {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
472 xmlwriter_start_element($xw, 'WATER'); // Source 2
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
473
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
474 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
475 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
476 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
477
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
478 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
479 xmlwriter_text($xw, $row['w2_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
480 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
481
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
482 xmlwriter_start_element($xw, 'AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
483 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
484 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
485
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
486 xmlwriter_start_element($xw, 'CALCIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
487 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_calcium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
488 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
489
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
490 xmlwriter_start_element($xw, 'BICARBONATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
491 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
492 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
493
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
494 xmlwriter_start_element($xw, 'SULFATE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
495 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_sulfate'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
496 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
497
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
498 xmlwriter_start_element($xw, 'CHLORIDE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
499 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_chloride'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
500 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
501
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
502 xmlwriter_start_element($xw, 'SODIUM');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
503 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_sodium'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
504 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
505
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
506 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
507 xmlwriter_text($xw, sprintf("%.1f",floatval($row['w2_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
508 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
509
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
510 xmlwriter_start_element($xw, 'TOTAL_ALKALINITY');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
511 xmlwriter_text($xw, sprintf("%.2f",floatval($row['w2_total_alkalinity'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
512 xmlwriter_end_element($xw);
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 xmlwriter_end_element($xw); // WATER
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
515 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
516 xmlwriter_end_element($xw); // WATERS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
517
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
518 xmlwriter_start_element($xw, 'MASH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
519
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
520 xmlwriter_start_element($xw, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
521 xmlwriter_text($xw, '1');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
522 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
523
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
524 xmlwriter_start_element($xw, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
525 xmlwriter_text($xw, $row['mash_name']);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
526 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
527
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
528 xmlwriter_start_element($xw, 'GRAIN_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
529 xmlwriter_text($xw, '10.0');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
530 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
531
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
532 xmlwriter_start_element($xw, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
533 xmlwriter_text($xw, sprintf("%.1f",floatval($row['sparge_ph'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
534 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
535
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
536 xmlwriter_start_element($xw, 'SPARGE_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
537 xmlwriter_text($xw, sprintf("%.1f",floatval($row['sparge_temp'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
538 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
539
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
540 xmlwriter_start_element($xw, 'MASH_STEPS');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
541 $arr = json_decode($row['json_mashs'], true);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
542 foreach($arr as $item) { //foreach element in $arr
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
543 xmlwriter_start_element($xw, 'MASH_STEP');
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, 'VERSION');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
546 xmlwriter_text($xw, '1');
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, 'NAME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
550 xmlwriter_text($xw, $item['step_name']);
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, 'TYPE');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
554 xmlwriter_text($xw, $item['step_type']);
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 if ($item['step_type'] == 'Infusion') {
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
558 xmlwriter_start_element($xw, 'INFUSE_AMOUNT');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
559 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_infuse_amount'])));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
560 xmlwriter_end_element($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
561 }
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, 'STEP_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
564 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_temp'])));
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, 'STEP_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
568 xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_time'])));
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, 'RAMP_TIME');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
572 xmlwriter_text($xw, sprintf("%.1f",floatval($item['ramp_time'])));
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, 'END_TEMP');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
576 xmlwriter_text($xw, sprintf("%.1f",floatval($item['end_temp'])));
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, 'PH');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
580 xmlwriter_text($xw, sprintf("%.1f",floatval($row['mash_ph'])));
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_end_element($xw); // MASH_STEP
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
584 }
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
585 xmlwriter_end_element($xw); // MASH_STEPS
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
586 xmlwriter_end_element($xw); // MASH
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
587 xmlwriter_end_element($xw); // RECIPE
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
588 xmlwriter_end_element($xw); // RECIPES
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
589 xmlwriter_end_document($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
590
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
591 $beerxml = xmlwriter_output_memory($xw);
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
592
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
593 Header('Content-type: text/xml');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
594 header('Content-Disposition: attachment; filename="' . $row['name'] . '.xml"');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
595 header('Content-Transfer-Encoding: binary');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
596 header('Expires: 0');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
597 header('Pragma: no-cache');
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
598 header('Content-Length: '.strlen($beerxml));
325bd6425978 Added products beerxml export.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
599 exit($beerxml);

mercurial