www/rec_print.php

Sat, 10 Nov 2018 20:56:07 +0100

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 10 Nov 2018 20:56:07 +0100
changeset 84
3e5e87f1818d
parent 83
85521c6e0022
child 85
ca7a37586551
permissions
-rw-r--r--

Added miscs ingredients to the recipe print.

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;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
27
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29 class PDF_MySQL_Table extends FPDF
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30 {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
31 protected $ProcessingTable=false;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 protected $aCols=array();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33 protected $TableX;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
34
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
35 function Header() {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
36 // Print the table header if necessary
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
37 if ($this->ProcessingTable)
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
38 $this->TableHeader();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
39 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
40
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41 function TableHeader() {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
42 $this->SetFont('Helvetica','B',9);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 $this->SetX($this->TableX);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
44 $this->SetFillColor(255,150,100);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 foreach($this->aCols as $col)
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46 $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
47 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50 function AddCol($width=-1, $caption='', $align='L') {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 $this->aCols[]=array('c'=>$caption,'w'=>$width,'a'=>$align);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
54 function TableGlobal($row) {
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55 /* 2 Columns */
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 $vul = $this->w - $this->rMargin - $this->lMargin - 170;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 $cMargin=$this->cMargin;
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
58 $this->cMargin=2;
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 $this->TableX=$this->lMargin;
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
60 $this->SetFont('Helvetica','B',9);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 $this->SetX($this->TableX);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
62 $this->SetFillColor(255,150,100);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
63 $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
64 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 $this->SetFont('Helvetica','',9);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
67 $this->SetFillColor(210,245,255);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 $this->SetX($this->TableX);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 $this->Cell(35,5,'Type',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 $this->Cell(25,5,$row['type'],0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 $this->Cell(25,5,'',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 $this->Cell($vul,5,'',0,0,'L',false);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 $this->Cell(35,5,'Batch grootte',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 $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
76 $this->Cell(25,5,'',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 $this->SetX($this->TableX);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80 $this->Cell(35,5,'Kooktijd',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 $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
82 $this->Cell(25,5,'',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 $this->Cell($vul,5,'',0,0,'L',false);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 $this->Cell(35,5,'Brouwzaal rendement',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
85 $this->Cell(25,5,$row['efficiency'].' %',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
86 $this->Cell(25,5,'',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 $this->SetX($this->TableX);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 $this->Cell(35,5,'Start SG',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 $this->Cell(25,5,sprintf("%.3f",$row['est_og']),0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 $this->Cell(25,5,'('.sprintf("%.3f",$row['st_og_min']).' - '.sprintf("%.3f",$row['st_og_max']).')',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 $this->Cell($vul,5,'',0,0,'L',false);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 $this->Cell(35,5,'Eind SG',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 $this->Cell(25,5,sprintf("%.3f",$row['est_fg']),0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 $this->Cell(25,5,'('.sprintf("%.3f",$row['st_fg_min']).' - '.sprintf("%.3f",$row['st_fg_max']).')',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 $this->SetX($this->TableX);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 $this->Cell(35,5,'Geschat alcohol',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 $this->Cell(25,5,sprintf("%.1f",$row['est_abv']).'%',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102 $this->Cell(25,5,'('.sprintf("%.1f",$row['st_abv_min']).' - '.sprintf("%.1f",$row['st_abv_max']).'%)',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103 $this->Cell($vul,5,'',0,0,'L',false);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
104 $this->Cell(35,5,'CO2',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 $this->Cell(25,5,sprintf("%.1f",$row['est_carb']).'%',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
106 $this->Cell(25,5,'('.sprintf("%.1f",$row['st_carb_min']).' - '.sprintf("%.1f",$row['st_carb_max']).'%)',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
107 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
109 $this->SetX($this->TableX);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
110 $this->Cell(35,5,'Kleur ('.$row['color_method'].')',0,0,'L',true);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
111 $beercolor = ebc_to_color($row['est_color']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
112 $this->SetFillColor($beercolor[0],$beercolor[1],$beercolor[2]);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
113 $this->Cell(25,5,$row['est_color'].' EBC',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
114 $this->Cell(25,5,'('.$row['st_color_min'].' - '.$row['st_color_max'].' EBC)',0,0,'L',true);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
115 $this->SetFillColor(210,245,255);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
116 $this->Cell($vul,5,'',0,0,'L',false);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
117 $this->Cell(35,5,'Bitterheid ('.$row['ibu_method'].')',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
118 $this->Cell(25,5,sprintf("%.0f",$row['est_ibu']).' IBU',0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
119 $this->Cell(25,5,'('.$row['st_ibu_min'].' - '.$row['st_ibu_max'].' IBU)',0,0,'L',true);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
120 $this->Ln(10);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
121
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
122 $this->cMargin=$cMargin;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
123 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
124
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
125 function TableFermentables($row) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
126 global $cost_fermentables;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
127 global $total_fermentables;
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
128 $vul = $this->w - $this->rMargin - $this->lMargin - 132;
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
129 $this->AddCol($vul,'Grondstof','L');
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
130 $this->AddCol(30,'Leverancier','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
131 $this->AddCol(15,'EBC','R');
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
132 $this->AddCol(17,'Moment','L');
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
133 $this->AddCol(20,'Kg','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
134 $this->AddCol(15,'Procent','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
135 $this->AddCol(15,'Opbr.','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
136 $this->AddCol(20,'Prijs','R');
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
137
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
138 $cMargin=$this->cMargin;
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
139 $this->cMargin=2;
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
140 $this->TableX=$this->lMargin;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
141 $this->TableHeader();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
142 $this->ProcessingTable=true;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
143
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
144 $this->SetFont('Helvetica','',9);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
145 $this->SetFillColor(250, 195, 65);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
146
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
147 $arr = json_decode($row['json_fermentables'], true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
148 foreach($arr as $item) { //foreach element in $arr
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
149 $name = iconv('UTF-8','windows-1252',$item['f_name']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
150 $supplier = iconv('UTF-8','windows-1252',$item['f_supplier']);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
151 $added = iconv('UTF-8','windows-1252',$item['f_added']);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
152 $amount = floatval($item['f_amount']);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
153 $costkg = floatval($item['f_cost']);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
154 $yield = floatval($item['f_yield']);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
155 $color = floatval($item['f_color']);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
156 $percent = floatval($item['f_percentage']);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
157 $cost = $amount * $costkg;
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
158 $cost_fermentables += $cost;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
159 $total_fermentables += $amount;
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
160 $this->Cell($vul,5,$name,0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
161 $this->Cell(30,5,$supplier,0,0,'L',true);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
162 $this->Cell(15,5,sprintf("%.0f",$color),0,0,'R',true);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
163 $this->Cell(17,5,added_type_names($added),0,0,'L',true);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
164 $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
165 $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
166 $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
167 $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
168 $this->Ln();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
169 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
170
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
171 $this->SetFillColor(210,245,255);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
172 $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
173 $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
174 $this->Cell(30,5,'',0,0,'L',false);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
175 $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
176 $this->Ln(10);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
177 $this->ProcessingTable=false;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
178 $this->cMargin=$cMargin;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
179 $this->aCols=array();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
180 }
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
181
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
182 function TableHops($row) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
183 global $total_hops;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
184 global $cost_hops;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
185 $vul = $this->w - $this->rMargin - $this->lMargin - 135;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
186 $this->AddCol($vul,'Hop','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
187 $this->AddCol(35,'Land','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
188 $this->AddCol(15,'Soort','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
189 $this->AddCol(20,'Moment','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
190 $this->AddCol(15,'Alpha','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
191 $this->AddCol(12,'IBU','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
192 $this->AddCol(18,'Gram','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
193 $this->AddCol(20,'Prijs','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
194
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
195 $cMargin=$this->cMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
196 $this->cMargin=2;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
197 $this->TableX=$this->lMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
198 $this->TableHeader();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
199 $this->ProcessingTable=true;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
200
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
201 $this->SetFont('Helvetica','',9);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
202 $this->SetFillColor(100, 250, 65);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
203
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
204 $arr = json_decode($row['json_hops'], true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
205 foreach($arr as $item) { //foreach element in $arr
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
206 $name = iconv('UTF-8','windows-1252',$item['h_name']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
207 $origin = iconv('UTF-8','windows-1252',$item['h_origin']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
208 $useat = iconv('UTF-8','windows-1252',$item['h_useat']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
209 $form = iconv('UTF-8','windows-1252',$item['h_form']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
210 $amount = floatval($item['h_amount']) * 1000;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
211 $mass = $amount;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
212 $costkg = floatval($item['h_cost']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
213 $time = floatval($item['h_time']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
214 $alpha = floatval($item['h_alpha']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
215
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
216 $cost = ($amount * $costkg) / 1000;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
217 $cost_hops += $cost;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
218 $total_hops += $amount;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
219
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
220 $fmoment = 1.0;
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
221 $moment = hop_useat_names($useat);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
222 if (($useat == "Dry Hop") || ($useat == "Dry hop")) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
223 $fmoment = 0.0;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
224 } else if ($useat == "Whirlpool") {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
225 $fmoment = 0.0;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
226 } else if ($useat == "Mash") {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
227 $fmoment = 0.7; // Brouwhulp
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
228 } else if (($useat == "First Wort") || ($useat == "First wort")) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
229 $fmoment = 1.1; // Brouwhulp, Louis, Ozzie
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
230 } else if ($useat == "Aroma") {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
231 $fmoment = 0.0; // Brouwhulp 1.0 redeneert vlamuit.
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
232 } else if ($useat == "Boil") {
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
233 $fmoment = 1.0;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
234 $moment = "Kook@".$time;
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
235 }
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
236
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
237 $pfactor = 1.0;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
238 if ($form == "Pellet") {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
239 $pfactor = 1.1;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
240 }
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
241
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
242 /* Tinseth only for now */
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
243 $AddedAlphaAcids = (($alpha / 100) * $mass * 1000) / floatval($row['batch_size']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
244 $Bigness_factor = 1.65 * pow( 0.000125, floatval($row['est_og']) - 1);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
245 $BoilTime_factor = ((1 - exp(-0.04 * $time)) / 4.15);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
246 $utiisation = $Bigness_factor * $BoilTime_factor;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
247 $ibu = (round($utiisation * $AddedAlphaAcids * $fmoment * $pfactor * 10) / 10.0);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
248
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
249 $this->Cell($vul,5,$name,0,0,'L',true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
250 $this->Cell(35,5,$origin,0,0,'L',true);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
251 $this->Cell(15,5,hop_form_names($form),0,0,'L',true);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
252 $this->Cell(20,5,$moment,0,0,'L',true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
253 $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
254 $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
255 $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
256 $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
257 $this->Ln();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
258 }
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
259
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
260 $this->SetFillColor(210,245,255);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
261 $this->Cell($vul+97,5,'',0,0,'L',false);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
262 $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
263 $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
264 $this->Ln(10);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
265 $this->ProcessingTable=false;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
266 $this->cMargin=$cMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
267 $this->aCols=array();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
268 }
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 function TableYeasts($row) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
271 global $cost_yeasts;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
272 $vul = $this->w - $this->rMargin - $this->lMargin - 140;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
273 $this->AddCol(27,'Laboratorium','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
274 $this->AddCol(18,'Product','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
275 $this->AddCol($vul,'Gist','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
276 $this->AddCol(20,'Gebruik','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
277 $this->AddCol(15,'Attn','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
278 $this->AddCol(22,'Vorm','L');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
279 $this->AddCol(18,'Gram','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
280 $this->AddCol(20,'Prijs','R');
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
281
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
282 $cMargin=$this->cMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
283 $this->cMargin=2;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
284 $this->TableX=$this->lMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
285 $this->TableHeader();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
286 $this->ProcessingTable=true;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
287
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
288 $this->SetFont('Helvetica','',9);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
289 $this->SetFillColor(175, 175, 255);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
290 $svg = 70; /* Conservative SVG% as default */
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
291
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
292 $arr = json_decode($row['json_yeasts'], true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
293 foreach($arr as $item) { //foreach element in $arr
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
294 $name = iconv('UTF-8','windows-1252',$item['y_name']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
295 $laboratory = iconv('UTF-8','windows-1252',$item['y_laboratory']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
296 $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
297 $form = iconv('UTF-8','windows-1252',$item['y_form']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
298 $use = iconv('UTF-8','windows-1252',$item['y_use']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
299 $amount = floatval($item['y_amount']) * 1000;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
300 $costg = floatval($item['y_cost']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
301 $attenuation = floatval($item['y_attenuation']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
302 $cost = $amount * $costg;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
303 $cost_yeasts += $cost;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
304
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
305 if ($use == "Primary")
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
306 $svg = $attenuation;
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 $this->Cell(27,5,$laboratory,0,0,'L',true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
309 $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
310 $this->Cell($vul,5,$name,0,0,'L',true);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
311 $this->Cell(20,5,yeast_use_names($use),0,0,'L',true);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
312 $this->Cell(15,5,sprintf("%.1f%%",$attenuation),0,0,'R',true);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
313 $this->Cell(22,5,yeast_form_names($form),0,0,'L',true);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
314 $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
315 $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
316 $this->Ln();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
317 }
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
318
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
319 $this->SetFillColor(210,245,255);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
320 $this->Cell($vul+120,5,'',0,0,'L',false);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
321 $this->Cell(20,5,sprintf("%8.3f",$cost_yeasts).EURO,0,0,'R',true);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
322 $this->Ln();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
323
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
324 $og = floatval($row['est_og']);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
325 $fg = $og - ($svg * ($og - 1.0)) / 100;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
326 $this->Cell(0,5,'FG: '.sprintf("%5.3f",$fg),0,0,'L',false);
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
327 $this->Ln(10);
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
328 $this->ProcessingTable=false;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
329 $this->cMargin=$cMargin;
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
330 $this->aCols=array();
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
331 }
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
332
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
333 function TableMiscs($row) {
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
334 global $cost_miscs;
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
335 $vul = $this->w - $this->rMargin - $this->lMargin - 95;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
336 $this->AddCol($vul,'Naam','L');
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
337 $this->AddCol(30,'Soort','L');
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
338 $this->AddCol(25,'Gebruik','L');
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
339 $this->AddCol(20,'Hoeveel','R');
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
340 $this->AddCol(20,'Prijs','R');
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
341
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
342 $cMargin=$this->cMargin;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
343 $this->cMargin=2;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
344 $this->TableX=$this->lMargin;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
345 $this->TableHeader();
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
346 $this->ProcessingTable=true;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
347
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
348 $this->SetFont('Helvetica','',9);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
349 $this->SetFillColor(175, 175, 255);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
350
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
351 $arr = json_decode($row['json_miscs'], true);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
352 foreach($arr as $item) {
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
353 $name = iconv('UTF-8','windows-1252',$item['m_name']);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
354 $type = iconv('UTF-8','windows-1252',$item['m_type']);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
355 $use_use = iconv('UTF-8','windows-1252',$item['m_use_use']);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
356 $amount = floatval($item['m_amount']) * 1000;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
357 $costg = floatval($item['m_cost']) / 1000;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
358 $time = floatval($item['m_time']);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
359 $aiw = $item['m_amount_is_weight'];
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
360 $cost = $amount * $costg;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
361 $cost_miscs += $cost;
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 if ($type == "Water agent")
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
364 $this->SetFillColor(240,140,130);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
365 else if ($type == "Fining")
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
366 $this->SetFillColor(95,180,25);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
367 else if (($type == "Spice") || ($type == "Herb") || ($type == "Flavor") || ($type == "Yeast nutrient"))
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
368 $this->SetFillColor(240,250,65);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
369 else
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
370 $this->SetFillColor(210,245,255);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
371
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
372 if ($use_use == "Boil")
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
373 $gebruik = sprintf("%s %d min",misc_use_names($use_use),$time);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
374 else
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
375 $gebruik = misc_use_names($use_use);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
376
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
377 $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
378 $this->Cell($vul,5,$name,0,0,'L',true);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
379 $this->Cell(30,5,misc_type_names($type),0,0,'L',true);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
380 $this->Cell(25,5,$gebruik,0,0,'L',true);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
381 $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
382 $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
383 $this->Ln();
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
384 }
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
385
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
386 $this->SetFillColor(210,245,255);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
387 $this->Cell($vul+75,5,'',0,0,'L',false);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
388 $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
389 $this->Ln(10);
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
390
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
391 $this->ProcessingTable=false;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
392 $this->cMargin=$cMargin;
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
393 $this->aCols=array();
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
394 }
84
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
395
3e5e87f1818d Added miscs ingredients to the recipe print.
Michiel Broek <mbroek@mbse.eu>
parents: 83
diff changeset
396 // Watercolor $this->SetFillColor(120,255,250);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
397 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
398
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
399
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
400
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
401 class PDF extends PDF_MySQL_Table {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
402 function Header() {
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
403 global $row;
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
404 $this->Image('images/logo.png',10,6,30);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
405 // Title
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
406 $this->SetFont('Helvetica','B',18);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
407 $this->SetX(45);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
408 $this->Cell(0,8,$row['name'],1,1,'L');
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
409 $this->Ln(20);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
410 // Ensure table header is printed
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
411 parent::Header();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
412 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
413 }
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
414
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
415
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
416 /*
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
417 * Generate PDF from recipe data
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
418 */
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
419 $pdf = new PDF();
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
420 $pdf->AddPage();
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
421 $pdf->TableGlobal($row);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
422 $pdf->TableFermentables($row);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
423 $pdf->TableHops($row);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
424 $pdf->TableYeasts($row);
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
425 $pdf->TableMiscs($row);
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
426
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
427 //$pdf->SetFont('Helvetica','',10);
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
428 //$pdf->Cell(0,10,'Receptje '.$record,0,1,'C');
83
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
429 // Disclaimer toeveogen dat dit alleen recept ontwikkeling is.
85521c6e0022 Added recipe print yeasts section.
Michiel Broek <mbroek@mbse.eu>
parents: 80
diff changeset
430 // Footer sectie met berekende/geschatte uitkomsten zoals FG, ABV, kostprijs per liter enz.
80
75b9227fb98c Added beginning of recipe print.
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
431 $pdf->Output();

mercurial