<?php 

////////////////////////////////共通設定//////////////////////////////////////////////

require("../config.php");
require("../function.php");

////////////////////////////////共通設定//////////////////////////////////////////////

//商品一覧
$item_id_list = "1758,1759,1760";
//親カテゴリ
$categoryID = str_replace("/","",$_SERVER['PATH_INFO']);
$length = mb_strlen($categoryID);

///////////////////////////////このページのURL////////////////////////////////////////
$this_page_url = array(
	str_replace(".php", "", $_SERVER["SCRIPT_NAME"])."/"
);
///////////////////////////////このページのURL////////////////////////////////////////

///////////////////////////////クエリパラメータ///////////////////////////////////////
require("../inc/components/query_params.php");
///////////////////////////////クエリパラメータ///////////////////////////////////////


//子カテゴリ
if($length==0){
	$sql_child_cate = "select d_cate_xl_new.d_cate_xl_id as cate_id, d_cate_xl_new.d_cate_xl_name as cate_name from d_cate_xl_new left join main_item_new on d_cate_xl_new.d_cate_xl_id = substring(main_item_new.d_cate,1,3) where item_id in($item_id_list) $price_dig and image_flag not in(1,3) group by d_cate_xl_new.d_cate_xl_id order by d_cate_xl_new.d_cate_xl_id asc";
	$rs_child_cate = mysqli_query($con,$sql_child_cate);
	$categoryID_dir = "";
}else if($length==3){
	$sql_child_cate = "select d_cate_xl_new.d_cate_xl_id as parent_cate_id, d_cate_xl_new.d_cate_xl_name as parent_name, d_cate_l_new.d_cate_l_id as cate_id, d_cate_l_new.d_cate_l_name as cate_name from d_cate_l_new left join d_cate_xl_new on d_cate_l_new.d_cate_xl_id = d_cate_xl_new.d_cate_xl_id where d_cate_xl_new.d_cate_xl_id = $categoryID";
	$rs_child_cate = mysqli_query($con,$sql_child_cate);
}else if($length==6){
	$sql_child_cate = "select d_cate_xl_new.d_cate_xl_id as grand_cate_id, d_cate_xl_new.d_cate_xl_name as grand_name, d_cate_l_new.d_cate_l_name as parent_name , d_cate_m_new.d_cate_m_id as cate_id, d_cate_m_new.d_cate_m_name as cate_name from d_cate_m_new left join (d_cate_l_new left join d_cate_xl_new on d_cate_l_new.d_cate_xl_id = d_cate_xl_new.d_cate_xl_id) on d_cate_m_new.d_cate_l_id = d_cate_l_new.d_cate_l_id where d_cate_l_new.d_cate_l_id = $categoryID ";
	$rs_child_cate = mysqli_query($con,$sql_child_cate);
	//下層にカテゴリない場合
	$num_len = mysqli_num_rows($rs_child_cate);
	if($num_len == 0){
		$sql_child_cate = "select d_cate_xl_new.d_cate_xl_id as grand_cate_id, d_cate_xl_new.d_cate_xl_name as grand_name, d_cate_l_new.d_cate_l_id as cate_id, d_cate_l_new.d_cate_l_name as parent_name, d_cate_l_new.d_cate_l_name as cate_name from (d_cate_l_new left join d_cate_xl_new on d_cate_l_new.d_cate_xl_id = d_cate_xl_new.d_cate_xl_id) where d_cate_l_new.d_cate_l_id = $categoryID";
		$rs_child_cate = mysqli_query($con,$sql_child_cate);
	}
}else if($length==9){
	$sql_child_cate = "select d_cate_xl_new.d_cate_xl_id as grand_cate_id, d_cate_xl_new.d_cate_xl_name as grand_name, d_cate_l_new.d_cate_l_name as parent_name,d_cate_l_new.d_cate_l_id as parent_cate_id , d_cate_m_new.d_cate_m_id as cate_id, d_cate_m_new.d_cate_m_name as cate_name from d_cate_m_new left join (d_cate_l_new left join d_cate_xl_new on d_cate_l_new.d_cate_xl_id = d_cate_xl_new.d_cate_xl_id) on d_cate_m_new.d_cate_l_id = d_cate_l_new.d_cate_l_id where d_cate_m_new.d_cate_m_id = $categoryID ";
	$rs_child_cate = mysqli_query($con,$sql_child_cate);
}


//価格帯での絞り込み用
if($_GET['min_p']!=""){
	$min_p = mb_convert_kana(strip_tags(trim($_GET['min_p'])),"nas");
	$max_p = mb_convert_kana(strip_tags(trim($_GET['max_p'])),"nas");
	$minSys = ">= ".$min_p;
	if($_GET['max_p']!=""){
		$maxSys = " and (price * ".$tax_per.") <= ".$max_p;
	}
	$price_dig = "and (price * ".$tax_per.") $minSys $maxSys ";
	
	//パン屑用msg
	$dig_msg = " (価格：\\".number_format($min_p,0)."～".number_format($max_p,0).")";
	}


