www/import/from_brouwhulp.php

changeset 200
7b2f11652d67
parent 198
f0ec83e1e01f
child 201
f9b7e3f6be7c
equal deleted inserted replaced
199:dad62ec9af18 200:7b2f11652d67
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)

mercurial