<link href="/css/store/base.css" type=text/css rel=stylesheet>
<link href="/css/store/layout_personal.css" type=text/css rel=stylesheet>
<link href="/css/store/shopping2.css" type=text/css rel=stylesheet>
<div id="right_contents">
	<div class="title_area">
	<p><img src="/images/store/store_title.gif" /></p>

	</div>
	<div class="subtitle_area">
		<?if($tab==10){echo"一般会員 ";}else{echo"正会員 ";}?>STORE&nbsp;<span>GOODS LIST</span>
	</div>
	<div class="cancle_notice">

	</div>
	<table width="100%" border="0" cellspacing="0" cellpadding="0" class="cart_list">
		<tr>
			<th width="59" height="32">NO</th>
			<th width="90">商品</th>
			<th width="342">商品名(オプション)</th>

			<th width="80">販売日</th>
			<th width="115">販売状況</th>
			<th width="98">おすすめ度</th>
		</tr>
		<?
	// =============================================== 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";
	}
	// 일반회원 1, 유료회원 0  , 둘다팜 2
  if($tab==10){
  //일반회원
    $where .= " and category in (1,2)";
  }else{
  //유료회원
    $where .= " and category in (0,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 class="items">
			<td><?=$Num?></td>
			<td><a href="javascript:formChange(<?=$row[uid]?>,'view');"><img src="/files/muti/shop/<?=$imgName?>" width="100"></a></td>
			<td class="al_left">
				<a href="javascript:formChange(<?=$row[uid]?>,'view');"><?=$row[name]?></a>
				<?if($row[display] == 2){echo "<font color=red>VIEW ADMIN</font>";}?>
			</td>

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

			?>
			</td>
			<td class="v_al_top"><?=$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>	<!--	/right_contents	-->