<?php

	include $_SERVER['DOCUMENT_ROOT']."/conf/conf_dir.php";

		$META_AUTHOR 					= "KIM JAE JOONG";
		$META_KEYWORD					= "KIM JAE JOONG,	C-jes Ent";
		$META_DISCRIPTION	= "KIM JAE JOONG JAPAN OFFICIAL WEB SITE";
		$PAGE_TITLE							= "KIM JAE JOONG JAPAN OFFICAL WEB SITE | ";

	$PAGE_GUBUN =	"9";

	include $_SERVER['DOCUMENT_ROOT']."/pages/inc_top.php";
  if($sessionLevel != 15 && $_SERVER['REMOTE_ADDR'] != $remoteAddr){
     $userhitpage ="store";
     $hitcount = Get_db("select hit from user_hit where name = '$userhitpage' and startDay = '$today'");
     if(!$hitcount){
      $queryhit = "INSERT INTO user_hit ( id, name, hit, startDay) VALUES ( '', '$userhitpage', '1', '$today')";
     }else{
      $queryhit = "update user_hit set hit = hit+1 where name='$userhitpage' and startDay = '$today'";
     }
     $hitresult = mysql_query($queryhit, $db_con);
   }
?>

<div id="page_index">
	<a href="default.php">HOME</a> > STORE
</div>

<div id="sub_content_box">
	<input type=hidden name="mode" value="<?=$mode?>">
	<input type=hidden name="idx">
</form>
<table width="100%" class="basic_table">
	<colgroup>
 	<col width="10%" />
 	<col width="15%" />
 	<col width="35%" />
 	<col width="10%" />
 	<col width="10%" />
 	<col width="10%" />
 </colgroup>
 <thead>
		<tr>
			<th class="title_le">NO</th>
			<th class="title_le">商品</th>
			<th class="title_le">商品名(オプション)</th>
			<th class="title_le">販売日</th>
			<th class="title_le">販売状況</th>
			<th class="title_le">おすすめ度</th>
		</tr>
 </thead>
 </tbody>
		<?
	// =============================================== Query
	$tableName = "product";

	if(!$pageCount) $pageCount = 10;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;

	if($key_word) {
		$key_word = str_replace(" ","",$key_word);
		$where = "AND $key LIKE '%$key_word%'";
	}
	//test 할려고 만듬
	if($sessionLevel != "15"){
		$where .= " and display !=2";
	}


	$order_by = ' ORDER BY uid DESC';
	$url_tail = "&act=$act&tabs=$tabs&key=$key&order_by=$order_by";

	$query_limit  = "limit $offset,$show_one_page";

	$QUERY_TOTAL = "SELECT count(*) FROM shop_$tableName where 1=1 $where $order_by";
	$QUERY_PAGE  = "SELECT * FROM shop_$tableName where 1=1 $where $order_by $query_limit";

	$total_count  = get_db($QUERY_TOTAL);
	$Num = $total_count - $offset;
	$total_page   = ceil( $total_count / $show_one_page);
	$start_num    = $total_count - $offset;  //
	$viewlist     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);

	$result= mysql_query($QUERY_PAGE,$db_con);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();

	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center height=50px>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan='8' align=center height=50px>登録された情報がございません</td></tr>";
	}else{
		for($i=0; $i<$total; $i++) {

			$row = mysql_fetch_array($result);
			$contents = explode("</p>",$row[contents]);
			$regdate = substr($row[d_regis],0,8);
			$imgName = get_db("select file_name from files where module_no = '$row[uid]' and module_name='shop' and module_type='T'");
			$subject= stripslashes($row[name]);

?>
		<tr>
			<td class="ls"><?=$Num?></td>
			<td class="ls" style="padding:3px 0  3px 0;"><a href="store_view.php?num=<?=$row[uid]?>"><img src="/files/muti/shop/<?=$imgName?>" width="100"></a></td>
			<td class="ls">
				<a href="store_view.php?num=<?=$row[uid]?>"><?=$row[name]?></a>
				<?if($row[display] == 2){echo "<font color=red>VIEW ADMIN</font>";}?>
			</td>

			<td class="ls"><?=$row[start_date]?></td>
			<td class="ls">
			<?
			if($row[display]==1){
				echo "未定";
			}else if($row[display]==0){
				echo "発売中";
			}else if($row[display]==3){
			   echo "販売締め切り";
			}

			?>
			</td>
			<td class="ls"><?=$row[vote]?></td>
		</tr>
		<?
			$Num--;
			}
		}
		?>
		<tr class="result">
			<td class="re_01" colspan="2"></td>
			<td class="re_02" colspan="2"><?=$viewlist?></td>
			<td class="re_03" colspan="2"></td>
		</tr>

	</table>
</div>



<?
  include"inc_footer.php";
?>

</body>
</html>