<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>
<?
$time_start = microtime(true);
?>
<script type="text/JavaScript"> 
function goPage(page)
{
	var f = document.form;
	f.page.value = page;
	f.action = '/admin/auction_list.php';
	f.submit();
}

 
function go_View(member_srl) {
	var f = document.form;
	f.idx.value = member_srl;
	f.action = 'auction_detail.php';
	f.submit();
}
 
function go_Delete(member_srl) {
	if(confirm("등록된 회원정보가 삭제 됩니다.\n삭제하시겠습니까?")) {
		var f = document.form;
		f.mode.value = 'del';
		f.idx.value = member_srl;
		//f.action = './Proc/member_proc.php';
		//f.submit();
	}
}
function searchChk() {
	//검색
	document.form.action = "./auction_list.php";
	document.form.submit();
}
</script>
<?
	if(!$pageCount) $pageCount = 25;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;   

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;
		  
	if($key_word) {
		if($key == "username" || $key == "jname" || $key == "jname2" || $key == "nickname"){
			//$key_word = str_replace(" ","",$key_word);
			$where = "AND $key like '%".$key_word."%' ";
		}else{
			$key_word = str_replace(" ","",$key_word);
			$where = "AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
		}
	}
	if($goods){
		$where .= "AND goodsuid ='$goods' ";
	}
	$order_by = ' ORDER BY goodsuid asc ,price DESC';
	$url_tail = "&goods=$goods&key=$key&key_word=$key_word&order_by=$order_by";
	//총 회원;
	$total_count  = get_db("SELECT count(*) FROM AUCTION_EVENT where 1=1 $where $CoWhere $order_by");
	$query_limit  = "limit $offset,$show_one_page";

	$QUERY_PAGE  = "SELECT * FROM AUCTION_EVENT where 1=1 $where $CoWhere $order_by $query_limit";
	
	if($_SERVER["REMOTE_ADDR"] == "115.90.174.51"){
	
	//echo $QUERY_PAGE."<br>";
	}
	$total_page   = ceil( $total_count / $show_one_page);
	$viewlist2     = ( !$total_count ) ? "" : Get_viewpage2($page,$total_count,$show_one_page,$show_view_page,$url_tail);
   $start_num    = $total_count - $offset;  // 
	$result= mysql_query($QUERY_PAGE,$db_con);
	$goodNameArr = array("",'ジェジュン　手の石膏','ユチョン　手の石膏','ジュンス　手の石膏','ジェジュン　石膏肖像','ユチョン　石膏肖像','ジュンス　石膏肖像','ジェジュン　パステル肖像','ユチョン　パステル肖像','ジュンス　パステル肖像','ジェジュン　マーブリング','ユチョン　マーブリング','ジュンス　マーブリング','JYJ　テーブル');

	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();
	${SEL_.$goods} = "selected";
?>
<div id="contents">
 
	<h2>경매 리스트</h2>
	<div id="content">
		<form name="form" method="post" target="_self" onsubmit="return false;" >
		<input type="hidden" name="idx">
		<input type="hidden" name="mode">
		<input type="hidden" name="act" value="<?=$act?>">
		<fieldset>
			<select name="goods">
				<option value=""	<?if($goods == "")	echo "selected"; ?>>전체</option>
				<?
					for($i=1;$i<14;$i++){
						echo "<option value=".$i." ".${SEL_.$i}.">".$goodNameArr[$i]."[".$i."]</option>";
					}
				?>
			</select>
			<select name="key">
				<option value="member_id"	<?if($key == "member_id")	echo "selected"; ?>>ID</option>
				<option value="o_name"	<?if($key == "o_name")	echo "selected"; ?>>名前</option>
				<option value="o_email"	<?if($key == "o_email")	echo "selected"; ?>>mail</option>
				<option value="o_tel"	<?if($key == "o_tel")	echo "selected"; ?>>tel</option>
				<option value="price"	<?if($key == "price")	echo "selected"; ?>>price</option>
			</select>
			<input type="text" name="key_word" class="type-text" size="20"  maxlength="20" value="<?=$key_word?>"  onKeyPress="if(event.keyCode==13) if(event.keyCode==13) searchChk();">
			<input type="button" value="검색"class="btn_blue" onClick="searchChk();" />
			<input type="button" value="취소" class="btn_blue" onClick="location.href='<?=$PHP_SELF?>';" />
			<a href='./auction_excel.html?<?=$url_tail?>' target='_blank'>[엑셀]</a>
		</fieldset>
		</form>
		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0" >
			
			<thead>
				<tr>
					<th>No</th>
					<th>아이디</th>
					<th>이름</th>
					<th>핸드폰</th>
					<th>email</th>
					<th>상품</th>
					<th>가격</th>
					<!--th>상태</th-->
					<th>등록일</th>
					<!--th>삭제</th-->
				</tr>
			</thead>
			<tbody>
			
				<?
				if(!$total){
					echo "<tr><td colspan='9' align=center  height='50px'>登録された情報がございません</td></tr>";
				}else{
					for($i=0; $i<$total; $i++) {
						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						$d_regis = substr($row[d_regis],0,10);
					
						if($row[mChk] == 1){
							$bgColor ="#dddddd";
						}else{
							$bgColor ="#ffffff";
						}
						switch($row[goodsuid]){
							case "1":
								$goodName = "ジェジュン　手の石膏";break;
							case "2":
								$goodName = "ユチョン　手の石膏";break;
							case "3":
								$goodName = "ジュンス　手の石膏";break;
							case "4":
								$goodName = "ジェジュン　石膏肖像";break;
							case "5":
								$goodName = "ユチョン　石膏肖像";break;
							case "6":
								$goodName = "ジュンス　石膏肖像";break;
							case "7":
								$goodName = "ジェジュン　パステル肖像";break;
							case "8":
								$goodName = "ユチョン　パステル肖像";break;
							case "9":
								$goodName = "ジュンス　パステル肖像";break;
							case "10":
								$goodName = "ジェジュン　マーブリング";break;
							case "11":
								$goodName = "ユチョン　マーブリング";break;
							case "12":
								$goodName = "ジュンス　マーブリング";break;
							case "13":
								$goodName = "JYJ　テーブル";break;
							
						}
						if($row[auth_code] == '10'){
							$stateColor ="#FF0099";
						}else{
							$stateColor ="#ffffff";
						}
				?>
				<tr bgcolor="<?=$bgColor?>">
					<td><?=$Num?></td>
					<td><?=$row[member_id]?></td>
					<td><?=$row[o_name]?></td>
					<td><?=$row[o_tel]?></td>
					<td><?=$row[o_email]?></td>
					<td style="text-align:left;padding-left:10px;"><?=$goodName?>[<?=$row[goodsuid]?>]</td>
					<td style="text-align:right; padding-right:20px;"><?=number_format($row[price])?></td>
					<!--td><?=$row[orderstep]?></td-->
					<td><?=$d_regis?></td>
					<!--td><a href="javascript:go_Delete('<?=$row[id]?>');"><img src="/admin/images/out.png"></a></td-->
				</tr>
				<?
					$Num--;
					}
				}
				?>
			</tbody>
		</table>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
	</div>
</div>
<p></p>
</body>
</html>
<?
$time_end = microtime(true);
		$time = sprintf("%0.2f",$time_end - $time_start);
		//echo "<center><br><br>$time sec<br><br>";
?>