<?
//========================================
// dehead(config/function/lib) Include
//========================================
include $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php";

//========================================
// Meta Tag
//========================================
$metaAdd = "sstv";
$metaTitle = $metaInfo[$metaAdd]['title'];
$metaDescription = $metaInfo[$metaAdd]['description'];
$metaKeyword = $metaInfo[$metaAdd]['keyword'];
$metaImage = $metaInfo[$metaAdd]['image'];
$metaNav = $metaInfo[$metaAdd]['nav'];

$gogoUrl='sstv_list'; //구글과 카카오를 위한 (로그인 후 넘어가는 페이지)

//========================================
// Class Connect
//========================================
$Db = new Db(); // 데이터 베이스 클래스

//========================================
// Data Process
//========================================
$rowCount = $pageInfo['sstv']['rowCount']; // 한 페이지에 보여질 게시물 수
$startNum = ($page - 1) * $rowCount; // limit 시작 위치
$param = array('no' => PARAMETER_NO, 'show' => PARAMETER_Y, 'del' => PARAMETER_N);


//========================================
// Search Query
//========================================

$addPath = "&sc=$sc&sd=$sd&st=$st&sf=$sf&sk=$sk&sb=$sb";
$orderINS = "reg_date DESC, no DESC";
//========================================
// Data Load
//========================================
$tags = $Db->query("SELECT distinct(tag) FROM $TABLE_SSTV WHERE tag != '' AND no > :no AND d_show = :show AND del = :del ", $param);
$i = 0;
foreach($tags as $key => $val){
	$keyword_explode = explode(',',$val['tag']);
	foreach($keyword_explode as $v){
		if($v){
			$keyword[$i] = $v;
			$i++;
		}
	}
	
}
//$keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "I")));

$nTagArr=array('홍보','홍보영상');//홍보영상 태그들
$mTagArr=array('후기','후기영상');//후기영상 태그들

if($sk){
    if($sf){
        $param['keyword'] = $Db->likeify($sk);
    } else {
        $param = array_merge($param, array(
            'keyword_title' => $Db->likeify($sk),
            'keyword_content' => $Db->likeify($sk),
			'keyword_tag' => $Db->likeify($sk),
        ));
    }
    $searchINS .= ($sf) ? " AND $sf LIKE :keyword" : " AND (title LIKE :keyword_title OR content LIKE :keyword_content OR tag LIKE :keyword_tag)";
}

if($st){
	if($st=='N'){ 
		
		//코질환 태그 
		for($nt=0; $nt<count($nTagArr); $nt++){
			$value = $Db->likeify($nTagArr[$nt]);
			if($nt==0){
				$searchINS .= " AND (";
			}else{
				$searchINS .= " OR ";
			}
			$searchINS .= "tag LIKE '%".$value."%'";

			if($nt==(count($nTagArr)-1)){
				$searchINS .= ")";
			}
		}
		//코성형 태그 빼기
		for($mt=0; $mt<count($mTagArr); $mt++){
			$value = $Db->likeify($mTagArr[$mt]);
			if($mt==0){
				$searchINS .= " AND (";
			}else{
				$searchINS .= " AND ";
			}
			$searchINS .= "tag NOT LIKE '%".$value."%'";
			if($mt==(count($mTagArr)-1)){
				$searchINS .= ")";
			}
		}
	
	}else if($st=='M'){
	
		//코성형 태그하나라도 있을시에!
		for($mt=0; $mt<count($mTagArr); $mt++){
			$value =$Db->likeify($mTagArr[$mt]);
			if($mt==0){
				$searchINS .= " AND (";
			}else{
				$searchINS .= " OR ";
			}
			$searchINS .= "tag LIKE '%".$value."%'";
			if($mt==(count($mTagArr)-1)){
				$searchINS .= ")";
			}
		}
	}else{
		$param['tag'] = $Db->likeify($st);
		$searchINS .= " AND tag LIKE :tag";
	}
}


$totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_SSTV WHERE no > :no AND d_show = :show AND del = :del $searchINS", $param);
$totalPages = ceil($totalCount / $rowCount);
 
$param = array_merge($param, array('startNum' => $startNum, 'rowCount' => $rowCount));
$list = $Db->query("SELECT no, best, store, title, content, hit, youtube, likes, tag FROM $TABLE_SSTV WHERE no > :no AND d_show = :show AND del = :del $searchINS ORDER BY $orderINS LIMIT :startNum, :rowCount", $param);

$Db->CloseConnection;

for($i=0; $i<4; $i++){
    $countCut[$i] = mb_substr(sprintf("%04d", $totalCount), $i, 1);
}

//========================================
// header Include
//========================================
include PATH_INCLUDE."header.php";


//========================================
// SNS Auth
//========================================
require PATH_LIB."naverLogin.php";
require PATH_LIB."kakaoLogin2.php";
require PATH_LIB."googleLogin.php";
require PATH_LIB."facebookLogin.php";

$gogoUrl='sstv_list';

$naver = new Naver(array(
    "CLIENT_ID" => NAVER_LOGIN_ID,        // (*필수)클라이언트 ID  
    "CLIENT_SECRET" => NAVER_LOGIN_SECRET,    // (*필수)클라이언트 시크릿
    "RETURN_URL" => NAVER_LOGIN_REDIRECT_URL,      // (*필수)콜백 URL
    "AUTO_CLOSE" => true,              // 인증 완료후 팝업 자동으로 닫힘 여부 설정 (추가 정보 기재등 추가행동 필요시 false 설정 후 추가)
    "SHOW_LOGOUT" => false              // 인증 후에 네이버 로그아웃 버튼 표시/ 또는 표시안함
    )
);
$kakao = new Kakao(array(
	"Rcode" => $returnCode,
    "CLIENT_ID" => KAKAO_CLIENT_ID,        // (*필수)클라이언트 ID  
    "RETURN_URL" => KAKAO_CALLBACK_URL,
    "AUTO_CLOSE" => true,              // 인증 완료후 팝업 자동으로 닫힘 여부 설정 (추가 정보 기재등 추가행동 필요시 false 설정 후 추가)
    "SHOW_LOGOUT" => false              // 인증 후에 네이버 로그아웃 버튼 표시/ 또는 표시안함
    )
);
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/waypoints/4.0.1/jquery.waypoints.min.js"></script>
<script src="/front/landing/js/jquery.countup.js"></script>
<script src="/front/landing/js/jquery.counterup.min.js"></script>

