%@ 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;
%>
<%
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 |
|
|
|
 |
 |
|
|
| <%
pointconn.close();
userconn.close();
}catch(Exception e){
out.println(e);
try{
if(userconn != null) userconn.close();
if(pointconn != null) pointconn.close();
}catch(SQLException se){}
}
%>
 |
| |
|
|
|
<%@ include file = "/include/banner/banner.jsp"%> |
<%
}
%>
| <%@ include file = "/include/bottom/info_bottom.jsp"%> |
|
|