| 3141 |
vikas |
1 |
<%@page import="in.shop2020.server.ItemActivityRepository"%>
|
|
|
2 |
<%@page import="in.shop2020.model.ItemActivity"%>
|
| 3100 |
vikas |
3 |
<%@page import="com.google.appengine.api.datastore.FetchOptions"%>
|
|
|
4 |
<%@page import="java.util.ArrayList"%>
|
|
|
5 |
<%@page import="in.shop2020.model.Item"%>
|
|
|
6 |
<%@page import="in.shop2020.server.ItemRepository"%>
|
| 3013 |
vikas |
7 |
<%@page import="java.util.Map"%>
|
|
|
8 |
<%@page import="java.util.HashMap"%>
|
|
|
9 |
<%@page import="java.util.Calendar"%>
|
|
|
10 |
<%@page import="java.util.Date"%>
|
|
|
11 |
<%@page import="java.util.TimeZone"%>
|
|
|
12 |
<%@page import="java.text.SimpleDateFormat"%>
|
|
|
13 |
<%@page import="com.google.appengine.api.datastore.Query.SortDirection"%>
|
|
|
14 |
<%@page import="java.util.Map.Entry"%>
|
|
|
15 |
<%@ page import="java.util.List" %>
|
|
|
16 |
<%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
|
|
|
17 |
<%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
|
|
|
18 |
<%@ page import="com.google.appengine.api.datastore.Query" %>
|
|
|
19 |
<%@ page import="com.google.appengine.api.datastore.Entity" %>
|
|
|
20 |
<%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>
|
|
|
21 |
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
|
|
|
22 |
|
|
|
23 |
<html>
|
|
|
24 |
<head>
|
|
|
25 |
<link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" />
|
|
|
26 |
<link rel="stylesheet" href="/DataTables/extras/TableTools/media/css/TableTools.css" type="text/css" />
|
|
|
27 |
</head>
|
|
|
28 |
<body>
|
|
|
29 |
<%
|
|
|
30 |
SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
|
| 3141 |
vikas |
31 |
iSdf.setTimeZone(TimeZone.getTimeZone("IST"));
|
| 3013 |
vikas |
32 |
Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("IST"));
|
|
|
33 |
String dateStr = request.getParameter("date");
|
| 3141 |
vikas |
34 |
Date date;
|
|
|
35 |
if (dateStr != null && !dateStr.isEmpty()) {
|
|
|
36 |
date = iSdf.parse(dateStr);
|
|
|
37 |
}
|
|
|
38 |
else {
|
|
|
39 |
date = iSdf.parse(iSdf.format(cal.getTime()));
|
|
|
40 |
dateStr = iSdf.format(date);
|
|
|
41 |
}
|
|
|
42 |
|
| 3100 |
vikas |
43 |
ItemRepository itemRepository = new ItemRepository();
|
|
|
44 |
List<Item> items = itemRepository.getAll();
|
|
|
45 |
Map<Long, Item> itemsCatalogIdMap = new HashMap<Long, Item>();
|
|
|
46 |
for (Item item : items) {
|
|
|
47 |
itemsCatalogIdMap.put(item.getCatalogId(), item);
|
|
|
48 |
}
|
| 3013 |
vikas |
49 |
|
| 3141 |
vikas |
50 |
ItemActivityRepository itemActivityRepository = new ItemActivityRepository();
|
|
|
51 |
List<ItemActivity> itemActivities = itemActivityRepository.getByDate(date);
|
| 3013 |
vikas |
52 |
%>
|
|
|
53 |
<form id="frmProductActivity" name="frmProductActivity" method="post" action="/jsp/product-activity.jsp">
|
|
|
54 |
<label>Date(YYYYMMDD) : </label> <input type="text" name="date" id="date" value="<%= dateStr %>"/>
|
|
|
55 |
<input type="submit" name="submit" id="submit" value="Submit"/><br/>
|
|
|
56 |
</form>
|
|
|
57 |
<table cellpadding="0" cellspacing="0" border="0" class="display"
|
| 3100 |
vikas |
58 |
id="prodFunnel">
|
| 3013 |
vikas |
59 |
<thead>
|
|
|
60 |
<tr>
|
|
|
61 |
<th>Product</th>
|
| 3100 |
vikas |
62 |
<th>View</th>
|
| 3141 |
vikas |
63 |
<th>Unique</th>
|
|
|
64 |
<th>AddCart</th>
|
|
|
65 |
<th>Unique</th>
|
|
|
66 |
<th>DelCart</th>
|
|
|
67 |
<th>Unique</th>
|
|
|
68 |
<th>AddResearch</th>
|
|
|
69 |
<th>Unique</th>
|
|
|
70 |
<th>DelResearch</th>
|
|
|
71 |
<th>Unique</th>
|
| 3013 |
vikas |
72 |
</tr>
|
|
|
73 |
</thead>
|
|
|
74 |
<tbody>
|
|
|
75 |
|
|
|
76 |
<%
|
| 3141 |
vikas |
77 |
for (ItemActivity itemActivity : itemActivities) {
|
| 3013 |
vikas |
78 |
%>
|
|
|
79 |
<tr>
|
| 3141 |
vikas |
80 |
<td><%=itemsCatalogIdMap.get(itemActivity.getCatalogId())==null? itemActivity.getCatalogId() : itemsCatalogIdMap.get(itemActivity.getCatalogId()).getName()%></td>
|
|
|
81 |
<td><%=itemActivity.getView()==null? 0 : itemActivity.getView()%></td>
|
|
|
82 |
<td><%=itemActivity.getUniqueView()==null? 0 : itemActivity.getUniqueView()%></td>
|
|
|
83 |
<td><%=itemActivity.getAddToCart()==null? 0 : itemActivity.getAddToCart()%></td>
|
|
|
84 |
<td><%=itemActivity.getUniqueAddToCart()==null? 0 : itemActivity.getUniqueAddToCart()%></td>
|
|
|
85 |
<td><%=itemActivity.getDeleteFromCart()==null? 0 : itemActivity.getDeleteFromCart()%></td>
|
|
|
86 |
<td><%=itemActivity.getUniqueDeleteFromCart()==null? 0 : itemActivity.getUniqueDeleteFromCart()%></td>
|
|
|
87 |
<td><%=itemActivity.getAddToResearch()==null? 0 : itemActivity.getAddToResearch()%></td>
|
|
|
88 |
<td><%=itemActivity.getUniqueAddToResearch()==null? 0 : itemActivity.getUniqueAddToResearch()%></td>
|
|
|
89 |
<td><%=itemActivity.getDeleteFromResearch()==null? 0 : itemActivity.getDeleteFromResearch()%></td>
|
|
|
90 |
<td><%=itemActivity.getUniqueDeleteFromResearch()==null? 0 : itemActivity.getUniqueDeleteFromResearch()%></td>
|
| 3013 |
vikas |
91 |
</tr>
|
|
|
92 |
<%
|
|
|
93 |
}
|
|
|
94 |
%>
|
|
|
95 |
</tbody>
|
|
|
96 |
</table>
|
|
|
97 |
|
|
|
98 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script>
|
|
|
99 |
<script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script>
|
|
|
100 |
<script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/ZeroClipboard.js"></script>
|
|
|
101 |
<script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/TableTools.js"></script>
|
|
|
102 |
<script type="text/javascript" charset="utf-8">
|
|
|
103 |
$(document).ready(function() {
|
| 3100 |
vikas |
104 |
$('#prodFunnel').dataTable({
|
|
|
105 |
"iDisplayLength": 15,
|
| 3013 |
vikas |
106 |
"bProcessing": true,
|
|
|
107 |
"aaSorting": [[1,'desc']],
|
| 3100 |
vikas |
108 |
"sDom": 'T<"clear">lfrtip',
|
|
|
109 |
"oTableTools": {
|
|
|
110 |
"sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"
|
|
|
111 |
},
|
|
|
112 |
"aLengthMenu": [[10, 15, 25, 50, 100, -1], [10, 15, 25, 50, 100, "All"]]
|
| 3013 |
vikas |
113 |
});
|
|
|
114 |
} );
|
|
|
115 |
</script>
|
|
|
116 |
</body>
|
|
|
117 |
</html>
|