<?

 $NOWPAGE = "BANK";

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

// =============================================== Query

	$tableName = "bank_kwon";
	
	if(!$pageCount) $pageCount = 200;

	$show_one_page			= $pageCount;
	$show_view_page			= 10;   

	$page     = ( $page ) ? $page : 1;
	$offset   = ($page-1)*$show_one_page;
	
	$url_tail = "&act=$act&orderstep=$orderstep&key=$key&key_word=$key_word&key2=$key2&key_word2=$key_word2&goodsproduct=$goodsproduct&sort=$sort&sort_sc=$sort_sc";

	$query_limit  = "limit $offset,$show_one_page";
  
	$QUERY_TOTAL 	= "SELECT count(*) FROM $tableName";
	
	$QUERY_PAGE  = "SELECT * FROM $tableName order by no desc $query_limit";

	if($_SERVER["REMOTE_ADDR"] == "115.90.174.51"){
		//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();


?>
<script type="text/javascript" src="js/jquery-1.6.1.min.js"></script>
<script type="text/javascript" src="js/SimpleModal.min.js"></script>
<script>
	function SimpleModalClose(){
		SimpleModal.close();
		return;
	}
	
	
	function openmodal(fn){
		
		var bank_no    = fn;
		var new_text		 = $('#new_text_'+fn).val();
		var or_money  	= $('#or_money_'+fn).val();
		
		var mmodal_url = "bank_modal.php?mode=search&bank_no="+ bank_no +"&new_text="+ new_text +"&or_money="+ or_money;
		
		//alert(mmodal_url);
		SimpleModal.open(mmodal_url,'450','900');
	
	}
	
	
		function openmodal2(fn){
		
			var bank_no    = fn;
			var mmodal_url = "bank_modal.php?mode=edit&bank_no="+ bank_no;
		
		//alert(mmodal_url);
		SimpleModal.open(mmodal_url,'450','800');
	
	}
</script>


<div id="contents">
	<h2>입금 리스트</h2>

	<? include"bank_inc_who.php";  ?>

	<div id="content">
		<form name="form" id="search_order" name="search_order" method="post" enctype="multipart/form-data">
  <table summary="관리자모드 게시판입니다" cellspacing="0">
   <!--colgroup>
    <col width="50" />
    <col width="150" />
    <col width="90"/>
    <col width="150" />
    <col />
    <col width="80" />
    <col width="80" />
    <col width="80" />
   </colgroup-->
    <thead>
    <tr>
     <th>번호</th>
     <th>입금일</th>
     <th>몰라1</th>
     <th>텍스트(원본)</th>
     <th>텍스트(검색)</th>
     <th>인출액</th>
     <th>입금액</th>
     <!--th>합계</th -->
     <th>매칭번호(중복수)</th>
     <th>상태</th>
     <th>주문구분</th>
     <th>확인자</th>
     <th>확인일</th>     
    </tr>
   </thead>
   <tbody>

<?
	
	if(!$result) {
		error("DB_ERROR");
		exit;
	}
	
	
	if(!$total){
		//echo "<tr><td colspan='$colsNum' align=center height=50px>등록된 정보가 없습니다.</td></tr>";
		echo "<tr><td colspan='9' align=center height=50px>登録された情報がございませ</td></tr>";
	}else{
		for($i=0; $i<$total; $i++) {
		
			$row = mysql_fetch_array($result);
			
			//주문 관리에서 검색
			$query30 = mysql_query("SELECT uid, orderstep FROM shop_order WHERE orderid ='$row[new_text]' AND price = '$row[or_money]'",$db_con) or die (mysql_error());
			$row_query30 = mysql_fetch_array($query30);
			$total_query30 = mysql_affected_rows();
			$date2	=	str_replace("-",".",substr($row[date], 0, 10));				

			
			//입금DB_TABLE에 주문DB_TABLE  매칭을 위해 값을 전송...

			/*
			if(!$row[par_no] && $total_query30 > 0){
				
				$query31 = mysql_query("UPDATE 
																														$tableName
																												SET
																												  par_no = '$row_query30[uid]'		
																												WHERE	
																														no = '$row[no]'",$db_con) or die (mysql_error());
			}
		*/
			
	//상태값
	/*
	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="";
			}
	*/
	
	switch($row_query30[orderstep]){
			case "1":
				$flagName = "주문접수";
				break;
			case "2":
				$flagName = "입금완료";
				$flagColor="#FF0099";
				break;
			case "3":
				$flagName = "배송준비";
				$flagColor="#FF9955";
				break;
			case "4":
				$flagName = "상품발송";
				$flagColor="#F25745";
				break;
			case "5":
				$flagName = "배송완료";
				$flagColor="#2457BD";
				break;
			case "6":
				$flagName = "주문취소";
				$flagColor="#cccccc";
				break;
			case "7":
				$flagName = "환불요청";
				$flagColor="#fff0";
				break;
			case "8":
				$flagName = "환불완료";
				$flagColor="#865F00";
			break;
			default:
			
					switch($row[par_check]){
						case("N"):
							$flagName = "미처리(N)";
							$flagColor="#FFFFFF";
						break;
						case("C"):
							$flagName = "환불(N)";
							$flagColor="#865F00";
						break;
						case("M"):
							$flagName = "입금완료";
							$flagColor="#FF0099";
						break;
						case("O"):
							$flagName = "입금완료";
							$flagColor="#FF0099";
						break;
						default:
							$flagName = "$row[par_check] ERORR!!";
						break;
					}			

			break;
		}
		
				
	//주문구분
	switch($row[par_check]){
		case("N"):
		 $PAR_CHECK = "<a href='javascript:openmodal2($row[no])'><strong>미처리(N)</strong></a>";
		break;
		case("C"):
		 $PAR_CHECK = "환불(N)";
		break;
		case("M"):
			$PAR_CHECK = "<a href='javascript:openmodal2($row[no])'><strong>회원(M)</strong></a>";
		break;
		case("O"):
			$PAR_CHECK = "주문(O)";
		break;
		default:
			$PAR_CHECK = "$row[par_check] ERORR!!";
		break;
	}


	if($row[or_money] == "5500"){   
	
	 	$row_or_money = "<span style='color:red;'><strong>$row[or_money]</strong></span>";
	
	}else{ 
	
			$row_or_money = "$row[or_money]";
	
	}


?>
			<tr>
				<td><?=$row[no]?></td>
				<td><?=$row[or_date]?></td>
				<td><span style="letter-spacing:-1px;"><?=$row[or_code1]?></span></td>
				<td><span style="letter-spacing:-1px;"><?=$row[or_text]?></span></td>
				<td>
    <!--<?=$row[new_text]?>-->
     <input type="text" 		name="new_text_<?=$row[no]?>" id="new_text_<?=$row[no]?>" value="<?=$row[new_text]?>">
     <input type="hidden" name="or_money_<?=$row[no]?>" id="or_money_<?=$row[no]?>" value="<?=$row[or_money]?>">
    <a href="javascript:openmodal(<?=$row[no]?>);"><strong>검색</strong></a>
    <!-- a onclick="SimpleModal.open('bank_modal.php?mode=search&new_text=<?=$row[new_text]?>&or_money=<?=$row[or_money]?>','450','450')"; class="link_kwon" ><?=$row[new_text]?></a --></td>
				<td><?=$row[or_code2]?></td>
				<td><?=$row_or_money ?></td>
				<!--td><?=$row[or_tmoney]?></td -->
				<td><?=$row[par_no]?> &nbsp; (<?=$total_query30?>)</td>
    <td bgcolor="<?=$flagColor?>"><span style='color:#FFF;'><?=$flagName?></span></td>
				<td><?=$PAR_CHECK?></td>				
    <td><?=$row[admin_id]?></td>
				<td><?=$date2?></td>
			</tr>
<?
		$Num--;
		}
	}
?>
		</tbody>
	</table>
 </form>
	<!--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>
 	</div>
	</div>
</body>
</html>