<?
//========================================
// dehead(config/function/lib) Include
//========================================
include $_SERVER['DOCUMENT_ROOT']."/front/include/dehead.php";
function AuthCheck2($getSession,$contentnumber){
    if(!$getSession){
		//$utf8str = iconv("euc-kr", "utf-8", "../epilogue/real_view.php?no=".$contentnumber);
        AlertMove("로그인 후 이용하실 수 있습니다.", "/front/member/login.php?returnUrl=real_view&no=".$contentnumber);
    }
}

	
//}

//========================================
// Class Connect
//========================================
$Db = new Db(); // 데이터 베이스 클래스

//========================================
// Data Process
//========================================
$param = array('no' => $no);

//========================================
// Data Load
//========================================
$view = $Db->row("SELECT no, sort, best, store, insert_date, name, title, content, likes, hit, tag, etc1 FROM $TABLE_EPILOGUE WHERE no = :no", $param);
// $keyword = array_filter(explode("|", $Db->single("SELECT keyword2 FROM $TABLE_KEYWORD")));

$no = $view['no'];
$sort = $view['sort'];
$bestClass = ($view['best'] === "Y") ? "best" : "";
$store = $storeNameArr[$view['store']];
$storeColor = StoreColorClass($view['store']);
$insert_date = $view['insert_date'];
$name = Utf8SubstrReplace(stripslashes($view['name']), "o");
$title = stripslashes($view['title']);
$content = stripslashes($view['content']);
$likes = $view['likes'];
$hit = $view['hit'];
$temp_tag = explode(",", stripslashes($view['tag']));
$tag = implode(",", array_filter($temp_tag));

$etc1 = $view['etc1'];

$pnparam = array('sort' => $sort, 'show' => PARAMETER_Y, 'del' => PARAMETER_N, 'best' => $view['best']);
if($sd === "likes"){
    $pnparam['likes'] = $likes;
    $prevINS .= "likes > :likes";
    $nextINS .= "likes < :likes";
    $prevOrderINS .= "likes ASC";
    $nextOrderINS .= "likes DESC";
} else if($sd === "hit"){
    $pnparam['hit'] = $hit;
    $prevINS .= "hit > :hit";
    $nextINS .= "hit < :hit";
    $prevOrderINS .= "hit ASC";
    $nextOrderINS .= "hit DESC";
} else {
    $pnparam['insert_date'] = $insert_date;
    $prevINS .= "insert_date > :insert_date";
    $nextINS .= "insert_date < :insert_date";
    $prevOrderINS .= "insert_date ASC";
    $nextOrderINS .= "insert_date DESC";
}

$prev = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $prevINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $prevOrderINS LIMIT 0, 1", $pnparam);
$next = $Db->row("SELECT no, store, title FROM $TABLE_EPILOGUE WHERE $nextINS AND sort = :sort AND d_show = :show AND del = :del AND best = :best ORDER BY $nextOrderINS LIMIT 0, 1", $pnparam);

if($prev > 0){
    $prevTitle = "[".$storeNameArr[$prev['store']]."]".stripslashes($prev['title']);
    $prevLink = "#".$prev['no'];
} else {
    $prevTitle = "이전글이 없습니다.";
    $prevLink = "#self";
}

if($next > 0){
    $nextTitle = "[".$storeNameArr[$next['store']]."]".stripslashes($next['title']);
    $nextLink = "#".$next['no'];
} else {
    $nextTitle = "다음글이 없습니다.";
    $nextLink = "#self";
}

// if($_SERVER['REMOTE_ADDR'] == "112.222.190.202"){
//     debug($insert_date);
//     debug($pnparam);
// }

//========================================
// Hit Update
//========================================
if(!$_COOKIE["HIT::".$TABLE_EPILOGUE."_".$no]){
    $hitPlus = $hit + 1;

    $hitUp = $Db->query("UPDATE $TABLE_EPILOGUE SET hit = :hit WHERE no = :no", array('hit' => $hitPlus, 'no' => $no));

    setcookie("HIT::".$TABLE_EPILOGUE."_".$no, time()+(60*60*24));
}
$Db->CloseConnection;




