comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 45
- 95251bedfab4
- parent 38
- b7d44c98d609
- child 48
- bdd1ec9b9c06
equal
deleted
inserted
replaced
| 44:6fea20eead56 | 45:95251bedfab4 |
|---|---|
| 179 function do_waters() | 179 function do_waters() |
| 180 { | 180 { |
| 181 global $brouwhulp, $db; | 181 global $brouwhulp, $db; |
| 182 | 182 |
| 183 echo " Start adding waters to the database\n"; | 183 echo " Start adding waters to the database\n"; |
| 184 $sql = "TRUNCATE TABLE inventory_water_profiles;"; | 184 $sql = "TRUNCATE TABLE profile_water;"; |
| 185 if (! $result = mysqli_query($db, $sql)) { | 185 if (! $result = mysqli_query($db, $sql)) { |
| 186 printf("Error: %s\n", mysqli_error($db)); | 186 printf("Error: %s\n", mysqli_error($db)); |
| 187 } | 187 } |
| 188 $sql = "TRUNCATE TABLE inventory_water_sources;"; | 188 $sql = "TRUNCATE TABLE inventory_water_sources;"; |
| 189 if (! $result = mysqli_query($db, $sql)) { | 189 if (! $result = mysqli_query($db, $sql)) { |
| 199 ($water->NAME == "Aurele Bronwater (Colruyt)")) { | 199 ($water->NAME == "Aurele Bronwater (Colruyt)")) { |
| 200 $sql = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME); | 200 $sql = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 201 ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0"; | 201 ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0"; |
| 202 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 202 ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
| 203 } else { | 203 } else { |
| 204 $sql = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME); | 204 $sql = "INSERT INTO profile_water SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 205 } | 205 } |
| 206 | 206 |
| 207 if ($water->NOTES) | 207 if ($water->NOTES) |
| 208 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); | 208 $sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES); |
| 209 $sql .= "', calcium='" . $water->CALCIUM; | 209 $sql .= "', calcium='" . $water->CALCIUM; |
| 320 function do_styles() | 320 function do_styles() |
| 321 { | 321 { |
| 322 global $brouwhulp, $db; | 322 global $brouwhulp, $db; |
| 323 | 323 |
| 324 echo " Start adding styles to the database\n"; | 324 echo " Start adding styles to the database\n"; |
| 325 $sql = "TRUNCATE TABLE inventory_styles;"; | 325 $sql = "TRUNCATE TABLE profile_styles;"; |
| 326 if (! $result = mysqli_query($db, $sql)) { | 326 if (! $result = mysqli_query($db, $sql)) { |
| 327 printf("Error: %s\n", mysqli_error($db)); | 327 printf("Error: %s\n", mysqli_error($db)); |
| 328 } | 328 } |
| 329 | 329 |
| 330 $styles = simplexml_load_file($brouwhulp . '/styles.xml'); | 330 $styles = simplexml_load_file($brouwhulp . '/styles.xml'); |
| 331 | 331 |
| 332 foreach ($styles->STYLE as $style) { | 332 foreach ($styles->STYLE as $style) { |
| 333 | 333 |
| 334 $sql = "INSERT INTO inventory_styles SET name='" . mysqli_real_escape_string($db, $style->NAME); | 334 $sql = "INSERT INTO profile_styles SET name='" . mysqli_real_escape_string($db, $style->NAME); |
| 335 if ($style->NOTES) | 335 if ($style->NOTES) |
| 336 $sql .= "', notes='" . mysqli_real_escape_string($db, $style->NOTES); | 336 $sql .= "', notes='" . mysqli_real_escape_string($db, $style->NOTES); |
| 337 if ($style->CATEGORY) | 337 if ($style->CATEGORY) |
| 338 $sql .= "', category='" . mysqli_real_escape_string($db, $style->CATEGORY); | 338 $sql .= "', category='" . mysqli_real_escape_string($db, $style->CATEGORY); |
| 339 if ($style->CATEGORY_NUMBER) | 339 if ($style->CATEGORY_NUMBER) |
| 374 function do_mash() | 374 function do_mash() |
| 375 { | 375 { |
| 376 global $brouwhulp, $db; | 376 global $brouwhulp, $db; |
| 377 | 377 |
| 378 echo " Start adding mash profiles to the database\n"; | 378 echo " Start adding mash profiles to the database\n"; |
| 379 $sql = "TRUNCATE TABLE inventory_mash_profiles;"; | 379 $sql = "TRUNCATE TABLE profile_mash;"; |
| 380 if (! $result = mysqli_query($db, $sql)) { | 380 if (! $result = mysqli_query($db, $sql)) { |
| 381 printf("Error: %s\n", mysqli_error($db)); | 381 printf("Error: %s\n", mysqli_error($db)); |
| 382 } | 382 } |
| 383 | 383 |
| 384 $mashes = simplexml_load_file($brouwhulp . '/mashs.xml'); | 384 $mashes = simplexml_load_file($brouwhulp . '/mashs.xml'); |
| 385 | 385 |
| 386 foreach ($mashes->MASH as $mash) { | 386 foreach ($mashes->MASH as $mash) { |
| 387 $sql = "INSERT INTO inventory_mash_profiles SET name='" . mysqli_real_escape_string($db, $mash->NAME); | 387 $sql = "INSERT INTO profile_mash SET name='" . mysqli_real_escape_string($db, $mash->NAME); |
| 388 if ($mash->NOTES) | 388 if ($mash->NOTES) |
| 389 $sql .= "', notes='" . mysqli_real_escape_string($db, $mash->NOTES); | 389 $sql .= "', notes='" . mysqli_real_escape_string($db, $mash->NOTES); |
| 390 | 390 |
| 391 /* | 391 /* |
| 392 * Put the steps in a json array | 392 * Put the steps in a json array |
| 431 | 431 |
| 432 do_fermentables(); | 432 do_fermentables(); |
| 433 do_hops(); | 433 do_hops(); |
| 434 do_yeasts(); | 434 do_yeasts(); |
| 435 do_miscs(); | 435 do_miscs(); |
| 436 //do_waters(); | 436 do_waters(); |
| 437 //do_equipments(); | 437 do_equipments(); |
| 438 do_styles(); | 438 do_styles(); |
| 439 do_mash(); | 439 do_mash(); |
| 440 | 440 |
| 441 mysqli_close($db); | 441 mysqli_close($db); |
| 442 | 442 |
