Subversion Repositories SmartDukaan

Rev

Rev 3197 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
2969 vikas 1 
<%@page import="java.util.Calendar"%>
2 
<%@page import="java.util.Map.Entry"%>
2774 vikas 3 
<%@page import="java.text.ParseException"%>
2629 vikas 4 
<%@page import="java.util.TimeZone"%>
5 
<%@page import="java.text.SimpleDateFormat"%>
6 
<%@page import="java.util.Date"%>
2620 vikas 7 
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
8 
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
9 
<%@ page import="java.util.List" %>
10 
<%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
11 
<%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
12 
<%@ page import="com.google.appengine.api.datastore.Query" %>
13 
<%@ page import="com.google.appengine.api.datastore.Entity" %>
14 
<%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>
15 
 
16 
<html>
2629 vikas 17 
  <head>
2994 vikas 18 
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
19 
      <link rel="stylesheet" href="/DataTables/extras/TableTools/media/css/TableTools.css" type="text/css" />
2629 vikas 20 
  </head>
2620 vikas 21 
  <body>
2969 vikas 22 
<%
2970 vikas 23 
    Date toDate = new Date();
2969 vikas 24 
    Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("IST"));
25 
    cal.add(Calendar.DAY_OF_MONTH, -2);
2970 vikas 26 
    Date fromDate = cal.getTime();
2969 vikas 27 
    SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
28 
    String fromDateStr = request.getParameter("fromDate");
29 
    String toDateStr = request.getParameter("toDate");
30 
    String eventType = request.getParameter("eventType");
31 
    if (eventType == null) {
2970 vikas 32 
        eventType = "PAYMENT_SUCCESS";
2969 vikas 33 
    }
2971 vikas 34 
    if (fromDateStr == null || fromDateStr.isEmpty()) {
35 
        fromDateStr = iSdf.format(fromDate);
36 
    }
37 
    if (toDateStr == null || toDateStr.isEmpty()) {
2972 vikas 38 
        toDateStr = iSdf.format(toDate);
2971 vikas 39 
    }
2969 vikas 40 
%>
41 
    <form id="frmSuccessfulPayments" name="frmSuccessfulPayments" method="post" action="/jsp/search-events.jsp">
2971 vikas 42 
      <label>From Date(YYYYMMDD) : </label> <input type="text" name="fromDate" id="fromDate" value="<%= fromDateStr %>"/>
43 
      <label>To Date(YYYYMMDD) : </label> <input type="text" name="toDate" id="toDate" value="<%= toDateStr %>"/>
2969 vikas 44 
      <label>Event Type : </label> <select name="eventType" id="eventType">
45 
          <option <%= eventType.equals("PAYMENT_SUCCESS")? "selected='selected'": "" %> value="PAYMENT_SUCCESS">PAYMENT_SUCCESS</option>
46 
          <option <%= eventType.equals("ADD_ADDRESS")? "selected='selected'": "" %> value="ADD_ADDRESS">ADD_ADDRESS</option>
47 
	      <option <%= eventType.equals("DELETE_ADDRESS")? "selected='selected'": "" %> value="DELETE_ADDRESS">DELETE_ADDRESS</option>
48 
	      <option <%= eventType.equals("SET_DEFAULT_ADDRESS")? "selected='selected'": "" %> value="SET_DEFAULT_ADDRESS">SET_DEFAULT_ADDRESS</option>
49 
	      <option <%= eventType.equals("ADD_TO_CART")? "selected='selected'": "" %> value="ADD_TO_CART">ADD_TO_CART</option>
50 
	      <option <%= eventType.equals("DELETE_FROM_CART")? "selected='selected'": "" %> value="DELETE_FROM_CART">DELETE_FROM_CART</option>
51 
	      <option <%= eventType.equals("UPDATE_CART_QUANTITY")? "selected='selected'": "" %> value="UPDATE_CART_QUANTITY">UPDATE_CART_QUANTITY</option>
