<?php
include_once("_include/settings/html_header.php");
include_once("_include/settings/sub_title_shuffle.php");
$pgi = 0;
$page["name"] = "商品のご紹介";


// データベースコネクト =====================================================================

include_once('/usr/home/ad1132yvdm/data/mat_MySQL_class.php');
$DB = new mat_MySQL_class;


// リファラーをチェック =====================================================================

if(preg_match("/baby\.co\.jp\//",$_SERVER["HTTP_REFERER"]) && preg_match("/products\.php/",$_SERVER["HTTP_REFERER"]))
{
	//var_dump(parse_url($_SERVER["HTTP_REFERER"]));
}


// 商品情報を取得 =====================================================================
if(isset($_GET["id"]) && strlen($_GET["id"]) <= 5 && preg_match("/^[0-9]+$/",$_GET["id"]))
{
	$get_id = $_GET["id"];
	
	// 念のため 公開状態を チェック
	$sql = "SELECT `post_status` FROM `wp_baby_2_posts` WHERE `ID` = $get_id LIMIT 1";
	$DB->Q($sql);
	$item_live = $DB->Fetch_key();
	if($item_live["post_status"] == "publish")
	// 公開OK -------------------------------------
	{
		// カスタムフィールド と アイキャッチ画像
		$sql = "SELECT * FROM `wp_baby_2_postmeta` WHERE `post_id` = $get_id";
		$DB->Q($sql);
		while($DBR = $DB->Fetch_key())
		{
			// 各情報
			$custom_feelds[$DBR["meta_key"]] = $DBR["meta_value"];
			
			// 画像への参照ID
			switch($DBR["meta_key"])
			{
				case "_thumbnail_id" :
				case "サブ画像1" :
				case "サブ画像2" :
				case "サブ画像3" :
				case "サブ画像4" :
				case "サブ画像5" :
				case "サブ画像6" :
				case "サブ画像7" :
				case "サブ画像8" :
				case "サブ画像9" :
				case "サブ画像10" :
					if(strlen($DBR["meta_value"]))
					{
						$image_id_array[$DBR["meta_key"]] = $DBR["meta_value"];
					}
					break;
				
				default :
					break;
			}
		}
		
		// 各画像 を 取得
		if(isset($image_id_array))
		{
			$image_id_in = implode(",",$image_id_array);
			$sql = "SELECT `ID`,`post_title`,`guid` FROM `wp_baby_2_posts` WHERE `ID` IN ($image_id_in)";
			$DB->Q($sql);
			while($DBR = $DB->Fetch_key())
			{
				$img_array["path"][$DBR["ID"]] = $DBR["guid"];
				$img_array["name"][$DBR["ID"]] = $DBR["post_title"];
			}
		}
		
		// 情報出力用 配列 を 作る
		$loop = 0;
		foreach($custom_feelds as $key => $val)
		{
			switch($key)
			{
				case "商品名A"			: $output[$key] = $val; break;
				case "商品名B"			: $output[$key] = $val; break;
				case "本体価格"			: $output[$key] = $val; break;
				case "配色"				: $output[$key] = $val; break;
				case "品番"				: $output[$key] = $val; break;
				case "サイズ"			: $output[$key] = $val; break;
				case "素材"				: $output[$key] = $val; break;
				case "サブテキスト"		: $output[$key] = $val; break;
				case "内訳"				: $output[$key] = $val; break;
				case "_thumbnail_id"	:
					if(strlen($img_array["path"][$val]))
					{
						$output["メイン画像"]["path"] = $img_array["path"][$val];
						$output["メイン画像"]["name"] = $img_array["name"][$val];
					}
					else
					{
						$output["メイン画像"] = "no_image";
					}
					break;
				case "サブ画像1" :
				case "サブ画像2" :
				case "サブ画像3" :
				case "サブ画像4" :
				case "サブ画像5" :
				case "サブ画像6" :
				case "サブ画像7" :
				case "サブ画像8" :
				case "サブ画像9" :
				case "サブ画像10" :
					if(strlen($img_array["path"][$val]))
					{
						$output["サブ画像"][$loop]["path"] = $img_array["path"][$val];
						$output["サブ画像"][$loop]["name"] = $img_array["name"][$val];
						++$loop;
					}
					break;
			}
		}
	}
	else
	{
	}
}
else
{
	// 引数 が ミスっていたら 一覧 へ リダイレクト
	header("Location: products.php");
}


