|
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/ |
Upload File : |
<?
include "../include/top.html";
include "_common.php";
// 상품구분
if($tab)$tab_arr = TO_good_module("common",$tab);
// 사이트
if ($lang){
// 사이트 구분
$bc_arr = TO_get_bc("","N"," and b_lang='{$lang}' and tab='L'");
foreach($bc_arr as $k => $v){
$b_uid_list[] = $v['b_uid'];
}
}
// 1차 카테고리
//if($tab and $b_uid_s)$bc_arr = TO_get_bc($b_uid_s,"N"," and b_lang='{$lang}' ");
if($tab and $b_uid_s)$bc_arr = TO_get_bc($b_uid_s,"N");
// 2차 카테고리
if($tab and $b_uid_s and $m_uid_s)$mc_arr= TO_get_mc($b_uid_s,$m_uid_s,"N");
// 추천코드
$code_chuchun = base_codec("TGO","TOUR","","N");
// 테이블명
$table = " TB_HOTEL ";
if (!$order_nm) $order_nm = "ins_dt";
if (!$order_key) $order_key = "desc";
// 검색 설정
$sql_where = "";
if ($tab) $sql_where .= " and tab='{$tab}' "; // 상품구분
if ($search_key_s and $search_word_s) $sql_where .= " and {$search_key_s} like '%{$search_word_s}%' ";// 검색어(상품명,행사명,행사코드,담당자명)
if ( $date_s1 and $date_s2) $sql_where .= " and (DATE_FORMAT({$date_key},'%Y-%m-%d') >= '{$date_s1}' and DATE_FORMAT({$date_key},'%Y-%m-%d') <= '{$date_s2}' )";// 기간검색(등록일,수정일)
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($s_uid_s) $sql_where .= " and s_uid = '{$s_uid_s}' "; // 3차 카테고리
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($gmain_s) $sql_where .= " and {$gmain_s} = 'Y' ";
if ($b_uid_list) {
$sql_where .= " and b_uid in('".implode("','", $b_uid_list)."') ";
}
// 리스트 수 가져옴
$sql = "select count(*) as total from {$table} where 0=0 {$sql_where} ";
$row = db_fetch($sql);
$total = $row[total];
// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = $list_count_s; // 보여줄 갯수
$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 = $order_by_s;
//배열에 저장
$data = array();
$data = hotel_list($sql_where,$sql_order,$olds,$line);
// 전체개수
$tot_r = db_fetch("select count(*) as gtot from {$table} where b_uid='{$b_uid_s}' and m_uid='{$m_uid_s}' ");
$res_gtot = $tot_r['gtot'];
// 네비게이션 타이틀
//$title = "<strong>호텔</strong>";
//if($tab) $title = '<span class="tit_eng">'.$tab_arr['name_en'].'.</span> ';
if($tab and $b_uid_s) $title .= $bc_arr[0]['b_name'];
if($tab and $b_uid_s and $m_uid_s) $title .= '<span class="arrow">></span><strong>'.$mc_arr[0]['m_name'].'</strong>';
//메인섹션리스트
$mainPageSectionList = getMainPageSectionList($lang,'YN','Y');
$mainViewHotelSectionIdList = "";
foreach($mainPageSectionList as $item){
if(!$mainViewHotelSectionIdList){
$mainViewHotelSectionIdList = $item['mainViewSectionID'];
}else{
$mainViewHotelSectionIdList .= ','.$item['mainViewSectionID'];
}
}
$mainPageSectionViewGoodList = getMainPageSectionViewGoodList($lang, $mainViewHotelSectionIdList);
$mainPageSectionViewGoodListArr = array();
foreach($mainPageSectionViewGoodList as $item){
$mainPageSectionViewGoodListArr[$item['g_uid']] = $item;
}
?>
<div class="contents_wrap">
<div class="contents_wrap_in">
<div class="title"><?=$title?></div>
<div class="contents_detail">
<?
// 검색폼
require_once("hotel_list_search.php");
?>
<div id="Content_box">
<table width="100%" border="0" cellpadding="0" cellspacing="0" summary="" class="c_top_table" style="margin-top:29px; margin-bottom:20px;font-size:14px;position:relative;top:-4px">
<colgroup>
<col width="150px" />
<col />
</colgroup>
<tbody>
<tr class="bot_line" style="height:40px">
<td style="font-size:14px">
<span>검색<a href="javascript:;" class="c_black_b"> <?=$total?></a>개 ／ 전체<a href="javascript:;" class="c_black_b"> <?=$res_gtot?></a>개</span>
</td>
</tr>
</tbody>
</table>
<!-- 폼 -->
<form name="frm_list" id="frm_list" method="post">
<input type="hidden" name="SqlType" value="disp_yn_updt" />
<div class="c_top_sch_wrap">
<p class="c_top_sch_l">
<span>선택된 상품을</span>
<select class="mt-3 ml10" name="disp_yn" id="" hname="" required>
<option value="Y">사용(활성)</option>
<option value="N">비사용(비활성)</option>
</select>
<a href="javascript:;" class="Tbtn gray2 ml5 item_chg_order_state">일괄처리</a>
</p>
<!-- 상품정렬 -->
<ul class="c_top_sch_r">
<li>
<a href="javascript:;" class="Tbtn red" onclick="javascript:<?if(!$tab){?>alert('좌측카테고리를 먼저 선택하세요.');return;<?}?>document.location.href='../hotel/hotel_register_info.html?tab=<?=$tab?>&b_uid_s=<?=$b_uid_s?>';">상품등록</a>
</li>
<li class="ml10">
<select name="order_by_s" id="order_by_s">
<option value="ins_dt desc" <?=($order_by_s=="ins_dt desc")?"selected":""?>>등록일 ↑</option>
<option value="ins_dt" <?=($order_by_s=="ins_dt")?"selected":""?>>등록일 ↓</option>
<option value="edit_dt desc" <?=($order_by_s=="edit_dt desc")?"selected":""?>>수정일 ↑</option>
<option value="edit_dt" <?=($order_by_s=="edit_dt")?"selected":""?>>수정일 ↓</option>
<option value="order_num desc" <?=($order_by_s=="order_num desc")?"selected":""?>>노출순서 ↑</option>
<option value="order_num" <?=($order_by_s=="order_num")?"selected":""?>>노출순서 ↓</option>
</select>
</li>
<li>
<select name="list_count_s" id="list_count_s" >
<option value="20" <?=($list_count_s==20)?"selected":""?>>20개 보기</option>
<option value="30" <?=($list_count_s==30)?"selected":""?>>30개 보기</option>
<option value="50" <?=($list_count_s==50)?"selected":""?>>50개 보기</option>
<option value="70" <?=($list_count_s==70)?"selected":""?>>70개 보기</option>
</select>
</li>
</ul><!-- 상품등록 -->
</div>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="T_list" summary="등록된 호텔 수정 및 관리를 할수 있습니다.">
<caption>호텔 수정 및 관리</caption>
<colgroup>
<col style=" width:42px" />
<col style=" width:42px" />
<col style=" width:42px" />
<col style=" width:45px" />
<col style=" width:60px" />
<col style=" width:94px" />
<col style=" width:94px" />
<col />
<?if($cf['tab']['L']=="Y"){?>
<col style=" width:54px" /><!-- 객실관리 -->
<col style=" width:54px" /><!-- 옵션관리 -->
<?}?>
<col style=" width:156px" /><!-- 호텔정보_new -->
<col style=" width:54px" />
<col style=" width:80px" />
<col style=" width:60px" />
</colgroup>
<thead>
<tr>
<th scope="col"><label for="checkall" class="v_none2">선택 체크</label><input type="checkbox" name="checkall" id="checkall" /></th>
<th scope="col">번호</th>
<th scope="col">복사</th>
<th scope="col">사용</th>
<th scope="col"><span id="change_ordernum" title="순서를 저장합니다." style="cursor:pointer;">노출순서</span><span class="list_order" order_nm="order_num" order_key="<?=$order_key?>"><?=$order_ico_arr['order_num']['icon']?></span></th>
<th scope="col">호텔코드</th>
<th scope="col">이미지</th>
<th scope="col">호텔명</th>
<?if($cf['tab']['L']=="Y"){?>
<th scope="col">객실관리</th>
<th scope="col">옵션관리</th>
<?}?>
<th scope="col">호텔정보</th>
<th scope="col" class="list_order" order_nm="read_cnt">조회</th>
<th scope="col" class="list_order" order_nm="ins_dt">등록일/수정일</th>
<th scope="col" class="c_red">삭제</th>
</tr>
</thead>
<tbody>
<?php
for($i=0 ; $i < count($data) ; $i++) {
$row = hotel_list_replace($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";
// 개수 초기화 & 이미지 필터
$filter = "style='filter:alpha(opacity=20);opacity:0.2;'";
$span_gray = "<span style='comment_gray'>(0)</span>";
// 객실관리 아이콘[필수]
if ( $row['date_cnt'] > 0 ) {
$date_arr['_cnt'] = str_replace("0",$row['date_cnt'],str_replace("_grap","",$span_gray));
$date_arr['_filter'] = "";
}else{
$date_arr['_cnt'] = $span_gray;
$date_arr['_filter'] = $filter;
}
// 옵션관리 아이콘[필수]
if ( $row['option_cnt'] > 0 ) {
$option_arr['_cnt'] = str_replace("0",$row['option_cnt'],str_replace("_grap","",$span_gray));
$option_arr['_filter'] = "";
}else{
$option_arr['_cnt'] = $span_gray;
$option_arr['_filter'] = $filter;
}
// 상세정보 아이콘
if ( $row['detail_cnt'] > 0 ) {
$detail_arr['_cnt'] = str_replace("0",$row['detail_cnt'],str_replace("_grap","",$span_gray));
$detail_arr['_filter'] = "on";
}else{
$detail_arr['_cnt'] = $span_gray;
$detail_arr['_filter'] = "gray";
}
// 갤러리 아이콘
if ( $row['gallery_cnt'] > 0 ) {
$gallery_arr['_cnt'] = str_replace("0",$row['gallery_cnt'],str_replace("_grap","",$span_gray));
$gallery_arr['_filter'] = "on";
}else{
$gallery_arr['_cnt'] = $span_gray;
$gallery_arr['_filter'] = "gray";
}
// 지도정보 아이콘
if ( $row['map_cnt'] > 0 ) {
$map_arr['_cnt'] = str_replace("0",$row['map_cnt'],str_replace("_grap","",$span_gray));
$map_arr['_filter'] = "on";
}else{
$map_arr['_cnt'] = $span_gray;
$map_arr['_filter'] = "gray";
}
// 관광정보 아이콘
if ( $row['place_cnt'] > 0 ) {
$place_arr['_cnt'] = str_replace("0",$row['place_cnt'],str_replace("_grap","",$span_gray));
$place_arr['_filter'] = "on";
}else{
$place_arr['_cnt'] = $span_gray;
$place_arr['_filter'] = "gray";
}
?>
<tr>
<td><input type="checkbox" name="h_seq_arr[]" class="item_checkbox" value="<?=$row['hseq']?>" /></td>
<td><?=$num?></td>
<td><img src="../image/icon/btn_copy.gif" id="btn_menu_<?=$num?>" onclick="choose_menu('<?=$num?>','<?=$row['hseq']?>')" title="상품복사" style="cursor:pointer;"/></td>
<td><span id="disp_yn_<?=$row['hseq']?>" style="cursor:pointer;"><img src="../image/btn/<?=$row['disp_yn2']?>" onClick="ajax_obj_loader('hotel_proc.php?SqlType=hotel_disp_yn&hseq=<?=$row['hseq']?>&disp_yn=<?=$row['disp_yn_opp']?>','disp_yn_<?=$row['hseq']?>');" alt="사용여부체크" /></span></td>
<td>
<label for="order_num_arr" class="v_none2">순서입력</label>
<input name="order_num_arr[]" id="order_num_arr" value="<?=$row['order_num']?>" type="text" class="t_no" maxlength="3" style="text-align:center; width:24px;" onKeyDown="ChkNum(this,event);" autocomplete='off' /><input type="hidden" name="hseq_arr[]" value="<?=$row['hseq']?>" />
</td>
<td>
<?=$row['hotel_code']?>
<? if($row['api_icon']) { ?>
<br><br><?=$row['api_icon']?>
<? } ?>
</td>
<td><img src="<?=$row['img1_thum']?>" title="지역이미지" width="88" height="57" style="cursor:pointer;" onClick="to_dialog.image('<?=$row['img1_path']?>')" /></td><!-- 이미지 -->
<td class="t_hotel_name">
<p class="hotel_code"><?=$row['special_icon']?></p>
<a href="hotel_edit.html?<?=$_href?>&hseq=<?=$row['hseq']?>&b_uid_s=<?=$row['b_uid']?>"><?=$row['hotel_nm']?></a><!-- 호텔명 -->
<p class="Hcode_type">
<?php
$seqNo = 1;
foreach($mainPageSectionList as $item){
$isChecked = "";
if(isset($mainPageSectionViewGoodListArr[$row['hseq']])){
if($mainPageSectionViewGoodListArr[$row['hseq']]['mainViewSectionID'] == $item['mainViewSectionID']){
$isChecked = "checked";
}
}
?>
<input type="checkbox" name="mainSectionViewGood" class="setMainSectionViewGood" lang=<?=$row['lang']?> sectionName="<?=$item['title']?>" g_uid="<?=$row['hseq']?>" mainSectionID="<?=$item['mainViewSectionID']?>" <?=$isChecked?>/>
<img src="/toadmin/image/icon/num_<?=$seqNo?>.gif" alt="<?=$item['seq']?>"> <?=$item['title']?>
<?php
$seqNo++;
}
?>
</p>
</td>
<?if($cf['tab']['L']=="Y"){?>
<td>
<a href="hotel_date.html?<?=$_href?>&hseq=<?=$row['hseq']?>"><img <?=$date_arr['_filter']?> src="../image/on.png" style="cursor:pointer" title="객실관리"></a><br /><?=$date_arr['_cnt']?></a><!-- 객실관리 -->
</td>
<td>
<a href="hotel_option.php?<?=$_href?>&hseq=<?=$row['hseq']?>"><img <?=$option_arr['_filter']?> src="../image/on.png" style="cursor:pointer" title="옵션관리"></a><br /><?=$option_arr['_cnt']?></a><!-- 옵션관리 -->
</td>
<?php }?>
<td>
<div class="Btn_State_wrap">
<?if($cf['tab']['L']=="Y"){?>
<input class="Btn_State <?=$detail_arr['_filter']?>" type="button" value="상세정보(<?=$row['detail_cnt']?>)" onclick="document.location.href='hotel_edit_detail.html?<?=$_href?>&hseq=<?=$row['hseq']?>';"><!-- 관광정보 -->
<?php }?>
<input class="Btn_State <?=$place_arr['_filter']?>" type="button" value="관광정보(<?=$row['place_cnt']?>)" onclick="document.location.href='hotel_register_sights.html?<?=$_href?>&hseq=<?=$row['hseq']?>';"><!-- 관광정보 -->
<input class="Btn_State <?=$map_arr['_filter']?>" type="button" value="지도정보(<?=$row['map_cnt']?>)" onclick="document.location.href='hotel_map.html?<?=$_href?>&hseq=<?=$row['hseq']?>';"><!-- 지도정보 -->
<input class="Btn_State <?=$gallery_arr['_filter']?>" type="button" value="갤러리(<?=$row['gallery_cnt']?>)" onclick="document.location.href='hotel_register_gallery.html?<?=$_href?>&hseq=<?=$row['hseq']?>';"><!-- 갤러리 -->
</div>
</td> <!-- 호텔정보_new -->
<td><?=$row['read_cnt']?></td>
<td><?=$row['ins_dt2']?><br><?=$row['edit_dt2']?></td>
<td><input type="button" value="삭제" class="Table_btn" onclick="if(!confirm('정말삭제하시겠습니까?'))return;ajax_loader('hotel_proc.php?SqlType=delete_hotel&hseq=<?=$row['hseq']?>');"></td>
</tr>
<?php
}
?>
</tbody>
</table>
</form>
<!-- /폼 -->
<?=adm_get_paging($total_page, $page, $list, "?$href&page=", "")?>
</div>
</div>
</div>
</div>
<div style="display:none;width:150px;z-index:9999;" id="menu_box" >
<?
// 1차 카테고리
$arr_1 = TO_get_bc("","N"," AND DelFlag='N' AND tab='L' ");
// 1차 카테고리
//if (count($arr_1)>0) echo "<ul>";
for($j=0 ; $j<count($arr_1) ; $j++) {
$arr1 = $arr_1[$j];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','','');"><?=$arr1['b_name']?>(<?=$arr1['b_uid']?>)</a>
<?
// 2차 카테고리
$arr_2 = TO_get_mc($arr1['b_uid'],"","N");
if (count($arr_2)>0) echo "<ul>";
for($k=0 ; $k<count($arr_2) ; $k++)
{
$arr2 = $arr_2[$k];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','<?=$arr2['m_uid']?>','');"><?=$arr2['m_name']?>(<?=$arr2['m_uid']?>)</a>
<?
// 3차 카테고리
$arr_3 = TO_get_sc($arr1['b_uid'],$arr2['m_uid'],"","N");
if (count($arr_3)>0) echo "<ul>";
for($n=0 ; $n<count($arr_3) ; $n++)
{
$arr3 = $arr_3[$n];
?>
<li><a href="javascript:;" onclick="good_copy('<?=$arr1['b_uid']?>','<?=$arr2['m_uid']?>','<?=$arr3['s_uid']?>');"><?=$arr3['s_name']?>(<?=$arr3['s_uid']?>)</a></li>
<?
}
if (count($arr_3)>0) echo "</ul>";
?>
</li>
<?
}
if (count($arr_2)>0) echo "</ul>";
?>
</li>
<?
}
//if (count($arr_1)>0) echo "</ul>";
?>
</li>
</div>
<script type="text/javascript">
var hseq;
// 상품카피
function good_copy(b_uid,m_uid,s_uid)
{
var params = "b_uid="+b_uid+"&m_uid="+m_uid+"&s_uid="+s_uid+"&hseq="+hseq;
if(!m_uid) return;
if (!confirm('해당카테고리에 호텔을 복사 하시겠습니까?\n기본정보, 상세정보, 지도정보, 관광정보만 복사됩니다.')) return;
ajax_post("","hotel_proc.php?SqlType=hotel_copy&"+params);
}
// 상품카피 메뉴
function choose_menu(num,gid)
{
var obj = $("#menu_box");
var e = ($("#btn_menu_"+num).offset());
obj.css({"left":e.left-parseInt(10)+"px","top":e.top});
hseq = gid;
$("#menu_box").fadeToggle("fast","linear");
}
//순서조정
$("#change_ordernum").click(function(){
var f = document.frm_list;
f.SqlType.value='change_ordernum';
if(!confirm('순서를 변경하시겠습니까?')) return;
ajax_post('ajax_proc','hotel_proc.php','frm_list');
})
// 추천
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);
}
$(document).ready(function(){
$("#menu_box").menu();
$("#menu_box").mouseleave(function(event){
$("#menu_box").hide();
hseq='';
});
$("#order_by_s").on("change",function(){
var order_by_s = $("#order_by_s").val();
var list_count_s = $("#list_count_s").val();
window.document.location.href='<?=$PHP_SELF?>?<?=$href?>&order_by_s='+order_by_s+'&list_count_s='+list_count_s;
});
$("#list_count_s").on("change",function(){
var order_by_s = $("#order_by_s").val();
var list_count_s = $("#list_count_s").val();
window.document.location.href='<?=$PHP_SELF?>?<?=$href?>&order_by_s='+order_by_s+'&list_count_s='+list_count_s;
});
$(".item_chg_order_state").on("click",function(){
if($(".item_checkbox:checked").length==0){
alert('적어도 한개 항목을 선택해 주세요.');
return;
}
if(!confirm('사용상태를 변경하시겠습니까?')) return;
ajax_post("ajax_proc","hotel_proc.php","frm_list");
});
$('.setMainSectionViewGood').click(function(){
console.log('sectionname is ' + $(this).attr('sectionname'));
console.log('g_uid is ' + $(this).attr('g_uid'));
console.log('mainsectionid is ' + $(this).attr('mainsectionid'));
console.log('lang is ' + $(this).attr('lang'));
// console.log('checkValue is ' + checkValue);
console.log(to_mb_id);
checkValue = $(this).prop("checked");
if(checkValue){
dbType = 'insert';
}else{
dbType = 'delete';
}
gUid = $(this).attr('g_uid');
mainSectionID = $(this).attr('mainsectionid');
lang = $(this).attr('lang');
$.ajax({
type: "POST",
url: "/toadmin/ajaxData/",
data: {mode: 'setMainPageViewGoods', gUid, mainSectionID, lang, to_mb_id, dbType},
dataType: 'json',
async: false,
success: function (data) {
console.log(JSON.stringify(data));
if (data.result == true) {
iziToast.show({
timeout: 2000,
color: 'green',
title: '메인페이지 노출 설정',
message: "적용되었습니다.",
});
} else {
iziToast.show({
timeout: 2000,
color: 'red',
title: '메인페이지 노출 설정',
message: "실패하였습니다.",
});
}
},
error: function (e) {
iziToast.show({
timeout: 2000,
color: 'red',
title: '메인페이지 노출 설정',
message: "실패하였습니다.",
});
}
});
})
});
</script>
<style type="text/css">
#menu_box {position:absolute;padding:5px 5px 5px;border:1px solid #A398EB;background-color:#ffffff;}
#menu_box ul{width:150px;}
</style>
<? include "../include/footer.html" ?>