|
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 : |
<?
include "../include/top_proc.html";
// 엑셀 파일명 설정
$FileName = "버스정산목록";
$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" );
// 파라메터
$sql_where = stripslashes($sql_where);
$sql_order = stripslashes($sql_order);
$sql = "select * from TB_ERP_BUS where 1 {$sql_where} order by {$sql_order}";
$rs = db_query($sql);
?>
<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>
<!--[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 cellspacing="0" cellpadding="2" bordercolor="#999999" bordercolordark="#FFFFFF" border="1">
<tr height="35">
<th align="center" bgcolor="#E7E7E7">No.</th>
<th align="center" bgcolor="#E7E7E7">버스회사</th>
<th align="center" bgcolor="#E7E7E7">행사명</th>
<th align="center" bgcolor="#E7E7E7">운행날짜</th>
<th align="center" bgcolor="#E7E7E7">차량종류</th>
<th align="center" bgcolor="#E7E7E7">차량번호</th>
<th align="center" bgcolor="#E7E7E7">기사명</th>
<th align="center" bgcolor="#E7E7E7">기사연락처</th>
<th align="center" bgcolor="#E7E7E7">버스비용</th>
<th align="center" bgcolor="#E7E7E7">기사일비</th>
<th align="center" bgcolor="#E7E7E7">기사식대</th>
<th align="center" bgcolor="#E7E7E7">통행료</th>
<th align="center" bgcolor="#E7E7E7">주차비</th>
<th align="center" bgcolor="#E7E7E7">부가세</th>
<th align="center" bgcolor="#E7E7E7">정산소계</th>
<th align="center" bgcolor="#E7E7E7">메모</th>
</tr>
<?
$j = 1;
for($i=0 ; $i < $row = db_fetch_array($rs) ; $i++){
$bus_corp = db_fetch("SELECT * FROM TB_ERP_BUS_CORP where bc_idx='{$row[bc_idx]}' ");
$start_date = substr($row['start_date'], 0, 10);
$end_date = substr($row['end_date'], 0, 10);
if($start_date == $end_date) {
$bus_date = $start_date;
} else {
$bus_date = $start_date . " ~<br>" . $end_date;
}
?>
<tr>
<td align="center"><?=$j?></td>
<td align="center"><?=$bus_corp['corp_nm']?></td>
<td align="center"><?=$row['schedule_name']?></td>
<td align="center"><?=$bus_date?></td>
<td align="center"><?=$row['bus_model']?></td>
<td align="center"><?=$row['bus_number']?></td>
<td align="center"><?=$row['driver_name']?></td>
<td align="center"><?=$row['driver_phone']?></td>
<td align="center"><?=number_format($row['bus_price'])?></td>
<td align="center"><?=number_format($row['driver_price'])?></td>
<td align="center"><?=number_format($row['meals_price'])?></td>
<td align="center"><?=number_format($row['toll_price'])?></td>
<td align="center"><?=number_format($row['parking_price'])?></td>
<td align="center"><?=number_format($row['surtax_price'])?></td>
<td align="center"><?=number_format($row['total_buy_price'])?></td>
<td align="center"><?=strip_tags($row['e_memo'])?></td>
</tr>
<?
$j++;
}
?>
</table>
</body>
</html>