Subversion Repositories SmartDukaan

Rev

Rev 2833 | Rev 2970 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 2833 Rev 2969
Line -... Line 1...
- 
 
 1 
<%@page import="java.util.Calendar"%>
- 
 
 2 
<%@page import="java.util.Map.Entry"%>
1 
<%@page import="java.text.ParseException"%>
 3 
<%@page import="java.text.ParseException"%>
2 
<%@page import="java.util.TimeZone"%>
 4 
<%@page import="java.util.TimeZone"%>
3 
<%@page import="java.text.SimpleDateFormat"%>
 5 
<%@page import="java.text.SimpleDateFormat"%>
4 
<%@page import="java.util.Date"%>
 6 
<%@page import="java.util.Date"%>
5 
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
 7 
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
Line 14... Line 16...
14 
<html>
 16 
<html>
15 
  <head>
 17 
  <head>
16 
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
18 
      <link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
17 
  </head>
 19 
  </head>
18 
  <body>
 20 
  <body>
- 
 
 21 
<%
- 
 
 22 
    Date inputToDate = new Date();
- 
 
 23 
    Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("IST"));
- 
 
 24 
    cal.add(Calendar.DAY_OF_MONTH, -2);
- 
 
 25 
    Date inputFromDate = cal.getTime();
- 
 
 26 
    SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
- 
 
 27 
    String fromDateStr = request.getParameter("fromDate");
- 
 
 28 
    String toDateStr = request.getParameter("toDate");
- 
 
 29 
    String eventType = request.getParameter("eventType");
- 
 
 30 
    if (eventType == null) {
- 
 
 31 
        eventType = "";
- 
 
 32 
    }
- 
 
 33 
%>
19 
    <form id="frmSuccessfulPayments" name="frmSuccessfulPayments" method="post" action="/jsp/successfull-payments.jsp">
 34 
    <form id="frmSuccessfulPayments" name="frmSuccessfulPayments" method="post" action="/jsp/search-events.jsp">
20 
      <label>From Date(YYYYMMDD) : </label> <input type="text" name="fromDate" id="fromDate"/>
 35 
      <label>From Date(YYYYMMDD) : </label> <input type="text" name="fromDate" id="fromDate" value="<%= iSdf.format(inputFromDate) %>"/>
21 
      <label>To Date(YYYYMMDD) : </label> <input type="text" name="toDate" id="toDate"/>
 36 
      <label>To Date(YYYYMMDD) : </label> <input type="text" name="toDate" id="toDate" value="<%= iSdf.format(inputToDate) %>"/>
- 
 
 37 
      <label>Event Type : </label> <select name="eventType" id="eventType">
- 
 
 38 
          <option <%= eventType.equals("PAYMENT_SUCCESS")? "selected='selected'": "" %> value="PAYMENT_SUCCESS">PAYMENT_SUCCESS</option>
- 
 
 39 
          <option <%= eventType.equals("ADD_ADDRESS")? "selected='selected'": "" %> value="ADD_ADDRESS">ADD_ADDRESS</option>
- 
 
 40 
	      <option <%= eventType.equals("DELETE_ADDRESS")? "selected='selected'": "" %> value="DELETE_ADDRESS">DELETE_ADDRESS</option>
- 
 
 41 
	      <option <%= eventType.equals("SET_DEFAULT_ADDRESS")? "selected='selected'": "" %> value="SET_DEFAULT_ADDRESS">SET_DEFAULT_ADDRESS</option>
- 
 
 42 
	      <option <%= eventType.equals("ADD_TO_CART")? "selected='selected'": "" %> value="ADD_TO_CART">ADD_TO_CART</option>
- 
 
 43 
	      <option <%= eventType.equals("DELETE_FROM_CART")? "selected='selected'": "" %> value="DELETE_FROM_CART">DELETE_FROM_CART</option>
- 
 
 44 
	      <option <%= eventType.equals("UPDATE_CART_QUANTITY")? "selected='selected'": "" %> value="UPDATE_CART_QUANTITY">UPDATE_CART_QUANTITY</option>
- 
 
 45 
	      <option <%= eventType.equals("UPDATE_CART_QUANTITY_FAILED")? "selected='selected'": "" %> value="UPDATE_CART_QUANTITY_FAILED">UPDATE_CART_QUANTITY_FAILED</option>