//========================================
// 2019-11-13
//========================================	

$epirel = $Db->row("SELECT * FROM 2019_epilogue_relate WHERE del = 'N' AND real_view = '".$_GET['no']."'");

$beaf_param = array('show' => PARAMETER_Y, 'del' => PARAMETER_N);

if($epirel['self_view']){
$ep1 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'A' AND d_show = :show AND del = :del AND no = '".$epirel['self_view']."'", $beaf_param);
}
if($epirel['real_view']){
$ep2 = $Db->row("SELECT * FROM $TABLE_EPILOGUE WHERE sort = 'B' AND d_show = :show AND del = :del AND no = '".$epirel['real_view']."'", $beaf_param);
}


$beaf_param = array_merge($beaf_param, array('Bcode' => "photo", 'Ccode' => "photo", 'Bseq' => 1, 'Cseq' => 2));

if($epirel['beaf']){
$beaf = $Db->row("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date, A.etc1,
B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1, 
C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2
FROM $TABLE_PHOTO A 
LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq 
LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq 
WHERE A.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf']."", $beaf_param);
}
if($epirel['beaf2']){
$beaf2 = $Db->row("SELECT A.no, A.title, A.before_content, A.after_content, A.reg_date, A.etc1,
B.attach AS attach1, B.attach_ori AS attach_ori1, B.mod_date AS mod_date1, 
C.attach AS attach2, C.attach_ori AS attach_ori2, C.mod_date AS mod_date2
FROM $TABLE_PHOTO A 
LEFT JOIN $TABLE_ATTACH B ON A.no = B.wno AND B.code = :Bcode AND B.seq = :Bseq 
LEFT JOIN $TABLE_ATTACH C ON A.no = C.wno AND C.code = :Ccode AND C.seq = :Cseq 
WHERE A.d_show = :show AND A.del = :del AND A.no = ".$epirel['beaf2']."", $beaf_param);
}

$epirel_name = Utf8SubstrReplace(stripslashes($epirel['name']), "o");

preg_match_all("/<img[^>]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep1['content'], $matches);

preg_match_all("/<img[^>]*src=[\"']?([^>\"']+)[\"']?[^>]*>/i", $ep2['content'], $matches2);


//========================================
// Meta Tag
//========================================
$metaTitle = $title;
$metaTitle2 = $title;
$metaDescription = StrCut(strip_tags($content), 0, 100);
$metaKeyword = $tag;


$metaImg = explode('src=',$content);
$metaImg = explode('>',$metaImg[1]);
$metaImg = explode(' ',$metaImg[0]);
$metaImg = str_replace('"','',$metaImg[0]);
if(!preg_match('#ssdream.co.kr#',$metaImg)){
	$metaImg = "http://www.ssdream.co.kr".$metaImg;
}

//$path = "./img/";
//$dir = opendir($path);
$tmpno = "2210";
if($no == $tmpno){
	$metaImg = "http://www.ssdream.co.kr/front/epilogue/img/".$no.".jpg";
}


$metaImage = $metaImg;
$metaNav = $metaInfo['real_list_'.$sort]['nav'];

//========================================
// header Include
//========================================
include PATH_INCLUDE."header.php";

//========================================
// Page Auth
//========================================
//if(MobileCheck() == "Desktop"){
//  일단 없애봄 170703
// 2020-03-13 검색엔진은 통과시키기
// 2020-05-25 header까지는 나오게하기
if( preg_match('#Yeti#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#Googlebot#',$_SERVER['HTTP_USER_AGENT']) || preg_match('#GoogleDocs#',$_SERVER['HTTP_USER_AGENT']) ){
}else{
	//echo $_SERVER['HTTP_USER_AGENT'];
    AuthCheck2($_SESSION['MEMBER_LOGIN_EXIST'],$_GET['no']);
}

?>
        
<style>

#container .cont_box .mo{
	display:none;
}
#container .cont_box .pc{
	display:inline-block;
}

#iframeYT{
	width:1000px;
	display:block;
	margin:auto;
}

