TCPDF Footer ออกรายงาน 2 หน้า แตกต่างกัน คือในหน้าที่ 1 ต้องเป็นยกยอดไปครับ
ข้อมูลเนื้อหา <table width="100%" border="0" cellspacing="1" cellpadding="0">
<?php
$queryExamineShow = "SELECT * FROM quotationlist WHERE quotation_id = '$_GET[quotation_id]' ORDER BY quotationlist_id ASC ";
$resultExamineShow = $mysqli->query($queryExamineShow);
if($resultExamineShow && $resultExamineShow->num_rows>0){
$i= 1;
while($rowExamineShow = $resultExamineShow->fetch_assoc()){
?>
<tr>
<th align="center" width="5%"><?php echo ++$unit; ?></th>
<th align="left" width="44%"><?php echo $rowExamineShow["quotationlist_name"]; ?></th>
<th align="left" width="15%"><?php echo $rowExamineShow["quotationlist_number"]; ?>
<?php $queryMeasure = "SELECT measure_name FROM measure WHERE measure_id = '$rowExamineShow[measure_id]' ";
$resultMeasure = $mysqli->query($queryMeasure);
$resultMeasure && $resultMeasure->num_rows>0;
$rowMeasureShow = $resultMeasure->fetch_assoc();
echo $rowMeasureShow["measure_name"]; ?></th>
<th align="right" width="12%"><?php echo number_format($rowExamineShow["quotationlist_price"],2,'.',',');?> </th>
<th align="right" width="9%"><?php if($rowExamineShow["quotationlist_discount"]<>""){echo number_format($rowExamineShow["quotationlist_discount"],2,'.',',');}else{echo "-";} ?> </th>
<th align="right" width="15%"><?php echo number_format($rowExamineShow["quotationlist_sum"],2,'.',',');?> </th>
</tr>
<? }} ?>
</table>
Code (PHP) // ส่วนจัดการ footer
public function Footer() {
$queryQuotationSum = "select sum(quotationlist_sum) as result from quotationlist where quotation_id= '$_GET[quotation_id]' ";
$resultQuotationSum = $mysqli->query($queryQuotationSum);
$resultQuotationSum && $resultQuotationSum->num_rows>0;
$rowQuotationSum = $resultQuotationSum->fetch_assoc();
$quotationlist_sum = number_format($rowQuotationSum["result"],2,'.',',');
//$quotationlist_sum;
$bf = bathformat($quotationlist_sum);
$html = "
<style>
td {
border: 0.5px solid #ffc000;
}
</style>
<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"2\" bordercolor=\"#ffc000\">
<tr>
<td rowspan=\"4\" width=\"60%\"> <strong>หมายเหตุ</strong> : </td>
<td align=\"right\" width=\"18%\">รวม </td>
<td align=\"right\" width=\"22%\">$quotationlist_sum </td>
</tr>
<tr>
<td align=\"right\">ส่วนลด </td>
<td align=\"right\">- </td>
</tr>
<tr>
<td align=\"right\">มูลค่าสินค้า </td>
<td align=\"right\">$quotationlist_sum </td>
</tr>
<tr>
<td align=\"right\">ภาษีมูลค่าเพิ่ม 7% </td>
<td align=\"right\">- </td>
</tr>
<tr>
<td align=\"center\"><strong>($bf)</strong></td>
<td align=\"right\"> <strong>สุทธิ</strong> </td>
<td align=\"right\"><strong>$quotationlist_sum</strong> </td>
</tr>
</table>";
$this->SetFont('thsarabun', '', _conversion(20,'px-pt'), '', true);
$this->writeHTMLCell(0, 0, '', '', $html, 0, 1, false,true, "L", true);
}
}
Tag PHP, MySQL, IIS
ประวัติการแก้ไข
Date :
2019-08-01 10:36:14By :
sookurbView :
1604Reply :
3
ลองแบ่งข้อมูลออกเป็น 2 ชุดดูหรือยังครับCode (PHP) $html1 ="<table>....</table>";
$pdf->writeHTML($html1);
$html2="<table>...</table>";
$pdf->writeHTML($html2);
Date :
2019-08-01 14:03:49By :
nobetaking
ผมทำเป็น Footer ครับ
ประวัติการแก้ไข
Date :
2019-08-01 15:02:48By :
sookurb
ได้แล้วครับ เผื่อใครกำลังหาอยู่ครับCode (PHP) public function Close() {
$this->last_page_flag = true;
parent::Close();
}
And then on the Footer() function I do something like:
function Footer(){
if($this->last_page_flag){
$footer_html = '...'; //HTML for the footer on the last page
}
else{
$footer_html = '...'; //HTML for the rest of the pages
}
Date :
2019-08-05 12:12:42By :
sookurb
Server 02
Load balance : Server 02
