|
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/account_inout/ |
Upload File : |
<?
include "../include/top_iframe.html";
if (!$no) {
error_msg("필수값이 없습니다.");
}
$data_ioac = base_codec("PRD","IOAC","","N");// 계정
// 날짜
$today = date("Y-m-d");
$yesterday = date('Y-m-d', strtotime("-1 day",strtotime($today) ) ); // 어제
$bebore7day = date('Y-m-d', strtotime("-7 day",strtotime($today) ) ); // 7일
$bebore15day = date('Y-m-d', strtotime("-15 day",strtotime($today) ) ); // 15일
$bebore1month = date('Y-m-d', strtotime("-1 month",strtotime($today) ) ); // 1개월
$bebore3month = date('Y-m-d', strtotime("-3 month",strtotime($today) ) ); // 3개월
$bebore1year = date('Y-m-d', strtotime("-1 year",strtotime($today) ) ); // 1년
// 상품예약정보의 시작년도,마지막년도
$GoodReserv_class = new GoodReserv();// 여행상품예약 클래스
$data_yy = $GoodReserv_class->goodResDateMinMax();
$class_AccountCustomer = new AccountCustomer(); // 정산 클래스
$sql = "SELECT * FROM TB_ACCOUNT_INOUT_BREAKDOWN WHERE no = {$no} and flag_approval = 1 and inout_amount - process_amount > 0";
deanLog("sql", $sql, "k1");
$row = db_fetch($sql);
//미처리금액
$unattended_amount = (int)$row['inout_amount'] - (int)$row['process_amount'];
// 검색 설정
$sql_where = "";
if (!$flag_reservation_s) {
$flag_reservation_s = 'T';
}
if (!$search_key_s_2) {
$search_key_s_2 = 'res_cust_nm';
}
if (!$mode_conn_period_s) {
$mode_conn_period_s = 'start_dt';
}
// 처음 연결버튼 눌렀을 경우 처리
if ($mode != 'search') {
$search_word_s_2 = $row['inout_provider'];
$srh_pay_stat_s = "A";
$date_s1 = $bebore1month;
$date_s2 = $today;
}
// 검색어
if ($search_key_s_2 AND $search_word_s_2) {
$sql_where .= " AND {$search_key_s_2} LIKE '%{$search_word_s_2}%' ";
}
if ($mode_conn_period_s) {
$sql_where .= " and ( DATE_FORMAT({$mode_conn_period_s},'%Y-%m-%d') >= '{$date_s1}' and DATE_FORMAT({$mode_conn_period_s},'%Y-%m-%d') <= '{$date_s2}' )";
}
if ($payment_ck) {
$sql_where .= " AND sales_total = '{$row['inout_amount']}'";
}
$data = array();
$sql = "select * from TB_RES_ALL where 1 {$sql_where} order by {$mode_conn_period_s}";
deanLog("sql", $sql, "k1");
$rs = db_query($sql);
while ($row_res = db_fetch_array($rs)) {
$arr = $class_AccountCustomer->res_account_info($row_res['res_no']);
// 예약진행전달
$code_data = base_codec("PRD","RESP",$row_res['order_state']);
$row_res['order_state_str'] = $code_data[0]['cd_nm'];
$row_res['order_state_color'] = $code_data[0]['cd_memo'];
// 입금상태 (미납/완납/과납)
$arr = $class_AccountCustomer->res_account_info($row_res['res_no']);
$arr_account = $arr['tot'];
$row_res['res_mrecv_str'] = "대기";
if ($arr_account['pre_money'] > 0 and $row_res['res_stat_cd']=="C") {
$row_res['res_mrecv_str'] = "<span class='unpaid'>미납</span>";
}
if ($arr_account['pre_money'] < 0) {
$row_res['res_mrecv_str'] = "<span class='icon_overpaid'>과납</span>";
}
if ($row_res['res_stat_cd']=="C" and $arr_account['pre_money'] == 0) {
$row_res['res_mrecv_str'] = "<b>완납</b>";
}
$row_res['account'] = $arr_account;
if ($srh_pay_stat_s) {
switch ($row_res['tab']) {
case 'L':
$table = "TB_RES_HOTEL";
break;
default:
$table = "TB_RES_GOOD";
break;
}
$sql = "SELECT count(*) as total FROM {$table} WHERE srh_pay_stat = '{$srh_pay_stat_s}' AND res_no = '{$row_res[res_no]}' "; // 입금
$row_money = db_fetch($sql);
$row_money_total = $row_money['total'];
if ($row_money_total) {
$total_premoney += (int)$row_res['account']['pre_money'];
}
}
else {
$total_premoney += (int)$row_res['account']['pre_money'];
}
$data[] = $row_res;
}
?>
<form name="frm_search_conn" id="frm_search_conn" method="get">
<input type="hidden" name="no" value="<?=$row['no']?>" />
<input type="hidden" name="period_date_s" id="period_date_s" value="<?=(($period_date_s) ? $period_date_s : 'today')?>">
<input type="hidden" name="mode" value="search" />
<input type="hidden" name="unattended_amount" value="<?=$unattended_amount?>" />
<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 width="300px" />
<col width="150px" />
<col width="300px" />
<col width="150px" />
<col />
</colgroup>
<tbody>
<tr>
<th>입금일자</th>
<td><?=$row['basic_date']?></td><!-- 입금일자 -->
<th class="bl">입금자명</th>
<td><?=$row['inout_provider']?></td>
<th class="bl">메모</th>
<td><?=$row['memo']?></td>
</tr>
<tr>
<th>입금받은 계좌</th>
<td><?=($row['bank_name'] . " - " . $row['account_number'] . " - " . $row['account_name'])?></td>
<th class="bl">입금액</th>
<td><?=number_format($row['inout_amount'])?></td>
<th class="bl">미처리금액</th>
<td><?=number_format($unattended_amount)?></td>
</tr>
<tr>
<th rowspan="2">기간</th>
<td colspan="5">
<ul class="form_list">
<li class="pt5">
<input type="radio" name="mode_conn_period_s" id="period_s_2" value="start_dt" <?if(!$mode_conn_period_s OR $mode_conn_period_s=="start_dt"){?>checked<?}?> />
<label for="period_s_2" title="출발일">출발일</label>
</li>
<li>
<input type="text" name="date_s1" id="date_s1" class="cal_input" value="<?=(!$period_date_s) ? date("Y-m-d", strtotime("-1 months", strtotime($row['basic_date']))):$date_s1?>" onclick="AjaxCal(this,event);" readonly>
~
<input type="text" name="date_s2" id="date_s2" class="cal_input" value="<?=(!$period_date_s) ? date("Y-m-d", strtotime($row['basic_date'])):$date_s2?>" onclick="AjaxCal(this,event);" readonly>
</li>
<li>
<ul class="form_in_btn item_period_date">
<li class="<?=($period_date_s=="yesterday") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$yesterday?>');$('#date_s2').val('<?=$yesterday?>');$('#period_date_s').val('yesterday');">어제</a></li>
<li class="<?=($period_date_s=="today") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$today?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('today');">오늘</a></li>
<li class="<?=($period_date_s=="bebore7day") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$bebore7day?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('bebore7day');">7일</a></li>
<li class="<?=($period_date_s=="bebore15day") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$bebore15day?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('bebore15day');">15일</a></li>
<li class="<?=($period_date_s=="bebore1month" || !$period_date_s) ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$bebore1month?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('bebore1month');">1개월</a></li>
<li class="<?=($period_date_s=="bebore3month") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$bebore3month?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('bebore3month');">3개월</a></li>
<li class="<?=($period_date_s=="bebore1year") ? "on":""?>"><a href="javascript:;" onclick="$('#date_s1').val('<?=$bebore1year?>');$('#date_s2').val('<?=$today?>');$('#period_date_s').val('bebore1year');">1년</a></li>
</ul>
</li>
</ul>
</td>
</tr>
<tr>
<td colspan="5">
<ul class="form_list">
<li class="mr5">
<select name="period_yy_s" id="item_period_yy">
<?php if(is_array($data_yy)){for ($yy=$data_yy['maxyy'] ; $yy>=$data_yy['minyy'] ; $yy--){?>
<option value="<?=$yy?>" <?=($yy==$period_yy_s) ? "selected":""?>><?=$yy?>년</option>
<?php }}?>
</select>
</li>
<li>
<ul class="form_in_btn item_period_mm">
<?php for($s=1 ; $s<=12 ; $s++){?>
<li class="<?if($s==$period_mm_s)echo "on";if(!$period_mm_s and sprintf("%02d",$s)==date("m"))echo "on";?>"><a href="javascript:;"><?=$s?>월</a></li>
<?php }?>
</ul>
</li>
</ul>
</td>
</tr>
<tr>
<th>입금</th>
<td colspan="5">
<ul class="form_list">
<li>
<input type="radio" name="srh_pay_stat_s" id="srh_pay_stat_s_1" value="" class="vertical" <?=(!$srh_pay_stat_s) ? "checked":""?>/>
<label for="srh_pay_stat_s_1" title="전체">전체</label>
</li>
<li>
<input type="radio" name="srh_pay_stat_s" id="srh_pay_stat_s_2" value="A" class="vertical" <?=($srh_pay_stat_s=="A") ? "checked":""?>/>
<label for="srh_pay_stat_s_2" title="미입금">미납</label>
</li>
<li>
<input type="radio" name="srh_pay_stat_s" id="srh_pay_stat_s_3" value="B" class="vertical" <?=($srh_pay_stat_s=="B") ? "checked":""?>/>
<label for="srh_pay_stat_s_3" title="부분입금">부분입금</label>
</li>
<li>
<input type="radio" name="srh_pay_stat_s" id="srh_pay_stat_s_4" value="C" class="vertical" <?=($srh_pay_stat_s=="C") ? "checked":""?>/>
<label for="srh_pay_stat_s_4" title="입금완료">완납</label>
</li>
</ul>
</td>
</tr>
<tr class="bot_line">
<th>검색어</th>
<td colspan="5">
<ul class="form_list">
<li class="mr5">
<select name="search_key_s_2">
<option value="res_cust_nm" <?=($search_key_s_2=="res_cust_nm") ? "selected":""?>>예약자명</option>
<option value="res_cust_id" <?=($search_key_s_2=="res_cust_id") ? "selected":""?>>예약자 아이디</option>
<option value="res_cust_tel" <?=($search_key_s_2=="res_cust_tel") ? "selected":""?>>예약자 전화번호</option>
<option value="res_cust_tel" <?=($search_key_s_2=="res_cust_tel") ? "selected":""?>>예약자 휴대폰</option>
<option value="res_cust_email" <?=($search_key_s_2=="res_cust_email") ? "selected":""?>>예약자 이메일</option>
<option value="res_no" <?=($search_key_s_2=="res_no") ? "selected":""?>>예약코드</option>
<option value="agent_nm" <?=($search_key_s_2=="agent_nm") ? "selected":""?>>대리점명</option>
<option value="admin_nm" <?=($search_key_s_2=="admin_nm") ? "selected":""?>>담당자명</option>
<option value="sales_total" <?=($search_key_s_2=="sales_total") ? "selected":""?>>판매액</option>
<option value="good_nm" <?=($search_key_s_2=="good_nm") ? "selected":""?>>상품명</option>
<option value="good_nm_s" <?=($search_key_s_2=="good_nm_s") ? "selected":""?>>행사명</option>
</select>
</li>
<li class="mr5">
<input type="text" name="search_word_s_2" value="<?=$search_word_s_2?>" />
</li>
<li class="pt5">
<input type="checkbox" name="payment_ck" id="payment_ck" value="Y" <?if($payment_ck == 'Y'){?>checked<?}?> />
<label for="payment_ck">판매금액과 입금액 일치</label>
</li>
</ul>
</td>
</tr>
</tbody>
</table>
<div class="sch_btn_wrap"><a href="javascript:;" class="sch_btn" onclick="document.frm_search_conn.submit();">검색</a></div>
</div>
</form>
<!-- /폼 -->
<!--
<p class="c_top_sch_l mt20 mb20">
○ 입금처리 금액 <span id="total_paymoney">0</span>원 ○ 미입금 합계 <span id="total_premoney"><?=number_format($total_premoney)?></span>원</span>
</p>
-->
<form name="frm_list" id="frm_list" method="post">
<input type="hidden" name="SqlType" value="ma_link_reservation" />
<input type="hidden" name="no" value="<?=$row['no']?>" />
<input type="hidden" name="flag_division" value="<?=$row['flag_division']?>" />
<input type="hidden" name="admin_id" value="<?=$TO_MB['mb_id']?>" />
<input type="hidden" name="admin_nm" value="<?=$TO_MB['mb_nm']?>" />
<input type="hidden" name="total_premoney" value="<?=$total_premoney?>" />
<input type="hidden" name="flag_reservation_s" value="<?=$flag_reservation_s?>" />
<input type="hidden" name="saving_provider" value="<?=$saving_provider?>" />
<input type="hidden" name="tmp_layer_id" value="<?=$tmp_layer_id?>" />
<input type="hidden" name="search_key_s" value="<?=$search_key_s?>" />
<input type="hidden" name="search_word_s" value="<?=$search_word_s?>" />
<input type="hidden" name="mode_period_s" value="<?=$mode_period_s?>" />
<input type="hidden" name="account_number_s" value="<?=$account_number_s?>" />
<input type="hidden" name="account_number" value="<?=$row['account_number']?>" />
<input type="hidden" name="flag_process_s" value="<?=$flag_process_s?>" />
<input type="hidden" name="date_s1" value="<?=$date_s1?>" />
<input type="hidden" name="date_s2" value="<?=$date_s2?>" />
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list">
<colgroup>
<col width="50">
<col width="70">
<col width="150">
<col width="100">
<col width="40">
<col />
<col width="90">
<col width="90">
<col width="90">
<col width="90">
<col width="100">
<col width="100">
<col width="200">
</colgroup>
<thead>
<tr>
<th><input type="checkbox" id="ck_all"></th>
<th>예약상태</th>
<th>예약코드</th>
<th>예약자명</th>
<th>인원</th>
<th>상품명/행사명</th>
<th>출발일</th>
<th>판매금액</th>
<th>입금액</th>
<th>미입금액</th>
<th>계정</th>
<th>입금처리금액</th>
<th>비고</th>
</tr>
</thead>
<tbody>
<?
if (empty($data)) {
?>
<tr class="total_gray">
<td colspan="15" class="txt_c">:: 내용이 없습니다 ::</td>
</tr>
<?
}
else {
foreach ($data as $k) {
$view_ck = true;
if ($srh_pay_stat_s) {
$view_ck = false;
switch ($k['tab']) {
case 'L':
$table = "TB_RES_HOTEL";
break;
default:
$table = "TB_RES_GOOD";
break;
}
$sql = "SELECT count(*) as total FROM {$table} WHERE srh_pay_stat = '{$srh_pay_stat_s}' AND res_no = '{$k[res_no]}' "; // 입금
$row_money = db_fetch($sql);
$row_money_total = $row_money['total'];
if ($row_money_total) {
$view_ck = true;
}
}
//입금처리 비활성화 처리 미입금액이 0원이고, 연결어 있는 입금건이 있다면 readonly
$readonly = '';
if ((int)$k['account']['pre_money'] == 0) {
$sql = "SELECT count(*) AS total FROM TB_ACCOUNT_INOUT_LINK WHERE res_no = '{$k[res_no]}'";
$row_matching = db_fetch($sql);
$row_matching_total = $row_matching['total'];
if ($row_matching_total) {
$readonly = 'readonly';
}
}
if ($view_ck) {
$inwon_arr = explode(',', $k['res_cust_person']); //인원
$inwon_arr = array_shift($inwon_arr);
?>
<tr class="total_gray">
<td><input type="checkbox" name="res_no_arr[]" class="item_checkbox_res" value="<?=$k['res_no']?>"></td>
<td>
<span style="color:<?=$k['order_state_color']?>;"><?=$k['order_state_str']?></span><br />
<span color="<?=$k['res_stat_color']?>"><?=$k['res_mrecv_str']?></span>
</td>
<td><?=$k['res_no']?></td>
<td><?=$k['res_cust_nm']?></td>
<td><?=count($inwon_arr)?></td><!-- 인원 -->
<td class="txt_l">
<strong><?=$k['good_nm']?></strong>
<br />
<?=$k['good_nm_s']?>
</td>
<td><?=$k['start_dt']?><br /><!--<?=$k['date']['d_plane1_img']?><?=$k['date']['d_plane1']?>--></td>
<td><?=number_format($k['sales_total'])?></td>
<td><?=number_format($k['account']['pay_money'])?></td>
<td class="premoney"><?=number_format($k['account']['pre_money'])?></td>
<td>
<?php if($k['rtp']<>'dsr'){?>
<select name="ioac_cd[]">
<option value=""></option>
<?php if(is_array($data_ioac)){foreach($data_ioac as $v){?>
<option value="<?=$v['code']?>" <?=($v['code']==$row['ioac_cd']) ? "selected":""?>><?=$v['cd_nm']?></option>
<?php }}?>
</select>
<?php }?>
</td>
<td><input type="text" name="saving_amount[]" value="0" class="input_text txt_r saving_amount" maxlength="10" onblur="this.value=comma(this.value)" onkeydown="ChkNum(this,event);" <?=$readonly?>></td>
<td><input type="text" name="remarks[]" size="30"></td>
</tr>
<?
}
}
}
?>
</tbody>
</table>
</form>
<div class="btn_wrap_C mt30 mb30">
<a class="Bbtn red" href="javascript:;" onclick="chk_form();">저장</a
</div>
<script type="text/javascript">
$(document).ready(function() {
// 미입금액
$('.saving_amount').on('blur',function(){
input_amount();
});
// 기간검색
$(".item_period_date li").on("click",function(){
$(this).addClass("on").siblings().removeClass("on");
});
$("#item_period_yy").on("change",function(){
var yy = $(this).val();
var mm = '';
$(".item_period_mm li").each(function(){
if($(this).hasClass("on")) {
mm=parseInt($(this).index())+1;
if(mm<10) mm='0'+mm;
}
});
var dd = (new Date( yy, mm, 0) ).getDate().toString();
$("#date_s1").val(yy+'-'+mm+'-01');
$("#date_s2").val(yy+'-'+mm+'-'+dd);
$("#period_yy_s").val(yy);
});
$(".item_period_mm li").on("click",function() {
var yy='';
var mm='';
$(this).addClass("on").siblings().removeClass("on");
yy = $("#item_period_yy").val();
$(".item_period_mm li").each(function(){
if($(this).hasClass("on")) {
mm=parseInt($(this).index())+1;
if(mm<10) mm='0'+mm;
}
});
var dd = (new Date( yy, mm, 0) ).getDate().toString();
$("#date_s1").val(yy+'-'+mm+'-01');
$("#date_s2").val(yy+'-'+mm+'-'+dd);
$("#period_mm_s").val(mm);
});
//체크박스
$("#ck_all").click(function() {
if ($(this).is(':checked')) {
$('.item_checkbox_res').each(function() {
//var pre_money = $(this).parent().parent().find(".premoney").text().replace(/,/g,'');
//$(this).parent().parent().find(".saving_amount").val(number_format(pre_money));
$(this).parent().parent().find(".saving_amount").trigger('blur');
});
$(".item_checkbox_res").prop('checked',true);
}
else {
$('.item_checkbox_res').each(function() {
//$(this).parent().parent().find(".saving_amount").val(0);
$(this).parent().parent().find(".saving_amount").trigger('blur');
});
$(".item_checkbox_res").prop('checked', false);
}
});
$(".item_checkbox_res").click(function() {
if ($(this).is(':checked')) {
//var pre_money = $(this).parent().parent().find(".premoney").text().replace(/,/g,'');
//$(this).parent().parent().find(".saving_amount").val(number_format(pre_money));
$(this).parent().parent().find(".saving_amount").trigger('blur');
$(this).parent().parent().find(".saving_amount").focus();
}
else {
$('#ck_all').prop('checked', false);
//$(this).parent().parent().find(".saving_amount").val(0);
$(this).parent().parent().find(".saving_amount").trigger('blur');
}
var cnt = $('.item_checkbox_res').length;
var ck_cnt = 0;
$('.item_checkbox_res').each(function() {
if ($(this).is(':checked')) {
ck_cnt++;
}
});
if (cnt == ck_cnt) {
$('#ck_all').prop('checked', true);
}
});
});
// 입금처리 / 미입금
function input_amount() {
var pre_money = 0;
var total_paymoney = 0;
var total_premoney = $("input[name='total_premoney']").val();
$('.saving_amount').each(function() {
pre_money += parseInt($(this).val().replace(/,/g,''));
});
total_premoney = parseInt(total_premoney) - parseInt(pre_money);
total_paymoney = parseInt(total_paymoney) + parseInt(pre_money);
//$('#total_premoney').text(number_format(total_premoney));
//$('#total_paymoney').text(number_format(total_paymoney));
}
// 저장
function chk_form() {
if ($(".item_checkbox_res:checked").length == 0) {
alert('적어도 한개 항목을 선택해 주세요.');
return;
}
if(!confirm('저장하시겠습니까?')) return;
var total_pay_amount = 0;
var flag_continue = true;
$("input[name='res_no_arr[]']:checked").each(function(index, item) {
var pay_ioac_cd = $(this).parent().parent().find("select[name='ioac_cd[]']").val();
$("#frm_list").append("<input type='hidden' name='pay_ioac_cd[]' value='" + pay_ioac_cd + "'>");
var pay_amount = $(this).parent().parent().find("input[name='saving_amount[]']").val();
$("#frm_list").append("<input type='hidden' name='pay_amount[]' value='" + pay_amount + "'>");
var pay_remarks = $(this).parent().parent().find("input[name='remarks[]']").val();
$("#frm_list").append("<input type='hidden' name='pay_remarks[]' value='" + pay_remarks + "'>");
pay_amount = parseInt(pay_amount.replace(/[^\d]+/g, ''));
if (pay_amount == 0) {
flag_continue = false;
return false;
}
total_pay_amount += parseInt(pay_amount);
});
if (flag_continue == false) {
alert("0 이상의 금액을 입력하셔야 됩니다.");
return;
}
if (total_pay_amount > parseInt($("input[name='unattended_amount']").val())) {
alert("금액이 초과되었습니다.");
return;
}
ajax_post("ajax_proc","account_inout_process.php","frm_list");
}
</script>
<? include "../include/footer_iframe.html"; ?>