<?
require_once dirname(__FILE__)."/../_header.php";
require_once dirname(__FILE__).'/../include/util.php';

if (isset($_GET['no'])) {
	$restaurant = findRestaurant($_GET['no']);
	
	if (empty($restaurant)) {
		notFoundError();
		exit;
	}
	
	$snsMeta = array(
		'facebook' => getFacebookMeta($restaurant['subject'], '', $restaurant['image'])
	);
	
	setPlusHit($restaurant['no']);
	
	$tagRestaurants = findRestaurantByTags($restaurant['no'], $restaurant['tag'], $restaurant['section']);

	require_once dirname(__FILE__)."/../include/top.php";
	
	$banner = noblesseBanner('banner_home', 'p', '301', 1);
} else {
	notFoundError();
	exit;
}

function findRestaurant($no) {
	global $db, $homeRootDir, $h_scrap_hit_table, $r_contents_section;
	$table = $h_scrap_hit_table['restaurant'];
	$restaurant = array();
	$query = "
		SELECT
			no,
			subject,
			contents,
			new_file,
			section,
			area,
			address,
			mapUrl,
			businessHours,
			tel,
			homepage,
			tag,
			DATE_FORMAT(R.showDate, '%Y-%m-%d') AS showDate,
			(SELECT IFNULL(SUM(hit), 0) FROM gd_bd_magazine_hit WHERE contents_table = '".$table."' AND magazine_no = R.no) AS hit,
			'".$table."' AS tableName
		FROM
			".$table." AS R
		WHERE
			(UNIX_TIMESTAMP(R.openDate) = 0
			OR (CASE
			WHEN openTime = 'am' THEN
				DATE_ADD(R.openDate, INTERVAL 9 HOUR)
			WHEN openTime = 'pm' THEN
				DATE_ADD(R.openDate, INTERVAL 21 HOUR)
			ELSE
				now()
			END) <= NOW()
			) AND R.no = ".$no."";

	$restaurant = $db->fetch($query);
	if ($restaurant['new_file']) {
		$images = explodeString('|', $restaurant['new_file']);
		$restaurant['image'] = getImagePath('board/restaurant', $image);
		$restaurant['slideImage'] = $images;
	} else {
		$restaurant['image'] = getContentsByImage($data['contents']);
	}
	
	if ($restaurant) {
		$restaurant['snsUrl'] = getSnsUrl('restaurant', $restaurant['no']);
		$restaurant['categoryUrl'] = $homeRootDir.'/restaurant/list.php?section='.array_search($restaurant['section'], $r_contents_section['r'], true);
	}
	
	return $restaurant;
}

function setPlusHit($no) {
	global $db, $h_scrap_hit_table;
	$table = $h_scrap_hit_table['restaurant'];
	$query = "SELECT COUNT(1) AS cnt FROM gd_bd_magazine_hit WHERE contents_table = '".$table."' AND hitDate = curdate() AND magazine_no = ".trim($no)."";
	
	$res = $db->fetch($query);
	if ($res['cnt'] > 0) {
		$query = "UPDATE gd_bd_magazine_hit SET hit = (hit + 1) WHERE contents_table = '".$table."' AND hitDate = curdate() AND magazine_no = ".trim($no)."";
	} else {
		$query = "INSERT INTO gd_bd_magazine_hit (contents_table, magazine_no, hitDate, hit, regdt) VALUES('".$table."', ".trim($no).", curdate(), 1, NOW())";
	}

	$res = $db->query($query);
}