<style>
.photo img{
	width:388px;
}
.cover{
	_display:none;
}
.gallery_list ul li a .cover img{
	width:50px;
	height:50px;
	display:block;
	margin-left:169px;
	margin-top:120px;
}
.gallery_list ul li a .txt_box .name{
	font-size:16px;
}
@media screen and (max-width:1620px){
	.gallery_list ul li a .cover img{
		margin-left:215px;
		margin-top:155px;
	}
	.gallery_list ul li a .txt_box .name{
		max-width:440px;
		_line-height:46px;
	}
}
ceen and (max-width:640px){
	.gallery_list ul li a .cover img{
		margin:auto;
		margin-top:14vw;
		width:6vw;
		height:6vw;
	}
	.gallery_list ul li a .txt_box .name{
		
		font-size:11px;
	}
}
</style>
        <div id="container">
		
            <div id="contents" class="sub_epilogue">
                <div class="sub_location">
                    <a href="/"><img src="<?=PATH_IMAGES?>/common/ico_home.png" alt="HOME" /></a> &nbsp;&gt;&nbsp;
                    <?php
					if($metaNav[4]){ echo "<span>".$metaNav[4]."</span> &nbsp;&gt;&nbsp;"; }
					if($metaNav[3]){ echo "<span>".$metaNav[3]."</span> &nbsp;&gt;&nbsp;"; }
					if($metaNav[2]){ echo "<span>".$metaNav[2]."</span> &nbsp;&gt;&nbsp;"; }
					if($metaNav[1]){ echo "<span>".$metaNav[1]."</span> &nbsp;&gt;&nbsp;"; }
					echo "<strong>".$metaNav[0]."</strong>";
					?>
                </div>
            
			
                <div class="sep_tab_box1">
                    <div class="tab_style1 two">
                        <ul id="moveList">
                            <!--li <? if(!$sc and !$st) echo "class=\"on\""; ?> Style="float:left;width:15%;min-width:95px;">
								<a href="#sc=#sd=#st=#sf=#sk=#sb="  Style="">삼성드림TV</a-->
							<li <? if(!$sb && !$st) echo "class=\"on\""; ?> Style="float:left;width:15%;min-width:95px;"><a href="#st=">삼성드림TV</a></li><?/*<?=$typeALink ?>*/?>
							<li <? if($st=='N') echo "class=\"on\""; ?> Style="float:left;width:15%;min-width:95px;"><a href="#st=N">홍보영상</a></li>
							<li <? if($st=='M') echo "class=\"on\""; ?> Style="float:left;width:15%;min-width:95px;"><a href="#st=M">후기영상</a></li>							
							<!--/li-->
			            </ul>
                    </div>
                    <div class="search_box_se">
                        <form id="searchFrm" method="GET" action="#contents">
                        <input type="hidden" id="no" name="no" value="" />
                        <input type="hidden" id="page" name="page" value="<?=$page?>" />
                        <input type="hidden" id="sc" name="sc" value="<?=$sc?>" />
                        <input type="hidden" id="sd" name="sd" value="<?=$sd?>" />
                        <input type="hidden" id="st" name="st" value="<?=$st//=urlencode($st)?>" />
                        <select id="sf" name="sf" title="검색">
                            <option value="" selected="selected">전체</option>
                            <option value="title" <? if($sf == 'title') echo "selected=\"selected\""; ?>>제목</option>
                            <option value="content" <? if($sf == 'content') echo "selected=\"selected\""; ?>>내용</option>
                        </select>
                        <input type="text" id="sk" name="sk" value="<?=$sk?>" />
                        <input type="hidden" id="sb" name="sb" value="<?=$sb?>" />
                        <input type="submit" value="검색" />
                        </form>
                    </div>
                </div>


                <div class="gallery_list">
                    <ul id="moveView">
                    <?

                    if($totalCount > 0){
                        foreach($list as $key => $val){
                            $no = $val['no'];
                            $best = ($val['best'] === "Y" && $sb === "Y") ? "best" : "";
                            $store = $storeNameArr[$val['store']];
                            $storeColor = StoreColorClass($val['store']);
                            $name = Utf8SubstrReplace(stripslashes($val['name']), "o");
                            $title = stripslashes($val['title']);
                            $content = stripslashes($val['content']);
                            preg_match("/<img[^>]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $content, $contImg);
							$imgPath = "https://i.ytimg.com/vi/".$val['youtube']."/hqdefault.jpg";
							$likes = $val['likes'];
                            $hit = $val['hit'];
                            $insert_date = DateConv($val['insert_date'], 7);
							$tag = $val['tag'];
							$tag_arr = explode(',',$tag);
							$mTagMatch = 0;
							foreach($tag_arr as $kw){
								if(in_array($kw, $mTagArr)){
									$mTagMatch = 1;
								}
							}
                    ?>
                        <li class="<?=$bestClass?>">
                            <a href="#<?=$no?>" data-mtag="<?=$mTagMatch?>">
                                <span class="photo"><img src="<?=$imgPath?>" alt="" /></span>
								
                                <span class="cover"><img src="<?=PATH_IMAGES?>/common/video_play2.png" alt="" /></span>
								
								<span class="txt_box" style="bottom:0px;">
									
									<span class="name"><?=$title?></span>
									
                                </span>
								
                                <span class="best"><img src="<?=PATH_IMAGES?>/epilogue/ico_best.png" alt="BEST" /></span>
                            </a>
                        </li>
                    <?
                        }
                    }
                    ?>
                    </ul>
                </div>

                <div class="pagination_wrap">
                    <? if($totalPages > 0) Pageing($totalPages, $blockCount, $page, $addPath); ?>
                </div>
			</div>
			<div class="seq_collect_wrap">
				<h3 class="tit">삼성드림TV 모아보기</h3>
				<div class="inner_box">
					<ul id="moveList">
					<? if($keyword){foreach ($keyword as $key => $val){ ?>
						<li><a href="#st=<?=$val?>"><?=$val?></a></li>
					<? } 	}?>
					</ul>
				</div>
			</div>
			
			
        </div><!-- end : container -->

		<div class="login_layerpopup" id="login_layerpopup">
            <div class="back" onclick="UI.layerPopup('#login_layerpopup','close')"></div>
            <div class="inner_box">
                <div class="layer_top">
                    <h2 class="tit">로그인</h2>
                </div>
                <div class="layer_conts">
                    <div class="login_box">
                        <form name="loginFrm" method="POST" action="<?=PATH?>/member/login_proc_ssdream.php">
                        <input type="hidden" id="rurl" name="rurl" value="" />
						<input type="hidden" id="login_chk" value="">
                            <div class="input_box">
                                <label for="mId">아이디</label>
                                <input type="text" id="mId" name="mId" />
                            </div>
                            <div class="input_box">
                                <label for="mPw">비밀번호</label>
                                <input type="password" id="mPw" name="mPw" />
                            </div>
                            <div class="id_pass_chk">
                                <a href="#self">· 아이디/비밀번호 찾기</a>
                            </div>
                            <input type="submit" class="submit" value="확인" />
                        </form>
                    </div>
                    <div class="btn_box" Style="padding-top:20px;">
						<p Style="text-align:center;padding-bottom:10px;">SNS 계정으로 간편하게 회원가입/로그인하세요.<br />탈퇴가 자유로우니 부담 갖지 마세요.</p>
                        <?php 
						    //$naver->login('real_list')
						?>
						<a href="#self" id="naverLogin" class="btn_green" onclick="Naver.openWindow('https://nid.naver.com/oauth2.0/authorize?client_id=vORamOrcdMDLtQSN4vHN&amp;response_type=code&amp;redirect_uri=http%3A%2F%2Fwww.ssdream.co.kr%2Ffront%2Fmember%2Flogin_proc.php&amp;state=6f4804a7e337aedb7cb815a458c95b1f', 'oAuth', 'sstv_list')" style="background-image:url(/uploads/sns4.png); background-repeat:no-repeat;background-position:2% 50%;">네이버 계정으로 로그인</a>

						<?php
						    //$kakao->login('real_list')
						?>
						<a href="#self" class="kakaoAlink" onclick="Kakao.openWindow('https://kauth.kakao.com/oauth/authorize?client_id=c86cf4caf552bb1c3c9294ba597b2e42&amp;response_type=code&amp;scope=account_email&amp;redirect_uri=http%3A%2F%2Fwww.ssdream.co.kr%2Ffront%2Fmember%2Flogin_proc2.php&amp;state=76172d14be8e0d30bdc7802ec9cf33f2', '카카오 계정으로 로그인', 'sstv_list')" style="color:#000;  background-image:url(/uploads/sns2.png); background-repeat:no-repeat;background-position:2% 50%;">카카오계정 로그인</a>

						<a href="javascript:facebooklogin();" class="btn_green btn_facebook" Style="background-color:#3B5999; background-image:url(/uploads/sns1.png); background-repeat:no-repeat; margin-right:10px; ">페이스북 로그인</a>
						<button id="ggloginBtn" Class="googleLoginBtn" Style="background-image:url(/uploads/sns3.png); background-repeat:no-repeat;background-position:2% 50%; " disabled>구글 로그인</button>
						<input type="hidden" id="afterUrl" value="<?php echo $gogoUrl; ?>">

                        <!-- <a href="#self" class="btn_navers">네이버 계정으로 로그인</a> -->
                        <!-- <a href="#self" id="naverLogin" class="btn_navers" onclick="Naver.openWindow('../member/naverLogin.php', 'naverLoginApi', '')">네이버 계정으로 로그인</a> -->
                        <a href="<?=PATH?>/member/join1.php" class="btn_joins" Style="margin-left:0; background-image:url(/uploads/sns5.png); background-repeat:no-repeat;background-position:2% 50%;">삼성드림 회원가입</a>
                    </div>
                </div>
                <a href="javascript:UI.layerPopup('#login_layerpopup','close')" class="close"><img src="<?=PATH_IMAGES?>/common/btn_layer_close.png" alt="창닫기" /></a>
            </div>
        </div>
<style>

.googleLoginBtn, .kakaoAlink{margin-bottom: 20px; display:block; width: 100%; height: 58px; text-align:center; border: solid 0px #fff; color:#fff; font-size:24px; line-height:58px;}
.googleLoginBtn{background-color:#E84C3D;color:#fefefe;border:0; cursor:pointer;}
.kakaoAlink{background-color:#F8EA01;}
.btn_green{margin-bottom: 10px;}

.btn_facebook {background-size:45px; background-position:1% 20%;  }

@media screen and (max-width: 640px){
	.googleLoginBtn, .kakaoAlink{
		margin-bottom: 10px; height: 35px; font-size:15px; line-height:35px; background-size:30px;
	}
	.btn_facebook{
		background-position:0% 20%;
	}
}


</style>


<script>
$(document).ready(function(){
    /*$("#moveView li > a").click(function(){
        $("#no").val($(this).attr("href").replace("#", ""));
            $("#searchFrm").attr('action', 'sstv_view.php').submit();
        
    });*/
	
	$("#moveView li > a").click(function(){
		var mTag = $(this).data('mtag');
		
		$("#no").val($(this).attr("href").replace("#", ""));
		
		if(mTag == 1){	//후기영상일 경우
			if("<?=$_SESSION['MEMBER_LOGIN_EXIST']?>" == true){// || $.browser.mobile){
				
				$("#searchFrm").attr('action', 'sstv_view.php').submit();
			} else {
				var url = "/front/introduction/sstv_view.php?no="+$(this).attr("href").replace("#", "")+"&page=<?=$page?>&sd=<?=$sb?>&st=<?=$st?>&sf=<?=$sf?>&sk=<?=$sk?>&sb=<?=$sb?>";

				$("#rurl").val(url);

				UI.layerPopup('#login_layerpopup','open');
			}
		}else if(mTag == 0){	//일반영상일 경우
			$("#searchFrm").attr('action', 'sstv_view.php').submit();
		}
    });


    $("#moveList li > a").click(function(){
        var href = $(this).attr("href").split("#");
		$.each(href, function(index,value){
			var val = value.split("=");
			if(val[0] != ""){
		        $("#"+val[0]).val(val[1]);
			}
			if(val[0] == "st" || val[0] == "sc"){
				$("#page").val(1);
			}
		});

        $("#searchFrm").attr('action', 'sstv_list.php#contents').submit();
    });
	
	
	Kakao = {
		openWindow: function(url, winName, returnUrl){
			var win = window.open(url, winName, 'width=320, height=480, toolbar=no, location=no');
			if(win != null){
				var timer = setInterval(function() {   
					var login_chk = document.getElementById('login_chk').value;
					if(win.closed && login_chk == 'true') {
						
						if(returnUrl == "index"){
							location.href = '/';
						}
						else if(returnUrl == "sstv_list"){
							$("#searchFrm").attr('action', 'sstv_view.php').submit();
						}else{
							window.location.reload();
						}
					}  
				}, 500);
			}
			return win;
		}
	}
	
});
</script>

<?
//========================================
// quick bar Include
//========================================
include PATH_INCLUDE."quick.php";

//========================================
// footer Include
//========================================
include PATH_INCLUDE."footer.php";
?>