www/import/from_brouwhulp.php

changeset 198
f0ec83e1e01f
parent 196
531d5458782f
child 200
7b2f11652d67
--- a/www/import/from_brouwhulp.php	Wed Jan 23 19:43:55 2019 +0100
+++ b/www/import/from_brouwhulp.php	Wed Jan 23 22:36:31 2019 +0100
@@ -223,15 +223,53 @@
 	foreach ($yeasts->YEAST as $yeast) {
 
 		$sql  = "INSERT INTO inventory_yeasts SET name='" . mysqli_real_escape_string($db, $yeast->NAME);
-		$sql .= "', type='" . $yeast->TYPE;
-		$sql .= "', form='" . $yeast->FORM;
+
+		if ($yeast->TYPE == 'Lager')
+			$sql .= "', type='0";
+		else if ($yeast->TYPE == 'Ale')
+			$sql .= "', type='1";
+		else if ($yeast->TYPE == 'Wheat')
+			$sql .= "', type='2";
+		else if ($yeast->TYPE == 'Wine')
+			$sql .= "', type='3";
+		else if ($yeast->TYPE == 'Champagne')
+			$sql .= "', type='4";
+		else
+			echo "Unknown TYPE " . $yeast->TYPE . PHP_EOL;
+
+		if ($yeast->FORM == 'Liquid')
+			$sql .= "', form='0";
+		else if ($yeast->FORM == 'Dry')
+			$sql .= "', form='1";
+		else if ($yeast->FORM == 'Slant')
+			$sql .= "', form='2";
+		else if ($yeast->FORM == 'Culture')
+			$sql .= "', form='3";
+		else if ($yeast->FORM == 'Frozen')
+			$sql .= "', form='4";
+		else if ($yeast->FORM == 'Bottle')
+			$sql .= "', form='5";
+		else
+			echo "Unknown FORM " . $yeast->FORM . PHP_EOL;
+
 		$sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY);
 		$sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID);
 		if ($yeast->MIN_TEMPERATURE)
 			$sql .= "', min_temperature='" . floatval($yeast->MIN_TEMPERATURE);
 		if ($yeast->MAX_TEMPERATURE)
 			$sql .= "', max_temperature='" . floatval($yeast->MAX_TEMPERATURE);
-		$sql .= "', flocculation='" . $yeast->FLOCCULATION;
+
+		if ($yeast->FLOCCULATION == 'Low')
+			$sql .= "', flocculation='0";
+		else if ($yeast->FLOCCULATION == 'Medium')
+			$sql .= "', flocculation='1";
+		else if ($yeast->FLOCCULATION == 'High')
+			$sql .= "', flocculation='2";
+		else if ($yeast->FLOCCULATION == 'Very high')
+			$sql .= "', flocculation='3";
+		else
+			echo "Unknown FLOCCULATION " . $yeast->FLOCCULATION . PHP_EOL;
+
 		if ($yeast->ATTENUATION)
 			$sql .= "', attenuation='" . floatval($yeast->ATTENUATION);
 		$sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES);

mercurial