www/prod_beerxml.php

Wed, 05 Jun 2019 16:52:14 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Wed, 05 Jun 2019 16:52:14 +0200
changeset 401
4aad74bde00b
parent 400
6d07c51e7540
child 429
0d2cf505957c
permissions
-rw-r--r--

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.

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' );
97c237654ddd Product export to beerxml produces a clean recipe. No brewing information added.
Michiel Broek <mbroek@mbse.eu>
parents: 177
diff changeset
33 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne' );
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