|
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/toadmin/cal_good/ |
Upload File : |
<?
include "../include/top.html"; //공통파일 인클루드
include "_common.html";
// 행사,여행예약 정산 클래스
$classGoodResEvCal = new GoodResEvCal();
//테이블명
$table = "TB_ACCOUNT_GOOD";
// 검색 설정
$sql_where = "";
if(!$date_s) $date_s="ins_dt";
if(!$key_date2_s) $key_date2_s = date("Y-m-")."01"; // 기간 검색
if(!$key_date3_s) $key_date3_s = date("Y-m-d"); // 기간 검색
$date_between = count(date_to_date($key_date2_s , $key_date3_s));
if($date_between > 100) { // 검색조건
echo("<script>alert('검색일자간에 3달 이상 차이가남니다.');</script>");
$key_date2_s = date("Y-m-")."01";
$key_date3_s = date("Y-m-d");
}
$sql_where .="
AND d_start BETWEEN '{$key_date2_s}' AND '{$key_date3_s}'
AND d_uid IN(SELECT ev_uid AS d_uid FROM TB_RES_GOOD WHERE res_stat_cd<>'D' AND ev_start BETWEEN '{$key_date2_s}' AND '{$key_date3_s}')
/*AND d_uid NOT IN(SELECT d_uid FROM TB_PAPER_GOOD_CAL WHERE approval_stat IN ('F','C') AND d_start BETWEEN '{$key_date2_s}' AND '{$key_date3_s}' )*/
";
//배열에 저장
$data = array();
$data = date_list("","none",$sql_where);
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><strong>행사별 수익현황</strong></div>
<div class="contents_detail">
<div id="Content_box">
<?include "_tab.html";?>
<div class="top_txt_s">
<div class="bar_wrap">
<p class="search_result_txt sch"><span><?=count($data)?></span><span class="pl10">건이 검색되었습니다.</span></p>
<ul class="search_rt_btn">
<li><a href="#" class="Tbtn red" onclick="page_print('print_div');">인쇄하기</a></li>
</ul>
</div>
</div>
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_register" >
<tbody>
<tr>
<th width="153">행사일</th>
<td>
<ul class="c_in_search">
<!-- <li>
<select name="date_s">
<option value="ev_start" <?=($date_s=="ev_start")?"selected":""?>>출발일</option>
<option value="ins_dt" <?=($date_s=="ins_dt")?"selected":""?>>예약일</option>
</select>
</li> -->
<li>
<a href="#" class="Table_btn" onClick="$('#key_date2_s').val('<?=date("Y-m")?>-01');$('#key_date3_s').val('<?=date("Y-m-d")?>');">이번달</a>
<a href="#" class="Table_btn" onClick="$('#key_date2_s').val('<?=date("Y-m",strtotime(" -1 month"))?>-01');$('#key_date3_s').val('<?=date("Y-m",strtotime(" -1 month"))?>-31');">지난달</a>
</li>
<li>
<input name="key_date2_s" id="key_date2_s" type="text" class="cal_input" size="12" onclick="AjaxCal(this,event);" value="<?=$key_date2_s?>" readonly/>
~ <input name="key_date3_s" id="key_date3_s" type="text" class="cal_input" size="12" onclick="AjaxCal(this,event);" value="<?=$key_date3_s?>" readonly/>
</li>
<li>
<input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" />
</li>
</ul>
</td>
</tr>
</tbody>
</table>
</form>
<!-- /폼 -->
<!-- print area -->
<div id="print_div">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list mt25" >
<thead>
<tr>
<th width="80px">출발일</th>
<th>행사명</th>
<th width="80px">담당자</th>
<th width="40px">인원</th>
<th width="70px">총판매가</th>
<th width="82px">지출(직접경비)</th>
<th width="70px">알선수익</th>
<th width="70px">알선수수료</th>
<th width="70px">기타수익</th>
<th width="70px">기타경비</th>
<th width="70px">총수익</th>
</tr>
</thead>
<tbody>
<?
$총판매가_계=0;
$알선수수료_계=0;
$총지출액_계=0;
$알선수익_계=0;
$기타수익_계=0;
$기타경비_계=0;
$총수익_계=0;
for($i=0 ; $i < count($data) ; $i++){
$row = date_list_replace($data[$i]);
// 정산정보
$data_cal = $classGoodResEvCal->to_paper_acc_report($row['d_uid']);
$총판매가_계+=$data_cal['총판매액'];
$알선수수료_계+=$data_cal['알선수수료'];
$총지출액_계+=$data_cal['총지출액'];
$알선수익_계+=$data_cal['알선수익'];
$기타수익_계+=$data_cal['기타수익'];
$기타경비_계+=$data_cal['기타경비'];
$총수익_계+=$data_cal['총수익'];
?>
<tr>
<td><?=$row['d_start_d']?></td>
<td class="t_title"><?=$row['d_title']?></td>
<td class="txt_c"><?=$row['admin_nm']?></td>
<td class="txt_c"><?=$row['d_people1']?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['총판매액'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['총지출액'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['알선수익'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['알선수수료'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['기타수익'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['기타경비'])?></td>
<td class="txt_r ls-1"><?=number_format($data_cal['총수익'])?></td>
</tr>
<?
}
?>
<tr class="bg_gray">
<td colspan="4">계</td>
<td class="txt_r ls-1"><?=number_format($총판매가_계)?></td>
<td class="txt_r ls-1"><?=number_format($총지출액_계)?></td>
<td class="txt_r ls-1"><?=number_format($알선수익_계)?></td>
<td class="txt_r ls-1"><?=number_format($알선수수료_계)?></td>
<td class="txt_r ls-1"><?=number_format($기타수익_계)?></td>
<td class="txt_r ls-1"><?=number_format($기타경비_계)?></td>
<td class="txt_r ls-1"><?=number_format($총수익_계)?></td>
</tr>
</tbody>
</table>
</div> <!-- /print area -->
</div>
</div>
</div>
</div>
<? include "../include/footer.html" ?>
<iframe name="ifrm_print" id="ifrm_print" src="../include/print_iframe.html?table_width=600" width="0" height="0" scrolling="yes"></iframe><!-- 인쇄 -->
<script type="text/javascript">
function page_print(id)
{
var inner_str = "";
var ifrm = document.getElementById('ifrm_print');
inner_str = $("#"+id).html();
ifrm.contentWindow.document.getElementById('print_div').innerHTML = inner_str;
ifrm_print.focus();
ifrm_print.start_print();
}
$(document).ready(function(){
$(".t_c_list2 tbody td").each(function(){
var _html = $(this).html();
$(this).html("<div style='width:100%;height:19px;overflow:hidden;'>"+_html+"</div>");
});
});
</script>