| 2629 |
vikas |
1 |
<%@page import="java.util.TimeZone"%>
|
|
|
2 |
<%@page import="java.text.SimpleDateFormat"%>
|
|
|
3 |
<%@page import="java.util.Date"%>
|
| 2620 |
vikas |
4 |
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
|
|
|
5 |
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
|
|
|
6 |
<%@ page import="java.util.List" %>
|
|
|
7 |
<%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
|
|
|
8 |
<%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
|
|
|
9 |
<%@ page import="com.google.appengine.api.datastore.Query" %>
|
|
|
10 |
<%@ page import="com.google.appengine.api.datastore.Entity" %>
|
|
|
11 |
<%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>
|
|
|
12 |
|
|
|
13 |
<html>
|
| 2629 |
vikas |
14 |
<head>
|
|
|
15 |
<link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
|
|
|
16 |
</head>
|
| 2620 |
vikas |
17 |
<body>
|
|
|
18 |
|
|
|
19 |
<%
|
| 2629 |
vikas |
20 |
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
|
|
|
21 |
sdf.setTimeZone(TimeZone.getTimeZone("IST"));
|
| 2620 |
vikas |
22 |
DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
|
|
|
23 |
Query query = new Query("DataLog");
|
|
|
24 |
query.addFilter("eventType", Query.FilterOperator.EQUAL, "PAYMENT_SUCCESS");
|
|
|
25 |
PreparedQuery pq = datastore.prepare(query);
|
| 2629 |
vikas |
26 |
%>
|
|
|
27 |
<table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
|
|
|
28 |
<thead>
|
|
|
29 |
<tr>
|
|
|
30 |
<th>Date</th>
|
|
|
31 |
<th>Email</th>
|
|
|
32 |
<th>Payment Id</th>
|
|
|
33 |
<th>View Session</th>
|
|
|
34 |
</tr>
|
|
|
35 |
</thead>
|
|
|
36 |
<tbody>
|
| 2620 |
vikas |
37 |
|
| 2629 |
vikas |
38 |
<%
|
| 2620 |
vikas |
39 |
for (Entity result : pq.asIterable()) {
|
| 2629 |
vikas |
40 |
try {
|
| 2620 |
vikas |
41 |
%>
|
| 2629 |
vikas |
42 |
|
|
|
43 |
<tr>
|
|
|
44 |
<td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
|
|
|
45 |
<td><%= result.getProperty("email").toString() %></td>
|
|
|
46 |
<td><%= result.getProperty("paymentId").toString() %></td>
|
|
|
47 |
<td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
|
|
|
48 |
</tr>
|
| 2620 |
vikas |
49 |
<%
|
| 2629 |
vikas |
50 |
}
|
|
|
51 |
catch (Exception e) {
|
|
|
52 |
e.printStackTrace();
|
|
|
53 |
}
|
| 2620 |
vikas |
54 |
}
|
|
|
55 |
%>
|
| 2629 |
vikas |
56 |
</tbody>
|
|
|
57 |
</table>
|
|
|
58 |
|
|
|
59 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
|
|
|
60 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
|
|
|
61 |
<script type="text/javascript" charset="utf-8">
|
|
|
62 |
$(document).ready(function() {
|
|
|
63 |
$('#payments').dataTable();
|
|
|
64 |
} );
|
|
|
65 |
</script>
|
| 2620 |
vikas |
66 |
</body>
|
|
|
67 |
</html>
|