Subversion Repositories SmartDukaan

Rev

Rev 2629 | Rev 2833 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed 

<%@page import="java.text.ParseException"%>
<%@page import="java.util.TimeZone"%>
<%@page import="java.text.SimpleDateFormat"%>
<%@page import="java.util.Date"%>
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ page import="java.util.List" %>
<%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
<%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
<%@ page import="com.google.appengine.api.datastore.Query" %>
<%@ page import="com.google.appengine.api.datastore.Entity" %>
<%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>

<html>
  <head>
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" /> 
  </head>
  <body>
    <form id="frmSuccessfulPayments" name="frmSuccessfulPayments" method="post" action="/jsp/successfull-payments.jsp">
      <label>From Date(YYYYMMDD) : </label> <input type="text" name="fromDate" id="fromDate"/>
      <label>To Date(YYYYMMDD) : </label> <input type="text" name="toDate" id="toDate"/>
      <input type="submit" name="submit" id="submit" value="Submit"/><br/>
    </form>
  
<%
    String fromDateStr = request.getParameter("fromDate");
    String toDateStr = request.getParameter("toDate");
    SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
    Date fromDate = new Date();
    Date toDate = new Date();
    try {
        if (fromDateStr != null) {
            fromDate = iSdf.parse(fromDateStr);
        }
        if (toDateStr != null) {
            toDate = iSdf.parse(toDateStr);
        }
    }
    catch (ParseException pe) {
%>
        <span>Invalid Date Format</span>
<%
    }
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
    Query query = new Query("DataLog");
    query.addFilter("eventType", Query.FilterOperator.EQUAL, "PAYMENT_SUCCESS");
    query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
    query.addFilter("date", Query.FilterOperator.LESS_THAN, toDate);
    PreparedQuery pq = datastore.prepare(query);
%>
    <table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
    <thead>
        <tr>
            <th>Date</th>
            <th>Email</th>
            <th>Payment Id</th>
            <th>View Session</th>
        </tr>
    </thead>
    <tbody>

<%
    for (Entity result : pq.asIterable()) {
        try {
%>

        <tr>
            <td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
            <td><%= result.getProperty("email").toString() %></td>
            <td><%= result.getProperty("paymentId").toString() %></td>
            <td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
        </tr>
<%
        }
        catch (Exception e) {
            e.printStackTrace();
        }
    }
%>
        </tbody>
    </table>
    
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
    <script type="text/javascript" charset="utf-8">
        $(document).ready(function() {
            $('#payments').dataTable();
        } );
    </script>
  </body>
</html>