Mercurial > bms / file diff

--- a/www/import/from_brouwhulp.php	Sat Jan 26 11:59:15 2019 +0100
+++ b/www/import/from_brouwhulp.php	Sat Jan 26 15:03:09 2019 +0100
@@ -447,7 +447,16 @@
 		$sql .= "', tun_volume='" . floatval($equipment->TUN_VOLUME);
 		$sql .= "', tun_weight='" . floatval($equipment->TUN_WEIGHT);
 		$sql .= "', tun_specific_heat='" . floatval($equipment->TUN_SPECIFIC_HEAT);
-		$sql .= "', tun_material='" . mysqli_real_escape_string($db, $equipment->TUN_MATERIAL);
+		if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.11)
+			$sql .= "', tun_material='0";
+		else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.22)
+			$sql .= "', tun_material='1";
+		else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.46)
+			$sql .= "', tun_material='2";
+		else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.092)
+			$sql .= "', tun_material='3";
+		else
+			echo "Unknown TUN_SPECIFIC_HEAT" . $equipment->TUN_SPECIFIC_HEAT . PHP_EOL;
 		$sql .= "', tun_height='" . floatval($equipment->TUN_HEIGHT);
 		$sql .= "', top_up_water='" . floatval($equipment->TOP_UP_WATER);
 		$sql .= "', trub_chiller_loss='" . floatval($equipment->TRUB_CHILLER_LOSS);