|
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 : |
<?
include "../include/top.html";
include "_common.html";
if(!$period_yy){
$period_yy = date('Y');
}
// 접근제한
if($TK_MEMBER['mb_id'] != 'tktravel'){
echo "
<script language='javascript'>
alert('접근이 제한된 메뉴입니다.');
history.back();
</script>
";
exit;
}
//////////////////////////////////////////////////////////////////////////
// 월간 내역
$data_month = year_cal_master($period_yy);
// 연간통계
foreach($data_month as $k => $v){
$total_year_tour += $v['total_tour'];
$total_year_inwon += $v['total_inwon'];
$total_year_sales += $v['total_sell_price'];
$total_year_sales_profit += $v['total_sell_price']-$v['total_buy_price'];
$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']; // 회사수익
}
// 첨부파일
for($m = 1; $m <=12; $m++){
$period_mm = sprintf("%02d",$m);;
$sql = "select * from TB_CAL_UPFILE where cal_year = '{$period_yy}' and cal_month = '{$period_mm}'";
$file_rs = db_query($sql);
for($i=0 ; $row = db_fetch_array($file_rs) ; $i++) {
$data_file[$period_mm][] = $row;
}
}
?>
<style>
.c_top_bar_search {padding:10px 16px;}
.t_list .month_total {text-align:right; padding-right:20px;}
.t_list .year_total {background-color:#fffde1; font-weight:bold;}
.t_list .year_total td{height:28px;} /*20220110장진혁*/
@media print {
td {color:#000 !important;}
th {color:#000 !important;}
div.top_blue{display:none;}
div.left_wrap{display:none; width:0;}
div .contents_wrap {margin-left:0 !important;}
div .contents_wrap_in .title{display:none;}
div .contents_wrap_in #frm_search{display:none;}
div .log_wrap{display:none;}
#footer{display:none;}
div #contents {padding:0;}
.cal_print_title {display:block !important;}
.no_print{display:none;}
.t_list td {font-size:11px;}
.t_list tbody tr {height:35px;}
.t_list .year_total td {font-size:12px !important;}
.b_c_top_sch {color:#000;}
.b_c_top_sch span {color:#000 !important;}
.contents_detail {margin-bottom:0 !important;}
#contents {padding-bottom:0 !important;}
.contents_wrap {min-height:auto !important;}
.contents_wrap_in {padding-bottom:0 !important; min-height:auto !important;}
}
@page {
size:29.7cm 21cm ; /*A4*/
page-break-after: auto;
counter-increment: page;
}
</style>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><strong>연간정산</strong></div>
<div class="contents_detail">
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get">
<input type="hidden" name="period_yy" id="period_yy" value="<?=$period_mm?>">
<div class="c_top_bar_search">
<table width="100%" border="0" cellpadding="0" cellspacing="0" summary="여행상품 예약관리 통합검색입니다." class="c_top_table">
<caption>여행상품 예약관리 통합검색</caption>
<colgroup>
<col width="150px" />
<col />
</colgroup>
<tbody>
<tr class="bot_line">
<th>검색년도</th>
<td><ul class="form_list">
<li>
<ul class="form_in_btn item_period_yy">
<? for($s=2018 ; $s<=date('Y') ; $s++){?>
<li class="<?if($s==$period_yy)echo "on";?>" year="<?=$s?>"><a href="javascript:;" style="width:80px;"><?=$s?>년</a></li>
<? }?>
</ul>
</li>
</ul>
</td>
</tr>
</tbody>
</table>
</div>
</form>
<!-- /폼 -->
<div id="Content_box">
<div class="cal_print_title" style="width:1000px; margin:10px 0 30px; text-align:center; display:none;">
<span style="font-size:40px; color#000;"><?=$period_yy?>년 정산 내역</span>
</div>
<div class="b_c_top_sch_wrap">
<span class="b_c_top_sch">▶ 검색결과 :
기간 : <?=$period_yy?>년 1월 ~ <?=$period_yy?>년 12월 |
총행사수<span class="c_red"> <?=number_format($total_year_tour)?></span>개 |
총인원 :<span class="c_red"> <?=number_format($total_year_inwon)?></span>명 |
회사수익<span class="c_red"> <?=number_format($total_year_profit)?></span>원
</span>
</div>
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="post">
<div class="c_top_sch_wrap no_print">
<ul class="c_top_sch_r">
<li><a href="javascript:;" class="Tbtn" onclick="to_excel('<?=$period_yy?>');" ><img src="../image/btn/ico_excel.gif" alt="엑셀" /> 엑셀저장</a></li>
<li><a href="#" class="Tbtn gray1 no_print" onclick="window.print();">인쇄하기</a></li>
</ul><!-- 상품등록 -->
</div>
<table border="0" cellspacing="0" cellpadding="0" class="t_list tlist_height" width="100%">
<colgroup>
<col style=" width:7%" />
<col style=" width:7%" />
<col style=" width:7%" />
<col style=" width:10%" />
<col style=" width:9%" />
<col style=" width:7%" />
<col style=" width:7%"/>
<col style=" width:7%"/>
<col style=" width:7%" />
<col style=" width:7%" />
<col style=" width:7%" />
<col style=" width:9%" />
<col style=" width:7%" />
</colgroup>
<thead>
<tr>
<th rowspan="2">구분</th>
<th rowspan="2">행사 수</th>
<th rowspan="2">모객인원</th>
<th rowspan="2">총 매출액</th>
<th rowspan="2">총 매출이익</th>
<th colspan="3" style="padding:3px 3px 4px 3px">인건비</th>
<th rowspan="2">운영비</th>
<th rowspan="2">부가세</th>
<th rowspan="2">소득세</th>
<th rowspan="2" style=" color:blue; font-weight:bold;">회사수익</th>
<th rowspan="2" class="no_print">첨부파일</th>
</tr>
<tr>
<th style="padding:3px 3px 4px 3px">기본급+인센</th>
<th style="padding:3px 3px 4px 3px">4대보험</th>
<th style="padding:3px 3px 4px 3px">퇴직금</th>
</tr>
</thead>
<tbody>
<?
foreach($data_month as $k => $v){
?>
<tr height="50">
<td><a href="month_cal.html?period_yy=<?=$period_yy?>&period_mm=<?=$k?>"><?=$period_yy?>년 <?=$k?>월</a></td>
<td><?=number_format($v['total_tour'])?> 개</td>
<td><?=number_format($v['total_inwon'])?> 명</td>
<td><?=number_format($v['total_sell_price'])?> 원</td>
<td><?=number_format($v['total_sell_price']-$v['total_buy_price'])?> 원</td>
<td><?=number_format($v['total_basic']+$v['total_incentive'])?> 원</td>
<td><?=number_format($v['total_insu'])?> 원</td>
<td><?=number_format($v['operate_sp'])?> 원</td>
<td><?=number_format($v['operate_mp'])?> 원</td>
<td><?=number_format($v['operate_surtax'])?> 원</td>
<td><?=number_format($v['operate_income'])?> 원</td>
<td class="month_total"><b><?=number_format($v['total_profit'])?> 원</b></td>
<td class="no_print">
<? if($data_file[$k][0]) { ?>
1<a href="../lib/Download.php?Type=CAL&FileName=<?=$data_file[$k][0][upfile]?>&FileNameOrg=<?=$data_file[$k][0][upfile_org]?>" title="다운로드"><span class="style_3"><img src="../image/cal_file_icon.gif" width="25" align="top" /></span></a>
<? } ?>
<? if($data_file[$k][1]) { ?>
2<a href="../lib/Download.php?Type=CAL&FileName=<?=$data_file[$k][1][upfile]?>&FileNameOrg=<?=$data_file[$k][1][upfile_org]?>" title="다운로드"><span class="style_3"><img src="../image/cal_file_icon.gif" width="25" align="top" /></span></a>
<? } ?>
<? if($data_file[$k][2]) { ?>
3<a href="../lib/Download.php?Type=CAL&FileName=<?=$data_file[$k][2][upfile]?>&FileNameOrg=<?=$data_file[$k][2][upfile_org]?>" title="다운로드"><span class="style_3"><img src="../image/cal_file_icon.gif" width="25" align="top" /></span></a>
<? } ?>
</td>
</tr>
<? } ?>
<tr class="year_total">
<td>합 계</td>
<td style="font-size:13px;"><?=number_format($total_year_tour)?> 개</td>
<td style="font-size:13px;"><?=number_format($total_year_inwon)?> 명</td>
<td style="font-size:13px;"><?=number_format($total_year_sales)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_sales_profit)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_basic)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_insu)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_op_sp)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_op_mp)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_op_surtax)?> 원</td>
<td style="font-size:13px;"><?=number_format($total_year_op_income)?> 원</td>
<td style="font-size:13px; color:blue; text-align:right; padding-right:20px;"><?=number_format($total_year_profit)?> 원</td>
<td class="no_print"></td>
</tr>
</tbody>
</table>
</form>
</div>
</div>
</div>
</div>
<script type="text/javascript">
// 폼 저장
function chk_form()
{
var f = document.frm_reserv_good;
if(!confirm('저장하시겠습니까?')) return;
f.action = "month_cal_proc.html";
f.submit();
}
$(document).ready(function(){
// 년도 변경
$(".item_period_yy li").on("click",function(){
var yy = parseInt($(this).attr('year'));;
$("#period_yy").val(yy);
document.frm_search.submit();
});
});
//엑셀출력
function to_excel(period_yy)
{
document.location.href='year_cal_excel.html?period_yy='+period_yy;
}
</script>
<?
include "../include/footer.html";
?>