카테고리 없음2009. 10. 16. 16:51

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page contentType="text/html; charset=euc-kr" errorPage="/error.jsp" %>
<%@ page import="java.util.Properties" %>
<%@ page import="com.em.http.Transaction" %>
<%@ page import="com.em.Util" %>
<%@ page import="com.em.util.*" %>
<%@ page import="com.em.Configuration" %>
<%@ page import="kis.customer.event.BankisFundEvtHome" %>
<%@ include file = "/common/Base64Utils.jsp" %>
<%!
public String altText(String present)
{
 if(Util.equals("0",present)){
  return "트랜스포머 아트북";
 } else if(Util.equals("1",present)){
  return "참치 선물세트";
 } else if(Util.equals("2",present)){
  return "여름휴가용품";
 } else{
  return "";
 }
}
%>
<%  
 String fromDate = "";
 String toDate = "";
 String searchColumn = "";
 String searchValue = "";
 
 int currentPage = 1;
 int rowsPerPage = 10;

 int totalCount = 0;
 Properties[] list = null;

 Properties searchData = new Properties();
 Transaction tr = new Transaction(pageContext);
 BankisFundEvtHome bankHome = new BankisFundEvtHome(tr);
 try {
  tr.open();

  fromDate = Util.normalize(tr.req.getParameter("fromDate"), Util.toString(Util.toInteger(Util.getYear()) - 1) + "-" + Util.getMonth() + "-" + Util.getDay());
  toDate = Util.normalize(tr.req.getParameter("toDate"), Util.getYear() + "-" + Util.getMonth() + "-" + Util.getDay());

  searchColumn = Util.normalizeNull(tr.req.getParameter("searchColumn"));
  searchValue = Util.normalizeNull(tr.req.getParameter("searchValue"));
  
  currentPage = Util.parseInt(tr.req.getParameter("currentPage"), 1);  
  
  searchData.setProperty("fromDate",fromDate);
  searchData.setProperty("toDate",toDate);
  searchData.setProperty("searchColumn",searchColumn);
  searchData.setProperty("searchValue",searchValue);
  
  totalCount = bankHome.selectCount(searchData);
  list = bankHome.selectList(searchData, currentPage, rowsPerPage);
 } catch (Exception e) {
  tr.rollback(e);
 } finally {
  tr.close();
 }
%>

<html>
<head>
<META HTTP-EQUIV="Content-Type" Pragma="no-cache" Cache-control="no-cache" CONTENT="text/html; charset=euc-kr">
<title></title>
<link rel="StyleSheet" type="text/css" href="/admin/common/css/common.css">
<SCRIPT language="JavaScript" type="text/javascript" src="/admin/common/js/common.js"></SCRIPT>
<STYLE TYPE="text/css">
 input.calendar { behavior:url(/library/calendar.htc); }
</STYLE>

<script language="Javascript">
<!--

function doSearch() {
 var f = document.searchForm;
 f.submit();
}

function doWrite(userNm, phoneNo, juminNo) {
 var f = document.searchForm;

 f.target = '_self';
 f.mode.value='update';
 f.user_nm.value = userNm;
 f.phone_no.value = phoneNo;
 f.jumin_no.value = juminNo;
 
 f.action = "bankis_event_write.jsp"
 f.submit();
}

function doExcel() {
 var f = document.pagingForm;

 f.target = 'hidden_ifm';
 f.action="bankis_event_excel.jsp";
 f.submit();
}
//-->
</script>
</head>

<body>

<h1>뱅키스 펀드가입 이벤트 목록</h1>
<div class="boxSet01" style="padding:11 19 11 19;margin-bottom:10px;">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
 <form name="searchForm" method="post">
 <input type="hidden" name="mode">
 <input type="hidden" name="num">
 <input type="hidden" name="user_nm">
 <input type="hidden" name="phone_no">
 <input type="hidden" name="jumin_no">
 <input type="hidden" name="searchValue2" value="<%=Base64_ENC(searchValue) %>">
 <tr>
  <td width="45" class="c"><b>* 기간</b></td>
  <td width="120" class="c">
  <INPUT TYPE="TEXT" NAME="fromDate" VALUE="<%=fromDate%>"
   STYLE="height:20;width:100;"
   STYLE="border-right-width:0;text-align:center;padding-left:3px; padding-right:3px; height:20; font-family:Verdana; padding-top:3px; padding-bottom:3px; font-size:11px; border:1px; border-style:solid; border-color:#D7D3C8;line-height: 110%; color:#636361" STYLE="ime-mode:disabled;" ONKEYPRESS="if(((event.keyCode&lt;48)||(event.keyCode&gt;57))&&(event.keyCode!=45)&&(event.keyCode!=126)&&(event.keyCode!=13))event.returnValue=false;"
   CLASS="calendar"
   MAXLENGTH="10"
   READONLY >
  </td>
  <td width="20" class="c">&nbsp;~</td>
  <td width="120" class="c">
  <INPUT TYPE="TEXT" NAME="toDate" VALUE="<%=toDate%>"
   STYLE="height:20;width:100;"
   STYLE="border-right-width:0;text-align:center;padding-left:3px; padding-right:3px; height:20; font-family:Verdana; padding-top:3px; padding-bottom:3px; font-size:11px; border:1px; border-style:solid; border-color:#D7D3C8;line-height: 110%; color:#636361" STYLE="ime-mode:disabled;" ONKEYPRESS="if(((event.keyCode&lt;48)||(event.keyCode&gt;57))&&(event.keyCode!=45)&&(event.keyCode!=126)&&(event.keyCode!=13))event.returnValue=false;"
   CLASS="calendar"
   MAXLENGTH="10"
   READONLY >
  </td>
  <td width="70" align="right">   
  <select name="searchColumn">
   <option value="" <%=searchColumn.equals("") ? "selected" :""%>>전체</option>
   <option value="1" <%=searchColumn.equals("1") ? "selected" :""%>>고객명</option>
   <option value="2" <%=searchColumn.equals("2") ? "selected" :""%>>주민번호</option>
   <option value="3" <%=searchColumn.equals("3") ? "selected" :""%>>전화번호</option>
  </select>
  </td>
  <td><input type="text" class="box01" style="width:100%;" name="searchValue" value="<%=searchValue%>"></td>
  <td width="55" align="right"><input type="button" value="검색" class="btn01" style="width:50px" style="cursor:hand;" onclick="doSearch()"></td>
  <td width="55" align="right"><input type="button" value="엑셀" class="btn01" style="width:50px" style="cursor:hand;" onclick="doExcel()"></td>
 </tr>
 </form>