@media screen and (max-width:1620px){
	#container .cont_box .mo{
		display:none;
	}
	#container .cont_box .pc{
		display:inline-block;
	}
	#iframeYT{
		width:100%;
		max-width:1000px;
	}
}
@media screen and (max-width:640px){
	#container .cont_box .mo{
		display:inline-block;
	}
	#container .cont_box .pc{
		display:none;
	}
	#iframeYT{
		width:100%;
	}
}
.cont_box img{ max-width:100% !important; height:auto !important;}
.relate img {max-width:100%; min-width:100%; display:block; margin:auto;}
</style>
        <div id="container">
            <div class="sub_visual_wrap eq2">
                <div class="inner_box">
                    <div class="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>";
						?>
                        <!--span>수술후기</span> &nbsp;&gt;&nbsp;
                        <strong><?=($sort === "B") ? "리얼스토리" : "리얼셀카후기";?></strong-->
                    </div>
                    <h1 class="tit"><?=($sort === "B") ? "리얼스토리" : "리얼셀카후기";?></h1>
                    <p><?=($sort === "B") ? "수술의 전과정을 알고 싶다면?" : "내마음대로 찍어 생생한!";?><!--환자분이 자필로 직접 <span>알려주는 삼성드림이비인후과!--></span></p>
                </div>
            </div>

            <div id="contents" class="sub_epilogue">

                <div class="sep_view">
                    <div class="title_box">
                        <div class="outer_box best">
                            <div class="inner_box">
                                <span class="img_box">
                                    <span class="cover1"></span>
                                    <span class="count"><?=$likes?></span>
                                </span>
                                <strong class="txt_box">
                                    <span class="branch  <?=$storeColor?>"  style="background-size:242px 39px; width:242px !important;"><?=$store?> <?=($sort === "B") ? "리얼스토리" : "리얼셀카후기";?></span>
                                    <span class="name"><?=$title?></span>
                                </strong>
                                <span class="date_box">
                                    <span><em>작성자</em> <?=$name?></span>
                                    <span><em>등록일</em> <?=$insert_date?></span>
                                    <span><em>조회</em> <?=$hit?></span>
                                </span>
                            </div>
                        </div>
                    </div>
                    <div class="cont_box" style="z-index:10">
						<div style="margin:0px auto 0 auto; left:40%; width:20%; height:100px; position:absolute; z-index:-1; word-break:break-all; font-size:9px; line-height:10px;"><?=$etc1?></div>
						<div style="margin:0px auto 0 auto; left:40%; width:20%; height:100%; position:absolute; z-index:-1;background:#fff"></div>
                        <?=$content?>
                    </div>
                    <div class="like_box">
                        <span class="like_txt">이 후기가 도움이 됐나요?</span> <span id="likePlus" class="like_btn"><a href="#<?=$no?>"><?=$likes?></a></span>
                    </div>
					
					
					
					
					
					<style>
					.relate1_head{background:rgb(29,118,174); padding:10px; cursor:pointer; text-align:center; font-weight:bold; color:#fff; margin:10px 0;}
					.relate1{_background:#f0f0f0; _min-height:300px;}
					.relate2_head{background:rgb(255,192,0); padding:10px; cursor:pointer; text-align:center; font-weight:bold; color:#fff; margin:10px 0;}
					.relate2{_background:#f0f0f0; _min-height:300px;}
					.relate3_head{background:rgb(92,193,65); padding:10px; cursor:pointer; text-align:center; font-weight:bold; color:#fff; margin:10px 0;}
					.relate3{_background:#f0f0f0; _min-height:300px;}
					</style>
					
					<?
					if($epirel['youtube']){?>
					<div class="relate1_head relate_head" data-no="1"><?=$epirel_name?>님의 리얼후기영상 보기<br><img class="arr" src="<?=PATH_IMAGES?>/epilogue/arrow.png" /></div>
					<div class="relate relate1" data-height="10">
					<iframe id="iframeYT" style="width:100%;" src="https://www.youtube.com/embed/<?=$epirel['youtube']?>" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
					</div>
					<?}else{?>
					<div class="relate relate1" data-height="10"></div>
					<?}?>
					
					<?
					if($epirel['self_view']){?>
					<div class="relate2_head relate_head" data-no="2"><?=$epirel_name?>님의 자필후기 보기<br><img class="arr" src="<?=PATH_IMAGES?>/epilogue/arrow.png" /></div>
					<div class="relate relate2" data-height="20">
					<?php
					for($i=0; $i<count($matches[0]); $i++){?>
					<?=stripslashes($matches[0][$i])?>
					<?}?>
					
					<div style="text-align:center;padding:15px;"><a href="/front/epilogue/self_view.php?no=<?=$epirel['self_view']?>" target="_blank">자세히 보기</a></div>
					</div>
					<?}else{?>
					<div class="relate relate2" data-height="20"></div>
					<?}?>
					
					<?
					if($epirel['beaf'] || $epirel['beaf2']){?>
					<div class="relate3_head relate_head" data-no="3"><?=$epirel_name?>님의 전후사진 보기<br><img class="arr" src="<?=PATH_IMAGES?>/epilogue/arrow.png" /></div>
					<div class="relate relate3" data-height="30">
						<div class="nbeaf_list">
							<ul>
								<?
								if($epirel['beaf']){?>
								<li>
									<div class="before_area">
										<div class="img_box">
											<img src='<?=$pathInfo['photo']['file'].DateConv($beaf['mod_date1'], 3)?>/<?=$beaf['attach1']?>'>
										</div>
										<div class="exp_box"><!-- 컨텐츠가 없으면 이영역 전체를 삭제해주세요. --> 
										<?=$beaf['before_content']?></div>
									</div>
									<div class="infor_area">
										<h4 class="tit"></h4>
										<img src="/front/images/nbeaf/ico_arrow1.png" alt="코성형 전후사진">
										<strong><?//=$beaf['no']?></strong>
										<span>a<?=DateConv($beaf['reg_date'], 7);?>a<?=$beaf['reg_date']?>a</span><p style="_text-align:center; _margin-top:-20px;">수술후 3개월</p>
									</div>
									<div class="after_area">
										<div class="img_box">
											<img src='<?=$pathInfo['photo']['file'].DateConv($beaf['mod_date1'], 3)?>/<?=$beaf['attach2']?>'>
										</div>
										<div class="exp_box"><!-- 컨텐츠가 없으면 이영역 전체를 삭제해주세요. -->
										<?=$beaf['after_content']?>
										</div>
									</div>
								</li>
								<?}?>
								<?
								if($epirel['beaf2']){?>
								<li>
									<div class="before_area">
										<div class="img_box">
											<img src='<?=$pathInfo['photo']['file'].DateConv($beaf2['mod_date1'], 3)?>/<?=$beaf2['attach1']?>'>
										</div>
										<div class="exp_box"><!-- 컨텐츠가 없으면 이영역 전체를 삭제해주세요. --> 
										<?=$beaf2['before_content']?></div>
									</div>
									<div class="infor_area">
										<h4 class="tit"></h4>
										<img src="/front/images/nbeaf/ico_arrow1.png" alt="코성형 전후사진">
										<strong><?//=$beaf2['no']?></strong>
										<span>a<?=DateConv($beaf2['reg_date'], 7);?>a<?=$beaf2['reg_date']?>a</span><p style="_text-align:center; _margin-top:-20px;">수술후 3개월</p>
									</div>
									<div class="after_area">
										<div class="img_box">
											<img src='<?=$pathInfo['photo']['file'].DateConv($beaf2['mod_date1'], 3)?>/<?=$beaf2['attach2']?>'>
										</div>
										<div class="exp_box"><!-- 컨텐츠가 없으면 이영역 전체를 삭제해주세요. -->
										<?=$beaf2['after_content']?>
										</div>
									</div>
								</li>
								<?}?>
							</ul>
						</div>
					</div>
					<?}else{?>
					<div class="relate relate3" data-height="30"></div>
					<?}?>
					
					<script type="text/javascript" src="https://cdn.sobekrepository.org/includes/jquery-rotate/2.2/jquery-rotate.min.js"></script>
					<script>
					$(function(){
						$('.relate_head').click(function(){
							$('html,body').animate({scrollTop : $(this).offset().top - 50 });
							console.log($('.relate'+$(this).data('no'))[0].offsetHeight);
							$('.relate'+$(this).data('no')).slideToggle('1000');
							
							//$(this).find('.arr').rotate('180');
							//console.log($(this).find('.arr').css('transform'));
							/*if ( $(this).find('.arr').css('transform') == 'rotate(180deg)'){
								$(this).find('.arr').css('transform','rotate(0deg)');
							}else{
								$(this).find('.arr').css('transform','rotate(180deg)');
							}*/
						});
						
						//$('.relate').data('height',$(this).offsetHeight);
						console.log($('.relate').data('height'));
						$('.relate').data('height','30');
						//console.log($('.relate').);
						
						
						setTimeout(function(){
							$('.relate').hide();
						},1000);
						
					});
					</script>
					
					
					
					
					
                    <div id="moveView" class="prev_next_wrap" style="display:none;">
                        <span class="prev"><strong>이전 글</strong><a href="<?=$prevLink?>"><?=$prevTitle?></a></span>
                        <span class="next"><strong>다음 글</strong><a href="<?=$nextLink?>"><?=$nextTitle?></a></span>
                    </div>
                </div>

                <div id="moveList" class="btn_area" style="display:none;">
                    <a href="#self" class="btn1">LIST</a>
                </div>       
            </div>
        </div><!-- end : container -->

    <form id="naviFrm">
    <input type="hidden" id="sort" name="sort" value="<?=$sort?>" />
    <input type="hidden" id="no" name="no" value="" />
    <input type="hidden" id="page" name="page" value="<?=$page?>" />
    <input type="hidden" id="sd" name="sd" value="<?=$sd?>" />
    <input type="hidden" id="st" name="st" value="<?=$st?>" />
    <input type="hidden" id="sf" name="sf" value="<?=$sf?>" />
    <input type="hidden" id="sk" name="sk" value="<?=$sk?>" />
    <input type="hidden" id="sb" name="sb" value="<?=$sb?>" />
    </form>

<script>
$(document).ready(function(){
    $("#moveView span > a").click(function(){
        $("#no").val($(this).attr("href").replace("#", ""));
        $("#naviFrm").attr('action', 'real_view.php#contents').submit();
    });

    $("#moveList > a").click(function(){
        $("#naviFrm").attr('action', 'real_list.php#contents').submit();
    });

    $("#likePlus > a").click(function(){
        LikePlus.Action('epilogue', $(this).attr("href").replace("#", ""));
    });
});
</script>

<script>
$(function(){
	var video = $('#iframeYT');
	var aspectRatio = 0.562;
	$(window).resize(function(){
		resizeVideo();
		
		
	});
	var resizeVideo = function(){
		var videoWidth = video.outerWidth();
		var newHeight = videoWidth*aspectRatio;
		video.css({"height":newHeight+"px"});
	}
	resizeVideo();
});
</script>

<?php
//echo PATH."/epilogue";
//========================================
// seo Include
//========================================
include_once "real_list_mod.php";
?>

<?
//========================================
// quick bar Include
//========================================
include PATH_INCLUDE."quick.php";

//========================================
// footer Include
//========================================
include PATH_INCLUDE."footer.php";
?>