274 $sql .= "', attenuation='" . floatval($yeast->ATTENUATION); |
274 $sql .= "', attenuation='" . floatval($yeast->ATTENUATION); |
275 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); |
275 $sql .= "', notes='" . mysqli_real_escape_string($db, $yeast->NOTES); |
276 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); |
276 $sql .= "', best_for='" . mysqli_real_escape_string($db, $yeast->BEST_FOR); |
277 if ($yeast->MAX_REUSE) |
277 if ($yeast->MAX_REUSE) |
278 $sql .= "', max_reuse='" . $yeast->MAX_REUSE; |
278 $sql .= "', max_reuse='" . $yeast->MAX_REUSE; |
|
279 |
|
280 if ($yeast->FORM == 'Liquid') { |
|
281 $sql .= "', cells='100000000000"; // 100 billion cells per pack |
|
282 } else if ($yeast->FORM == 'Dry') { |
|
283 $sql .= "', cells='15000000000"; // 6..15 billion per gram |
|
284 } else { |
|
285 $sql .= "', cells='1700000000"; // 1.7 billion cells per ml. |
|
286 } |
279 if ($yeast->INVENTORY) |
287 if ($yeast->INVENTORY) |
280 $sql .= "', inventory='" . floatval($yeast->INVENTORY) / 1000.0; |
288 $sql .= "', inventory='" . floatval($yeast->INVENTORY) / 1000.0; // To kg or liter |
281 if ($yeast->COST) |
289 if ($yeast->COST) |
282 $sql .= "', cost='" . floatval($yeast->COST) * 1000.0; |
290 $sql .= "', cost='" . floatval($yeast->COST) * 1000.0; // to Euro/kg or liter |
283 if ($yeast->CULTURE_DATE) { |
291 if ($yeast->CULTURE_DATE) { |
284 $date = substr($yeast->CULTURE_DATE, 6, 4) . '-' . substr($yeast->CULTURE_DATE, 3, 2) . '-' . substr($yeast->CULTURE_DATE, 0, 2); |
292 $date = substr($yeast->CULTURE_DATE, 6, 4) . '-' . substr($yeast->CULTURE_DATE, 3, 2) . '-' . substr($yeast->CULTURE_DATE, 0, 2); |
285 $sql .= "', production_date='" . $date; |
293 $sql .= "', production_date='" . $date; |
286 } |
294 } |
287 $sql .= "';"; |
295 $sql .= "';"; |
354 foreach ($miscs->MISC as $misc) { |
362 foreach ($miscs->MISC as $misc) { |
355 |
363 |
356 $sql = "INSERT INTO inventory_miscs SET name='" . mysqli_real_escape_string($db, $misc->NAME); |
364 $sql = "INSERT INTO inventory_miscs SET name='" . mysqli_real_escape_string($db, $misc->NAME); |
357 if ($misc->NOTES) |
365 if ($misc->NOTES) |
358 $sql .= "', notes='" . mysqli_real_escape_string($db, $misc->NOTES); |
366 $sql .= "', notes='" . mysqli_real_escape_string($db, $misc->NOTES); |
359 $sql .= "', type='" . $misc->TYPE; |
367 |
360 $sql .= "', use_use='" . $misc->USE; |
368 if ($misc->TYPE == 'Spice') |
|
369 $sql .= "', type='0"; |
|
370 else if ($misc->TYPE == 'Herb') |
|
371 $sql .= "', type='1"; |
|
372 else if ($misc->TYPE == 'Flavor') |
|
373 $sql .= "', type='2"; |
|
374 else if ($misc->TYPE == 'Fining') |
|
375 $sql .= "', type='3"; |
|
376 else if ($misc->TYPE == 'Water agent') |
|
377 $sql .= "', type='4"; |
|
378 else if ($misc->TYPE == 'Yeast nutrient') |
|
379 $sql .= "', type='5"; |
|
380 else if ($misc->TYPE == 'Other') |
|
381 $sql .= "', type='6"; |
|
382 else |
|
383 echo "Unknown TYPE " . $misc->TYPE . PHP_EOL; |
|
384 |
|
385 if ($misc->USE == 'Starter') |
|
386 $sql .= "', use_use='0"; |
|
387 else if ($misc->USE == 'Mash') |
|
388 $sql .= "', use_use='1"; |
|
389 else if ($misc->USE == 'Boil') |
|
390 $sql .= "', use_use='2"; |
|
391 else if ($misc->USE == 'Primary') |
|
392 $sql .= "', use_use='3"; |
|
393 else if ($misc->USE == 'Secondary') |
|
394 $sql .= "', use_use='4"; |
|
395 else if ($misc->USE == 'Bottling') |
|
396 $sql .= "', use_use='5"; |
|
397 else |
|
398 echo "Unknown USE " . $misc->USE . PHP_EOL; |
|
399 |
361 $sql .= "', time='" . $misc->TIME; |
400 $sql .= "', time='" . $misc->TIME; |
362 ($misc->AMOUNT_IS_WEIGHT == 'TRUE') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; |
401 ($misc->AMOUNT_IS_WEIGHT == 'TRUE') ? $sql .= "', amount_is_weight='1" : $sql .= "', amount_is_weight='0"; |
363 if ($misc->USE_FOR) |
402 if ($misc->USE_FOR) |
364 $sql .= "', use_for='" . mysqli_real_escape_string($db, $misc->USE_FOR); |
403 $sql .= "', use_for='" . mysqli_real_escape_string($db, $misc->USE_FOR); |
365 if ($misc->ALWAYS_ON_STOCK) |
404 if ($misc->ALWAYS_ON_STOCK) |