comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 198
- f0ec83e1e01f
- parent 196
- 531d5458782f
- child 200
- 7b2f11652d67
equal
deleted
inserted
replaced
| 197:63174cff2cc1 | 198:f0ec83e1e01f |
|---|---|
| 221 $yeasts = simplexml_load_file($brouwhulp . '/yeasts.xml'); | 221 $yeasts = simplexml_load_file($brouwhulp . '/yeasts.xml'); |
| 222 | 222 |
| 223 foreach ($yeasts->YEAST as $yeast) { | 223 foreach ($yeasts->YEAST as $yeast) { |
| 224 | 224 |
| 225 $sql = "INSERT INTO inventory_yeasts SET name='" . mysqli_real_escape_string($db, $yeast->NAME); | 225 $sql = "INSERT INTO inventory_yeasts SET name='" . mysqli_real_escape_string($db, $yeast->NAME); |
| 226 $sql .= "', type='" . $yeast->TYPE; | 226 |
| 227 $sql .= "', form='" . $yeast->FORM; | 227 if ($yeast->TYPE == 'Lager') |
| 228 $sql .= "', type='0"; | |
| 229 else if ($yeast->TYPE == 'Ale') | |
| 230 $sql .= "', type='1"; | |
| 231 else if ($yeast->TYPE == 'Wheat') | |
| 232 $sql .= "', type='2"; | |
| 233 else if ($yeast->TYPE == 'Wine') | |
| 234 $sql .= "', type='3"; | |
| 235 else if ($yeast->TYPE == 'Champagne') | |
| 236 $sql .= "', type='4"; | |
| 237 else | |
| 238 echo "Unknown TYPE " . $yeast->TYPE . PHP_EOL; | |
| 239 | |
| 240 if ($yeast->FORM == 'Liquid') | |
| 241 $sql .= "', form='0"; | |
| 242 else if ($yeast->FORM == 'Dry') | |
| 243 $sql .= "', form='1"; | |
| 244 else if ($yeast->FORM == 'Slant') | |
| 245 $sql .= "', form='2"; | |
| 246 else if ($yeast->FORM == 'Culture') | |
| 247 $sql .= "', form='3"; | |
| 248 else if ($yeast->FORM == 'Frozen') | |
| 249 $sql .= "', form='4"; | |
| 250 else if ($yeast->FORM == 'Bottle') | |
| 251 $sql .= "', form='5"; | |
| 252 else | |
| 253 echo "Unknown FORM " . $yeast->FORM . PHP_EOL; | |
| 254 | |
| 228 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY); | 255 $sql .= "', laboratory='" . mysqli_real_escape_string($db, $yeast->LABORATORY); |
| 229 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID); | 256 $sql .= "', product_id='" . mysqli_real_escape_string($db, $yeast->PRODUCT_ID); |
| 230 if ($yeast->MIN_TEMPERATURE) | 257 if ($yeast->MIN_TEMPERATURE) |
| 231 $sql .= "', min_temperature='" . floatval($yeast->MIN_TEMPERATURE); | 258 $sql .= "', min_temperature='" . floatval($yeast->MIN_TEMPERATURE); |
| 232 if ($yeast->MAX_TEMPERATURE) | 259 if ($yeast->MAX_TEMPERATURE) |
| 233 $sql .= "', max_temperature='" . floatval($yeast->MAX_TEMPERATURE); | 260 $sql .= "', max_temperature='" . floatval($yeast->MAX_TEMPERATURE); |
| 234 $sql .= "', flocculation='" . $yeast->FLOCCULATION; | 261 |
| 262 if ($yeast->FLOCCULATION == 'Low') | |
| 263 $sql .= "', flocculation='0"; | |
| 264 else if ($yeast->FLOCCULATION == 'Medium') | |
| 265 $sql .= "', flocculation='1"; | |
| 266 else if ($yeast->FLOCCULATION == 'High') | |
| 267 $sql .= "', flocculation='2"; | |
| 268 else if ($yeast->FLOCCULATION == 'Very high') | |
| 269 $sql .= "', flocculation='3"; | |
| 270 else | |
| 271 echo "Unknown FLOCCULATION " . $yeast->FLOCCULATION . PHP_EOL; | |
| 272 | |
| 235 if ($yeast->ATTENUATION) | 273 if ($yeast->ATTENUATION) |
| 236 $sql .= "', attenuation='" . floatval($yeast->ATTENUATION); | 274 $sql .= "', attenuation='" . floatval($yeast->ATTENUATION); |
| 237 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); | 275 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); |
| 238 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); | 276 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); |
| 239 if ($yeast->MAX_REUSE) | 277 if ($yeast->MAX_REUSE) |
