comparison: www/import/from_brouwhulp.php
www/import/from_brouwhulp.php
- changeset 196
- 531d5458782f
- parent 195
- 2ac491548d8d
- child 198
- f0ec83e1e01f
equal
deleted
inserted
replaced
| 195:2ac491548d8d | 196:531d5458782f |
|---|---|
| 163 $sql .= "', cohumulone='" . floatval($hop->COHUMULONE); | 163 $sql .= "', cohumulone='" . floatval($hop->COHUMULONE); |
| 164 if ($hop->MYCRENE) | 164 if ($hop->MYCRENE) |
| 165 $sql .= "', myrcene='" . floatval($hop->MYCRENE); | 165 $sql .= "', myrcene='" . floatval($hop->MYCRENE); |
| 166 if ($hop->HSI) | 166 if ($hop->HSI) |
| 167 $sql .= "', hsi='" . floatval($hop->HSI); | 167 $sql .= "', hsi='" . floatval($hop->HSI); |
| 168 $sql .= "', useat='Boil"; // brouwhulp says Aroma always :) | 168 |
| 169 $sql .= "', type='" . $hop->TYPE; | 169 if ($hop->TYPE == 'Bittering') |
| 170 $sql .= "', form='" . $hop->FORM; | 170 $sql .= "', type='0"; |
| 171 else if ($hop->TYPE == 'Aroma') | |
| 172 $sql .= "', type='1"; | |
| 173 else if ($hop->TYPE == 'Both') | |
| 174 $sql .= "', type='2"; | |
| 175 else | |
| 176 echo "Unknown TYPE " . $hop->TYPE . PHP_EOL; | |
| 177 | |
| 178 if ($hop->FORM == 'Pellet') | |
| 179 $sql .= "', form='0"; | |
| 180 else if ($hop->FORM == 'Plug') | |
| 181 $sql .= "', form='1"; | |
| 182 else if ($hop->FORM == 'Leaf') | |
| 183 $sql .= "', form='2"; | |
| 184 else | |
| 185 echo "Unknown FORM " . $hop->FORM . PHP_EOL; | |
| 186 | |
| 171 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES); | 187 $sql .= "', notes='" . mysqli_real_escape_string($db, $hop->NOTES); |
| 172 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN); | 188 $sql .= "', origin='" . mysqli_real_escape_string($db, $hop->ORIGIN); |
| 173 $sql .= "', substitutes='" . mysqli_real_escape_string($db, $hop->SUBSTITUTES); | 189 $sql .= "', substitutes='" . mysqli_real_escape_string($db, $hop->SUBSTITUTES); |
| 174 ($hop->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; | 190 ($hop->ALWAYS_ON_STOCK == 'TRUE') ? $sql .= "', always_on_stock='1" : $sql .= "', always_on_stock='0"; |
| 175 if ($hop->INVENTORY) | 191 if ($hop->INVENTORY) |
| 176 $sql .= "', inventory='" . floatval($hop->INVENTORY) / 1000.0; | 192 $sql .= "', inventory='" . floatval($hop->INVENTORY) / 1000.0; |
| 177 if ($hop->COST) | 193 if ($hop->COST) |
| 178 $sql .= "', cost='" . floatval($hop->COST); | 194 $sql .= "', cost='" . floatval($hop->COST); |
| 179 if ($hop->TOTAL_OIL) | 195 if ($hop->TOTAL_OIL) |
| 180 $sql .= "', total_oil='" . floatval($hop->TOTAL_OIL); | 196 $sql .= "', total_oil='" . floatval($hop->TOTAL_OIL); |
| 197 if ($hop->HARVEST_DATE) { | |
| 198 $date = substr($hop->HARVEST_DATE, 6, 4).'-'.substr($hop->HARVEST_DATE, 3, 2).'-'.substr($hop->HARVEST_DATE, 0, 2); | |
| 199 $sql .= "', production_date='" . $date; | |
| 200 } | |
| 181 $sql .= "';"; | 201 $sql .= "';"; |
| 182 if (! $result = mysqli_query($db, $sql)) { | 202 if (! $result = mysqli_query($db, $sql)) { |
| 183 printf("Error: %s\n", mysqli_error($db)); | 203 printf("Error: %s\n", mysqli_error($db)); |
| 184 } | 204 } |
| 185 } | 205 } |
