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

//========================================
// Meta Tag
//========================================
$metaAdd = ($sc) ? "self_list_".$sc : "self_list";
$metaTitle = $metaInfo[$metaAdd]['title'];
$metaDescription = $metaInfo[$metaAdd]['description'];
$metaKeyword = $metaInfo[$metaAdd]['keyword'];
$metaImage = $metaInfo[$metaAdd]['image'];

//========================================
// Naver Auth
//========================================
$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              // 인증 후에 네이버 로그아웃 버튼 표시/ 또는 표시안함
    )
);

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

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

//========================================
// Search Query
//========================================
if($sc){
    $param['category1'] = $sc;
    $param['category2'] = $Db->likeify($categoryArr[$sc]);
    $searchINS .= " AND (category = :category1 OR tag LIKE :category2)";
}

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)
        ));
    }
    $searchINS .= ($sf) ? " AND $sf LIKE :keyword" : " AND (title LIKE :keyword_title AND content LIKE :keyword_content)";
}

if($st){
    $param['tag'] = $Db->likeify($st);
    $searchINS .= " AND tag LIKE :tag";
}

if($sb){
    $param['best'] = $sb;
    $searchINS .= " AND best = :best";
}

//20170530 임의묶음용 sct변수 추가
if($sct){
    if($sct == 1){
        $searchINS .= ' AND (no = 2417 OR no = 2431 OR no = 2369 OR no = 2424)';

    }else if($sct == 2){
        $searchINS .= ' AND (no = 2451 OR no = 1694 OR no = 1489)';

    }else if($sct == 3){
        $searchINS .= ' AND (no = 875 OR no = 2260 OR no = 2342)';

    }
}


$orderINS .= ($sd) ? "$sd DESC" : "insert_date DESC";
$addPath = "&sc=$sc&sd=$sd&st=$st&sf=$sf&sk=$sk&sb=$sb";

//========================================
// Data Load
//========================================
//20170530 sct적용시 베스트 없애기위해 조건추가
if(!$sct){

	if($sb == "" || $sb == "N"){
    	$bestParam = array_merge($param, array('best' => PARAMETER_Y));
	    $best = $Db->query("SELECT no, store, insert_date, name, title, content, hit FROM $TABLE_EPILOGUE WHERE no > :no AND d_show = :show AND del = :del AND sort = :sort AND best = :best $searchINS ORDER BY insert_date DESC LIMIT 5", $bestParam);

    	foreach ($best as $key => $val){
        	$strTmp .= $val['no'].",";
	    }
	    $noStr = ($best) ? "AND no NOT IN (".substr($strTmp, 0, -1).")" : "";
	} else {
	    $noStr = "";
	}
}else{
	$best = array();
}

$totalCount = $Db->single("SELECT COUNT(*) FROM $TABLE_EPILOGUE WHERE no > :no AND d_show = :show AND del = :del AND sort = :sort $noStr $searchINS", $param);
$totalPages = ceil($totalCount / $rowCount);

$param = array_merge($param, array('startNum' => $startNum, 'rowCount' => $rowCount));
$list = $Db->query("SELECT no, best, store, insert_date, name, title, content, hit FROM $TABLE_EPILOGUE WHERE no > :no AND d_show = :show AND del = :del AND sort = :sort $noStr $searchINS ORDER BY $orderINS LIMIT :startNum, :rowCount", $param);

$keyword = explode("|", $Db->single("SELECT keyword FROM $TABLE_KEYWORD WHERE code = :code", array('code' => "B")));
$Db->CloseConnection;

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