52 
	      <option <%= eventType.equals("UPDATE_CART_QUANTITY_FAILED")? "selected='selected'": "" %> value="UPDATE_CART_QUANTITY_FAILED">UPDATE_CART_QUANTITY_FAILED</option>
53 
	      <option <%= eventType.equals("PAYMENT_FAILURE")? "selected='selected'": "" %> value="PAYMENT_FAILURE">PAYMENT_FAILURE</option>
54 
	      <option <%= eventType.equals("PRODUCT_VIEW")? "selected='selected'": "" %> value="PRODUCT_VIEW">PRODUCT_VIEW</option>
55 
	      <option <%= eventType.equals("PRODUCT_SEARCH")? "selected='selected'": "" %> value="PRODUCT_SEARCH">PRODUCT_SEARCH</option>
56 
	      <option <%= eventType.equals("PRODUCT_COMPARE")? "selected='selected'": "" %> value="PRODUCT_COMPARE">PRODUCT_COMPARE</option>
57 
	      <option <%= eventType.equals("LOGIN_FAILED")? "selected='selected'": "" %> value="LOGIN_FAILED">LOGIN_FAILED</option>
58 
	      <option <%= eventType.equals("LOGIN_SUCCESS")? "selected='selected'": "" %> value="LOGIN_SUCCESS">LOGIN_SUCCESS</option>
59 
	      <option <%= eventType.equals("LOGOUT")? "selected='selected'": "" %> value="LOGOUT">LOGOUT</option>
60 
	      <option <%= eventType.equals("RESEARCH_ADD")? "selected='selected'": "" %> value="RESEARCH_ADD">RESEARCH_ADD</option>
61 
	      <option <%= eventType.equals("RESEARCH_DELETE")? "selected='selected'": "" %> value="RESEARCH_DELETE">RESEARCH_DELETE</option>
62 
	      <option <%= eventType.equals("REGISTER_SUCCESS")? "selected='selected'": "" %> value="REGISTER_SUCCESS">REGISTER_SUCCESS</option>
63 
	      <option <%= eventType.equals("REGISTER_FAILED_USER_EXISTS")? "selected='selected'": "" %> value="REGISTER_FAILED_USER_EXISTS">REGISTER_FAILED_USER_EXISTS</option>
64 
          <option <%= eventType.equals("REGISTER_DATA_INCOMPLETE")? "selected='selected'": "" %> value="REGISTER_DATA_INCOMPLETE">REGISTER_DATA_INCOMPLETE</option>
65 
          <option <%= eventType.equals("SHIPPINIG_ACCESS")? "selected='selected'": "" %> value="SHIPPINIG_ACCESS">SHIPPINIG_ACCESS</option>
3211 vikas 66 
          <option <%= eventType.equals("PROCEED_TO_PAY")? "selected='selected'": "" %> value="PROCEED_TO_PAY">PROCEED_TO_PAY</option>
2969 vikas 67 
          <option <%= eventType.equals("SHIPPINIG_ADD_ADDRESS")? "selected='selected'": "" %> value="SHIPPINIG_ADD_ADDRESS">SHIPPINIG_ADD_ADDRESS</option>
68 
          <option <%= eventType.equals("SHIPPINIG_ADD_CHANGE")? "selected='selected'": "" %> value="SHIPPINIG_ADD_CHANGE">SHIPPINIG_ADD_CHANGE</option>
69 
          <option <%= eventType.equals("ORDER_CREATION")? "selected='selected'": "" %> value="ORDER_CREATION">ORDER_CREATION</option>
70 
          <option <%= eventType.equals("NEW_SESSION")? "selected='selected'": "" %> value="NEW_SESSION">NEW_SESSION</option>
71 
          <option <%= eventType.equals("COUPON_APPLIED")? "selected='selected'": "" %> value="COUPON_APPLIED">COUPON_APPLIED</option>
