<?include $_SERVER['DOCUMENT_ROOT']."/admin/adminTopMenu.html";?>

<script type="text/javascript" src="./js/Calendar_cash.js"></script>

<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,cid,mid,mcode) {
		var choose = confirm("修正しましょうか?");
		if(choose){
			document.form.idx.value = cid;
			document.form.midx.value = mid;
			document.form.mCode.value = mcode;
			document.form.mode.value = status;
			document.form.action = "/admin/Proc/price_proc.php";
			document.form.submit();
		}
	}
function memochk(cid){
	var choose = confirm("修正しましょうか?");
	if(choose){
	document.form.idx.value = cid;
	document.form.action = "/admin/Proc/memo_proc.php";
	document.form.submit();
	}
}

function go_View(member_srl) {
	var f = document.form;
	f.idx.value = member_srl;
	f.action = 'member_detail.php';
	f.submit();
}
function go_Modify(member_cash_srl) {
	var f = document.form;
	f.idx.value = member_cash_srl;
	f.action = 'member_cash_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/cash_member_proc.php';
		f.submit();
	}
}
function searchChk() {
	//검색
	document.form.action = "./memberlist1.php";
	document.form.submit();
}
</script>
<?
	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 == "jcname" || $key == "ccname" || $key == "ecname"){
			//$key_word = str_replace(" ","",$key_word);
			$where = "AND UPPER(".$key.") like '%".$key_word."%' ";



		}else{
			$key_word = str_replace(" ","",$key_word);
			$where = "AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
		}

	}
	if($key2){
		if($key2 != "all") $where .= "AND flag='$key2'";
	}
  if($start_date && $end_date){
		$where .=" and admin_date >='$start_date' and  admin_date <='$end_date'";
		//$where .=" and id not like '%16%' ";
		$order_by = ' ORDER BY flag asc,admin_date desc';
	}else{
	$order_by = ' ORDER BY flag asc,id DESC';
	}





	if($sort == '1'){
		$order_by = ' ORDER BY m_enddate asc';
	}
	 if($sessionID =="cjesent"){
		//$where .=" and id not like '2%' and id not like '8%'";
		$where .=" and id not like '7%'  and id not like '8%'";
	}

	$url_tail = "&act=$act&start_date=$start_date&end_date=$end_date&key=$key&key2=$key2&key_word=$key_word&order_by=$order_by&sort=$sort";
	$query_limit  = "limit $offset,$show_one_page";
	$total_count  = get_db("SELECT count(*) FROM user_cash where 1=1 $where $CoWhere $order_by");
	$QUERY_PAGE  = "SELECT * FROM user_cash where 1=1 $where $CoWhere $order_by $query_limit";
	//if($_SERVER["REMOTE_ADDR"] == $remoteAddr){
		echo $QUERY_PAGE."<br>";
	//}
	$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>결제회원정보</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="act" value="<?=$act?>">
		<input type="hidden" name="midx">
		<input type="hidden" name="page" value="<?=$page?>">
		<input type="hidden" name="mCode">
		<input type="hidden" name="mode">
		<fieldset>
			<select name="key">
				<option value="userid"	<?if($key == "userid")	echo "selected"; ?>>ID</option>
				<option value="jcname"	<?if($key == "jcname")	echo "selected"; ?>>名前（カタカナ）</option>
				<option value="ecname"	<?if($key == "ecname")	echo "selected"; ?>>名前（ローマ字)</option>
				<option value="ccname"	<?if($key == "ccname")	echo "selected"; ?>>名前 ( 漢字 )</option>
				<option value="inning"	<?if($key == "inning")	echo "selected"; ?>>회차</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();">

			<!--추가 날짜 선택-->
				<img src="http://www.lookkorea.jp/event/v21_mwave/img/calendar.gif"/>
				<input type="text" name="start_date" size="17" value="<?echo $start_date?>" onclick="createCalendarDiv(document.all.start_date)">
				~
				<input type="text" name="end_date" size="17" value="<?echo $end_date?>" onclick="createCalendarDiv(document.all.end_date)">
				<!--추가 날짜 선택-->
			<select name="key2">
				<option value="all"	<?if($key2 == "all")	echo "selected"; ?>>all</option>
				<option value="A"	<?if($key2 == "A")	echo "selected"; ?>>대기</option>
				<option value="D"	<?if($key2 == "D")	echo "selected"; ?>>완료</option>

			</select>
			<input type="button" value="검색"class="btn_blue" onClick="searchChk();" />
			<input type="button" value="취소" class="btn_blue" onClick="location.href='./memberlist1.php?act=<?=$act?>';" />
		</fieldset>

			<!--엑셀로 다운 받기
			<select name="group_srl">
				<option value="3">정회원</option>
				<option value="2">결제대기회원</option>
			</select>
			<input type="text" name="startdate"/> ~ <input type="text" name="enddate" /> ex)2012-01-01
			<input type="submit" value="다운로드" class="btn_blue"/>
		</fieldset>
		</form>-->
		<table class="member" summary="관리자모드 게시판입니다" cellspacing="0">

			<thead>
				<tr>
					<th>No</th>
					<th>아이디</th>
					<th>이름(영문)</th>
					<th>일어</th>
					<th>한문</th>
					<th>상태</th>
					<th>체크</th>
					<th>신청일</th>
					<th>유료시작일</th>
					<th>유료마감일</th>
					<th>입금완료일</th>
					<th>회차</th>
					<th>ACTION</th>
				</tr>
			</thead>
			<tbody>

				<?
				if(!$total){
					echo "<tr><td colspan='11' align=center  height='50px'>登録された情報がございません</td></tr>";
				}else if(($sessionLevel == 3 || $sessionLevel == "") && ($tabs==4 || $tabs==6 || $tabs==7)){
					echo "<tr><td colspan='11' align=center  height='50px'>$membersJapansName</td></tr>";
				}else{
					for($i=0; $i<$total; $i++) {

						$Num = $start_num - $i;
						$row = mysql_fetch_array($result);
						$created = substr($row[created],0,10);
						$admin_date = substr($row[admin_date],0,10);
						$resub = Get_dbres("select id,member_code,mChk from user where id = '$row[user_id]'");
						$rows	= mysql_fetch_array($resub);
						if($rows[mChk] == 1){
							$bgColor ="#dddddd";
						}else{
							$bgColor ="#ffffff";
						}

						if($row[flag] == 'D'){
							$stateColor ="#FF0099";
						}else{
							$stateColor ="#ffffff";
						}
				?>
				<tr bgcolor="<?=$bgColor?>">
					<td><?=$Num?></td>
					<td><a href="javascript:go_View('<?=$rows[id]?>');"><?=$row[userid]?></a></td>
					<td><?=$row[ecname]?></td>
					<td><?=$row[jcname]?></td>
					<td><?=$row[ccname]?></td>
					<td bgcolor="<?=$stateColor?>">
						<?
						if($row[auth_code] == 15){
							echo"管理者";
						}else{?>
						<select name="status" onChange="javascript:StatusScript(this.value,'<?=$row[id]?>','<?=$rows[id]?>','<?=$rows[member_code]?>');" <?//if($_SERVER["REMOTE_ADDR"] != $remoteAddr){echo" disabled='true'";}?>>
							<!--option <? if($row[auth_code] == '15') { echo 'selected'; } ?> value='15'>관리자</option-->
							<option <? if($row[flag] == 'A') { echo 'selected'; } ?> value='A'><font color='red'>대기</font></option>
							<option <? if($row[flag] == 'D') { echo 'selected'; } ?> value='D'><font color='red'>완료</font></option>
						</select>
						<?}?>
					</td>
					<td><input type="checkbox" name="mChk" value="1" onclick="memochk('<?=$rows[id]?>')" <?if($rows[mChk] == 1){echo "checked";}?>></td>
					<td><?=$row[reg_date]?></td>
					<td><?=$row[startdate]?></td>
					<td><b><?=$row[enddate]?></b></td>
					<td ><b><font color=blue><?=$admin_date?></font></b></td>
					<td><?=$row[inning]?></td>
					<td><a href="javascript:go_Modify(<?=$row[id]?>);"><img src="./images/check.png" alt="" /></a>&nbsp;&nbsp;<a href="javascript:go_Delete(<?=$row[id]?>);"><img src="./images/out.png" alt="" /></a></td>
				</tr>
				<?
					$Num--;
					}
				}
				?>
			</tbody>
		</table>
		<div class="page_list">
		<!--  prev/next_std -->
		<?=$viewlist2?>
		<!--  prev/next_end -->
		</div>
	</div>
</div>
<p></p>
</body>
</html>