Sat, 11 May 2019 16:55:41 +0200
Reduce inventory is now done in a cron job at moments when there are ingredients used. So the inventory should be uptodate at all times.
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
3 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | if (! $link) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
8 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
10 | if (! mysqli_set_charset($link, "utf8" )) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | echo "error"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | return 1; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
14 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
15 | setlocale ( LC_ALL, 'nl_NL.UTF-8'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | $record = $_GET["record"]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'"); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | $row = mysqli_fetch_array($result); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | $preboil_sg = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | date_default_timezone_set('Europe/Amsterdam'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | $prdate = date(DATE_RFC2822); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
24 | ?> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
25 | <!DOCTYPE html> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
26 | <html lang=nl-NL> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | <head> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | <meta http-equiv="content-type" content="text/html; charset=utf-8" /> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | <title>BMS v<?php echo $my_version;?> - Export recipe</title> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
30 | <meta name="viewport" content="width=device-width, initial-scale=1 maximum-scale=1 minimum-scale=1" /> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
31 | </head> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
32 | <body> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
33 | <pre> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
34 | <?php |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | $recipetype = array( 'Extract', 'Deelmaisch', 'Mout' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | $colormethod = array( 'Morey', 'Mosher', 'Daniels' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | $ibumethod = array( 'Tinseth', 'Rager', 'Daniels' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | $added = array( 'Maischen', 'Koken', 'Vergisten', 'Nagisten/lageren', 'Bottelen' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | $hopform = array( 'Pellets', 'Plugs', 'Bellen', 'Hop nat' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | $hopuse = array( 'Maischen', 'First wort', 'Koken', 'Vlamuit', 'Whirlpool', 'Koudhop' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | $misctype = array( 'Specerij', 'Kruid', 'Smaakstof', 'Klaringsmiddel', 'Brouwzout', 'Gistvoeding', 'Anders' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | $miscuse = array( 'Starter', 'Maischen', 'Koken', 'Hoofdvergisting', 'Nagisting/lagering', 'Bottelen' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | $yeastform = array( 'Vloeibaar', 'Droog', 'Schuine buis', 'Slurry', 'Ingevroren', 'Depot' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | $yeastuse = array( 'Hoofdgisting', 'Nagisting', 'Lagering', 'Bottelen' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | $steptype = array( 'Infusie', 'Directe verwarming', 'Decoctie' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
47 | $acidtype = array( 'Melkzuur', 'Zoutzuur', 'Fosforzuur', 'Zwavelzuur' ); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
48 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
49 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | function itemline($item, $content) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
51 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
52 | echo $item . " "; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
53 | for ($i = strlen($item); $i < 40; $i++) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | echo "."; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
55 | echo ": " . $content . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
57 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | function formatstr($strin, $len) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
61 | $strout = null; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | $cnt = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
63 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
64 | for ($i = 0; $i < strlen($strin); $i++) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
65 | $ord = ord($strin[$i]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
66 | if ($ord != 195) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
67 | $cnt++; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
68 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
69 | switch ($strin[$i]) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
70 | case '<': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
71 | $strout .= '<'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
73 | case '>': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
74 | $strout .= '>'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
75 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
76 | case '&': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
77 | $strout .= '&'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
78 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
79 | case '"': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
80 | $strout .= '"'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
81 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
82 | default: |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
83 | $strout .= $strin[$i]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
84 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
85 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
86 | if ($cnt >= $len) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
87 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
88 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
89 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
90 | for ($i = $cnt; $i < $len; $i++) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
91 | $strout .= " "; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
92 | return $strout; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
93 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
94 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
95 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
96 | echo "BMS v" . $my_version . " - Datum export: " . $prdate . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
97 | echo "----------------------------------------------------------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
98 | itemline("Bier naam", $row['code'].' '.$row['name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
99 | itemline("Bier stijl", $row['st_name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
100 | itemline("Recept type", $recipetype[$row['type']]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
101 | itemline("Batch grootte", $row['batch_size'].' liter'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
102 | itemline("Kooktijd", $row['boil_time'].' minuten'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
103 | itemline("Brouwzaal rendement", $row['efficiency'].' %'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
104 | itemline("Geschatte begin densiteit", sprintf("%.3f",$row['est_og']).' SG/ '.sprintf("%.1f", sg_to_plato($row['est_og'])).'°P'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
105 | itemline("Geschatte eind densiteit", sprintf("%.3f",$row['est_fg']).' SG/ '.sprintf("%.1f", sg_to_plato($row['est_fg'])).'°P'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
106 | itemline("Geschat alcohol", sprintf("%.1f",$row['est_abv']).'% vol'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
107 | itemline("Kleur (" . $colormethod[$row['color_method']] . ")", $row['est_color'] . ' EBC'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
108 | itemline("Bitterheid (" . $ibumethod[$row['ibu_method']] . ")", $row['est_ibu'] . ' IBU'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
109 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
110 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
111 | $sugarsm = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
112 | $grainabsorbtion = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
113 | $mashwater = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
114 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
115 | $arr = json_decode($row['json_fermentables'], true); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
116 | echo "Mout, granen en suikers EBC Gewicht kg % Gebruik tijdens" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
117 | echo "---------------------------------------- --- ---------- ----- ----------------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
118 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
119 | $name = formatstr($item['f_name'] . " (" . $item['f_supplier'] . ")", 40); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
120 | $amount = floatval($item['f_amount']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
121 | $d = $amount * (floatval($item['f_yield']) / 100) * (1 - floatval($item['f_moisture']) / 100); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
122 | if ($item['f_added'] == 0) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
123 | $d = floatval($row['efficiency']) / 100 * $d; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
124 | $sugarsm += $d; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
125 | $grainabsorbtion += $item['f_amount']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
126 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
127 | echo sprintf("%s %3.0f %10.3f %5.1f ", $name, floatval($item['f_color']), $amount, floatval($item['f_percentage'])); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
128 | echo $added[$item['f_added']] . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
129 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
130 | $preboil_sg = estimate_sg($sugarsm, floatval($row['boil_size'])); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
131 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
132 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
133 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
134 | echo "Hop Vorm α % IBU Gram Toevoegen moment" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
135 | echo "---------------------------------------- ------- ----- ----- ------ --------------------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
136 | $arr = json_decode($row['json_hops'], true); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
137 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
138 | $name = formatstr($item['h_name'] . " (" . $item['h_origin'] . ")", 40); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
139 | $amount = floatval($item['h_amount']) * 1000; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
140 | $time = floatval($item['h_time']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
141 | $alpha = floatval($item['h_alpha']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
142 | $ibu = calc_IBU($item['h_useat'], $item['h_form'], $preboil_sg, floatval($row['batch_size']), $amount, $time, $alpha, $row['ibu_method']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
143 | $moment = $hopuse[$item['h_useat']]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
144 | if ($item['h_useat'] == 2) { // Boil |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
145 | $moment = "Kook ".$time." minuten"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
146 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
147 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
148 | echo sprintf("%s %-7s %5.1f %5.1f %6.1f %-20s", $name, $hopform[$item['h_form']], $alpha, $ibu, $amount, $moment); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
149 | echo PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
150 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
151 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
152 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
153 | echo "Specerij, kruid, brouwzout etc Type grondstof Gebruik tijdens Hoeveel" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
154 | echo "------------------------------ --------------- -------------------- ----------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
155 | $arr = json_decode($row['json_miscs'], true); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
156 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
157 | $amount = floatval($item['m_amount']) * 1000; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
158 | $aiw = $item['m_amount_is_weight']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
159 | $use_use = $item['m_use_use']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
160 | $time = floatval($item['m_time']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
161 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
162 | if ($use_use == 2) // Boil |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
163 | $gebruik = sprintf("%s %d min",$miscuse[$use_use],$time); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
164 | else |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
165 | $gebruik = $miscuse[$use_use]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
166 | $hoeveel = sprintf("%.1f %s",$amount,$aiw ? "gr":"ml"); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
167 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
168 | echo sprintf("%s %-15s %-20s %10s", formatstr($item['m_name'], 30), $misctype[$item['m_type']], $gebruik, $hoeveel) . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
169 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
170 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
171 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
172 | echo "Gistlab en code Omschrijving Gebruik Vorm Hoeveel" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
173 | echo "-------------------- ------------------------------ ------------ ------------ ----------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
174 | $arr = json_decode($row['json_yeasts'], true); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
175 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
176 | $name = formatstr($item['y_name'], 30); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
177 | $product = formatstr($item['y_laboratory']." ".$item['y_product_id'], 20); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
178 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
179 | if ($item['y_form'] == 0) // Liquid |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
180 | $amount = sprintf("%.0f",floatval($item['y_amount']))." pak"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
181 | else if ($item['y_form'] == 1) // Dry |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
182 | $amount = sprintf("%.1f",floatval($item['y_amount'])*1000)." gr"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
183 | else |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
184 | $amount = sprintf("%.0f",floatval($item['y_amount'])*1000)." ml"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
185 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
186 | echo sprintf("%s %s %-12s %-12s %10s", $product, $name, $yeastuse[$item['y_use']], $yeastform[$item['y_form']], $amount) . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
187 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
188 | if ($row['starter_enable'] && $row['prop1_volume']) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
189 | $sv = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
190 | for ($i = 1; $i < 5; $i++) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
191 | $pv = "prop".$i."_volume"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
192 | if (floatval($row[$pv]) && (floatval($row[$pv]) > $sv)) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
193 | $sv = floatval($row[$pv]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
194 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
195 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
196 | echo PHP_EOL . "Maak een giststarter van " . sprintf("%.1f", $sv) . " liter." . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
197 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
198 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
199 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
200 | if ($row['w1_name']) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
201 | $mashwater += floatval($row['w1_amount']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
202 | if ($row['w2_name']) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
203 | $mashwater += floatval($row['w2_amount']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
204 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
205 | echo "Maisch stap stap type stap temp rusten opwarmen" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
206 | echo "-------------------- ---------------------- --------- --------- ---------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
207 | $arr = json_decode($row['json_mashs'], true); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
208 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
209 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
210 | if ($item['step_type'] == 1) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
211 | $stype = formatstr($steptype[$item['step_type']], 22); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
212 | } else { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
213 | $stype = formatstr($steptype[$item['step_type']].' '.sprintf("%.1f", $item['step_infuse_amount']).' liter', 22); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
214 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
215 | echo sprintf("%s %s %s %s %s", |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
216 | formatstr($item['step_name'], 20), $stype, sprintf("%6.1f °C", $item['step_temp']), |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
217 | sprintf("%4.0f min.", $item['step_time']), sprintf("%4.0f min.", $item['ramp_time'])) . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
218 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
219 | echo PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
220 | if ($row['w1_name'] && $row['w2_name']) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
221 | itemline("Maischwater 1", sprintf("%.1f",floatval($row['w1_amount'])).' liter water '.$row['w1_name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
222 | itemline("Maischwater 2", sprintf("%.1f",floatval($row['w2_amount'])).' liter water '.$row['w2_name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
223 | } else { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
224 | itemline("Maischwater", sprintf("%.1f",floatval($row['w1_amount'])).' liter water '.$row['w1_name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
225 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
226 | itemline("Maischwater aanzuren tot pH", $row['mash_ph'].' pH'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
227 | $spoelw = ($row['boil_size'] - $mashwater + $grainabsorbtion + $row['eq_lauter_deadspace']) * 1.03; // A small heat correction |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
228 | itemline("Spoelwater geschat", sprintf("%.1f", $spoelw)." liter"); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
229 | itemline("Spoelwater temperatuur", $row['sparge_temp'].' °C'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
230 | itemline("Spoelwater aanzuren tot pH", sprintf("%.1f",$row['sparge_ph']).' pH'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
231 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
232 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
233 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
234 | ?> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
235 | </pre> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
236 | </body> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
237 | </html> |