<?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();
}

function go_View(mediano) {
	var f = document.form;
	f.idx.value = mediano;
	f.action = 'store_order_write.php';
	f.submit();
}
 
function go_Write() {
	var f = document.form;
	f.action = 'store_order_write.php';
	f.submit();
}
 
function go_Modify(mediano) {
	var f = document.form;
	f.idx.value = mediano;
	f.action = 'store_order_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();
	}
}

function searchChk() {
	//검색
	document.F_search.action = "<?=$php_self?>";
	document.F_search.submit();
}
</script>
<?
// =============================================== Query
	$tableName = "order";
	
	if(!$pageCount) $pageCount = 30;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;   

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;
	
	if($key_word) {
		if($key == "member_id"){
			//$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)."%' ";
		}
		
	}else{
		
	}
	$order_by = ' ORDER BY no desc';
	$url_tail = "&act=$act&orderstep=$orderstep&key=$key&key_word=$key_word&key2=$key2&key_word2=$key_word2&goodsproduct=$goodsproduct&sort=$sort&sort_sc=$sort_sc";

	$query_limit  = "limit $offset,$show_one_page";
  
	$QUERY_TOTAL = "SELECT count(*) FROM AUCTION_EVENT4 WHERE 1=1 $where $order_by";

	$QUERY_PAGE  = "
	SELECT
	* ,(select username from user where id = mbruid) as username
	FROM
	AUCTION_EVENT4
	WHERE 1=1 $where $order_by $query_limit";
	if($_SERVER["REMOTE_ADDR"] == "115.90.174.51"){
		echo $QUERY_PAGE."<br>";
	}

	$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);
	$total = mysql_affected_rows();
?>
<div id="contents">
	<h2>2015 membership week 설문조사</h2>
	<div id="content">
	
	<form name="F_search" method="post" action="<?$PHP_SELF?>">
		<input type="hidden" name="act" value="<?=$act?>">
		<input type="hidden" name="orderstep" value="<?=$orderstep?>">
		<input type="hidden" name="page" value="<?=$page?>">
		참가자수 : <b><? echo $total_count;?> 명</b>
				<select name='key'>
					<option value='member_id' <?if($key == 'member_id'){ echo "selected";}?>>id</option>
					<option value='goods1' <?if($key == 'goods1'){ echo "selected";}?>>참가횟수</option>
					<option value='d_regis' <?if($key == 'd_regis'){ echo "selected";}?>>접수일</option>
					<option value='memo' <?if($key == 'memo'){ echo "selected";}?>>내용</option>
				</select>
				<input type="text" name="key_word" size="17" value="<?echo $key_word?>"  ONKEYPRESS="if (event.keyCode==13) searchChk();">
				<input type="button" value="search" class="button" onclick="Javascript:searchChk()">
				<input type="button" value="reset" class="button" onclick="Javascript:location.replace('<?=$PHP_SELF?>');">
				
				<a href='./event_list_201507_excel.html' target='_blank'>[엑셀]</a>

	</form>
	
	<table summary="관리자모드 게시판입니다" cellspacing="0" width="1000">
		
 		<thead>
			<tr>
				<th>No</th>
				<th>ID</th>
				<th>이름</th>
				<th>참가횟수</th>
				<th>접수일</th>
				<th>내용</th>
			</tr>
		</thead>
		<tbody>
<form name="form" method="post" target="_self" onsubmit="return false;" > 
<input type="hidden" name="page" value="<?=$page?>">
<input type="hidden" name="act" value="<?=$act?>">
<input type="hidden" name="orderstep" value="<?=$orderstep?>">
<input type="hidden" name="key" value="<?=$key?>">
<input type="hidden" name="key_word" value="<?=$key_word?>">
<input type="hidden" name="mode" value="">
<input type="hidden" name="category" value="shop">
<input type="hidden" name="idx" value="">
<input type="hidden" name="flag" value="">
</form>
<?
	
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	
	$totalsum=0;
	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center height=50px>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan='9' align=center height=50px>登録された情報がございませ</td></tr>";
	}else{
		for($i=0; $i<$total; $i++) {
			$row = mysql_fetch_array($result);
			
			$d_regis= substr($row[d_regis],0,10);
?>
			<tr>
				<td><?=$Num?></td>
				<td><?=$row[member_id]?></td>
				<td><?=$row[username]?></td>
				<td><?=$row[goods1]?></td>
				<td><?=$d_regis?></td>
				<td width=500 style="text-align:left;"><p><?=nl2br(stripslashes($row[memo]))?></p></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>