Sun, 12 May 2019 15:16:35 +0200
Lot's of improvements for recipes and products database load and save. Insert missing yeast tolerance field for old products and recipes. Recipe locked and calc_acid fields coverted to integer. In recipe edit screen removed the Print button. It is now included in the export screen. Added recipe export to forum screen.
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
3 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/formulas.php'); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
4 | require_once($_SERVER['DOCUMENT_ROOT'].'/fpdf/fpdf.php'); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
5 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
6 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
7 | $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
8 | if (! $link) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
9 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
10 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
11 | if (! mysqli_set_charset($link, "utf8" )) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
12 | echo "error"; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
13 | return 1; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
14 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
15 | |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
16 | setlocale ( LC_ALL, 'nl_NL.UTF-8'); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
17 | $record = $_GET["record"]; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
18 | $result = mysqli_query($link, "SELECT * FROM recipes WHERE record='".$record."'"); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
19 | $row = mysqli_fetch_array($result); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
20 | |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
21 | $total_fermentables = 0.0; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
22 | $cost_fermentables = 0.0; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
23 | $total_hops = 0.0; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
24 | $cost_hops = 0.0; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
25 | $cost_yeasts = 0.0; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
26 | $cost_miscs = 0.0; |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
27 | $pSugar = 0; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
28 | $pCara = 0; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
29 | $svg = 77; |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
30 | $colorw = 0; |
93 | 31 | $total_ibus = 0; |
94
295c3af2a421
Include boil_size field in the recipes table. Calculate pre-boil SG. Use that in the IBU calculation.
Michiel Broek <mbroek@mbse.eu>
parents:
93
diff
changeset
|
32 | $preboil_sg = 0; |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
33 | date_default_timezone_set('Europe/Amsterdam'); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
34 | $prdate = date(DATE_RFC2822); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
35 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
36 | class PDF_MySQL_Table extends FPDF |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
37 | { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
38 | protected $ProcessingTable=false; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
39 | protected $aCols=array(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
40 | protected $TableX; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
41 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
42 | function Header() { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
43 | // Print the table header if necessary |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
44 | if ($this->ProcessingTable) |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
45 | $this->TableHeader(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
46 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
47 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
48 | function TableHeader() { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
49 | $this->SetFont('Helvetica','B',9); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
50 | $this->SetX($this->TableX); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
51 | $this->SetFillColor(255,150,100); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
52 | foreach($this->aCols as $col) |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
53 | $this->Cell($col['w'],5,$col['c'],0,0,$col['a'],true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
54 | $this->Ln(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
55 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
56 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
57 | function AddCol($width=-1, $caption='', $align='L') { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
58 | $this->aCols[]=array('c'=>$caption,'w'=>$width,'a'=>$align); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
59 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
60 | |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
61 | function TableGlobal($row) { |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
62 | /* 2 Columns */ |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
63 | $recipetype = array( 'Extract', 'Deelmaisch', 'Mout' ); |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
64 | $vul = $this->w - $this->rMargin - $this->lMargin - 120; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
65 | $cMargin=$this->cMargin; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
66 | $this->cMargin=2; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
67 | $this->TableX=$this->lMargin; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
68 | $this->SetFont('Helvetica','B',9); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
69 | $this->SetX($this->TableX); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
70 | $this->SetFillColor(255,150,100); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
71 | $this->Cell(0, 5, 'Recept overzicht',0,0,'C',true); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
72 | $this->Ln(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
73 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
74 | $this->SetFont('Helvetica','',9); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
75 | $this->SetFillColor(210,245,255); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
76 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
77 | $this->SetX($this->TableX); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
78 | $this->Cell(35,5,'Type',0,0,'L',true); |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
79 | $this->Cell(25,5,$recipetype[$row['type']],0,0,'L',true); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
80 | $this->Cell($vul,5,'',0,0,'L',false); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
81 | $this->Cell(35,5,'Batch grootte',0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
82 | $this->Cell(25,5,$row['batch_size'].' liter',0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
83 | $this->Ln(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
84 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
85 | $this->SetX($this->TableX); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
86 | $this->Cell(35,5,'Kooktijd',0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
87 | $this->Cell(25,5,$row['boil_time'].' minuten',0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
88 | $this->Cell($vul,5,'',0,0,'L',false); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
89 | $this->Cell(35,5,'Brouwzaal rendement',0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
90 | $this->Cell(25,5,$row['efficiency'].' %',0,0,'L',true); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
91 | $this->Ln(10); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
92 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
93 | $this->cMargin=$cMargin; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
94 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
95 | |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
96 | function TableFermentables($row) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
97 | global $cost_fermentables; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
98 | global $total_fermentables; |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
99 | global $pSugar; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
100 | global $pCara; |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
101 | global $colorw; |
94
295c3af2a421
Include boil_size field in the recipes table. Calculate pre-boil SG. Use that in the IBU calculation.
Michiel Broek <mbroek@mbse.eu>
parents:
93
diff
changeset
|
102 | global $preboil_sg; |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
103 | $added = array( 'Maischen', 'Koken', 'Vergisten', 'Nagisten/lageren', 'Bottelen' ); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
104 | $vul = $this->w - $this->rMargin - $this->lMargin - 132; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
105 | $this->AddCol($vul,'Grondstof','L'); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
106 | $this->AddCol(30,'Leverancier','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
107 | $this->AddCol(15,'EBC','R'); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
108 | $this->AddCol(17,'Moment','L'); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
109 | $this->AddCol(20,'Kg','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
110 | $this->AddCol(15,'Procent','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
111 | $this->AddCol(15,'Opbr.','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
112 | $this->AddCol(20,'Prijs','R'); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
113 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
114 | $cMargin=$this->cMargin; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
115 | $this->cMargin=2; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
116 | $this->TableX=$this->lMargin; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
117 | $this->TableHeader(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
118 | $this->ProcessingTable=true; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
119 | |
98
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
120 | $sugarsf = 0; |
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
121 | $sugarsm = 0; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
122 | $this->SetFont('Helvetica','',9); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
123 | $this->SetFillColor(250, 195, 65); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
124 | $arr = json_decode($row['json_fermentables'], true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
125 | foreach($arr as $item) { //foreach element in $arr |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
126 | $name = iconv('UTF-8','windows-1252',$item['f_name']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
127 | $supplier = iconv('UTF-8','windows-1252',$item['f_supplier']); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
128 | $amount = floatval($item['f_amount']); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
129 | $costkg = floatval($item['f_cost']); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
130 | $yield = floatval($item['f_yield']); |
85
ca7a37586551
Added SG/Plato formulas for PHP. Added OG calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
84
diff
changeset
|
131 | $moisture = floatval($item['f_moisture']); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
132 | $color = floatval($item['f_color']); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
133 | $percent = floatval($item['f_percentage']); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
134 | |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
135 | if ($item['f_type'] == 1) // Sugar |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
136 | $pSugar += $percent; |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
137 | if ($item['f_graintype'] == 2) // Crystal |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
138 | $pCara += $percent; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
139 | |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
140 | $cost = $amount * $costkg; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
141 | $cost_fermentables += $cost; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
142 | $total_fermentables += $amount; |
85
ca7a37586551
Added SG/Plato formulas for PHP. Added OG calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
84
diff
changeset
|
143 | /* Calculate the amount of sugars */ |
ca7a37586551
Added SG/Plato formulas for PHP. Added OG calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
84
diff
changeset
|
144 | $d = $amount * ($yield / 100) * (1 - $moisture / 100); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
145 | if ($item['f_added'] == 0) { // Mash |
85
ca7a37586551
Added SG/Plato formulas for PHP. Added OG calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
84
diff
changeset
|
146 | $d = floatval($row['efficiency']) / 100 * $d; |
98
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
147 | $sugarsm += $d; |
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
148 | } |
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
149 | $sugarsf += $d; |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
150 | $colorw += ($amount * ebc_to_srm($color) / $row['batch_size']) * 8.34436; |
85
ca7a37586551
Added SG/Plato formulas for PHP. Added OG calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
84
diff
changeset
|
151 | |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
152 | $this->Cell($vul,5,$name,0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
153 | $this->Cell(30,5,$supplier,0,0,'L',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
154 | $this->Cell(15,5,sprintf("%.0f",$color),0,0,'R',true); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
155 | $this->Cell(17,5,$added[$item['f_added']],0,0,'L',true); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
156 | $this->Cell(20,5,sprintf("%8.3f",$amount),0,0,'R',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
157 | $this->Cell(15,5,sprintf("%.1f%%",$percent),0,0,'R',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
158 | $this->Cell(15,5,sprintf("%.1f%%",$yield),0,0,'R',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
159 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
160 | $this->Ln(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
161 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
162 | |
98
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
163 | $row['est_og'] = estimate_sg($sugarsf, floatval($row['batch_size'])); |
92d6bc8a4cdd
Added javascript formulas for color calculations. Added IBU total calculation. Better IBI calculation for the hop entries. Blocked selection of IBU calculation for Garetz, Mosher and Noonan. Better sg calculation in the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
96
diff
changeset
|
164 | $preboil_sg = estimate_sg($sugarsm, floatval($row['boil_size'])); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
165 | $this->SetFillColor(210,245,255); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
166 | $this->Cell($vul+62,5,'',0,0,'L',false); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
167 | $this->Cell(20,5,sprintf("%8.3f",$total_fermentables),0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
168 | $this->Cell(30,5,'',0,0,'L',false); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
169 | $this->Cell(20,5,sprintf("%8.3f",$cost_fermentables).EURO,0,0,'R',true); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
170 | $this->Ln(10); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
171 | $this->ProcessingTable=false; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
172 | $this->cMargin=$cMargin; |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
173 | $this->aCols=array(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
174 | } |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
175 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
176 | function TableHops($row) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
177 | global $total_hops; |
93 | 178 | global $total_ibus; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
179 | global $cost_hops; |
94
295c3af2a421
Include boil_size field in the recipes table. Calculate pre-boil SG. Use that in the IBU calculation.
Michiel Broek <mbroek@mbse.eu>
parents:
93
diff
changeset
|
180 | global $preboil_sg; |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
181 | // $hoptype = array( 'Bitterhop', 'Aromahop', 'Beide' ); |
289
4082c41f45e9
Added the use and calculation of wet hops. Assume 5.5 times more hops needed by weight.
Michiel Broek <mbroek@mbse.eu>
parents:
240
diff
changeset
|
182 | $hopform = array( 'Pellets', 'Plugs', 'Bellen', 'Hop nat' ); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
183 | $hopuse = array( 'Maischen', 'First wort', 'Koken', 'Vlamuit', 'Whirlpool', 'Koudhop' ); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
184 | $vul = $this->w - $this->rMargin - $this->lMargin - 135; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
185 | $this->AddCol($vul,'Hop','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
186 | $this->AddCol(35,'Land','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
187 | $this->AddCol(15,'Soort','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
188 | $this->AddCol(20,'Moment','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
189 | $this->AddCol(15,'Alpha','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
190 | $this->AddCol(12,'IBU','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
191 | $this->AddCol(18,'Gram','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
192 | $this->AddCol(20,'Prijs','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
193 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
194 | $cMargin=$this->cMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
195 | $this->cMargin=2; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
196 | $this->TableX=$this->lMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
197 | $this->TableHeader(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
198 | $this->ProcessingTable=true; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
199 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
200 | $this->SetFont('Helvetica','',9); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
201 | $this->SetFillColor(100, 250, 65); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
202 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
203 | $arr = json_decode($row['json_hops'], true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
204 | foreach($arr as $item) { //foreach element in $arr |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
205 | $name = iconv('UTF-8','windows-1252',$item['h_name']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
206 | $origin = iconv('UTF-8','windows-1252',$item['h_origin']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
207 | $amount = floatval($item['h_amount']) * 1000; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
208 | $mass = $amount; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
209 | $costkg = floatval($item['h_cost']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
210 | $time = floatval($item['h_time']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
211 | $alpha = floatval($item['h_alpha']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
212 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
213 | $cost = ($amount * $costkg) / 1000; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
214 | $cost_hops += $cost; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
215 | $total_hops += $amount; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
216 | |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
217 | $moment = $hopuse[$item['h_useat']]; |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
218 | if ($item['h_useat'] == 2) { // Boil |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
219 | $moment = "Kook@".$time; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
220 | } |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
221 | $ibu = calc_IBU($item['h_useat'], $item['h_form'], $preboil_sg, floatval($row['batch_size']), $mass, $time, $alpha, $row['ibu_method']); |
93 | 222 | $total_ibus += $ibu; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
223 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
224 | $this->Cell($vul,5,$name,0,0,'L',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
225 | $this->Cell(35,5,$origin,0,0,'L',true); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
226 | $this->Cell(15,5,$hopform[$item['h_form']],0,0,'L',true); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
227 | $this->Cell(20,5,$moment,0,0,'L',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
228 | $this->Cell(15,5,sprintf("%.1f%%",$alpha),0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
229 | $this->Cell(12,5,sprintf("%.1f",$ibu),0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
230 | $this->Cell(18,5,sprintf("%.1f",$amount),0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
231 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
232 | $this->Ln(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
233 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
234 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
235 | $this->SetFillColor(210,245,255); |
93 | 236 | $this->Cell($vul+85,5,'',0,0,'L',false); |
237 | $this->Cell(12,5,sprintf("%.1f",$total_ibus),0,0,'R',true); | |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
238 | $this->Cell(18,5,sprintf("%.1f",$total_hops),0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
239 | $this->Cell(20,5,sprintf("%8.3f",$cost_hops).EURO,0,0,'R',true); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
240 | $this->Ln(10); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
241 | $this->ProcessingTable=false; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
242 | $this->cMargin=$cMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
243 | $this->aCols=array(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
244 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
245 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
246 | function TableYeasts($row) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
247 | global $cost_yeasts; |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
248 | global $svg; |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
249 | $yeastform = array( 'Vloeibaar', 'Droog', 'Schuine buis', 'Slurry', 'Ingevroren', 'Depot' ); |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
250 | $yeastuse = array( 'Hoofdgisting', 'Nagisting', 'Lagering', 'Bottelen' ); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
251 | $vul = $this->w - $this->rMargin - $this->lMargin - 140; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
252 | $this->AddCol(27,'Laboratorium','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
253 | $this->AddCol(18,'Product','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
254 | $this->AddCol($vul,'Gist','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
255 | $this->AddCol(20,'Gebruik','L'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
256 | $this->AddCol(15,'Attn','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
257 | $this->AddCol(22,'Vorm','L'); |
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
258 | $this->AddCol(18,'Hoeveel','R'); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
259 | $this->AddCol(20,'Prijs','R'); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
260 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
261 | $cMargin=$this->cMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
262 | $this->cMargin=2; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
263 | $this->TableX=$this->lMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
264 | $this->TableHeader(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
265 | $this->ProcessingTable=true; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
266 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
267 | $this->SetFont('Helvetica','',9); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
268 | $this->SetFillColor(175, 175, 255); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
269 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
270 | $arr = json_decode($row['json_yeasts'], true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
271 | foreach($arr as $item) { //foreach element in $arr |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
272 | $name = iconv('UTF-8','windows-1252',$item['y_name']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
273 | $laboratory = iconv('UTF-8','windows-1252',$item['y_laboratory']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
274 | $product_id = iconv('UTF-8','windows-1252',$item['y_product_id']); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
275 | $attenuation = floatval($item['y_attenuation']); |
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
276 | $cost = floatval($item['y_amount']) * floatval($item['y_cost']); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
277 | $cost_yeasts += $cost; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
278 | |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
279 | if ($item['y_use'] == 0) // Primary |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
280 | $svg = $attenuation; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
281 | |
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
282 | if ($item['y_form'] == 0) // Liquid |
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
283 | $amount = sprintf("%.0f",floatval($item['y_amount']))." pak"; |
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
284 | else if ($item['y_form'] == 1) // Dry |
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
285 | $amount = sprintf("%.1f",floatval($item['y_amount'])*1000)." gr"; |
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
286 | else |
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
287 | $amount = sprintf("%.0f",floatval($item['y_amount'])*1000)." ml"; |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
288 | $this->Cell(27,5,$laboratory,0,0,'L',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
289 | $this->Cell(18,5,$product_id,0,0,'L',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
290 | $this->Cell($vul,5,$name,0,0,'L',true); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
291 | $this->Cell(20,5,$yeastuse[$item['y_use']],0,0,'L',true); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
292 | $this->Cell(15,5,sprintf("%.1f%%",$attenuation),0,0,'R',true); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
293 | $this->Cell(22,5,$yeastform[$item['y_form']],0,0,'L',true); |
232
daf2d9d6fa18
When adding yeast the flocculation and cells fields were not added. Possible fix for double water agents in the miscs grid. Better efforts to set the initial water infuse amount. The new recipe wizzard now uses indexed fields. In recipe print fixed the yeast amount and cost.
Michiel Broek <mbroek@mbse.eu>
parents:
231
diff
changeset
|
294 | $this->Cell(18,5,$amount,0,0,'R',true); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
295 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
296 | $this->Ln(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
297 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
298 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
299 | $this->SetFillColor(210,245,255); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
300 | $this->Cell($vul+120,5,'',0,0,'L',false); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
301 | $this->Cell(20,5,sprintf("%8.3f",$cost_yeasts).EURO,0,0,'R',true); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
302 | $this->Ln(10); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
303 | $this->ProcessingTable=false; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
304 | $this->cMargin=$cMargin; |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
305 | $this->aCols=array(); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
306 | } |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
307 | |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
308 | function TableMiscs($row) { |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
309 | global $cost_miscs; |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
310 | $misctype = array( 'Specerij', 'Kruid', 'Smaakstof', 'Klaringsmiddel', 'Brouwzout', 'Gistvoeding', 'Anders' ); |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
311 | $miscuse = array( 'Starter', 'Maischen', 'Koken', 'Hoofdvergisting', 'Nagisting/lagering', 'Bottelen' ); |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
312 | $vul = $this->w - $this->rMargin - $this->lMargin - 100; |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
313 | $this->AddCol($vul,'Naam','L'); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
314 | $this->AddCol(30,'Soort','L'); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
315 | $this->AddCol(30,'Gebruik','L'); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
316 | $this->AddCol(20,'Hoeveel','R'); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
317 | $this->AddCol(20,'Prijs','R'); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
318 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
319 | $cMargin=$this->cMargin; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
320 | $this->cMargin=2; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
321 | $this->TableX=$this->lMargin; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
322 | $this->TableHeader(); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
323 | $this->ProcessingTable=true; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
324 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
325 | $this->SetFont('Helvetica','',9); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
326 | $this->SetFillColor(175, 175, 255); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
327 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
328 | $arr = json_decode($row['json_miscs'], true); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
329 | foreach($arr as $item) { |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
330 | $name = iconv('UTF-8','windows-1252',$item['m_name']); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
331 | $type = $item['m_type']; |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
332 | $use_use = $item['m_use_use']; |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
333 | $amount = floatval($item['m_amount']) * 1000; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
334 | $costg = floatval($item['m_cost']) / 1000; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
335 | $time = floatval($item['m_time']); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
336 | $aiw = $item['m_amount_is_weight']; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
337 | $cost = $amount * $costg; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
338 | $cost_miscs += $cost; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
339 | |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
340 | if ($type == 4) // Water agent |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
341 | $this->SetFillColor(240,140,130); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
342 | else if ($type == 3) // Fining |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
343 | $this->SetFillColor(95,180,25); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
344 | else if (($type == 0) || ($type == 1) || ($type == 2) || ($type == 5)) // Spice, Herb, Flavour, Yeast nutrient |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
345 | $this->SetFillColor(240,250,65); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
346 | else |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
347 | $this->SetFillColor(210,245,255); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
348 | |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
349 | if ($use_use == 2) // Boil |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
350 | $gebruik = sprintf("%s %d min",$miscuse[$use_use],$time); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
351 | else |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
352 | $gebruik = $miscuse[$use_use]; |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
353 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
354 | $hoeveel = sprintf("%.1f %s",$amount,$aiw ? "gr":"ml"); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
355 | $this->Cell($vul,5,$name,0,0,'L',true); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
356 | $this->Cell(30,5,$misctype[$type],0,0,'L',true); |
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
357 | $this->Cell(30,5,$gebruik,0,0,'L',true); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
358 | $this->Cell(20,5,$hoeveel,0,0,'R',true); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
359 | $this->Cell(20,5,sprintf("%8.3f",$cost).EURO,0,0,'R',true); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
360 | $this->Ln(); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
361 | } |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
362 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
363 | $this->SetFillColor(210,245,255); |
231
9881453a49b3
Recipe print and export afjusted to use array indexes.
Michiel Broek <mbroek@mbse.eu>
parents:
98
diff
changeset
|
364 | $this->Cell($vul+80,5,'',0,0,'L',false); |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
365 | $this->Cell(20,5,sprintf("%8.3f",$cost_miscs).EURO,0,0,'R',true); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
366 | $this->Ln(10); |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
367 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
368 | $this->ProcessingTable=false; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
369 | $this->cMargin=$cMargin; |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
370 | $this->aCols=array(); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
371 | } |
84
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
372 | |
3e5e87f1818d
Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
83
diff
changeset
|
373 | // Watercolor $this->SetFillColor(120,255,250); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
374 | |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
375 | function TableSummary($row) { |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
376 | global $pSugar; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
377 | global $pCara; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
378 | global $svg; |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
379 | global $colorw; |
93 | 380 | global $cost_fermentables; |
381 | global $cost_hops; | |
382 | global $cost_miscs; | |
383 | global $cost_yeasts; | |
338
a51b858aacca
Fixed color and IBU method display in recipe and product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
289
diff
changeset
|
384 | $colormethod = array( 'Morey', 'Mosher', 'Daniels' ); |
a51b858aacca
Fixed color and IBU method display in recipe and product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
289
diff
changeset
|
385 | $ibumethod = array( 'Tinseth', 'Rager', 'Daniels' ); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
386 | /* 2 Columns */ |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
387 | $vul = $this->w - $this->rMargin - $this->lMargin - 170; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
388 | $cMargin=$this->cMargin; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
389 | $this->cMargin=2; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
390 | $this->TableX=$this->lMargin; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
391 | $this->SetFont('Helvetica','B',9); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
392 | $this->SetX($this->TableX); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
393 | $this->SetFillColor(255,150,100); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
394 | $this->Cell(0, 5, 'Recept samenvatting',0,0,'C',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
395 | $this->Ln(); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
396 | |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
397 | $this->SetFont('Helvetica','',9); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
398 | $this->SetFillColor(210,245,255); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
399 | |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
400 | $row['est_fg'] = estimate_fg($pSugar, $pCara, 0, 0, 0, $svg, $row['est_og']); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
401 | |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
402 | $this->SetX($this->TableX); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
403 | $this->Cell(35,5,'Start SG',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
404 | $this->Cell(25,5,sprintf("%.3f",$row['est_og']),0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
405 | $this->Cell(25,5,'('.sprintf("%.3f",$row['st_og_min']).' - '.sprintf("%.3f",$row['st_og_max']).')',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
406 | $this->Cell($vul,5,'',0,0,'L',false); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
407 | $this->Cell(35,5,'Eind SG',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
408 | $this->Cell(25,5,sprintf("%.3f",$row['est_fg']),0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
409 | $this->Cell(25,5,'('.sprintf("%.3f",$row['st_fg_min']).' - '.sprintf("%.3f",$row['st_fg_max']).')',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
410 | $this->Ln(); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
411 | |
88 | 412 | $row['est_abv'] = abvol($row['est_og'], $row['est_fg']); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
413 | $this->SetX($this->TableX); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
414 | $this->Cell(35,5,'Geschat alcohol',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
415 | $this->Cell(25,5,sprintf("%.1f",$row['est_abv']).'%',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
416 | $this->Cell(25,5,'('.sprintf("%.1f",$row['st_abv_min']).' - '.sprintf("%.1f",$row['st_abv_max']).'%)',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
417 | $this->Cell($vul,5,'',0,0,'L',false); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
418 | $this->Cell(35,5,'CO2',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
419 | $this->Cell(25,5,sprintf("%.1f",$row['est_carb']).'%',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
420 | $this->Cell(25,5,'('.sprintf("%.1f",$row['st_carb_min']).' - '.sprintf("%.1f",$row['st_carb_max']).'%)',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
421 | $this->Ln(); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
422 | |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
423 | $row['est_color'] = kw_to_ebc($row['color_method'], $colorw); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
424 | $this->SetX($this->TableX); |
338
a51b858aacca
Fixed color and IBU method display in recipe and product print pages.
Michiel Broek <mbroek@mbse.eu>
parents:
289
diff
changeset
|
425 | $this->Cell(35,5,'Kleur ('.$colormethod[$row['color_method']].')',0,0,'L',true); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
426 | $beercolor = ebc_to_color($row['est_color']); |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
427 | if ($row['est_color'] > 30) |
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
428 | $this->SetTextColor(250); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
429 | $this->SetFillColor($beercolor[0],$beercolor[1],$beercolor[2]); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
430 | $this->Cell(25,5,$row['est_color'].' EBC',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
431 | $this->Cell(25,5,'('.$row['st_color_min'].' - '.$row['st_color_max'].' EBC)',0,0,'L',true); |
89
082c23b26055
Missing Water agent costs from Brouwhulp import are now added from the imported miscs database. The printed recipe report now calculates the beer color from the ingredients. Also set during recipes import. This will later allow to set the color method for each recipe individually.
Michiel Broek <mbroek@mbse.eu>
parents:
88
diff
changeset
|
432 | $this->SetTextColor(0); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
433 | $this->SetFillColor(210,245,255); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
434 | $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:
289
diff
changeset
|
435 | $this->Cell(35,5,'Bitterheid ('.$ibumethod[$row['ibu_method']].')',0,0,'L',true); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
436 | $this->Cell(25,5,sprintf("%.0f",$row['est_ibu']).' IBU',0,0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
437 | $this->Cell(25,5,'('.$row['st_ibu_min'].' - '.$row['st_ibu_max'].' IBU)',0,0,'L',true); |
93 | 438 | $this->Ln(); |
439 | ||
440 | $this->SetX($this->TableX); | |
441 | $cost_total = $cost_fermentables + $cost_hops + $cost_miscs + $cost_yeasts; | |
442 | $this->Cell(35,5,'Kosten',0,0,'L',true); | |
443 | $this->Cell(25,5,sprintf("%.2f",$cost_total).EURO,0,0,'L',true); | |
444 | $this->Cell(25,5,sprintf("%.2f",$cost_total/$row['batch_size']).EURO.' / liter',0,0,'L',true); | |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
445 | $this->Ln(10); |
93 | 446 | |
447 | ||
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
448 | // Kostprijs per liter, calorieren |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
449 | $this->cMargin=$cMargin; |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
450 | } |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
451 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
452 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
453 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
454 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
455 | class PDF extends PDF_MySQL_Table { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
456 | function Header() { |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
457 | global $row; |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
458 | global $prdate; |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
459 | $this->Image('images/logo.png',10,6,30); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
460 | // Title |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
461 | $this->SetFont('Helvetica','B',18); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
462 | $this->SetX(45); |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
463 | $this->Cell(0,8,$row['name'],0,1,'L'); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
464 | $this->Ln(1); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
465 | $this->SetFont('Helvetica','',10); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
466 | $this->SetX(45); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
467 | $this->Cell(17,5,'Datum:',0,0,'L'); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
468 | $this->Cell(0,5,$prdate,0,1,'L'); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
469 | $this->SetX(45); |
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:
233
diff
changeset
|
470 | $this->Cell(17,5,'Stijl:',0,0,'L'); |
233
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
471 | $this->Cell(0,5,$row['st_name'],0,1,'L'); |
14a84d42031d
In recipe report added the date and beer style to the page header.
Michiel Broek <mbroek@mbse.eu>
parents:
232
diff
changeset
|
472 | $this->Ln(7); |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
473 | // Ensure table header is printed |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
474 | parent::Header(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
475 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
476 | } |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
477 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
478 | |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
479 | /* |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
480 | * Generate PDF from recipe data |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
481 | */ |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
482 | $pdf = new PDF(); |
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
483 | $pdf->AddPage(); |
83
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
484 | $pdf->TableGlobal($row); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
485 | $pdf->TableFermentables($row); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
486 | $pdf->TableHops($row); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
487 | $pdf->TableYeasts($row); |
85521c6e0022
Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents:
80
diff
changeset
|
488 | $pdf->TableMiscs($row); |
87
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
489 | $pdf->TableSummary($row); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
490 | if (strlen($row['notes'])) { |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
491 | $pdf->SetFillColor(255,150,100); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
492 | $pdf->Cell(0, 5, 'Recept opmerkingen',0,0,'C',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
493 | $pdf->Ln(); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
494 | $pdf->SetFillColor(210,245,255); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
495 | $pdf->MultiCell(0,4,$row['notes'],0,'L',true); |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
496 | } |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
497 | // Disclaimer toevoegen dat dit alleen recept ontwikkeling is. Uitkomsten zoals IBU zijn een berekende schatting. |
7f1d0abe5571
OG and FG are now calculated from the grist. The printed report has a summary an notes section at the end. The formulas are in the global formulas script.
Michiel Broek <mbroek@mbse.eu>
parents:
86
diff
changeset
|
498 | // Footer sectie met berekende/geschatte uitkomsten zoals ABV, kostprijs per liter enz. |
80
75b9227fb98c
Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
499 | $pdf->Output(); |