<%@ taglib uri="struts-html" prefix="html" %> <%@ taglib uri="struts-bean" prefix="bean" %> <%@ taglib uri="struts-logic" prefix="logic" %> <%@ page language="java" import="java.sql.*"%> <%@ page import="java.io.*" %> <%@ page language="java" %> <%@ page import="com.easyinsurance.common.DashBoardPolicy"%> <%@ page import="com.easyinsurance.common.DashboardCustomer"%> <%@ page import="com.easyinsurance.common.ConnectionDB" %> <%@page import="org.apache.struts.action.DynaActionForm"%> <%@ page import="java.util.*" %> <%@ page import="java.text.SimpleDateFormat" %> <%@ page import="java.text.DateFormat" %> <%@ page import="com.easyinsurance.exception.CustomerError" %> <%@ page import="com.easyinsurance.scroller.ScrollerDAO" %> <%@ page import="com.sun.rowset.CachedRowSetImpl" %> <%@ taglib uri="http://displaytag.sf.net" prefix="display" %> <%@ page import="org.apache.commons.beanutils.RowSetDynaClass" %> <% String contextpath=request.getContextPath(); String companyList=(String) application.getAttribute("companyList"); %> Easy Insurance India - Dash Board
<% String callmestatus =""; String callid =""; String callremarks =""; String callback =""; int count =0; int inprogressco =0; int soldco =0; int nilco =0; int confirmco =0; int appointment =0; int notinterestedco =0; int noresponseco =0; int lostsaleco =0; int pendingco =0; int duplicateco =0; int languageco =0; int assistco =0; String assignstat =""; int totalreg =0; int customerregister=0; int todayregcustomer=0; int customeractive =0; String dofromdate =""; String dotodate =""; String val =""; String statusval =""; String callname =""; String callphone =""; String callemail =""; String exremarks =""; String dispose =""; String premium =""; String calldate =""; String calltime =""; String calltime1 =""; String calltime2 =""; String dispose2 =""; String company =""; String paymentMode =""; String purchaseDate =""; String insuredName =""; String callmeSource =""; int recCount =0; String userval =""; String roleval =""; String appmtFollow =""; String appmtProduct =""; String serviceCharge =""; String trackingSize="0"; String searchFromDate=""; String searchToDate=""; String searchSelect="All"; String trackingFDate=""; String trackingTDate=""; String totalRecords=""; DashboardCustomer dashCustomers=null; try{ if(session.getAttribute("dashBoardCustomer")!=null){ dashCustomers=(DashboardCustomer)session.getAttribute("dashBoardCustomer"); userval=dashCustomers.getDashLoginId(); roleval=dashCustomers.getDashCustomerRole(); }else{ response.sendRedirect("dashboard.do"); } }catch(Exception exception){System.out.println("Exception"+exception);} DashBoardPolicy dashobj=new DashBoardPolicy(); if(roleval.equalsIgnoreCase("customerservice")){ recCount=dashobj.newAssignedRecord(userval); // System.out.println("record count-->"+recCount); } if(request.getAttribute("trackingFromDate")!=null && request.getAttribute("trackingFromDate").toString().length()>0 ){ trackingFDate=(String)request.getAttribute("trackingFromDate"); searchFromDate="From Date :"+trackingFDate; } if(request.getAttribute("trackingTodate")!=null && request.getAttribute("trackingTodate").toString().length()>0){ trackingTDate=(String)request.getAttribute("trackingTodate"); searchToDate=" To Date :"+trackingTDate; } if(request.getAttribute("trackingSearchOption")!=null){ searchSelect=(String)request.getAttribute("trackingSearchOption"); } if(request.getParameter("selectoption")!=null){ searchSelect=request.getParameter("selectoption"); } if(request.getAttribute("noOfRecords")!=null){ totalRecords=""+request.getAttribute("noOfRecords"); } assignstat=request.getParameter("assigntohide"); if(assignstat !=null) userval=assignstat; else assignstat=userval; company =request.getParameter("company"); paymentMode =request.getParameter("paymentMode"); purchaseDate=request.getParameter("purchaseDate"); insuredName =request.getParameter("insuredName"); callmeSource=request.getParameter("callmeSource"); callname =request.getParameter("cnames"); callphone =request.getParameter("phonenos"); callemail =request.getParameter("emailids"); callmestatus=request.getParameter("callmestatus"); callremarks =request.getParameter("desc"); calltime =request.getParameter("calltime"); exremarks =request.getParameter("exremarks"); dispose =request.getParameter("disposition"); dispose2 =request.getParameter("dispose1"); premium =request.getParameter("preamount"); calldate =request.getParameter("calldate"); calltime =request.getParameter("calltime"); calltime1 =request.getParameter("calltime1"); appmtFollow =request.getParameter("follow"); appmtProduct =request.getParameter("product"); serviceCharge =request.getParameter("serviceCharge"); if(calldate !=null || calltime !=null) calltime1=calltime+":"+calltime1; callid =request.getParameter("callId"); statusval =request.getParameter("statusval"); dofromdate =request.getParameter("dofromDate"); dotodate =request.getParameter("dotoDate"); ArrayList dopolicyarr =new ArrayList(); nilco =dashobj.callmecount("nil",userval,roleval); soldco =dashobj.callmecount("Sold",userval,roleval); assistco =dashobj.callmecount("Online Assist",userval,roleval); confirmco =dashobj.callmecount("Confirm",userval,roleval); appointment =dashobj.callmecount("Appointment",userval,roleval); inprogressco=dashobj.callmecount("In Progress",userval,roleval); noresponseco=dashobj.callmecount("No Response",userval,roleval); lostsaleco =dashobj.callmecount("Lost Sale",userval,roleval); notinterestedco=dashobj.callmecount("Not Interested",userval,roleval); duplicateco =dashobj.callmecount("Duplicate",userval,roleval); pendingco =dashobj.callmecount("Pending",userval,roleval); languageco =dashobj.callmecount("Language",userval,roleval); ArrayList assigntoarr =new ArrayList(); assigntoarr=dashobj.callmeassignto(); ArrayList followarr =new ArrayList(); followarr=dashobj.getfollowupcustomers(userval,roleval); %>
<%@ include file="header.jsp"%>
From Date  To Date  All Nil Sold Online Assist Confirm Appointment Pending In Progress Lost Sale Language No Response Not Interest Duplicate
Print Save Email
<% String nameAccendingDisplay=""; String nameDecendingDisplay="style=display:none"; String phoneAccendingDisplay=""; String phoneDecendingDisplay="style=display:none"; String productAccendingDisplay=""; String productDecendingDisplay="style=display:none"; String timeAccendingDisplay=""; String timeDecendingDisplay="style=display:none"; String dateAccendingDisplay=""; String dateDecendingDisplay="style=display:none"; String sourceAccendingDisplay=""; String sourceDecendingDisplay="style=display:none"; String callbackAccendingDisplay=""; String callbackDecendingDisplay="style=display:none"; String mailAccendingDisplay=""; String mailDecendingDisplay="style=display:none"; String assignedAccendingDisplay=""; String assignedDecendingDisplay="style=display:none"; String str="callmetracking.do?action=show&dofromDate="+trackingFDate+"&dotoDate="+trackingTDate+"&selectoption="+ searchSelect+"&records="+totalRecords; if(session.getAttribute("sortedType")!=null){ String sType=(String)session.getAttribute("sortedType"); String sName=(String)session.getAttribute("sortedName"); if(sName.equalsIgnoreCase("customername")){ if(sType.equalsIgnoreCase("accending")){ nameAccendingDisplay="";nameDecendingDisplay="style=display:none"; }else{ nameAccendingDisplay="style=display:none";nameDecendingDisplay=""; } } if(sName.equalsIgnoreCase("phoneno")){ if(sType.equalsIgnoreCase("accending")){ phoneAccendingDisplay="";phoneDecendingDisplay="style=display:none"; }else{ phoneAccendingDisplay="style=display:none";phoneDecendingDisplay=""; } } if(sName.equalsIgnoreCase("product")){ if(sType.equalsIgnoreCase("accending")){ productAccendingDisplay="";productDecendingDisplay="style=display:none"; }else{ productAccendingDisplay="style=display:none";productDecendingDisplay=""; } } if(sName.equalsIgnoreCase("contacttime")){ if(sType.equalsIgnoreCase("accending")){ timeAccendingDisplay="";timeDecendingDisplay="style=display:none"; }else{ timeAccendingDisplay="style=display:none";timeDecendingDisplay=""; } } if(sName.equalsIgnoreCase("assigndate")){ if(sType.equalsIgnoreCase("accending")){ dateAccendingDisplay="";dateDecendingDisplay="style=display:none"; }else{ dateAccendingDisplay="style=display:none";dateDecendingDisplay=""; } } if(sName.equalsIgnoreCase("source")){ if(sType.equalsIgnoreCase("accending")){ sourceAccendingDisplay="";sourceDecendingDisplay="style=display:none"; }else{ sourceAccendingDisplay="style=display:none";sourceDecendingDisplay=""; } } if(sName.equalsIgnoreCase("callback")){ if(sType.equalsIgnoreCase("accending")){ callbackAccendingDisplay="";callbackDecendingDisplay="style=display:none"; }else{ callbackAccendingDisplay="style=display:none";callbackDecendingDisplay=""; } } if(sName.equalsIgnoreCase("emailid")){ if(sType.equalsIgnoreCase("accending")){ mailAccendingDisplay="";mailDecendingDisplay="style=display:none"; }else{ mailAccendingDisplay="style=display:none";mailDecendingDisplay=""; } } if(sName.equalsIgnoreCase("assignedby")){ if(sType.equalsIgnoreCase("accending")){ assignedAccendingDisplay="";assignedDecendingDisplay="style=display:none"; }else{ assignedAccendingDisplay="style=display:none";assignedDecendingDisplay=""; } } } String accendingImage=""+" "+decendingImage+" "+nameDecendingDisplay+" onclick=callSorting('customername','accending');>"; String phoneSorted="Phone No. "+accendingImage+" "+phoneAccendingDisplay+" onclick=callSorting('phoneno','decending');>"+decendingImage+" "+phoneDecendingDisplay+" onclick=callSorting('phoneno','accending');>"; String productSorted="Product "+accendingImage+" "+productAccendingDisplay+" onclick=callSorting('product','decending');>"+decendingImage+" "+productDecendingDisplay+" onclick=callSorting('product','accending');>"; String timeSorted="Contact Time "+accendingImage+" "+timeAccendingDisplay+" onclick=callSorting('contacttime','decending');>"+decendingImage+" "+timeDecendingDisplay+" onclick=callSorting('contacttime','accending');>"; String dateSorted="Assign Date "+accendingImage+" "+dateAccendingDisplay+" onclick=callSorting('assigndate','decending');>"+decendingImage+" "+dateDecendingDisplay+" onclick=callSorting('assigndate','accending');>"; String sourceSorted="Source "+accendingImage+" "+sourceAccendingDisplay+" onclick=callSorting('source','decending');>"+decendingImage+" "+sourceDecendingDisplay+" onclick=callSorting('source','accending');>"; String callbackSorted="Callback "+accendingImage+" "+callbackAccendingDisplay+" onclick=callSorting('callback','decending');>"+decendingImage+" "+callbackDecendingDisplay+" onclick=callSorting('callback','accending');>"; String mailSorted="Email Id "+accendingImage+" "+mailAccendingDisplay+" onclick=callSorting('emailid','decending');>"+decendingImage+" "+mailDecendingDisplay+" onclick=callSorting('emailid','accending');>"; String assignedSorted="Assigned By "+accendingImage+" "+assignedAccendingDisplay+" onclick=callSorting('assignedby','decending');>"+decendingImage+" "+assignedDecendingDisplay+" onclick=callSorting('assignedby','accending');>"; %>
Call Me Tracking  ( <% if(request.getAttribute("trackingSize")!=null){ out.println(request.getAttribute("trackingSize")); }else{ out.println("0"); } %> ) <%=searchFromDate%> <%=searchToDate%> <%=val%>   <% if(roleval.equals("management") || roleval.equals("supervisor")){ %>  <%=userval %> <% } %> Show 10 25 50 100 entries
Nil-<%=nilco%>   Sold-<%=soldco%>   OnlineAssist-<%=assistco%>   Confirm-<%=confirmco%>   Appointment-<%=appointment%>   Pending-<%=pendingco%>   InProgress-<%=inprogressco%>   LostSale-<%=lostsaleco%>   Language-<%=languageco%>   NR-<%=noresponseco%>   NI-<%=notinterestedco%>   Duplicate-<%=duplicateco%>