13 } |
13 } |
14 |
14 |
15 $result = mysqli_query($link, "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"); |
15 $result = mysqli_query($link, "SELECT * FROM inventory_yeasts ORDER BY laboratory,product_id,name"); |
16 $row = mysqli_fetch_array($result); |
16 $row = mysqli_fetch_array($result); |
17 |
17 |
|
18 function field($x, $field, $value) { |
|
19 xmlwriter_start_element($x, $field); |
|
20 xmlwriter_text($x, $value); |
|
21 xmlwriter_end_element($x); |
|
22 } |
18 |
23 |
19 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne', 'Other', 'Other', 'Other', 'Other', 'Other' ); |
24 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne', 'Other', 'Other', 'Other', 'Other', 'Other' ); |
20 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle', 'Dry' ); |
25 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle', 'Dry' ); |
21 $yeastflocculation = array( 'Low', 'Medium', 'High', 'Very high' ); |
26 $yeastflocculation = array( 'Low', 'Medium', 'High', 'Very high' ); |
22 |
27 |
34 xmlwriter_start_element($xw, 'YEASTS'); |
39 xmlwriter_start_element($xw, 'YEASTS'); |
35 while ($row = mysqli_fetch_array($result)) { |
40 while ($row = mysqli_fetch_array($result)) { |
36 |
41 |
37 xmlwriter_start_element($xw, 'YEAST'); |
42 xmlwriter_start_element($xw, 'YEAST'); |
38 |
43 |
39 xmlwriter_start_element($xw, 'VERSION'); |
44 field($xw, 'VERSION', '1'); |
40 xmlwriter_text($xw, '1'); |
45 field($xw, 'NAME', $row['name']); |
41 xmlwriter_end_element($xw); |
46 field($xw, 'TYPE', $yeasttype[$row['type']]); |
|
47 field($xw, 'FORM', $yeastform[$row['form']]); |
|
48 field($xw, 'AMOUNT_IS_WEIGHT', ($row['form'] == '1' || $row['form'] == '6') ? 'TRUE':'FALSE'); |
|
49 field($xw, 'LABORATORY', $row['laboratory']); |
|
50 if (strlen($row['product_id'])) |
|
51 field($xw, 'PRODUCT_ID', $row['product_id']); |
|
52 field($xw, 'MIN_TEMPERATURE', sprintf("%.4f",floatval($row['min_temperature']))); |
|
53 field($xw, 'MAX_TEMPERATURE', sprintf("%.4f",floatval($row['max_temperature']))); |
|
54 field($xw, 'ATTENUATION', sprintf("%.4f",floatval($row['attenuation']))); |
|
55 field($xw, 'ADD_TO_SECONDARY', ($row['use'] == 0) ? 'FALSE':'TRUE'); |
|
56 field($xw, 'FLOCCULATION', $yeastflocculation[$row['flocculation']]); |
|
57 field($xw, 'MAX_REUSE', $row['max_reuse']); |
|
58 if (floatval($row['cost']) > 0) |
|
59 field($xw, 'COST', sprintf("%.5f",floatval($row['cost']))); |
|
60 if (strlen($row['notes'])) |
|
61 field($xw, 'NOTES', $row['notes']); |
42 |
62 |
43 xmlwriter_start_element($xw, 'NAME'); |
63 xmlwriter_end_element($xw); // YEAST |
44 xmlwriter_text($xw, $row['name']); |
|
45 xmlwriter_end_element($xw); |
|
46 |
|
47 xmlwriter_start_element($xw, 'TYPE'); |
|
48 xmlwriter_text($xw, $yeasttype[$row['type']]); |
|
49 xmlwriter_end_element($xw); |
|
50 |
|
51 xmlwriter_start_element($xw, 'FORM'); |
|
52 xmlwriter_text($xw, $yeastform[$row['form']]); |
|
53 xmlwriter_end_element($xw); |
|
54 |
|
55 xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT'); |
|
56 ($row['amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE'); |
|
57 xmlwriter_end_element($xw); |
|
58 |
|
59 xmlwriter_start_element($xw, 'LABORATORY'); |
|
60 xmlwriter_text($xw, $row['laboratory']); |
|
61 xmlwriter_end_element($xw); |
|
62 |
|
63 if (strlen($row['product_id'])) { |
|
64 xmlwriter_start_element($xw, 'PRODUCT_ID'); |
|
65 xmlwriter_text($xw, $row['product_id']); |
|
66 xmlwriter_end_element($xw); |
|
67 } |
|
68 |
|
69 xmlwriter_start_element($xw, 'MIN_TEMPERATURE'); |
|
70 xmlwriter_text($xw, sprintf("%.4f",floatval($row['min_temperature']))); |
|
71 xmlwriter_end_element($xw); |
|
72 |
|
73 xmlwriter_start_element($xw, 'MAX_TEMPERATURE'); |
|
74 xmlwriter_text($xw, sprintf("%.4f",floatval($row['max_temperature']))); |
|
75 xmlwriter_end_element($xw); |
|
76 |
|
77 xmlwriter_start_element($xw, 'ATTENUATION'); |
|
78 xmlwriter_text($xw, sprintf("%.4f",floatval($row['attenuation']))); |
|
79 xmlwriter_end_element($xw); |
|
80 |
|
81 xmlwriter_start_element($xw, 'ADD_TO_SECONDARY'); |
|
82 ($row['use'] == 0) ? xmlwriter_text($xw, 'FALSE') : xmlwriter_text($xw, 'TRUE'); |
|
83 xmlwriter_end_element($xw); |
|
84 |
|
85 xmlwriter_start_element($xw, 'FLOCCULATION'); |
|
86 xmlwriter_text($xw, $yeastflocculation[$row['flocculation']]); |
|
87 xmlwriter_end_element($xw); |
|
88 |
|
89 xmlwriter_start_element($xw, 'MAX_REUSE'); |
|
90 xmlwriter_text($xw, $row['max_reuse']); |
|
91 xmlwriter_end_element($xw); |
|
92 |
|
93 if (floatval($row['cost']) > 0) { |
|
94 xmlwriter_start_element($xw, 'COST'); |
|
95 xmlwriter_text($xw, sprintf("%.5f",floatval($row['cost']))); |
|
96 xmlwriter_end_element($xw); |
|
97 } |
|
98 |
|
99 if (strlen($row['notes'])) { |
|
100 xmlwriter_start_element($xw, 'NOTES'); |
|
101 xmlwriter_text($xw, $row['notes']); |
|
102 xmlwriter_end_element($xw); |
|
103 } |
|
104 |
|
105 |
|
106 xmlwriter_end_element($xw); // MISC |
|
107 } |
64 } |
108 xmlwriter_end_element($xw); // MISCS |
65 xmlwriter_end_element($xw); // YEASTS |
109 |
66 |
110 $beerxml = xmlwriter_output_memory($xw); |
67 $beerxml = xmlwriter_output_memory($xw); |
111 |
68 |
112 Header('Content-type: text/xml'); |
69 Header('Content-type: text/xml'); |
113 header('Content-Disposition: attachment; filename="yeasts.xml"'); |
70 header('Content-Disposition: attachment; filename="yeasts.xml"'); |