|
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/air/ |
Upload File : |
<?
include "../include/top_proc.html";
include "_common.php";
// 출발일 파라메터 받기
if ( $date_year_s and $date_month_s ) {
$d_start_s = $date_year_s."-".$date_month_s;
}else{
$date_year_s = date("Y");
$date_month_s = date("m");
$d_start_s = $date_year_s."-".$date_month_s;
}
// 출발일 정보 목록
$sql_where = " and ti_uid='{$ti_uid}' and left(start_dt,7)='{$d_start_s}' ";
if ($res_state_s) $sql_where .= " and res_state='{$res_state_s}' ";
$air_data = to_air_date($sql_where);
$total = count($air_data);
//출발일자중 첫번째 날짜와 마지막 날짜
$airticket_date = toad_airticket_first_last($ti_uid);
//검색된 년월 이전, 이후 년월
$date_pre_next = date_pre_next($date_year_s."-".$date_month_s."-01");
// 가격입력시에 콤마+숫자필수 style+스크립트
$require_num_comma = " maxlength=\"10\" style=\"width:60px;ime-mode:inactive;ime-mode:disabled;text-align:right\" onblur=\"this.value=comma(this.value)\" onKeyDown=\"ChkNum(this,event);\" ";
?>
<!-- 폼 -->
<form name="frm_airdate_list" id="frm_airdate_list" method="post">
<input type="hidden" name="SqlType" value="">
<input type="hidden" name="ti_uid" value="<?=$ti_uid?>">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_register3" >
<thead>
<td colspan="12">
<div class="search_result_txt">
<span><?=$total?></span>개가 검색되었습니다.<span class="result_date">[<?=$date_year_s?>년 <?=$date_month_s?>월]</span>
</div>
<ul class="search_date pr10">
<li class="arrow_lo"><img src="../image/common/arrow_l.gif" alt="이전" style="cursor:pointer;" onClick="ajax_loader('airticket_date_list.html?ti_uid=<?=$ti_uid?>&date_year_s=<?=$date_pre_next[0]['pre_date1']?>&date_month_s=<?=$date_pre_next[0]['pre_date2']?>','ajax_start_date');" /></li>
<li>
<select name="date_year_s" id="date_year_s" class="w01" onchange="search_date_list();">
<?
for($i=$airticket_date['first_dt1'] ; $i < $airticket_date['last_dt1']+3 ; $i++){
?>
<option value="<?=$i?>" <?=($i==$date_year_s)?"selected":""?>><?=$i?></option>
<?}?>
</select>
</li>
<li>
<select name="date_month_s" id="date_month_s" class="w02" onchange="search_date_list();">
<?
for($i=1 ; $i<=12 ; $i++){
$j = sprintf("%02d",$i);
?>
<option value="<?=$j?>" <?=($j==$date_month_s)?"selected":""?>><?=$j?></option>
<?}?>
</select>
</li>
<li class="arrow_lo"><img src="../image/common/arrow_r.gif" alt="이후" style="cursor:pointer;" onClick="ajax_loader('airticket_date_list.html?ti_uid=<?=$ti_uid?>&date_year_s=<?=$date_pre_next[1]['next_date1']?>&date_month_s=<?=$date_pre_next[1]['next_date2']?>','ajax_start_date');"/></li>
<li class="pl10">
<select name="res_state_s" id="res_state_s" style="width:75px" onchange="search_date_list();">
<option value="">==전체==</option>
<option value="A" <?=($res_state_s=="A")?"selected":""?> style="color:<?=$cf['d_ok_color_A']?>;">예약가능</option>
<option value="B" <?=($res_state_s=="B")?"selected":""?> style="color:<?=$cf['d_ok_color_B']?>;">대기</option>
<option value="C" <?=($res_state_s=="C")?"selected":""?> style="color:<?=$cf['d_ok_color_C']?>;">마감</option>
</select>
</li>
<li class="arrow_lo">
<img src="../image/btn/btn_reset.gif" align="top" title="처음으로" class="input_img" style="cursor:pointer;" onClick="ajax_loader('airticket_date_list.html?ti_uid=<?=$ti_uid?>','ajax_start_date');" /></li>
</ul>
</td>
</tr>
<tr>
<th width="50"><input type="checkbox" name="chkbox_all" id="chkbox_all" value=""></th>
<th width="50">NO.</th>
<th width="110">상태</th>
<th>출발일/시간/비행편/경유지</th>
<th>도착일/시간</th>
<th width="80">정원</th>
<th>원가</th>
<th>공항+유류</th>
<th>개인판매</th>
<th>대리점판매</th>
<th width="60">-</th>
</tr>
</thead>
<tbody>
<?
for($i=0,$j=count($air_data) ; $i<count($air_data) ; $i++,$j--){
$row = $air_data[$i];
$ar_uid = $row['ar_uid'];
?>
<tr>
<td rowspan="3"><input type="checkbox" name="chk_seq[]" value="<?=$row['ar_uid']?>"></td>
<td rowspan="3"><?=$j?></td>
<td rowspan="3">
<select name="res_state_<?=$ar_uid?>" style="width:75px" >
<option value="A" <?=($row['res_state']=="A")?"selected":""?> style="color:<?=$cf['d_ok_color_A']?>;">예약가능</option>
<option value="B" <?=($row['res_state']=="B")?"selected":""?> style="color:<?=$cf['d_ok_color_B']?>;">대기</option>
<option value="C" <?=($row['res_state']=="C")?"selected":""?> style="color:<?=$cf['d_ok_color_C']?>;">마감</option>
</select>
</td>
<td rowspan="3">
<input name="start_dt_<?=$ar_uid?>" type="text" style="width:90px;" value="<?=$row['start_dt']?>" class="cal_input" onclick="AjaxCal(this,event);" readonly />
<input name="start_tm_1_<?=$ar_uid?>" type="text" size="2" value="<?=$row['start_tm_1']?>" class="input_text" maxlength="2" onKeyDown="ChkNum(this,event);"/>:
<input name="start_tm_2_<?=$ar_uid?>" type="text" size="2" value="<?=$row['start_tm_2']?>" class="input_text" maxlength="2" onKeyDown="ChkNum(this,event);" />
<input name="plane_nm_<?=$ar_uid?>" type="text" style="width:10%;" value="<?=$row['plane_nm']?>" class="input_text" />
<input name="visit_nm_<?=$ar_uid?>" type="text" style="width:30%;" value="<?=$row['visit_nm']?>" class="input_text" />
</td><!-- 출발일/시간/비행편/경유지 -->
<td rowspan="3">
<input name="end_dt_<?=$ar_uid?>" type="text" style="width:90px;" value="<?=$row['end_dt']?>" class="cal_input" onclick="AjaxCal(this,event);" readonly />
<input name="end_tm_1_<?=$ar_uid?>" type="text" size="2" value="<?=$row['end_tm_1']?>" class="input_text" maxlength="2" onKeyDown="ChkNum(this,event);" />:
<input name="end_tm_2_<?=$ar_uid?>" type="text" size="2" value="<?=$row['end_tm_2']?>" class="input_text" maxlength="2" onKeyDown="ChkNum(this,event);" />
</td><!-- 도착일/시간 -->
<td rowspan="3">
<input name="left_seat_<?=$ar_uid?>" type="text" size="2" value="<?=$row['left_seat']?>" class="input_text" maxlength="4" style="text-align:right" onKeyDown="ChkNum(this,event);" /> /<input name="total_seat_<?=$ar_uid?>" type="text" size="2" value="<?=$row['total_seat']?>" class="input_text" maxlength="4" style="text-align:right" onKeyDown="ChkNum(this,event);" />
</td><!-- 정원 -->
<td>
<input name="net_ad_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ad'])?>" class="input_text" <?=$require_num_comma?> />
</td><!-- 원가 -->
<td>
<input name="net_ad_addon_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ad_addon'])?>" class="input_text" <?=$require_num_comma?> />
</td><!-- 공항이용료+유류세 -->
<td>
<input name="person_ad_<?=$ar_uid?>" type="text" value="<?=number_format($row['person_ad'])?>" class="input_text" <?=$require_num_comma?> />
</td><!-- 개인판매마진 -->
<td>
<input name="agent_ad_<?=$ar_uid?>" type="text" value="<?=number_format($row['agent_ad'])?>" class="input_text" <?=$require_num_comma?>/>
</td><!-- 대리점판매마진 -->
<td rowspan="3">
<img src="../image/btn/icon_write.gif" align="top" alt="수정" style="cursor:pointer;" onClick="edit_date('<?=$ar_uid?>');" />
<img src="../image/btn/icon_del.gif" align="top" alt="삭제" style="cursor:pointer;" onClick="if(!confirm('정말삭제하겠습니까?'))return;ajax_loader('airticket_proc.html?SqlType=airdate_delete_check&<?=$shref?>&ar_uid=<?=$ar_uid?>');" />
</td><!-- 수정/삭제 -->
</tr>
<tr>
<td><input name="net_ch_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ch'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="net_ch_addon_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ch_addon'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="person_ch_<?=$ar_uid?>" type="text" value="<?=number_format($row['person_ch'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="agent_ch_<?=$ar_uid?>" type="text" value="<?=number_format($row['agent_ch'])?>" class="input_text" <?=$require_num_comma?> /></td>
</tr>
<tr>
<td><input name="net_ba_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ba'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="net_ba_addon_<?=$ar_uid?>" type="text" value="<?=number_format($row['net_ba_addon'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="person_ba_<?=$ar_uid?>" type="text" value="<?=number_format($row['person_ba'])?>" class="input_text" <?=$require_num_comma?> /></td>
<td><input name="agent_ba_<?=$ar_uid?>" type="text" value="<?=number_format($row['agent_ba'])?>" class="input_text" <?=$require_num_comma?> /></td>
</tr>
<?}?>
</tbody>
</table>
</form>
<!-- /폼 -->
<!-- 선택저장및 수정 -->
<ul class="btn_check">
<li class="btn01"><a href="javascript:;" onClick="edit_date_check('airdate_edit_check');">선택수정</a></li>
<li class="btn02"><a href="javascript:;" onClick="edit_date_check('airdate_delete_check');">선택삭제</a></li>
<!-- /선택저장및 수정 -->
</ul>
<!-- 출발일수정 폼 -->
<form name="airtdate_edit" id="airtdate_edit">
<input type="hidden" name="SqlType" value="airdate_edit">
<INPUT TYPE="hidden" NAME="ar_uid" value="" >
<INPUT TYPE="hidden" NAME="plane_nm" value="" >
<INPUT TYPE="hidden" NAME="visit_nm" value="" >
<INPUT TYPE="hidden" NAME="start_dt" value="" hname="출발일" required>
<INPUT TYPE="hidden" NAME="start_tm_1" value="" hname="출발시간" required>
<INPUT TYPE="hidden" NAME="start_tm_2" value="" hname="출발시간" required>
<INPUT TYPE="hidden" NAME="end_dt" value="" hname="도착일" required>
<INPUT TYPE="hidden" NAME="end_tm_1" value="" hname="도착시간" required>
<INPUT TYPE="hidden" NAME="end_tm_2" value="" hname="도착시간" required>
<INPUT TYPE="hidden" NAME="left_seat" value="" hname="예약인원" required>
<INPUT TYPE="hidden" NAME="total_seat" value="" hname="정원" required>
<INPUT TYPE="hidden" NAME="net_ad" value="" hname="성인원가" required>
<INPUT TYPE="hidden" NAME="net_ch" value="" >
<INPUT TYPE="hidden" NAME="net_ba" value="" >
<INPUT TYPE="hidden" NAME="net_ad_addon" value="" >
<INPUT TYPE="hidden" NAME="net_ch_addon" value="" >
<INPUT TYPE="hidden" NAME="net_ba_addon" value="" >
<INPUT TYPE="hidden" NAME="person_ad" value="" >
<INPUT TYPE="hidden" NAME="person_ch" value="" >
<INPUT TYPE="hidden" NAME="person_ba" value="" >
<INPUT TYPE="hidden" NAME="agent_ad" value="" >
<INPUT TYPE="hidden" NAME="agent_ch" value="" >
<INPUT TYPE="hidden" NAME="agent_ba" value="" >
<INPUT TYPE="hidden" NAME="res_state" value="">
</form>
<!-- /출발일수정 폼 -->
<script type="text/javascript">
// 월,일,상태별 조회
function search_date_list()
{
var res_state_s = $("#res_state_s").val();
var date_year_s = $("#date_year_s").val();
var date_month_s = $("#date_month_s").val();
ajax_loader('airticket_date_list.html?ti_uid=<?=$ti_uid?>&res_state_s='+res_state_s+'&date_year_s='+date_year_s+'&date_month_s='+date_month_s,'ajax_start_date');
}
function edit_date_check(sqltype)
{
var ck = false;
$("input[name='chk_seq[]']").each(function(){
if( $(this).is(":checked")==true ) ck = true;
});
if(ck==false) {
alert('적어도 한개 항목을 선택하세요.');
return;
}
if (!confirm('실행하시겠습니까?')) return false;
$("form#frm_airdate_list input[name='SqlType']").val(sqltype);
ajax_post("ajax_proc","airticket_proc.html?<?=$shref?>","frm_airdate_list");
}
function edit_date(ar_uid)
{
var f = document.airtdate_edit;
f.ar_uid.value = ar_uid;
f.plane_nm.value = $("input[name='plane_nm_"+ar_uid+"']").val();
f.visit_nm.value = $("input[name='visit_nm_"+ar_uid+"']").val();
f.start_dt.value = $("input[name='start_dt_"+ar_uid+"']").val();
f.start_tm_1.value = $("input[name='start_tm_1_"+ar_uid+"']").val();
f.start_tm_2.value = $("input[name='start_tm_2_"+ar_uid+"']").val();
f.end_dt.value = $("input[name='end_dt_"+ar_uid+"']").val();
f.end_tm_1.value = $("input[name='end_tm_1_"+ar_uid+"']").val();
f.end_tm_2.value = $("input[name='end_tm_2_"+ar_uid+"']").val();
f.left_seat.value = $("input[name='left_seat_"+ar_uid+"']").val();
f.total_seat.value = $("input[name='total_seat_"+ar_uid+"']").val();
f.net_ad.value = $("input[name='net_ad_"+ar_uid+"']").val();
f.net_ch.value = $("input[name='net_ch_"+ar_uid+"']").val();
f.net_ba.value = $("input[name='net_ba_"+ar_uid+"']").val();
f.net_ad_addon.value = $("input[name='net_ad_addon_"+ar_uid+"']").val();
f.net_ch_addon.value = $("input[name='net_ch_addon_"+ar_uid+"']").val();
f.net_ba_addon.value = $("input[name='net_ba_addon_"+ar_uid+"']").val();
f.person_ad.value = $("input[name='person_ad_"+ar_uid+"']").val();
f.person_ch.value = $("input[name='person_ch_"+ar_uid+"']").val();
f.person_ba.value = $("input[name='person_ba_"+ar_uid+"']").val();
f.agent_ad.value = $("input[name='agent_ad_"+ar_uid+"']").val();
f.agent_ch.value = $("input[name='agent_ch_"+ar_uid+"']").val();
f.agent_ba.value = $("input[name='agent_ba_"+ar_uid+"']").val();
f.res_state.value = $("select[name='res_state_"+ar_uid+"']").val();
var result = to_validation(f);
if ( result == false ) return false;
if (!confirm('수정하시겠습니까?')) return false;
ajax_post("ajax_proc","airticket_proc.html","airtdate_edit");
}
$("#chkbox_all").click(function(){
var ck=$(this).is(":checked");
$("input[name='chk_seq[]']").each(function(){
this.checked = ck;
});
});
</script>