WebSVN – SmartDukaan – Diff – //trunk/GoogleAppDatalog/src/main/webapp/jsp/productSearchFrequency.jsp

+<%@ page import="java.util.ArrayList"%>
+<%@ page import="in.shop2020.server.SearchMetadata"%>
-<%@page import="java.util.Arrays"%>
+<%@ page import="java.util.Arrays"%>
-<%@page import="java.util.Set"%>
+<%@ page import="java.util.Set"%>
-<%@page import="java.util.Hashtable"%>
+<%@ page import="java.util.Hashtable"%>
 <%@ page import="java.util.Calendar"%>
 <%@ page import="java.util.Map.Entry"%>
 <%@ page import="java.util.Map"%>
 <%@ page import="java.text.ParseException"%>
 <%@ page import="java.util.TimeZone"%>
 <%@ page import="java.text.SimpleDateFormat"%>
 <%@ page import="java.util.Date"%>
 <%@ page import="java.util.List" %>
+<%@ page import="java.net.URLDecoder" %>
 <%@ page import="com.google.appengine.api.datastore.Query.SortDirection"%>
 <%@ page contentType="text/html;charset=UTF-8" language="java" %>
 <%@ page import="com.google.appengine.api.datastore.DatastoreServiceFactory" %>
 <%@ page import="com.google.appengine.api.datastore.DatastoreService" %>
 <%@ page import="com.google.appengine.api.datastore.Query" %>
 <%@ page import="com.google.appengine.api.datastore.Entity" %>
 <%@ page import="com.google.appengine.api.datastore.PreparedQuery" %>
+<%@	page import="in.shop2020.model.Category"%>
 <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 <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" />
 <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
 <title>Product Search</title>
 </head>
-<%
+<%!
+public Map<String,SearchMetadata> populateSearchDataMap(Map<String,SearchMetadata> productSearchFreq, Entity result){
+	String searchString = (String)result.getProperty("query");
+	if(productSearchFreq.containsKey(searchString)){
+		SearchMetadata searchObject = productSearchFreq.get(searchString);
+		//Setting number of searches
+		searchObject.setTotalSearches(searchObject.getTotalSearches()+1);
+		//setting number of search results
+		List<Long> numSearchResults =searchObject.getSearchResults();
+		numSearchResults.add((Long)result.getProperty("totalResults"));
+		searchObject.setSearchResults(numSearchResults);
+		//Setting frequency by category
+		String categoryId = Category.findByValue(Integer.parseInt(result.getProperty("categoryId").toString())).toString();
+		if(searchObject.getcategoryFrequency().containsKey(categoryId)) {
+			searchObject.getcategoryFrequency().put(categoryId, (searchObject.getcategoryFrequency().get(categoryId))+1);
+		}else {
+			searchObject.getcategoryFrequency().put(categoryId,Long.parseLong("1"));
+		}
+		//Storing session Id of query
+		if(!searchObject.getSessionIds().contains(result.getProperty("sessionId"))){
+			searchObject.getSessionIds().add(result.getProperty("sessionId"));
+		}
+		productSearchFreq.put(searchString, searchObject);
+	}else{
+		SearchMetadata searchObject = new SearchMetadata();
+		//Setting frequency by category
+		String categoryId = Category.findByValue(Integer.parseInt(result.getProperty("categoryId").toString())).toString();
+		Map<String, Long> categoryFrequency = new Hashtable<String, Long>();
+		categoryFrequency.put(categoryId,Long.parseLong("1"));
+		searchObject.setcategoryFrequency(categoryFrequency);
+		//Setting number of searches
+		searchObject.setTotalSearches(Long.parseLong("1"));
+		//setting number of search results
+		List<Long> numSearchResults = new ArrayList<Long>();
+		numSearchResults.add((Long)result.getProperty("totalResults"));
+		searchObject.setSearchResults(numSearchResults);
+		//Storing session Id of query
+		List<Object> sessionList = new ArrayList<Object>();
+		sessionList.add(result.getProperty("sessionId"));
+		searchObject.setSessionIds(sessionList);
+		productSearchFreq.put(searchString,searchObject);
+	}
+	return productSearchFreq;
+}
+public Map<String,Double> populateSearchClickMap(Map<String,Double> searchClickMap, Entity result){
+	String refererUrl = (String)result.getProperty("refererUrl");
+	if(refererUrl!=null){
+		if(refererUrl.contains("search?")){
+			String clickQuery = "";
+			refererUrl = URLDecoder.decode(refererUrl);
+			clickQuery = refererUrl.split("q=")[1].split("&")[0];
+			if(searchClickMap.containsKey(clickQuery)){
+				searchClickMap.put(clickQuery, searchClickMap.get(clickQuery)+1);
+			}else{
+				searchClickMap.put(clickQuery, Double.parseDouble("1"));
+			}
+		}
+	}
+	return searchClickMap;
+}
+%>
-Date toDate = new Date();
+<% Date toDate = new Date();
 Calendar cal = Calendar.getInstance(TimeZone.getTimeZone("IST"));
 cal.add(Calendar.DAY_OF_MONTH, -2);
 Date fromDate = cal.getTime();
 SimpleDateFormat iSdf = new SimpleDateFormat("yyyyMMdd");
 String toDateStr  = request.getParameter("toDate");
         <span>Invalid Date Format</span>
 <%
+    }
     SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
     sdf.setTimeZone(TimeZone.getTimeZone("IST"));
     DatastoreService datastore = DatastoreServiceFactory.getDatastoreService();
     Query query = new Query("DataLog");
     query.addFilter("eventType", Query.FilterOperator.IN,Arrays.asList("PRODUCT_SEARCH","PRODUCT_VIEW"));
     query.addFilter("date", Query.FilterOperator.GREATER_THAN_OR_EQUAL, fromDate);
     query.addFilter("date", Query.FilterOperator.LESS_THAN_OR_EQUAL, toDate);
     PreparedQuery pq = datastore.prepare(query);
