| 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>
|
|
|
60 |
</tr>
|
|
|
61 |
</thead>
|
|
|
62 |
<tbody>
|
| 2620 |
vikas |
63 |
|
| 2629 |
vikas |
64 |
<%
|
| 2620 |
vikas |
65 |
for (Entity result : pq.asIterable()) {
|
| 2629 |
vikas |
66 |
try {
|
| 2620 |
vikas |
67 |
%>
|
| 2629 |
vikas |
68 |
|
|
|
69 |
<tr>
|
|
|
70 |
<td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
|
|
|
71 |
<td><%= result.getProperty("email").toString() %></td>
|
|
|
72 |
<td><%= result.getProperty("paymentId").toString() %></td>
|
|
|
73 |
<td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
|
|
|
74 |
</tr>
|
| 2620 |
vikas |
75 |
<%
|
| 2629 |
vikas |
76 |
}
|
|
|
77 |
catch (Exception e) {
|
|
|
78 |
e.printStackTrace();
|
|
|
79 |
}
|
| 2620 |
vikas |
80 |
}
|
|
|
81 |
%>
|
| 2629 |
vikas |
82 |
</tbody>
|
|
|
83 |
</table>
|
|
|
84 |
|
|
|
85 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
|
|
|
86 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
|
|
|
87 |
<script type="text/javascript" charset="utf-8">
|
|
|
88 |
$(document).ready(function() {
|
|
|
89 |
$('#payments').dataTable();
|
|
|
90 |
} );
|
|
|
91 |
</script>
|
| 2620 |
vikas |
92 |
</body>
|
|
|
93 |
</html>
|