// カテゴリ一覧を取得 =====================================================================

// カテゴリ
$sql = "SELECT `option_value` FROM `wp_baby_2_options` WHERE `option_name` = 'wpguy_category_order' LIMIT 1";
$DB->Q($sql);
$cat_sort = $DB->Fetch_key();
preg_match_all('/".*?";/',$cat_sort["option_value"],$csm);
foreach($csm[0] as $csmK => $csmV)
{
	$csm[0][$csmK] = preg_replace('/"([0-9,]{1,200})";/','$1',$csmV);
}

preg_match_all('/i:[0-9]{1,3};/',$cat_sort["option_value"],$csm2);
$subcat_loop = 0;
foreach($csm2[0] as $csm2K => $csm2V)
{
	$subcat[preg_replace('/i:([0-9]{1,3});/','$1',$csm2V)] = explode(",",$csm[0][$subcat_loop++]);
}

$submenu = explode(",",$csm[0][0]);
foreach($submenu as $submenuV)
{
	$submenu2[$submenuV] = @array_flip($subcat[$submenuV]);
}

unset($submenu2[1]);// 未分類を外す


// 全てのカテゴリ名を得る
$sql = "SELECT `wp_baby_2_terms`.`term_id` AS `id`,`name`,`count` FROM `wp_baby_2_terms` LEFT JOIN `wp_baby_2_term_taxonomy` ON `wp_baby_2_terms`.`term_id` = `wp_baby_2_term_taxonomy`.`term_id` WHERE `wp_baby_2_term_taxonomy`.`count` != 0";
$DB->Q($sql);
while($DBR = $DB->Fetch_key())
{
	$taxo_name[$DBR["id"]] = $DBR["name"];
}


// パンクズの後ろとサブナビのCSS =====================================================================

$BC = '　<i class="fa fa-chevron-circle-right"></i>　'.$page["name"];
$sub_nav_css = '';
if(isset($_GET["cat"]) && strlen($_GET["cat"]) <= 3 && preg_match("/[0-9]{1,3}/",$_GET["cat"]))
{
	$get_cat = $_GET["cat"];
	if(isset($_GET["parent"]) && strlen($_GET["parent"]) <= 3 && preg_match("/[0-9]{1,3}/",$_GET["parent"]))
	{
		$get_parent = $_GET["parent"];
		$BC = '　<i class="fa fa-chevron-circle-right"></i>　<a href="products.php">'.$page["name"].'</a>　<i class="fa fa-chevron-circle-right"></i>　<a href="products.php?cat='.$get_parent.'">'.$taxo_name[$get_parent].'</a>　<i class="fa fa-chevron-circle-right"></i>　'.$taxo_name[$get_cat];
		$sub_nav_css = '#sub_'.$get_parent.'{display:block;}';
	}
	else
	{
		$BC = '　<i class="fa fa-chevron-circle-right"></i>　<a href="products.php">'.$page["name"].'</a>　<i class="fa fa-chevron-circle-right"></i>　'.$taxo_name[$get_cat];
		$sub_nav_css = '#sub_'.$get_cat.'{display:block;}';
	}
}


?><!DOCTYPE html>
<html lang="ja">
<head>
<meta charset="UTF-8">
<?=$html_header["keywords"];?>
<?=$html_header["description"];?>
<?=$html_header["viewport"];?>

<title><?=$html_header["site_name"];?>｜<?=$page["name"];?>｜<?=$output["商品名A"];?> / <?=$output["商品名B"];?></title>
<?=$html_header["css"]["font"];?>

