-
Notifications
You must be signed in to change notification settings - Fork 0
/
view_invoice.php
73 lines (66 loc) · 1.22 KB
/
view_invoice.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
<?php
include('db_connect.php');
require 'dompdf/dompdf_config.inc.php';
$sqlinv="SELECT * FROM teach_clmi";
$res_inv = mysql_query($sqlinv) or die(mysql_error());
while ($sql3=mysql_fetch_array($res_inv)) {
$sr = $sql3['Teach_Clmi_TOA'];
$part = $sql3['Teach_Clmi_YSR'];
$size = $sql3['Teach_Clmi_API'];
//$qty = $sql3['qty'];
//$rate = $sql3['rate'];
//$amt = $sql3['amt'];
}
$dompdf= new DOMPDF();
$html .="<html>
<head>
<style>
body {
font-family: arial;
font-size: 13px;
}
table {
width: 100%;
border-collapse: collapse;
}
th {
font-weight: bold;
font-size: 14px;
border: 1px solid #333333;
}
tr {
width: 100%;
}
td {
border: 1px solid #333333;
text-align: center;
padding: 10px;
font-weight: normal!important;
}
</style>
</head><body>";
$html .="
<table>
<thead>
<tr>
<th class=''>Sr.</th>
<th class=''>Particulars</th>
<th class=''>Size</th>
</tr>
</thead>
<tbody>
<tr>
<td class=''>" . $sr ."</td>
<td class=''>" . $part . "</td>
<td class=''>" . $size . "</td>
</tr>
</tbody>
</table>
</body>
</html>";
$dompdf->load_html($html);
$dompdf->render();
//$dompdf->stream("sample.pdf");
$dompdf->stream("media_inv_".$invno."_".$date.".pdf", array("Attachment" => false));
exit(0);
?>