-	Map<String,Double> productSearchFreq = new Hashtable<String,Double>();
+	Map<String,SearchMetadata> productSearchFreq = new Hashtable<String,SearchMetadata>();
 	Map<String,Double> searchClickMap = new Hashtable<String,Double>();
 	for (Entity result : pq.asIterable()) {
 		if(result.getProperty("eventType").equals("PRODUCT_SEARCH")){
-			String searchString = (String)result.getProperty("query");
+			productSearchFreq = populateSearchDataMap(productSearchFreq, result);
-			if(productSearchFreq.containsKey(searchString)){
-				productSearchFreq.put(searchString, productSearchFreq.get(searchString)+1);
-			}else{
-				productSearchFreq.put(searchString,Double.parseDouble("1"));
-			}
 		}else{
-			String refererUrl = (String)result.getProperty("refererUrl");
+			//Calculating the frequency of ProductViews originating from ProductSearch
-			if(refererUrl!=null){
-				if(refererUrl.contains("search?")){
-					String clickQuery = refererUrl.split("q=")[1].split("&")[0];
-					if(searchClickMap.containsKey(clickQuery)){
-						searchClickMap.put(clickQuery, searchClickMap.get(clickQuery)+1);
+			searchClickMap = populateSearchClickMap(searchClickMap,result);
-					}else{
-						searchClickMap.put(clickQuery, Double.parseDouble("1"));
-					}
-				}
-			}
+		}
+	}
 %>
 <table cellpadding="0" cellspacing="0" border="0" class="display" id="productSearch">
 	<thead>
 		<tr>
 			<th>Query String</th>
+			<th>Total Search Count</th>
+			<th>No Category</th>
+			<th>Mobile Phones</th>
-			<th>Frequency</th>
+			<th>Tablets</th>
+			<th>Laptops</th>
+			<th>Accessories</th>
+			<th>Session Count</th>
+			<th>Average No. of Results</th>
 			<th>Search Result Clicked</th>
-			<th>Search Conversion </th>
+			<th>Search Conversion (%) </th>
 		</tr>
 	</thead>
 	<tbody>
 	<% 	Set<String> querySet= productSearchFreq.keySet();
 				for (String productQuery:querySet){
+					Double searchConversionRate = (((searchClickMap.get(productQuery))==null ? 0 : searchClickMap.get(productQuery))*100/(productSearchFreq.get(productQuery).getTotalSearches()));
+					searchConversionRate = ((double)((long)(searchConversionRate*100)))/100; //Truncating to 2 decimal places
 	%>
 		<tr>
 			<td><a href="/jsp/productSearch.jsp?productQuery=<%=productQuery.toString()%>&toDate=<%=toDateStr%>&fromDate=<%=fromDateStr%>"><%=productQuery%></a></td>
-			<td><%=productSearchFreq.get(productQuery).intValue()%></td>
+			<td><%=productSearchFreq.get(productQuery).getTotalSearches()%></td>
+			<%
+				Set<String> searchCategories = productSearchFreq.get(productQuery).getcategoryFrequency().keySet();
+				List<String> categories = new ArrayList<String>();
+				categories.add("NA");
+				categories.add("Mobile_Phones");
+				categories.add("Tablets");
+				categories.add("Laptops");
+				categories.add("Mobile_Accessories");
+				for(String category : categories){
+					Long searchinCategory = productSearchFreq.get(productQuery).getcategoryFrequency().get(category);
+			%>
+			<td>
+				<%=searchinCategory==null ? 0 : searchinCategory %>
+			</td>
+			<% }%>
+			<%
+			long tempSum = 0;
+			for(Long numOfSearchResults : productSearchFreq.get(productQuery).getSearchResults()){
+				tempSum+=numOfSearchResults;
+			}%>
+			<td><%=(productSearchFreq.get(productQuery).getSessionIds()==null ? 0 : productSearchFreq.get(productQuery).getSessionIds().size()) %></td>
+			<td><%=tempSum/productSearchFreq.get(productQuery).getTotalSearches() %></td>
 			<td><%=(searchClickMap.get(productQuery))==null ? 0 : searchClickMap.get(productQuery).intValue() %></td>
-			<td><%=(((searchClickMap.get(productQuery))==null ? 0 : searchClickMap.get(productQuery))*100/productSearchFreq.get(productQuery)) +"%"%></td>
+			<td><%=searchConversionRate%></td>
         </tr>
     <%}%>
 	</tbody>
 </table>
 <script type="text/javascript" language="javascript" src="/DataTables/media/js/jquery.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">
         $(document).ready(function() {
             $('#productSearch').dataTable({
             	"sPaginationType": "full_numbers",
-            	"aaSorting" : [ [ 1, 'desc' ] ],
+            	"aaSorting" : [ [ 2, 'desc' ] ],
             	"bProcessing": true,
                 "bStateSave": true,
             	"sDom": 'T<"clear">lfrtip',
                 "oTableTools": {
                     "sSwfPath": "/DataTables/extras/TableTools/media/swf/copy_cvs_xls_pdf.swf"
                 },
                 "aoColumns": [
                           { "bSearchable": true },
-                          null,
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
-                          null,
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
-			  null
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" },
+                          { "sSortDataType": "dom-text", "sType": "numeric" }
+                ]
             });
         } );
     </script>
 </body>

Subversion Repositories SmartDukaan

(root)//trunk/GoogleAppDatalog/src/main/webapp/jsp/productSearchFrequency.jsp – Rev 4638 → 4744