|
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/erp_231024/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.html";
$upload = "http://www.tourboss.co.kr/FileData/good/";
$upload_thum = "http://www.tourboss.co.kr/FileData/good_thum/";
// 기존 예약정보
if($a_idx){
$sql = "select * from TB_ERP_ALL where a_idx='{$a_idx}'";
$rs = db_query($sql);
$row = db_fetch_array($rs) ;
//1인투어비
$price_per_one = round($row['total_price'] / ($row['num_adult']+$row['num_child']));
}
// 엑셀 파일명 설정
$FileName = "VOUCHER_".$row['good_name']."_".$row['res_name'] ;
$FileName = $FileName."_".Date("Ymd").".xls";
$FileName = urlencode($FileName); // UTF-8
// 엑셀 파일로 변환 헤더
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$FileName");
header("Content-Description: PHP4 Generated Data" );
//VOUCHER 정보
if($v_idx){
$sql4 = "select * from TB_ERP_VOUCHER where v_idx='{$v_idx}'";
$rs4 = db_query($sql4);
$row4 = db_fetch_array($rs4) ;
$row4['img_src'] = $upload . $row4['meeting_place'];
if($row4['code1']) {
//array('voucher code','person name','persons','person nationality')
$code1 = explode("::",$row4['code1']);
}
if($row4['code2']) {
$code2 = explode("::",$row4['code2']);
}
if($row4['code3']) {
$code3 = explode("::",$row4['code3']);
}
if($row4['code4']) {
$code4 = explode("::",$row4['code4']);
}
if($row4['code5']) {
$code5 = explode("::",$row4['code5']);
}
if($row4['code6']) {
$code6 = explode("::",$row4['code6']);
}
if($row4['code7']) {
$code7 = explode("::",$row4['code7']);
}
if($row4['code8']) {
$code8 = explode("::",$row4['code8']);
}
if($row4['code9']) {
$code9 = explode("::",$row4['code9']);
}
if($row4['code10']) {
$code10 = explode("::",$row4['code10']);
}
if($row4['code11']) {
$code11 = explode("::",$row4['code11']);
}
if($row4['code12']) {
$code12 = explode("::",$row4['code12']);
}
if($row4['code13']) {
$code13 = explode("::",$row4['code13']);
}
if($row4['code14']) {
$code14 = explode("::",$row4['code14']);
}
if($row4['code15']) {
$code15 = explode("::",$row4['code15']);
}
if($row4['code16']) {
$code16 = explode("::",$row4['code16']);
}
if($row4['code17']) {
$code17 = explode("::",$row4['code17']);
}
if($row4['code18']) {
$code18 = explode("::",$row4['code18']);
}
if($row4['code19']) {
$code19 = explode("::",$row4['code19']);
}
if($row4['code20']) {
$code20 = explode("::",$row4['code20']);
}
if($row4['code21']) {
$code21 = explode("::",$row4['code21']);
}
if($row4['code22']) {
$code22 = explode("::",$row4['code22']);
}
if($row4['code23']) {
$code23 = explode("::",$row4['code23']);
}
if($row4['code24']) {
$code24 = explode("::",$row4['code24']);
}
if($row4['code25']) {
$code25 = explode("::",$row4['code25']);
}
if($row4['code26']) {
$code26 = explode("::",$row4['code26']);
}
if($row4['code27']) {
$code27 = explode("::",$row4['code27']);
}
if($row4['code28']) {
$code28 = explode("::",$row4['code28']);
}
if($row4['code29']) {
$code29 = explode("::",$row4['code29']);
}
if($row4['code30']) {
$code30 = explode("::",$row4['code30']);
}
if($row4['code31']) {
$code31 = explode("::",$row4['code31']);
}
if($row4['code32']) {
$code32 = explode("::",$row4['code32']);
}
if($row4['code33']) {
$code33 = explode("::",$row4['code33']);
}
if($row4['code34']) {
$code34 = explode("::",$row4['code34']);
}
if($row4['code35']) {
$code35 = explode("::",$row4['code35']);
}
if($row4['code36']) {
$code36 = explode("::",$row4['code36']);
}
if($row4['code37']) {
$code37 = explode("::",$row4['code37']);
}
if($row4['code38']) {
$code38 = explode("::",$row4['code38']);
}
if($row4['code39']) {
$code39 = explode("::",$row4['code39']);
}
if($row4['code40']) {
$code40 = explode("::",$row4['code40']);
}
if($row4['code41']) {
$code41 = explode("::",$row4['code41']);
}
if($row4['code42']) {
$code42 = explode("::",$row4['code42']);
}
if($row4['code43']) {
$code43 = explode("::",$row4['code43']);
}
if($row4['code44']) {
$code44 = explode("::",$row4['code44']);
}
if($row4['code45']) {
$code45 = explode("::",$row4['code45']);
}
if($row4['code46']) {
$code46 = explode("::",$row4['code46']);
}
if($row4['code47']) {
$code47 = explode("::",$row4['code47']);
}
if($row4['code48']) {
$code48 = explode("::",$row4['code48']);
}
if($row4['code49']) {
$code49 = explode("::",$row4['code49']);
}
if($row4['code50']) {
$code50 = explode("::",$row4['code50']);
}
//사용방법
$use_method = explode("::",$row4['use_method']);
}
if($row4['code_type']=='voucher' && $code1[0]) {
$voucher_no = "VOUCHER NO. <u>" . $code1[0] . "</u>";
} else {
$voucher_no =" ";
}
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 10">
<style>
<!--
table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in .75in;
mso-header-margin:.5in;
mso-footer-margin:.5in;}
-->
table.qtable th{ text-align:center;background:"#E7E7E7"}
table.qtable td{ text-align:center;background:"#ffffff"}
table.qtable td.txt_left{ text-align:left;padding-left:10px;}
table.qtable td.red{ text-align:left;color:red;}
.qrcode {
margin-top:10px;
text-align:center;
}
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>견적서</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
</x:Print>
<x:Selected/>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
</x:ExcelWorkbook>
</xml><![endif]-->
<meta http-equiv=Content-Language content=ko>
</head>
<body>
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td>
<table border=0>
<tr height="106">
<td colspan="11"><img src="http://tourboss.co.kr/admin/TCPDF/erp/images/header_voucher_tktravel.jpg" width="700" height="106"></td>
</tr>
<tr height="35">
<td colspan="5">Date:<?=date("Y-m-d")?></td>
<td colspan="6" align="right"><strong><?=$voucher_no?></strong></td>
</tr>
<tr>
<td colspan="11" height="20"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<!--예약정보-->
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<tr height="35">
<th width="60">ATTN</th>
<td colspan="6" class="txt_left"><?=$row['attn']?></td>
<th width="60">FROM</th>
<td width="180" class="txt_left"><?=$row['admin_nm']?></td>
<th width="60">Manager</th>
<td width="180" class="txt_left"><?=$row['charger']?></td>
</tr>
<tr height="35">
<th>Name</th>
<td colspan="6" class="txt_left"><?=$row['good_name']?></td>
<th>Date use.</th>
<td colspan="3" class="txt_left">
<?=$row['start_date']?> ~ <?=$row['end_date']?>
<span id="periods"><?=$row['periods']?></span>
</td>
</tr>
<tr height="35">
<th>Hotel</th>
<td colspan="6" class="txt_left"><?=$row['hotel_name']?></td>
<th>Bus Info.</th>
<td colspan="3" class="txt_left"><?=$row['car_info']?></td>
</tr>
<tr height="35">
<th>Name</th>
<td colspan="2" class="txt_left"><?=$row['res_name']?></td>
<th width="60">Country</th>
<td colspan="3" class="txt_left"><?=$row['res_nationality']?></td>
<th>Deposit</th>
<td colspan="3" class="txt_left">
<?=$row['currency']?><?=number_format($row['deposit'])?>
</td>
</tr>
<tr height="35">
<th>Mobile</th>
<td colspan="2" class="txt_left"> <?=$row['res_phone']?></td>
<th width="60">E-mail</th>
<td colspan="3" class="txt_left"><?=$row['res_email']?></td>
<th>Balance</th>
<td colspan="3" class="txt_left">
<?=$row['currency']?> <?=number_format($row['balance'])?>
</td>
</tr>
<tr height="35">
<th>Participant</th>
<th width="60">Adult</th>
<td width="60"><?=$row['num_adult']?></td>
<th width="60">Child</th>
<td width="60"><?=$row['num_child']?></td>
<th width="60">FOC</th>
<td width="60"><?=$row['num_foc']?></td>
<th>Total</th>
<td class="txt_left">
<span id="total"><?=$row['currency']?> <?=number_format($row['total_price'])?></span>
</td>
<th>1 ppl cost</th>
<td class="txt_left">
<span id="per_amount"><?=$row['currency']?> <?=number_format($price_per_one)?></span>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="20"> </td>
</tr>
</table>
</td>
</tr>
<!--세부항목-->
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="35">
<? if($row4['code_type']=='voucher') { ?>
■ Voucher Number (預約編號) :
<? } else { ?>
■ QR Code Number : <span style="color:#c00066">Please show this QR code to ticket office.</span>
<? } ?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<? if($row4['code_type']=='voucher') : ?>
<? if($row4['code1'] || $row4['code2'] || $row4['code3']) {?>
<tr height="35">
<th><?if($code1[0]) echo "No.1";?></th><td colspan="2" class="red"><?=$code1[0]?></td>
<th><?if($code2[0]) echo "No.2";?></th><td colspan="3" class="red"><?=$code2[0]?></td>
<th><?if($code3[0]) echo "No.3";?></th><td colspan="3" class="red"><?=$code3[0]?></td>
</tr>
<? } ?>
<? if($row4['code4'] || $row4['code5'] || $row4['code6']) {?>
<tr height="35">
<th><?if($code4[0]) echo "No.4";?></th><td colspan="2" class="red"><?=$code4[0]?></td>
<th><?if($code5[0]) echo "No.5";?></th><td colspan="3" class="red"><?=$code5[0]?></td>
<th><?if($code6[0]) echo "No.6";?></th><td colspan="3" class="red"><?=$code6[0]?></td>
</tr>
<? } ?>
<? if($row4['code7'] || $row4['code8'] || $row4['code9']) {?>
<tr height="35">
<th><?if($code7[0]) echo "No.7";?></th><td colspan="2" class="red"><?=$code7[0]?></td>
<th><?if($code8[0]) echo "No.8";?></th><td colspan="3" class="red"><?=$code8[0]?></td>
<th><?if($code9[0]) echo "No.9";?></th><td colspan="3" class="red"><?=$code9[0]?></td>
</tr>
<? } ?>
<? if($row4['code10'] || $row4['code11'] || $row4['code12']) {?>
<tr height="35">
<th><?if($code10[0]) echo "No.10";?></th><td colspan="2" class="red"><?=$code10[0]?></td>
<th><?if($code11[0]) echo "No.11";?></th><td colspan="3" class="red"><?=$code11[0]?></td>
<th><?if($code12[0]) echo "No.12";?></th><td colspan="3" class="red"><?=$code12[0]?></td>
</tr>
<? } ?>
<? if($row4['code13'] || $row4['code14'] || $row4['code15']) {?>
<tr height="35">
<th><?if($code13[0]) echo "No.13";?></th><td colspan="2" class="red"><?=$code13[0]?></td>
<th><?if($code14[0]) echo "No.14";?></th><td colspan="3" class="red"><?=$code14[0]?></td>
<th><?if($code15[0]) echo "No.15";?></th><td colspan="3" class="red"><?=$code15[0]?></td>
</tr>
<? } ?>
<? if($row4['code16'] || $row4['code17'] || $row4['code18']) {?>
<tr height="35">
<th><?if($code16[0]) echo "No.16";?></th><td colspan="2" class="red"><?=$code16[0]?></td>
<th><?if($code17[0]) echo "No.17";?></th><td colspan="3" class="red"><?=$code17[0]?></td>
<th><?if($code18[0]) echo "No.18";?></th><td colspan="3" class="red"><?=$code18[0]?></td>
</tr>
<? } ?>
<? if($row4['code19'] || $row4['code20'] || $row4['code21']) {?>
<tr height="35">
<th><?if($code19[0]) echo "No.19";?></th><td colspan="2" class="red"><?=$code19[0]?></td>
<th><?if($code20[0]) echo "No.20";?></th><td colspan="3" class="red"><?=$code20[0]?></td>
<th><?if($code21[0]) echo "No.21";?></th><td colspan="3" class="red"><?=$code21[0]?></td>
</tr>
<? } ?>
<? if($row4['code22'] || $row4['code23'] || $row4['code24']) {?>
<tr height="35">
<th><?if($code22[0]) echo "No.22";?></th><td colspan="2" class="red"><?=$code22[0]?></td>
<th><?if($code23[0]) echo "No.23";?></th><td colspan="3" class="red"><?=$code23[0]?></td>
<th><?if($code24[0]) echo "No.24";?></th><td colspan="3" class="red"><?=$code24[0]?></td>
</tr>
<? } ?>
<? if($row4['code25'] || $row4['code26'] || $row4['code27']) {?>
<tr height="35">
<th><?if($code25[0]) echo "No.25";?></th><td colspan="2" class="red"><?=$code25[0]?></td>
<th><?if($code26[0]) echo "No.26";?></th><td colspan="3" class="red"><?=$code26[0]?></td>
<th><?if($code27[0]) echo "No.27";?></th><td colspan="3" class="red"><?=$code27[0]?></td>
</tr>
<? } ?>
<? if($row4['code28'] || $row4['code29'] || $row4['code30']) {?>
<tr height="35">
<th><?if($code28[0]) echo "No.28";?></th><td colspan="2" class="red"><?=$code28[0]?></td>
<th><?if($code29[0]) echo "No.29";?></th><td colspan="3" class="red"><?=$code29[0]?></td>
<th><?if($code30[0]) echo "No.30";?></th><td colspan="3" class="red"><?=$code30[0]?></td>
</tr>
<? } ?>
<? if($row4['code31'] || $row4['code32'] || $row4['code33']) {?>
<tr height="35">
<th><?if($code31[0]) echo "No.31";?></th><td colspan="2" class="red"><?=$code31[0]?></td>
<th><?if($code32[0]) echo "No.32";?></th><td colspan="3" class="red"><?=$code32[0]?></td>
<th><?if($code33[0]) echo "No.33";?></th><td colspan="3" class="red"><?=$code33[0]?></td>
</tr>
<? } ?>
<? if($row4['code34'] || $row4['code35'] || $row4['code36']) {?>
<tr height="35">
<th><?if($code34[0]) echo "No.34";?></th><td colspan="2" class="red"><?=$code34[0]?></td>
<th><?if($code35[0]) echo "No.35";?></th><td colspan="3" class="red"><?=$code35[0]?></td>
<th><?if($code36[0]) echo "No.36";?></th><td colspan="3" class="red"><?=$code36[0]?></td>
</tr>
<? } ?>
<? if($row4['code37'] || $row4['code38'] || $row4['code39']) {?>
<tr height="35">
<th><?if($code37[0]) echo "No.37";?></th><td colspan="2" class="red"><?=$code37[0]?></td>
<th><?if($code38[0]) echo "No.38";?></th><td colspan="3" class="red"><?=$code38[0]?></td>
<th><?if($code39[0]) echo "No.39";?></th><td colspan="3" class="red"><?=$code39[0]?></td>
</tr>
<? } ?>
<? if($row4['code40'] || $row4['code41'] || $row4['code42']) {?>
<tr height="35">
<th><?if($code40[0]) echo "No.40";?></th><td colspan="2" class="red"><?=$code40[0]?></td>
<th><?if($code41[0]) echo "No.41";?></th><td colspan="3" class="red"><?=$code41[0]?></td>
<th><?if($code42[0]) echo "No.42";?></th><td colspan="3" class="red"><?=$code42[0]?></td>
</tr>
<? } ?>
<? if($row4['code43'] || $row4['code44'] || $row4['code45']) {?>
<tr height="35">
<th><?if($code43[0]) echo "No.43";?></th><td colspan="2" class="red"><?=$code43[0]?></td>
<th><?if($code44[0]) echo "No.44";?></th><td colspan="3" class="red"><?=$code44[0]?></td>
<th><?if($code45[0]) echo "No.45";?></th><td colspan="3" class="red"><?=$code45[0]?></td>
</tr>
<? } ?>
<? if($row4['code46'] || $row4['code47'] || $row4['code48']) {?>
<tr height="35">
<th><?if($code46[0]) echo "No.46";?></th><td colspan="2" class="red"><?=$code46[0]?></td>
<th><?if($code47[0]) echo "No.47";?></th><td colspan="3" class="red"><?=$code47[0]?></td>
<th><?if($code48[0]) echo "No.48";?></th><td colspan="3" class="red"><?=$code48[0]?></td>
</tr>
<? } ?>
<? if($row4['code49'] || $row4['code50']) {?>
<tr height="35">
<th><?if($code49[0]) echo "No.49";?></th><td colspan="2" class="red"><?=$code49[0]?></td>
<th><?if($code50[0]) echo "No.50";?></th><td colspan="3" class="red"><?=$code50[0]?></td>
<th></th><td colspan="3"></td>
</tr>
<? } ?>
<? endif; ?>
<? if($row4['code_type']=='qrcode') : ?>
<? if($row4['code1'] || $row4['code2'] || $row4['code3']) {?>
<tr height="130">
<?if($code1[0]){?><th>No.1</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code1[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code2[0]){?><th>No.2</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code2[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code3[0]){?><th>No.3</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code3[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code4'] || $row4['code5'] || $row4['code6']) {?>
<tr height="130">
<?if($code4[0]){?><th>No.4</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code4[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code5[0]){?><th>No.5</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code5[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code6[0]){?><th>No.6</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code6[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code7'] || $row4['code8'] || $row4['code9']) {?>
<tr height="130">
<?if($code7[0]){?><th>No.7</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code7[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code8[0]){?><th>No.8</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code8[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code9[0]){?><th>No.9</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code9[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code10'] || $row4['code11'] || $row4['code12']) {?>
<tr height="130">
<?if($code10[0]){?><th>No.10</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code10[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code11[0]){?><th>No.11</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code11[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code12[0]){?><th>No.12</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code12[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code13'] || $row4['code14'] || $row4['code15']) {?>
<tr height="130">
<?if($code13[0]){?><th>No.13</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code13[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code14[0]){?><th>No.14</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code14[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code15[0]){?><th>No.15</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code15[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code16'] || $row4['code17'] || $row4['code18'] ) {?>
<tr height="130">
<?if($code16[0]){?><th>No.16</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code16[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code17[0]){?><th>No.17</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code17[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code18[0]){?><th>No.18</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code18[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code19'] || $row4['code20'] || $row4['code21']) {?>
<tr height="130">
<?if($code19[0]){?><th>No.19</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code19[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code20[0]){?><th>No.20</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code20[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code21[0]){?><th>No.21</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code21[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code22'] || $row4['code23'] || $row4['code24']) {?>
<tr height="130">
<?if($code22[0]){?><th>No.22</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code22[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code23[0]){?><th>No.23</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code23[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code24[0]){?><th>No.24</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code24[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code25'] || $row4['code26'] || $row4['code27']) {?>
<tr height="130">
<?if($code25[0]){?><th>No.25</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code25[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code26[0]){?><th>No.26</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code26[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code27[0]){?><th>No.27</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code27[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code28'] || $row4['code29'] || $row4['code30']) {?>
<tr height="130">
<?if($code28[0]){?><th>No.28</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code28[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code29[0]){?><th>No.29</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code29[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code30[0]){?><th>No.30</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code31[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code31'] || $row4['code32'] || $row4['code33']) {?>
<tr height="130">
<?if($code31[0]){?><th>No.31</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code31[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code32[0]){?><th>No.32</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code32[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code33[0]){?><th>No.33</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code33[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code34'] || $row4['code35'] || $row4['code36']) {?>
<tr height="130">
<?if($code34[0]){?><th>No.34</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code34[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code35[0]){?><th>No.35</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code35[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code36[0]){?><th>No.36</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code36[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code37'] || $row4['code37'] || $row4['code37']) {?>
<tr height="130">
<?if($code37[0]){?><th>No.37</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code37[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code38[0]){?><th>No.38</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code38[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code39[0]){?><th>No.39</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code39[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code40'] || $row4['code41'] || $row4['code42']) {?>
<tr height="130">
<?if($code40[0]){?><th>No.40</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code40[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code41[0]){?><th>No.41</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code41[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code42[0]){?><th>No.42</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code42[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code43'] || $row4['code44'] || $row4['code45']) {?>
<tr height="130">
<?if($code43[0]){?><th>No.43</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code43[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code44[0]){?><th>No.44</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code44[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code45[0]){?><th>No.45</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code45[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code46'] || $row4['code47'] || $row4['code48']) {?>
<tr height="130">
<?if($code46[0]){?><th>No.46</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code46[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code47[0]){?><th>No.47</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code47[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code48[0]){?><th>No.48</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code48[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code49'] || $row4['code50']) {?>
<tr height="130">
<?if($code49[0]){?><th>No.49</th><td colspan="2" align="center"><img src="<?=$upload?><?=$code49[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code50[0]){?><th>No.50</th><td colspan="3" align="center"><img src="<?=$upload?><?=$code50[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<th></th><td colspan="3"></td>
</tr>
<? } ?>
<? endif; ?>
</table>
</td>
</tr>
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="20"> </td>
</tr>
</table>
</td>
</tr>
<!-- guest detail -->
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="35">■ Guest Details 客人資料 :</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<thead>
<tr height="35">
<th colspan="4">Name</th>
<th colspan="3">Persons</th>
<th colspan="4">Nationality</th>
</tr>
</thead>
<tbody>
<? if($row4['code1']) {?>
<tr height="35">
<td colspan="4"><?=$code1[1]?></td>
<td colspan="3"><?=$code1[2]?></td>
<td colspan="4"><?=$code1[3]?></td>
</tr>
<? } ?>
<? if($row4['code2']) {?>
<tr height="35">
<td colspan="4"><?=$code2[1]?></td>
<td colspan="3"><?=$code2[2]?></td>
<td colspan="4"><?=$code2[3]?></td>
</tr>
<? } ?>
<? if($row4['code3']) {?>
<tr height="35">
<td colspan="4"><?=$code3[1]?></td>
<td colspan="3"><?=$code3[2]?></td>
<td colspan="4"><?=$code3[3]?></td>
</tr>
<? } ?>
<? if($row4['code4']) {?>
<tr height="35">
<td colspan="4"><?=$code4[1]?></td>
<td colspan="3"><?=$code4[2]?></td>
<td colspan="4"><?=$code4[3]?></td>
</tr>
<? } ?>
<? if($row4['code5']) {?>
<tr height="35">
<td colspan="4"><?=$code5[1]?></td>
<td colspan="3"><?=$code5[2]?></td>
<td colspan="4"><?=$code5[3]?></td>
</tr>
<? } ?>
<? if($row4['code6']) {?>
<tr height="35">
<td colspan="4"><?=$code6[1]?></td>
<td colspan="3"><?=$code6[2]?></td>
<td colspan="4"><?=$code6[3]?></td>
</tr>
<? } ?>
<? if($row4['code7']) {?>
<tr height="35">
<td colspan="4"><?=$code1[7]?></td>
<td colspan="3"><?=$code1[7]?></td>
<td colspan="4"><?=$code1[7]?></td>
</tr>
<? } ?>
<? if($row4['code8']) {?>
<tr height="35">
<td colspan="4"><?=$code8[1]?></td>
<td colspan="3"><?=$code8[2]?></td>
<td colspan="4"><?=$code8[3]?></td>
</tr>
<? } ?>
<? if($row4['code9']) {?>
<tr height="35">
<td colspan="4"><?=$code9[1]?></td>
<td colspan="3"><?=$code9[2]?></td>
<td colspan="4"><?=$code9[3]?></td>
</tr>
<? } ?>
<? if($row4['code10']) {?>
<tr height="35">
<td colspan="4"><?=$code10[1]?></td>
<td colspan="3"><?=$code10[2]?></td>
<td colspan="4"><?=$code10[3]?></td>
</tr>
<? } ?>
<? if($row4['code11']) {?>
<tr height="35">
<td colspan="4"><?=$code11[1]?></td>
<td colspan="3"><?=$code11[2]?></td>
<td colspan="4"><?=$code11[3]?></td>
</tr>
<? } ?>
<? if($row4['code12']) {?>
<tr height="35">
<td colspan="4"><?=$code12[1]?></td>
<td colspan="3"><?=$code12[2]?></td>
<td colspan="4"><?=$code12[3]?></td>
</tr>
<? } ?>
<? if($row4['code13']) {?>
<tr height="35">
<td colspan="4"><?=$code13[1]?></td>
<td colspan="3"><?=$code13[2]?></td>
<td colspan="4"><?=$code13[3]?></td>
</tr>
<? } ?>
<? if($row4['code14']) {?>
<tr height="35">
<td colspan="4"><?=$code14[1]?></td>
<td colspan="3"><?=$code14[2]?></td>
<td colspan="4"><?=$code14[3]?></td>
</tr>
<? } ?>
<? if($row4['code15']) {?>
<tr height="35">
<td colspan="4"><?=$code15[1]?></td>
<td colspan="3"><?=$code15[2]?></td>
<td colspan="4"><?=$code15[3]?></td>
</tr>
<? } ?>
<? if($row4['code16']) {?>
<tr height="35">
<td colspan="4"><?=$code16[1]?></td>
<td colspan="3"><?=$code16[2]?></td>
<td colspan="4"><?=$code16[3]?></td>
</tr>
<? } ?>
<? if($row4['code17']) {?>
<tr height="35">
<td colspan="4"><?=$code17[1]?></td>
<td colspan="3"><?=$code17[2]?></td>
<td colspan="4"><?=$code17[3]?></td>
</tr>
<? } ?>
<? if($row4['code18']) {?>
<tr height="35">
<td colspan="4"><?=$code18[1]?></td>
<td colspan="3"><?=$code18[2]?></td>
<td colspan="4"><?=$code18[3]?></td>
</tr>
<? } ?>
<? if($row4['code19']) {?>
<tr height="35">
<td colspan="4"><?=$code19[1]?></td>
<td colspan="3"><?=$code19[2]?></td>
<td colspan="4"><?=$code19[3]?></td>
</tr>
<? } ?>
<? if($row4['code20']) {?>
<tr height="35">
<td colspan="4"><?=$code20[1]?></td>
<td colspan="3"><?=$code20[2]?></td>
<td colspan="4"><?=$code20[3]?></td>
</tr>
<? } ?>
<? if($row4['code21']) {?>
<tr height="35">
<td colspan="4"><?=$code21[1]?></td>
<td colspan="3"><?=$code21[2]?></td>
<td colspan="4"><?=$code21[3]?></td>
</tr>
<? } ?>
<? if($row4['code22']) {?>
<tr height="35">
<td colspan="4"><?=$code22[1]?></td>
<td colspan="3"><?=$code22[2]?></td>
<td colspan="4"><?=$code22[3]?></td>
</tr>
<? } ?>
<? if($row4['code23']) {?>
<tr height="35">
<td colspan="4"><?=$code23[1]?></td>
<td colspan="3"><?=$code23[2]?></td>
<td colspan="5"><?=$code23[3]?></td>
</tr>
<? } ?>
<? if($row4['code24']) {?>
<tr height="35">
<td colspan="4"><?=$code24[1]?></td>
<td colspan="3"><?=$code24[2]?></td>
<td colspan="4"><?=$code24[3]?></td>
</tr>
<? } ?>
<? if($row4['code25']) {?>
<tr height="35">
<td colspan="4"><?=$code25[1]?></td>
<td colspan="3"><?=$code25[2]?></td>
<td colspan="4"><?=$code25[3]?></td>
</tr>
<? } ?>
<? if($row4['code26']) {?>
<tr height="35">
<td colspan="4"><?=$code26[1]?></td>
<td colspan="3"><?=$code26[2]?></td>
<td colspan="4"><?=$code26[3]?></td>
</tr>
<? } ?>
<? if($row4['code27']) {?>
<tr height="35">
<td colspan="4"><?=$code27[1]?></td>
<td colspan="3"><?=$code27[2]?></td>
<td colspan="4"><?=$code27[3]?></td>
</tr>
<? } ?>
<? if($row4['code28']) {?>
<tr height="35">
<td colspan="4"><?=$code28[1]?></td>
<td colspan="3"><?=$code28[2]?></td>
<td colspan="4"><?=$code28[3]?></td>
</tr>
<? } ?>
<? if($row4['code29']) {?>
<tr height="35">
<td colspan="4"><?=$code29[1]?></td>
<td colspan="3"><?=$code29[2]?></td>
<td colspan="4"><?=$code29[3]?></td>
</tr>
<? } ?>
<? if($row4['code30']) {?>
<tr height="35">
<td colspan="4"><?=$code30[1]?></td>
<td colspan="3"><?=$code30[2]?></td>
<td colspan="4"><?=$code30[3]?></td>
</tr>
<? } ?>
<? if($row4['code31']) {?>
<tr height="35">
<td colspan="4"><?=$code31[1]?></td>
<td colspan="3"><?=$code31[2]?></td>
<td colspan="4"><?=$code31[3]?></td>
</tr>
<? } ?>
<? if($row4['code32']) {?>
<tr height="35">
<td colspan="4"><?=$code32[1]?></td>
<td colspan="3"><?=$code32[2]?></td>
<td colspan="4"><?=$code32[3]?></td>
</tr>
<? } ?>
<? if($row4['code33']) {?>
<tr height="35">
<td colspan="4"><?=$code33[1]?></td>
<td colspan="3"><?=$code33[2]?></td>
<td colspan="4"><?=$code33[3]?></td>
</tr>
<? } ?>
<? if($row4['code34']) {?>
<tr height="35">
<td colspan="4"><?=$code34[1]?></td>
<td colspan="3"><?=$code34[2]?></td>
<td colspan="4"><?=$code34[3]?></td>
</tr>
<? } ?>
<? if($row4['code35']) {?>
<tr height="35">
<td colspan="4"><?=$code35[1]?></td>
<td colspan="3"><?=$code35[2]?></td>
<td colspan="4"><?=$code35[3]?></td>
</tr>
<? } ?>
<? if($row4['code36']) {?>
<tr height="35">
<td colspan="4"><?=$code36[1]?></td>
<td colspan="3"><?=$code36[2]?></td>
<td colspan="4"><?=$code36[3]?></td>
</tr>
<? } ?>
<? if($row4['code37']) {?>
<tr height="35">
<td colspan="4"><?=$code37[1]?></td>
<td colspan="3"><?=$code37[2]?></td>
<td colspan="4"><?=$code37[3]?></td>
</tr>
<? } ?>
<? if($row4['code38']) {?>
<tr height="35">
<td colspan="4"><?=$code38[1]?></td>
<td colspan="3"><?=$code38[2]?></td>
<td colspan="4"><?=$code38[3]?></td>
</tr>
<? } ?>
<? if($row4['code39']) {?>
<tr height="35">
<td colspan="4"><?=$code39[1]?></td>
<td colspan="3"><?=$code39[2]?></td>
<td colspan="4"><?=$code39[3]?></td>
</tr>
<? } ?>
<? if($row4['code40']) {?>
<tr height="35">
<td colspan="4"><?=$code40[1]?></td>
<td colspan="3"><?=$code40[2]?></td>
<td colspan="4"><?=$code40[3]?></td>
</tr>
<? } ?>
<? if($row4['code41']) {?>
<tr height="35">
<td colspan="4"><?=$code41[1]?></td>
<td colspan="3"><?=$code41[2]?></td>
<td colspan="4"><?=$code41[3]?></td>
</tr>
<? } ?>
<? if($row4['code42']) {?>
<tr height="35">
<td colspan="4"><?=$code42[1]?></td>
<td colspan="3"><?=$code42[2]?></td>
<td colspan="4"><?=$code42[3]?></td>
</tr>
<? } ?>
<? if($row4['code43']) {?>
<tr height="35">
<td colspan="4"><?=$code43[1]?></td>
<td colspan="3"><?=$code43[2]?></td>
<td colspan="4"><?=$code43[3]?></td>
</tr>
<? } ?>
<? if($row4['code44']) {?>
<tr height="35">
<td colspan="4"><?=$code44[1]?></td>
<td colspan="3"><?=$code44[2]?></td>
<td colspan="4"><?=$code44[3]?></td>
</tr>
<? } ?>
<? if($row4['code45']) {?>
<tr height="35">
<td colspan="4"><?=$code45[1]?></td>
<td colspan="3"><?=$code45[2]?></td>
<td colspan="5"><?=$code45[3]?></td>
</tr>
<? } ?>
<? if($row4['code46']) {?>
<tr height="35">
<td colspan="4"><?=$code46[1]?></td>
<td colspan="3"><?=$code46[2]?></td>
<td colspan="4"><?=$code46[3]?></td>
</tr>
<? } ?>
<? if($row4['code47']) {?>
<tr height="35">
<td colspan="4"><?=$code47[1]?></td>
<td colspan="3"><?=$code47[2]?></td>
<td colspan="4"><?=$code47[3]?></td>
</tr>
<? } ?>
<? if($row4['code48']) {?>
<tr height="35">
<td colspan="4"><?=$code48[1]?></td>
<td colspan="3"><?=$code48[2]?></td>
<td colspan="4"><?=$code48[3]?></td>
</tr>
<? } ?>
<? if($row4['code49']) {?>
<tr height="35">
<td colspan="4"><?=$code49[1]?></td>
<td colspan="3"><?=$code49[2]?></td>
<td colspan="4"><?=$code49[3]?></td>
</tr>
<? } ?>
<? if($row4['code50']) {?>
<tr height="35">
<td colspan="4"><?=$code50[1]?></td>
<td colspan="3"><?=$code50[2]?></td>
<td colspan="4"><?=$code50[3]?></td>
</tr>
<? } ?>
</table>
</td>
</tr>
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="20"> </td>
</tr>
</table>
</td>
</tr>
<!-- voucher 사용방법 -->
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="35">■ How to use</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<? for($i=0,$j=1 ; $i<count($use_method)-1 ; $i++,$j++){ ?>
<tr height="35">
<th> (<?=$j?>)</th>
<td colspan="10" class="txt_left"><?=$use_method[$i]?></td>
</tr>
<? } ?>
</table>
</td>
</tr>
<!-- 미팅장소 및 교환장소 -->
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="2-"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="35">■ Meeting Point & Redemption Place</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<tr>
<td colspan="11" height="350">
<?if($row4['meeting_place']){?><img src="<?=$row4['img_src']?>" alt="미팅장소이미지" /><?}?></td>
</tr>
</table>
</td>
</tr>
<!-- contact us -->
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="20"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1" class="qtable">
<tr>
<th colspan="3">Contact Us</th>
<td colspan="8" class="txt_left" style="min-height:35px">
<?
$contact = stripslashes($row4['contact_us']);
$contact = nl2br($contact);
//$contact = str_replace("\n", "<br style='mso-data-placement:same-cell'>", $contact);
echo $contact;
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table border=0>
<tr>
<td colspan="11" height="20"> </td>
</tr>
<tr>
<td colspan="11" height="72" align="right"><img src="http://tourboss.co.kr/admin/erp/img/excel_sign_tktravel.jpg" alt="sign" border="0" width="700" height="72" /></td>
</tr>
<tr>
<td colspan="11" height="20"> </td>
</tr>
<tr height="105">
<td colspan="11"><img src="http://tourboss.co.kr/admin/TCPDF/erp/images/pdf_footer_tktravel.jpg" width="700" height="105"></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>