001.<?php
002.require ('DBcon.php');
003.require_once('mpdf/mpdf.php');
004.
005.ob_start();
006.include('DBcon.php');
007.include('datetime.php');
008.include('fulldate2.php');
009.?>
012.<html>
013.<head>
014.<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8">
015.</head>
016.<body>
017.<div class=Section2>
018. <?php
019.
020. $date_start = '2015-10-01';
021. $date_end = '2015-10-28';
022. $strSQL = "SELECT
023. tb_request.Stokout_date,
024. tb_equipment.Eq_name,
025. tb_rqdetail.Rq_quantity1,
026. tb_unit.Unit_name,
027. tb_staf.staf_name,
028. tb_staf.staf_last,
029. tb_preface.preface_subject,
030. tb_status.status_id,
031. tb_rqdetail.note_disapp
032. FROM
033. tb_request
034. INNER JOIN tb_rqdetail ON tb_rqdetail.Req_id = tb_request.Req_id
035. INNER JOIN tb_equipment ON tb_rqdetail.Eq_id = tb_equipment.Eq_id
036. INNER JOIN tb_staf ON tb_request.staf_id = tb_staf.staf_id
037. INNER JOIN tb_unit ON tb_equipment.Unit_id = tb_unit.Unit_id
038. INNER JOIN tb_preface ON tb_request.preface_id = tb_preface.preface_id
039. INNER JOIN tb_prefix ON tb_staf.prefix_id = tb_prefix.prefix_id
040. INNER JOIN tb_status ON tb_rqdetail.status_id = tb_status.status_id
041. WHERE
042. (tb_request.Stokout_date BETWEEN '".$date_start."' AND '".$date_end."') AND
043. tb_rqdetail.status_id = '12'
044. ORDER BY
045. tb_request.Stokout_date ASC";
046. $objQuery = mysql_query($strSQL) or die (mysql_error());
047. $objResult = mysql_fetch_array($objQuery);
048. $num_rows = mysql_num_rows($objQuery);
049. ?>
050. <table width="800" border="0" align="left" cellpadding="0" cellspacing="0">
051. <tr>
052. <td align="left" rowspan="5" width="50">
053. <img src="img/PRANAKORN_LOGO.jpg" width="74" height="134">
054. </td>
055. </tr>
056. <tr>
057. <td width="291" align="left"><span class="style2"> </span></td>
058. </tr>
059. <tr>
060. <td width="291" align="left"><span class="style2"> </span></td>
061. </tr>
062. <tr>
063. <td width="291" align="left"><span class="style2"><h2>รายงานการจ่ายวัสดุ</h2></span></td>
064. </tr>
065. <tr>
066. <td height="27" align="left"><span class="style2"><h3>คณะบริหารธุรกิจ มหาวิทยาลัยเทคโนโลยีราชมงคลพระนคร </h3></span></td>
067. </tr>
068. <tr>
069. <td></td>
070. <td height="30" align="left"><span class="style2">ตั้งแต่วันที่ <? echo fulldate($date_start) .' ถึงวันที่ '.fulldate($date_end)?></span></td>
071. </tr>
072. </table>
073.<table width="200" border="0" align="center">
074. <tbody>
075. <tr>
076. <td align="center"> </td>
077. </tr>
078. </tbody>
079.</table>
080.<table bordercolor="#424242" width="1141" height="78" border="1" align="center" cellpadding="0" cellspacing="0" class="style3">
081.<tr align="center">
082. <td width="60" align="center" ><strong>วันที่เบิก</strong></td>
083. <td width="178" align="center" ><strong>ชื่อวัสดุ</strong></td>
084. <td width="123" align="center" ><strong>จำนวน</strong></td>
085. <td width="155" align="center" ><strong>หน่วยนับ</strong></td>
086. <td width="139" align="center" ><strong>ผู้เบิก</strong></td>
087. <td width="139" align="center" ><strong>คำสั่ง</strong></td>
088.</tr>
089.<?
090.do
091.{
092. $item = $item + 1;
093. if($item > 7){
094. $pdf->AddPage();
095. $item = 0;
096. $i = 0;
097. ?>
098. <table width="800" border="0" align="left" cellpadding="0" cellspacing="0">
099. <tr>
100. <td align="left" rowspan="5" width="50">
101. <img src="img/PRANAKORN_LOGO.jpg" width="74" height="134">
102. </td>
103. </tr>
104. <tr>
105. <td width="291" align="left"><span class="style2"> </span></td>
106. </tr>
107. <tr>
108. <td width="291" align="left"><span class="style2"> </span></td>
109. </tr>
110. <tr>
111. <td width="291" align="left"><span class="style2"><h2>รายงานการจ่ายวัสดุ</h2></span></td>
112. </tr>
113. <tr>
114. <td></td>
115. <td height="30" align="left"><span class="style2">ตั้งแต่วันที่ <? echo fulldate($date_start) .' ถึงวันที่ '.fulldate($date_end)?></span></td>
116. </tr>
117. </table>
118. <? }
119. $i = $i+14;
120. ?>
121. <table bordercolor="#424242" width="1141" height="78" border="1" align="center" cellpadding="0" cellspacing="0" class="style3">
122. <tr align="center">
123. <td width="60" align="center" ><? echo $objResult['Stokout_date']; ?></td>
124. <td width="178" align="left" ><? echo $objResult['Eq_name']; ?></td>
125. <td width="123" align="center" ><? echo $objResult['Rq_quantity1']; ?></td>
126. <td width="155" align="center" ><? echo $objResult['Unit_name']; ?></td>
127. <td width="139" align="left" ><? echo $objResult['staf_name'].' '. $objResult['staf_last']; ?></td>
128. <td width="139" align="left" ><? echo $objResult['preface_subject']; ?></td>
129. </tr>
130. <?
131.}while($objResult = mysql_fetch_array($objQuery));
132. ?>
133.</table>
134.</div>
135.</body>
136.</html>
137.<?php
138.$html = ob_get_contents();
139.ob_end_clean();
140.$pdf = new mPDF('th', 'A4-L', '0', 'THSarabun');
141.$pdf->SetAutoFont();
142.$pdf->SetDisplayMode('fullpage');
143.$pdf->WriteHTML($html, 2);
144.$pdf->Output();
145.?>
Load balance : Server 05
