Subversion Repositories SmartDukaan

Rev

Rev 3370 | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2833 vikas 1
<%@page import="java.util.Date"%>
2
<%@page import="java.util.TimeZone"%>
3
<%@page import="java.text.SimpleDateFormat"%>
4
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
5
<%@page import="java.util.Map.Entry"%>
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
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
13
 
14
<html>
15
  <head>
2994 vikas 16
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
17
      <link rel="stylesheet" href="/DataTables/extras/TableTools/media/css/TableTools.css" type="text/css" /> 
2833 vikas 18
  </head>
19
  <body>
20
<%
21
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
22
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
23
    DatastoreService datastore = DatastoreServiceFactory
24
            .getDatastoreService();
25
    String email = request.getParameter("email");
26
    if (email != null && !email.isEmpty()) {
27
        Query query = new Query("DataLog");
28
        query.addFilter("email", Query.FilterOperator.EQUAL,
29
                email);
30
        PreparedQuery pq = datastore.prepare(query);
31
%>
32
	<table cellpadding="0" cellspacing="0" border="0" class="display"
33
		id="activity">
34
		<thead>
35
			<tr>
36
				<th>Date</th>
37
				<th>Session</th>
38
				<th>Event Type</th>
39
				<th>Information</th>
40
			</tr>
41
		</thead>
42
		<tbody>
43
 
44
<%
45
        for (Entity result : pq.asIterable()) {
46
%>
47
			<tr>
48
				<td><%=sdf.format((Date) (result.getProperty("date")))%></td>
2969 vikas 49
				<td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>"><%=result.getProperty("sessionId").toString()%></a></td>
2833 vikas 50
				<td><%=result.getProperty("eventType").toString()%></td>
51
				<td>
52
<%
53
            for (Entry<String, Object> entry : result.getProperties()
54
                    .entrySet()) {
55
                String key = entry.getKey();
56
                if (key.equals("email") || key.equals("sessionId")
57
                        || key.equals("userId") || key.equals("date")
3370 vikas 58
                        || key.equals("eventType") || key.equals("logTime") || key.equals("shortdate")) {
2833 vikas 59
                    continue;
60
                }
3450 vikas 61
                String value = "";
62
                if (entry.getValue() != null) {
63
                    value = entry.getValue().toString();
64
                }
2833 vikas 65
%> 
66
                    <%=key + ":" + value + "; "%> 
67
<%
68
     }
69
 %>
70
				</td>
71
			</tr>
72
<%
73
    }
74
%>
75
		</tbody>
76
	</table>
77
<%
78
    }
79
%>
80
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
81
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
2994 vikas 82
    <script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/ZeroClipboard.js"></script>
83
    <script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/TableTools.js"></script>
2833 vikas 84
    <script type="text/javascript" charset="utf-8">
85
        $(document).ready(function() {
2994 vikas 86
            $('#activity').dataTable({
87
                "sPaginationType": "full_numbers",
88
                "bProcessing": true,
89
                "bStateSave": true,
90
                "sDom": 'T<"clear">lfrtip',
91
                "oTableTools": {
92
                    "sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"
93
                },
94
                "aoColumns": [ 
95
                              null,
96
                              { "bSearchable": false },
97
                              null,
98
                              null
99
                    ]
100
            });
2833 vikas 101
        } );
102
    </script>
103
  </body>
104
</html>