<?
include "../include/top.html";
include "_list.html";

// Made by Paul 12-03-2019 -- Start
$_TOP_path    = $_SERVER[DOCUMENT_ROOT] . "/toadmin/_TOPTRAVEL_CUST_/";
$_TOP_files = scandir($_TOP_path);
$_TOP_files = array_diff(scandir($_TOP_path), array('.', '..'));
foreach($_TOP_files as $_TOP_file) $_TOP_[str_replace(".db", "", str_replace("permalink_", "", $_TOP_file))] = file_get_contents($_TOP_path."/".$_TOP_file);
function _TOP_PERMALINK_($href) {
	global $_TOP_;
        $Key = explode("&", explode("g_uid=", $href)[1])[0];
	$PERMALINK = $_TOP_[$Key];
        if ($PERMALINK) {
		return "../good/" . $PERMALINK;
	} else return $href;
}
// -- End


// 테이블명
$table = " good ";

// 검색 설정
//$sql_where = "AND g_uid = (SELECT g_uid FROM `date` WHERE g_uid= good.g_uid AND d_start > CURDATE() ORDER BY d_start ASC LIMIT 1)";
// spark(20190525) : 행사등록을 하지 않은 상품도 Display 하도록 변경
//$sql_where .= " AND ";
//$ag = get_cookie('ag');


// 출발지 지정 sjang(2019/07) 
$ag = $_COOKIE['ag']; // 쿠키값으로 ag 값 가져옴
if($ag == 'WS'){
    $sql_where .= "g_ok='Y' ";
}else if($ag == 'NY'){
    $sql_where .= "g_ok2='Y' ";
}else if($ag == 'OT'){
    $sql_where .= "g_ok3='Y' ";
}else if($ag == 'SE'){
    $sql_where .= "g_ok4='Y' ";
}else{
    $sql_where .= "g_ok='Y' and g_ok2='Y' and g_ok3='Y' and g_ok4='Y' ";
}

