<?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" >
			<?
			$EndYear = date("Y")+1;
			//$EndYear = "2013";
   $StartYear = date("Y")-2;
			$nn=0;
			//2012
			for($k=$StartYear;$k<$EndYear;$k++){?>
				<tr >
				<?
				echo"<td>".$k."년</td>";
				for($i=1;$i<13;$i++){
					echo"<td>".$i."월</td>";
				}
					echo"<td>총합</td>";
				?>
				</tr>
				<tr >
				<?
				echo"<td>신규</td>";
				$sumA="";
				for($i=1;$i<13;$i++){
					//신규는 해당년도에+1을 해야함... 1인것임.
					$countmember="";
					$shinguYear=$k;
					if($i < 10) $tmpi="0".$i;
					else $tmpi=$i;

					//윤달 -1일 해줘야함..
					if($shinguYear == 2016 && $i > 3){
						$kk = $i-1;
						if($i < 11) $tmpkk="0".$kk;
						else $tmpkk=$kk;

						if($kk == 3) $tmpday = "31";
						else if($kk == 4) $tmpday = "30";
						else if($kk == 5) $tmpday = "31";
						else if($kk == 6) $tmpday = "30";
						else if($kk == 7) $tmpday = "30";
						else if($kk == 8) $tmpday = "31";
						else if($kk == 9) $tmpday = "30";
						else if($kk == 10) $tmpday = "31";
						else if($kk == 11) $tmpday = "30";
						else if($kk == 12) $tmpday = "31";

						$tmpdate1=$shinguYear."-".$tmpkk."-".$tmpday." 23:59:59";

						//$tmpdate1=$shinguYear."-".$tmpi."-30";
					}else{
						if($i < 10) $tmpi="0".$i;
						else $tmpi=$i;
						$tmpdate1=$shinguYear."-".$tmpi."-01 00:00:00";
					}

					$tmpdate2=$shinguYear."-".$tmpi."-32 23:59:59";
					/*
					echo "SELECT count(id)
					FROM user_cash
					WHERE admin_date >= '$tmpdate1'
					AND admin_date <= '$tmpdate2'
					AND inning =1
					AND flag = 'D' <br>";
					*/
					$countmember = get_db("
					SELECT count(id)
					FROM user_cash
					WHERE admin_date >= '$tmpdate1'
					AND admin_date <= '$tmpdate2 23:59:59'
					AND inning =1
					AND flag = 'D'
					");
					echo"<td>$countmember</td>";
					$sumA = $sumA+$countmember;
					$sumArr[]= $countmember;

				}
				$sumArr1[$nn]=$sumArr;
				echo"<td>$sumA</td>";
				?>
				</tr>
				<tr >
				<?
				echo"<td>연장</td>";
				$sumB="";
				for($i=1;$i<13;$i++){
					$countmember1="";
					$yunjangYear=$k;
					if($i < 10) $tmpi="0".$i;
					else $tmpi=$i;
					$tmpdate3=$yunjangYear."-".$tmpi."-01 00:00:00";
					$tmpdate4=$yunjangYear."-".$tmpi."-32 23:59:59";

					/*
					echo "SELECT count(id)
					FROM user_cash
					WHERE admin_date >= '$tmpdate3'
					AND admin_date <= '$tmpdate4'
					AND inning !=1
					AND flag = 'D' <br>";
					*/
					$countmember1 = get_db("
					SELECT count(id)
					FROM user_cash
					WHERE admin_date >= '$tmpdate3'
					AND admin_date <= '$tmpdate4'
					AND inning !=1
					AND flag = 'D'
					");

					echo"<td>$countmember1</td>";
					$sumB = $sumB+$countmember1;
					$sumBrr[]= $countmember1;


				}
				$sumBrr[$nn]=$sumBrr;
				echo"<td>$sumB</td>";
				?>
				</tr>
				<!--<tr >
				<?
				echo"<td>합계</td>";

				for($i=0;$i<13;$i++){
					$totalsum="";
					//$totalsum = $sumArr[$i] + $sumBrr[$i];
					echo"<td>$sumArr[$i]</td>";
				}

				?>
				</tr>
				-->
			<?
				$nn++;
				}?>



		</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='22222' /><set label='신규2기' value='33333' /><set label='연장회원' value='11111' /></chart>");
			//myChart.setXMLUrl("Data.xml");
			myChart.render("chartContainer");


				 </script>
				 -->

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