<?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 = 'member_detail.php';
	f.submit();
}

function go_View2(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/authdel_proc.php';
		f.submit();
	}
}

function searchChk() {
	//검색
	if(document.F_search.key_word2.value && !document.F_search.key2.value){
		alert("2차검색이 없습니다.");return false;
	}
	document.F_search.action = "<?=$php_self?>";
	document.F_search.submit();
}

function StatusScript(flag,id) {
	var form = document.form;
	var flagName;
		form.idx.value = id;
		form.flag.value = flag;

	switch(flag){
		case "1":
			flagName = "주문접수\'으로";break;
		case "2":
			flagName = "입금완료\'으로";break;
		case "3":
			flagName = "배송준비\'로";break;
		case "4":
			flagName = "상품발송\'로";break;
		case "5":
			flagName = "배송완료\'로";break;
		case "6":
			flagName = "주문취소\'로";break;
		case "7":
			flagName = "환불요청\'로";break;
		case "8":
			flagName = "환불완료\'로";break;

	}
	var choose = confirm("\'"+flagName+" 수정하시겠습니까?");

	if(choose){
		form.action = "./Proc/authcode_proc.php";
		form.submit();
	}
	else{
		return;
	}

}
</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 == "A.d_bank"){
			$where = " AND $key like '%".$key_word."%' ";
			if($orderstep){
				$where .=" and A.orderstep='$orderstep' ";
			}
		}else{
			$key_word = trim($key_word);
			//$where = " AND UPPER(".$key.") like '%".strtoupper($key_word)."%' ";
			$where = " AND ".$key." like '%".$key_word."%' ";
		}

	}else{

		if($orderstep){
			$where .=" and A.orderstep='$orderstep' ";
		}
	}

	if($key_word2){
		$key_word = trim($key_word);
		$where .= " AND $key2 like '%".$key_word2."%' ";
	}
	if($deli){
		$where .=" and A.tack_after ='$deli' ";
	}
	if($selStatus){
		if($selStatus != "all") $where .= "AND A.orderstep='$selStatus'";
	}
	if($selckind){
		if($selckind != "all") $where .= "AND A.ckind='$selckind'";
	}


	//order by
	if($sort){
		$order_by = ' ORDER BY '.$sort.' '.$sort_sc;
	}else{
		if($orderstep==1) $order_by = ' ORDER BY A.uid desc';
		else if($orderstep >= 2) $order_by = ' ORDER BY A.d_bank desc';
		elseif($key_word){
			$order_by = ' ORDER BY A.orderstep asc';
		}else{
			$order_by = ' ORDER BY A.uid desc';
		}
	}
	if($act==6) $where .="and display=1 and A.buyfix in (1,2)";
	else $where .="and display=1 and buyfix=0"; //회원정보만 display:1 ,카드결제 buyfix 1이면 안보이게 삭제되거나 결제될 데이터

	$url_tail = "&act=$act&orderstep=$orderstep&key=$key&key_word=$key_word&key2=$key2&key_word2=$key_word2&deli=$deli&sort=$sort&sort_sc=$sort_sc&selStatus=$selStatus&selckind=$selckind";

	$query_limit  = "limit $offset,$show_one_page";

	$QUERY_TOTAL = "SELECT count(*) FROM shop_$tableName A ,user C WHERE A.mbruid = C.id $where $order_by";


	$QUERY_PAGE  = "SELECT A.*,C.* FROM shop_order A,user_cash C WHERE A.uid = C.order_uid $where $order_by $query_limit";
	if($_SERVER["REMOTE_ADDR"] == "110.12.8.160"){
		//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>입금회원관리</h2>
	<div id="content">
		<?include "./membertab.html"?>

	<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?>">
				<select name='key'>
					<option value='A.orderid' <?if($key == 'A.orderid'){ echo "selected";}?>>예약번호</option>
					<option value='C.userid' <?if($key == 'C.userid'){ echo "selected";}?>>id</option>
					<option value='o_name' <?if($key == 'o_name'){ echo "selected";}?>>주문자</option>
					<option value='A.price' <?if($key == 'A.price'){ echo "selected";}?>>금액</option>
					<option value='o_email' <?if($key == 'o_email'){ echo "selected";}?>>email</option>
					<option value='A.d_bank' <?if($key == 'A.d_bank'){ echo "selected";}?>>입금일자</option>
				</select>
				<input type="text" name="key_word" size="17" value="<?echo $key_word?>"  ONKEYPRESS="if (event.keyCode==13) searchChk();">
				<select name='key2'>
					<option value=''>선택</option>
					<option value='orderid' <?if($key2 == 'A.orderid'){ echo "selected";}?>>예약번호</option>
					<option value='C.userid' <?if($key2 == 'C.userid'){ echo "selected";}?>>id</option>
					<option value='o_name' <?if($key2 == 'o_name'){ echo "selected";}?>>주문자</option>
					<option value='A.price' <?if($key2 == 'A.price'){ echo "selected";}?>>금액</option>
					<option value='o_email' <?if($key2 == 'o_email'){ echo "selected";}?>>email</option>
				</select>
				<input type="text" name="key_word2" size="17" value="<?echo $key_word2?>"  ONKEYPRESS="if (event.keyCode==13) searchChk();">
				<select name="selckind">
				<option value="all"	<?if($selckind == "all")	echo "selected"; ?>>지불선택</option>
				<option value="1"	<?if($selckind == "1")	echo "selected"; ?>>무통장</option>
				<option value="2"	<?if($selckind == "2")	echo "selected"; ?>>카드</option>
				
				</select>
				<select name="selStatus">
				<option value="all"	<?if($selStatus == "all")	echo "selected"; ?>>상태선택</option>
				<option value="1"	<?if($selStatus == "1")	echo "selected"; ?>>대기</option>
				<option value="2"	<?if($selStatus == "2")	echo "selected"; ?>>완료</option>
				</select>
				<select name='sort'>
					<option value=''>작성일</option>
					<option value='C.userid' <?if($sort == 'C.userid'){ echo "selected";}?>>ID</option>
					<option value='A.o_name' <?if($sort == 'A.o_name'){ echo "selected";}?>>주문자</option>
					<option value='A.d_regis' <?if($sort == 'A.d_regis'){ echo "selected";}?>>주문일자</option>
					<option value='A.d_bank' <?if($sort == 'A.d_bank'){ echo "selected";}?>>입금일자</option>
				</select>
				<select name='sort_sc'>
					<option value='desc'>올림차순</option>
					<option value='asc' <?if($sort_sc == 'asc'){ echo "selected";}?>>내림차순</option>
				</select>
				<input type="button" value="search" class="button" onclick="Javascript:searchChk()">
				<input type="button" value="reset" class="button" onclick="Javascript:location.replace('./memberlist1.php?act=<?=$act?>');">


				<!--
				<?if($_SERVER["REMOTE_ADDR"] == "115.90.174.52"){?>
				&nbsp;&nbsp;<a href='./Proc/authdel_proc.php?mode=alldel&act=<?=$act?>>'>[개발자 삭제]</a>
				<?}?>
				-->

				<!--
				<font color=red>*빨간색 예약번호는 <b>리나</b>주임에게 주세요!</font>
				-->
	</form>


	<table summary="관리자모드 게시판입니다" cellspacing="0" style="width:100%">
 		<thead>
			<tr>
				<th>No</th>
				<th>예약번호</th>
				<th>ID</th>
				<th>주문자(일어)</th>
				<th>주문자(한문)</th>
				<!--<th>주문자(영문)</th>-->
				<th>상품정보</th>
				<th>지불방법</th>
				<th>금액</th>
				<!--<th>주문일자</th>-->
				<th>시작일</th>
				<th>마감일</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="m">
<input type="hidden" name="idx" value="">
<input type="hidden" name="flag" value="">
<input type="hidden" name="goodsproduct" value="<?=$goodsproduct?>">

</form>
<?

	if(!$result) {
		error("DB_ERROR");
		exit;
	}


	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center height=50px>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan='16' align=center height=50px>登録された情報がございませ</td></tr>";
	}else{
		for($i=0; $i<$total; $i++) {

			$row = mysql_fetch_array($result);
			$contents = explode("</p>",$row[contents]);
			$regdate = substr($row[d_regis],0,4)."-".substr($row[d_regis],4,2)."-".substr($row[d_regis],6,2);
			if($row[d_bank]) $bankdate = substr($row[d_bank],0,4)."-".substr($row[d_bank],4,2)."-".substr($row[d_bank],6,2);
			else $bankdate="";
			$subject= stripslashes($row[name]);
			if($row[orderstep]==2){
				$flagColor="#FF0099";
			}else if($row[orderstep]==3){
				$flagColor="#FF9955";
			}else if($row[orderstep]==4){
				$flagColor="#F25745";
			}else if($row[orderstep]==5){
				$flagColor="#2457BD";
			}else if($row[orderstep]==6){
				$flagColor="#cccccc";
			}else if($row[orderstep]==7){
				$flagColor="#fff0";
			}else if($row[orderstep]==8){
				$flagColor="#865F00";
			}else{
				$flagColor="";
			}
			$orderCode ="";
			$orderCodeLeng= strlen($row[orderid]);
			$orderCode = substr($row[orderid],0,-7)."<span style='color:#2c8400'>".substr($row[orderid],-7)."</span>";

			//지불방법
			if($row[ckind] == 1) $ckind_name = "무통장";
			elseif($row[ckind] == 2) $ckind_name = "카드";
			elseif($row[ckind] == 3) $ckind_name = "편의점";

				//$orderCodes = $row[orderid];
?>
			<tr>
				<td><?=$Num?></td>
				<td><b><a href="javascript:go_View2(<?=$row[uid]?>);"><?=$orderCode?></a></b></td>
				<td><a href="javascript:go_View(<?=$row[mbruid]?>);"><?=$row[userid]?></a></td>
				<td><?=$row[o_name]?></td>
				<td><?=$row[ccname]?></td>
				<!--<td><?=$row[ecname]?></td>-->
				<td>
				<?$reqry = "select * from shop_ordergoods where parent='$row[uid]'";
					$resub= mysql_query($reqry,$db_con);
					while($rows=mysql_fetch_array($resub)){
				?>
				<?=$rows[goodsname]?><br/>
				<?}?>
				</td>
				<td><?=$ckind_name?></td>
				<td><b><?=number_format($row[price])?> 円</b></td>

				<!--<td><?=$regdate?></td>-->
				
				<td><?=$row[startdate]?></td>
				<td><?=$row[enddate]?></td>
				<td><?=$bankdate?></td>
				<td><?=$row[inning]?></td>
				<td bgcolor="<?=$flagColor?>">
					<select name="status" id="status" onChange="javascript: StatusScript(this.value,'<?=$row[uid]?>');">
						<option <? if($row[orderstep] == '1') { echo 'selected'; } ?> value='1'>주문접수</option>
						<option <? if($row[orderstep] == '2') { echo 'selected'; } ?> value='2'><font color='red'>입금완료</font></option>
						<!--<option <? if($row[orderstep] == '3') { echo 'selected'; } ?> value='3'><font color='red'>배송준비</font></option>
						<option <? if($row[orderstep] == '4') { echo 'selected'; } ?> value='4'><font color='red'>상품발송</font></option>
						<option <? if($row[orderstep] == '5') { echo 'selected'; } ?> value='5'><font color='red'>배송완료</font></option>
						<option <? if($row[orderstep] == '6') { echo 'selected'; } ?> value='6'><font color='red'>주문취소</font></option>
						<option <? if($row[orderstep] == '7') { echo 'selected'; } ?> value='7'><font color='red'>환불요청</font></option>
						<option <? if($row[orderstep] == '8') { echo 'selected'; } ?> value='8'><font color='red'>환불완료</font></option>-->
					</select>
					<!--<a href="javascript:openMail('<?=$row[idx]?>');">[Mail]</a>
					<a href="javascript:go_Modify(<?=$row[uid]?>);"><img src="./images/check.png" alt="" /></a>-->
				</td>
				<td>
				<?//if($row[ckind]==1 && $row[orderstep]==1){?>
				<a href="javascript: go_Delete(<?=$row[uid]?>);"><img src="./images/out.png" alt="" /></a>
				<?//}?>
				</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>
	*예약번호를 누르면 상세보기가 나옴.<br>
	*id를 누르면 회원정보가 나옴.<br>
	*삭제하기전에 회원정보 시작일 마감일을 꼭 확인하여주세요.
 	</div>
	</div>
<p></p>
</body>
</html>