<?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>
		구분 : <font color=black>무통장(입금 완료일 기준)</font>, <font color=blue>카드(승인 기준)</font> 
		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0" >
			<?
			$EndYear = date("Y")+1;
			$nn=0;
			for($k=2019;$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>";
				unset($sum1,$sum2,$sum3);
				for($i=1;$i<13;$i++){
					//신규는 해당년도에+1을 해야함... 1인것임.
					$countmember="";
					$shinguYear=$k;
					$ss = $i+1;
					$num = sprintf('%02d',$i);
					$numss = sprintf('%02d',$ss);
					$tmpdate1=$shinguYear.$num."01";
					$tmpdate2=$shinguYear.$numss."01";

					$countmember_1 = get_db("
					SELECT count(uid)
					FROM shop_order
					WHERE goodsuid ='1'
					AND display = '1'
					AND orderstep = '2'
					AND d_bank >= '$tmpdate1'
					AND d_bank <= '$tmpdate2'
					AND ckind = 1
					AND buyfix = 0
					");

					$countmember_2 = get_db("
					SELECT count(uid)
					FROM shop_order
					WHERE goodsuid ='1'
					AND display = '1'
					AND orderstep = '2'
					AND d_bank >= '$tmpdate1'
					AND d_bank <= '$tmpdate2'
					AND ckind = 2
					AND buyfix = 0
					");

					$tsum = $countmember_1 + $countmember_2 ;
					echo"<td>$countmember_1 <font color=blue>$countmember_2</font><br> ($tsum)</td>";

					$sum1 = $sum1+$countmember_1;
					$sum2 = $sum2+$countmember_2;

					//$sumArr[]= $countmember;

				}
				//$sumArr1[$nn]=$sumArr;
				$tysum = $sum1+$sum2+$sum3;
				echo"<td>$sum1 <font color=blue>$sum2</font> <font color=red>$sum3</font><br>  ($tysum)</td>";
				$eekd = $eekd + $tysum;
				?>
				</tr>
				<tr >
				<?
				echo"<td>연장</td>";
				unset($sum11,$sum22,$sum33);
				for($i=1;$i<13;$i++){
					$countmember1="";
					$yunjangYear=$k;
					$kk = $i+1;

					$num2 = sprintf('%02d',$i);
					$numkk = sprintf('%02d',$kk);
					$tmpdate3=$yunjangYear.$num2."01";
					$tmpdate4=$yunjangYear.$numkk."01";
					
					$countmember_11 = get_db("
					SELECT count(uid)
					FROM shop_order
					WHERE goodsuid ='2'
					AND display = '1'
					AND orderstep = '2'
					AND d_bank >= '$tmpdate3'
					AND d_bank <= '$tmpdate4'
					AND ckind = 1
					AND buyfix = 0
					");

					$countmember_22 = get_db("
					SELECT count(uid)
					FROM shop_order
					WHERE goodsuid ='2'
					AND display = '1'
					AND orderstep = '2'
					AND d_bank >= '$tmpdate3'
					AND d_bank <= '$tmpdate4'
					AND ckind = 2
					AND buyfix = 0
					");

					

					$tsum2 = $countmember_11 + $countmember_22;
					echo"<td>$countmember_11 <font color=blue>$countmember_22</font><br>($tsum2)</td>";
					$sum11 = $sum11+$countmember_11;
					$sum22 = $sum22+$countmember_22;
					//$sumBrr[]= $countmember1;


				}
				//$sumBrr[$nn]=$sumBrr;
				$tysum2 = $sum11+$sum22;
				echo"<td>$sum11 <font color=blue>$sum22</font> <br>($tysum2)</td>";
				?>
				</tr>
				<!--
				<tr >
				<?
				echo"<td>합계</td>";

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

				?>
				</tr>
				-->

			<?
				$nujukTotal = $eekd+$tysum2;
				$nn++;
				}?>



		</table>
		<div class="page_list">
		입금회원 누적수 : <?=$nujukTotal?>
		<!--  prev/next_std >
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>




        <!--[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>";
?>