ÿØÿà JFIF ` ` ÿþ
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 "../res_hotel/_common.html"; $nextloadwx = $nextloadwx; $skin=($skin) ? $skin:"resgood_contabedit"; if ($cseq) { // 상담마스터 $data = contab_list(" and cseq = '{$cseq}' "); $row = $data[0]; } //테이블명 $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 hseq in(select h_seq from TB_HOTEL_DATE where room_date >= CURDATE()) and disp_yn='Y' "; $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 hseq in(select h_seq from TB_HOTEL_DATE where room_date >= CURDATE()) "; if($b_uid_s) $sql_where .= " and h.b_uid = '{$b_uid_s}' "; // 1차카테고리 if($m_uid_s) $sql_where .= " and h.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 h.hotel_nm like '%{$hotel_nm_s}%' ";//호텔명 // 리스트 수 가져옴 $sql = "select count(*) as total from {$table} h where 0=0 {$sql_where} "; $row = db_fetch($sql); $total = $row[total]; // 페이지수 설정 if (!$page) $page = 1; // 페이지 번호 $line = 12; // 보여줄 갯수 $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); $data = hotel_list_admin($sql_where,$sql_order,$olds,$line,$lang); // 1차 카테고리 $bc_arr = TO_get_bc("","N"," and tab='L' and b_lang='{$lang}' "); ?> <div class="iframe ma0"> <div class="popbox"> <!-- 본문 --> <!-- 폼 --> <form name="frm_search" id="frm_search" method="get" style="margin:0px;padding:0px;"> <INPUT TYPE="hidden" NAME="tmp_layer_id" value="<?=$tmp_layer_id?>"> <INPUT TYPE="hidden" NAME="cseq" value="<?=$cseq?>"> <INPUT TYPE="hidden" NAME="nextloadwx" value="<?=$nextloadwx?>"> <input type="hidden" name="lang" value="<?=$lang?>"> <input type="hidden" name="curunit" value="<?=$curunit?>"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="setting_write search"> <tbody> <tr><th> <?if(!$lang) { ?> <select name="lang" class="lo_left top_input" onchange="document.frm_search.submit();" > <option value="">언어</option> <option value="ko">한글</option> <option value="en">영어</option> <option value="cn">간체</option> <option value="hk">번체</option> </select> <? } ?> <select name="b_uid_s" id="b_uid_s" class="lo_left top_input" onchange="ajax_loader('../res_good/good_selbox_ajax.html?lang=<?=$lang?>&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> <span id="ajax_search_mc"> <select name="m_uid_s" id="m_uid_s" class="lo_left top_input"> <option value="">==2차분류==</option> </select> </span> 호텔명 <input class="search_box <?=($place_nm_s)?$place_nm_s:""?>" id="place_nm_s" name="place_nm_s" value="<?=$place_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_img input_btn_search" /> </th></tr> </tbody> </table> </form> <!-- /폼 --> <div class="hotel_wrap"> <ul class="product_res"> <li class="lo_left" style="width:40%"> <h2 class="mt35">호텔목록</h2> <table width="95%" border="0" cellspacing="0" cellpadding="0" class="t_list"> <colgroup> <col width="10%" /> <col /> <col width="15%" /> </colgroup> <thead> <tr> <td colspan="3" class="t_top_line"></td> </tr> <tr> <th>No.</th> <th>호텔명</th> <th>룸타입</th> </tr> </thead> <tbody> <? for($i=0 ; $i < count($data) ; $i++){ $row = $data[$i]; $num = $total - ($page - 1) * $line - $i; ?> <tr class="mouse_over" id="list_hotel_<?=$row['hseq']?>" onclick="ajax_post('ajax_date_list','../res_hotel/room_date_ajax.html?hseq=<?=$row['hseq']?>&skin=<?=$skin?>&nextloadwx=<?=$nextloadwx?>&lang=<?=$lang?>&curunit=<?=$curunit?>')"> <td><?=$num?></td> <td style="text-align:left;"><?=$row['hotel_nm']?></td> <td><?=$row['roomtype_cnt']?></td> </tr> <? } ?> </tbody> </table> <? echo adm_get_paging($total_page, $page, $list, "?$href&page=", ""); ?> </li> <li class="lo_right" style="width:60%"><div id="ajax_date_list"></div></li> </ul> </div> <!-- /본문 --> </div> </div> <script type="text/javascript"> var hseq,room_date; function reserv_hotel2(hseq,ridx,room_date,hdidx) { if(!confirm('예약을 진행하시겠습니까?')) return; parent.to_dialog.iframe('../res_hotel/hotel_res_reg.html?cseq=<?=$cseq?>&lang=<?=$lang?>&curunit=<?=$curunit?>&hseq='+hseq+'&ridx='+ridx+'&hdidx='+hdidx+'&room_date='+room_date,'호텔예약','1100','700',true,true,'yes'); parent.to_dialog.close('<?=$tmp_layer_id?>'); } function new_reserv_hotel(hseq,ridx,room_date,hdidx) { // 관리자페이지에서 TK직접예약으로 호텔 예약 시 객실 선택하면 여기 호출! if(!confirm('예약을 진행하시겠습니까?')) return; parent.ajax_loader('hotelResRegFormHotel.ajax.html?lang=<?=$lang?>&curunit=<?=$curunit?>&hseq='+hseq+'&ridx='+ridx+'&hdidx='+hdidx+'&room_date='+room_date,'item_ajaxResHotel'); parent.to_dialog.close('<?=$tmp_layer_id?>'); } $(".mouse_over").bind({ mouseover:function(e){ $(this).css({"background-color":"#D7D7D7","cursor":"pointer"}); }, mouseout:function(e){ $(this).css("background-color","#FFFFFF"); } }); 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); }); </script> <? include "../include/footer_iframe.html" ?>