$sql_where.= $cf['on_site']['user_where'];
// spark(20190227): 원더풀투어 선택시 sql 변경
//if ($b_uid_s) $sql_where .= " and b_uid='{$b_uid_s}' "; // 1차 카테고리(필수)
if ($b_uid_s){
	if($b_uid_s == 38) {
	    /* -- Original  by 9/1/2021 --  $sql_where .= " and displayToWT='y' "; // 원더풀투어 */
	    /*$sql_where .= " and b_uid='{$b_uid_s}' "; // 바로 하단과 같이 수정 - 오류 문제로 임시로 수정 by 9/1/2021*/
	    $sql_where .= " and displayToWT='y' ";
	} else {
	    $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 ($Bidx_s) $sql_where .= " and Bidx='{$Bidx_s}' "; // 국가
if ($Cidx_s) $sql_where .= " and Cidx='{$Cidx_s}' "; // 도시
//if ($start_dt_s) $sql_where .= " and d_start='{$start_dt_s}' ";// 출발일
if($g_title_s) //공백을통한 여러 단어가 포함된 단어 연관검색 예) 워싱턴 2박.
    {
        $g_title_sc_ar=explode(' ',$g_title_s);
        for($i=0; $i<count($g_title_sc_ar); $i++){
            if($g_title_sc_ar[$i] == '여행'){
            }elseif($g_title_sc_ar[$i] == '관광'){
            }elseif($g_title_sc_ar[$i] == '투어'){
            }elseif($g_title_sc_ar[$i] == '관광'){
            }else{
                $sql_where .= " and g_title like '%{$g_title_sc_ar[$i]}%' ";// 상품명
            }    
        }
    }
if ($d_start_s1 and $d_start_s2) { // 출발일
	$g_uid_in = ""; 
	$sql = "select g_uid from date where d_start between '{$d_start_s1}' and '{$d_start_s2}' group by g_uid ";

	$rss = db_query($sql);
	$arr_t = db_fetch_all($rss);
	for($i=0,$j=1 ; $i<count($arr_t) ; $i++,$j++ ) {
		$arr = $arr_t[$i];
		if ($j<count($arr_t)) $g_uid_in .= " '{$arr[g_uid]}',";
		else $g_uid_in .= "'{$arr[g_uid]}'";
	}
	if($g_uid_in) $sql_where .= " and g_uid in ({$g_uid_in})";
}

//메인에서 검색해서 들어올때
if($sc_mode=='true'){
	if($start_place_s){
		$sql_where.= "and m_uid in(select m_uid from mc where m_name like '%".$start_place_s."%') ";
	}

	if($start_dt_s){
		$g_uid_in = ""; 
		$sql.= "select distinct g_uid from date where d_start='{$start_dt_s}' ";

		$rss = db_query($sql);
		$arr_t = db_fetch_all($rss);
		for($i=0,$j=1 ; $i<count($arr_t) ; $i++,$j++ ) {
			$arr = $arr_t[$i];
			if ($j<count($arr_t)) $g_uid_in .= " '{$arr[g_uid]}',";
			else $g_uid_in .= "'{$arr[g_uid]}'";
		}
		if($g_uid_in) $sql_where .= " and g_uid in ({$g_uid_in})";
	}

}

if($period){
	$sql = "SELECT cd_nm,cd_memo,cd_memo2 FROM TB_CODEC WHERE cd_a='TGO' AND cd_b='PERD' AND `code`='{$period}'";
	$period_arr = db_fetch($sql);
	//$sql_where .= " AND g_uid in(SELECT g_uid FROM `date` WHERE period='{$period_arr['cd_memo2']}' AND periodStr='{$period_arr['cd_memo']}' AND d_start > CURDATE() AND d_ok <> 'D' GROUP BY g_uid) ";
	$sql_where .= " and EXISTS (SELECT 1 FROM `date` WHERE period='{$period_arr['cd_memo2']}' AND periodStr='{$period_arr['cd_memo']}' AND d_start > CURDATE() AND d_ok <> 'D' and `date`.g_uid=good.g_uid) ";
}

// 리스트 수 가져옴
//$sql = "select count(*) as total from {$table} where 0=0 {$sql_where} ";
//2023-10-20 일정없어도 리스트 보이게
//$sql = "SELECT count(*) as total FROM {$table} RIGHT JOIN (SELECT g_uid, d_start FROM `date` WHERE d_start > CURDATE() GROUP BY g_uid) AS sdate ON good.g_uid = sdate.g_uid where {$sql_where} ";
$sql = "SELECT count(*) as total FROM {$table} where {$sql_where} ";
$row = db_fetch($sql);
$total = $row['total'];

// 페이지수 설정
if (!$page) $page = 1; // 페이지 번호
$line = 10; // 보여줄 갯수
$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="";
$sql_order.= $cf['on_site']['user_order'];

//배열에 저장
$data = array();
//$data = good_list($sql_where,$sql_order,$olds,$line);
$data = new_good_list($sql_where,$sql_order,$olds,$line);

//검색기간 리스트
$period_list = base_codec("TGO","PERD","","N");

$banner12 = homepage_banner("TMSS012","","Y","20", "and b_uid='{$b_uid_s}' ");
?>
	<script src="./js/good.js" type="text/javascript"></script>
	<div id="container">
		<?if($sc_mode!='true' && count($banner12)>0){//검색모드가 아닐때?>
		<div class="bx_wrap">
		     <ul class="bxslider">
		     	<?for($i=0;$i<count($banner12);$i++){
					$arr = $banner12[$i];
				?>
		        <li><img src="<?=$arr['img_big']?>" alt="<?=$arr['title']?>"></li>
		        <?}?>
		    </ul>
		    <div class="bx_direction">
		        <span class="slider_prev"></span><span class="slider_next"></span>
		    </div>
		    <div class="pager_01"></div>
		</div>
		<?}?>
		
		<!-- contents -->
		<div id="contents" class="contents w100p">
			
			<!-- new_snb -->
	            <div id="new_nav">
	                <? include "snb.html" ?>
	            </div>
	            <!-- //new_snb -->
			<!-- title -->
			<div id="title" class="left">
				<div class="box">
					<div id="location" style="right:0"><a href="/">홈</a> <?=$disp_navi?></div>
					<h3 class="con_tit"><?=($nav['m_name'])?$nav['m_name']." ":""?><?=$nav['b_name']?> <?=is_medical_tab($b_uid_s) ?"": is_usim_tab($b_uid_s) ? " 칩 구매 <!--(온라인 준비중입니다)-->" : "여행상품";?> <?if($sc_mode=='true'){?> 검색:  <?=$g_title_s?><?}?></h3>
				    
				    <?if(is_usim_tab($b_uid_s)){?><br><br><br><h4><a href="https://www.toptravelusa.com/cmm/?MODE=view&BD_CD=TOURINF&MSEQ=131../good/list.html?b_uid_s=33&m_uid_s=145">유심구입 가이드(클릭)</a></h4><?}else{}?>
				</div>
			</div>
			<!-- /title -->

			<!-- product_list_zone -->
			<div class="product_list_zone">
				<div class="box">
					<form name="search_frm" id="search_frm" method="get">
					<input type="hidden" name="sc_mode" value="<?=$sc_mode?>"><!-- 검색모드 -->
					<input type="hidden" name="b_uid_s" value="<?=$b_uid_s?>">
					<input type="hidden" name="m_uid_s" value="<?=$m_uid_s?>">
					<input type="hidden" name="s_uid_s" value="<?=$s_uid_s?>">
					<div class="sort">
						<!--<span>Sort by : </span>-->
						<!--
						<div class="select_box">
							<label for=""><?=(!$period)?"원하는 일수를 선택하세요":$period_arr['cd_nm']?></label>
							<select name="period" id="period" onchange="$('#search_frm').submit();" class="choose">
								<option value="">원하는 일수를 선택하세요</option>
								<?for($i=0;$i<count($period_list);$i++){?>
								<option value="<?=$period_list[$i]['code']?>" <?=($period_list[$i]['code'] == $period)?"selected":""?>><?=$period_list[$i]['cd_nm']?></option>
								<?}?>
							</select>
						</div>-->
					</div>
					</form>
					<div class="product_list">
						<ul id="list">
							<?if(!empty($data)){foreach($data as $row){?>
							<li>
								<div class="list_con" id="top_<?=$row['g_uid']?>">
									<?/*<div class="img"><a href="javascript:;" onclick="good.date_tab('<?=$row['g_uid']?>','');return false;"><img src="<?=$row['img_src2']?>" width="268" height="180" /></a></div>*/?>
									<div class="img"><a href="<?=_TOP_PERMALINK_($row['d_href'])?>"><img src="<?=$row['img_src2']?>" width="268" height="180" /></a></div>
									<div class="con">
										<span class="p_icon"><?=$row['special_icon']?></span>
										<strong class="subject"><a href="<?=_TOP_PERMALINK_($row['d_href'])?>"><?=$row['g_title']?></a></strong>
										
										<span class="txt"><?=$row['g_brief']?></span>
										<p class="arrowinfo"><span class="arrow"><?=is_medical_tab($b_uid_s) ? "검진" : "여행";?>일정</span> <span class="dn"><?=$row['period_date']?></span> <span class="arrow ml20">상품코드</span> <span class="num"><?=$row['g_code']?></span></p>
										<span class="price"><?=$row['main_to_max_price2']?></span>
										<span class="btn_sch view"><a href="javascript:;" onclick="popup_schedule('<?=$row['g_uid']?>','<?=$row['g_title']?>','Y');">일정표 보기</a></span>
										<span class="btn_sch btn_sch_on" id="btn_sch_<?=$row['g_uid']?>"><a href="javascript:;" onclick="good.date_tab('<?=$row['g_uid']?>','','<?=$row['d_start']?>');return false;"> <?if(is_ticket_tab($row['b_uid'])){?> 사용일 선택 <?} else{ ?> 출발일 보기 <?}?></a></span>
									</div>
								</div>
								<div id="ajax_start_date_<?=$row['g_uid']?>" class="ajax_start_date" style="display:none;"></div>
							</li>
							<?}}?>
						</ul>
					</div>
					<?=TO_get_paging($total_page, $page, $list, "?$href&page=", "")?>
					<!--/paging-->
					
				</div>
			</div>
			<!-- /product_list_zone -->
			
		</div>
		<!-- //contents -->
		
	</div>
	<!--=== //container ===-->
	
<script type="text/javascript">
$(document).ready(function() {
	var slider = $('.bxslider').bxSlider({
		auto: true,
    	mode: 'fade',
    	nextSelector: '.slider_next',
    	prevSelector: '.slider_prev',
    	nextText: '<i class="xi-angle-right-thin"></i>',
    	prevText: '<i class="xi-angle-left-thin"></i>',
    	pagerSelector: '.pager_01'    
	});
	
	/*
	var stop_t = $("#new_nav").offset().top;	

	$(".m_quick").css({'top':stop_t+'px'});
	var quick_scroll = function() {
		var pos = $(window).scrollTop();
		if (pos > stop_t) 
			$(".m_quick").css({'position':'fixed','top':'10px'});
		else {
			$(".m_quick").css({'position':'absolute','top':stop_t+'px'});
		}
	}
	$(window).scroll(quick_scroll);
	*/
});
</script>
	

<script type="text/javascript">
$(function(){
	<?
		if ($g_uid)
		{
	?>
		scrollLink("top_<?=$g_uid?>",10);
		good.date_tab('<?=$g_uid?>','');
	<?}?>

	// 인기상품
	$(".pop_btn").bind({
		"mouseenter": function(e){
			
			$(this).addClass("on").siblings().removeClass("on");
			$(".pop_box").hide();
			$("#pop_box_"+$(this).attr("tab_num")).show();
		}
	});

	// 추천상품
	$(".tab_recom_bn li").bind("mouseenter",function(){
		var id = $(this).index();
		$(this).addClass("on").siblings("li").removeClass("on");
		$(".recom_bn_list").each(function(index){
			if(index==id) {
				$(this).show();
			}else{
				$(this).hide();
			}
		});
	});

	$("#location span").last().addClass("strong");

	$('.product_list ul li:nth-of-type(even)').addClass('bg_white'); 
	
	
});
	
function good_banner_mv(m){
	var num=0,ck_num;
	var b_cnt = $("#slide-controls li").length;
	
	if(b_cnt==0) return;

	b_cnt--;

	$("#slide-controls li").each(function(){
		if($(this).children("img").attr("src").indexOf("_on")>0) {
			num = $(this).index();
			if(m=='pre') {
				num--;
				if(num<0) ck_num=b_cnt;
				else ck_num=num;
			}else{
				num++;
				if(num>b_cnt) ck_num=0;
				else ck_num=num;
			}
		}
	});
	
	$("#slide-controls li").each(function(){
		if($(this).index()==ck_num) {
			$(this).children("img").trigger("mouseover")
														 .trigger("mouseout");
		}
	});
}
</script>


<? include "../include/footer.html"; ?>