Fri, 18 Oct 2019 19:24:05 +0200
Code cleanup and manual compress.
165 | 1 | <?php |
2 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); | |
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:
460
diff
changeset
|
4 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/constants.php'); |
165 | 5 | require_once($_SERVER['DOCUMENT_ROOT'].'/fpdf/fpdf.php'); |
6 | ||
7 | ||
8 | $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); | |
9 | if (! $link) { | |
10 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); | |
11 | } | |
12 | if (! mysqli_set_charset($link, "utf8" )) { | |
13 | echo "error"; | |
14 | return 1; | |
15 | } | |
16 | ||
17 | setlocale ( LC_ALL, 'nl_NL.UTF-8'); | |
18 | $record = $_GET["record"]; | |
19 | $result = mysqli_query($link, "SELECT * FROM products WHERE record='".$record."'"); | |
20 | $row = mysqli_fetch_array($result); | |
21 | ||
22 | $total_fermentables = 0.0; | |
23 | $cost_fermentables = 0.0; | |
24 | $total_hops = 0.0; | |
25 | $cost_hops = 0.0; | |
26 | $cost_yeasts = 0.0; | |
27 | $cost_miscs = 0.0; | |
28 | $pSugar = 0; | |
29 | $pCara = 0; | |
30 | $svg = 77; | |
31 | $colorw = 0; | |
32 | $total_ibus = 0; | |
33 | $preboil_sg = 0; | |
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
34 | $mashkg = 0; |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
35 | date_default_timezone_set('Europe/Amsterdam'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
36 | $prdate = date(DATE_RFC2822); |
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
37 | $bottle_sugar = ''; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
38 | $keg_sugar = ''; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
39 | $bottle_sugar_amount = 0; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
40 | $keg_sugar_amount = 0; |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
41 | |
165 | 42 | |
43 | class PDF_MySQL_Table extends FPDF | |
44 | { | |
45 | protected $ProcessingTable=false; | |
46 | protected $aCols=array(); | |
47 | protected $TableX; | |
48 | ||
49 | function Header() { | |
50 | // Print the table header if necessary | |
51 | if ($this->ProcessingTable) | |
52 | $this->TableHeader(); | |
53 | } | |
54 | ||
55 | function TableHeader() { | |
56 | $this->SetFont('Helvetica','B',9); | |
57 | $this->SetX($this->TableX); | |
58 | $this->SetFillColor(255,150,100); | |
59 | foreach($this->aCols as $col) | |
60 | $this->Cell($col['w'],5,$col['c'],0,0,$col['a'],true); | |
61 | $this->Ln(); | |
62 | } | |
63 | ||
64 | function AddCol($width=-1, $caption='', $align='L') { | |
65 | $this->aCols[]=array('c'=>$caption,'w'=>$width,'a'=>$align); | |
66 | } | |
67 | ||
68 | function TableGlobal($row) { | |
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:
460
diff
changeset
|
69 | global $recipetype; |
165 | 70 | /* 2 Columns */ |
71 | $vul = $this->w - $this->rMargin - $this->lMargin - 160; | |
72 | $cMargin=$this->cMargin; | |
73 | $this->cMargin=2; | |
74 | $this->TableX=$this->lMargin; | |
75 | $this->SetFont('Helvetica','B',9); | |
76 | $this->SetX($this->TableX); | |
77 | $this->SetFillColor(255,150,100); | |
78 | $this->Cell(0, 5, 'Recept overzicht',0,0,'C',true); | |
79 | $this->Ln(); | |
80 | ||
81 | $this->SetFont('Helvetica','',9); | |
82 | $this->SetFillColor(210,245,255); | |
83 | ||
84 | $this->SetX($this->TableX); | |
85 | $this->Cell(35,5,'Type',0,0,'L',true); | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
86 | $this->Cell(45,5,$recipetype[$row['type']],0,0,'L',true); |
165 | 87 | $this->Cell($vul,5,'',0,0,'L',false); |
88 | $this->Cell(35,5,'Batch grootte',0,0,'L',true); | |
89 | $this->Cell(45,5,$row['batch_size'].' liter',0,0,'L',true); | |
90 | $this->Ln(); | |
91 | ||
92 | $this->SetX($this->TableX); | |
93 | $this->Cell(35,5,'Kooktijd',0,0,'L',true); | |
94 | $this->Cell(45,5,$row['boil_time'].' minuten',0,0,'L',true); | |
95 | $this->Cell($vul,5,'',0,0,'L',false); | |
96 | $this->Cell(35,5,'Brouwzaal rendement',0,0,'L',true); | |
97 | $this->Cell(45,5,$row['efficiency'].' %',0,0,'L',true); | |
98 | $this->Ln(); | |
99 | ||
100 | $this->SetX($this->TableX); | |
101 | $this->Cell(35,5,'Bierstijl',0,0,'L',true); | |
102 | $this->Cell(45,5,$row['st_name'],0,0,'L',true); | |
103 | $this->Cell($vul,5,'',0,0,'L',false); | |
104 | $this->Cell(35,5,'Installatie',0,0,'L',true); | |
105 | $this->Cell(45,5,$row['eq_name'],0,0,'L',true); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
106 | $this->Ln(); |
165 | 107 | |
108 | $this->cMargin=$cMargin; | |
109 | } | |
110 | ||
111 | function TableFermentables($row) { | |
112 | global $cost_fermentables; | |
113 | global $total_fermentables; | |
114 | global $pSugar; | |
115 | global $pCara; | |
116 | global $colorw; | |
117 | global $preboil_sg; | |
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
118 | global $mashkg; |
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
119 | global $bottle_sugar; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
120 | global $bottle_sugar_amount; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
121 | global $keg_sugar; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
122 | global $keg_sugar_amount; |
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:
460
diff
changeset
|
123 | global $added; |
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:
460
diff
changeset
|
124 | global $fermentabletype; |
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:
460
diff
changeset
|
125 | global $graintype; |
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:
391
diff
changeset
|
126 | $vul = $this->w - $this->rMargin - $this->lMargin - 125; |
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:
391
diff
changeset
|
127 | $this->Ln(); |
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:
391
diff
changeset
|
128 | $this->AddCol($vul,'Mout, granen en suikers','L'); |
165 | 129 | $this->AddCol(15,'Procent','R'); |
130 | $this->AddCol(15,'Opbr.','R'); | |
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:
391
diff
changeset
|
131 | $this->AddCol(25,'Soort', 'L'); |
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:
391
diff
changeset
|
132 | $this->AddCol(30,'Gebruik moment','L'); |
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:
391
diff
changeset
|
133 | $this->AddCol(20,'Hoeveel','R'); |
165 | 134 | $this->AddCol(20,'Prijs','R'); |
135 | ||
136 | $cMargin=$this->cMargin; | |
137 | $this->cMargin=2; | |
138 | $this->TableX=$this->lMargin; | |
139 | $this->TableHeader(); | |
140 | $this->ProcessingTable=true; | |
141 | ||
142 | $sugarsf = 0; | |
143 | $sugarsm = 0; | |
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
144 | $mashkg = 0; |
165 | 145 | $this->SetFont('Helvetica','',9); |
146 | $this->SetFillColor(250, 195, 65); | |
147 | $arr = json_decode($row['json_fermentables'], true); | |
148 | foreach($arr as $item) { //foreach element in $arr | |
149 | $name = iconv('UTF-8','windows-1252',$item['f_name']); | |
150 | $supplier = iconv('UTF-8','windows-1252',$item['f_supplier']); | |
151 | $amount = floatval($item['f_amount']); | |
152 | $costkg = floatval($item['f_cost']); | |
153 | $yield = floatval($item['f_yield']); | |
154 | $moisture = floatval($item['f_moisture']); | |
155 | $color = floatval($item['f_color']); | |
156 | $percent = floatval($item['f_percentage']); | |
157 | ||
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
158 | if ($item['f_type'] == 1) // Sugar |
165 | 159 | $pSugar += $percent; |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
160 | if ($item['f_graintype'] == 2) // Crystal |
165 | 161 | $pCara += $percent; |
162 | ||
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:
391
diff
changeset
|
163 | if ($item['f_type'] == 0) |
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:
460
diff
changeset
|
164 | $soort = iconv('UTF-8','windows-1252',$graintype[$item['f_graintype']]); |
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:
391
diff
changeset
|
165 | 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:
460
diff
changeset
|
166 | $soort = iconv('UTF-8','windows-1252',$fermentabletype[$item['f_type']]); |
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:
391
diff
changeset
|
167 | |
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
168 | if ($item['f_added'] == 4) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
169 | $bottle_sugar = $name; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
170 | $bottle_sugar_amount = $amount; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
171 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
172 | if ($item['f_added'] == 5) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
173 | $keg_sugar = $name; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
174 | $keg_sugar_amount = $amount; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
175 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
176 | |
165 | 177 | $cost = $amount * $costkg; |
178 | $cost_fermentables += $cost; | |
179 | $total_fermentables += $amount; | |
180 | /* Calculate the amount of sugars */ | |
181 | $d = $amount * ($yield / 100) * (1 - $moisture / 100); | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
182 | if ($item['f_added'] == 0) { |
165 | 183 | $d = floatval($row['efficiency']) / 100 * $d; |
184 | $sugarsm += $d; | |
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
185 | $mashkg += $amount; |
165 | 186 | } |
187 | $sugarsf += $d; | |
188 | $colorw += ($amount * ebc_to_srm($color) / $row['batch_size']) * 8.34436; | |
189 | ||
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:
391
diff
changeset
|
190 | if ($amount > 100) |
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:
391
diff
changeset
|
191 | $amount = sprintf("%.1f",$amount).' kg'; |
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:
391
diff
changeset
|
192 | else if ($amount > 10) |
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:
391
diff
changeset
|
193 | $amount = sprintf("%.2f",$amount).' kg'; |
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:
391
diff
changeset
|
194 | else |
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:
391
diff
changeset
|
195 | $amount = sprintf("%.0f",$amount * 1000).' gr'; |
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:
391
diff
changeset
|
196 | $this->Cell($vul,5,$name.' ('.$supplier.') '.sprintf("%.0f",$color).' EBC',0,0,'L',true); |
165 | 197 | $this->Cell(15,5,sprintf("%.1f%%",$percent),0,0,'R',true); |
198 | $this->Cell(15,5,sprintf("%.1f%%",$yield),0,0,'R',true); | |
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:
391
diff
changeset
|
199 | $this->Cell(25,5,$soort,0,0,'L',true); |
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:
391
diff
changeset
|
200 | $this->Cell(30,5,$added[$item['f_added']],0,0,'L',true); |
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:
391
diff
changeset
|
201 | $this->Cell(20,5,$amount,0,0,'R',true); |
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:
391
diff
changeset
|
202 | $this->Cell(20,5,sprintf("%.3f",$cost).EURO,0,0,'R',true); |
165 | 203 | $this->Ln(); |
204 | } | |
205 | ||
206 | $row['est_og'] = estimate_sg($sugarsf, floatval($row['batch_size'])); | |
207 | $preboil_sg = estimate_sg($sugarsm, floatval($row['boil_size'])); | |
208 | $this->SetFillColor(210,245,255); | |
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:
391
diff
changeset
|
209 | $this->Cell($vul+105,5,'',0,0,'L',false); |
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:
391
diff
changeset
|
210 | $this->Cell(20,5,sprintf("%.3f",$cost_fermentables).EURO,0,0,'R',true); |
165 | 211 | $this->ProcessingTable=false; |
212 | $this->cMargin=$cMargin; | |
213 | $this->aCols=array(); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
214 | $this->Ln(); |
165 | 215 | } |
216 | ||
217 | function TableHops($row) { | |
218 | global $total_hops; | |
219 | global $total_ibus; | |
220 | global $cost_hops; | |
221 | global $preboil_sg; | |
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:
460
diff
changeset
|
222 | global $hopform; |
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:
460
diff
changeset
|
223 | global $hopuse; |
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:
391
diff
changeset
|
224 | $vul = $this->w - $this->rMargin - $this->lMargin - 122; |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
225 | $this->Ln(); |
165 | 226 | $this->AddCol($vul,'Hop','L'); |
227 | $this->AddCol(15,'Alpha','R'); | |
228 | $this->AddCol(12,'IBU','R'); | |
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:
391
diff
changeset
|
229 | $this->AddCol(25,'Soort','L'); |
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:
391
diff
changeset
|
230 | $this->AddCol(30,'Gebruik moment','L'); |
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:
391
diff
changeset
|
231 | $this->AddCol(20,'Hoeveel','R'); |
165 | 232 | $this->AddCol(20,'Prijs','R'); |
233 | ||
234 | $cMargin=$this->cMargin; | |
235 | $this->cMargin=2; | |
236 | $this->TableX=$this->lMargin; | |
237 | $this->TableHeader(); | |
238 | $this->ProcessingTable=true; | |
239 | ||
240 | $this->SetFont('Helvetica','',9); | |
241 | $this->SetFillColor(100, 250, 65); | |
242 | ||
243 | $arr = json_decode($row['json_hops'], true); | |
244 | foreach($arr as $item) { //foreach element in $arr | |
245 | $name = iconv('UTF-8','windows-1252',$item['h_name']); | |
246 | $origin = iconv('UTF-8','windows-1252',$item['h_origin']); | |
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:
391
diff
changeset
|
247 | $amount = floatval($item['h_amount']); |
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:
391
diff
changeset
|
248 | $mass = $amount * 1000; |
165 | 249 | $costkg = floatval($item['h_cost']); |
250 | $time = floatval($item['h_time']); | |
251 | $alpha = floatval($item['h_alpha']); | |
252 | ||
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:
391
diff
changeset
|
253 | $cost = ($amount * $costkg); |
165 | 254 | $cost_hops += $cost; |
255 | $total_hops += $amount; | |
256 | ||
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
257 | $moment = $hopuse[$item['h_useat']]; |
396
804800d8e885
Added console logging in the grid write callback functions. Removed grid sorting, it is done on the server side. Alert popup for block row edit functions. Better grid live updates. In recipe and product print show the whirlpool time. The checklist now shows misc ingredients added in the mash. Show hops added in the whirlpool. Most ingredient names are now quoted.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
258 | if (($item['h_useat'] == 2) || ($item['h_useat'] == 4)) { // Boil or Whirlpool |
804800d8e885
Added console logging in the grid write callback functions. Removed grid sorting, it is done on the server side. Alert popup for block row edit functions. Better grid live updates. In recipe and product print show the whirlpool time. The checklist now shows misc ingredients added in the mash. Show hops added in the whirlpool. Most ingredient names are now quoted.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
259 | $moment = $hopuse[$item['h_useat']].' '.$time." min"; |
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:
391
diff
changeset
|
260 | } else if ($item['h_useat'] == 5) { // Dryhop |
396
804800d8e885
Added console logging in the grid write callback functions. Removed grid sorting, it is done on the server side. Alert popup for block row edit functions. Better grid live updates. In recipe and product print show the whirlpool time. The checklist now shows misc ingredients added in the mash. Show hops added in the whirlpool. Most ingredient names are now quoted.
Michiel Broek <mbroek@mbse.eu>
parents:
392
diff
changeset
|
261 | $moment = $hopuse[$item['h_useat']].' '.sprintf("%.0f", $time / 1440).' dagen'; |
165 | 262 | } |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
263 | $ibu = calc_IBU($item['h_useat'], $item['h_form'], $preboil_sg, floatval($row['batch_size']), $mass, $time, $alpha, $row['ibu_method']); |
165 | 264 | $total_ibus += $ibu; |
265 | ||
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:
391
diff
changeset
|
266 | if ($amount > 1) |
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:
391
diff
changeset
|
267 | $amount = sprintf("%.3f",$amount).' kg'; |
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:
391
diff
changeset
|
268 | else |
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:
391
diff
changeset
|
269 | $amount = sprintf("%.1f",$amount * 1000).' gr'; |
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:
391
diff
changeset
|
270 | |
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:
391
diff
changeset
|
271 | $this->Cell($vul,5,$name.' ('.$origin.')',0,0,'L',true); |
165 | 272 | $this->Cell(15,5,sprintf("%.1f%%",$alpha),0,0,'R',true); |
273 | $this->Cell(12,5,sprintf("%.1f",$ibu),0,0,'R',true); | |
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:
391
diff
changeset
|
274 | $this->Cell(25,5,$hopform[$item['h_form']],0,0,'L',true); |
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:
391
diff
changeset
|
275 | $this->Cell(30,5,$moment,0,0,'L',true); |
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:
391
diff
changeset
|
276 | $this->Cell(20,5,$amount,0,0,'R',true); |
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:
391
diff
changeset
|
277 | $this->Cell(20,5,sprintf("%.3f",$cost).EURO,0,0,'R',true); |
165 | 278 | $this->Ln(); |
279 | } | |
280 | ||
281 | $this->SetFillColor(210,245,255); | |
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:
391
diff
changeset
|
282 | $this->Cell($vul+102,5,'',0,0,'L',false); |
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:
391
diff
changeset
|
283 | $this->Cell(20,5,sprintf("%.3f",$cost_hops).EURO,0,0,'R',true); |
165 | 284 | $this->ProcessingTable=false; |
285 | $this->cMargin=$cMargin; | |
286 | $this->aCols=array(); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
287 | $this->Ln(); |
165 | 288 | } |
289 | ||
290 | function TableYeasts($row) { | |
291 | global $cost_yeasts; | |
292 | global $svg; | |
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:
460
diff
changeset
|
293 | global $yeastform; |
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:
460
diff
changeset
|
294 | global $yeastuse; |
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:
391
diff
changeset
|
295 | $vul = $this->w - $this->rMargin - $this->lMargin - 110; |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
296 | $this->Ln(); |
165 | 297 | $this->AddCol($vul,'Gist','L'); |
298 | $this->AddCol(15,'Attn','R'); | |
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:
391
diff
changeset
|
299 | $this->AddCol(25,'Soort','L'); |
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:
391
diff
changeset
|
300 | $this->AddCol(30,'Gebruik moment','L'); |
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:
391
diff
changeset
|
301 | $this->AddCol(20,'Hoeveel','R'); |
165 | 302 | $this->AddCol(20,'Prijs','R'); |
303 | ||
304 | $cMargin=$this->cMargin; | |
305 | $this->cMargin=2; | |
306 | $this->TableX=$this->lMargin; | |
307 | $this->TableHeader(); | |
308 | $this->ProcessingTable=true; | |
309 | ||
310 | $this->SetFont('Helvetica','',9); | |
311 | $this->SetFillColor(175, 175, 255); | |
312 | ||
313 | $arr = json_decode($row['json_yeasts'], true); | |
314 | foreach($arr as $item) { //foreach element in $arr | |
315 | $name = iconv('UTF-8','windows-1252',$item['y_name']); | |
316 | $laboratory = iconv('UTF-8','windows-1252',$item['y_laboratory']); | |
317 | $product_id = iconv('UTF-8','windows-1252',$item['y_product_id']); | |
318 | $attenuation = floatval($item['y_attenuation']); | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
319 | $cost = floatval($item['y_amount']) * floatval($item['y_cost']); |
165 | 320 | $cost_yeasts += $cost; |
321 | ||
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
322 | if ($item['y_use'] == 0) // Primary |
165 | 323 | $svg = $attenuation; |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
324 | if ($item['y_form'] == 0) // Liquid |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
325 | $amount = sprintf("%.0f",floatval($item['y_amount']))." pak"; |
516 | 326 | else if ($item['y_form'] == 1 || $item['y_form'] == 6) // Dry |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
327 | $amount = sprintf("%.1f",floatval($item['y_amount'])*1000)." gr"; |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
328 | else |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
329 | $amount = sprintf("%.0f",floatval($item['y_amount'])*1000)." ml"; |
165 | 330 | |
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:
391
diff
changeset
|
331 | $this->Cell($vul,5,$laboratory.' '.$product_id.' ('.$name.')',0,0,'L',true); |
165 | 332 | $this->Cell(15,5,sprintf("%.1f%%",$attenuation),0,0,'R',true); |
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:
391
diff
changeset
|
333 | $this->Cell(25,5,$yeastform[$item['y_form']],0,0,'L',true); |
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:
391
diff
changeset
|
334 | $this->Cell(30,5,$yeastuse[$item['y_use']],0,0,'L',true); |
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:
391
diff
changeset
|
335 | $this->Cell(20,5,$amount,0,0,'R',true); |
165 | 336 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); |
337 | $this->Ln(); | |
338 | } | |
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:
391
diff
changeset
|
339 | if ($row['starter_enable'] && $row['prop1_volume']) { |
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:
391
diff
changeset
|
340 | $sv = 0; |
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:
391
diff
changeset
|
341 | $st = 0; |
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:
391
diff
changeset
|
342 | for ($i = 1; $i < 5; $i++) { |
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:
391
diff
changeset
|
343 | $pv = "prop".$i."_volume"; |
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:
391
diff
changeset
|
344 | if (floatval($row[$pv])) { |
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:
391
diff
changeset
|
345 | $st++; |
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:
391
diff
changeset
|
346 | if (floatval($row[$pv]) > $sv) |
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:
391
diff
changeset
|
347 | $sv = floatval($row[$pv]); |
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:
391
diff
changeset
|
348 | } |
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:
391
diff
changeset
|
349 | } |
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:
391
diff
changeset
|
350 | $this->Cell($vul,5,$st." staps giststarter",0,0,'L',true); |
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:
391
diff
changeset
|
351 | $this->Cell(40,5,'',0,0,'R',true); |
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:
391
diff
changeset
|
352 | $this->Cell(30,5,"Vooraf",0,0,'L',true); |
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:
391
diff
changeset
|
353 | $this->Cell(20,5,sprintf("%.2f",$sv)." L",0,0,'R',true); |
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:
391
diff
changeset
|
354 | $this->Cell(20,5,'',0,0,'R',true); |
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:
391
diff
changeset
|
355 | $this->Ln(); |
293
db898ec73277
Show yeast starter on printed page
Michiel Broek <mbroek@mbse.eu>
parents:
289
diff
changeset
|
356 | } |
165 | 357 | |
358 | $this->SetFillColor(210,245,255); | |
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:
391
diff
changeset
|
359 | $this->Cell($vul+90,5,'',0,0,'L',false); |
165 | 360 | $this->Cell(20,5,sprintf("%8.3f",$cost_yeasts).EURO,0,0,'R',true); |
361 | $this->ProcessingTable=false; | |
362 | $this->cMargin=$cMargin; | |
363 | $this->aCols=array(); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
364 | $this->Ln(); |
165 | 365 | } |
366 | ||
367 | function TableMiscs($row) { | |
368 | global $cost_miscs; | |
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:
460
diff
changeset
|
369 | global $misctype; |
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:
460
diff
changeset
|
370 | global $miscuse; |
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:
391
diff
changeset
|
371 | $vul = $this->w - $this->rMargin - $this->lMargin - 95; |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
372 | if ($this->GetY() > 200) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
373 | $this->AddPage(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
374 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
375 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
376 | $this->AddCol($vul,'Diversen naam','L'); |
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:
391
diff
changeset
|
377 | $this->AddCol(25,'Soort','L'); |
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:
391
diff
changeset
|
378 | $this->AddCol(30,'Gebruik moment','L'); |
165 | 379 | $this->AddCol(20,'Hoeveel','R'); |
380 | $this->AddCol(20,'Prijs','R'); | |
381 | ||
382 | $cMargin=$this->cMargin; | |
383 | $this->cMargin=2; | |
384 | $this->TableX=$this->lMargin; | |
385 | $this->TableHeader(); | |
386 | $this->ProcessingTable=true; | |
387 | ||
388 | $this->SetFont('Helvetica','',9); | |
389 | $this->SetFillColor(175, 175, 255); | |
390 | ||
391 | $arr = json_decode($row['json_miscs'], true); | |
392 | foreach($arr as $item) { | |
393 | $name = iconv('UTF-8','windows-1252',$item['m_name']); | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
394 | $type = $item['m_type']; |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
395 | $use_use = $item['m_use_use']; |
165 | 396 | $amount = floatval($item['m_amount']) * 1000; |
397 | $costg = floatval($item['m_cost']) / 1000; | |
398 | $time = floatval($item['m_time']); | |
399 | $aiw = $item['m_amount_is_weight']; | |
400 | $cost = $amount * $costg; | |
401 | $cost_miscs += $cost; | |
402 | ||
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
403 | if ($type == 4) // Water agent |
165 | 404 | $this->SetFillColor(240,140,130); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
405 | else if ($type == 3) // Fining |
165 | 406 | $this->SetFillColor(95,180,25); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
407 | else if (($type == 0) || ($type == 1) || ($type == 2) || ($type == 5)) // Spice, Herb, Flavour, Yeast nutrient |
165 | 408 | $this->SetFillColor(240,250,65); |
409 | else | |
410 | $this->SetFillColor(210,245,255); | |
411 | ||
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
412 | if ($use_use == 2) // Boil |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
413 | $gebruik = sprintf("%s %d min",$miscuse[$use_use],$time); |
165 | 414 | else |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
415 | $gebruik = $miscuse[$use_use]; |
165 | 416 | |
357
74d56bed75b9
One more decimal digit for misc ingredients. Updated the README.
Michiel Broek <mbroek@mbse.eu>
parents:
338
diff
changeset
|
417 | $hoeveel = sprintf("%.2f %s",$amount,$aiw ? "gr":"ml"); |
165 | 418 | $this->Cell($vul,5,$name,0,0,'L',true); |
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:
391
diff
changeset
|
419 | $this->Cell(25,5,$misctype[$type],0,0,'L',true); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
420 | $this->Cell(30,5,$gebruik,0,0,'L',true); |
165 | 421 | $this->Cell(20,5,$hoeveel,0,0,'R',true); |
422 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); | |
423 | $this->Ln(); | |
424 | } | |
425 | ||
426 | $this->SetFillColor(210,245,255); | |
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:
391
diff
changeset
|
427 | $this->Cell($vul+75,5,'',0,0,'L',false); |
165 | 428 | $this->Cell(20,5,sprintf("%8.3f",$cost_miscs).EURO,0,0,'R',true); |
429 | ||
430 | $this->ProcessingTable=false; | |
431 | $this->cMargin=$cMargin; | |
432 | $this->aCols=array(); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
433 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
434 | } |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
435 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
436 | function TableMashs($row) { |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
437 | global $cost_yeasts; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
438 | global $svg; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
439 | global $mashkg; |
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:
460
diff
changeset
|
440 | global $mashtype; |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
441 | $vul = $this->w - $this->rMargin - $this->lMargin - 137; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
442 | if ($this->GetY() > 250) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
443 | $this->AddPage(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
444 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
445 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
446 | $this->AddCol($vul,'Maisch stap naam','L'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
447 | $this->AddCol(25,'Stap type','L'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
448 | $this->AddCol(18,'Start '.DEG.'C','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
449 | $this->AddCol(18,'Eind '.DEG.'C','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
450 | $this->AddCol(18,'Rust min','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
451 | $this->AddCol(18,'Stap min','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
452 | $this->AddCol(20,'L/Kg','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
453 | $this->AddCol(20,'Infusie L','R'); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
454 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
455 | $cMargin=$this->cMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
456 | $this->cMargin=2; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
457 | $this->TableX=$this->lMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
458 | $this->TableHeader(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
459 | $this->ProcessingTable=true; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
460 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
461 | $this->SetFont('Helvetica','',9); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
462 | $this->SetFillColor(175, 175, 255); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
463 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
464 | $vol = 0; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
465 | $arr = json_decode($row['json_mashs'], true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
466 | foreach($arr as $item) { //foreach element in $arr |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
467 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
468 | if ($item['step_type'] == 0) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
469 | $vol += $item['step_infuse_amount']; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
470 | if ($mashkg > 0) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
471 | $thick = $vol / $mashkg; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
472 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
473 | $thick = 0; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
474 | $this->Cell($vul,5,$item['step_name'],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
475 | $this->Cell(25,5,$mashtype[$item['step_type']],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
476 | $this->Cell(18,5,sprintf("%.1f",$item['step_temp']),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
477 | $this->Cell(18,5,sprintf("%.1f",$item['end_temp']),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
478 | $this->Cell(18,5,sprintf("%.0f",$item['step_time']),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
479 | $this->Cell(18,5,sprintf("%.0f",$item['ramp_time']),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
480 | $this->Cell(20,5,sprintf("%.2f",$thick),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
481 | $this->Cell(20,5,sprintf("%.1f",$item['step_infuse_amount']),0,0,'R',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
482 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
483 | } |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
484 | $this->ProcessingTable=false; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
485 | $this->cMargin=$cMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
486 | $this->aCols=array(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
487 | $this->Ln(); |
165 | 488 | } |
489 | ||
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:
391
diff
changeset
|
490 | function TableWaters($row) { |
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:
391
diff
changeset
|
491 | |
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:
391
diff
changeset
|
492 | $vul = $this->w - $this->rMargin - $this->lMargin - 137; |
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:
391
diff
changeset
|
493 | if ($this->GetY() > 250) |
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:
391
diff
changeset
|
494 | $this->AddPage(); |
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:
391
diff
changeset
|
495 | else |
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:
391
diff
changeset
|
496 | $this->Ln(); |
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:
391
diff
changeset
|
497 | $this->AddCol($vul,'Water bron','L'); |
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:
391
diff
changeset
|
498 | $this->AddCol(20,'Volume','R'); |
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:
391
diff
changeset
|
499 | $this->AddCol(15,'Ca','R'); |
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:
391
diff
changeset
|
500 | $this->AddCol(15,'Mg','R'); |
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:
391
diff
changeset
|
501 | $this->AddCol(15,'Na','R'); |
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:
391
diff
changeset
|
502 | $this->AddCol(15,'CaCO3','R'); |
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:
391
diff
changeset
|
503 | $this->AddCol(15,'Cl','R'); |
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:
391
diff
changeset
|
504 | $this->AddCol(15,'SO4','R'); |
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:
391
diff
changeset
|
505 | $this->AddCol(15,'pH','R'); |
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:
391
diff
changeset
|
506 | |
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:
391
diff
changeset
|
507 | $cMargin=$this->cMargin; |
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:
391
diff
changeset
|
508 | $this->cMargin=2; |
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:
391
diff
changeset
|
509 | $this->TableX=$this->lMargin; |
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:
391
diff
changeset
|
510 | $this->TableHeader(); |
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:
391
diff
changeset
|
511 | $this->ProcessingTable=true; |
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:
391
diff
changeset
|
512 | |
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:
391
diff
changeset
|
513 | $this->SetFont('Helvetica','',9); |
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:
391
diff
changeset
|
514 | $this->SetFillColor(120, 255, 250); |
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:
391
diff
changeset
|
515 | |
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:
391
diff
changeset
|
516 | $this->Cell($vul,5,$row['w1_name'],0,0,'L',true); |
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:
391
diff
changeset
|
517 | $this->Cell(20,5,sprintf("%.1f", $row['w1_amount']).' L',0,0,'R',true); |
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:
391
diff
changeset
|
518 | $this->Cell(15,5,sprintf("%.1f", $row['w1_calcium']),0,0,'R',true); |
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:
391
diff
changeset
|
519 | $this->Cell(15,5,sprintf("%.1f", $row['w1_magnesium']),0,0,'R',true); |
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:
391
diff
changeset
|
520 | $this->Cell(15,5,sprintf("%.1f", $row['w1_sodium']),0,0,'R',true); |
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:
391
diff
changeset
|
521 | $this->Cell(15,5,sprintf("%.1f", $row['w1_total_alkalinity']),0,0,'R',true); |
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:
391
diff
changeset
|
522 | $this->Cell(15,5,sprintf("%.1f", $row['w1_chloride']),0,0,'R',true); |
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:
391
diff
changeset
|
523 | $this->Cell(15,5,sprintf("%.1f", $row['w1_sulfate']),0,0,'R',true); |
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:
391
diff
changeset
|
524 | $this->Cell(15,5,sprintf("%.1f", $row['w1_ph']),0,0,'R',true); |
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:
391
diff
changeset
|
525 | $this->Ln(); |
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:
391
diff
changeset
|
526 | $this->Cell($vul,5,$row['w2_name'],0,0,'L',true); |
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:
391
diff
changeset
|
527 | $this->Cell(20,5,sprintf("%.1f", $row['w2_amount']).' L',0,0,'R',true); |
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:
391
diff
changeset
|
528 | $this->Cell(15,5,sprintf("%.1f", $row['w2_calcium']),0,0,'R',true); |
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:
391
diff
changeset
|
529 | $this->Cell(15,5,sprintf("%.1f", $row['w2_magnesium']),0,0,'R',true); |
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:
391
diff
changeset
|
530 | $this->Cell(15,5,sprintf("%.1f", $row['w2_sodium']),0,0,'R',true); |
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:
391
diff
changeset
|
531 | $this->Cell(15,5,sprintf("%.1f", $row['w2_total_alkalinity']),0,0,'R',true); |
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:
391
diff
changeset
|
532 | $this->Cell(15,5,sprintf("%.1f", $row['w2_chloride']),0,0,'R',true); |
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:
391
diff
changeset
|
533 | $this->Cell(15,5,sprintf("%.1f", $row['w2_sulfate']),0,0,'R',true); |
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:
391
diff
changeset
|
534 | $this->Cell(15,5,sprintf("%.1f", $row['w2_ph']),0,0,'R',true); |
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:
391
diff
changeset
|
535 | $this->Ln(); |
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:
391
diff
changeset
|
536 | $this->Cell($vul,5,'Gemengd water',0,0,'L',true); |
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:
391
diff
changeset
|
537 | $this->Cell(20,5,sprintf("%.1f", $row['wg_amount']).' L',0,0,'R',true); |
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:
391
diff
changeset
|
538 | $this->Cell(15,5,sprintf("%.1f", $row['wg_calcium']),0,0,'R',true); |
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:
391
diff
changeset
|
539 | $this->Cell(15,5,sprintf("%.1f", $row['wg_magnesium']),0,0,'R',true); |
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:
391
diff
changeset
|
540 | $this->Cell(15,5,sprintf("%.1f", $row['wg_sodium']),0,0,'R',true); |
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:
391
diff
changeset
|
541 | $this->Cell(15,5,sprintf("%.1f", $row['wg_total_alkalinity']),0,0,'R',true); |
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:
391
diff
changeset
|
542 | $this->Cell(15,5,sprintf("%.1f", $row['wg_chloride']),0,0,'R',true); |
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:
391
diff
changeset
|
543 | $this->Cell(15,5,sprintf("%.1f", $row['wg_sulfate']),0,0,'R',true); |
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:
391
diff
changeset
|
544 | $this->Cell(15,5,sprintf("%.1f", $row['wg_ph']),0,0,'R',true); |
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:
391
diff
changeset
|
545 | $this->Ln(); |
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:
391
diff
changeset
|
546 | $this->Cell($vul,5,'Behandeld water',0,0,'L',true); |
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:
391
diff
changeset
|
547 | $this->Cell(20,5,'',0,0,'R',true); |
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:
391
diff
changeset
|
548 | $this->Cell(15,5,sprintf("%.1f", $row['wb_calcium']),0,0,'R',true); |
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:
391
diff
changeset
|
549 | $this->Cell(15,5,sprintf("%.1f", $row['wb_magnesium']),0,0,'R',true); |
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:
391
diff
changeset
|
550 | $this->Cell(15,5,sprintf("%.1f", $row['wb_sodium']),0,0,'R',true); |
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:
391
diff
changeset
|
551 | $this->Cell(15,5,sprintf("%.1f", $row['wb_total_alkalinity']),0,0,'R',true); |
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:
391
diff
changeset
|
552 | $this->Cell(15,5,sprintf("%.1f", $row['wb_chloride']),0,0,'R',true); |
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:
391
diff
changeset
|
553 | $this->Cell(15,5,sprintf("%.1f", $row['wb_sulfate']),0,0,'R',true); |
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:
391
diff
changeset
|
554 | $this->Cell(15,5,sprintf("%.1f", $row['wb_ph']),0,0,'R',true); |
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:
391
diff
changeset
|
555 | $this->ProcessingTable=false; |
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:
391
diff
changeset
|
556 | $this->cMargin=$cMargin; |
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:
391
diff
changeset
|
557 | $this->aCols=array(); |
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:
391
diff
changeset
|
558 | $this->Ln(); |
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:
391
diff
changeset
|
559 | } |
165 | 560 | |
561 | function TableSummary($row) { | |
562 | global $pSugar; | |
563 | global $pCara; | |
564 | global $svg; | |
565 | global $colorw; | |
566 | global $cost_fermentables; | |
567 | global $cost_hops; | |
568 | global $cost_miscs; | |
569 | global $cost_yeasts; | |
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
570 | global $mashkg; |
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:
460
diff
changeset
|
571 | global $colormethod; |
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:
460
diff
changeset
|
572 | global $ibumethod; |
165 | 573 | /* 2 Columns */ |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
574 | if ($this->GetY() > 200) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
575 | $this->AddPage(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
576 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
577 | $this->Ln(); |
165 | 578 | $vul = $this->w - $this->rMargin - $this->lMargin - 170; |
579 | $cMargin=$this->cMargin; | |
580 | $this->cMargin=2; | |
581 | $this->TableX=$this->lMargin; | |
582 | $this->SetFont('Helvetica','B',9); | |
583 | $this->SetX($this->TableX); | |
584 | $this->SetFillColor(255,150,100); | |
585 | $this->Cell(0, 5, 'Recept samenvatting',0,0,'C',true); | |
586 | $this->Ln(); | |
587 | ||
588 | $this->SetFont('Helvetica','',9); | |
589 | $this->SetFillColor(210,245,255); | |
590 | ||
275
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
591 | $mashtime = 0; |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
592 | $mashtemp = 0; |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
593 | $mash_infuse = 0; |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
594 | $arr = json_decode($row['json_mashs'], true); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
595 | foreach($arr as $item) { |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
596 | if ($item['step_type'] == 0) { // infusion |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
597 | $mash_infuse += floatval($item['step_infuse_amount']); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
598 | } |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
599 | if ($item['step_temp'] < 75) { // ignore mashout temps |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
600 | $mashtime += floatval($item['step_time']); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
601 | $mashtemp += floatval($item['step_time']) * floatval($item['step_temp']); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
602 | } |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
603 | } |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
604 | $mashtemp = $mashtemp / $mashtime; |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
605 | if (($mashkg > 0) && ($mash_infuse > 0) && ($mashtime > 0) && ($mashtemp > 0)) { |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
606 | $row['est_fg'] = estimate_fg($pSugar, $pCara, $mash_infuse / $mashkg, $mashtime, $mashtemp, $svg, $row['est_og']); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
607 | } else { |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
608 | $row['est_fg'] = estimate_fg($pSugar, $pCara, 0, 0, 0, $svg, $row['est_og']); |
fb1e88f1c643
Better fg estimation in product print.
Michiel Broek <mbroek@mbse.eu>
parents:
247
diff
changeset
|
609 | } |
165 | 610 | |
611 | $this->SetX($this->TableX); | |
612 | $this->Cell(35,5,'Start SG',0,0,'L',true); | |
613 | $this->Cell(25,5,sprintf("%.3f",$row['est_og']),0,0,'L',true); | |
614 | $this->Cell(25,5,'('.sprintf("%.3f",$row['st_og_min']).' - '.sprintf("%.3f",$row['st_og_max']).')',0,0,'L',true); | |
615 | $this->Cell($vul,5,'',0,0,'L',false); | |
616 | $this->Cell(35,5,'Eind SG',0,0,'L',true); | |
617 | $this->Cell(25,5,sprintf("%.3f",$row['est_fg']),0,0,'L',true); | |
618 | $this->Cell(25,5,'('.sprintf("%.3f",$row['st_fg_min']).' - '.sprintf("%.3f",$row['st_fg_max']).')',0,0,'L',true); | |
619 | $this->Ln(); | |
620 | ||
621 | $row['est_abv'] = abvol($row['est_og'], $row['est_fg']); | |
622 | $this->SetX($this->TableX); | |
623 | $this->Cell(35,5,'Geschat alcohol',0,0,'L',true); | |
624 | $this->Cell(25,5,sprintf("%.1f",$row['est_abv']).'%',0,0,'L',true); | |
625 | $this->Cell(25,5,'('.sprintf("%.1f",$row['st_abv_min']).' - '.sprintf("%.1f",$row['st_abv_max']).'%)',0,0,'L',true); | |
626 | $this->Cell($vul,5,'',0,0,'L',false); | |
627 | $this->Cell(35,5,'CO2',0,0,'L',true); | |
628 | $this->Cell(25,5,sprintf("%.1f",$row['est_carb']).'%',0,0,'L',true); | |
629 | $this->Cell(25,5,'('.sprintf("%.1f",$row['st_carb_min']).' - '.sprintf("%.1f",$row['st_carb_max']).'%)',0,0,'L',true); | |
630 | $this->Ln(); | |
631 | ||
632 | $row['est_color'] = kw_to_ebc($row['color_method'], $colorw); | |
633 | $this->SetX($this->TableX); | |
338
a51b858aacca
Fixed color and IBU method display in recipe and product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
319
diff
changeset
|
634 | $this->Cell(35,5,'Kleur ('.$colormethod[$row['color_method']].')',0,0,'L',true); |
165 | 635 | $beercolor = ebc_to_color($row['est_color']); |
636 | if ($row['est_color'] > 30) | |
637 | $this->SetTextColor(250); | |
638 | $this->SetFillColor($beercolor[0],$beercolor[1],$beercolor[2]); | |
639 | $this->Cell(25,5,$row['est_color'].' EBC',0,0,'L',true); | |
640 | $this->Cell(25,5,'('.$row['st_color_min'].' - '.$row['st_color_max'].' EBC)',0,0,'L',true); | |
641 | $this->SetTextColor(0); | |
642 | $this->SetFillColor(210,245,255); | |
643 | $this->Cell($vul,5,'',0,0,'L',false); | |
338
a51b858aacca
Fixed color and IBU method display in recipe and product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
319
diff
changeset
|
644 | $this->Cell(35,5,'Bitterheid ('.$ibumethod[$row['ibu_method']].')',0,0,'L',true); |
165 | 645 | $this->Cell(25,5,sprintf("%.0f",$row['est_ibu']).' IBU',0,0,'L',true); |
646 | $this->Cell(25,5,'('.$row['st_ibu_min'].' - '.$row['st_ibu_max'].' IBU)',0,0,'L',true); | |
647 | $this->Ln(); | |
648 | ||
649 | $this->SetX($this->TableX); | |
650 | $cost_total = $cost_fermentables + $cost_hops + $cost_miscs + $cost_yeasts; | |
651 | $this->Cell(35,5,'Kosten',0,0,'L',true); | |
652 | $this->Cell(25,5,sprintf("%.2f",$cost_total).EURO,0,0,'L',true); | |
653 | $this->Cell(25,5,sprintf("%.2f",$cost_total/$row['batch_size']).EURO.' / liter',0,0,'L',true); | |
654 | ||
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
655 | // calorieen |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
656 | $this->ProcessingTable=false; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
657 | $this->cMargin=$cMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
658 | $this->aCols=array(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
659 | $this->Ln(); |
165 | 660 | } |
243
b43214d218c0
In stage Plan the brewdate data is saved, but not the brewdate itself. Added kettle_cm() function. Fixed serveral kettle heights when creating a new product. Print product prints a almost complete checklist in stages plan and brew.
Michiel Broek <mbroek@mbse.eu>
parents:
241
diff
changeset
|
661 | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
662 | function Brewday($row) { |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
663 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
664 | global $my_brix_correction; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
665 | global $my_grain_absorbtion; |
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:
460
diff
changeset
|
666 | global $coolingtype; |
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:
460
diff
changeset
|
667 | global $aerationtype; |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
668 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
669 | if ($this->GetY() > 180) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
670 | $this->AddPage(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
671 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
672 | $this->Ln(10); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
673 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
674 | $vul = $this->w - $this->rMargin - $this->lMargin - 170; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
675 | $cMargin=$this->cMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
676 | $this->cMargin=2; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
677 | $this->TableX=$this->lMargin; |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
678 | $this->SetFont('Helvetica','B',9); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
679 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
680 | $this->SetFillColor(255,150,100); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
681 | $this->Cell(0, 5, 'Brouwdag gegevens',0,0,'C',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
682 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
683 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
684 | $this->SetFont('Helvetica','',9); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
685 | $this->SetFillColor(210,245,255); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
686 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
687 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
688 | $this->Cell(35,5,'Datum start',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
689 | $this->Cell(50,5,$row['brew_date_start'],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
690 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
691 | $this->Cell(35,5,'Maisch zuurgraad',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
692 | $this->Cell(50,5,sprintf("%.1f", $row['brew_mash_ph']).' pH',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
693 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
694 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
695 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
696 | $this->Cell(35,5,'Datum eind',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
697 | $this->Cell(50,5,$row['brew_date_end'],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
698 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
699 | $this->Cell(35,5,'Maisch densiteit',0,0,'L',true); |
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:
391
diff
changeset
|
700 | $this->Cell(50,5,density_str(floatval($row['brew_mash_sg'])),0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
701 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
702 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
703 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
704 | $this->Cell(85+$vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
705 | $this->Cell(35,5,'Maisch rendement',0,0,'L',true); |
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:
391
diff
changeset
|
706 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_mash_efficiency']))."%",0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
707 | $this->Ln(7); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
708 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
709 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
710 | $this->Cell(35,5,'Voor koken zuurgraad',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
711 | $this->Cell(50,5,sprintf("%.1f", $row['brew_preboil_ph'])." pH",0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
712 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
713 | $this->Cell(35,5,'Na koken zuurgraad',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
714 | $this->Cell(50,5,sprintf("%.1f", $row['brew_aboil_ph'])." pH",0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
715 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
716 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
717 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
718 | $this->Cell(35,5,'Voor koken densiteit',0,0,'L',true); |
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:
391
diff
changeset
|
719 | $this->Cell(50,5,density_str(floatval($row['brew_preboil_sg'])),0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
720 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
721 | $this->Cell(35,5,'Na koken densiteit',0,0,'L',true); |
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:
391
diff
changeset
|
722 | $this->Cell(50,5,density_str(floatval($row['brew_aboil_sg'])),0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
723 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
724 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
725 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
726 | $this->Cell(35,5,'Voor koken volume',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
727 | $this->Cell(50,5,sprintf("%.1f", $row['brew_preboil_volume'])." liter",0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
728 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
729 | $this->Cell(35,5,'Na koken volume',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
730 | $this->Cell(50,5,sprintf("%.1f", $row['brew_aboil_volume'])." liter",0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
731 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
732 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
733 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
734 | $this->Cell(35,5,'Voor koken rendement',0,0,'L',true); |
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:
391
diff
changeset
|
735 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_preboil_efficiency']))."%",0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
736 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
737 | $this->Cell(35,5,'Na koken rendement',0,0,'L',true); |
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:
391
diff
changeset
|
738 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_aboil_efficiency']))."%",0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
739 | $this->Ln(7); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
740 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
741 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
742 | $this->Cell(35,5,'Spoelwater temperatuur',0,0,'L',true); |
432
99dcd8488b62
Merged brew_sparge_temperature with sparge_temp and brew_sparge_volume with sparge_volume.
Michiel Broek <mbroek@mbse.eu>
parents:
424
diff
changeset
|
743 | $this->Cell(50,5,sprintf("%.1f", $row['sparge_temp']).DEG.'C',0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
744 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
745 | $this->Cell(35,5,'Koel methode',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
746 | $this->Cell(50,5,$coolingtype[$row['brew_cooling_method']],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
747 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
748 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
749 | $this->SetX($this->TableX); |
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:
391
diff
changeset
|
750 | $this->Cell(35,5,'Spoelwater geschat',0,0,'L',true); |
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:
391
diff
changeset
|
751 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_sparge_est'])).' liter',0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
752 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
753 | $this->Cell(35,5,'Koel temperatuur',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
754 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_cooling_to'])).DEG.'C',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
755 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
756 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
757 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
758 | $this->Cell(35,5,'Spoelwater zuurgraad',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
759 | $this->Cell(50,5,sprintf("%.1f", $row['brew_sparge_ph']).' pH',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
760 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
761 | $this->Cell(35,5,'Koel tijdsduur',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
762 | $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_cooling_time'])).' minuten',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
763 | $this->Ln(7); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
764 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
765 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
766 | $this->Cell(35,5,'Whirlpool +85'.DEG.'C',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
767 | $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool9']).' minuten',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
768 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
769 | $this->Cell(35,5,'Koeler & trub verlies',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
770 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_tcloss'])).' liter',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
771 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
772 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
773 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
774 | $this->Cell(35,5,'Whirlpool 72..79'.DEG.'C',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
775 | $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool7']).' minuten',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
776 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
777 | $this->Cell(35,5,'Extra water in gistvat',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
778 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_extrawater'])).' liter',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
779 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
780 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
781 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
782 | $this->Cell(35,5,'Whirlpool 60..66'.DEG.'C',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
783 | $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool6']).' minuten',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
784 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
785 | $this->Cell(35,5,'Volume naar gistvat',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
786 | $this->Cell(50,5,sprintf("%.1f", floatval($row['brew_fermenter_volume'])).' liter',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
787 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
788 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
789 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
790 | $this->Cell(35,5,'Whirlpool koud',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
791 | $this->Cell(50,5,sprintf("%.0f", $row['brew_whirlpool2']).' minuten',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
792 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
793 | $this->Cell(35,5,'Densiteit in gistvat',0,0,'L',true); |
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:
391
diff
changeset
|
794 | $this->Cell(50,5,density_str(floatval($row['brew_fermenter_sg'])),0,0,'L',true); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
795 | $this->Ln(7); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
796 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
797 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
798 | $this->Cell(35,5,'Beluchten met',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
799 | $this->Cell(50,5,$aerationtype[$row['brew_aeration_type']],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
800 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
801 | $this->Cell(35,5,'Kleur in gistvat',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
802 | $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_color'])).' EBC',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
803 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
804 | |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
805 | $this->SetX($this->TableX); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
806 | $this->Cell(35,5,'Beluchten snelheid/tijd',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
807 | $this->Cell(50,5,$row['brew_aeration_speed'].'/'.$row['brew_aeration_time'],0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
808 | $this->Cell($vul,5,'',0,0,'L',false); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
809 | $this->Cell(35,5,'Bitterheid in gistvat',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
810 | $this->Cell(50,5,sprintf("%.0f", floatval($row['brew_fermenter_ibu'])).' IBU',0,0,'L',true); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
811 | $this->Ln(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
812 | } |
421 | 813 | |
814 | function Fermentation($row) { | |
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
815 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
816 | if ($this->GetY() > 230) |
421 | 817 | $this->AddPage(); |
818 | else | |
819 | $this->Ln(10); | |
820 | ||
821 | $vul = $this->w - $this->rMargin - $this->lMargin - 180; | |
822 | $cMargin=$this->cMargin; | |
823 | $this->cMargin=2; | |
824 | $this->TableX=$this->lMargin; | |
825 | $this->SetFont('Helvetica','B',9); | |
826 | $this->SetX($this->TableX); | |
827 | $this->SetFillColor(255,150,100); | |
828 | $this->Cell(0, 5, 'Vergisting gegevens',0,0,'C',true); | |
829 | $this->Ln(); | |
830 | ||
831 | $this->SetFont('Helvetica','',9); | |
832 | $this->SetFillColor(210,245,255); | |
833 | ||
834 | $this->SetX($this->TableX); | |
835 | $this->Cell(45,5,'Hoofdvergisting start temp.',0,0,'L',true); | |
836 | $this->Cell(45,5,sprintf("%.1f",$row['primary_start_temp']).DEG.'C',0,0,'L',true); | |
837 | $this->Cell($vul,5,'',0,0,'L',false); | |
838 | $this->Cell(45,5,'Hoofdvergisting piek temp.',0,0,'L',true); | |
839 | $this->Cell(45,5,sprintf("%.1f",$row['primary_max_temp']).DEG.'C',0,0,'L',true); | |
840 | $this->Ln(); | |
841 | ||
842 | $this->SetX($this->TableX); | |
843 | $this->Cell(45,5,'Hoofdvergisting eind temp.',0,0,'L',true); | |
844 | $this->Cell(45,5,sprintf("%.1f",$row['primary_end_temp']).DEG.'C',0,0,'L',true); | |
460
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
845 | $this->Cell($vul,5,'',0,0,'L',false); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
846 | $this->Cell(45,5,'Hoofdvergisting densiteit',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
847 | $this->Cell(45,5,sprintf("%.3f",floatval($row['primary_end_sg'])).' SG',0,0,'L',true); |
421 | 848 | $this->Ln(); |
849 | ||
850 | $this->SetX($this->TableX); | |
460
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
851 | $this->Cell(45,5,'Hoofdvergisting einde',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
852 | $this->Cell(45,5,$row['primary_end_date'],0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
853 | $this->Ln(); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
854 | |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
855 | $this->SetX($this->TableX); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
856 | $this->Cell(45,5,'Navergisting tempertuur',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
857 | $this->Cell(45,5,sprintf("%.1f", $row['secondary_temp']).DEG.'C',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
858 | $this->Cell($vul,5,'',0,0,'L',false); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
859 | $this->Cell(45,5,'Nagisten densiteit',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
860 | $this->Cell(45,5,sprintf("%.3f",floatval($row['secondary_end_sg'])).' SG',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
861 | $this->Ln(); |
421 | 862 | |
863 | $this->SetX($this->TableX); | |
460
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
864 | $this->Cell(45,5,'Nagisten einde',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
865 | $this->Cell(45,5,$row['secondary_end_date'],0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
866 | $this->Ln(); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
867 | |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
868 | $this->SetX($this->TableX); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
869 | $this->Cell(45,5,'Lageren temperatuur',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
870 | $this->Cell(45,5,sprintf("%.1f",$row['tertiary_temp']).DEG.'C',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
871 | $this->Cell($vul,5,'',0,0,'L',false); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
872 | $this->Cell(45,5,'Lageren densiteit',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
873 | $this->Cell(45,5,sprintf("%.3f",floatval($row['fg'])).' SG',0,0,'L',true); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
874 | $this->Ln(); |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
875 | |
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
876 | $this->SetX($this->TableX); |
421 | 877 | $this->Cell(45,5,'Lageren einde',0,0,'L',true); |
878 | $this->Cell(45,5,$row['package_date'],0,0,'L',true); | |
460
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
879 | $this->Cell($vul,5,'',0,0,'L',false); |
421 | 880 | $svg = 100 * (floatval($row['brew_fermenter_sg']) - floatval($row['fg'])) / (floatval($row['brew_fermenter_sg']) - 1); |
460
046ff5fdc96c
Implemented products.secondary_end_sg field. The missing values are updated by the crontask.
Michiel Broek <mbroek@mbse.eu>
parents:
449
diff
changeset
|
881 | $this->Cell(45,5,'Schijnbare vergistingsgraad',0,0,'L',true); |
421 | 882 | $this->Cell(45,5,sprintf("%.1f",$svg).'%',0,0,'L',true); |
883 | $this->Ln(); | |
884 | } | |
885 | ||
886 | function Packaging($row) { | |
887 | ||
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
888 | global $bottle_sugar; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
889 | global $bottle_sugar_amount; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
890 | global $keg_sugar; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
891 | global $keg_sugar_amount; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
892 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
893 | if ($this->GetY() > 230) |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
894 | $this->AddPage(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
895 | else |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
896 | $this->Ln(10); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
897 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
898 | $vul = $this->w - $this->rMargin - $this->lMargin - 180; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
899 | $cMargin=$this->cMargin; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
900 | $this->cMargin=2; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
901 | $this->TableX=$this->lMargin; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
902 | $this->SetFont('Helvetica','B',9); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
903 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
904 | $this->SetFillColor(255,150,100); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
905 | $this->Cell(0, 5, 'Verpakken',0,0,'C',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
906 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
907 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
908 | $this->SetFont('Helvetica','',9); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
909 | $this->SetFillColor(210,245,255); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
910 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
911 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
912 | $this->Cell(45,5,'Datum verpakken',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
913 | $this->Cell(45,5,$row['package_date'],0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
914 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
915 | $this->Cell(45,5,'Hoeveelheid',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
916 | $this->Cell(45,5,sprintf("%.1f", $row['package_volume']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
917 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
918 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
919 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
920 | $this->Cell(45,5,'Alcohol volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
921 | $this->Cell(45,5,sprintf("%.1f",$row['package_abv']).'%',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
922 | if (($row['package_infuse_amount'] > 0) && ($row['package_infuse_abv'] == 0)) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
923 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
924 | $this->Cell(45,5,'Water toevoegen',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
925 | $this->Cell(45,5,sprintf("%.1f", $row['package_infuse_amount']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
926 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
927 | $this->Ln(7); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
928 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
929 | if (($row['package_infuse_amount'] > 0) && ($row['package_infuse_abv'] > 0)) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
930 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
931 | $this->Cell(45,5,'Drank toevoegen',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
932 | $this->Cell(45,5,sprintf("%.1f",$row['package_infuse_amount']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
933 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
934 | $this->Cell(45,5,'Bevat alcohol volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
935 | $this->Cell(45,5,sprintf("%.1f", $row['package_infuse_abv']).'%',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
936 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
937 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
938 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
939 | $this->Cell(180,5,iconv('UTF-8','windows-1252',$row['package_infuse_notes']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
940 | $this->Ln(7); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
941 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
942 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
943 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
944 | $this->Cell(45,5,'Flessen volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
945 | $this->Cell(45,5,sprintf("%.1f",$row['bottle_amount']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
946 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
947 | $this->Cell(45,5,'Fusten volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
948 | $this->Cell(45,5,sprintf("%.1f", $row['keg_amount']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
949 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
950 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
951 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
952 | $this->Cell(45,5,'CO2 volumes',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
953 | $this->Cell(45,5,sprintf("%.2f",$row['bottle_carbonation']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
954 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
955 | $this->Cell(45,5,'CO2 volumes',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
956 | $this->Cell(45,5,sprintf("%.2f", $row['keg_carbonation']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
957 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
958 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
959 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
960 | $this->Cell(45,5,'Suiker',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
961 | $this->Cell(45,5,$bottle_sugar,0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
962 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
963 | $this->Cell(45,5,'Suiker',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
964 | $this->Cell(45,5,$keg_sugar,0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
965 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
966 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
967 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
968 | $this->Cell(45,5,'Hoeveelheid',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
969 | $this->Cell(45,5,sprintf("%.1f",$row['bottle_priming_amount']).' gram/liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
970 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
971 | if ($row['keg_forced_carb']) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
972 | $this->Cell(45,5,'Geforceerd op druk zetten',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
973 | $this->Cell(45,5,'Ja',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
974 | } else { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
975 | $this->Cell(45,5,'Hoeveelheid',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
976 | $this->Cell(45,5,sprintf("%.1f", $row['keg_priming_amount']).' gram/liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
977 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
978 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
979 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
980 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
981 | $this->Cell(45,5,'Totaal suiker',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
982 | $this->Cell(45,5,sprintf("%.3f",$bottle_sugar_amount).' kg',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
983 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
984 | if ($row['keg_forced_carb']) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
985 | $this->Cell(45,5,'Druk op fust',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
986 | $this->Cell(45,5,sprintf("%.1f",$row['keg_pressure']).' bar',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
987 | } else { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
988 | $this->Cell(45,5,'Totaal suiker',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
989 | $this->Cell(45,5,sprintf("%.3f",$keg_sugar_amount).' kg',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
990 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
991 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
992 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
993 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
994 | $this->Cell(45,5,'Water oplossen',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
995 | $this->Cell(45,5,sprintf("%.3f",$row['bottle_priming_water']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
996 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
997 | if (! $row['keg_forced_carb']) { |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
998 | $this->Cell(45,5,'Water oplossen',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
999 | $this->Cell(45,5,sprintf("%.3f",$row['keg_priming_water']).' liter',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1000 | } |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1001 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1002 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1003 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1004 | $this->Cell(45,5,'Alcohol volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1005 | $this->Cell(45,5,sprintf("%.1f",$row['package_abv'] + $row['bottle_priming_amount'] * 0.47 / 7.907).'%',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1006 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1007 | $this->Cell(45,5,'Alcohol volume',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1008 | $this->Cell(45,5,sprintf("%.1f",$row['package_abv'] + $row['keg_priming_amount'] * 0.47 / 7.907).'%',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1009 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1010 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1011 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1012 | $this->Cell(45,5,'Hergisting temperatuur',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1013 | $this->Cell(45,5,sprintf("%.1f",$row['bottle_carbonation_temp']).DEG.'C',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1014 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1015 | $this->Cell(45,5,'Hergisting temperatuur',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1016 | $this->Cell(45,5,sprintf("%.1f", $row['keg_carbonation_temp']).DEG.'C',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1017 | $this->Ln(); |
421 | 1018 | } |
1019 | ||
1020 | function Tasting($row) { | |
1021 | ||
424
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1022 | if ($this->GetY() > 200) |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1023 | $this->AddPage(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1024 | else |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1025 | $this->Ln(10); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1026 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1027 | $vul = $this->w - $this->rMargin - $this->lMargin - 180; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1028 | $cMargin=$this->cMargin; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1029 | $this->cMargin=2; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1030 | $this->TableX=$this->lMargin; |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1031 | $this->SetFont('Helvetica','B',9); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1032 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1033 | $this->SetFillColor(255,150,100); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1034 | $this->Cell(0, 5, 'Proef notities',0,0,'C',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1035 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1036 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1037 | $this->SetFont('Helvetica','',9); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1038 | $this->SetFillColor(210,245,255); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1039 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1040 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1041 | $this->Cell(45,5,'Proeven datum',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1042 | $this->Cell(45,5,$row['taste_date'],0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1043 | $this->Cell($vul,5,'',0,0,'L',false); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1044 | $this->Cell(45,5,'Waardering',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1045 | $this->Cell(45,5,sprintf("%.1f", $row['taste_rate']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1046 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1047 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1048 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1049 | $this->Cell(45,5,'Kleur',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1050 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_color']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1051 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1052 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1053 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1054 | $this->Cell(45,5,'Helderheid',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1055 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_transparency']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1056 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1057 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1058 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1059 | $this->Cell(45,5,'Schuim',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1060 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_head']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1061 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1062 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1063 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1064 | $this->Cell(45,5,'Aroma',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1065 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_aroma']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1066 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1067 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1068 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1069 | $this->Cell(45,5,'Smaak',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1070 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_taste']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1071 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1072 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1073 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1074 | $this->Cell(45,5,'Mondgevoel',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1075 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_mouthfeel']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1076 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1077 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1078 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1079 | $this->Cell(45,5,'Nasmaak',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1080 | $this->Cell($vul+135,5,iconv('UTF-8','windows-1252',$row['taste_aftertaste']),0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1081 | $this->Ln(); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1082 | |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1083 | $this->SetX($this->TableX); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1084 | $this->Cell(45,5,'Notities',0,0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1085 | $this->MultiCell(0,5,iconv('UTF-8','windows-1252',$row['taste_notes']),0,'L',true); |
7d231014b301
Added packaging and tasting to print product.
Michiel Broek <mbroek@mbse.eu>
parents:
421
diff
changeset
|
1086 | $this->Ln(); |
421 | 1087 | } |
165 | 1088 | } |
1089 | ||
1090 | ||
1091 | ||
1092 | class PDF extends PDF_MySQL_Table { | |
1093 | function Header() { | |
1094 | global $row; | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1095 | global $prdate; |
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:
460
diff
changeset
|
1096 | global $stage; |
243
b43214d218c0
In stage Plan the brewdate data is saved, but not the brewdate itself. Added kettle_cm() function. Fixed serveral kettle heights when creating a new product. Print product prints a almost complete checklist in stages plan and brew.
Michiel Broek <mbroek@mbse.eu>
parents:
241
diff
changeset
|
1097 | $this->Image('images/logo.png',10,10,30); |
165 | 1098 | // Title |
1099 | $this->SetFont('Helvetica','B',18); | |
1100 | $this->SetX(45); | |
243
b43214d218c0
In stage Plan the brewdate data is saved, but not the brewdate itself. Added kettle_cm() function. Fixed serveral kettle heights when creating a new product. Print product prints a almost complete checklist in stages plan and brew.
Michiel Broek <mbroek@mbse.eu>
parents:
241
diff
changeset
|
1101 | $this->Cell(0,8,$row['code'].' '.$row['name'],0,1,'L'); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1102 | $this->Ln(1); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1103 | $this->SetFont('Helvetica','',10); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1104 | $this->SetX(45); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1105 | $this->Cell(17,5,'Datum:',0,0,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1106 | $this->Cell(0,5,$prdate,0,1,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1107 | $this->SetX(45); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1108 | $this->Cell(17,5,'Stijl:',0,0,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1109 | $this->Cell(0,5,$row['st_name'],0,1,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1110 | $this->SetX(45); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1111 | $this->Cell(17,5,'Fase:',0,0,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1112 | $this->Cell(0,5,$stage[$row['stage']],0,1,'L'); |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1113 | $this->Ln(6); |
165 | 1114 | // Ensure table header is printed |
1115 | parent::Header(); | |
1116 | } | |
1117 | } | |
1118 | ||
1119 | ||
1120 | /* | |
1121 | * Generate PDF from recipe data | |
1122 | */ | |
1123 | $pdf = new PDF(); | |
1124 | $pdf->AddPage(); | |
1125 | $pdf->TableGlobal($row); | |
1126 | $pdf->TableFermentables($row); | |
1127 | $pdf->TableHops($row); | |
1128 | $pdf->TableYeasts($row); | |
1129 | $pdf->TableMiscs($row); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1130 | $pdf->TableMashs($row); |
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:
391
diff
changeset
|
1131 | $pdf->TableWaters($row); |
165 | 1132 | $pdf->TableSummary($row); |
1133 | if (strlen($row['notes'])) { | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1134 | if ($pdf->GetY() > 200) |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1135 | $pdf->AddPage(); |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1136 | else |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1137 | $pdf->Ln(10); |
165 | 1138 | $pdf->SetFillColor(255,150,100); |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1139 | $pdf->SetFont('Helvetica','B',9); |
165 | 1140 | $pdf->Cell(0, 5, 'Recept opmerkingen',0,0,'C',true); |
1141 | $pdf->Ln(); | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1142 | $pdf->SetFont('Helvetica','',9); |
165 | 1143 | $pdf->SetFillColor(210,245,255); |
421 | 1144 | $pdf->MultiCell(0,4,iconv('UTF-8','windows-1252',$row['notes']),0,'L',true); |
165 | 1145 | } |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1146 | |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1147 | if ($row['stage'] > 2) { |
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1148 | $pdf->Brewday($row); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1149 | } |
391
a1bcebc61ddd
Added mash schedule and brewday data to the product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
357
diff
changeset
|
1150 | |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1151 | if ($row['stage'] > 3) { |
421 | 1152 | $pdf->Fermentation($row); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1153 | } |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1154 | if ($row['stage'] > 6) { |
421 | 1155 | $pdf->Packaging($row); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1156 | } |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1157 | if ($row['stage'] > 9) { |
421 | 1158 | $pdf->Tasting($row); |
240
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1159 | } |
a85c1d4c4d12
Depending on the product stage, more or less fields are saved in the database. Added begin of auto stage increase. Added missing inventory columns in the fermentables grid. New product wizzard now works with the indexed values. Product print works with indexed values and prepared for different print modules depending on the product stage.
Michiel Broek <mbroek@mbse.eu>
parents:
165
diff
changeset
|
1160 | |
165 | 1161 | $pdf->Output(); |