ÿØÿà JFIF  ` ` ÿþš 403 WEBHELL REBORN
403 WEBHELL REBORN
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/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

Buat Folder Baru:
Buat File Baru:

Current File : /tkt_travelbus/www/admin/erp/excel_customer.php
<?
include "../include/top_proc.html";
include "_common.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']) . ")";
}

// 엑셀 파일명 설정 
$FileName = "고객리스트_".$row['good_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" );

?>

<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;}
-->
.qtable {border:collapse;width:100%; border-top: 1px solid #999999;border-left:1px solid #999999; border-spacing: 0;}
.qtable caption {display:none;}
.qtable th { background:#E7E7E7;border-top:none;border-bottom: 1px solid #999999; padding:5px 0;font-weight:bold; letter-spacing:0; vertical-align:middle; border-right:1px solid #999999;border-left:none;text-align:center;border-spacing: 0;}
.qtable td {border-right:1px solid #999999; border-bottom:1px solid #999999;border-top:none;border-left:none;  letter-spacing:0; padding:5px 0; vertical-align:middle;text-align:center;border-spacing: 0;font-weight:normal;}

.qtable td.txt_left{text-align:left;padding-left:5px;padding-right:5px;}
.qtable td.bt_none{border-bottom:none !important;}
.qtable td.bt_none1,table.qtable td.bt_none2, table.qtable td.bt_none3,table.qtable td.bt_none4,table.qtable td.bt_none5,table.qtable td.bt_none6,table.qtable td.bt_none7,table.qtable td.bt_none8,table.qtable td.bt_none9 {border-bottom:1px solid #999 ;}
.qtable td.orange{color:#ffffff;background:#ff9900;font-weight:bold;}
.qtable td.orange2{color:#ffffff;background:#ff9900;border-bottom:none;font-weight:bold;}
.qtable td.small{font-size:7pt !important;}

</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>
					<td colspan="2">행사명</td>
					<td colspan="9"><?=$row['good_name']?></td>
				</tr>
				<tr>
					<td colspan="2">출발일</td>
					<td colspan="9"><?=$start_date?></td>
				</tr>
				<tr>
					<td colspan="2">가이드정보</td>
					<td colspan="9"><?=$row['customer_guide']?></td>
				</tr>
				<tr>
					<td colspan="2">기사정보</td>
					<td colspan="9"><?=$row['customer_driver']?></td>
				</tr>
				<tr>
					<td colspan="2">치량정보</td>
					<td colspan="9"><?=$row['customer_carinfo']?></td>
				</tr>
			</table>
		</td>
	</tr>

	<tr>
		<td>
			<table border="0">
				<tr>
					<td colspan="11" height="20">&nbsp;</td>
				</tr>
			</table>
		</td>
	</tr>

	<tr>
		<td>
			<!--상세일정-->
			<table cellspacing="0" cellpadding="5" border="0" class="qtable">
				<tr height="35">
					<th>NO</th>
					<th>고객이름</th>
					<th>전화번호</th>
					<th>국적</th>
					<th>성별</th>
					<th>나이</th>
					<th>미팅장소</th>
					<th>객실타입</th>
					<th>객실번호</th>
					<th>예약경로</th>
					<th>비고</th>
				</tr>
				<? foreach($row_customer as $k => $v){ ?>
				<tr height="35">
					<td width="150"><?=$k+1?></td>
					<td><?=$v['cus_nm']?></td>
					<td><?=$v['cus_phone']?></td>
					<td><?=$v['cus_nat']?></td>
					<td><?=$v['cus_gend']?></td>
					<td><?=$v['cus_age']?></td>
					<td><?=$v['cus_depot']?></td>
					<td><?=$v['cus_roomtype']?></td>
					<td><?=$v['cus_roomnum']?></td>
					<td><?=$v['cus_route']?></td>
					<td><?=$v['memo']?></td>
				</tr>
				<? } ?>
			</table>
		</td>
	</tr>

	</table>

<!-- //예약정보 -->

</body>
</html>

Anon7 - 2021