<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<script type="text/JavaScript">
function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/storeList.php';
	f.submit();
}
</script>
<script type="text/javascript">
function go_View(mediano) {
	var f = document.form;
	f.idx.value = mediano;
	f.action = 'store_write.php';
	f.submit();
}

function go_Write() {
	var f = document.form;
	f.action = 'store_write.php';
	f.submit();
}

function go_Modify(mediano) {
	var f = document.form;
	f.idx.value = mediano;
	f.action = 'store_write.php';
	f.submit();
}

function go_Delete(mediano) {
	if(confirm("등록된 글이 삭제 됩니다.\n삭제하시겠습니까?")) {
		var f = document.form;
		f.mode.value = 'del';
		f.idx.value = mediano;
		f.action = './Proc/store_proc.php';
		f.submit();
	}
}
</script>
<div id="contents">
	<h2>GOODS 상품관리</h2>
	<div id="content">

	<table summary="관리자모드 게시판입니다" cellspacing="0" >
		<colgroup>
			<col width="50" />
			<col width="100" />
			<col />
			<col width="90" />
			<col width="80" />
			<col width="80" />
			<col width="80" />
			<col width="80" />
		</colgroup>
 		<thead>
			<tr>
				<th>No</th>
				<th>Image</th>
				<th>goodsName</th>
    <th>회원</th>
				<th>rate</th>
				<td>등록일</td>
				<th>Action</th>
			</tr>
		</thead>
		<tbody>
<form name="form" method="post" target="_self" onsubmit="return false;" >
<input type="hidden" name="page" value="1">
<input type="hidden" name="totalRow" value="10" >
<input type="hidden" name="searchType" value="">
<input type="hidden" name="searchStr" value="">
<input type="hidden" name="searchGroup" value="">
<input type="hidden" name="mode" value="">
<input type="hidden" name="lang_code" value="KO">
<input type="hidden" name="category" value="shop">
<input type="hidden" name="idx" value="">

</form>
<?
	// =============================================== 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%'";
	}

	$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;  //
	$viewlist2     = ( !$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,10);
			$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]);
   if($row[category] == 1) $category = "무료회원";
   else if($row[category] == 2) $category = "전체회원";
   else $category = "유료회원";

?>
			<tr>
				<td><?=$Num?></td>
				<td><img src="/files/muti/shop/<?=$imgName?>" width="100"></td>
				<td class="depth" style="padding-left:20px;"><a href="javascript:go_View(<?=$row[uid]?>);"><?=$row[name]?></a></td>
    <td><?=$category?></td>
				<td><?=$row[shop_rate]?></td>

				<td><?=$regdate?></td>
				<td><a href="javascript:go_Modify(<?=$row[uid]?>);"><img src="./images/check.png" alt="" /></a><a href="javascript:go_Delete(<?=$row[uid]?>);"><img src="./images/out.png" alt="" /></a></td>
			</tr>
<?
		$Num--;
		}
	}
?>
		</tbody>
	</table>
	<div class="btn">
			<a href="javascript:go_Write();" class="btn_blue">등록하기</a>
		</div>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
 	</div>
	</div>
<p></p>
</body>
</html>