|
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']+$row['num_foc']));
}
// 엑셀 파일명 설정
$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_thum . $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']);
}
?>
<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;}
-->
</style>
<style>
.qrcode {
cursor:pointer;width:100px;height:auto;display:inline;
margin-right:10px;
padding:10px;
border: #000 solid 2px;
background: #fff;
}
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</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 width="700" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>예약정보</strong></div>
</td>
</tr>
<!-- 예약정보 -->
<tr>
<td valign="top">
<table width="700" border="1" cellspacing="0" cellpadding="10" class="setting_write">
<tbody>
<tr>
<th width="9%">ATTN</th>
<td colspan="6"><?=$row['attn']?></td>
<th width="9%">FROM</th>
<td width="20%"><?=$row['admin_nm']?></td>
<th width="9%">담당자</th>
<td width="20%"><?=$row['charger']?></td>
</tr>
<tr>
<th>행사명</th>
<td colspan="6"><?=$row['good_name']?></td>
<th>행사날짜</th>
<td colspan="3">
<?=$row['start_date']?> ~ <?=$row['end_date']?>
<span id="periods"><?=$row['periods']?></span>
</td>
</tr>
<tr>
<th>호텔명</th>
<td colspan="6"><?=$row['hotel_name']?></td>
<th>차량정보</th>
<td colspan="3"><?=$row['car_info']?></td>
</tr>
<tr>
<th>예약자명</th>
<td colspan="3"><?=$row['res_name']?></td>
<th>국적</th>
<td colspan="2"><?=$row['res_nationality']?></td>
<th>계약금</th>
<td colspan="3">
<?=$row['currency']?><?=number_format($row['deposit'])?>
</td>
</tr>
<tr>
<th>연락처</th>
<td colspan="3"> <?=$row['res_phone']?></td>
<th>이메일</th>
<td colspan="2"><?=$row['res_email']?></td>
<th>잔금</th>
<td colspan="3">
<?=$row['currency']?><?=number_format($row['balance'])?>
</td>
</tr>
<tr>
<th>인원</th>
<th width="9%">Adult</th>
<td width="5%"><?=$row['num_adult']?></td>
<th width="9%">Child</th>
<td width="5%"><?=$row['num_child']?></td>
<th width="9%">FOC</th>
<td width="5%"><?=$row['num_foc']?></td>
<th>최종합계</th>
<td>
<span id="total"><?=$row['currency']?><?=number_format($row['total_price'])?></span>
</td>
<th>1인투어비</th>
<td>
<span id="per_amount"><?=$row['currency']?><?=number_format($price_per_one)?></span>
</td>
</tr>
<tr>
<th>입금기한</th>
<td colspan="10" align="left"><?=$row['date_payment']?></td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<!-- //예약정보 -->
<!-- VOUCHER -->
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>VOUCHER 정보</strong></div>
</td>
</tr>
<tr>
<td valign="top">
<table width="590" border="1" cellspacing="0" cellpadding="0" class="setting_write">
<tbody>
<tr>
<th>코드타입</th>
<td>
<?
if($row4['code_type']=='voucher') echo "Voucher";
elseif($row4['code_type']=='qrcode') echo "Qrcode Number";
?>
</td>
</tr>
</tbody>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<!-- //VOUCHER -->
<!-- 세부항목 -->
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>세부항목 수량</strong></div>
</td>
</tr>
<tr>
<td valign="top">
<? if($row4['code_type']=='voucher') : ?>
<table width="590" border="1" cellspacing="0" cellpadding="0">
<? if($row4['code1'] || $row4['code2'] || $row4['code3'] || $row4['code4'] || $row4['code5']) {?>
<tr>
<td>Voucher1</td><td><?=$code1[0]?></td>
<td>Voucher2</td><td><?=$code2[0]?></td>
<td>Voucher3</td><td><?=$code3[0]?></td>
<td>Voucher4</td><td><?=$code4[0]?></td>
<td>Voucher5</td><td><?=$code5[0]?></td>
</tr>
<? } ?>
<? if($row4['code6'] || $row4['code7'] || $row4['code7'] || $row4['code9'] || $row4['code10']) {?>
<tr>
<td>Voucher6</td><td><?=$code6[0]?></td>
<td>Voucher7</td><td><?=$code7[0]?></td>
<td>Voucher8</td><td><?=$code8[0]?></td>
<td>Voucher9</td><td><?=$code9[0]?></td>
<td>Voucher10</td><td><?=$code10[0]?></td>
</tr>
<? } ?>
<? if($row4['code11'] || $row4['code12'] || $row4['code13'] || $row4['code14'] || $row4['code15']) {?>
<tr>
<td>Voucher11</td><td><?=$code11[0]?></td>
<td>Voucher12</td><td><?=$code12[0]?></td>
<td>Voucher13</td><td><?=$code13[0]?></td>
<td>Voucher14</td><td><?=$code14[0]?></td>
<td>Voucher15</td><td><?=$code15[0]?></td>
</tr>
<? } ?>
<? if($row4['code16'] || $row4['code17'] || $row4['code18'] || $row4['code19'] || $row4['code20']) {?>
<tr>
<td>Voucher16</td><td><?=$code16[0]?></td>
<td>Voucher17</td><td><?=$code17[0]?></td>
<td>Voucher18</td><td><?=$code18[0]?></td>
<td>Voucher19</td><td><?=$code19[0]?></td>
<td>Voucher20</td><td><?=$code20[0]?></td>
</tr>
<? } ?>
<? if($row4['code21'] || $row4['code22'] || $row4['code23'] || $row4['code24'] || $row4['code25']) {?>
<tr>
<td>Voucher21</td><td><?=$code21[0]?></td>
<td>Voucher22</td><td><?=$code22[0]?></td>
<td>Voucher23</td><td><?=$code23[0]?></td>
<td>Voucher24</td><td><?=$code24[0]?></td>
<td>Voucher25</td><td><?=$code25[0]?></td>
</tr>
<? } ?>
<? if($row4['code26'] || $row4['code27'] || $row4['code28'] || $row4['code29'] || $row4['code30']) {?>
<tr>
<td>Voucher26</td><td><?=$code26[0]?></td>
<td>Voucher27</td><td><?=$code27[0]?></td>
<td>Voucher28</td><td><?=$code28[0]?></td>
<td>Voucher29</td><td><?=$code29[0]?></td>
<td>Voucher30</td><td><?=$code30[0]?></td>
</tr>
<? } ?>
<? if($row4['code31'] || $row4['code32'] || $row4['code33'] || $row4['code34'] || $row4['code35']) {?>
<tr>
<td>Voucher31</td><td><?=$code31[0]?></td>
<td>Voucher32</td><td><?=$code32[0]?></td>
<td>Voucher33</td><td><?=$code33[0]?></td>
<td>Voucher34</td><td><?=$code34[0]?></td>
<td>Voucher35</td><td><?=$code35[0]?></td>
</tr>
<? } ?>
<? if($row4['code36'] || $row4['code37'] || $row4['code38'] || $row4['code39'] || $row4['code40']) {?>
<tr>
<td>Voucher36</td><td><?=$code36[0]?></td>
<td>Voucher37</td><td><?=$code37[0]?></td>
<td>Voucher38</td><td><?=$code38[0]?></td>
<td>Voucher39</td><td><?=$code39[0]?></td>
<td>Voucher40</td><td><?=$code40[0]?></td>
</tr>
<? } ?>
<? if($row4['code41'] || $row4['code42'] || $row4['code43'] || $row4['code44'] || $row4['code45']) {?>
<tr>
<td>Voucher41</td><td><?=$code41[0]?></td>
<td>Voucher42</td><td><?=$code42[0]?></td>
<td>Voucher43</td><td><?=$code43[0]?></td>
<td>Voucher44</td><td><?=$code44[0]?></td>
<td>Voucher45</td><td><?=$code45[0]?></td>
</tr>
<? } ?>
<? if($row4['code46'] || $row4['code47'] || $row4['code48'] || $row4['code49'] || $row4['code50']) {?>
<tr>
<td>Voucher46</td><td><?=$code46[0]?></td>
<td>Voucher47</td><td><?=$code47[0]?></td>
<td>Voucher48</td><td><?=$code48[0]?></td>
<td>Voucher49</td><td><?=$code49[0]?></td>
<td>Voucher50</td><td><?=$code50[0]?></td>
</tr>
<? } ?>
</table>
<? endif; ?>
<? if($row4['code_type']=='qrcode') : ?>
<table width="590" border="1" cellspacing="0" cellpadding="0">
<? if($row4['code1'] || $row4['code2'] || $row4['code3'] || $row4['code4'] || $row4['code5']) {?>
<tr height="130">
<?if($code1[0]){?><td>Qrcode1</td><td><img src="<?=$upload?><?=$code1[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code2[0]){?><td>Qrcode2</td><td colspan="3"><img src="<?=$upload?><?=$code2[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code3[0]){?><td>Qrcode3</td><td colspan="2"><img src="<?=$upload?><?=$code3[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code4[0]){?><td>Qrcode4</td><td colspan="2"><img src="<?=$upload?><?=$code4[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code5[0]){?><td>Qrcode5</td><td colspan="2"><img src="<?=$upload?><?=$code5[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code6'] || $row4['code7'] || $row4['code8'] || $row4['code9'] || $row4['code10']) {?>
<tr height="130">
<?if($code6[0]){?><td>Qrcode6</td><td><img src="<?=$upload?><?=$code6[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code7[0]){?><td>Qrcode7</td><td colspan="3"><img src="<?=$upload?><?=$code7[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code8[0]){?><td>Qrcode8</td><td colspan="2"><img src="<?=$upload?><?=$code8[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code9[0]){?><td>Qrcode9</td><td colspan="2"><img src="<?=$upload?><?=$code9[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code10[0]){?><td>Qrcode10</td><td colspan="2"><img src="<?=$upload?><?=$code10[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code11'] || $row4['code12'] || $row4['code13'] || $row4['code14'] || $row4['code15']) {?>
<tr height="130">
<?if($code11[0]){?><td>Qrcode11</td><td><img src="<?=$upload?><?=$code11[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code12[0]){?><td>Qrcode12</td><td colspan="3"><img src="<?=$upload?><?=$code12[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code13[0]){?><td>Qrcode13</td><td colspan="2"><img src="<?=$upload?><?=$code13[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code14[0]){?><td>Qrcode14</td><td colspan="2"><img src="<?=$upload?><?=$code14[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code15[0]){?><td>Qrcode15</td><td colspan="2"><img src="<?=$upload?><?=$code15[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code16'] || $row4['code17'] || $row4['code18'] || $row4['code19'] || $row4['code20']) {?>
<tr height="130">
<?if($code16[0]){?><td>Qrcode16</td><td><img src="<?=$upload?><?=$code16[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code17[0]){?><td>Qrcode17</td><td colspan="3"><img src="<?=$upload?><?=$code17[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code18[0]){?><td>Qrcode18</td><td colspan="2"><img src="<?=$upload?><?=$code18[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code19[0]){?><td>Qrcode19</td><td colspan="2"><img src="<?=$upload?><?=$code19[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code20[0]){?><td>Qrcode20</td><td colspan="2"><img src="<?=$upload?><?=$code20[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code21'] || $row4['code22'] || $row4['code23'] || $row4['code24'] || $row4['code25']) {?>
<tr height="130">
<?if($code21[0]){?><td>Qrcode21</td><td><img src="<?=$upload?><?=$code21[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code22[0]){?><td>Qrcode22</td><td colspan="3"><img src="<?=$upload?><?=$code22[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code23[0]){?><td>Qrcode23</td><td colspan="2"><img src="<?=$upload?><?=$code23[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code24[0]){?><td>Qrcode24</td><td colspan="2"><img src="<?=$upload?><?=$code24[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code25[0]){?><td>Qrcode25</td><td colspan="2"><img src="<?=$upload?><?=$code25[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code26'] || $row4['code27'] || $row4['code28'] || $row4['code29'] || $row4['code30']) {?>
<tr height="130">
<?if($code26[0]){?><td>Qrcode26</td><td><img src="<?=$upload?><?=$code26[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code27[0]){?><td>Qrcode27</td><td colspan="3"><img src="<?=$upload?><?=$code27[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code28[0]){?><td>Qrcode28</td><td colspan="2"><img src="<?=$upload?><?=$code28[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code29[0]){?><td>Qrcode29</td><td colspan="2"><img src="<?=$upload?><?=$code29[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code30[0]){?><td>Qrcode30</td><td colspan="2"><img src="<?=$upload?><?=$code30[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code31'] || $row4['code32'] || $row4['code33'] || $row4['code34'] || $row4['code35']) {?>
<tr height="130">
<?if($code31[0]){?><td>Qrcode31</td><td><img src="<?=$upload?><?=$code31[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code32[0]){?><td>Qrcode32</td><td colspan="3"><img src="<?=$upload?><?=$code32[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code33[0]){?><td>Qrcode33</td><td colspan="2"><img src="<?=$upload?><?=$code33[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code34[0]){?><td>Qrcode34</td><td colspan="2"><img src="<?=$upload?><?=$code34[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code35[0]){?><td>Qrcode35</td><td colspan="2"><img src="<?=$upload?><?=$code35[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code36'] || $row4['code37'] || $row4['code38'] || $row4['code39'] || $row4['code40']) {?>
<tr height="130">
<?if($code36[0]){?><td>Qrcode36</td><td><img src="<?=$upload?><?=$code36[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code37[0]){?><td>Qrcode37</td><td colspan="3"><img src="<?=$upload?><?=$code37[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code38[0]){?><td>Qrcode38</td><td colspan="2"><img src="<?=$upload?><?=$code38[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code39[0]){?><td>Qrcode39</td><td colspan="2"><img src="<?=$upload?><?=$code39[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code40[0]){?><td>Qrcode40</td><td colspan="2"><img src="<?=$upload?><?=$code40[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code41'] || $row4['code42'] || $row4['code43'] || $row4['code44'] || $row4['code45']) {?>
<tr height="130">
<?if($code41[0]){?><td>Qrcode41</td><td><img src="<?=$upload?><?=$code41[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code42[0]){?><td>Qrcode42</td><td colspan="3"><img src="<?=$upload?><?=$code42[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code43[0]){?><td>Qrcode43</td><td colspan="2"><img src="<?=$upload?><?=$code43[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code44[0]){?><td>Qrcode44</td><td colspan="2"><img src="<?=$upload?><?=$code44[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code45[0]){?><td>Qrcode45</td><td colspan="2"><img src="<?=$upload?><?=$code45[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
<? if($row4['code46'] || $row4['code47'] || $row4['code48'] || $row4['code49'] || $row4['code50']) {?>
<tr height="130">
<?if($code46[0]){?><td>Qrcode46</td><td><img src="<?=$upload?><?=$code46[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code47[0]){?><td>Qrcode47</td><td colspan="3"><img src="<?=$upload?><?=$code47[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code48[0]){?><td>Qrcode48</td><td colspan="2"><img src="<?=$upload?><?=$code48[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code49[0]){?><td>Qrcode49</td><td colspan="2"><img src="<?=$upload?><?=$code49[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
<?if($code50[0]){?><td>Qrcode50</td><td colspan="2"><img src="<?=$upload?><?=$code50[0]?>" alt="qrcode" class="qrcode" /></td><?}?>
</tr>
<? } ?>
</table>
<? endif; ?>
</td>
</tr>
<tr>
<td> </td>
</tr>
<!-- //세부항목 -->
<!-- guest detail -->
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>Guest Details</strong></div>
</td>
</tr>
<tr>
<td valign="top">
<table width="590" border="1" cellspacing="0" cellpadding="0" class="item_addon_guest_box">
<thead>
<tr>
<th>Name</th>
<th>Persons</th>
<th>Nationality</th>
</tr>
</thead>
<tbody>
<? if($row4['code1']) {?>
<tr>
<td><?=$code1[1]?></td>
<td><?=$code1[2]?></td>
<td><?=$code1[3]?></td>
</tr>
<? } ?>
<? if($row4['code2']) {?>
<tr>
<td><?=$code2[1]?></td>
<td><?=$code2[2]?></td>
<td><?=$code2[3]?></td>
</tr>
<? } ?>
<? if($row4['code3']) {?>
<tr>
<td><?=$code3[1]?></td>
<td><?=$code3[2]?></td>
<td><?=$code3[3]?></td>
</tr>
<? } ?>
<? if($row4['code4']) {?>
<tr>
<td><?=$code4[1]?></td>
<td><?=$code4[2]?></td>
<td><?=$code4[3]?></td>
</tr>
<? } ?>
<? if($row4['code5']) {?>
<tr>
<td><?=$code5[1]?></td>
<td><?=$code5[2]?></td>
<td><?=$code5[3]?></td>
</tr>
<? } ?>
<? if($row4['code6']) {?>
<tr>
<td><?=$code6[1]?></td>
<td><?=$code6[2]?></td>
<td><?=$code6[3]?></td>
</tr>
<? } ?>
<? if($row4['code7']) {?>
<tr>
<td><?=$code1[7]?></td>
<td><?=$code1[7]?></td>
<td><?=$code1[7]?></td>
</tr>
<? } ?>
<? if($row4['code8']) {?>
<tr>
<td><?=$code8[1]?></td>
<td><?=$code8[2]?></td>
<td><?=$code8[3]?></td>
</tr>
<? } ?>
<? if($row4['code9']) {?>
<tr>
<td><?=$code9[1]?></td>
<td><?=$code9[2]?></td>
<td><?=$code9[3]?></td>
</tr>
<? } ?>
<? if($row4['code10']) {?>
<tr>
<td><?=$code10[1]?></td>
<td><?=$code10[2]?></td>
<td><?=$code10[3]?></td>
</tr>
<? } ?>
<? if($row4['code11']) {?>
<tr>
<td><?=$code11[1]?></td>
<td><?=$code11[2]?></td>
<td><?=$code11[3]?></td>
</tr>
<? } ?>
<? if($row4['code12']) {?>
<tr>
<td><?=$code12[1]?></td>
<td><?=$code12[2]?></td>
<td><?=$code12[3]?></td>
</tr>
<? } ?>
<? if($row4['code13']) {?>
<tr>
<td><?=$code13[1]?></td>
<td><?=$code13[2]?></td>
<td><?=$code13[3]?></td>
</tr>
<? } ?>
<? if($row4['code14']) {?>
<tr>
<td><?=$code14[1]?></td>
<td><?=$code14[2]?></td>
<td><?=$code14[3]?></td>
</tr>
<? } ?>
<? if($row4['code15']) {?>
<tr>
<td><?=$code15[1]?></td>
<td><?=$code15[2]?></td>
<td><?=$code15[3]?></td>
</tr>
<? } ?>
<? if($row4['code16']) {?>
<tr>
<td><?=$code16[1]?></td>
<td><?=$code16[2]?></td>
<td><?=$code16[3]?></td>
</tr>
<? } ?>
<? if($row4['code17']) {?>
<tr>
<td><?=$code17[1]?></td>
<td><?=$code17[2]?></td>
<td><?=$code17[3]?></td>
</tr>
<? } ?>
<? if($row4['code18']) {?>
<tr>
<td><?=$code18[1]?></td>
<td><?=$code18[2]?></td>
<td><?=$code18[3]?></td>
</tr>
<? } ?>
<? if($row4['code19']) {?>
<tr>
<td><?=$code19[1]?></td>
<td><?=$code19[2]?></td>
<td><?=$code19[3]?></td>
</tr>
<? } ?>
<? if($row4['code20']) {?>
<tr>
<td><?=$code20[1]?></td>
<td><?=$code20[2]?></td>
<td><?=$code20[3]?></td>
</tr>
<? } ?>
<? if($row4['code21']) {?>
<tr>
<td><?=$code21[1]?></td>
<td><?=$code21[2]?></td>
<td><?=$code21[3]?></td>
</tr>
<? } ?>
<? if($row4['code22']) {?>
<tr>
<td><?=$code22[1]?></td>
<td><?=$code22[2]?></td>
<td><?=$code22[3]?></td>
</tr>
<? } ?>
<? if($row4['code23']) {?>
<tr>
<td><?=$code23[1]?></td>
<td><?=$code23[2]?></td>
<td><?=$code23[3]?></td>
</tr>
<? } ?>
<? if($row4['code24']) {?>
<tr>
<td><?=$code24[1]?></td>
<td><?=$code24[2]?></td>
<td><?=$code24[3]?></td>
</tr>
<? } ?>
<? if($row4['code25']) {?>
<tr>
<td><?=$code25[1]?></td>
<td><?=$code25[2]?></td>
<td><?=$code25[3]?></td>
</tr>
<? } ?>
<? if($row4['code26']) {?>
<tr>
<td><?=$code26[1]?></td>
<td><?=$code26[2]?></td>
<td><?=$code26[3]?></td>
</tr>
<? } ?>
<? if($row4['code27']) {?>
<tr>
<td><?=$code27[1]?></td>
<td><?=$code27[2]?></td>
<td><?=$code27[3]?></td>
</tr>
<? } ?>
<? if($row4['code28']) {?>
<tr>
<td><?=$code28[1]?></td>
<td><?=$code28[2]?></td>
<td><?=$code28[3]?></td>
</tr>
<? } ?>
<? if($row4['code29']) {?>
<tr>
<td><?=$code29[1]?></td>
<td><?=$code29[2]?></td>
<td><?=$code29[3]?></td>
</tr>
<? } ?>
<? if($row4['code30']) {?>
<tr>
<td><?=$code30[1]?></td>
<td><?=$code30[2]?></td>
<td><?=$code30[3]?></td>
</tr>
<? } ?>
<? if($row4['code31']) {?>
<tr>
<td><?=$code31[1]?></td>
<td><?=$code31[2]?></td>
<td><?=$code31[3]?></td>
</tr>
<? } ?>
<? if($row4['code32']) {?>
<tr>
<td><?=$code32[1]?></td>
<td><?=$code32[2]?></td>
<td><?=$code32[3]?></td>
</tr>
<? } ?>
<? if($row4['code33']) {?>
<tr>
<td><?=$code33[1]?></td>
<td><?=$code33[2]?></td>
<td><?=$code33[3]?></td>
</tr>
<? } ?>
<? if($row4['code34']) {?>
<tr>
<td><?=$code34[1]?></td>
<td><?=$code34[2]?></td>
<td><?=$code34[3]?></td>
</tr>
<? } ?>
<? if($row4['code35']) {?>
<tr>
<td><?=$code35[1]?></td>
<td><?=$code35[2]?></td>
<td><?=$code35[3]?></td>
</tr>
<? } ?>
<? if($row4['code36']) {?>
<tr>
<td><?=$code36[1]?></td>
<td><?=$code36[2]?></td>
<td><?=$code36[3]?></td>
</tr>
<? } ?>
<? if($row4['code37']) {?>
<tr>
<td><?=$code37[1]?></td>
<td><?=$code37[2]?></td>
<td><?=$code37[3]?></td>
</tr>
<? } ?>
<? if($row4['code38']) {?>
<tr>
<td><?=$code38[1]?></td>
<td><?=$code38[2]?></td>
<td><?=$code38[3]?></td>
</tr>
<? } ?>
<? if($row4['code39']) {?>
<tr>
<td><?=$code39[1]?></td>
<td><?=$code39[2]?></td>
<td><?=$code39[3]?></td>
</tr>
<? } ?>
<? if($row4['code40']) {?>
<tr>
<td><?=$code40[1]?></td>
<td><?=$code40[2]?></td>
<td><?=$code40[3]?></td>
</tr>
<? } ?>
<? if($row4['code41']) {?>
<tr>
<td><?=$code41[1]?></td>
<td><?=$code41[2]?></td>
<td><?=$code41[3]?></td>
</tr>
<? } ?>
<? if($row4['code42']) {?>
<tr>
<td><?=$code42[1]?></td>
<td><?=$code42[2]?></td>
<td><?=$code42[3]?></td>
</tr>
<? } ?>
<? if($row4['code43']) {?>
<tr>
<td><?=$code43[1]?></td>
<td><?=$code43[2]?></td>
<td><?=$code43[3]?></td>
</tr>
<? } ?>
<? if($row4['code44']) {?>
<tr>
<td><?=$code44[1]?></td>
<td><?=$code44[2]?></td>
<td><?=$code44[3]?></td>
</tr>
<? } ?>
<? if($row4['code45']) {?>
<tr>
<td><?=$code45[1]?></td>
<td><?=$code45[2]?></td>
<td><?=$code45[3]?></td>
</tr>
<? } ?>
<? if($row4['code46']) {?>
<tr>
<td><?=$code46[1]?></td>
<td><?=$code46[2]?></td>
<td><?=$code46[3]?></td>
</tr>
<? } ?>
<? if($row4['code47']) {?>
<tr>
<td><?=$code47[1]?></td>
<td><?=$code47[2]?></td>
<td><?=$code47[3]?></td>
</tr>
<? } ?>
<? if($row4['code48']) {?>
<tr>
<td><?=$code48[1]?></td>
<td><?=$code48[2]?></td>
<td><?=$code48[3]?></td>
</tr>
<? } ?>
<? if($row4['code49']) {?>
<tr>
<td><?=$code49[1]?></td>
<td><?=$code49[2]?></td>
<td><?=$code49[3]?></td>
</tr>
<? } ?>
<? if($row4['code50']) {?>
<tr>
<td><?=$code50[1]?></td>
<td><?=$code50[2]?></td>
<td><?=$code50[3]?></td>
</tr>
<? } ?>
</tbody>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<!-- //guest detail -->
<!-- voucher 사용방법/미팅장소/contact us -->
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>VOUCHER 사용방법</strong></div>
</td>
</tr>
<tr>
<td>
<table width="590" border="1" cellspacing="0" cellpadding="0" id="setting_write_meeting">
<tbody>
<tr>
<th>No.</th>
<th>내용</th>
</tr>
<? for($i=0,$j=1 ; $i<count($use_method)-1 ; $i++,$j++){ ?>
<tr>
<td><?=$j?></td>
<td><?=$use_method[$i]?></td>
</tr>
<? } ?>
</tbody>
</table>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>미팅장소 및 교환장소</strong></div>
</td>
</tr>
<tr height="300">
<td style="min-height:300px">
<?if($row4['meeting_place']){?><div style="margin-top:10px"><img src="<?=$row4['img_src']?>" alt="미팅장소이미지" /></div><?}?>
</td>
</tr>
<tr>
<td> </td>
</tr>
<tr>
<td valign="top">
<div class="pop_title"><div class="lo_left"><strong>Contact Us</strong></div>
</td>
</tr>
<tr>
<td>
<?
$contact = stripslashes($row4['contact_us']);
$contact = str_replace("\n", "<br style='mso-data-placement:same-cell'>", $contact);
echo $contact;
?>
</td>
</tr>
<!-- //voucher 사용방법/미팅장소/contact us -->
</table>
</body>
</html>