- 
 
 46 
	      <option <%= eventType.equals("PAYMENT_FAILURE")? "selected='selected'": "" %> value="PAYMENT_FAILURE">PAYMENT_FAILURE</option>
- 
 
 47 
	      <option <%= eventType.equals("PRODUCT_VIEW")? "selected='selected'": "" %> value="PRODUCT_VIEW">PRODUCT_VIEW</option>
- 
 
 48 
	      <option <%= eventType.equals("PRODUCT_SEARCH")? "selected='selected'": "" %> value="PRODUCT_SEARCH">PRODUCT_SEARCH</option>
- 
 
 49 
	      <option <%= eventType.equals("PRODUCT_COMPARE")? "selected='selected'": "" %> value="PRODUCT_COMPARE">PRODUCT_COMPARE</option>
- 
 
 50 
	      <option <%= eventType.equals("LOGIN_FAILED")? "selected='selected'": "" %> value="LOGIN_FAILED">LOGIN_FAILED</option>
- 
 
 51 
	      <option <%= eventType.equals("LOGIN_SUCCESS")? "selected='selected'": "" %> value="LOGIN_SUCCESS">LOGIN_SUCCESS</option>
- 
 
 52 
	      <option <%= eventType.equals("LOGOUT")? "selected='selected'": "" %> value="LOGOUT">LOGOUT</option>
- 
 
 53 
	      <option <%= eventType.equals("RESEARCH_ADD")? "selected='selected'": "" %> value="RESEARCH_ADD">RESEARCH_ADD</option>
- 
 
 54 
	      <option <%= eventType.equals("RESEARCH_DELETE")? "selected='selected'": "" %> value="RESEARCH_DELETE">RESEARCH_DELETE</option>
- 
 
 55 
	      <option <%= eventType.equals("REGISTER_SUCCESS")? "selected='selected'": "" %> value="REGISTER_SUCCESS">REGISTER_SUCCESS</option>
- 
 
 56 
	      <option <%= eventType.equals("REGISTER_FAILED_USER_EXISTS")? "selected='selected'": "" %> value="REGISTER_FAILED_USER_EXISTS">REGISTER_FAILED_USER_EXISTS</option>
- 
 
 57 
          <option <%= eventType.equals("REGISTER_DATA_INCOMPLETE")? "selected='selected'": "" %> value="REGISTER_DATA_INCOMPLETE">REGISTER_DATA_INCOMPLETE</option>
- 
 
 58 
          <option <%= eventType.equals("SHIPPINIG_ACCESS")? "selected='selected'": "" %> value="SHIPPINIG_ACCESS">SHIPPINIG_ACCESS</option>
- 
 
 59 
          <option <%= eventType.equals("SHIPPINIG_ADD_ADDRESS")? "selected='selected'": "" %> value="SHIPPINIG_ADD_ADDRESS">SHIPPINIG_ADD_ADDRESS</option>
- 
 
 60 
          <option <%= eventType.equals("SHIPPINIG_ADD_CHANGE")? "selected='selected'": "" %> value="SHIPPINIG_ADD_CHANGE">SHIPPINIG_ADD_CHANGE</option>
- 
 
 61 
          <option <%= eventType.equals("ORDER_CREATION")? "selected='selected'": "" %> value="ORDER_CREATION">ORDER_CREATION</option>
- 
 
 62 
          <option <%= eventType.equals("NEW_SESSION")? "selected='selected'": "" %> value="NEW_SESSION">NEW_SESSION</option>
- 
 
 63 
          <option <%= eventType.equals("COUPON_APPLIED")? "selected='selected'": "" %> value="COUPON_APPLIED">COUPON_APPLIED</option>
- 
 
 64 
          <option <%= eventType.equals("COUPON_REMOVED")? "selected='selected'": "" %> value="COUPON_REMOVED">COUPON_REMOVED</option>
- 
 
 65 
      </select>
22 
      <input type="submit" name="submit" id="submit" value="Submit"/><br/>
 66 
      <input type="submit" name="submit" id="submit" value="Submit"/><br/>
23 
    </form>
 67 
    </form>
