<%
/**
 *	$RCSfile: rewardReports.jsp,v $
 *	$Revision: 1.1.1.1 $
 *	$Date: 2002/09/09 13:50:29 $
 */
%>

<%@ page import="java.util.*,
				 java.text.*,
                 java.sql.*,
				 com.jivesoftware.util.*,
                 com.jivesoftware.forum.*,
				 com.jivesoftware.forum.database.*,
				 com.jivesoftware.forum.util.*"
    errorPage="error.jsp"
%>

<%@ include file="include/global.jsp" %>
 
<%!
    private static final int THIS_MONTH = 1;
    private static final int SOME_MONTH = 2;
    private static final int SOME_YEAR = 3;
    private static final String POINT_EARNERS_SQL =
        "SELECT userID, SUM(rewardPoints) AS points FROM jiveReward " +
        "WHERE creationDate > ? AND creationDate < ? " +
        "GROUP BY userID ORDER BY points desc";
    private static final SimpleDateFormat monthYearDateFormatter
        = new SimpleDateFormat("MMMM, yyyy");
%>

<%	// get parameters
	int reportType = ParamUtils.getIntParameter(request,"reportType",-1);
    boolean generate = ParamUtils.getBooleanParameter(request,"generate");
    int month = ParamUtils.getIntParameter(request,"month",1);
    int year1 = ParamUtils.getIntParameter(request,"year1",2000);
    int year2 = ParamUtils.getIntParameter(request,"year2",2000);
    
    UserManager userManager = forumFactory.getUserManager();
%>

<%@ include file="include/header.jsp" %>

<p>

<%  // Title of this page and breadcrumbs
    String title = "Reward Reports";
    String[][] breadcrumbs = {
        {"Main", "main.jsp"},
        {title, "rewardReports.jsp"}
    };
%>
<%@ include file="include/title.jsp" %>

<font size="-1">
Use the forums below to generate reports on reward point usage.
</font>

<p>

<form action="rewardReports.jsp">
<input type="hidden" name="generate" value="true">

<font size="-1">Choose a report to generate:</font>
<ul>
    <input type="radio" name="reportType" value="<%= THIS_MONTH %>" checked>
    <font size="-1">This month's top point earners</font>
    <p>
    
    <input type="radio" name="reportType" value="<%= SOME_MONTH %>">
    <font size="-1">Top point earners for the month of</font>
    <select size="1" name="month">
    <option value="0">January
    <option value="1">February
    <option value="2">March
    <option value="3">April
    <option value="4">May
    <option value="5">June
    <option value="6">July
    <option value="7">August
    <option value="8">September
    <option value="9">October
    <option value="10">November
    <option value="11">December
    </select>
    <select size="1" name="year1">
    <option value="2000">2000
    <option value="2001">2001
    </select>
    <p>
    
    <input type="radio" name="reportType" value="<%= SOME_YEAR %>">
    <font size="-1">Top point earners for the year of</font>
    <select size="1" name="year2">
    <option value="2000">2000
    <option value="2001">2001
    </select>
</ul>
<input type="submit" value="Generate">
</form>

<%  if (generate) { %>
<hr>

<center>

<%      if (reportType != THIS_MONTH
            && reportType != SOME_MONTH
            && reportType != SOME_YEAR)
        {
%>      <font size="-1"><i>Please pick a type of report to run</i></font>
<%      } else {
            Calendar cal = Calendar.getInstance();
            // "bottom" out the calendar by resetting it to the beginning day
            // in this month:
            cal.set(Calendar.DAY_OF_MONTH, 1);
            cal.set(Calendar.HOUR_OF_DAY, 0);
            cal.set(Calendar.MINUTE, 0);
            cal.set(Calendar.SECOND, 0);
            cal.set(Calendar.MILLISECOND, 0);
%>

<%      if (reportType == THIS_MONTH) { 
%>
    
    <font size="+1">
    Top Reward Point Earners for <%= monthYearDateFormatter.format(cal.getTime()) %>
    </font>
    
<%      } else if (reportType == SOME_MONTH) {
            cal.set(Calendar.MONTH, month);
            cal.set(Calendar.YEAR, year1);
%>
    
    <font size="+1">
    Top Reward Point Earners for <%= monthYearDateFormatter.format(cal.getTime()) %>
    </font>
    
<%      } else if (reportType == SOME_YEAR) {
            cal.set(Calendar.DAY_OF_YEAR, 1);
            cal.set(Calendar.YEAR, year2);
%>
    
    <font size="+1">
    Top Reward Point Earners for the Year of <%= year2 %>
    </font>
    
<%      } else {} %>

<p>

<table cellpadding="3" cellspacing="0" border="1" width="80%">
<tr>
    <td align="center" width="10%">&nbsp;</td>
    <td align="center" width="45%"><font size="-1"><b>User</b></font></td>
    <td align="center" width="45%"><font size="-1"><b>Points</b></font></td>
</tr>

<%
    Connection con = null;
    PreparedStatement pstmt = null;
    try {
        con = ConnectionManager.getConnection();
        pstmt = con.prepareStatement(POINT_EARNERS_SQL);
        if (reportType == THIS_MONTH) {
            pstmt.setString(1, Long.toString(cal.getTime().getTime()));
            cal.roll(Calendar.MONTH,1);
            pstmt.setString(2, Long.toString(cal.getTime().getTime()));
        }
        else if (reportType == SOME_MONTH) {
            pstmt.setString(1, Long.toString(cal.getTime().getTime()));
            cal.roll(Calendar.MONTH,1);
            pstmt.setString(2, Long.toString(cal.getTime().getTime()));
        }
        else if (reportType == SOME_YEAR) {
            pstmt.setString(1, Long.toString(cal.getTime().getTime()));
            cal.roll(Calendar.YEAR,1);
            pstmt.setString(2, Long.toString(cal.getTime().getTime()));
        }
        ResultSet rs = pstmt.executeQuery();
        int count = 0;
        boolean noData = true;
        while (rs.next() && (count++ < 10)) {
            noData = false;
            long userID = rs.getLong(1);
            int points = rs.getInt(2);
%>
<tr>
    <td align="right"><font size="-1"><%= count %></font></td>
    <td align="center"><font size="-1"><%= userManager.getUser(userID).getUsername() %></font></td>
    <td align="center"><font size="-1"><%= points %></font></td>
</tr>
<%      }
        if (noData) {
%>
<tr>
    <td colspan="3" align="center"><font size="-1"><i>No data for this time period.</i></font></td>
</tr>
<%
        }
    }
    catch (SQLException sqle) {
        sqle.printStackTrace();
    }
    finally {
        try {  pstmt.close();   }
        catch (Exception e) { e.printStackTrace(); }
        try {  con.close();   }
        catch (Exception e) { e.printStackTrace(); }
    }
%>
</table>

<%      }
    }
%>

</center>

<%@ include file="include/footer.jsp" %>