comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 99
- f433193f7bb6
- parent 96
- 107c12c3e49d
- child 100
- 08c92cb740b9
equal
deleted
inserted
replaced
| 98:92d6bc8a4cdd | 99:f433193f7bb6 |
|---|---|
| 210 | 210 |
| 211 if (($water->NAME == "Gedemineraliseerd water") || ($water->NAME == "Cristalline") || ($water->NAME == "Montille (Delhaize)") || | 211 if (($water->NAME == "Gedemineraliseerd water") || ($water->NAME == "Cristalline") || ($water->NAME == "Montille (Delhaize)") || |
| 212 ($water->NAME == "Spa Reine") || ($water->NAME == "Velsen") || ($water->NAME == "Zutphen") || | 212 ($water->NAME == "Spa Reine") || ($water->NAME == "Velsen") || ($water->NAME == "Zutphen") || |
| 213 ($water->NAME == "Aurele Bronwater (Colruyt)")) { | 213 ($water->NAME == "Aurele Bronwater (Colruyt)")) { |
| 214 $sql = "INSERT INTO inventory_waters SET name='" . mysqli_real_escape_string($db, $water->NAME); | 214 $sql = "INSERT INTO inventory_waters SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 215 ($water->DEFAULT_WATER == 'TRUE') ? $sql .= "', default_water='1" : $sql .= "', default_water='0"; | |
| 216 } else { | 215 } else { |
| 217 $sql = "INSERT INTO profile_water SET name='" . mysqli_real_escape_string($db, $water->NAME); | 216 $sql = "INSERT INTO profile_water SET name='" . mysqli_real_escape_string($db, $water->NAME); |
| 218 } | 217 } |
| 219 | 218 |
| 220 if ($water->NOTES) | 219 if ($water->NOTES) |
| 799 $waters .= ',"w_total_alkalinity":' . floatval($water->TOTAL_ALKALINITY); | 798 $waters .= ',"w_total_alkalinity":' . floatval($water->TOTAL_ALKALINITY); |
| 800 if ($water->COST) | 799 if ($water->COST) |
| 801 $waters .= ',"w_cost":' . floatval($water->COST); | 800 $waters .= ',"w_cost":' . floatval($water->COST); |
| 802 else | 801 else |
| 803 $waters .= ',"w_cost":0.00'; | 802 $waters .= ',"w_cost":0.00'; |
| 804 ($water->DEFAULT_WATER== "TRUE") ? $waters .= ',"w_default_water":true' : $waters.= ',"w_default_water":false'; | |
| 805 $waters .= "}"; | 803 $waters .= "}"; |
| 806 } | 804 } |
| 807 | 805 |
| 808 $waters .= ']'; | 806 $waters .= ']'; |
| 809 // echo $waters . PHP_EOL; | 807 // echo $waters . PHP_EOL; |