</table>
</div>

<div class="boxSet01" style="padding:0 5 5 5;">
<table width="100%" cellpadding="0" cellspacing="0" border="0">
 <!-- <col width="20" />
 <col />
 <col width="120" />
 <col width="120" />
 <col width="100" /> -->
 <tr class="titleTr">
  <td></div><div class="td"><b>번호</b></div></td>
  <td><div class="bar"></div><div class="td"><b>신청일</b></div></td>
  <td><div class="bar"></div><div class="td"><b>고객명</b></div></td>
  <td><div class="bar"></div><div class="td"><b>주민번호</b></div></td>
  <td><div class="bar"></div><div class="td"><b>전화번호</b></div></td>
  <td><div class="bar"></div><div class="td"><b>주소</b></div></td>
  <td><div class="bar"></div><div class="td"><b>신청<br>사은품</b></div></td>
  <td><div class="bar"></div><div class="td"><b>진행지점</b></div></td>
  <td><div class="bar"></div><div class="td"><b>사은품 <br>배송여부</b></div></td>
 </tr>
 <%
 if (list != null) {
  for (int i=0; i<list.length; i++) {
 %>
 <tr class="dataTr">
  <td class="first data">
   <div class="td"><%= (totalCount - ((currentPage - 1) * 10)) - i %></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td"><%=Util.normalizeNull(list[i].getProperty("REG_DATE2"))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td"><a href="javascript:doWrite('<%=Util.normalizeNull(list[i].getProperty("USER_NM"))%>','<%=Util.normalizeNull(list[i].getProperty("PHONE_NO"))%>','<%=Util.normalizeNull(list[i].getProperty("JUMIN_NO"))%>');"><%=Util.normalizeNull(list[i].getProperty("USER_NM"))%></a></div> 
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td"><%=Util.normalizeNull(list[i].getProperty("JUMIN_NO"))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td"><%=Util.normalizeNull(list[i].getProperty("PHONE_NO"))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td left"><%=Util.normalizeNull(list[i].getProperty("ADDRESS"))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td left"><%=altText(Util.normalizeNull(list[i].getProperty("PRESENT")))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td left"><%=Util.normalizeNull(list[i].getProperty("BRANCH"))%></div>
  </td>
  <td class="data">
   <div class="bar"></div>
   <div class="td"><%=Util.normalizeNull(list[i].getProperty("PRESENT_FLAG"))%></div>
  </td>        
 </tr>
 <%
  }
 }
 if (Util.equals(0, list.length)) {
 %>
 <tr class="dataTr">
  <td class="first data" colspan='9'><div class="bar"></div><div class="td">해당 내용이 없습니다.</div></td>
 </tr>
 <%
 }
 %>
</table>
</div>

<form name="pagingForm" method="post">
 <input type="hidden" name="currentPage">
 <input type="hidden" name="searchColumn" value="<%=searchColumn%>">
 <input type="hidden" name="searchValue" value="<%=searchValue%>"> 
 <input type="hidden" name="searchValue2" value="<%=Base64_ENC(searchValue) %>">
</form>

<script language="Javascript">
function setPage(_currentPage) {
 var f = document.pagingForm;
 f.currentPage.value = _currentPage;
}

function doSubmit() {
 var f = document.pagingForm;
 f.target = '_self';
 f.action = 'bankis_event_list.jsp';
 f.submit();
}
</script>

<jsp:include page="/admin/include/paging.jsp" flush="true">
 <jsp:param name="currentPage" value="<%=currentPage%>" />
 <jsp:param name="totalCount" value="<%=totalCount%>" />
</jsp:include>
<iframe name="hidden_ifm" width="0" height="0" border=0  ></iframe>
</body>
</html>

Posted by penguindori