Product export to beerxml produces a clean recipe. No brewing information added.

Mon, 04 Feb 2019 20:56:44 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Mon, 04 Feb 2019 20:56:44 +0100
changeset 242
97c237654ddd
parent 241
e95d2886f49f
child 243
b43214d218c0

Product export to beerxml produces a clean recipe. No brewing information added.

www/prod_export.php file | annotate | diff | comparison | revisions
--- a/www/prod_export.php	Mon Feb 04 20:30:41 2019 +0100
+++ b/www/prod_export.php	Mon Feb 04 20:56:44 2019 +0100
@@ -18,11 +18,26 @@
 if (isset($_GET["record"]))
 	$record = $_GET["record"];
 else
-	$record = 14;
+	$record = 78;
 $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'");
 $row = mysqli_fetch_array($result);
 
 
+$recipetype = array( 'Extract', 'Partial Mash', 'All Grain' );
+$styletype = array( 'Lager', 'Ale', 'Mead', 'Wheat', 'Mixed', 'Cider' );
+$hoptype = array( 'Bittering', 'Aroma', 'Both' );
+$hopform = array( 'Pellet', 'Plug', 'Leaf' );
+$hopuse = array( 'Mash', 'First wort', 'Boil', 'Aroma', 'Whirlpool', 'Dry hop' );
+$fermentabletype = array( 'Grain', 'Sugar', 'Extract', 'Dry extract', 'Adjunct' );
+$graintype = array( 'Base', 'Roast', 'Crystal', 'Kilned', 'Sour malt', 'Special', 'No malt' );
+$yeasttype = array( 'Lager', 'Ale', 'Wheat', 'Wine', 'Champagne' );
+$yeastform = array( 'Liquid', 'Dry', 'Slant', 'Culture', 'Frozen', 'Bottle' );
+$yeastuse = array( 'Primary', 'Secondary', 'Tertiary', 'Bottle' );
+$misctype = array( 'Spice', 'Herb', 'Flavor', 'Fining', 'Water agent', 'Yeast nutrient', 'Other' );
+$miscuse = array( 'Starter', 'Mash', 'Boil', 'Primary', 'Secondary', 'Bottling' );
+$mashsteptype = array( 'Infusion', 'Temperature', 'Decoction' );
+
+
 
 /*
  * Create beerxml output
@@ -50,7 +65,7 @@
 xmlwriter_end_element($xw);
 
 xmlwriter_start_element($xw, 'TYPE');
-xmlwriter_text($xw, $row['type']);
+xmlwriter_text($xw, $recipetype[$row['type']]);
 xmlwriter_end_element($xw);
 
 xmlwriter_start_element($xw, 'BREWER');
@@ -109,7 +124,7 @@
 xmlwriter_end_element($xw);
 
 xmlwriter_start_element($xw, 'TYPE');
-xmlwriter_text($xw, $row['st_type']);
+xmlwriter_text($xw, $styletype[$row['st_type']]);
 xmlwriter_end_element($xw);
 
 xmlwriter_start_element($xw, 'OG_MIN');
@@ -213,7 +228,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'USE');
-	xmlwriter_text($xw, $item['h_useat']);
+	xmlwriter_text($xw, $hopuse[$item['h_useat']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TIME');
@@ -221,11 +236,11 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TYPE');
-	xmlwriter_text($xw, $item['h_type']);
+	xmlwriter_text($xw, $hoptype[$item['h_type']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'FORM');
-	xmlwriter_text($xw, $item['h_form']);
+	xmlwriter_text($xw, $hopform[$item['h_form']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'BETA');
@@ -258,7 +273,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TYPE');
-	xmlwriter_text($xw, $item['f_type']);
+	xmlwriter_text($xw, $fermentabletype[$item['f_type']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'AMOUNT');
@@ -320,7 +335,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'GRAINTYPE');
-	xmlwriter_text($xw, $item['f_graintype']);
+	xmlwriter_text($xw, $graintype[$item['f_graintype']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_end_element($xw);	// FERMENTABLE
@@ -342,7 +357,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TYPE');
-	xmlwriter_text($xw, $item['m_type']);
+	xmlwriter_text($xw, $misctype[$item['m_type']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'AMOUNT');
@@ -354,7 +369,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'USE');
-	xmlwriter_text($xw, $item['m_use_use']);
+	xmlwriter_text($xw, $miscuse[$item['m_use_use']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TIME');
@@ -380,11 +395,11 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TYPE');
-	xmlwriter_text($xw, $item['y_type']);
+	xmlwriter_text($xw, $yeasttype[$item['y_type']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'FORM');
-	xmlwriter_text($xw, $item['y_form']);
+	xmlwriter_text($xw, $yeastform[$item['y_form']]);
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'AMOUNT');
@@ -392,7 +407,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'AMOUNT_IS_WEIGHT');
-	($item['y_amount_is_weight']) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
+	($item['y_form'] == 1) ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'LABORATORY');
@@ -416,7 +431,7 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'ADD_TO_SECONDARY');
-	($item['y_use'] == 'Secondary') ? xmlwriter_text($xw, 'TRUE') : xmlwriter_text($xw, 'FALSE');
+	($item['y_use'] == 0) ? xmlwriter_text($xw, 'FALSE') : xmlwriter_text($xw, 'TRUE');
 	xmlwriter_end_element($xw);
 
 	xmlwriter_end_element($xw);	// YEAST
@@ -551,10 +566,10 @@
 	xmlwriter_end_element($xw);
 
 	xmlwriter_start_element($xw, 'TYPE');
-	xmlwriter_text($xw, $item['step_type']);
+	xmlwriter_text($xw, $mashsteptype[$item['step_type']]);
 	xmlwriter_end_element($xw);
 
-	if ($item['step_type'] == 'Infusion') {
+	if ($item['step_type'] == 0) {
 		xmlwriter_start_element($xw, 'INFUSE_AMOUNT');
 		xmlwriter_text($xw, sprintf("%.1f",floatval($item['step_infuse_amount'])));
 		xmlwriter_end_element($xw);

mercurial