<link rel="stylesheet" href="css/common.css">
<link rel="stylesheet" href="css/font-awesome.min.css">
<style>
#products_wrapper{
	margin-top:40px;
}

#products_wrapper table td{
	vertical-align:top;
}

.item_box{
	position:relative;
	box-sizing:border-box;
	display:inline-block;
	padding:20px 10px 10px 10px;
	background:url(img/products/bg.gif) repeat;
	/*background:#fff8e6;*/
	vertical-align:text-top;
	margin-right:10px;
	box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-webkit-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-moz-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	text-decoration:none;
	border-radius:10px;
}

<?php
$tape_color = array("01","02","03","04","05");
shuffle($tape_color);
?>
.box_tape{
	position:absolute;
	width:100px;
	height:30px;
	top:-16px;
	left:210px;
	background:url(img/products/item_box_tape_L_<?=$tape_color[0];?>.png) no-repeat;
}

.img_box{
	display:inline-block;
	margin-bottom:5px;
}

.img_box img{
	border:#ccc 1px solid;
}

.image_selector{
	margin-left:2px;
}

.sub_img_box{
	display:inline-block;
	margin-top:5px;
	margin-left:2px;
	cursor:pointer;
}

.sub_img_box img{
	border:#ccc 1px solid;
}


#info_box{
	position:relative;
	box-sizing:border-box;
	padding:3px;
	background:url(img/products/bg.gif) repeat;
	box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-webkit-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-moz-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	border-radius:10px;
}

#info_box_in{
	box-sizing:border-box;
	padding:16px 6px 6px 6px;
	border-radius:7px;
	border:#efce7f 1px dashed;
}

.box_tape2{
	position:absolute;
	width:100px;
	height:30px;
	top:-16px;
	left:63px;
	background:url(img/products/item_box_tape_L_<?=$tape_color[1];?>.png) no-repeat;
}

.info_box_solo{
	border-bottom:#efce7f 1px dashed;
	margin-bottom:10px;
	width:100%;
}

.info_box_solo:nth-last-child(1){
	border-bottom:none;
	margin-bottom:0px;
	width:100%;
}

.name_A_box{
	font-size:13px;
	color:#63081e;
	font-weight:bold;
}

.name_B_box{
	font-size:14px;
	color:#63081e;
	font-weight:bold;
}

.price_box{
	font-size:13px;
	color:#666666;
}

#product_info{
	font-size:12px;
	color:#666666;
}

.sub_category{
	display:none;
}


#return_button{
	display:block;
	box-sizing:border-box;
	margin-top:20px;
	cursor:pointer;
	color:#115683;
	text-align:center;
	text-decoration:none;
	font-family:"メイリオ", Meiryo, "Jun 34", "ヒラギノ角ゴ Pro W3", "Hiragino Kaku Gothic Pro", "游ゴシック", YuGothic,  Osaka, sans-serif;
	padding:5px 10px 5px 13px;
	border-radius:20px;
	border:#ff8d8d 1px solid;
	background:rgba(255, 255, 255, 0.75);
	box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-webkit-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
	-moz-box-shadow:rgba(89, 152, 223, 0.509804) 0px 6px 10px 0px;
}
<?=$sub_nav_css;?>
</style>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<script src="js/jquery.easie.js"></script>
<script src="js/jqfloat.min.js"></script>
<script src="js/fuwa_fuwa_effect.js"></script>
<script>
$(function(){
	$(".sub_img_box img").on("click",function(){
		var path = $(this).attr("src");
		$("#main_image").attr("src",path);
	});
	
	$("#return_button").on("click",function(){
		history.back();
	});
});
function sub_open(key)
{
	$("#sub_"+key).animate({height:"toggle"},300);
}
</script>
</head>
<body>
<?php include_once("_include/parts/google_analytics_code.php");?>


