Sun, 12 May 2019 21:46:38 +0200
Version 0.3.1
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 | |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
153 | echo "Specerij, kruid, brouwzout etc Type grondstof Gebruik tijdens Hoeveel" . PHP_EOL; |
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
154 | echo "------------------------------ --------------- -------------------- -----------" . PHP_EOL; |
341
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]; |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
166 | $hoeveel = sprintf("%.2f %s",$amount,$aiw ? "gr":"ml"); |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
167 | |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
168 | echo sprintf("%s %-15s %-20s %11s", formatstr($item['m_name'], 30), $misctype[$item['m_type']], $gebruik, $hoeveel) . PHP_EOL; |
341
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> |