24
68
25 
<%
 69 
<%
26 
    String fromDateStr = request.getParameter("fromDate");
 - 
 
27 
    String toDateStr = request.getParameter("toDate");
 - 
 
28 
    SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
 - 
 
29 
    Date fromDate = new Date();
 70 
    Date fromDate = new Date();
30 
    Date toDate = new Date();
 71 
    Date toDate = new Date();
31 
    try {
 72 
    try {
32 
        if (fromDateStr != null) {
 73 
        if (fromDateStr != null) {
33 
            fromDate = iSdf.parse(fromDateStr);
 74 
            fromDate = iSdf.parse(fromDateStr);
Line 43... Line 84...
43 
    }
 84 
    }
44 
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
 85 
    SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
45 
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
 86 
    sdf.setTimeZone(TimeZone.getTimeZone("IST"));
46 
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
 87 
    DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
47 
    Query query = new Query("DataLog");
 88 
    Query query = new Query("DataLog");
48 
    query.addFilter("eventType", Query.FilterOperator.EQUAL, "PAYMENT_SUCCESS");
 89 
    query.addFilter("eventType", Query.FilterOperator.EQUAL, eventType);
49 
    query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
 90 
    query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
50 
    query.addFilter("date", Query.FilterOperator.LESS_THAN, toDate);
 91 
    query.addFilter("date", Query.FilterOperator.LESS_THAN, toDate);
51 
    PreparedQuery pq = datastore.prepare(query);
 92 
    PreparedQuery pq = datastore.prepare(query);
52 
%>
 93 
%>
53 
    <table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
 94 
    <table cellpadding="0" cellspacing="0" border="0" class="display" id="payments">
54 
    <thead>
 95 
    <thead>
55 
        <tr>
 96 
        <tr>
56 
            <th>Date</th>
 97 
            <th>Date</th>
57 
            <th>Email</th>
 98 
            <th>Email</th>
58 
            <th>Payment Id</th>
 - 
 
59 
            <th>View Session</th>
 99 
            <th>View Session</th>
60 
            <th>View User Activity</th>
 100 
            <th>View User Activity</th>
- 
 
 101 
            <th>Information</th>
61 
        </tr>
 102 
        </tr>
62 
    </thead>
 103 
    </thead>
63 
    <tbody>
 104 
    <tbody>
64 
 
 105 
 
65 
<%
 106 
<%
Line 68... Line 109...
68 
%>
 109 
%>
69 
 
 110 
 
70 
        <tr>
 111 
        <tr>
71 
            <td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
 112 
            <td><%= sdf.format((Date)(result.getProperty("date"))) %></td>
72 
            <td><%= result.getProperty("email").toString() %></td>
 113 
            <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>
 114 
            <td><a href="/jsp/session-activity.jsp?sessionId=<%=result.getProperty("sessionId").toString()%>">View Session</a></td>
75 
            <td><a href="/jsp/user-activity.jsp?email=<%=result.getProperty("email").toString()%>">View User Activity</a></td>
 115 
            <td><a href="/jsp/user-activity.jsp?email=<%=result.getProperty("email").toString()%>">View User Activity</a></td>
- 
 
 116 
            <td>
- 
 
 117 
            <%
- 
 
 118 
            for (Entry<String, Object> entry : result.getProperties().entrySet()) {
- 
 
 119 
                String key = entry.getKey();
- 
 
 120 
                if (key.equals("email") || key.equals("sessionId")
- 
 
 121 
                        || key.equals("userId") || key.equals("date")
- 
 
 122 
                        || key.equals("eventType") || key.equals("logTime")) {
- 
 
 123 
                    continue;
- 
 
 124 
                }
- 
 
 125 
                String value = entry.getValue().toString();
- 
 
 126 
%>
- 
 
 127 
                    <%=key + ":" + value + "; "%>
- 
 
 128 
<%
- 
 
 129 
     }
- 
 
 130 
 %>
- 
 
 131
- 
 
 132 
            </td>
76 
        </tr>
 133 
        </tr>
77 
<%
 134 
<%
78 
        }
 135 
        }
79 
        catch (Exception e) {
 136 
        catch (Exception e) {
80 
            e.printStackTrace();
 137 
            e.printStackTrace();