www/import/from_brouwhulp.php

changeset 209
dc30801e6961
parent 202
64a9c935a66b
child 213
b0d484a5525e
equal deleted inserted replaced
208:578c78abf058 209:dc30801e6961
445 $sql .= "', boil_size='" . floatval($equipment->BOIL_SIZE); 445 $sql .= "', boil_size='" . floatval($equipment->BOIL_SIZE);
446 $sql .= "', batch_size='" . floatval($equipment->BATCH_SIZE); 446 $sql .= "', batch_size='" . floatval($equipment->BATCH_SIZE);
447 $sql .= "', tun_volume='" . floatval($equipment->TUN_VOLUME); 447 $sql .= "', tun_volume='" . floatval($equipment->TUN_VOLUME);
448 $sql .= "', tun_weight='" . floatval($equipment->TUN_WEIGHT); 448 $sql .= "', tun_weight='" . floatval($equipment->TUN_WEIGHT);
449 $sql .= "', tun_specific_heat='" . floatval($equipment->TUN_SPECIFIC_HEAT); 449 $sql .= "', tun_specific_heat='" . floatval($equipment->TUN_SPECIFIC_HEAT);
450 $sql .= "', tun_material='" . mysqli_real_escape_string($db, $equipment->TUN_MATERIAL); 450 if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.11)
451 $sql .= "', tun_material='0";
452 else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.22)
453 $sql .= "', tun_material='1";
454 else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.46)
455 $sql .= "', tun_material='2";
456 else if (floatval($equipment->TUN_SPECIFIC_HEAT) == 0.092)
457 $sql .= "', tun_material='3";
458 else
459 echo "Unknown TUN_SPECIFIC_HEAT" . $equipment->TUN_SPECIFIC_HEAT . PHP_EOL;
451 $sql .= "', tun_height='" . floatval($equipment->TUN_HEIGHT); 460 $sql .= "', tun_height='" . floatval($equipment->TUN_HEIGHT);
452 $sql .= "', top_up_water='" . floatval($equipment->TOP_UP_WATER); 461 $sql .= "', top_up_water='" . floatval($equipment->TOP_UP_WATER);
453 $sql .= "', trub_chiller_loss='" . floatval($equipment->TRUB_CHILLER_LOSS); 462 $sql .= "', trub_chiller_loss='" . floatval($equipment->TRUB_CHILLER_LOSS);
454 /* 463 /*
455 * Brouwhulp uses a percentage for the evaporation rate. This is wrong 464 * Brouwhulp uses a percentage for the evaporation rate. This is wrong

mercurial