comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 15
- ccbe79db80b8
- parent 13
- b8c3ca152984
- child 20
- 22271f3598ac
equal
deleted
inserted
replaced
| 14:d9dfd703df83 | 15:ccbe79db80b8 |
|---|---|
| 192 echo " Start adding waters to the database\n"; | 192 echo " Start adding waters to the database\n"; |
| 193 $sql = "TRUNCATE TABLE inventory_water_profiles;"; | 193 $sql = "TRUNCATE TABLE inventory_water_profiles;"; |
| 194 if (! $result = mysqli_query($db, $sql)) { | 194 if (! $result = mysqli_query($db, $sql)) { |
| 195 printf("Error: %s\n", mysqli_error($db)); | 195 printf("Error: %s\n", mysqli_error($db)); |
| 196 } | 196 } |
| 197 $sql = "TRUNCATE TABLE inventory_water_sources;"; | |
| 198 if (! $result = mysqli_query($db, $sql)) { | |
| 199 printf("Error: %s\n", mysqli_error($db)); | |
| 200 } | |
| 197 | 201 |
| 198 $waters = simplexml_load_file($brouwhulp . '/waters.xml'); | 202 $waters = simplexml_load_file($brouwhulp . '/waters.xml'); |
| 199 | 203 |
| 200 foreach ($waters->WATER as $water) { | 204 foreach ($waters->WATER as $water) { |
| 201 | 205 |
| 202 $sql = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME); | 206 if (($water->NAME == "Gedemineraliseerd water") || ($water->NAME == "Cristalline") || ($water->NAME == "Montille (Delhaize)") || |
| 207 ($water->NAME == "Spa Reine") || ($water->NAME == "Velsen") || ($water->NAME == "Zutphen") || | |
| 208 ($water->NAME == "Aurele Bronwater (Colruyt)")) { | |
| 209 $sql = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME); | |
| 210 } else { | |
| 211 $sql = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME); | |
| 212 } | |
| 213 | |
| 203 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='Y" : $sql .= "', always_on_stock='N"; | 214 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='Y" : $sql .= "', always_on_stock='N"; |
| 204 if ($water->NOTES) | 215 if ($water->NOTES) |
| 205 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); | 216 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); |
| 206 $sql .= "', calcium='" . $water->CALCIUM; | 217 $sql .= "', calcium='" . $water->CALCIUM; |
| 207 $sql .= "', bicarbonate='" . $water->BICARBONATE; | 218 $sql .= "', bicarbonate='" . $water->BICARBONATE; |
| 444 } | 455 } |
| 445 } | 456 } |
| 446 | 457 |
| 447 | 458 |
| 448 | 459 |
| 449 do_fermentables(); | 460 //do_fermentables(); |
| 450 do_hops(); | 461 //do_hops(); |
| 451 //do_yeasts(); | 462 //do_yeasts(); |
| 452 //do_waters(); | 463 do_waters(); |
| 453 //do_miscs(); | 464 //do_miscs(); |
| 454 //do_equipments(); | 465 //do_equipments(); |
| 455 //do_styles(); | 466 //do_styles(); |
| 456 //do_mash(); | 467 //do_mash(); |
| 457 | 468 |