function findRestaurantByTags($no, $tag, $section) {
	global $db, $h_scrap_hit_table;
	$table = $h_scrap_hit_table['restaurant'];
	$restaurants = array();
	$tags = array_values(array_filter(array_map('trim',explodeString(',', $tag))));

	if (empty($tags)) {
		return $restaurants;
	}

	$field = array (
		'no',
		'subject',
		'contents',
		'new_file',
		'section',
		'area'
	);
	$caseQuery = '';
	$caseSumQuery = '';

	for ($i = 0, $a = 'a'; $i < count($tags); $i++, $a++) {
		$value = $tags[$i];
		$caseSumQuery .= ($i == 0 ? "(".$a : $a );
		$caseQuery .= "CASE
			WHEN replace(tag,' ','') REGEXP '^".$value."$|^,".$value."$|^".$value.",$|^,".$value.",$|,".$value.",|,".$value."$' THEN 1
			ELSE 0
		END AS ".$a."";

		if (($i + 1) < count($tags)) {
			$caseSumQuery .= " + ";
			$caseQuery .= ",";
		} else {
			$caseSumQuery .= ")";
		}

		$caseQuery .= PHP_EOL;

	}

	$query = "
		SELECT
			".implode(",", $field).",
			DATE_FORMAT(showDate, '%Y-%m-%d') AS showDate,
			'".$table."' AS tableName,
			".$caseSumQuery." as tagCount
		FROM (
			SELECT
				".implode(",", $field).",
				showDate,
				".$caseQuery."
			FROM
				".$table." AS R
			WHERE
				(UNIX_TIMESTAMP(R.openDate) = 0
				OR (
					CASE
					WHEN R.openTime = 'am' THEN
						DATE_ADD(R.openDate, INTERVAL 9 HOUR)
					WHEN R.openTime = 'pm' THEN
						DATE_ADD(R.openDate, INTERVAL 21 HOUR)
					ELSE
						NOW()
					END) <= NOW()
				)
				AND R.section = '".$section."'
				AND R.no <> ".$no."
		) AS Sub
		WHERE
			".$caseSumQuery." > 0
		ORDER BY tagCount DESC, Sub.showDate DESC, no DESC
		LIMIT 12";

	$res = $db->query($query);
	while ($data = $db->fetch($res, 1)) {
		if ($data['new_file']) {
			$image = explodeString('|', $data['new_file']);
			$data['image'] = getImagePath('board/restaurant', $image[0]);
		} else {
			$data['image'] = getContentsByImage($data['contents']);
		}
		
		$data['snsUrl'] = getSnsUrl('restaurant', $data['no']);
		$restaurants[] = $data;
	}
	
	return $restaurants;
}

