diff -r b316b88ebe12 -r f6fafccd8a6d www/upl_hops.php
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/www/upl_hops.php Sun Mar 03 13:26:28 2019 +0100
@@ -0,0 +1,123 @@
+ 500000 && $uploadOk) {
+ echo "Fout 2: het bestand is te groot. ";
+ $uploadOk = 0;
+}
+// Allow certain file formats
+if ($imageFileType != "xml" && $uploadOk) {
+ echo "Fout 3: alleen XML bestanden toegestaan. ";
+ $uploadOk = 0;
+}
+// Check if $uploadOk is set to 0 by an error
+if ($uploadOk == 0) {
+ exit;
+}
+
+if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
+ echo "Verwerken bestand ". basename( $_FILES["fileToUpload"]["name"]). "
";
+} else {
+ echo "Fout 4: er ging iets fout met de upload.";
+ exit;
+}
+
+
+$db = mysqli_connect(DBASE_HOST, DBASE_USER, DBASE_PASS, DBASE_NAME);
+if (! $db) {
+ echo "Fout 5: ".mysqli_connect_errno()." ".mysqli_connect_error();
+ exit;
+}
+mysqli_set_charset($db, "utf8" );
+date_default_timezone_set('Europe/Amsterdam');
+
+
+$imported = 0;
+$hops = simplexml_load_file($target_file);
+
+
+foreach ($hops->HOP as $hop) {
+
+ $sql = "INSERT INTO inventory_hops SET name='" . mysqli_real_escape_string($db, $hop->NAME);
+ if ($hop->ALPHA)
+ $sql .= "', alpha='" . floatval($hop->ALPHA);
+ if ($hop->BETA)
+ $sql .= "', beta='" . floatval($hop->BETA);
+ if ($hop->HUMULENE)
+ $sql .= "', humulene='" . floatval($hop->HUMULENE);
+ if ($hop->CAROPHYLLENE)
+ $sql .= "', caryophyllene='" . floatval($hop->CAROPHYLLENE);
+ if ($hop->COHUMULONE)
+ $sql .= "', cohumulone='" . floatval($hop->COHUMULONE);
+ if ($hop->MYRCENE)
+ $sql .= "', myrcene='" . floatval($hop->MYRCENE);
+ if ($hop->HSI)
+ $sql .= "', hsi='" . floatval($hop->HSI);
+
+ if ($hop->TYPE == 'Bittering')
+ $sql .= "', type='0";
+ else if ($hop->TYPE == 'Aroma')
+ $sql .= "', type='1";
+ else if ($hop->TYPE == 'Both')
+ $sql .= "', type='2";
+ else
+ echo "Unknown TYPE " . $hop->TYPE . "
";
+
+ if ($hop->FORM == 'Pellet')
+ $sql .= "', form='0";
+ else if ($hop->FORM == 'Plug')
+ $sql .= "', form='1";
+ else if ($hop->FORM == 'Leaf')
+ $sql .= "', form='2";
+ else
+ echo "Unknown FORM " . $hop->FORM . "
";
+
+ $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES);
+ $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN);
+ $sql .= "', substitutes='" . mysqli_real_escape_string($db, $hop->SUBSTITUTES);
+ ($hop->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
+ if ($hop->INVENTORY)
+ $sql .= "', inventory='" . floatval($hop->INVENTORY) / 1000.0;
+ if ($hop->COST)
+ $sql .= "', cost='" . floatval($hop->COST);
+ if ($hop->TOTAL_OIL)
+ $sql .= "', total_oil='" . floatval($hop->TOTAL_OIL);
+ if ($hop->HARVEST_DATE) {
+ $date = substr($hop->HARVEST_DATE, 6, 4).'-'.substr($hop->HARVEST_DATE, 3, 2).'-'.substr($hop->HARVEST_DATE, 0, 2);
+ $sql .= "', production_date='" . $date;
+ }
+ $sql .= "';";
+ if (! $result = mysqli_query($db, $sql)) {
+ echo "Fout 8: " . mysqli_error($db) . "
";
+ } else {
+ echo "+ " . $hop->NAME . "
";
+ $imported++;
+ }
+}
+
+if ($imported == 0) {
+ echo "Fout 7: geen hoppen in dit bestand.
";
+} else {
+ echo $imported . " hoppen toegevoegd.
";
+}
+
+
+
+// Don't clutter the upload directory.
+unlink($target_file);
+
+?>