Wed, 16 Oct 2019 21:05:03 +0200
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
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'); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
4 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/constants.php'); |
341
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 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | $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
|
8 | if (! $link) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
9 | 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
|
10 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
11 | if (! mysqli_set_charset($link, "utf8" )) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
12 | echo "error"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
13 | return 1; |
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 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | 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
|
17 | $record = $_GET["record"]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | $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
|
19 | $row = mysqli_fetch_array($result); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
21 | $preboil_sg = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
22 | date_default_timezone_set('Europe/Amsterdam'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
23 | $prdate = date(DATE_RFC2822); |
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 | ?> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
26 | <!DOCTYPE html> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
27 | <html lang=nl-NL> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
28 | <head> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
29 | <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
|
30 | <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
|
31 | <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
|
32 | </head> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
33 | <body> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
34 | <pre> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | <?php |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | function itemline($item, $content) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | echo $item . " "; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | 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
|
42 | echo "."; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | echo ": " . $content . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
47 | function formatstr($strin, $len) { |
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 | $strout = null; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | $cnt = 0; |
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 | 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
|
53 | $ord = ord($strin[$i]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | if ($ord != 195) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
55 | $cnt++; |
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 | switch ($strin[$i]) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | case '<': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | $strout .= '<'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
61 | case '>': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | $strout .= '>'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
63 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
64 | case '&': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
65 | $strout .= '&'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
66 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
67 | case '"': |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
68 | $strout .= '"'; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
69 | break; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
70 | default: |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
71 | $strout .= $strin[$i]; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
73 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
74 | if ($cnt >= $len) |
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 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
77 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
78 | for ($i = $cnt; $i < $len; $i++) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
79 | $strout .= " "; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
80 | return $strout; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
81 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
82 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
83 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
84 | 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
|
85 | echo "----------------------------------------------------------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
86 | 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
|
87 | itemline("Bier stijl", $row['st_name']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
88 | itemline("Recept type", $recipetype[$row['type']]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
89 | 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
|
90 | itemline("Kooktijd", $row['boil_time'].' minuten'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
91 | itemline("Brouwzaal rendement", $row['efficiency'].' %'); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
92 | 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
|
93 | 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
|
94 | 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
|
95 | 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
|
96 | 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
|
97 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
98 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
99 | $sugarsm = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
100 | $grainabsorbtion = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
101 | $mashwater = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
102 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
103 | $arr = json_decode($row['json_fermentables'], true); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
104 | echo "Mout, granen en suikers EBC Gewicht kg % Gebruik tijdens" . PHP_EOL; |
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
105 | echo "---------------------------------------- ---- ---------- ----- ----------------" . PHP_EOL; |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
106 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
107 | $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
|
108 | $amount = floatval($item['f_amount']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
109 | $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
|
110 | if ($item['f_added'] == 0) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
111 | $d = floatval($row['efficiency']) / 100 * $d; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
112 | $sugarsm += $d; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
113 | $grainabsorbtion += $item['f_amount']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
114 | } |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
115 | echo sprintf("%s %4.0f %10.3f %5.1f ", $name, floatval($item['f_color']), $amount, floatval($item['f_percentage'])); |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
116 | 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
|
117 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
118 | $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
|
119 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
120 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
121 | |
449
a1d6b9eec988
Added Cryo Hop support to the export scripts.
Michiel Broek <mbroek@mbse.eu>
parents:
399
diff
changeset
|
122 | echo "Hop Vorm α % IBU Gram Toevoegen moment" . PHP_EOL; |
a1d6b9eec988
Added Cryo Hop support to the export scripts.
Michiel Broek <mbroek@mbse.eu>
parents:
399
diff
changeset
|
123 | echo "---------------------------------------- -------- ----- ----- ------ --------------------" . PHP_EOL; |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
124 | $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
|
125 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
126 | $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
|
127 | $amount = floatval($item['h_amount']) * 1000; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
128 | $time = floatval($item['h_time']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
129 | $alpha = floatval($item['h_alpha']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
130 | $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
|
131 | $moment = $hopuse[$item['h_useat']]; |
399
6f1cde4215d3
In the checklist misc ingredients shows liquid or weight. In forum output whirlpool hops show the time in minutes.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
132 | if (($item['h_useat'] == 2) || ($item['h_useat'] == 4)) { // Boil or Whirlpool |
6f1cde4215d3
In the checklist misc ingredients shows liquid or weight. In forum output whirlpool hops show the time in minutes.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
133 | $moment = $hopuse[$item['h_useat']].' '.$time." minuten"; |
392
544d7d0183b2
Added 15 fields to the recipes table. Added 18 fields to the products table. These are calculated values that are now stored in the database so export programs can use these values without calculating them again. Product and recipe print have water and mash schedule added. Product print has brewday results added if the brewday is over. The ingredients layout changed in the product and recipe prints.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
134 | } else if ($item['h_useat'] == 5) { // Dryhop |
399
6f1cde4215d3
In the checklist misc ingredients shows liquid or weight. In forum output whirlpool hops show the time in minutes.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
135 | $moment = $hopuse[$item['h_useat']].' '.sprintf("%.0f", $time / 1440).' dagen'; |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
136 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
137 | |
449
a1d6b9eec988
Added Cryo Hop support to the export scripts.
Michiel Broek <mbroek@mbse.eu>
parents:
399
diff
changeset
|
138 | echo sprintf("%s %-8s %5.1f %5.1f %6.1f %-20s", $name, $hopform[$item['h_form']], $alpha, $ibu, $amount, $moment); |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
139 | echo PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
140 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
141 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
142 | |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
143 | 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
|
144 | echo "------------------------------ --------------- -------------------- -----------" . PHP_EOL; |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
145 | $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
|
146 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
147 | $amount = floatval($item['m_amount']) * 1000; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
148 | $aiw = $item['m_amount_is_weight']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
149 | $use_use = $item['m_use_use']; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
150 | $time = floatval($item['m_time']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
151 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
152 | if ($use_use == 2) // Boil |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
153 | $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
|
154 | else |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
155 | $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
|
156 | $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
|
157 | |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
341
diff
changeset
|
158 | 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
|
159 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
160 | echo PHP_EOL . PHP_EOL; |
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 | 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
|
163 | echo "-------------------- ------------------------------ ------------ ------------ ----------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
164 | $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
|
165 | foreach($arr as $item) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
166 | $name = formatstr($item['y_name'], 30); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
167 | $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
|
168 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
169 | if ($item['y_form'] == 0) // Liquid |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
170 | $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
|
171 | 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
|
172 | $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
|
173 | else |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
174 | $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
|
175 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
176 | 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
|
177 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
178 | 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
|
179 | $sv = 0; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
180 | for ($i = 1; $i < 5; $i++) { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
181 | $pv = "prop".$i."_volume"; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
182 | 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
|
183 | $sv = floatval($row[$pv]); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
184 | } |
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 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
|
187 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
188 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
189 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
190 | if ($row['w1_name']) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
191 | $mashwater += floatval($row['w1_amount']); |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
192 | if ($row['w2_name']) |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
193 | $mashwater += floatval($row['w2_amount']); |
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 | 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
|
196 | echo "-------------------- ---------------------- --------- --------- ---------" . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
197 | $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
|
198 | foreach($arr as $item) { |
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 ($item['step_type'] == 1) { |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
201 | $stype = formatstr($mashtype[$item['step_type']], 22); |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
202 | } else { |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
203 | $stype = formatstr($mashtype[$item['step_type']].' '.sprintf("%.1f", $item['step_infuse_amount']).' liter', 22); |
341
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 sprintf("%s %s %s %s %s", |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
206 | 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
|
207 | 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
|
208 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
209 | echo PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
210 | 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
|
211 | 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
|
212 | 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
|
213 | } else { |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
214 | 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
|
215 | } |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
216 | itemline("Maischwater aanzuren tot pH", $row['mash_ph'].' pH'); |
392
544d7d0183b2
Added 15 fields to the recipes table. Added 18 fields to the products table. These are calculated values that are now stored in the database so export programs can use these values without calculating them again. Product and recipe print have water and mash schedule added. Product print has brewday results added if the brewday is over. The ingredients layout changed in the product and recipe prints.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
217 | itemline("Spoelwater geschat", sprintf("%.1f", $row['brew_sparge_est'])." liter"); |
341
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
218 | 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
|
219 | 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
|
220 | echo PHP_EOL . PHP_EOL; |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
221 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
222 | |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
223 | ?> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
224 | </pre> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
225 | </body> |
9c4bc199be9e
Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
226 | </html> |