|
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_hotel/ |
Upload File : |
<?
include "../include/top.html";
include "_common.html";
//테이블명
$table = "TB_HOTEL";
// 검색 설정
$sql_where = " and hseq in(select h_seq as hseq from TB_HOTEL_ROOMTYPE where h_seq=hseq and del_flag='N' and disp_yn='Y') and disp_yn='Y' ";
if($b_uid_s) $sql_where .= " and b_uid = '{$b_uid_s}' "; // 1차카테고리
if($m_uid_s) $sql_where .= " and m_uid = '{$m_uid_s}' "; // 2차카테고리
if($areaa_cd_s) $sql_where .= " and areaa_cd = '{$areaa_cd_s}' "; //대륙
if($areab_cd_s) $sql_where .= " and areab_cd = '{$areab_cd_s}' "; //국가
if($areac_cd_s) $sql_where .= " and areac_cd = '{$areac_cd_s}' "; //도시
if($hotel_nm_s) $sql_where .= " and hotel_nm like '%{$hotel_nm_s}%' ";//호텔명
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 0=0 {$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
// $limit = " {$olds},{$line} ";
//배열에 저장
$data = array();
$data = hotel_list($sql_where,$sql_order,$olds,$line);
// 1차 카테고리
$bc_arr = TO_get_bc("","N"," and tab='L' ");
?>
<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">
<div class="c_top_bar">
<ul class="c_top_search">
<li>
<select name="b_uid_s" id="b_uid_s" class="lo_left top_input" onchange="ajax_loader('../res_good/good_selbox_ajax.html?SqlType=mc&b_uid_s='+this.value,'ajax_search_mc',false);">
<option value="">==1차분류==</option>
<?
for($a=0 ; $a<count($bc_arr) ; $a++){
$arr = $bc_arr[$a];
?>
<option value="<?=$arr['b_uid']?>" <?=($b_uid_s==$arr['b_uid'])?"selected":""?>><?=$arr['b_name']?></option>
<?}?>
</select>
</li>
<li>
<span id="ajax_search_mc">
<select name="m_uid_s" id="m_uid_s">
<option value="">==2차분류==</option>
</select>
</span>
</li>
<li> 호텔명<input class="search_box <?=($hotel_nm_s)?$hotel_nm_s:""?>" id="place_nm_s" name="place_nm_s" value="<?=$hotel_nm_s?>" type="text" onfocus="this.style.background='#ffffff url(none)'" onblur="if(this.value.length == 0) {this.style.background='#ffffff;this.style.backgroundRepeat='no-repeat';this.style.backgroundPosition='5px 1px';}" /><input type="image" src="../image/btn/btn_search.gif" align="top" alt="검색" class="input_btn_search" /></li>
</ul>
</div>
</form>
<!-- /폼 -->
<!-- /검색 폼 -->
<div id="Content_box">
<ul class="product_res">
<li class="lo_left">
<!-- 폼 -->
<h2 class="mt35">호텔목록</h2>
<div style="overflow-y:auto;overflow-x:hidden;">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list">
<thead>
<tr>
<th width="40">No.</th>
<th>호텔명</th>
<th width="120">6개월 입실월(月)</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = hotel_list_replace($data[$i]);
$num = $total - ($page - 1) * $line - $i;
?>
<tr class="mouse_over" id="list_hotel_<?=$row['hseq']?>" onclick="ajax_post('ajax_date_list','room_date_ajax.html?hseq=<?=$row['hseq']?>')">
<td><?=$num?></td>
<td class="txt_l pl10"><?=$row['hotel_nm']?></td>
<td style="text-align:left;"><?=$row['after_month']?></td>
</tr>
<?
}
?>
</tbody>
</table>
<?
echo adm_get_paging($total_page, $page, $list, "?$href&page=", "");
?>
</div>
</li>
<li class="lo_right">
<div id="ajax_date_list">
<h2 class="mt35">객실목록</h2>
<table border="0" cellspacing="0" cellpadding="0" width="100%" class="t_list">
<thead>
</thead>
</table>
</div>
</li>
</ul>
</div>
</div>
</div>
</div>
<script type="text/javascript">
var hseq,room_date;
$(document).ready(function(){
ajax_loader('../res_good/good_selbox_ajax.html?SqlType=mc&b_uid_s=<?=$b_uid_s?>&m_uid_s=<?=$m_uid_s?>','ajax_search_mc',false);
});
$(".mouse_over").bind({
mouseover:function(e){ $(this).css({"background-color":"#D7D7D7","cursor":"pointer"}); },
mouseout:function(e){ $(this).css("background-color","#FFFFFF"); }
});
</script>
<? include "../include/footer.html" ?>