<%@ page import="loveenjoy.point.*,loveenjoy.myroom.*,loveenjoy.lovefile.*,loveenjoy.mypoint.*,loveenjoy.meetingroom.*,loveenjoy.member.*,loveenjoy.util.*,java.sql.*,java.net.*,javax.sql.*,javax.naming.*,java.text.*,java.util.*,java.io.*,javax.servlet.*,javax.servlet.http.*" contentType="text/html; charset=KSC5601"%> <% //if(CookieUtils.getCookieValue("USERID", request) == null){ // response.sendRedirect("http://loveenjoy.ddaza.com/ranking/index_nologin.jsp"); //} %> <%@ include file="/include/top/meetinginfo.jsp"%> <%@ include file="/include/top/info_top.jsp"%> <% Connection logconn = null; try{ Context env = (Context) new InitialContext().lookup("java:comp/env"); DataSource source = (DataSource) env.lookup("jdbc/enjoylog"); logconn = source.getConnection(); loveenjoy.log.EnjoyLog enjoylog = new loveenjoy.log.EnjoyLog(logconn); SimpleDateFormat sdf1 = new SimpleDateFormat("yyyyMM"); enjoylog.insertEnjoyLog(userId , "ranking" , "ÀÎ±â¼øÀ§ ¿­¶÷" , sdf1.format(new java.util.Date())); logconn.close(); }catch(Exception e){ //out.println(e); }finally{ try{ if(logconn != null) logconn.close(); }catch(SQLException se){} } %> <% SimpleDateFormat sdf1 = new SimpleDateFormat("dd"); SimpleDateFormat sdf2 = new SimpleDateFormat("HHmm"); java.util.Date nowdate = new java.util.Date(); if((sdf1.format(nowdate)).equals("01") && Integer.parseInt(sdf2.format(nowdate)) >= 0 && Integer.parseInt(sdf2.format(nowdate)) <= 800) { %> <% } else { %> <% } %>
<%@ include file = "/ranking/inc_rank.jsp"%> <% Connection pointconn = null; Connection userconn = null; Hashtable monthRanking = null; try{ Context env = (Context) new InitialContext().lookup("java:comp/env"); DataSource source = (DataSource) env.lookup("jdbc/enjoy"); DataSource pointsource = (DataSource) env.lookup("jdbc/enjoypoint"); userconn = source.getConnection(); pointconn = pointsource.getConnection(); UserInfo userinfo = new UserInfo(userconn); EnjoyPointLog enjoypointlog = new EnjoyPointLog(pointconn); monthRanking = enjoypointlog.getEnjoyPointMonthRanking(); EnjoyPointBean enjoypointbean = null; %> <% pointconn.close(); userconn.close(); }catch(Exception e){ out.println(e); try{ if(userconn != null) userconn.close(); if(pointconn != null) pointconn.close(); }catch(SQLException se){} } %>
ÃßõÆ÷ÀÎÆ®¸¦ ´Þ¶ó°í Á¹¶óº¸¼¼¿ä
<% NumberFormat num_format = NumberFormat.getInstance(); enjoypointbean = (EnjoyPointBean)monthRanking.get("1"); EnjoyPointLogBean enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); UserInfoMeetingBean usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); String genderImage = ""; if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=num_format.format(enjoypointlogbean.getJungYudo())%> P 
<%=num_format.format(enjoypointlogbean.getLoveFile())%> P 
<%=num_format.format(enjoypointlogbean.getAlbum())%> P 
<%=num_format.format(enjoypointlogbean.getMovie())%> P 
<%=num_format.format(enjoypointbean.getGiftPoint())%> P 
<%=enjoypointbean.getUserId()%>
 (<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>¼¼)
 
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("2"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("3"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("4"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("5"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("6"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("7"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("8"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("9"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
<% enjoypointbean = (EnjoyPointBean)monthRanking.get("10"); enjoypointlogbean = enjoypointlog.getEnjoyPointMonthLog(enjoypointbean.getUserId()); usermeetingbean = userinfo.userMeetingInfo(enjoypointbean.getUserId()); if(usermeetingbean.getUsex() == 1) { genderImage = "man"; } else genderImage = "woman"; %>
<%=enjoypointbean.getUserId()%>
(<%=getRegiLocation(usermeetingbean.getBigCode())%>/<%=usermeetingbean.getUage()%>)
  Çö±ÝÆ÷ÀÎÆ®: <%=num_format.format(enjoypointbean.getGiftPoint())%>P
 
<%@ include file = "/include/banner/banner.jsp"%>
<%@ include file = "/include/bottom/info_bottom.jsp"%>