www/prod_forum.php

Sun, 27 Oct 2019 22:39:28 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sun, 27 Oct 2019 22:39:28 +0100
changeset 539
fe9ac6d49c4f
parent 516
28670364bd0c
child 542
dabe1c854a0f
permissions
-rw-r--r--

Printed outputs have IBUs for whirlpool hops. Removed some debug console logs.

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 .= '&lt;';
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 .= '&gt;';
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 .= '&amp;';
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 .= '&quot;';
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'])).'&deg;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'])).'&deg;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 &alpha; % 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']);
539
fe9ac6d49c4f Printed outputs have IBUs for whirlpool hops. Removed some debug console logs.
Michiel Broek <mbroek@mbse.eu>
parents: 516
diff changeset
130 $ibu = calc_IBU($item['h_useat'], $item['h_form'], $preboil_sg, floatval($row['batch_size']), $amount, $time, $alpha,
fe9ac6d49c4f Printed outputs have IBUs for whirlpool hops. Removed some debug console logs.
Michiel Broek <mbroek@mbse.eu>
parents: 516
diff changeset
131 $row['ibu_method'], $row['brew_whirlpool9'], $row['brew_whirlpool7'], $row['brew_whirlpool6']);
341
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
132 $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
133 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
134 $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
135 } 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
136 $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
137 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
138
449
a1d6b9eec988 Added Cryo Hop support to the export scripts.
Michiel Broek <mbroek@mbse.eu>
parents: 399
diff changeset
139 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
140 echo PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
141 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
142 echo PHP_EOL . PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
143
357
74d56bed75b9 One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents: 341
diff changeset
144 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
145 echo "------------------------------ --------------- -------------------- -----------" . PHP_EOL;
341
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
146 $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
147 foreach($arr as $item) {
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
148 $amount = floatval($item['m_amount']) * 1000;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
149 $aiw = $item['m_amount_is_weight'];
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
150 $use_use = $item['m_use_use'];
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
151 $time = floatval($item['m_time']);
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 if ($use_use == 2) // Boil
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
154 $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
155 else
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
156 $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
157 $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
158
357
74d56bed75b9 One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents: 341
diff changeset
159 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
160 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
161 echo PHP_EOL . PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
162
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
163 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
164 echo "-------------------- ------------------------------ ------------ ------------ ----------" . PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
165 $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
166 foreach($arr as $item) {
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
167 $name = formatstr($item['y_name'], 30);
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
168 $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
169
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
170 if ($item['y_form'] == 0) // Liquid
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
171 $amount = sprintf("%.0f",floatval($item['y_amount']))." pak";
516
28670364bd0c Added dried yeast form.
Michiel Broek <mbroek@mbse.eu>
parents: 514
diff changeset
172 else if ($item['y_form'] == 1 || $item['y_form'] == 6) // Dry
341
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
173 $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
174 else
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
175 $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
176
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
177 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
178 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
179 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
180 $sv = 0;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
181 for ($i = 1; $i < 5; $i++) {
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
182 $pv = "prop".$i."_volume";
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
183 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
184 $sv = floatval($row[$pv]);
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 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
187 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
188 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
189 echo PHP_EOL . PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
190
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
191 if ($row['w1_name'])
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
192 $mashwater += floatval($row['w1_amount']);
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
193 if ($row['w2_name'])
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
194 $mashwater += floatval($row['w2_amount']);
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 "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
197 echo "-------------------- ---------------------- --------- --------- ---------" . PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
198 $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
199 foreach($arr as $item) {
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
200
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
201 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
202 $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
203 } 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
204 $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
205 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
206 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
207 formatstr($item['step_name'], 20), $stype, sprintf("%6.1f &deg;C", $item['step_temp']),
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
208 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
209 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
210 echo PHP_EOL;
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
211 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
212 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
213 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
214 } else {
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
215 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
216 }
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
217 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
218 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
219 itemline("Spoelwater temperatuur", $row['sparge_temp'].' &deg;C');
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
220 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
221 echo PHP_EOL . PHP_EOL;
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 ?>
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
225 </pre>
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
226 </body>
9c4bc199be9e Added product forum export and changed the export menu.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
227 </html>

mercurial