Subversion Repositories SmartDukaan

Rev

Go to most recent revision | Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
2774 vikas 1 
<%@page import="java.text.ParseException"%>
2629 vikas 2 
<%@page import="java.util.TimeZone"%>
3 
<%@page import="java.text.SimpleDateFormat"%>
4 
<%@page import="java.util.Date"%>
2620 vikas 5 
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
6 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
7 
<%@ page import="java.util.List" %>
8 
<%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
9 
<%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
10 
<%@ page import="com.google.appengine.api.datastore.Query" %>
11 
<%@ page import="com.google.appengine.api.datastore.Entity" %>
12 
<%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>
13 
 
14 
<html>
2629 vikas 15 
  <head>
16 
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
17 
  </head>
2620 vikas 18 
  <body>
2774 vikas 19 
    <form id="frmSuccessfulPayments" name="frmSuccessfulPayments" method="post" action="/jsp/successfull-payments.jsp">
20 
      <label>From Date(YYYYMMDD) : </label> <input type="text" name="fromDate" id="fromDate"/>
21 
      <label>To Date(YYYYMMDD) : </label> <input type="text" name="toDate" id="toDate"/>
22 
      <input type="submit" name="submit" id="submit" value="Submit"/><br/>
23 
    </form>
2620 vikas 24 
 
25 
<%
2774 vikas 26 
    String fromDateStr = request.getParameter("fromDate");
27 
    String toDateStr = request.getParameter("toDate");
28 
    SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
29 
    Date fromDate = new Date();
30 
    Date toDate = new Date();
31 
    try {
32 
        if (fromDateStr != null) {
33 
            fromDate = iSdf.parse(fromDateStr);
34 
        }
35 
        if (toDateStr != null) {
36 
            toDate = iSdf.parse(toDateStr);
37 
        }
38 
    }
39 
    catch (ParseException pe) {
40 
%>
41 
        <span>Invalid Date Format</span>
42 
<%
43 
    }
2629 vikas 44 
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
45 
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
2620 vikas 46 
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
47 
    Query query = new Query("DataLog");
48 
    query.addFilter("eventType", Query.FilterOperator.EQUAL, "PAYMENT_SUCCESS");
2774 vikas 49 
    query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
50 
    query.addFilter("date", Query.FilterOperator.LESS_THAN, toDate);
2620 vikas 51 
    PreparedQuery pq = datastore.prepare(query);
2629 vikas 52 
%>
53 
    <table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
54 
    <thead>
55 
        <tr>
56 
            <th>Date</th>
57 
            <th>Email</th>
58 
            <th>Payment Id</th>
59 
            <th>View Session</th>
2833 vikas 60 
            <th>View User Activity</th>
2629 vikas 61 
        </tr>
62 
    </thead>
63 
    <tbody>
2620 vikas 64 
 
2629 vikas 65 
<%
2620 vikas 66 
    for (Entity result : pq.asIterable()) {
2629 vikas 67 
        try {
2620 vikas 68 
%>
2629 vikas 69 
 
70 
        <tr>
71 
            <td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
72 
            <td><%= result.getProperty("email").toString() %></td>
73 
            <td><%= result.getProperty("paymentId").toString() %></td>
74 
            <td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
2833 vikas 75 
            <td><a href="/jsp/user-activity.jsp?email=<%=result.getProperty("email").toString()%>">View User Activity</a></td>
2629 vikas 76 
        </tr>
2620 vikas 77 
<%
2629 vikas 78 
        }
79 
        catch (Exception e) {
80 
            e.printStackTrace();
81 
        }
2620 vikas 82 
    }
83 
%>
2629 vikas 84 
        </tbody>
85 
    </table>
86 
 
87 
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
88 
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
89 
    <script type="text/javascript" charset="utf-8">
90 
        $(document).ready(function() {
91 
            $('#payments').dataTable();
92 
        } );
93 
    </script>
2620 vikas 94 
  </body>
95 
</html>