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 .= "';"; |