www/import/from_brouwhulp.php

changeset 201
f9b7e3f6be7c
parent 200
7b2f11652d67
child 202
64a9c935a66b
equal deleted inserted replaced
200:7b2f11652d67 201:f9b7e3f6be7c
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 279
280 if ($yeast->FORM == 'Liquid') { 280 if ($yeast->FORM == 'Liquid') {
281 $sql .= "', cells='100000000000"; // 100 billion cells per pack 281 $sql .= "', cells='100000000000"; // 100 billion cells per pack
282 if ($yeast->COST)
283 $sql .= "', cost='" . floatval($yeast->COST);
284 if ($yeast->INVENTORY)
285 $sql .= "', inventory='" . floatval($yeast->INVENTORY);
282 } else if ($yeast->FORM == 'Dry') { 286 } else if ($yeast->FORM == 'Dry') {
283 $sql .= "', cells='15000000000"; // 6..15 billion per gram 287 $sql .= "', cells='15000000000"; // 6..15 billion per gram
288 if ($yeast->INVENTORY)
289 $sql .= "', inventory='" . floatval($yeast->INVENTORY) / 1000.0; // To kg
290 if ($yeast->COST)
291 $sql .= "', cost='" . floatval($yeast->COST) * 1000.0; // to Euro/kg
284 } else { 292 } else {
285 $sql .= "', cells='1700000000"; // 1.7 billion cells per ml. 293 $sql .= "', cells='1700000000"; // 1.7 billion cells per ml.
286 } 294 if ($yeast->INVENTORY)
287 if ($yeast->INVENTORY) 295 $sql .= "', inventory='" . floatval($yeast->INVENTORY) / 1000.0; // To liter
288 $sql .= "', inventory='" . floatval($yeast->INVENTORY) / 1000.0; // To kg or liter 296 if ($yeast->COST)
289 if ($yeast->COST) 297 $sql .= "', cost='" . floatval($yeast->COST) * 1000.0; // to Euro/liter
290 $sql .= "', cost='" . floatval($yeast->COST) * 1000.0; // to Euro/kg or liter 298 }
291 if ($yeast->CULTURE_DATE) { 299 if ($yeast->CULTURE_DATE) {
292 $date = substr($yeast->CULTURE_DATE, 6, 4) . '-' . substr($yeast->CULTURE_DATE, 3, 2) . '-' . substr($yeast->CULTURE_DATE, 0, 2); 300 $date = substr($yeast->CULTURE_DATE, 6, 4) . '-' . substr($yeast->CULTURE_DATE, 3, 2) . '-' . substr($yeast->CULTURE_DATE, 0, 2);
293 $sql .= "', production_date='" . $date; 301 $sql .= "', production_date='" . $date;
294 } 302 }
295 $sql .= "';"; 303 $sql .= "';";

mercurial