www/import/from_brouwhulp.php

changeset 22
99c02fa797f9
parent 21
acb2d8098f19
child 23
4b157d7a1cee
--- a/www/import/from_brouwhulp.php	Fri Aug 17 15:20:56 2018 +0200
+++ b/www/import/from_brouwhulp.php	Sat Aug 18 14:21:21 2018 +0200
@@ -203,11 +203,11 @@
 		    ($water->NAME == "Aurele Bronwater (Colruyt)")) {
 		    $sql  = "INSERT INTO inventory_water_sources SET name='" . mysqli_real_escape_string($db, $water->NAME);
 		    ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0";
+		    ($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
 		} else {
 			$sql  = "INSERT INTO inventory_water_profiles SET name='" . mysqli_real_escape_string($db, $water->NAME);
 		}
 
-		($water->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0";
 		if ($water->NOTES)
 			$sql .= "', notes='" . mysqli_real_escape_string($db, $water->NOTES);
 		$sql .= "', calcium='" . $water->CALCIUM;

mercurial