01.<?php @session_start();?>
02.<?php include '../../Connections/innos.php'; ?>
03.<meta charset="utf-8" />
04.<style type="text/css">
05..a {
06. font-family: "TH SarabunPSK";
07. font-size: 20pt;
08.}
09..b{
10. font-family: "TH SarabunPSK";
11. font-size: 28pt;
12. font-weight: bold;
13.}
14.</style>
15.<?php
16. date_default_timezone_set('Asia/Bangkok');
17. $date= date('d-m-Y') ;
18.?>
19.
20.<!------------------------------------------------------------------------------------------------------------------------------->
21.<?php
22.require_once('../../mpdf/mpdf.php');
23.ob_start();
24.?>
25.<!------------------------------------------------------------------------------------------------------------------------------->
26.<?
27.mysql_select_db("intern_innosoft");
28.isset($_POST["from_date"], $_POST["to_date"], $_POST["stud_name"]);
29.$sql = "SELECT *
30.FROM tbl_stud, tbl_timestud
31.WHERE tbl_timestud.stud_id=tbl_stud.stud_id
32.AND (tbl_stud.stud_name LIKE '%{$_POST['stud_name']}%'
33.OR tbl_stud.stud_nickname LIKE '%{$_POST['stud_name']}%')
34.AND tbl_timestud.time_date BETWEEN '".$_POST["from_date"]."' AND '".$_POST["to_date"]."'
35.ORDER BY tbl_timestud.time_date";
36.$query = mysql_query($sql);
37.$row1 = mysql_fetch_assoc($query)
38.?>
39.<!------------------------------------------------------------------------------------------------------------------------------->
40.<table width="100%" border="0">
41. <tr class="a">
42. <td width="67%" align="left" class="style-a">บริษัท อินโนเวทีฟ ซอฟท์แวร์ เซอร์วิสเซส จำกัด </td>
43. <td width="32%" class="style-a">ออกเอกสารโดย : <?php echo $_SESSION["Name"]; ?></td>
44. </tr>
45. <tr class="a">
46. <td align="left" class="style-a"> </td>
47. <td class="style-a">วันที่ออกเอกสาร : <? echo $date ?></td>
48. </tr>
49.</table>
50.<hr />
51.<table width="100%" border="0">
52. <tr class="b">
53. <th align="center" >ตารางเวลาเข้า - ออกงานของ <? echo $row1 ["stud_name"];?> (<? echo $row1 ["stud_nickname"];?>)</th>
54. </tr>
55.</table>
56.<!------------------------------------------------------------------------------------------------------------------------------->
57.
58.<!------------------------------------------------------------------------------------------------------------------------------->
59.<table bordercolor="#424242" width="100%" height="" border="0" align="center" cellpadding="0" cellspacing="0" class="style-a">
60.
61. <tr class="a">
62.
63. <th height="30" widht="25%" align="center" bgcolor="#D5D5D5">วันที่</th>
64. <th widht="25%" align="center" bgcolor="#D5D5D5">เวลาเข้างาน</th>
65. <th widht="25%" align="center" bgcolor="#D5D5D5">เวลาเลิกงาน</th>
66. </tr>
67. <?php
68. while ($result = mysql_fetch_assoc($query)) {
69. ?>
70. <tr class="a">
71.
72. <td height="20" align="center"><?php echo $result["time_date"]; ?></td>
73. <td align="center"><?php echo $result["time_wrktime"]; ?></td>
74. <td align="center"><?php echo $result["time_outtime"]; ?></td>
75. </tr>
76. <?php } ?>
77. </table>
78. <!------------------------------------------------------------------------------------------------------------------------------->
79.<hr />
80.
81.<!------------------------------------------------------------------------------------------------------------------------------->
82.<?Php
83.$html = ob_get_contents();
84.ob_end_clean();
85.$pdf = new mPDF('th', 'A4', '0', '');
86.$pdf->SetAutoFont();
87.$pdf->SetDisplayMode('fullpage');
88.$pdf->WriteHTML($html, 2);
89.$pdf->Output();
90.?>
