|
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/TCPDF/erp/ |
Upload File : |
<?php
ob_start();
include "../../include/top_pdf.html";
// 기존 예약정보
if($a_idx){
$sql = "select * from TB_ERP_ALL where a_idx='{$a_idx}'";
$rs = db_query($sql);
$row = db_fetch_array($rs) ;
// 참여 인원
$inwon = $row['num_adult'] + $row['num_child'];
//customer 정보
$sql2 = "select * from TB_ERP_CUSTOMER where a_idx='{$a_idx}' order by c_idx asc";
$rs2 = db_query($sql2);
while ($row2 = db_fetch_array($rs2)) {
$row_customer[] = $row2;
}
// 출발일
$start_date = date('Y년 m월 d일', strtotime($row['start_date']));
$start_date .= " (" . get_yoil($row['start_date']) . ")";
}
// Include the main TCPDF library (search for installation path).
require_once('tcpdf_include.php');
// Page footer
class MYPDF extends TCPDF {
//Page header
public function Header() {
// Logo
//$image_file = K_PATH_IMAGES.'logo_example.jpg';
//$this->Image($image_file, 10, 10, 15, '', 'JPG', '', 'T', false, 300, '', false, false, 0, false, false, false);
// Set font
//$this->SetFont('helvetica', 'B', 20);
// Title
$this->Cell(0, 0, '', 0, false, 'C', 0, '', 0, false, 'M', 'M');
}
// Page footer
public function Footer() {
// Position at 15 mm from bottom
$this->SetY(-15);
// Set font
$this->SetFont('helvetica', 'I', 8);
// Page number
$this->Cell(0, 10, 'Page '.$this->getAliasNumPage().'/'.$this->getAliasNbPages(), 0, false, 'C', 0, '', 0, false, 'T', 'M');
}
}
// create new PDF document
//$pdf = new TCPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
$pdf = new MYPDF(PDF_PAGE_ORIENTATION, PDF_UNIT, PDF_PAGE_FORMAT, true, 'UTF-8', false);
// set document information
$pdf->SetCreator(PDF_CREATOR);
$pdf->SetAuthor('Nicola Asuni');
$pdf->SetTitle('PERSON LIST');
$pdf->SetSubject('TKTRAVEL');
$pdf->SetKeywords('TCPDF, PDF, estimate, invoice, voucher');
// set default header data
//$pdf->SetHeaderData(HEADER_INVOICE_TKTRAVEL, PDF_HEADER_TKTRAVEL_WIDTH, '', '');
// set header and footer fonts
$pdf->setHeaderFont(Array(PDF_FONT_NAME_MAIN, '', PDF_FONT_SIZE_MAIN));
$pdf->setFooterFont(Array(PDF_FONT_NAME_DATA, '', PDF_FONT_SIZE_DATA));
// set default monospaced font
$pdf -> SetDefaultMonospacedFont("nanumgothic");
//$pdf->SetDefaultMonospacedFont(PDF_FONT_MONOSPACED);
//$pdf->SetFont('CID0KR', '', 10);
// set margins
//$pdf->SetMargins(PDF_MARGIN_LEFT, PDF_MARGIN_TOP, PDF_MARGIN_RIGHT);
//$pdf->SetHeaderMargin(PDF_MARGIN_HEADER);
//$pdf->SetFooterMargin(PDF_MARGIN_FOOTER);
// set auto page breaks
$pdf->SetAutoPageBreak(TRUE, PDF_MARGIN_BOTTOM);
// set image scale factor
$pdf->setImageScale(PDF_IMAGE_SCALE_RATIO);
// set some language-dependent strings (optional)
if (@file_exists(dirname(__FILE__).'/lang/eng.php')) {
require_once(dirname(__FILE__).'/lang/eng.php');
$pdf->setLanguageArray($l);
}
// ---------------------------------------------------------
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
// Print a table
// set font
//$pdf->SetFont('CID0KR', '', 10);
$pdf->SetFont('nanumgothic', '', 8);
//$pdf->SetFont('nanumgothic', '', 8); ## 폰트 종류,스타일,크기 지정
$pdf->SetTextColor(33,33,33);
// add a page
$pdf->AddPage();
// create some HTML content
// Set some content to print
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
$html = '
<style>
p {text-align:right; font-size:12px;line-height:10px;}
table.qtable{
width:100%;border-top:1px solid #000;border-left:1px solid #000;border-collapse:collapse;border-spacing:0;
}
table.qtable th{
background:#d9d9d9; border:1px solid #000;
font-weight:bold;padding:5px 0;text-align:center;
line-height:18px;
}
table.qtable td{
border-right:1px solid #000;border-bottom:1px solid #000; padding:5px 0;
line-height:18px; text-align:center;
}
table.qtable td.txt_left{text-align:left;}
table, td, th{
border-collapse : collapse;
}
th,td{
vertical-align : middle;
}
</style>
';
$html .= '
<div>
<img src="images/pdf_header_person.png" alt="LOGO" border="0" />
<p>행사명 : '.$row['good_name'].'</p>
<p>출발일 : '.$start_date.'</p>
</div>
<div>
<span>총 인원 : '.count($row_customer).' 명</span> |
<span>가이드정보 : '.$row['customer_guide'].'</span> |
<span>기사정보 : '.$row['customer_driver'].'</span> |
<span>차량정보 : '.$row['customer_carinfo'].'</span>
</div>
';
$html .= '
<tr>
<td> </td>
</tr>
<table width="100%" border="0" cellspacing="0" cellpadding="1" class="qtable">
<thead>
<tr style="text-align:center;">
<th width="4%" height="25" bgcolor="#d9d9d9">NO</th>
<th width="16%" bgcolor="#d9d9d9">고객이름</th>
<th width="16%" bgcolor="#d9d9d9">전화번호</th>
<th width="4%" bgcolor="#d9d9d9">국적</th>
<th width="4%" bgcolor="#d9d9d9">성별</th>
<th width="22%" bgcolor="#d9d9d9" >미팅장소</th>
<th width="10%" bgcolor="#d9d9d9">객실타입</th>
<th width="10%" bgcolor="#d9d9d9">객실번호</th>
<th width="14%" bgcolor="#d9d9d9">비고</th>
</tr>
';
foreach($row_customer as $k => $v){
$html .= '
<tr>
<td height="20">'.($k+1).'</td>
<td> '.$v['cus_nm'].'</td>
<td>'.$v['cus_phone'].'</td>
<td>'.$v['cus_nat'].'</td>
<td>'.$v['cus_gend'].'</td>
<td class="txt_left"> '.$v['cus_depot'].'</td>
<td>'.$v['cus_roomtype'].'</td>
<td>'.$v['cus_roomnum'].'</td>
<td class="txt_left"> '.$v['memo'].'</td>
</tr>
';
}
$html .= '
</thead>
<tbody>
</tbody>
</table>
';
// output the HTML content
$pdf->writeHTML($html, true, false, true, false, '');
// reset pointer to the last page
$pdf->lastPage();
// - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ob_end_clean();
//Close and output PDF document
$filename = "person_list_" . str_replace("-", "", $use_dt) . "_" . date("ymdHis") . ".pdf";
$pdf->Output($filename, 'I');
//$pdf->Output($filename, 'I');
ob_end_flush();
//============================================================+
// END OF FILE
//============================================================+