function changeSectionName($value) {
	switch ($value) {
	case 'Cafe' :
	    return 'Caf&#233;';
	    break;
	case 'etc' :
	    return 'Etc.';
	    break;
	default :
	    return $value;
	    break;
	}
}
?>
		
		<!-- 내용 -->
		<main id="content">
			<!-- 레스토랑 - 상세페이지 -->
			<section class="container rest-detail">
				<h2 class="title_main">Restaurant</h2>

				<!-- 레스토랑 - 상세페이지 - 내용 -->
				<article class="detail">
					<div class="box_bracket detail-title">
						<span class="category"><?=$restaurant['section']?></span>
						<h3><?=$restaurant['subject']?></h3>
						<ul class="info">
							<li><?=$restaurant['showDate']?></li>
							<!-- li><img class="hit" src="<?=$homeRootDir?>/common/images/icon/ico_hit.png" alt="조회수"><span><?=$restaurant['hit']?></span></li -->
						</ul>
					</div>
					
					
					<div class="js detail-slide">
						<div class="js slide-list">
							<ul>
								<?
								foreach($restaurant['slideImage'] as $key=>$data) {
								?>
								<li class="js slide-content"><img src="<?=getImagePath('board/restaurant', $data)?>" alt=""></li>
								<?
								}
								?>
							</ul>
						</div>
						
						<div class="js slide-page">
							<ul>
								<?
								foreach($restaurant['slideImage'] as $key=>$data) {
								?>
								<li <?=($key == 0 ? 'class="on" title="선택됨"' : '')?>><a href="#"><?=($key + 1)?></a></li>
								<?
								}
								?>
							</ul>
						</div>
						<button class="js slide-arrow prev" data-direction="prev"><img src="<?=$homeRootDir?>/common/images/button/detail_slide_arrow_prev.png" alt="이전"></button>
						<button class="js slide-arrow next" data-direction="next"><img src="<?=$homeRootDir?>/common/images/button/detail_slide_arrow_next.png" alt="다음"></button>
					</div>
					
					
					<div class="detail-content">
						<?=$restaurant['contents']?>
						
						<div class="buttonset">
							<ul>
								<li>
									<a href="javascript:void(0)" id="scrap" data-no="<?=$restaurant['no']?>" data-table="<?=$restaurant['tableName']?>">
										<img src="<?=$homeRootDir?>/common/images/button/detail_content_scrap.png" alt="스크랩">
									</a>
								</li>
								<li data-sns="facebook" data-url="<?=$restaurant['snsUrl']?>">
									<a href="javascript:void(0)"><img src="<?=$homeRootDir?>/common/images/button/detail_content_facebook.png" alt="페이스북에 공유"></a>
								</li>
								<li data-sns="instagram">
									<a href="javascript:void(0)"><img src="<?=$homeRootDir?>/common/images/button/detail_content_instagram.png" alt="인스타그램에 공유"></a>
								</li>
								<li><a href="<?=$restaurant['categoryUrl']?>"><img src="<?=$homeRootDir?>/common/images/button/detail_content_list.png" alt="목록"></a></li>
							</ul>
						</div>
					</div>
					
					<div class="detail-hash">
						<?
						if ($restaurant['tag']) {
						?>
						<ul>
							<?
							foreach(explodeString(',', $restaurant['tag']) as $value) {
							?>
							<li><a href="<?=$homeRootDir?>/search/search.php?keyword=%23<?=trim($value)?>">#<?=trim($value)?></a></li>
							<?
							}
							?>
						</ul>
						<?
						}
						?>
					</div>
				</article>
				<!-- // 레스토랑 - 상세페이지 - 내용 -->

				<!-- 레스토랑 - 상세페이지 - 정보 -->
				<section class="rest-detail-info">
					<div class="map">
						<iframe src="<?=$restaurant['mapUrl']?>" width="100%" frameborder="0" style="border:0" allowfullscreen></iframe>
					</div>
					<h4>Infomation</h4>
					<ul>
						<li>
							<dl>
								<dt>Address</dt>
								<dd><?=$restaurant['address']?></dd>
							</dl>
						</li>
						<li>
							<dl>
								<dt>Business Hours</dt>
								<dd><?=$restaurant['businessHours']?></dd>
							</dl>
						</li>
						<li>
							<dl>
								<dt>Call</dt>
								<dd><?=$restaurant['tel']?></dd>
							</dl>
						</li>
						<li>
							<dl>
								<dt>Homepage</dt>
								<dd><?=$restaurant['homepage']?></dd>
							</dl>
						</li>
					</ul>
				</section>
				<!-- // 레스토랑 - 상세페이지 - 정보 -->

				<?
				if (!empty($banner)) {
				?>
				<div class="banner_add">
					<?
					foreach($banner as $key=>$data) {
					?>
					<a href="<?=$data['linkUrl']?>"><img src="<?=$data['img']?>" alt="<?=$data['mainCopy']?>"></a>
					<?
					}
					?>
				</div>
				<?
				}
				?>

				<!-- 레스토랑 - 상세페이지 - 관련레스토랑 -->
				<?
				if(sizeof($tagRestaurants)>0){
				?>
				<section class="js rest-detail-related">
					<h4>관련 레스토랑</h4>
					<div class="js rest-list related-list">
						<ul class="list">
							<?
							foreach($tagRestaurants as $key=>$data) {
							?>
							<li class="js related-content">
								<a href="detail.php?no=<?=$data['no']?>">
									<figure>
										<div class="img"><img class="js cover" src="<?=$data['image']?>" alt=""></div>
										<figcaption>
											<span class="category"><?=changeSectionName($data['section'])?>
											<?=(empty($data['area']) ? '' : '<span class="region">'.$data['area'].'</span>')?>
											</span>
											<strong class="title"><?=$data['subject']?></strong>
										</figcaption>
									</figure>
								</a>
							</li>
							<?
							}
							?>
						</ul>
					</div>
					<button class="js related-arrow prev" data-direction="prev"><img src="<?=$homeRootDir?>/common/images/button/detail_slide_arrow_prev.png" alt="이전"></button>
					<button class="js related-arrow next" data-direction="next"><img src="<?=$homeRootDir?>/common/images/button/detail_slide_arrow_next.png" alt="다음"></button>
				</section>
				<?
				}
				?>
				<!-- // 레스토랑 - 상세페이지 - 관련레스토랑 -->
			</section>
			<!-- // 레스토랑 - 상세페이지 -->

			<!-- 페이지 스크립트 -->
			<script src="<?=$homeRootDir?>/common/js/publish/page_restaurant.js"></script>
		</main>
		<!-- // 내용 -->
		
<?
include dirname(__FILE__)."/../include/bottom.php";
?>

<script src="<?=$homeRootDir?>/common/js/body/common/scrap.js"></script>
<script src="<?=$homeRootDir?>/common/js/body/common/share.js"></script>