001.
<?php
002.
003.
@session_start();
004.
include
(
"mpdf.php"
);
005.
006.
$user_id
=
$_SESSION
[user_id];
007.
$role
=
$_SESSION
[role];
008.
$company_id
=
$_SESSION
[company_id];
009.
$user_level
=
$_SESSION
[user_level];
010.
011.
if
(
$user_id
==NULL){
012.
013.
header(
'location: login.php'
);
014.
exit
();
015.
}
016.
017.
018.
019.
020.
021.
022.
023.
024.
025.
026.
027.
028.
029.
030.
031.
032.
$start_date
=
$_POST
[
"hide_date_start"
];
033.
$end_date
=
$_POST
[
"hide_date_end"
];
034.
$company
=
$_POST
[
"hide_company"
];
035.
$factor
=
$_POST
[
"hide_factor"
];
036.
037.
038.
039.
040.
$status
=
$_POST
[
"hide_status"
];
041.
$str_search
=
$_POST
[
"hide_str_search"
];
042.
$type_action
=
str_replace
(
"%20"
,
" "
,
$_POST
[
"hide_type_action"
]);
043.
$sel_cause
=
$_POST
[
"hide_sel_root"
];
044.
045.
$staff
=
$_POST
[
"hide_sel_staff"
];
046.
?>
047.
<?php
048.
049.
050.
051.
$mpdf
=
new
mPDF(
'win-1252'
,
'A4'
,
''
,
''
,20,15,48,25,10,10);
052.
$mpdf
->useOnlyCoreFonts = true;
053.
$mpdf
->SetProtection(
array
(
'print'
));
054.
$mpdf
->SetTitle(
"Acme Trading Co. - Invoice"
);
055.
$mpdf
->SetAuthor(
"Acme Trading Co."
);
056.
$mpdf
->SetWatermarkText(
"ITA Report"
);
057.
$mpdf
->showWatermarkText = true;
058.
$mpdf
->watermark_font =
'DejaVuSansCondensed'
;
059.
$mpdf
->watermarkTextAlpha = 0.1;
060.
$mpdf
->SetDisplayMode(
'fullpage'
);
061.
062.
063.
064.
065.
$host
=
"n6-mysql5-3.smartyhost.com.au"
;
066.
$username
=
"whereol"
;
067.
$password
=
"terrace18"
;
068.
$db
=
"whereol_db"
;
069.
$Conn
= mysql_connect(
$host
,
$username
,
$password
)
or
die
(
"Error Connect to Database"
);
070.
mysql_query(
"SET NAMES utf8"
,
$Conn
);
071.
mysql_select_db(
$db
)
or
die
(
"เลือกฐานข้อมูลไม่ได้"
);
072.
mysql_query(
"SET NAMES UTF8"
);
073.
074.
$sql
=
"SELECT * FROM company WHERE company_id='"
.
$company_id
.
"'"
;
075.
076.
$result
= mysql_query(
$sql
);
077.
$show
= mysql_fetch_array(
$result
);
078.
079.
$sql_city
=
"SELECT * FROM city WHERE city_id='"
.
$show
[city].
"'"
;
080.
$result_city
= mysql_query(
$sql_city
);
081.
$show_city
= mysql_fetch_array(
$result_city
);
082.
083.
$sql_state
=
"SELECT * FROM state WHERE state_id='"
.
$show
[state].
"'"
;
084.
$result_state
= mysql_query(
$sql_state
);
085.
$show_state
= mysql_fetch_array(
$result_state
);
086.
087.
088.
089.
090.
$html
= '
091.
<html>
092.
<head>
093.
<style>
094.
body {font-family: sans-serif;
095.
font-size: 10pt;
096.
}
097.
p { margin: 0pt;
098.
}
099.
td { vertical-align: top; }
100.
.items td {
101.
border-left: 0.1mm solid #000000;
102.
border-right: 0.1mm solid #000000;
103.
}
104.
table thead td { background-color: #EEEEEE;
105.
text-align: center;
106.
border: 0.1mm solid #000000;
107.
}
108.
.items td.blanktotal {
109.
background-color: #FFFFFF;
110.
border: 0mm none #000000;
111.
border-top: 0.1mm solid #000000;
112.
border-right: 0.1mm solid #000000;
113.
}
114.
.items td.totals {
115.
text-align: right;
116.
border: 0.1mm solid #000000;
117.
}
118.
</style>
119.
</head>
120.
<body>
121.
122.
<!--mpdf
123.
<htmlpageheader name=
"myheader"
>
124.
<br/><table width=
"100%"
><tr>
125.
<td width=
"50%"
style=
"color:#0000BB;"
><span style=
"font-weight: bold; font-size: 14pt;"
>Acme Trading Co.</span><br />123 Anystreet<br />Your City<br />GD12 4LP<br /><span style=
"font-size: 15pt;"
>☎</span> 01777 123 567</td>
126.
<td width=
"50%"
style=
"text-align: right;"
>Invoice No.<br /><span style=
"font-weight: bold; font-size: 12pt;"
>0012345</span></td>
127.
</tr></table>
128.
</htmlpageheader>
129.
130.
<htmlpagefooter name=
"myfooter"
>
131.
<div style=
"border-top: 1px solid #000000; font-size: 9pt; text-align: center; padding-top: 3mm; "
>
132.
Page {PAGENO} of {nb}
133.
</div>
134.
</htmlpagefooter>
135.
136.
<sethtmlpageheader name=
"myheader"
value=
"on"
show-this-page=
"1"
/>
137.
<sethtmlpagefooter name=
"myfooter"
value=
"on"
/>
138.
mpdf-->
139.
140.
<div style=
"text-align: right"
>
Date
:
'.date('
jS F Y
').'
</div>
141.
142.
<table width=
"100%"
style=
"font-family: serif;"
cellpadding=
"10"
>
143.
<tr>
144.
<td width=
"45%"
style=
"border: 0.1mm solid #888888;"
><span style=
"color:#0000BB;"
><span style=
"font-weight: bold; font-size: 14pt;"
>
'.$show[company_name].'
</span><br />
145.
'.$show[address].'
><br />
146.
'.$show_city[city].'
><br />
147.
'.$show_state[state].'
'.$show[post_code].'
<br />
148.
<span style=
"font-size: 15pt;"
>☎</span>
'.$show[phone].'
</span></td>
149.
<td width=
"10%"
> </td>
150.
<td width=
"45%"
style=
"border: 0.1mm solid #888888;"
>
151.
<table align=
"right"
width=
"70%"
border=
"0"
style=
"font-size: 10pt;"
>
152.
153.
<tr>
154.
<td width=
"41%"
style=
"text-align: right"
>
Date
:</td>
155.
<td width=
"59%"
> </td>
156.
</tr>
157.
<tr>
158.
<td style=
"text-align: right"
>Motivating Factor:</td>
159.
<td> </td>
160.
</tr>
161.
<tr>
162.
<td style=
"text-align: right"
>Type of Action:</td>
163.
<td> </td>
164.
</tr>
165.
<tr>
166.
<td style=
"text-align: right"
>Status:</td>
167.
<td> </td>
168.
</tr>
169.
<tr>
170.
<td style=
"text-align: right"
>Word Filte:</td>
171.
<td> </td>
172.
</tr>
173.
</table>
174.
</td>
175.
</tr>
176.
</table>
177.
178.
179.
<table
class
=
"items"
width=
"100%"
style=
"font-size: 9pt; border-collapse: collapse;"
cellpadding=
"8"
>
180.
<thead>
181.
<tr>
182.
<td width=
"15%"
>REF. NO.</td>
183.
<td width=
"10%"
>QUANTITY</td>
184.
<td width=
"45%"
>DESCRIPTION</td>
185.
<td width=
"15%"
>UNIT PRICE</td>
186.
<td width=
"15%"
>AMOUNT</td>
187.
</tr>
188.
</thead>
189.
<tbody>
190.
<!-- ITEMS HERE -->
191.
<tr>
192.
<td align=
"center"
>MF1234567</td>
193.
<td align=
"center"
>10</td>
194.
<td>Large pack Hoover bags</td>
195.
<td align=
"right"
>£2.56</td>
196.
<td align=
"right"
>£25.60</td>
197.
</tr>
198.
<tr>
199.
<td align=
"center"
>MX37801982</td>
200.
<td align=
"center"
>1</td>
201.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
202.
<td align=
"right"
>£112.56</td>
203.
<td align=
"right"
>£112.56</td>
204.
</tr>
205.
<tr>
206.
<td align=
"center"
>MR7009298</td>
207.
<td align=
"center"
>25</td>
208.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
209.
<td align=
"right"
>£12.26</td>
210.
<td align=
"right"
>£325.60</td>
211.
</tr>
212.
<tr>
213.
<td align=
"center"
>MF1234567</td>
214.
<td align=
"center"
>10</td>
215.
<td>Large pack Hoover bags</td>
216.
<td align=
"right"
>£2.56</td>
217.
<td align=
"right"
>£25.60</td>
218.
</tr>
219.
<tr>
220.
<td align=
"center"
>MX37801982</td>
221.
<td align=
"center"
>1</td>
222.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
223.
<td align=
"right"
>£112.56</td>
224.
<td align=
"right"
>£112.56</td>
225.
</tr>
226.
<tr>
227.
<td align=
"center"
>MR7009298</td>
228.
<td align=
"center"
>25</td>
229.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
230.
<td align=
"right"
>£12.26</td>
231.
<td align=
"right"
>£325.60</td>
232.
</tr>
233.
<tr>
234.
<td align=
"center"
>MF1234567</td>
235.
<td align=
"center"
>10</td>
236.
<td>Large pack Hoover bags</td>
237.
<td align=
"right"
>£2.56</td>
238.
<td align=
"right"
>£25.60</td>
239.
</tr>
240.
<tr>
241.
<td align=
"center"
>MX37801982</td>
242.
<td align=
"center"
>1</td>
243.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
244.
<td align=
"right"
>£112.56</td>
245.
<td align=
"right"
>£112.56</td>
246.
</tr>
247.
<tr>
248.
<td align=
"center"
>MR7009298</td>
249.
<td align=
"center"
>25</td>
250.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
251.
<td align=
"right"
>£12.26</td>
252.
<td align=
"right"
>£325.60</td>
253.
</tr>
254.
<tr>
255.
<td align=
"center"
>MF1234567</td>
256.
<td align=
"center"
>10</td>
257.
<td>Large pack Hoover bags</td>
258.
<td align=
"right"
>£2.56</td>
259.
<td align=
"right"
>£25.60</td>
260.
</tr>
261.
<tr>
262.
<td align=
"center"
>MX37801982</td>
263.
<td align=
"center"
>1</td>
264.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
265.
<td align=
"right"
>£112.56</td>
266.
<td align=
"right"
>£112.56</td>
267.
</tr>
268.
<tr>
269.
<td align=
"center"
>MR7009298</td>
270.
<td align=
"center"
>25</td>
271.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
272.
<td align=
"right"
>£12.26</td>
273.
<td align=
"right"
>£325.60</td>
274.
</tr>
275.
<tr>
276.
<td align=
"center"
>MF1234567</td>
277.
<td align=
"center"
>10</td>
278.
<td>Large pack Hoover bags</td>
279.
<td align=
"right"
>£2.56</td>
280.
<td align=
"right"
>£25.60</td>
281.
</tr>
282.
<tr>
283.
<td align=
"center"
>MX37801982</td>
284.
<td align=
"center"
>1</td>
285.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
286.
<td align=
"right"
>£112.56</td>
287.
<td align=
"right"
>£112.56</td>
288.
</tr>
289.
<tr>
290.
<td align=
"center"
>MF1234567</td>
291.
<td align=
"center"
>10</td>
292.
<td>Large pack Hoover bags</td>
293.
<td align=
"right"
>£2.56</td>
294.
<td align=
"right"
>£25.60</td>
295.
</tr>
296.
<tr>
297.
<td align=
"center"
>MX37801982</td>
298.
<td align=
"center"
>1</td>
299.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
300.
<td align=
"right"
>£112.56</td>
301.
<td align=
"right"
>£112.56</td>
302.
</tr>
303.
<tr>
304.
<td align=
"center"
>MR7009298</td>
305.
<td align=
"center"
>25</td>
306.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
307.
<td align=
"right"
>£12.26</td>
308.
<td align=
"right"
>£325.60</td>
309.
</tr>
310.
<tr>
311.
<td align=
"center"
>MR7009298</td>
312.
<td align=
"center"
>25</td>
313.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
314.
<td align=
"right"
>£12.26</td>
315.
<td align=
"right"
>£325.60</td>
316.
</tr>
317.
<tr>
318.
<td align=
"center"
>MF1234567</td>
319.
<td align=
"center"
>10</td>
320.
<td>Large pack Hoover bags</td>
321.
<td align=
"right"
>£2.56</td>
322.
<td align=
"right"
>£25.60</td>
323.
</tr>
324.
<tr>
325.
<td align=
"center"
>MX37801982</td>
326.
<td align=
"center"
>1</td>
327.
<td>Womans waterproof jacket<br />Options - Red
and
charcoal.</td>
328.
<td align=
"right"
>£112.56</td>
329.
<td align=
"right"
>£112.56</td>
330.
</tr>
331.
<tr>
332.
<td align=
"center"
>MR7009298</td>
333.
<td align=
"center"
>25</td>
334.
<td>Steel nails; oval head; 30mm x 3mm. Packs of 1000.</td>
335.
<td align=
"right"
>£12.26</td>
336.
<td align=
"right"
>£325.60</td>
337.
</tr>
338.
<!--
END
ITEMS HERE -->
339.
<tr>
340.
<td
class
=
"blanktotal"
colspan=
"3"
rowspan=
"6"
></td>
341.
<td
class
=
"totals"
>Subtotal:</td>
342.
<td
class
=
"totals"
>£1825.60</td>
343.
</tr>
344.
<tr>
345.
<td
class
=
"totals"
>Tax:</td>
346.
<td
class
=
"totals"
>£18.25</td>
347.
</tr>
348.
<tr>
349.
<td
class
=
"totals"
>Shipping:</td>
350.
<td
class
=
"totals"
>£42.56</td>
351.
</tr>
352.
<tr>
353.
<td
class
=
"totals"
><b>TOTAL:</b></td>
354.
<td
class
=
"totals"
><b>£1882.56</b></td>
355.
</tr>
356.
<tr>
357.
<td
class
=
"totals"
>Deposit:</td>
358.
<td
class
=
"totals"
>£100.00</td>
359.
</tr>
360.
<tr>
361.
<td
class
=
"totals"
><b>Balance due:</b></td>
362.
<td
class
=
"totals"
><b>£1782.56</b></td>
363.
</tr>
364.
</tbody>
365.
</table>
366.
<div style=
"text-align: center; font-style: italic;"
>Payment terms: payment due in 30 days</div>
367.
</body>
368.
</html>
369.
';
370.
371.
$mpdf
->WriteHTML(
$html
);
372.
373.
$mpdf
->Output();
exit
;
374.
375.
exit
;
376.
377.
?>