<?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/memberlist.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 = "./memberlist.php";
	document.form.submit();
}
</script>
<div id="contents">
 
	<h2>회원관리</h2>
	<div id="content">
		<?include "./membertab.html"?>
		<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?>">
		
		</form>
		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0" >
			<colgroup>
				<col width="100"/>
				<col width="100" />
				<col width="80" />
				<col width="100"/>
			</colgroup>
			<thead>
				<tr >
					<th>membership</th>
					<th>회원유형</th>
					<th>기수</th>
					<th>회원수</th>
					
				</tr>
			</thead>
			<tbody>
			
				<?
				
						//$beforeDay = date("Y-m-d", strtotime($today." -".$i." day"));
						//기존회원 쿼리
						$Gmember = Get_db("
						SELECT count(*) FROM `user` 
						WHERE 
						
						m_startdate <= '".date(Y)."-01-01'
						and m_enddate <= '".date(Y)."-12-31'
						and `auth_code` = 10 
						and `activated` = 1");

						//신규회원 쿼리
						$Smember = Get_db("
						SELECT count(*) 
						FROM `user` 
						WHERE 
						m_startdate >= '".date(Y)."-01-01'
						AND `auth_code` = 10
						AND `activated` =1");
						//연장회원 쿼리
						$Lmember = Get_db("
						SELECT count(*) FROM `user` 
						WHERE 
						
						m_startdate < '2013-01-01' and
						m_enddate > '2013-12-31'
						and `auth_code` = 10 
						and `activated` = 1 ");

						$SumM = $Gmember + $Smember +$Lmember;
						$SumM2 =$Smember +$Lmember;


				?>
				<tr>
					<td rowspan="4"><?=date(Y)?>년 JYJ JAPAN</td>
					<td rowspan="2">신규회원</td>
					<td>1기</td>
					<td><?=number_format($Gmember)?></td>
				</tr>
				<tr>
					
					
					<td>2기</td>
					<td><?=number_format($Smember)?></td>
				</tr>
				<tr>
					
					<td> 연장회원</td>
					<td>1기,2기</td>
					<td><?=number_format($Lmember)?></td>
				</tr>
				<tr>
					
					<td>년 카드 발급 회원</td>
					<td>신규2기 연장1기,2기</td>
					<td bgcolor="yellow"><?=number_format($SumM2)?></td>
				</tr>
				<tr>
					<td colspan=3>총계</td>
					
					
					<td><?=number_format($SumM)?></td>
				</tr>
				
			</tbody>
		</table>
		<div class="page_list">
		<!--  prev/next_std >
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
		<script type="text/javascript" src="/FusionChart/Charts/FusionCharts.js"></script>
		<script type="text/javascript" language="Javascript" src="/FusionChart/Code/assets/ui/js/jquery.min.js"></script>
		<script type="text/javascript" language="Javascript" src="/FusionChart/Code/assets/ui/js/lib.js"></script>

      

        <!--[if IE 6]>
        <script type="text/javascript" src="../assets/ui/js/DD_belatedPNG_0.0.8a-min.js"></script>

<script>
          /* select the element name, css selector, background etc */
          DD_belatedPNG.fix('img');

          /* string argument can be any CSS selector */
        </script>
        <![endif]-->

      <div class="gen-chart-render">

			<center>
				 <div id="chartContainer">FusionCharts will load here</div>

				 <script type="text/javascript"><!--

					  var myChart = new FusionCharts("/FusionChart/Charts/Pie3D.swf", "myChartId", "500", "400", "0", "1");
			
			myChart.setXMLData("<chart caption='<?=date('Y')?>년 JYJ MEMBER' xAxisName='Week' yAxisName='Sales' numberPrefix='' formatNumberScale='0' baseFontSize='12' baseFont='굴림'  ><set label='신규1기' value='<?=$Gmember?>' /><set label='신규2기' value='<?=$Smember?>' /><set label='연장회원' value='<?=$Lmember?>' /></chart>");                                
			//myChart.setXMLUrl("Data.xml");
			myChart.render("chartContainer");

					  // -->
				 </script>

			</center>
	  </div>

	  일주일<br>
	  <?
	  //for
	  ?>
	  한달<br>
	  1년<br>

	</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>";
?>