Subversion Repositories SmartDukaan

Rev

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

Rev Author Line No. Line
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();
3154 vikas 45
	Map<Long, String> itemsCatalogIdNameMap = new HashMap<Long, String>();
3100 vikas 46
	for (Item item : items) {
3154 vikas 47
	    itemsCatalogIdNameMap.put(item.getCatalogId(), item.getName());
3100 vikas 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>
3154 vikas 80
				<td><%=itemsCatalogIdNameMap.get(itemActivity.getCatalogId())==null? itemActivity.getCatalogId() : itemsCatalogIdNameMap.get(itemActivity.getCatalogId())%></td>
3141 vikas 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>