Fri, 13 Dec 2019 20:33:38 +0100
Added ispindel logging. Updated the documentation.
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
1 | <?php |
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
2 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/global.inc.php'); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
3 | require_once($_SERVER['DOCUMENT_ROOT'].'/includes/constants.php'); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
4 | require_once($_SERVER['DOCUMENT_ROOT'].'/fpdf/fpdf.php'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
5 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
6 | define('EURO', chr(128) ); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
7 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
8 | $link = mysqli_connect(DBASE_HOST,DBASE_USER,DBASE_PASS,DBASE_NAME); |
82
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
9 | if (! $link) { |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
10 | die('Connect Error (' . mysqli_connect_errno() . ') ' . mysqli_connect_error()); |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
11 | } |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
12 | if (! mysqli_set_charset($link, "utf8" )) { |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
13 | echo "error"; |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
14 | return 1; |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
15 | } |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
16 | |
78 | 17 | setlocale ( LC_ALL, 'nl_NL.UTF-8'); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
18 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
19 | class PDF_MySQL_Table extends FPDF |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
20 | { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
21 | protected $ProcessingTable=false; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
22 | protected $aCols=array(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
23 | protected $TableX; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
24 | protected $HeaderColor; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
25 | protected $RowColors; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
26 | protected $TotalColor; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
27 | protected $ColorIndex; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
28 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
29 | function Header() { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
30 | // Print the table header if necessary |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
31 | if ($this->ProcessingTable) |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
32 | $this->TableHeader(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
33 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
34 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
35 | function TableHeader() { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
36 | $this->SetFont('Helvetica','B',9); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
37 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
38 | $this->SetFillColor($this->HeaderColor[0],$this->HeaderColor[1],$this->HeaderColor[2]); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
39 | foreach($this->aCols as $col) |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
40 | $this->Cell($col['w'],5,$col['c'],0,0,$col['a'],true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
41 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
42 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
43 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
44 | function CalcWidths($width, $align) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
45 | // Compute the widths of the columns |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
46 | $TableWidth=0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
47 | foreach($this->aCols as $i=>$col) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
48 | $w=$col['w']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
49 | if($w==-1) |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
50 | $w=$width/count($this->aCols); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
51 | elseif(substr($w,-1)=='%') |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
52 | $w=$w/100*$width; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
53 | $this->aCols[$i]['w']=$w; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
54 | $TableWidth+=$w; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
55 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
56 | // Compute the abscissa of the table |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
57 | if($align=='C') |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
58 | $this->TableX=max(($this->w-$TableWidth)/2,0); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
59 | elseif($align=='R') |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
60 | $this->TableX=max($this->w-$this->rMargin-$TableWidth,0); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
61 | else |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
62 | $this->TableX=$this->lMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
63 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
64 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
65 | function AddCol($width=-1, $caption='', $align='L') { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
66 | $this->aCols[]=array('c'=>$caption,'w'=>$width,'a'=>$align); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
67 | } |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
68 | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
69 | function TableFermentables($link,$prop) { |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
70 | global $fermentabletype; |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
71 | $this->AddCol( 26,'Type','L'); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
72 | $this->AddCol( 26,'Leverancier','L'); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
73 | $this->AddCol( 68,'Vergistbaar ingredient','L'); |
78 | 74 | $this->AddCol( 30,'Voorraad','R'); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
75 | $this->AddCol( 20, 'Prijs/kg', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
76 | $this->AddCol( 20, 'Waarde', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
77 | $prop['width']=$this->w-$this->lMargin-$this->rMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
78 | $prop['align']='L'; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
79 | $cMargin=$this->cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
80 | $this->cMargin=$prop['padding']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
81 | $this->HeaderColor=$prop['HeaderColor']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
82 | $this->TotalColor=$prop['TotalColor']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
83 | $this->RowColors=array($prop['color1'],$prop['color2']); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
84 | $this->CalcWidths($prop['width'],$prop['align']); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
85 | $this->TableHeader(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
86 | $this->SetFont('Helvetica','',9); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
87 | $this->ColorIndex=0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
88 | $this->ProcessingTable=true; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
89 | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
90 | $sql = "SELECT type,name,supplier,inventory,cost FROM inventory_fermentables WHERE inventory > 0 ORDER BY type,supplier,name"; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
91 | $result = mysqli_query($link, $sql); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
92 | $tot_fermentables = 0.0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
93 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
94 | while($row=mysqli_fetch_array($result)) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
95 | $value = $row['inventory'] * $row['cost']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
96 | $tot_fermentables += $value; |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
97 | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
98 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
99 | $ci=$this->ColorIndex; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
100 | $this->SetFillColor($this->RowColors[$ci][0],$this->RowColors[$ci][1],$this->RowColors[$ci][2]); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
101 | $this->Cell(26,5,$fermentabletype[$row['type']],0,0,'L',true); |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
102 | $this->Cell(26,5,iconv('UTF-8','windows-1252',$row['supplier']),0,0,'L',true); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
103 | $this->Cell(68,5,iconv('UTF-8','windows-1252',$row['name']),0,0,'L',true); |
78 | 104 | $this->Cell(30,5,sprintf("%10.3f kg",$row['inventory']),0,0,'R',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
105 | $this->Cell(20,5,sprintf("%8.2f ",$row['cost']).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
106 | $this->Cell(20,5,sprintf("%8.2f ",$value).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
107 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
108 | $this->ColorIndex=1-$ci; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
109 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
110 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
111 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
112 | $this->SetFillColor($this->TotalColor[0],$this->TotalColor[1],$this->TotalColor[2]); |
78 | 113 | $this->Cell(170,5,'Totaal',0,0,'L',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
114 | $this->Cell(20,5,sprintf("%8.2f ",$tot_fermentables).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
115 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
116 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
117 | $this->ProcessingTable=false; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
118 | $this->cMargin=$cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
119 | $this->aCols=array(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
120 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
121 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
122 | function TableHops($link,$prop) { |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
123 | global $hopform; |
78 | 124 | $this->AddCol( 30,'Land','L'); |
125 | $this->AddCol( 75,'Hoppen','L'); | |
126 | $this->AddCol( 15,'Soort','L'); | |
127 | $this->AddCol( 30,'Voorraad','R'); | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
128 | $this->AddCol( 20, 'Prijs/kg', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
129 | $this->AddCol( 20, 'Waarde', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
130 | $prop['width']=$this->w-$this->lMargin-$this->rMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
131 | $prop['align']='L'; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
132 | $cMargin=$this->cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
133 | $this->cMargin=$prop['padding']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
134 | $this->CalcWidths($prop['width'],$prop['align']); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
135 | $this->TableHeader(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
136 | $this->SetFont('Helvetica','',9); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
137 | $this->ColorIndex=0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
138 | $this->ProcessingTable=true; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
139 | |
78 | 140 | $result = mysqli_query($link, "SELECT name,form,origin,inventory,cost FROM inventory_hops WHERE inventory > 0 ORDER BY origin,name"); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
141 | $tot_hops = 0.0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
142 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
143 | while($row=mysqli_fetch_array($result)) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
144 | $value = $row['inventory'] * $row['cost']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
145 | $tot_hops += $value; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
146 | $stock = floatval($row['inventory']) * 1000.0; |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
147 | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
148 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
149 | $ci=$this->ColorIndex; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
150 | $this->SetFillColor($this->RowColors[$ci][0],$this->RowColors[$ci][1],$this->RowColors[$ci][2]); |
82
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
151 | $this->Cell(30,5,iconv('UTF-8','windows-1252',$row['origin']),0,0,'L',true); |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
152 | $this->Cell(75,5,iconv('UTF-8','windows-1252',$row['name']),0,0,'L',true); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
153 | $this->Cell(15,5,$hopform[$row['form']],0,0,'L',true); |
78 | 154 | $this->Cell(30,5,sprintf("%10.1f gr",$stock),0,0,'R',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
155 | $this->Cell(20,5,sprintf("%8.2f ",$row['cost']).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
156 | $this->Cell(20,5,sprintf("%8.2f ",$value).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
157 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
158 | $this->ColorIndex=1-$ci; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
159 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
160 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
161 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
162 | $this->SetFillColor($this->TotalColor[0],$this->TotalColor[1],$this->TotalColor[2]); |
78 | 163 | $this->Cell(170,5,'Totaal',0,0,'L',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
164 | $this->Cell(20,5,sprintf("%8.2f ",$tot_hops).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
165 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
166 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
167 | $this->ProcessingTable=false; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
168 | $this->cMargin=$cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
169 | $this->aCols=array(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
170 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
171 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
172 | function TableYeasts($link,$prop) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
173 | $this->AddCol( 30,'Laboratorium','L'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
174 | $this->AddCol( 20,'Product','L'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
175 | $this->AddCol( 70,'Gist','L'); |
78 | 176 | $this->AddCol( 30,'Voorraad','R'); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
177 | $this->AddCol( 20, 'Prijs/kg', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
178 | $this->AddCol( 20, 'Waarde', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
179 | $prop['width']=$this->w-$this->lMargin-$this->rMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
180 | $prop['align']='L'; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
181 | $cMargin=$this->cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
182 | $this->cMargin=$prop['padding']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
183 | $this->CalcWidths($prop['width'],$prop['align']); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
184 | $this->TableHeader(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
185 | $this->SetFont('Helvetica','',9); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
186 | $this->ColorIndex=0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
187 | $this->ProcessingTable=true; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
188 | |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
189 | $sql = "SELECT name,laboratory,product_id,form,inventory,cost FROM inventory_yeasts WHERE inventory > 0 ORDER BY laboratory,product_id"; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
190 | $result = mysqli_query($link, $sql); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
191 | $tot_yeasts = 0.0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
192 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
193 | while($row=mysqli_fetch_array($result)) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
194 | $value = $row['inventory'] * $row['cost']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
195 | $tot_yeasts += $value; |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
196 | if ($row['form'] == 0) |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
197 | $stock = floatval($row['inventory']); |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
198 | else |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
199 | $stock = floatval($row['inventory']) * 1000.0; |
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
200 | $form = array( 'pak', 'gr', 'ml', 'ml', 'ml', 'ml' ); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
201 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
202 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
203 | $ci=$this->ColorIndex; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
204 | $this->SetFillColor($this->RowColors[$ci][0],$this->RowColors[$ci][1],$this->RowColors[$ci][2]); |
82
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
205 | $this->Cell(30,5,iconv('UTF-8','windows-1252',$row['laboratory']),0,0,'L',true); |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
206 | $this->Cell(20,5,iconv('UTF-8','windows-1252',$row['product_id']),0,0,'L',true); |
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
207 | $this->Cell(70,5,iconv('UTF-8','windows-1252',$row['name']),0,0,'L',true); |
209
dc30801e6961
Import set tun_material from the specifix heat value. Equipment database uses POST instead of GET. Equipment editor screen in style with other inventory screens. In stock print now uses the type indexes to translate to text. Also show the correct unit and values of the yeast.
Michiel Broek <mbroek@mbse.eu>
parents:
82
diff
changeset
|
208 | $this->Cell(30,5,sprintf("%10.1f ",$stock).$form[$row['form']],0,0,'R',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
209 | $this->Cell(20,5,sprintf("%8.2f ",$row['cost']).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
210 | $this->Cell(20,5,sprintf("%8.2f ",$value).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
211 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
212 | $this->ColorIndex=1-$ci; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
213 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
214 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
215 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
216 | $this->SetFillColor($this->TotalColor[0],$this->TotalColor[1],$this->TotalColor[2]); |
78 | 217 | $this->Cell(170,5,'Totaal',0,0,'L',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
218 | $this->Cell(20,5,sprintf("%8.2f ",$tot_yeasts).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
219 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
220 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
221 | $this->ProcessingTable=false; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
222 | $this->cMargin=$cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
223 | $this->aCols=array(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
224 | } |
33
2ee6ad5d6f14
More weight/volmes standards in the database.
Michiel Broek <mbroek@mbse.eu>
parents:
30
diff
changeset
|
225 | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
226 | function TableMiscs($link,$prop) { |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
227 | global $misctype; |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
228 | $this->AddCol( 30,'Type','L'); |
78 | 229 | $this->AddCol( 90,'Ingredient','L'); |
230 | $this->AddCol( 30,'Voorraad','R'); | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
231 | $this->AddCol( 20, 'Prijs/kg', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
232 | $this->AddCol( 20, 'Waarde', 'R'); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
233 | $prop['width']=$this->w-$this->lMargin-$this->rMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
234 | $prop['align']='L'; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
235 | $cMargin=$this->cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
236 | $this->cMargin=$prop['padding']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
237 | $this->CalcWidths($prop['width'],$prop['align']); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
238 | $this->TableHeader(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
239 | $this->SetFont('Helvetica','',9); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
240 | $this->ColorIndex=0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
241 | $this->ProcessingTable=true; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
242 | |
78 | 243 | $result = mysqli_query($link, "SELECT name,type,amount_is_weight,inventory,cost FROM inventory_miscs WHERE inventory > 0 ORDER BY type,name"); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
244 | $tot_miscs = 0.0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
245 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
246 | while($row=mysqli_fetch_array($result)) { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
247 | $value = $row['inventory'] * $row['cost']; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
248 | $tot_miscs += $value; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
249 | $stock = floatval($row['inventory']) * 1000.0; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
250 | ($row['amount_is_weight']) ? $amount = "gr" : $amount = "ml"; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
251 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
252 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
253 | $ci=$this->ColorIndex; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
254 | $this->SetFillColor($this->RowColors[$ci][0],$this->RowColors[$ci][1],$this->RowColors[$ci][2]); |
514
3c680d1dea35
Added dutch array strings to a global php script. Changed fermentables, hops, yeast and misc inventory scripts to use these strings between the database scripts and javascript scripts. This makes filtering on types strings useable. Added these changes to the product/recipe forum and print exports too.
Michiel Broek <mbroek@mbse.eu>
parents:
209
diff
changeset
|
255 | $this->Cell(30,5,$misctype[$row['type']],0,0,'L',true); |
82
7af1d472475a
Inventory PDF now properly handles UTF8 encoding.
Michiel Broek <mbroek@mbse.eu>
parents:
78
diff
changeset
|
256 | $this->Cell(90,5,iconv('UTF-8','windows-1252',$row['name']),0,0,'L',true); |
78 | 257 | $this->Cell(30,5,sprintf("%10.1f ",$stock).$amount,0,0,'R',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
258 | $this->Cell(20,5,sprintf("%8.2f ",$row['cost']).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
259 | $this->Cell(20,5,sprintf("%8.2f ",$value).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
260 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
261 | $this->ColorIndex=1-$ci; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
262 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
263 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
264 | $this->SetX($this->TableX); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
265 | $this->SetFillColor($this->TotalColor[0],$this->TotalColor[1],$this->TotalColor[2]); |
78 | 266 | $this->Cell(170,5,'Totaal',0,0,'L',true); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
267 | $this->Cell(20,5,sprintf("%8.2f ",$tot_miscs).EURO,0,0,'R',true); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
268 | $this->Ln(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
269 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
270 | $this->ProcessingTable=false; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
271 | $this->cMargin=$cMargin; |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
272 | $this->aCols=array(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
273 | } |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
274 | } |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
275 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
276 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
277 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
278 | class PDF extends PDF_MySQL_Table { |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
279 | function Header() { |
78 | 280 | $this->Image('images/logo.png',10,6,30); |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
281 | // Title |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
282 | $this->SetFont('Helvetica','',18); |
78 | 283 | $this->Cell(0,10,'Inventaris',0,1,'C'); |
284 | $this->Ln(20); | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
285 | // Ensure table header is printed |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
286 | parent::Header(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
287 | } |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
288 | } |
30
f5ab22446aa5
Inventory fermentables and hops to standard weight format.
Michiel Broek <mbroek@mbse.eu>
parents:
diff
changeset
|
289 | |
77
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
290 | |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
291 | $pdf = new PDF(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
292 | $pdf->AddPage(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
293 | $prop = array('HeaderColor'=>array(255,150,100), 'color1'=>array(210,245,255), |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
294 | 'color2'=>array(255,255,210), 'TotalColor'=>array(255,150,100), 'padding'=>2); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
295 | $pdf->TableFermentables($link,$prop); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
296 | $pdf->Ln(10); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
297 | $pdf->TableHops($link,$prop); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
298 | $pdf->AddPage(); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
299 | $pdf->TableYeasts($link,$prop); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
300 | $pdf->Ln(10); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
301 | $pdf->TableMiscs($link,$prop); |
a9f8de2d7b2b
Fixed most charset problems. Added fpdf library. Added inventory pdf creation.
Michiel Broek <mbroek@mbse.eu>
parents:
33
diff
changeset
|
302 | $pdf->Output(); |