|
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/hotel_tw/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
// 테이블명
$table = " TB_HOTEL ";
// 검색 설정
$sql_where = " and disp_yn='Y' ";
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="";
if($gamin) $sql_order = " {$gamin} desc , order_num , hseq desc";
//배열에 저장
$data = array();
$data = hotel_fetch($sql_where,$sql_order,$olds,$line);
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title">추천 호텔관리</div>
<div class="contents_detail">
<!-- 폼 -->
<form name="frm_search" id="frm_search" method="get" style="margin:0px;padding:0px;">
<div class="c_top_bar">
<select name="areaa_cd_s" id="areaa_cd_s" onchange="ajax_loader('../place/sights_area_selbox_ajax.html?SqlType=areab&areaa_cd='+this.value,'ajax_areab_cd');" class="lo_left top_input">
<option value="">==대륙==</option>
<?
for($i=0 ; $i < count($data_areaa) ; $i++){
$arr = $data_areaa[$i];
?>
<option value="<?=$arr['Aidx']?>" <?=($areaa_cd_s==$arr['Aidx'])?"selected":""?>><?=$arr['ContinentName']?></option>
<?}?>
</select>
<span id="ajax_areab_cd">
<select name="areab_cd_s" id="areab_cd_s" onchange="ajax_loader('../place/sights_area_selbox_ajax.html?SqlType=areac&areab_cd='+this.value,'ajax_areac_cd');" class="lo_left top_input">
<option value="">==국가==</option>
<?
for($i=0 ; $i < count($data_areab) ; $i++){
$arr = $data_areab[$i];
?>
<option value="<?=$arr['Bidx']?>" <?=($arr['Bidx']==$areab_cd_s)?"selected":""?>><?=$arr['NationName']?></option>
<?}?>
</select>
</span>
<span id="ajax_areac_cd">
<select name="areac_cd_s" id="areac_cd_s" class="lo_left top_input">
<option value="">==도시==</option>
<?
for($i=0 ; $i < count($data_areac) ; $i++){
$arr = $data_areac[$i];
?>
<option value="<?=$arr['Cidx']?>" <?=($arr['Cidx']==$areac_cd_s)?"selected":""?>><?=$arr['CityName']?></option>
<?}?>
</select>
</span>
<div class="lo_left">
<label for="place_nm_s" class="v_none2">검색어 입력</label>
<input class="search_box <?=($place_nm_s)?$place_nm_s:"search_box_bg2"?>" 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 url(../image/common/search_txtbg02.gif)';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" />
</div>
</div>
<div class="top_txt_s">
<p class="search_result_txt"><span><?=$total?></span> 개의 호텔이 검색되었습니다.</p>
</div>
</form>
<!-- /폼 -->
<div class="hotel_wrap">
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="post" style="margin:0px;padding:0px;">
<input type="hidden" name="SqlType" value="" />
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="t_list" summary="등록된 호텔 수정 및 관리를 할수 있습니다.">
<caption>호텔 수정 및 관리</caption>
<colgroup>
<col style=" width:45px" />
<col style=" width:95px" />
<col />
<col style=" width:110px" />
<col style=" width:80px" />
<col style=" width:80px" />
<col style=" width:80px" />
<col style=" width:80px" />
<col style=" width:80px" />
<col style=" width:60px" />
</colgroup>
<thead>
<tr>
<td colspan="11" class="t_top_line"></td>
</tr>
<tr>
<th scope="col">No.</th>
<th scope="col">이미지</th>
<th scope="col">호텔명/호텔코드</th>
<th scope="col">지역</th>
<th scope="col"><a href="<?=$_SERVER['PHP_SELF']?>?<?=$href?>&gamin=g_main1"><b>메인추천</b></a></th>
<th scope="col"><a href="<?=$_SERVER['PHP_SELF']?>?<?=$href?>&gamin=g_main2"><b>메인인기</b></a></th>
<th scope="col"><a href="<?=$_SERVER['PHP_SELF']?>?<?=$href?>&gamin=g_main3"><b>추천</b></a></th>
<th scope="col"><a href="<?=$_SERVER['PHP_SELF']?>?<?=$href?>&gamin=g_main4"><b>인기</b></a></th>
<th scope="col">등록일</th>
<th scope="col">조회</th>
</tr>
</thead>
<tbody>
<?
for($i=0 ; $i < count($data) ; $i++){
$row = $data[$i];
$num = $total - ($page - 1) * $line - $i;
$g_main1_yn = ( $row['g_main1'] == "Y" ) ? "N":"Y";
$g_main2_yn = ( $row['g_main2'] == "Y" ) ? "N":"Y";
$g_main3_yn = ( $row['g_main3'] == "Y" ) ? "N":"Y";
$g_main4_yn = ( $row['g_main4'] == "Y" ) ? "N":"Y";
?>
<tr>
<td><?=$num?></td>
<td><img src="<?=$row['img1_path']?>" alt="지역이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img1_path']?>','<?=$row['hotel_nm']?>')" /></td><!-- 이미지 -->
<td class="t_hotel_name"><?=$row['hotel_nm']?><!-- 호텔명 -->
<p class="hotel_code"><?=$row['hotel_code']?></p></td>
<td><?=$row['area_nm']?></td>
<td><input type="checkbox" name="g_main1" id="g_main1_<?=$row['hseq']?>" value="Y" <?=($row['g_main1']=="Y")?"checked":""?> onclick="gmain_check('<?=$row['hseq']?>','g_main1');"></td><!-- 메인추천 -->
<td><input type="checkbox" name="g_main2" id="g_main2_<?=$row['hseq']?>" value="Y" <?=($row['g_main2']=="Y")?"checked":""?> onclick="gmain_check('<?=$row['hseq']?>','g_main2');" disabled="true"></td><!-- 메인인기 -->
<td><input type="checkbox" name="g_main3" id="g_main3_<?=$row['hseq']?>" value="Y" <?=($row['g_main3']=="Y")?"checked":""?> onclick="gmain_check('<?=$row['hseq']?>','g_main3');" disabled="true"></td><!-- 추천 -->
<td><input type="checkbox" name="g_main4" id="g_main4_<?=$row['hseq']?>" value="Y" <?=($row['g_main4']=="Y")?"checked":""?> onclick="gmain_check('<?=$row['hseq']?>','g_main4');" disabled="true"></td><!-- 인기 -->
<td><?=$row['ins_dt2']?></td>
<td><?=$row['read_cnt']?></td>
</tr>
<?}?>
</tbody>
</table>
</form>
<!-- /폼 -->
</div>
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
<script type="text/javascript">
function gmain_check(hseq,id)
{
var yn_str='N';
if ($("#"+id+'_'+hseq).is(":checked") == true)
{
yn_str='Y';
}
ajax_loader("hotel_proc.php?SqlType=chg_gmain&hseq="+hseq+"&colnm="+id+"&yn_str="+yn_str);
}
</script>
<? include "../include/footer.html" ?>