|
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/res_good/ |
Upload File : |
<?
include "../include/top_iframe.html";
include "../reservation/_common.php";
// 항공사,출발도시,도착도시
$air_data = to_airticket_airline();
// 파라메터
$href = "s_cidx_s={$s_cidx_s}&cidx={$cidx_s}&d_start_s1={$d_start_s1}&d_start_s2={$d_start_s2}&d_start_s2={$d_start_s2}&airline_code_s={$airline_code_s}&tmp_layer_id={$tmp_layer_id}";
$_href = $href."&page=".$page;
// 기본날짜
if(!$d_start_s1) $d_start_s1 = date("Y-m-d"); // 기간 검색
if(!$d_start_s2) $d_start_s2 = date("Y-m-d",strtotime(" +4 month")); // 기간 검색
//테이블명
$table = "TB_AIR_TICKET";
// 검색 설정
$sql_where = "";
if ( $s_cidx_s) $sql_where .= " and s_cidx='{$s_cidx_s}' ";// 출발도시
if ( $cidx_s) $sql_where .= " and cidx='{$cidx_s}' ";// 도착도시
if ( $d_start_s1 and $d_start_s2 ) $sql_where .= " and start_dt between '{$d_start_s1}' and '{$d_start_s2}' ";// 출발일
if ( $airline_code_s ) $sql_where .= " and airline_code = '{$airline_code_s}' ";// 항공사코드
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 1 {$sql_where} ";
$row = db_fetch($sql);
$total = $row[total];
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 20; // 보여줄 갯수
$list = 10; // 블럭 갯수
$total_page = ceil($total / $line); // 총페이지
if ($total == 0) $total_page = 1; // 데이터가 하나도 없으면 총페이지 1
if ($page > $total_page) $page = $total_page; // 페이지가 전체 페이지보다 크면 페이지 번호를 바꿈
$total_list = intval($total_page / $list);
if ($total_page % $list == 0) $total_list--;
$curr_list = intval($page / $list);
if ($page % $list == 0) $curr_list--;
$start_page = $curr_list * $list + 1;
$prev_list = $start_page - $list;
$next_list = $start_page + $list;
$olds = $line * ($page - 1);
// 정렬 설정
$sql_order="";
$limit = " $olds , $line ";
//배열에 저장
$data = array();
$data = to_air_date($sql_where,$sql_order,$limit);
?>
<div class="" id="contents">
<div class="iframe contents_wrap_in" style="margin:-80px 10px 10px 0px;">
<!-- 폼 -->
<form name="dtsearch_form"id="dtsearch_form" method="get" >
<input type="hidden" name="tmp_layer_id" value="<?=$tmp_layer_id?>">
<table width="860" border="0" cellspacing="0" cellpadding="0" class="setting_write">
<tr><th>
<select name="s_cidx_s" id="s_cidx_s">
<option value="">==출발도시==</option>
<?
for($i=0 ; $i < count($air_data['s_cidx']) ; $i++){
$arr = $air_data['s_cidx'][$i];
?>
<option value="<?=$arr['s_cidx']?>" <?=($arr['s_cidx']==$s_cidx_s)?"selected":""?>><?=$arr['s_cidx_nm']?>(<?=$arr['s_cidx_count']?>)</option>
<?}?>
</select>
<select name="cidx_s" id="cidx_s">
<option value="">==출발도시==</option>
<?
for($i=0 ; $i < count($air_data['cidx']) ; $i++){
$arr = $air_data['cidx'][$i];
?>
<option value="<?=$arr['cidx']?>" <?=($arr['cidx']==$cidx_s)?"selected":""?>><?=$arr['cidx_nm']?>(<?=$arr['cidx_count']?>)</option>
<?}?>
</select>
<select name="airline_code_s" id="airline_code_2">
<option value="">==항공사==</option>
<?
for($i=0 ; $i < count($air_data['airline']) ; $i++){
$arr = $air_data['airline'][$i];
?>
<option value="<?=$arr['airline_code']?>" <?=($arr['airline_code']==$airline_code_s)?"selected":""?>><?=$arr['air_nm']?>(<?=$arr['airline_count']?>)</option>
<?}?>
</select>
출발일
<input type="text" name="d_start_s1" class="cal_input" value="<?=$d_start_s1?>" size="15" onclick="AjaxCal(this,event);"> ~
<input type="text" name="d_start_s2" class="cal_input" value="<?=$d_start_s2?>" size="15" onclick="AjaxCal(this,event);">
<input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_img" />
</th></tr>
</table>
</form>
<!-- /폼 -->
<table width="860" border="0" cellspacing="0" cellpadding="0" class="setting_write">
<thead>
<tr>
<td colspan="33" class="t_top_line"></td>
</tr>
<tr>
<th style="width:10px;">No.</th>
<th style="width:60px;">출발도시</th>
<th style="width:100px;">도착도시</th>
<th style="width:100px;">항공사</th>
<th>출발일시</th>
<th>도착일시</th>
<th style="width:50px;">성인요금</th>
<th style="width:50px;">아동요금</th>
<th>정원</th>
<th width="30">-</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = count($data) - ($page - 1) * $line - $i;
?>
<tr>
<td class="top_line"><?=$num?></td>
<td><?=$row['s_cidx_nm']?>(<?=$row['s_cidx']?>)</td><!-- 출발도시 -->
<td><?=$row['cidx_nm']?>(<?=$row['cidx']?>)</td><!-- 도착도시 -->
<td><?=$row['air_nm']?>(<?=$row['airline_code']?>)</td><!-- 항공사 -->
<td><?=$row['start_dt']?>(<?=$row['start_dt_yoil']?>) <?=$row['start_tm']?></td>
<td><?=$row['end_dt']?>(<?=$row['end_dt_yoil']?>) <?=$row['end_tm']?></td>
<td style="text-align:right;padding-right:10px;"><?=number_format($row['adult_price'])?></td>
<td style="text-align:right;padding-right:10px;"><?=number_format($row['child_price'])?></td>
<td><span style="<?if($row['left_seat']>0)echo "font-weight:bold;color:#3333FF;";?>"><?=$row['left_seat']?></span>/<?=$row['total_seat']?></td><!-- 예약/정원 -->
<td>
<?
if($row['reserv_yn']=="C" or $row['reserv_yn']=="R"){
?>
<input type="button" value="<?=$row['reserv_str']?>" class="btn_<?=$row['reserv_yn']?>_left" onclick="if(!confirm('연결하시겠습니까?'))return;;parent.ajax_loader('air_date_ajax.html?ar_uid=<?=$row['ar_uid']?>','',false);parent.to_dialog.close('<?=$tmp_layer_id?>');"><span class="btn_<?=$class_str?>_right"></span>
<?}else{?>
<?=$row['reserv_str']?>
<?}?>
</td>
</tr>
<?
}
?>
</tbody>
</table>
<?
echo adm_get_paging($total_page, $page, $list, "?$href&page=", "");
?>
</div>
</div>
<?
include "../include/footer_iframe.html";
?>
<script type="text/javascript">
window.onload=function()
{
ajax_loader('contab_selbox_ajax.html?SqlType=bc&tab=<?=$tab?>&b_uid=<?=$b_uid?>','ajax_sel_bc',false); // 1차분류
ajax_loader('contab_selbox_ajax.html?SqlType=mc&b_uid=<?=$b_uid?>&m_uid=<?=$m_uid?>','ajax_sel_mc',false); // 2차분류
ajax_loader('contab_selbox_ajax.html?SqlType=sc&b_uid=<?=$b_uid?>&m_uid=<?=$m_uid?>&s_uid=<?=$s_uid?>','ajax_sel_sc',false); // 3차분류
}
function to_dialog_close()
{
$("#SqlType",parent.document).val('conn_date');
parent.write_readony_date('d'); // 폼 수정금지
parent.to_dialog.close('<?=$tmp_layer_id?>'); // 창닫기
}
</script>