Rev 3488 | Blame | Compare with Previous | Last modification | View Log | RSS feed
<%@page import="in.shop2020.model.ItemActivityWithSource"%><%@page import="in.shop2020.server.ItemActivityWithSourceRepository"%><%@page import="java.util.HashMap"%><%@page import="java.util.Map"%><%@page import="in.shop2020.model.Item"%><%@page import="java.util.List"%><%@page import="in.shop2020.server.ItemRepository"%><%@page import="java.util.Date"%><%@page import="java.util.Calendar"%><%@page import="java.util.TimeZone"%><%@page import="java.text.SimpleDateFormat"%><%@ page contentType="text/html;charset=UTF-8" language="java" %><html><head><link rel="stylesheet" href="/DataTables/media/css/demo_table.css" type="text/css" /><link rel="stylesheet" href="/DataTables/extras/TableTools/media/css/TableTools.css" type="text/css" /></head><body><%SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");iSdf.setTimeZone(TimeZone.getTimeZone("IST"));Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("IST"));String dateStr = request.getParameter("date");Date date;if (dateStr != null && !dateStr.isEmpty()) {date = iSdf.parse(dateStr);}else {date = iSdf.parse(iSdf.format(cal.getTime()));dateStr = iSdf.format(date);}ItemRepository itemRepository = new ItemRepository();List<Item> items = itemRepository.getAll();Map<Long, String> itemsCatalogIdNameMap = new HashMap<Long, String>();for (Item item : items) {itemsCatalogIdNameMap.put(item.getCatalogId(), item.getName());}ItemActivityWithSourceRepository itemActivityRepository = new ItemActivityWithSourceRepository();List<ItemActivityWithSource> itemActivities = itemActivityRepository.getByDate(date);%><form id="frmProductActivity" name="frmProductActivity" method="post" action="/jsp/product-activity-with-source.jsp"><label>Date(YYYYMMDD) : </label> <input type="text" name="date" id="date" value="<%= dateStr %>"/><input type="submit" name="submit" id="submit" value="Submit"/><br/></form><table cellpadding="0" cellspacing="0" border="0" class="display"id="prodFunnel"><thead><tr><th>Product</th><th>Source</th><th>Paid</th><th>SessSource</th><th>Paid</th><th>View</th><th>Unique</th><th>AddCart</th><th>Unique</th><th>Shipping</th><th>Unique</th><th>ProceedPay</th><th>Unique</th><th>OrderCreation</th><th>Unique</th><th>PayFail</th><th>Unique</th><th>PayOk</th><th>Unique</th><th>DelCart</th><th>Unique</th><th>AddResearch</th><th>Unique</th><th>DelResearch</th><th>Unique</th></tr></thead><tbody><%int rowId = 0;for (ItemActivityWithSource itemActivity : itemActivities) {rowId++;%><tr id="tr-<%=rowId%>"><td><%=itemsCatalogIdNameMap.get(itemActivity.getCatalogId())==null? itemActivity.getCatalogId() : itemsCatalogIdNameMap.get(itemActivity.getCatalogId())%><a href="#" class="show-chart"rowId="<%=rowId%>">chart</a></td><td><%=itemActivity.getFirstSource()%></td><td><%=itemActivity.getIsPaidFirstSource()%></td><td><%=itemActivity.getSessionSource()%></td><td><%=itemActivity.getIsPaidSessionSource()%></td><td countAttr="view"><%=itemActivity.getView()==null? 0 : itemActivity.getView()%></td><td countAttr="unique_view"><%=itemActivity.getUniqueView()==null? 0 : itemActivity.getUniqueView()%></td><td countAttr="cart"><%=itemActivity.getAddToCart()==null? 0 : itemActivity.getAddToCart()%></td><td countAttr="unique_cart"><%=itemActivity.getUniqueAddToCart()==null? 0 : itemActivity.getUniqueAddToCart()%></td><td countAttr="shipping"><%=itemActivity.getShippingAccess()==null? 0 : itemActivity.getShippingAccess()%></td><td countAttr="unique_shipping"><%=itemActivity.getUniqueShippingAccess()==null? 0 : itemActivity.getUniqueShippingAccess()%></td><td countAttr="pay"><%=itemActivity.getProceedToPay()==null? 0 : itemActivity.getProceedToPay()%></td><td countAttr="unique_pay"><%=itemActivity.getUniqueProceedToPay()==null? 0 : itemActivity.getUniqueProceedToPay()%></td><td countAttr="order"><%=itemActivity.getOrderCreation()==null? 0 : itemActivity.getOrderCreation()%></td><td countAttr="unique_order"><%=itemActivity.getUniqueOrderCreation()==null? 0 : itemActivity.getUniqueOrderCreation()%></td><td countAttr="pay_fail"><%=itemActivity.getPaymentFailure()==null? 0 : itemActivity.getPaymentFailure()%></td><td countAttr="unique_pay_fail"><%=itemActivity.getUniquePaymentFailure()==null? 0 : itemActivity.getUniquePaymentFailure()%></td><td countAttr="pay_ok"><%=itemActivity.getPaymentSuccess()==null? 0 : itemActivity.getPaymentSuccess()%></td><td countAttr="unique_pay_ok"><%=itemActivity.getUniquePaymentSuccess()==null? 0 : itemActivity.getUniquePaymentSuccess()%></td><td><%=itemActivity.getDeleteFromCart()==null? 0 : itemActivity.getDeleteFromCart()%></td><td><%=itemActivity.getUniqueDeleteFromCart()==null? 0 : itemActivity.getUniqueDeleteFromCart()%></td><td><%=itemActivity.getAddToResearch()==null? 0 : itemActivity.getAddToResearch()%></td><td><%=itemActivity.getUniqueAddToResearch()==null? 0 : itemActivity.getUniqueAddToResearch()%></td><td><%=itemActivity.getDeleteFromResearch()==null? 0 : itemActivity.getDeleteFromResearch()%></td><td><%=itemActivity.getUniqueDeleteFromResearch()==null? 0 : itemActivity.getUniqueDeleteFromResearch()%></td></tr><%}%></tbody></table><div id="placeholder" style="width:800px;height:300px;"></div><script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.js"></script><script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.dataTables.min.js"></script><script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/ZeroClipboard.js"></script><script type="text/javascript" charset="utf-8" src="/DataTables/extras/TableTools/media/js/TableTools.js"></script><script type="text/javascript" charset="utf-8" src="/js/flot/jquery.flot.js"></script><script type="text/javascript" charset="utf-8">$(document).ready(function() {$('#prodFunnel').dataTable({"sPaginationType": "full_numbers","iDisplayLength": 15,"bProcessing": true,"aaSorting": [[5,'desc']],"sDom": 'T<"clear">lfrtip',"oTableTools": {"sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"},"aLengthMenu": [[10, 15, 25, 50, 100, -1], [10, 15, 25, 50, 100, "All"]]});} );$('.show-chart').click(function() {var d1 = [];var d2 = [];var x = [];var index = 0;alert($(this).attr('rowId'));$('#tr-' + $(this).attr('rowId')).children('[countAttr]').each(function() {var countAttr = $(this).attr('countAttr');var count = $(this).text();if (countAttr.indexOf('unique_') != -1) {index = x.length - 1;d2.push([index, count]);}else {index = x.length;x.push([index, countAttr]);d1.push([index, count]);}});$.plot($("#placeholder"), [{ label: "Count", data: d1},{ label: "Unique Count", data: d2}], {series: {lines: { show: true },points: { show: true }},xaxis: {ticks: x},grid: {backgroundColor: { colors: ["#fff", "#eee"] }}});});</script></body></html>