www/prod_forum.php

Thu, 17 Oct 2019 16:09:53 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Thu, 17 Oct 2019 16:09:53 +0200
changeset 516
28670364bd0c
parent 514
3c680d1dea35
child 537
9dbce45f39b7
child 539
fe9ac6d49c4f
permissions
-rw-r--r--

Added dried yeast form.

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']);
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";
516
28670364bd0c Added dried yeast form.
Michiel Broek <mbroek@mbse.eu>
parents: 514
diff changeset
171 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
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 &deg;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'].' &deg;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>

mercurial