//カテゴリを形成
while($row_child_cate = mysqli_fetch_assoc($rs_child_cate)){
	//一番上のカテゴリ
	  $grand_cate['id'] = $row_child_cate['grand_cate_id'];
	  $grand_cate['name'] = $row_child_cate['grand_name'];
	 
	//現在居るカテゴリ
	  $parent_cate['name'] = $row_child_cate['parent_name'];
	  $parent_cate['id'] = $row_child_cate['parent_cate_id'];
	//子カテゴリ
	  //商品数をカウント
	  $sql = "select count(*) as num from main_item_new where item_id in($item_id_list) and d_cate like '".$row_child_cate['cate_id']."%' $price_dig and image_flag not in(1,3)";
	  $rs = mysqli_query($con,$sql);
	  $row = mysqli_fetch_assoc($rs);
	  
	  $child_cate[] = array(
						  'cate_name'=>$row_child_cate['cate_name'],
						  'cate_id'=>$row_child_cate['cate_id'],
						  'count'=>$row['num']
						);
	}
	
//メイン
$pos = mysqli_real_escape_string($con,$_GET['pos']);

////////////////////////////////以下アイテム抽出//////////////////////////////////////

//廃版・生産完了絞り込みのsql生成
$q_stock = (int)strip_tags($_GET['stock']);
$q_discon = (int)strip_tags($_GET['discon']);
if(($q_stock+$q_discon)!=0){
	if($q_stock!=0 and $q_discon!=0){
		$image_select = "image_flag not in ('2','3') and ";
	}elseif($q_stock==2 and $q_discon==0){
		$image_select = "image_flag not in ('2') and ";
	}elseif($q_stock==0 and $q_discon==3){
		$image_select = "image_flag not in ('3') and ";
	}
}

////////////////////////////////ソートとPager/////////////////////////////////////////

$q_sort_field = $_GET['alocale'];
$q_sort_mode = $_GET['mode'];
$num_mode = $_GET['max_num'];
$disp_mode = $_GET['disp'];

if($q_sort_field=="brand"){
	$sort_field="maker";
	$q_alocale = "alocale=".$q_sort_field;
}else if($q_sort_field=="price"){
	if($login_mode==1){
		if($member_mode==1){
			$sort_field="s_price";
			$q_alocale = "alocale=".$q_sort_field;
		}else{
			$sort_field="d_price";
			$q_alocale = "alocale=".$q_sort_field;
		}
	}else{
		$sort_field="price";
		$q_alocale = "alocale=".$q_sort_field;
	}
}else if($q_sort_field=="akari"){
	$sort_field="item_order2";
	$q_alocale = "alocale=".$q_sort_field;
}else if($q_sort_field=="recommen_level"){
	$sort_field="recommen_level";
	$q_alocale = "alocale=".$q_sort_field;
}else{
	$sort_field="maker = 'YAZAWA(ヤザワ)' desc,newdate";
	$q_alocale = "";
}

if($q_sort_mode=="cbids_up"){
	$sort_mode="desc";
	$q_mode = "mode=".$q_sort_mode;
}else if($q_sort_mode=="cbids_down"){
	$sort_mode="asc";
	$q_mode = "mode=".$q_sort_mode;
}else{
	$sort_mode="desc";
	$q_mode = "";
}

//表示切替
if($disp_mode=="list"){
	$disp_mode = "list";
	$q_disp_mode = "disp=list";
}else if($disp_mode=="thumb"){
	$disp_mode = "thumb";
	$q_disp_mode = "disp=thumb";
}else{
	$disp_mode = "thumb";
	$q_disp_mode = "disp=thumb";
}
//件数表示
if($num_mode!=""){
	$maxrow = $num_mode;
	$q_max_num = "max_num=".$num_mode;
}else{
	$maxrow = 40;
	$q_max_num = "";
}

$pos = 0 + (int)$pos;

$_GET['digg'] = mysqli_real_escape_string($con,$_GET['digg']);

