comparison: www/rec_beerxml.php
www/rec_beerxml.php
- changeset 804
- ac5c3e97fcf1
- parent 803
- 45e87aa8d02c
- child 805
- 488613f30789
equal
deleted
inserted
replaced
| 803:45e87aa8d02c | 804:ac5c3e97fcf1 |
|---|---|
| 1 <?php | |
| 2 require_once($_SERVER['DOCUMENT_ROOT'].'/config.php'); | |
| 3 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); | |
| 4 | |
| 5 | |
| 6 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
| 7 if (! $link) { | |
| 8 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
| 9 } | |
| 10 if (! mysqli_set_charset($link, "utf8" )) { | |
| 11 echo "error"; | |
| 12 return 1; | |
| 13 } | |
| 14 | |
| 15 //setlocale ( LC_ALL, 'nl_NL.UTF-8'); | |
| 16 if (isset($_GET["record"])) | |
| 17 $record = $_GET["record"]; | |
| 18 else | |
| 19 $record = 148; | |
| 20 $result = mysqli_query($link, "SELECT * FROM recipes WHERE record='".$record."'"); | |
| 21 $row = mysqli_fetch_array($result); | |
| 22 | |
| 23 | |
| 24 $recipetype = array( 'Extract', 'Partial Mash', 'All Grain' ); | |
| 25 $styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' ); | |
| 26 $hoptype = array( 'Bittering', 'Aroma', 'Both' ); | |
| 27 $hopform = array( 'Pellet', 'Plug', 'Leaf', 'Leaf', 'Leaf' ); | |
| 28 $hopuse = array( 'Mash', 'First wort', 'Boil', 'Aroma', 'Whirlpool', 'Dry hop' ); | |
| 29 $fermentabletype = array( 'Grain', 'Sugar', 'Extract', 'Dry extract', 'Adjunct' ); | |
| 30 $graintype = array( 'Base', 'Roast', 'Crystal', 'Kilned', 'Sour malt', 'Special', 'No malt' ); | |
| 31 $yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne', 'Other', 'Other', 'Other', 'Other', 'Other' ); | |
| 32 $yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle', 'Dry' ); | |
| 33 $yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' ); | |
| 34 $misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' ); | |
| 35 $miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' ); | |
| 36 $mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' ); | |
| 37 $colormethod = array( 'Morey', 'Mosher', 'Daniels', 'Halberstadt', 'Naudts' ); | |
| 38 $ibumethod = array( 'Tinseth', 'Rager', 'Daniels', 'Garetz', 'Mosher', 'Noonan' ); | |
| 39 | |
| 40 | |
| 41 function field($x, $field, $value) { | |
| 42 xmlwriter_start_element($x, $field); | |
| 43 xmlwriter_text($x, $value); | |
| 44 xmlwriter_end_element($x); | |
| 45 } | |
| 46 | |
| 47 | |
| 48 /* | |
| 49 * Create beerxml output | |
| 50 */ | |
| 51 $xw = xmlwriter_open_memory(); | |
| 52 xmlwriter_set_indent($xw, 1); | |
| 53 $res = xmlwriter_set_indent_string($xw, ' '); | |
| 54 | |
| 55 xmlwriter_start_document($xw, '1.0', 'UTF-8'); | |
| 56 | |
| 57 xmlwriter_start_element($xw, 'RECIPES'); | |
| 58 xmlwriter_start_element($xw, 'RECIPE'); | |
| 59 | |
| 60 // Recipe basics | |
| 61 field($xw, 'VERSION', '1'); | |
| 62 field($xw, 'NAME', $row['name']); | |
| 63 field($xw, 'NOTES', $row['notes']); | |
| 64 field($xw, 'TYPE', $recipetype[$row['type']]); | |
| 65 field($xw, 'BREWER', 'Anonymous'); | |
| 66 field($xw, 'BATCH_SIZE', sprintf("%.4f",floatval($row['batch_size']))); | |
| 67 field($xw, 'BOIL_SIZE', sprintf("%.4f",floatval($row['boil_size']))); | |
| 68 field($xw, 'BOIL_TIME', sprintf("%.3f",floatval($row['boil_time']))); | |
| 69 field($xw, 'EFFICIENCY', sprintf("%.4f",floatval($row['efficiency']))); | |
| 70 | |
| 71 if (floatval($row['est_og']) > 0) { | |
| 72 field($xw, 'EST_OG', sprintf("%.3f",floatval($row['est_og']))); | |
| 73 } | |
| 74 | |
| 75 if (floatval($row['est_fg']) > 0) { | |
| 76 field($xw, 'EST_FG', sprintf("%.3f",floatval($row['est_fg']))); | |
| 77 } | |
| 78 | |
| 79 if (floatval($row['est_abv']) > 0) { | |
| 80 field($xw, 'EST_ABV', sprintf("%.1f",floatval($row['est_abv']))); | |
| 81 } | |
| 82 | |
| 83 if (floatval($row['est_color']) > 0) { | |
| 84 field($xw, 'EST_COLOR', sprintf("%.6f", ebc_to_srm(floatval($row['est_color'])))); | |
| 85 field($xw, 'COLOR_METHOD', $colormethod[$row['color_method']]); | |
| 86 } | |
| 87 | |
| 88 if (floatval($row['est_ibu']) > 0) { | |
| 89 field($xw, 'EST_IBU', sprintf("%.1f",floatval($row['est_ibu']))); | |
| 90 field($xw, 'IBU_METHOD', $ibumethod[$row['ibu_method']]); | |
| 91 } | |
| 92 | |
| 93 | |
| 94 // Style | |
| 95 xmlwriter_start_element($xw, 'STYLE'); | |
| 96 field($xw, 'VERSION', '1'); | |
| 97 field($xw, 'NAME', $row['st_name']); | |
| 98 field($xw, 'CATEGORY', $row['st_category']); | |
| 99 field($xw, 'CATEGORY_NUMBER', $row['st_category_number']); | |
| 100 field($xw, 'STYLE_LETTER', $row['st_letter']); | |
| 101 field($xw, 'STYLE_GUIDE', $row['st_guide']); | |
| 102 field($xw, 'TYPE', $styletype[$row['st_type']]); | |
| 103 field($xw, 'OG_MIN', sprintf("%.3f",floatval($row['st_og_min']))); | |
| 104 field($xw, 'OG_MAX', sprintf("%.3f",floatval($row['st_og_max']))); | |
| 105 field($xw, 'FG_MIN', sprintf("%.3f",floatval($row['st_fg_min']))); | |
| 106 field($xw, 'FG_MAX', sprintf("%.3f",floatval($row['st_fg_max']))); | |
| 107 field($xw, 'IBU_MIN', sprintf("%.0f",floatval($row['st_ibu_min']))); | |
| 108 field($xw, 'IBU_MAX', sprintf("%.0f",floatval($row['st_ibu_max']))); | |
| 109 field($xw, 'COLOR_MIN', sprintf("%.2f",ebc_to_srm(floatval($row['st_color_min'])))); | |
| 110 field($xw, 'COLOR_MAX', sprintf("%.2f",ebc_to_srm(floatval($row['st_color_max'])))); | |
| 111 field($xw, 'CARB_MIN', sprintf("%.1f",floatval($row['st_carb_min']))); | |
| 112 field($xw, 'CARB_MAX', sprintf("%.1f",floatval($row['st_carb_max']))); | |
| 113 field($xw, 'ABV_MIN', sprintf("%.1f",floatval($row['st_abv_min']))); | |
| 114 field($xw, 'ABV_MAX', sprintf("%.1f",floatval($row['st_abv_max']))); | |
| 115 xmlwriter_end_element($xw); // STYLE | |
| 116 | |
| 117 xmlwriter_start_element($xw, 'EQUIPMENT'); | |
| 118 field($xw, 'VERSION', '1'); | |
| 119 field($xw, 'NAME', 'Dummy Brewery'); | |
| 120 field($xw, 'BATCH_SIZE', sprintf("%.2f",floatval($row['batch_size']))); | |
| 121 field($xw, 'BOIL_SIZE', sprintf("%.2f",floatval($row['boil_size']))); | |
| 122 field($xw, 'BOIL_TIME', sprintf("%.0f",floatval($row['boil_time']))); | |
| 123 xmlwriter_end_element($xw); // EQUIPMENT | |
| 124 | |
| 125 xmlwriter_start_element($xw, 'HOPS'); | |
| 126 $arr = json_decode($row['json_hops'], true); | |
| 127 foreach($arr as $item) { //foreach element in $arr | |
| 128 xmlwriter_start_element($xw, 'HOP'); | |
| 129 field($xw, 'VERSION', '1'); | |
| 130 field($xw, 'NAME', $item['h_name']); | |
| 131 field($xw, 'ALPHA', sprintf("%.1f",floatval($item['h_alpha']))); | |
| 132 field($xw, 'AMOUNT', sprintf("%.4f",floatval($item['h_amount']))); | |
| 133 field($xw, 'USE', $hopuse[$item['h_useat']]); | |
| 134 field($xw, 'TIME', $item['h_time']); | |
| 135 field($xw, 'TYPE', $hoptype[$item['h_type']]); | |
| 136 field($xw, 'FORM', $hopform[$item['h_form']]); | |
| 137 field($xw, 'BETA', sprintf("%.1f",floatval($item['h_beta']))); | |
| 138 field($xw, 'HSI', sprintf("%.1f",floatval($item['h_hsi']))); | |
| 139 field($xw, 'ORIGIN', $item['h_origin']); | |
| 140 xmlwriter_end_element($xw); // HOP | |
| 141 } | |
| 142 xmlwriter_end_element($xw); // HOPS | |
| 143 | |
| 144 xmlwriter_start_element($xw, 'FERMENTABLES'); | |
| 145 $arr = json_decode($row['json_fermentables'], true); | |
| 146 foreach($arr as $item) { //foreach element in $arr | |
| 147 if ($item['f_added'] <= 3) { | |
| 148 xmlwriter_start_element($xw, 'FERMENTABLE'); | |
| 149 field($xw, 'VERSION', '1'); | |
| 150 field($xw, 'NAME', $item['f_name']); | |
| 151 field($xw, 'TYPE', $fermentabletype[$item['f_type']]); | |
| 152 field($xw, 'AMOUNT', sprintf("%.4f",floatval($item['f_amount']))); | |
| 153 field($xw, 'YIELD', sprintf("%.1f",floatval($item['f_yield']))); | |
| 154 field($xw, 'COLOR', sprintf("%.1f",ebc_to_srm(floatval($item['f_color'])))); | |
| 155 field($xw, 'ADD_AFTER_BOIL', ($item['f_added'] > 1) ? 'TRUE':'FALSE'); | |
| 156 field($xw, 'ORIGIN', $item['f_origin']); | |
| 157 field($xw, 'SUPPLIER', $item['f_supplier']); | |
| 158 if (floatval($item['f_coarse_fine_diff'])) | |
| 159 field($xw, 'COARSE_FINE_DIFF', sprintf("%.4f",floatval($item['f_coarse_fine_diff']))); | |
| 160 if (floatval($item['f_moisture'])) | |
| 161 field($xw, 'MOISTURE', sprintf("%.4f",floatval($item['f_moisture']))); | |
| 162 if (floatval($item['f_diastatic_power'])) | |
| 163 field($xw, 'DIASTATIC_POWER', sprintf("%.4f",floatval($item['f_diastatic_power']))); | |
| 164 if (floatval($item['f_protein'])) | |
| 165 field($xw, 'PROTEIN', sprintf("%.4f",floatval($item['f_protein']))); | |
| 166 if (floatval($item['f_max_in_batch'])) | |
| 167 field($xw, 'MAX_IN_BATCH', sprintf("%.1f",floatval($item['f_max_in_batch']))); | |
| 168 field($xw, 'RECOMMEND_MASH', ($item['f_recommend_mash']) ? 'TRUE':'FALSE'); | |
| 169 field($xw, 'GRAINTYPE', $graintype[$item['f_graintype']]); | |
| 170 xmlwriter_end_element($xw); // FERMENTABLE | |
| 171 } | |
| 172 } | |
| 173 xmlwriter_end_element($xw); // FERMENTABLES | |
| 174 | |
| 175 xmlwriter_start_element($xw, 'MISCS'); | |
| 176 $arr = json_decode($row['json_miscs'], true); | |
| 177 foreach($arr as $item) { | |
| 178 xmlwriter_start_element($xw, 'MISC'); | |
| 179 field($xw, 'VERSION', '1'); | |
| 180 field($xw, 'NAME', $item['m_name']); | |
| 181 field($xw, 'TYPE', $misctype[$item['m_type']]); | |
| 182 field($xw, 'AMOUNT', sprintf("%.5f",floatval($item['m_amount']))); | |
| 183 field($xw, 'AMOUNT_IS_WEIGHT', ($item['m_amount_is_weight']) ? 'TRUE':'FALSE'); | |
| 184 field($xw, 'USE', $miscuse[$item['m_use_use']]); | |
| 185 field($xw, 'TIME', sprintf("%.0f",floatval($item['m_time']))); | |
| 186 xmlwriter_end_element($xw); // MISC | |
| 187 } | |
| 188 xmlwriter_end_element($xw); // MISCS | |
| 189 | |
| 190 xmlwriter_start_element($xw, 'YEASTS'); | |
| 191 $arr = json_decode($row['json_yeasts'], true); | |
| 192 foreach($arr as $item) { //foreach element in $arr | |
| 193 xmlwriter_start_element($xw, 'YEAST'); | |
| 194 field($xw, 'VERSION', '1'); | |
| 195 field($xw, 'NAME', $item['y_name']); | |
| 196 field($xw, 'TYPE', $yeasttype[$item['y_type']]); | |
| 197 field($xw, 'FORM', $yeastform[$item['y_form']]); | |
| 198 field($xw, 'AMOUNT', sprintf("%.5f",floatval($item['y_amount']))); | |
| 199 field($xw, 'AMOUNT_IS_WEIGHT', ($item['y_form'] == 1) ? 'TRUE':'FALSE'); | |
| 200 field($xw, 'LABORATORY', $item['y_laboratory']); | |
| 201 field($xw, 'PRODUCT_ID', $item['y_product_id']); | |
| 202 field($xw, 'MIN_TEMPERATURE', sprintf("%.1f",floatval($item['y_min_temperature']))); | |
| 203 field($xw, 'MAX_TEMPERATURE', sprintf("%.1f",floatval($item['y_max_temperature']))); | |
| 204 field($xw, 'ATTENUATION', sprintf("%.1f",floatval($item['y_attenuation']))); | |
| 205 field($xw, 'ADD_TO_SECONDARY', ($item['y_use'] == 0) ? 'FALSE':'TRUE'); | |
| 206 xmlwriter_end_element($xw); // YEAST | |
| 207 } | |
| 208 xmlwriter_end_element($xw); // YEASTS | |
| 209 | |
| 210 xmlwriter_start_element($xw, 'WATERS'); | |
| 211 xmlwriter_start_element($xw, 'WATER'); // Source 1 | |
| 212 field($xw, 'VERSION', '1'); | |
| 213 field($xw, 'NAME', $row['w1_name']); | |
| 214 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w1_amount']))); | |
| 215 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w1_calcium']))); | |
| 216 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w1_magnesium']))); | |
| 217 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w1_total_alkalinity']) * 1.22)); | |
| 218 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w1_sulfate']))); | |
| 219 field($xw, 'CHLORIDE', sprintf("%.2f",floatval($row['w1_chloride']))); | |
| 220 field($xw, 'SODIUM', sprintf("%.2f",floatval($row['w1_sodium']))); | |
| 221 field($xw, 'PH', sprintf("%.1f",floatval($row['w1_ph']))); | |
| 222 field($xw, 'TOTAL_ALKALINITY', sprintf("%.2f",floatval($row['w1_total_alkalinity']))); | |
| 223 xmlwriter_end_element($xw); // WATER | |
| 224 if (strlen($row['w2_name'])) { | |
| 225 xmlwriter_start_element($xw, 'WATER'); // Source 2 | |
| 226 field($xw, 'VERSION', '1'); | |
| 227 field($xw, 'NAME', $row['w2_name']); | |
| 228 field($xw, 'AMOUNT', sprintf("%.2f",floatval($row['w2_amount']))); | |
| 229 field($xw, 'CALCIUM', sprintf("%.2f",floatval($row['w2_calcium']))); | |
| 230 field($xw, 'MAGNESIUM', sprintf("%.2f",floatval($row['w2_magnesium']))); | |
| 231 field($xw, 'BICARBONATE', sprintf("%.2f",floatval($row['w2_total_alkalinity']) * 1.22)); | |
| 232 field($xw, 'SULFATE', sprintf("%.2f",floatval($row['w2_sulfate']))); | |
| 233 field($xw, 'CHLORIDE', sprintf("%.2f",floatval($row['w2_chloride']))); | |
| 234 field($xw, 'SODIUM', sprintf("%.2f",floatval($row['w2_sodium']))); | |
| 235 field($xw, 'PH', sprintf("%.1f",floatval($row['w2_ph']))); | |
| 236 field($xw, 'TOTAL_ALKALINITY', sprintf("%.2f",floatval($row['w2_total_alkalinity']))); | |
| 237 xmlwriter_end_element($xw); // WATER | |
| 238 } | |
| 239 xmlwriter_end_element($xw); // WATERS | |
| 240 | |
| 241 xmlwriter_start_element($xw, 'MASH'); | |
| 242 field($xw, 'VERSION', '1'); | |
| 243 field($xw, 'NAME', $row['mash_name']); | |
| 244 field($xw, 'GRAIN_TEMP', '10.0'); | |
| 245 field($xw, 'PH', sprintf("%.1f",floatval($row['sparge_ph']))); | |
| 246 field($xw, 'SPARGE_TEMP', sprintf("%.1f",floatval($row['sparge_temp']))); | |
| 247 xmlwriter_start_element($xw, 'MASH_STEPS'); | |
| 248 $arr = json_decode($row['json_mashs'], true); | |
| 249 foreach($arr as $item) { //foreach element in $arr | |
| 250 xmlwriter_start_element($xw, 'MASH_STEP'); | |
| 251 field($xw, 'VERSION', '1'); | |
| 252 field($xw, 'NAME', $item['step_name']); | |
| 253 field($xw, 'TYPE', $mashsteptype[$item['step_type']]); | |
| 254 if ($item['step_type'] == 0) { | |
| 255 field($xw, 'INFUSE_AMOUNT', sprintf("%.3f",floatval($item['step_infuse_amount']))); | |
| 256 field($xw, 'INFUSE_TEMP', sprintf("%.3f",floatval($item['step_infuse_temp']))); | |
| 257 } | |
| 258 if ($item['step_type'] == 2) { | |
| 259 field($xw, 'DECOCTION_AMT', sprintf("%.3f",floatval($item['step_infuse_amount']))); | |
| 260 } | |
| 261 field($xw, 'STEP_TEMP', sprintf("%.1f",floatval($item['step_temp']))); | |
| 262 field($xw, 'STEP_TIME', sprintf("%.1f",floatval($item['step_time']))); | |
| 263 field($xw, 'RAMP_TIME', sprintf("%.1f",floatval($item['ramp_time']))); | |
| 264 field($xw, 'END_TEMP', sprintf("%.1f",floatval($item['end_temp']))); | |
| 265 field($xw, 'PH', sprintf("%.1f",floatval($row['mash_ph']))); | |
| 266 xmlwriter_end_element($xw); // MASH_STEP | |
| 267 } | |
| 268 xmlwriter_end_element($xw); // MASH_STEPS | |
| 269 xmlwriter_end_element($xw); // MASH | |
| 270 xmlwriter_end_element($xw); // RECIPE | |
| 271 xmlwriter_end_element($xw); // RECIPES | |
| 272 xmlwriter_end_document($xw); | |
| 273 | |
| 274 $beerxml = xmlwriter_output_memory($xw); | |
| 275 | |
| 276 Header('Content-type: text/xml'); | |
| 277 header('Content-Disposition: attachment; filename="' . $row['name'] . '.xml"'); | |
| 278 header('Content-Transfer-Encoding: binary'); | |
| 279 header('Expires: 0'); | |
| 280 header('Pragma: no-cache'); | |
| 281 header('Content-Length: '.strlen($beerxml)); | |
| 282 exit($beerxml); |