//========================================
// header Include
//========================================
include PATH_INCLUDE."header.php";
?>
        
        <div id="container">
            <div class="sub_visual_wrap eq1">
                <div class="inner_box">
                    <div class="location">
                        <a href="/"><img src="<?=PATH_IMAGES?>/common/ico_home.png" alt="HOME" /></a> &nbsp;&gt;&nbsp;
                        <span>수술후기</span> &nbsp;&gt;&nbsp;
                        <strong>수술자필후기</strong>
                    </div>
                    <h3 class="tit">수술자필후기</h3>
                    <p>환자분이 자필로 직접 <span>알려주는 삼성드림이비인후과!</span></p>
                </div>
            </div>
            <div id="contents" class="sub_epilogue">
                <div class="sep_tab_box1">
                    <div class="tab_style1 two">
                        <ul id="moveList">
                            <li <? if(!$sb) echo "class=\"on\""; ?>><a href="<?=($sb) ? "#sb=" : "#self";?>">전체보기</a></li>
                            <li <? if($sb === "Y") echo "class=\"on\""; ?>><a href="<?=($sb) ? "#self" : "#sb=Y";?>" style="display:none;">베스트 모아보기</a></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="sep_counter">
                    <span class="number">
                        <? foreach ($countCut as $key => $val){ ?>
                        <em><?=$val?></em>
                        <? } ?>
                    </span>
                    <strong>개의</strong>
                     수/술/자/필/후/기가 있습니다.
                </div>

                <div class="sep_tab_box1">
                    <div class="sep_tab">
                        <h3 class="tit"><a href="#self">비중격만곡증</a></h3>
                        <ul id="moveList">
                            <li <? if(!$sc) echo "class=\"on\""; ?>><a href="#sc=">전체보기</a></li>
                            <li <? if($sc === "A") echo "class=\"on\""; ?>><a href="#sc=A">비중격만곡증</a></li>
                            <li <? if($sc === "B") echo "class=\"on\""; ?>><a href="#sc=B">비염</a></li>
                            <li <? if($sc === "C") echo "class=\"on\""; ?>><a href="#sc=C">축농증</a></li>
                            <li <? if($sc === "D") echo "class=\"on\""; ?>><a href="#sc=D">코성형</a></li>
                            <li <? if($sc === "E") echo "class=\"on\""; ?>><a href="#sc=E">코뼈골절</a></li>
                        </ul>
                    </div>
                    <ul id="moveList" class="sep_orderby">
                        <li <? if(!$sd) echo "class=\"on\""; ?>><a href="#sd=">최신순</a></li>
                        <li <? if($sd === "likes") echo "class=\"on\""; ?>><a href="#sd=likes">추천순</a></li>
                        <li <? if($sd === "hit") echo "class=\"on\""; ?>><a href="#sd=hit">조회순</a></li>
                    </ul>
                </div>
                
                <div class="sep_list">
                    <ul id="moveView">
                    <?
                    if($sb == "" || $sb == "N"){
                        foreach ($best as $key => $val){
                            $no = $val['no'];
                            $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 = (is_file($_SERVER['DOCUMENT_ROOT'].$contImg['1'])) ? $contImg['1'] : PATH_IMAGES."/epilogue/exp1.jpg";
                            $hit = $val['hit'];
                            $insert_date = DateConv($val['insert_date'], 7);
                    ?>
                        <li class="best">
                            <a href="#<?=$no?>">
                                <span class="img_box">
                                    <img src="<?=$imgPath?>" alt="문서" />
                                    <span class="cover"></span>
                                    <span class="best">BEST</span>
                                </span>
                                <strong class="txt_box">
                                    <span class="branch <?=$storeColor?>"><?=$store?> 자필후기</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>
                            </a>
                        </li>
                    <?
                        }
                    }

                    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 = (is_file($_SERVER['DOCUMENT_ROOT'].$contImg['1'])) ? $contImg['1'] : PATH_IMAGES."/epilogue/exp1.jpg";
                            $hit = $val['hit'];
                            $insert_date = DateConv($val['insert_date'], 7);
                    ?>
                        <li class="<?=$best?>">
                            <a href="#<?=$no?>">
                                <span class="img_box">
                                    <img src="<?=$imgPath?>" alt="문서" />
                                    <span class="cover"></span>
                                    <span class="best">BEST</span>
                                </span>
                                <strong class="txt_box">
                                    <span class="branch <?=$storeColor?>"><?=$store?> 자필후기</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>
                            </a>
                        </li>
                    <?
                        }
                    }
                    ?>
                    </ul>
                </div>

                <div class="pagination_wrap">
                    <? if($totalPages > 0) Pageing($totalPages, $blockCount, $page, $addPath); ?>
                </div>
				
				<?
				//if(bip=='Y'){
					include(PATH_INCLUDE."/b_navertalk.php");
				//}?>
				
            </div>

            <div class="seq_collect_wrap">
                <h3 class="tit">수술후기 모아보기</h3>
                <div class="inner_box">
                    <ul id="moveList">
                    <? 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.php">
                        <input type="hidden" id="rurl" name="rurl" 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">
                        <?=$naver->login('self_list')?>
                        <!-- <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">삼성드림 회원가입</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>

<script>
$(document).ready(function(){
    $("#moveView li > a").click(function(){
        if("<?=$_SESSION['MEMBER_LOGIN_EXIST']?>" == true || $.browser.mobile){
            $("#no").val($(this).attr("href").replace("#", ""));
            $("#searchFrm").attr('action', 'self_view.php').submit();
        } else {
            var url = "/front/epilogue/self_view.php?no="+$(this).attr("href").replace("#", "")+"&page=<?=$page?>&sc=<?=$sc?>&sd=<?=$sb?>&st=<?=$st?>&sf=<?=$sf?>&sk=<?=$sk?>&sb=<?=$sb?>";

            $("#rurl").val(url);
            UI.layerPopup('#login_layerpopup','open');
        }
    });

    $("#moveList li > a").click(function(){
        var val = $(this).attr("href").replace("#", "").split("=");
        $("#"+val[0]).val(val[1]);
        if(val[0] == "st" || val[0] == "sc"){
            $("#page").val(1);
        }
        $("#searchFrm").attr('action', 'self_list.php#contents').submit();
    });
});
</script>

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

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