72 
          <option <%= eventType.equals("COUPON_REMOVED")? "selected='selected'": "" %> value="COUPON_REMOVED">COUPON_REMOVED</option>
73 
      </select>
2774 vikas 74 
      <input type="submit" name="submit" id="submit" value="Submit"/><br/>
75 
    </form>
2620 vikas 76 
 
77 
<%
2774 vikas 78 
    try {
79 
        if (fromDateStr != null) {
80 
            fromDate = iSdf.parse(fromDateStr);
81 
        }
82 
        if (toDateStr != null) {
83 
            toDate = iSdf.parse(toDateStr);
84 
        }
85 
    }
86 
    catch (ParseException pe) {
87 
%>
88 
        <span>Invalid Date Format</span>
89 
<%
90 
    }
2629 vikas 91 
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
92 
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
2620 vikas 93 
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
94 
    Query query = new Query("DataLog");
2969 vikas 95 
    query.addFilter("eventType", Query.FilterOperator.EQUAL, eventType);
2774 vikas 96 
    query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
97 
    query.addFilter("date", Query.FilterOperator.LESS_THAN, toDate);
2620 vikas 98 
    PreparedQuery pq = datastore.prepare(query);
2629 vikas 99 
%>
100 
    <table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
101 
    <thead>
102 
        <tr>
103 
            <th>Date</th>
2994 vikas 104 
            <th>UserId</th>
2629 vikas 105 
            <th>View Session</th>
2969 vikas 106 
            <th>Information</th>
2629 vikas 107 
        </tr>
108 
    </thead>
109 
    <tbody>
2620 vikas 110 
 
2629 vikas 111 
<%
2620 vikas 112 
    for (Entity result : pq.asIterable()) {
2629 vikas 113 
        try {
2620 vikas 114 
%>
2629 vikas 115 
 
116 
        <tr>
117 
            <td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
2994 vikas 118 
            <td><a href="/jsp/user-activity.jsp?email=<%=result.getProperty("email").toString()%>"><%= result.getProperty("email").toString() %></a></td>
2629 vikas 119 
            <td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
2969 vikas 120 
            <td>
121 
            <%
122 
            for (Entry<String, Object> entry : result.getProperties().entrySet()) {
123 
                String key = entry.getKey();
124 
                if (key.equals("email") || key.equals("sessionId")
125 
                        || key.equals("userId") || key.equals("date")
3197 vikas 126 
                        || key.equals("eventType") || key.equals("logTime") || key.equals("shortdate")) {
2969 vikas 127 
                    continue;
128 
                }
129 
                String value = entry.getValue().toString();
130 
%>
131 
                    <%=key + ":" + value + "; "%>
132 
<%
133 
     }
134 
 %>
135 
 
136 
            </td>
2629 vikas 137 
        </tr>
2620 vikas 138 
<%
2629 vikas 139 
        }
140 
        catch (Exception e) {
141 
            e.printStackTrace();
142 
        }
2620 vikas 143 
    }
144 
%>
2629 vikas 145 
        </tbody>
146 
    </table>
147 
 
148 
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
149 
    <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
2994 vikas 150 
    <script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/ZeroClipboard.js"></script>
151 
    <script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/TableTools.js"></script>
2629 vikas 152 
    <script type="text/javascript" charset="utf-8">
153 
        $(document).ready(function() {
2994 vikas 154 
            $('#payments').dataTable({
155 
            	"sPaginationType": "full_numbers",
156 
            	"bProcessing": true,
157 
                "bStateSave": true,
158 
            	"sDom": 'T<"clear">lfrtip',
159 
                "oTableTools": {
160 
                    "sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"
161 
                },
162 
                "aoColumns": [
163 
                          null,
164 
                          null,
165 
                          { "bSearchable": false },
166 
                          null
167 
                ]
168 
            });
2629 vikas 169 
        } );
170 
    </script>
2620 vikas 171 
  </body>
172 
</html>