//diggったときの分岐
if($_GET['digg']==""){

	// 表示分商品の抽出
	$sql_main_item = " select * from main_item_new WHERE item_id in($item_id_list) and d_cate like '$categoryID%' $price_dig and image_flag not in(1,3) order by image_flag, $sort_field $sort_mode, code limit ".($pos * $maxrow).", $maxrow";
	$rs_main_item = mysqli_query($con,$sql_main_item);

	// 全ページ分商品の抽出
	$sql_main_item_all = "select * from main_item_new where item_id in($item_id_list) and d_cate like '$categoryID%' $price_dig and image_flag not in(1,3)";
	$rs_main_item_all = mysqli_query($con,$sql_main_item_all);
	$num = mysqli_num_rows($rs_main_item_all);

	
}else{//diggったときの分岐
  
	// 表示分商品の抽出
	$sql_main_item = " select * from main_item_new WHERE item_id in($item_id_list) and d_cate like '$categoryID%' $price_dig and image_flag not in(1,3) order by image_flag, $sort_field $sort_mode, code limit ".($pos * $maxrow).", $maxrow";
	$rs_main_item = mysqli_query($con,$sql_main_item);

    // 全ページ分商品の抽出
	$sql_main_item_all = "select * from main_item_new WHERE item_id in($item_id_list) and d_cate like '$categoryID%' $price_dig and image_flag not in(1,3)";
	$rs_main_item_all = mysqli_query($con,$sql_main_item_all);
	$num = mysqli_num_rows($rs_main_item_all);
  
}//diggったときの分岐終わり

// 該当カテゴリ全商品
$sql_main_item_list = " select * from main_item_new WHERE item_id in($item_id_list) and d_cate like '$categoryID%' and image_flag not in(1,3)";
$rs_main_item_list = mysqli_query($con,$sql_main_item_list);

/*** 商品データ配列を生成 ***************************/
// 表示分のみ
while($row_main_item = mysqli_fetch_assoc($rs_main_item)):
	$item_array[] = $row_main_item;
endwhile;

// 対象全商品
while($row_main_item_list = mysqli_fetch_assoc($rs_main_item_list)):
	$all_item_array[] = $row_main_item_list;
endwhile;
/*** 商品データ配列を生成 ***************************/

//○ページ目
if($pos!=""){
	$pager_text = " ".($pos+1)."ページ";
}else{
	$pager_text = " 1ページ";
}

///////パン屑//////////////////////////////////////////////
$bread_crumbs = "<ul class='breadcrumbs'>
                  <li itemtype='http://data-vocabulary.org/Breadcrumb'>
                    <a href='".$this_site_url."' itemprop='url'><span itemprop='title'>トップページ</span></a>
                  </li>
                  <li itemscope itemtype='http://data-vocabulary.org/Breadcrumb'>
                    <a href='".$this_site_url."contents/0004/' itemprop='url'><span itemprop='title'>シーン別 ナイトライトシリーズ ".$dig_msg."</span></a>
                  </li>
                </ul>";
///////パン屑//////////////////////////////////////////////

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>シーン別 ナイトライトシリーズ | <?php echo $this_site_title;?> <?php echo $pager_text;?></title>
<meta name="description" content="シーン別 ナイトライトシリーズ。<?php echo $meta_desc;?>" />
<meta name="keywords" content="シーン別 ナイトライトシリーズ,<?php echo $meta_key;?>" />
<meta name="author" content="<?php echo $meta_author;?>" />

<?php if($pos != ""):?>
<meta name="robots" content="noindex" />
<?php endif;?>

<!-- Common Files -->
<?php include("../inc/common_files.php")?>

<!-- css -->
<link href="<?php echo $css_path;?>style.css" rel="stylesheet" type="text/css" />
<link href="<?php echo $css_path;?>part.css" rel="stylesheet" type="text/css" />
<link href="<?php echo $css_path?>list.css" rel="stylesheet" />

<!-- item list effect -->
<script src="<?php echo $js_path?>itemListEf.js"></script>
<style>
.pager-bottom ul{
	width:calc(15% + <?php echo round($num/$maxrow)?>%);
	}
.curnt a{
	font-weight:bold;
	}
.c_topbox{
	margin:0 auto;
	text-align:center;
  margin:0 0 20px;
  width:500px;
}
</style>
</head>
<body id="Search">
<?php include("../inc/header.php");?>
<article class="mainContents">
  <h1>シーン別 ナイトライトシリーズ</h1>
  <section>
    <div>
      <div class="cltitlebox">
        <h2>商品数<span class="result_num"><?php echo number_format($num);?> <span>件 / <?php echo $pager_text;?></span></span></h2>
	  </div>
	  
	  <!-- 表示切替オプション -->
	  <?php include("../inc/components/optional_box.php")?>

      <div class="flex justify-between align-start">
        <!-- サイドメニュー -->
        <?php include("../inc/listpage_menu.php")?>
        
        <!-- 商品一覧 -->
        <div class="ItemDisplay flex">
    <?php if($disp_mode=="list"){?>
    <?php include("../inc/templates/list_tmp_02.php");?>
    <?php }else if($disp_mode=="thumb"){?>
    <?php include("../inc/templates/list_tmp.php");?>
    <?php } ?>

          <!-- ページネーション -->
          <?php include("../inc/components/pagenation.php")?>
        </div>

      </div>
 
    </section>
  </article>
  <article class="subContents">
  </article>
  <?php include("../inc/footer.php");?>
<?php include("../inc/acc.php");?>
</body>
</html>