www/inv_yeastlab.php

Sat, 23 May 2020 20:53:48 +0200

author
Michiel Broek <mbroek@mbse.eu>
date
Sat, 23 May 2020 20:53:48 +0200
changeset 691
9c21125f584e
parent 630
ffe0416614b3
permissions
-rw-r--r--

Added clone command to the equipment inventory.

626
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
1 <?php
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
2 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
3 require_once($_SERVER['DOCUMENT_ROOT'].'/includes/constants.php');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
4 require_once($_SERVER['DOCUMENT_ROOT'].'/fpdf/fpdf.php');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
5
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
6 define('EURO', chr(128) );
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
7
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
8 $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
9 if (! $link) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
10 die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error());
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
11 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
12 if (! mysqli_set_charset($link, "utf8" )) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
13 echo "error";
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
14 return 1;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
15 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
16
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
17 setlocale ( LC_ALL, 'nl_NL.UTF-8');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
18 date_default_timezone_set('Europe/Amsterdam');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
19 $prdate = date(DATE_RFC2822);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
20
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
21 $sql = "SELECT brewery_name,my_yeastlab FROM profile_setup WHERE record = '1';";
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
22 $result = mysqli_query($link, $sql);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
23 if ($row=mysqli_fetch_array($result)) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
24 $my_brewery = iconv('UTF-8','windows-1252',$row['brewery_name']);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
25 $my_lab = $row['my_yeastlab'];
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
26 } else {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
27 $my_brewery = $my_lab = '';
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
28 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
29
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
30
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
31 class PDF_MySQL_Table extends FPDF
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
32 {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
33 protected $ProcessingTable=false;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
34 protected $aCols=array();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
35 protected $TableX;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
36 protected $HeaderColor;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
37 protected $RowColors;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
38 protected $TotalColor;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
39 protected $ColorIndex;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
40
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
41 function Header() {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
42 // Print the table header if necessary
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
43 if ($this->ProcessingTable)
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
44 $this->TableHeader();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
45 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
46
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
47 function TableHeader() {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
48 $this->SetFont('Helvetica','B',9);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
49 $this->SetX($this->TableX);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
50 $this->SetFillColor($this->HeaderColor[0],$this->HeaderColor[1],$this->HeaderColor[2]);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
51 foreach($this->aCols as $col)
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
52 $this->Cell($col['w'],5,$col['c'],0,0,$col['a'],true);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
53 $this->Ln();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
54 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
55
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
56 function CalcWidths($width, $align) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
57 // Compute the widths of the columns
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
58 $TableWidth=0;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
59 foreach($this->aCols as $i=>$col) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
60 $w=$col['w'];
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
61 if($w==-1)
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
62 $w=$width/count($this->aCols);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
63 elseif(substr($w,-1)=='%')
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
64 $w=$w/100*$width;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
65 $this->aCols[$i]['w']=$w;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
66 $TableWidth+=$w;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
67 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
68 // Compute the abscissa of the table
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
69 if($align=='C')
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
70 $this->TableX=max(($this->w-$TableWidth)/2,0);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
71 elseif($align=='R')
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
72 $this->TableX=max($this->w-$this->rMargin-$TableWidth,0);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
73 else
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
74 $this->TableX=$this->lMargin;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
75 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
76
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
77 function AddCol($width=-1, $caption='', $align='L') {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
78 $this->aCols[]=array('c'=>$caption,'w'=>$width,'a'=>$align);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
79 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
80
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
81 function TableYeasts($link,$prop) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
82 global $yeasttype;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
83 global $yeastform;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
84 global $my_lab;
630
ffe0416614b3 Added short_desc to the yeast inventory database for short remarks in the yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents: 626
diff changeset
85 $this->AddCol( 60,'Gist','L');
ffe0416614b3 Added short_desc to the yeast inventory database for short remarks in the yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents: 626
diff changeset
86 $this->AddCol( 50,'Omschrijving','L');
626
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
87 $this->AddCol( 18,'Soort','L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
88 $this->AddCol( 18,'Vorm','L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
89 $this->AddCol( 20,'Voorraad','R');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
90 $this->AddCol( 25,'Datum','L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
91 $prop['width']=$this->w-$this->lMargin-$this->rMargin;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
92 $prop['align']='L';
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
93 $cMargin=$this->cMargin;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
94 $this->cMargin=$prop['padding'];
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
95 $this->HeaderColor=$prop['HeaderColor'];
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
96 $this->TotalColor=$prop['TotalColor'];
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
97 $this->RowColors=array($prop['color1'],$prop['color2']);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
98 $this->CalcWidths($prop['width'],$prop['align']);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
99 $this->TableHeader();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
100 $this->SetFont('Helvetica','',9);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
101 $this->ColorIndex=0;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
102 $this->ProcessingTable=true;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
103
630
ffe0416614b3 Added short_desc to the yeast inventory database for short remarks in the yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents: 626
diff changeset
104 $sql = "SELECT name,type,form,inventory,production_date,short_desc FROM inventory_yeasts ";
626
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
105 $sql .= "WHERE inventory > 0 AND laboratory = '".$my_lab."' ORDER BY product_id";
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
106 $result = mysqli_query($link, $sql);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
107
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
108 while ($row=mysqli_fetch_array($result)) {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
109 if ($row['form'] == 0)
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
110 $stock = floatval($row['inventory']);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
111 else
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
112 $stock = floatval($row['inventory']) * 1000.0;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
113 $form = array( 'pak', 'gr', 'ml', 'ml', 'ml', 'ml', 'gr' );
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
114
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
115 $this->SetX($this->TableX);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
116 $ci=$this->ColorIndex;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
117 $this->SetFillColor($this->RowColors[$ci][0],$this->RowColors[$ci][1],$this->RowColors[$ci][2]);
630
ffe0416614b3 Added short_desc to the yeast inventory database for short remarks in the yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents: 626
diff changeset
118 $this->Cell(60,5,iconv('UTF-8','windows-1252',$row['name']),0,0,'L',true);
ffe0416614b3 Added short_desc to the yeast inventory database for short remarks in the yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents: 626
diff changeset
119 $this->Cell(50,5,iconv('UTF-8','windows-1252',$row['short_desc']),0,0,'L',true);
626
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
120 $this->Cell(18,5,iconv('UTF-8','windows-1252',$yeasttype[$row['type']]),0,0,'L',true);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
121 $this->Cell(18,5,iconv('UTF-8','windows-1252',$yeastform[$row['form']]),0,0,'L',true);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
122 $this->Cell(20,5,sprintf("%10.1f ",$stock).$form[$row['form']],0,0,'R',true);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
123 $this->Cell(25,5,$row['production_date'],0,0,'L',true);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
124 $this->Ln();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
125 $this->ColorIndex=1-$ci;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
126 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
127
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
128 $this->ProcessingTable=false;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
129 $this->cMargin=$cMargin;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
130 $this->aCols=array();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
131 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
132 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
133
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
134
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
135
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
136 class PDF extends PDF_MySQL_Table {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
137 function Header() {
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
138 global $prdate;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
139 global $my_brewery;
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
140 $this->Image('images/logo.png',10,6,30);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
141 // Title
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
142 $this->SetFont('Helvetica','',18);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
143 $this->SetX(45);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
144 $this->Cell(0,10,'Gistbank van '.$my_brewery,0,1,'L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
145 $this->Ln(1);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
146 $this->SetFont('Helvetica','',10);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
147 $this->SetX(45);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
148 $this->Cell(17,5,'Datum:',0,0,'L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
149 $this->Cell(0,5,$prdate,0,1,'L');
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
150 $this->Ln(18);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
151 // Ensure table header is printed
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
152 parent::Header();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
153 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
154 }
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
155
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
156
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
157 $pdf = new PDF();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
158 $pdf->AddPage();
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
159 $prop = array('HeaderColor'=>array(255,150,100), 'color1'=>array(210,245,255),
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
160 'color2'=>array(255,255,210), 'TotalColor'=>array(255,150,100), 'padding'=>2);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
161 $pdf->TableYeasts($link,$prop);
571473f62c1e Added private yeastlab pdf list
Michiel Broek <mbroek@mbse.eu>
parents:
diff changeset
162 $pdf->Output();

mercurial