<?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/fp_search2.php';
	f.submit();
}
function StatusScript(status,id) {
		var choose = confirm("修正しましょうか?");
		if(choose){
			document.form.idx.value = id;
			document.form.mode.value = status;
			document.form.action = "/admin/Proc/authcode_proc.php";
			document.form.submit();
		}
	}
</script>
<script type="text/javascript">
function validate()
{
	if(!chkDate(frm.startdate,"날짜 형식에 맞게 입력해 주세요\n\n예)2012-01-01")) {return false;}
	if(!chkDate(frm.enddate,"날짜 형식에 맞게 입력해 주세요\n\n예)2012-01-01")) {return false;}
	return true;
}

function go_View(member_srl) {
	var f = document.form;
	f.idx.value = member_srl;
	f.action = 'member_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 = "./fp_search2.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) {
		$key_word = str_replace(" ","",$key_word);
		$where = "AND UPPER(a.".$key.") like '%".strtoupper($key_word)."%' ";
	}
	$order_by = ' ORDER BY b.point desc';

	$url_tail = "$key&key_word=$key_word";
	//총 회원;
	$total_count  = get_db("SELECT count(*) FROM user a left join user_point_inning b on a.id=b.userid where a.activated = 1 and a.auth_code=10 $where $CoWhere $order_by");
	$query_limit  = "limit $offset,$show_one_page";

	$QUERY_PAGE  = "SELECT a.userid,a.id,a.nickname,a.kana_name1,a.auth_code,b.id as count, b.point,b.level FROM user a left join user_point_inning b on a.id=b.userid where a.activated = 1 and a.auth_code=10  $where $CoWhere $order_by $query_limit";
	if($_SERVER["REMOTE_ADDR"] == $remoteAddr){

	echo $QUERY_PAGE."<br>";
	//echo $HTTP_SESSION_VARS[S_ID];
	}
	$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);
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	$total = mysql_affected_rows();
?>
<div id="contents">

	<h2>FAN POINT 조회</h2>
	<div id="content">
		<ul>
			<li><a href="fp.php" class="">FP 회차</a></li>
			<li><a href="fp_search.php" class="">현 회차 FP 조회</a></li>
			<li><a href="fp_search2.php" class="act">전 회차 FP 조회</a></li>
		</ul>
		<form name="form" method="post" target="_self" onsubmit="return false;" >
		<input type="hidden" name="idx">
		<input type="hidden" name="mode">
		<fieldset>
			<select name='gubun'>
				<?
				$QUERY_product  = "SELECT *  FROM user_ranking order by inning desc";
				$results= mysql_query($QUERY_product,$db_con);
					$kk=0;
					while($array=mysql_fetch_array($results)){
						if($kk != 0){
				?>
				<option value='<?=$array[inning]?>' <?if($gubun == $array[inning]){ echo "selected";}?>><?=$array[inning]?>회차</option>
				<?
						}
						$kk++;
					}
				?>
			</select>
			<select name="key">
				<option value="nickname"	<?if($key == "nickname")	echo "selected"; ?>>닉네임</option>
				<option value="userid"	<?if($key == "userid")	echo "selected"; ?>>ID</option>
				<option value="kana_name1"	<?if($key == "kana_name1")	echo "selected"; ?>>名前（カタカナ）</option>
				<option value="member_code"	<?if($key == "member_code")	echo "selected"; ?>>회원번호</option>

				<option value="email"	<?if($key == "email")	echo "selected"; ?>>mail</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='./fp_search2.php'" />
		</fieldset>
		</form>

		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0" >
			<colgroup>
				<col width="30"/>
				<col width="100" />
				<col width="100"/>
				<col width="100"/>
				<col width="" />
				<col width="" />
				<col width="120"/>

			</colgroup>
			<thead>
				<tr>
					<th>No</th>
					<th>아이디</th>
					<th>이름</th>
					<th>별명</th>
					<th>FP</th>
					<th>랭킹</th>
					<th>회원상태</th>
				</tr>
			</thead>
			<tbody>

				<?
				if(!$total){
					echo "<tr><td colspan='11' align=center  height='50px'>登録された情報がございません</td></tr>";
				}else{
					for($i=0; $i<$total; $i++) {
						unset($persent,$MY_LEVEL);
						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						if($row[auth_code] == '10'){
							$stateColor ="#FF0099";
						}else{
							$stateColor ="#ffffff";
						}

						if($row[level] == "Legend") $MY_LEVEL = "<img src='../images/sub/icon_ranking4.png'/> <span class='color_rank_gold font_size_16'>Legend</span>";
						elseif($row[level] == "Gold") $MY_LEVEL = "<img src='../images/sub/icon_ranking5.png'/> <span class='color_rank_gold font_size_16'>Gold</span>";
						elseif($row[level] == "Sliver") $MY_LEVEL = "<img src='../images/sub/icon_ranking6.png'/> <span class='color_rank_gold font_size_16'>Sliver</span>";
						elseif($row[level] == "Bronze") $MY_LEVEL = "<img src='../images/sub/icon_ranking7.png'/> <span class='color_rank_gold font_size_16'>Bronze</span>";
						else $MY_LEVEL = "<img src='../images/sub/icon_ranking7.png'/> <span class='color_rank_gold font_size_16'>Bronze</span>";

				?>
				<tr bgcolor="<?=$bgColor?>">
					<td><?=$Num?></td>
					<td><?=$row[userid]?></td>
					<td><a href="javascript:go_View('<?=$row[id]?>');"><?=$row[kana_name1]?> </a></td>

					<td><?=$row[nickname]?></td>
					<td><?=$row[point]?></td>
					<td><?=$MY_LEVEL?> 등수 <?=$row[count]?>등</td>
					<td bgcolor="<?=$stateColor?>">
						<?
							if($row[auth_code] == '10'){
								echo"<font color=#fff>유료회원</font>";
							}else{
								if($row[auth_code] == 15) echo"관리자<br/>";
								else echo"일반회원";
							}
							?>
					</td>

				</tr>
				<?
					$Num--;
					}
				}
				?>
			</tbody>
		</table>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
	</div>
</div>
</div>
</body>
</html>