<div id="wrapper">
	<?php include_once("_include/parts/header.php");?>
	
	
	<div id="contents">
		<div id="contents_inner">
			
			
			<!-- === Left Column === -->
			<?php include_once("_include/parts/products_left_nav.php");?>
			
			
			<!-- === Right Column === -->
			<div id="right_column">
				
				<div class="page_title">
					<div id="bread_clumbs"><a href="./">TOP</a><?=$BC;?></div>
					<h2><?=$page["name"];?></h2>
				</div>
				
				<div id="products_wrapper" itemscope itemtype="http://schema.org/Product">
					<table width="780" cellpadding="0" cellspacing="0">
						<tr>
							<td width="1%">
								<div class="item_box">
									<div class="box_tape"></div>
<?php
if(isset($output["メイン画像"])):
?>
									<div class="img_box"><img itemprop="image" id="main_image" src="<?=$output["メイン画像"]["path"];?>" width="500" height="500" alt="<?=$output["商品名A"];?> / <?=$output["商品名B"];?>"></div>
<?php
else :
?>
									<div class="img_box"><img id="main_image" src="img/products/no_image_l.gif" width="500" height="500"></div>
<?php
endif;
?>
									<div class="image_selector">
<?php
if(isset($output["メイン画像"])):
?>
										<div class="sub_img_box"><img src="<?=$output["メイン画像"]["path"];?>" width="75" height="75" alt="<?=$output["商品名A"];?> / <?=$output["商品名B"];?>"></div>
<?php
else :
?>
										<div class="sub_img_box"><img src="img/products/no_image_l.gif" width="75" height="75" alt="<?=$output["商品名A"];?> / <?=$output["商品名B"];?>"></div>
<?php
endif;
?>
<?php
if(isset($output["サブ画像"])) :
	foreach($output["サブ画像"] as $key => $val) :
?>
										<div class="sub_img_box"><img src="<?=$val["path"];?>" width="75" height="75" alt="<?=$output["商品名A"];?> / <?=$output["商品名B"];?>"></div>
<?php
	endforeach;
endif;
?>
									</div>
								</div>
							</td>
							<td>
								<div id="info_box">
									<div class="box_tape2"></div>
									<div id="info_box_in">
										<div class="info_box_solo">
											<div class="name_A_box" itemprop="name">
												<?=$output["商品名A"];?><br>
											</div>
											<div class="name_B_box" itemprop="alternateName">
												<?=$output["商品名B"];?><br>
											</div>
											<div class="price_box">
												本体価格&yen;<?=number_format($output["本体価格"]);?>+税<br>
											</div>
										</div>
										<div class="info_box_solo">
											<table cellpadding="0" cellspacing="0" id="main_info">
												<?php if(strlen($output["配色"])):?><tr><td nowrap>配色　</td><td itemprop="color"><?=$output["配色"];?></td></tr><?php endif;?>
												<?php if(strlen($output["品番"])):?><tr><td nowrap>品番　</td><td itemprop="productID"><?=$output["品番"];?></td></tr><?php endif;?>
												<?php if(strlen($output["サイズ"])):?><tr><td nowrap>サイズ&nbsp;</td><td itemprop="color"><?=$output["サイズ"];?></td></tr><?php endif;?>
												<?php if(strlen($output["素材"])):?><tr><td nowrap>素材　</td><td><?=$output["素材"];?></td></tr><?php endif;?>
											</table>
										</div>
										<?php if(strlen($output["サブテキスト"])):?><div class="info_box_solo" itemprop="description"><?=$output["サブテキスト"];?></div><?php endif;?>
										<?php if(strlen($output["内訳"])):?><div class="info_box_solo"><?=nl2br($output["内訳"]);?></div><?php endif;?>
									</div>
								</div>
								
								<div id="return_button">
									<i class="fa fa-arrow-circle-left"></i>&nbsp;戻る
								</div>
							</td>
						</tr>
					</table>
				</div>
				
			</div>
		</div>
	</div>
	
	<div id="footer" style="position:relative; z-index:10001;">
		<?=file_get_contents("_include/parts/footer.php");?>
	</div>
</div>
</body>
</html>