@SuppressWarnings("rawtypes") public String getResolverData() { String returnResult = ERROR; boolean sessionFlag = ValidateSession.checkSession(); if (sessionFlag) { try { SessionFactory connectionSpace = (SessionFactory) session.get("connectionSpace"); HelpdeskUniversalAction HUA = new HelpdeskUniversalAction(); ComplaintLodgeHelper CLH = new ComplaintLodgeHelper(); String deptFor = ""; List empdata = new ArrayList<String>(); List feedbackList = HUA.getMultipleColumns( "complaint_status", "forDept", "", "allot_to", "level", "", "id", feedid, "", "", connectionSpace); if (feedbackList != null && feedbackList.size() > 0) { for (Iterator iterator = feedbackList.iterator(); iterator.hasNext(); ) { Object[] object = (Object[]) iterator.next(); deptFor = object[0].toString(); } empdata = CLH.getEmp4Escalation(deptFor, "DREAM_HDM", "", connectionSpace); jsonArr = new JSONArray(); JSONObject formDetailsJson = null; for (Object c : empdata) { Object[] dataC_new = (Object[]) c; formDetailsJson = new JSONObject(); formDetailsJson.put("ID", dataC_new[0].toString()); formDetailsJson.put("NAME", dataC_new[1].toString()); jsonArr.add(formDetailsJson); } } returnResult = SUCCESS; } catch (Exception e) { e.printStackTrace(); } } else { returnResult = LOGIN; } return returnResult; }
@SuppressWarnings("rawtypes") public String updateFeedbackStatus() { String returnResult = ERROR; boolean sessionFlag = ValidateSession.checkSession(); if (sessionFlag) { try { HelpdeskUniversalHelper HUH = new HelpdeskUniversalHelper(); new HelpdeskUniversalAction(); MsgMailCommunication MMC = new MsgMailCommunication(); FeedbackPojo fbp = new FeedbackPojo(); String duration = "NA"; Map<String, Object> wherClause = new HashMap<String, Object>(); Map<String, Object> condtnBlock = new HashMap<String, Object>(); String snDate = "", snTime = "", snUpToDate = "", snUpToTime = "", snDuration = ""; List ticketData = new HelpdeskUniversalAction() .getMultipleColumns( "complaint_status", "sn_on_date", "sn_on_time", "sn_upto_date", "sn_upto_time", "sn_duration", "id", getFeedid(), "", "", connectionSpace); if (ticketData != null && ticketData.size() > 0) { for (Iterator iterator = ticketData.iterator(); iterator.hasNext(); ) { Object[] object = (Object[]) iterator.next(); if (object[0] != null && !object[0].toString().equals("")) { snDate = object[0].toString(); } else { snDate = "NA"; } if (object[1] != null && !object[1].toString().equals("")) { snTime = object[1].toString(); } else { snTime = "NA"; } if (object[2] != null && !object[2].toString().equals("")) { snUpToDate = object[2].toString(); } else { snUpToDate = "NA"; } if (object[3] != null && !object[3].toString().equals("")) { snUpToTime = object[3].toString(); } else { snUpToTime = "NA"; } if (object[4] != null && !object[4].toString().equals("")) { snDuration = object[4].toString(); } else { snDuration = "NA"; } } } if (getStatus().equalsIgnoreCase("Resolved")) { String cal_duration = ""; if (open_date != null && !open_date.equals("") && open_time != null && !open_time.equals("")) { duration = DateUtil.time_difference( DateUtil.convertDateToUSFormat(open_date), open_time, DateUtil.getCurrentDateUSFormat(), DateUtil.getCurrentTime()); } if (!snDuration.equals("") && !snDuration.equals("NA")) { boolean flag = DateUtil.time_update(snUpToDate, snUpToTime); if (flag) { cal_duration = DateUtil.getTimeDifference(duration, snDuration); if (cal_duration != null && !cal_duration.equals("") && !cal_duration.contains("-")) { duration = cal_duration; } } else { String newduration = DateUtil.time_difference( snDate, snTime, DateUtil.getCurrentDateUSFormat(), DateUtil.getCurrentTime()); if (newduration != null && !newduration.equals("") && !newduration.equals("NA")) { String new_cal_duration = DateUtil.getTimeDifference(duration, newduration); if (new_cal_duration != null && !new_cal_duration.equals("") && !new_cal_duration.contains("-")) { duration = new_cal_duration; } } } } wherClause.put("status", getStatus()); wherClause.put("action_by", userName); wherClause.put("resolve_date", DateUtil.getCurrentDateUSFormat()); wherClause.put("resolve_time", DateUtil.getCurrentTime()); wherClause.put("resolve_duration", duration); wherClause.put("resolve_remark", DateUtil.makeTitle(getRemark())); wherClause.put("resolve_by", getResolver()); wherClause.put("spare_used", getSpareused()); wherClause.put("resolve_rca", getRca()); wherClause.put("resolve_capa", getCapa()); condtnBlock.put("id", getFeedid()); } else if (getStatus().equalsIgnoreCase("Snooze")) { if (snDate.equals("NA") || snTime.equals("NA")) { if (snoozeDate != null && !snoozeDate.equals("") && snoozeTime != null && !snoozeTime.equals("")) { duration = DateUtil.time_difference( DateUtil.getCurrentDateUSFormat(), DateUtil.getCurrentTime(), DateUtil.convertDateToUSFormat(snoozeDate), snoozeTime); } } else { if (snoozeDate != null && !snoozeDate.equals("") && snoozeTime != null && !snoozeTime.equals("")) { duration = DateUtil.time_difference( snDate, snTime, DateUtil.convertDateToUSFormat(snoozeDate), snoozeTime); } } wherClause.put("status", getStatus()); wherClause.put("sn_reason", DateUtil.makeTitle(getSnoozecomment())); if (snDate.equals("NA") || snTime.equals("NA")) { wherClause.put("sn_on_date", DateUtil.getCurrentDateUSFormat()); wherClause.put("sn_on_time", DateUtil.getCurrentTime()); } wherClause.put("sn_upto_date", DateUtil.convertDateToUSFormat(snoozeDate)); wherClause.put("sn_upto_time", snoozeTime); wherClause.put("sn_duration", duration); wherClause.put("action_by", userName); condtnBlock.put("id", getFeedid()); } else if (getStatus().equalsIgnoreCase("High Priority")) { wherClause.put("status", getStatus()); wherClause.put("hp_date", DateUtil.getCurrentDateUSFormat()); wherClause.put("hp_time", DateUtil.getCurrentTime()); wherClause.put("hp_reason", DateUtil.makeTitle(getHpcomment())); wherClause.put("action_by", userName); condtnBlock.put("id", getFeedid()); } else if (getStatus().equalsIgnoreCase("Ignore")) { wherClause.put("status", getStatus()); wherClause.put("ig_date", DateUtil.getCurrentDateUSFormat()); wherClause.put("ig_time", DateUtil.getCurrentTime()); wherClause.put("ig_reason", DateUtil.makeTitle(getIgnorecomment())); wherClause.put("action_by", userName); condtnBlock.put("id", getFeedid()); } /*else if (getStatus().equalsIgnoreCase("Re-Assign")) { String feedBy="NA",mobNo="NA",emailId="NA",bysubdept="NA",feedBrief="NA",location="NA"; List existTicketData = new HelpdeskUniversalHelper().getTransferTicketData(getFeedid(), connectionSpace); if (existTicketData!=null && existTicketData.size()>0) { for (Iterator iterator = existTicketData.iterator(); iterator .hasNext();) { Object[] object = (Object[]) iterator.next(); if (object[0]!=null && !object[0].toString().equals("")) { feedBy=object[0].toString(); } if (object[1]!=null && !object[1].toString().equals("")) { mobNo=object[1].toString(); } if (object[2]!=null && !object[2].toString().equals("")) { emailId=object[2].toString(); } if (object[3]!=null && !object[3].toString().equals("")) { bysubdept=object[3].toString(); } if (object[4]!=null && !object[4].toString().equals("")) { feedBrief=object[4].toString(); } if (object[5]!=null && !object[5].toString().equals("")) { location=object[5].toString(); } } boolean flag = transferComplaint(feedBy,mobNo,emailId,bysubdept,feedBrief,location,getFeedid()); if (flag) { wherClause.put("status", "Transfer"); wherClause.put("transfer_date", DateUtil.getCurrentDateUSFormat()); wherClause.put("transfer_time", DateUtil.getCurrentTime()); wherClause.put("transfer_reason", DateUtil.makeTitle(getReAssignRemark())); wherClause.put("action_by", userName); condtnBlock.put("id", getFeedid()); } } }*/ boolean updateFeed = HUH.updateTableColomn("complaint_status", wherClause, condtnBlock, connectionSpace); if (updateFeed) { ComplaintLodgeHelper CLH = new ComplaintLodgeHelper(); String levelMsg = "", complainatMsg = "", mailText = "", mailSubject = "", mailheading = ""; List data = CLH.getFeedbackDetail(getFeedid(), getStatus(), connectionSpace); if (data != null && data.size() > 0) { fbp = CLH.setFeedbackDataValues(data, getStatus(), connectionSpace); } if (getStatus().equalsIgnoreCase("Resolved")) { // levelMsg = "Close Feedback Alert: Ticket No: " + fbp.getTicket_no() + ", Reg. By: " + // DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", Location: " + // fbp.getLocation() + ", Brief: " + remark + " is Closed."; // complainatMsg = "Dear " + DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", // Ticket No: " + fbp.getTicket_no() + ", Location: " + fbp.getLocation() + ", Brief: " // + remark + " is Closed."; mailSubject = "Close Ticket Alert: " + fbp.getTicket_no(); mailheading = "Close Ticket Alert: " + fbp.getTicket_no(); } else if (getStatus().equalsIgnoreCase("High Priority")) { // levelMsg = "High Priority Alert: Ticket No: " + fbp.getTicket_no() + ", Reg. By : " + // DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", Location: " + // fbp.getLocation() + ", Brief: " + fbp.getFeed_brief() + ",Reason: " + // fbp.getHp_reason() + "."; // complainatMsg = "Dear " + DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", // Ticket No: " + fbp.getTicket_no() + ", Location: " + fbp.getLocation() + ", Brief: " // + fbp.getFeed_brief() + ",Reason: " + fbp.getHp_reason() + " is on High Priority."; mailSubject = "High Priority Feedback Alert: " + fbp.getTicket_no(); mailheading = "High Priority Case Ticket Alert"; } else if (getStatus().equalsIgnoreCase("Snooze")) { // levelMsg = "Snooze Alert: Ticket No: " + fbp.getTicket_no() + ", Reg. By: " + // DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", Location: " + // fbp.getLocation() + ", Brief: " + fbp.getFeed_brief() + " will be Snoozed till " + // fbp.getSn_duration() + ",Reason: " + fbp.getSn_reason() + "."; // complainatMsg = "Dear " + DateUtil.makeTitle(fbp.getFeed_registerby().trim()) + ", // Ticket No: " + fbp.getTicket_no() + ", Location: " + fbp.getLocation() + ", Brief: " // + fbp.getFeed_brief() + ",Status: Snoozed to " + fbp.getSn_on_date() + " " + // fbp.getSn_on_time() + " Hrs, Reason:" + fbp.getSn_reason() + "."; mailSubject = "Snooze Feedback Alert: " + fbp.getTicket_no(); mailheading = "Snooze Case Ticket Alert"; } else if (getStatus().equalsIgnoreCase("Ignore")) { // levelMsg = "Ignore Feedback Alert: Ticket No: " + fbp.getTicket_no() + ", Reg. By: " // + DateUtil.makeTitle(fbp.getFeed_registerby()) + ", Location: " + fbp.getLocation() + // ", Brief: " + fbp.getFeed_brief() + ",Reason: " + fbp.getIg_reason() + " should be // Ignored."; // complainatMsg = "Dear " + DateUtil.makeTitle(fbp.getFeed_registerby()) + ", Ticket // No: " + fbp.getTicket_no() + ", Location: " + fbp.getLocation() + ", Brief: " + // fbp.getFeed_brief() + ",Reason: " + fbp.getIg_reason() + " is Ignored."; mailSubject = "Ignore Feedback Alert: " + fbp.getTicket_no(); mailheading = "Ignore Case Ticket Alert"; } if (getStatus().equalsIgnoreCase("Resolved")) { /*if (fbp.getFeedback_by_mobno() != null && fbp.getFeedback_by_mobno() != "" && fbp.getFeedback_by_mobno().trim().length() == 10 && (fbp.getFeedback_by_mobno().startsWith("9") || fbp.getFeedback_by_mobno().startsWith("8") || fbp.getFeedback_by_mobno().startsWith("7"))) { MMC.addMessage(fbp.getFeed_registerby(), fbp.getFeedback_by_dept(), fbp.getFeedback_by_mobno(), complainatMsg, ticket_no, getStatus(), "0", "HDM"); }*/ if (fbp.getFeedback_by_emailid() != null && !fbp.getFeedback_by_emailid().equals("")) { mailText = CLH.getConfigMessage( fbp, mailheading, getStatus(), false, fbp.getClientFor(), fbp.getClientName(), fbp.getOfferingName()); MMC.addMail( fbp.getFeed_registerby(), fbp.getFeedback_by_dept(), fbp.getFeedback_by_emailid(), mailSubject, mailText, ticket_no, getStatus(), "0", "", "DREAM_HDM"); } /*if (fbp.getResolve_by_mobno() != null && fbp.getResolve_by_mobno() != "" && fbp.getResolve_by_mobno().trim().length() == 10 && (fbp.getResolve_by_mobno().startsWith("9") || fbp.getResolve_by_mobno().startsWith("8") || fbp.getResolve_by_mobno().startsWith("7"))) { MMC.addMessage(fbp.getResolve_by(), fbp.getFeedback_to_dept(), fbp.getResolve_by_mobno(), levelMsg, ticket_no, getStatus(), "0", "HDM"); }*/ if (fbp.getResolve_by_emailid() != null && !fbp.getResolve_by_emailid().equals("")) { mailText = CLH.getConfigMessage( fbp, mailheading, getStatus(), true, fbp.getClientFor(), fbp.getClientName(), fbp.getOfferingName()); MMC.addMail( fbp.getResolve_by(), fbp.getFeedback_to_dept(), fbp.getResolve_by_emailid(), mailSubject, mailText, fbp.getTicket_no(), "Pending", "0", "", "DREAM_HDM"); } } else if (getStatus().equalsIgnoreCase("High Priority") || getStatus().equalsIgnoreCase("Snooze") || getStatus().equalsIgnoreCase("Ignore")) { /* if (fbp.getFeedback_by_mobno() != null && fbp.getFeedback_by_mobno() != "" && fbp.getFeedback_by_mobno().trim().length() == 10 && (fbp.getFeedback_by_mobno().startsWith("9") || fbp.getFeedback_by_mobno().startsWith("8") || fbp.getFeedback_by_mobno().startsWith("7"))) { MMC.addMessage(fbp.getFeed_registerby(), fbp.getFeedback_by_dept(), fbp.getFeedback_by_mobno(), complainatMsg, ticket_no, getStatus(), "0", "HDM"); } */ if (fbp.getFeedback_by_emailid() != null && !fbp.getFeedback_by_emailid().equals("")) { mailText = CLH.getConfigMessage( fbp, mailheading, getStatus(), false, fbp.getClientFor(), fbp.getClientName(), fbp.getOfferingName()); MMC.addMail( fbp.getFeed_registerby(), fbp.getFeedback_by_dept(), fbp.getFeedback_by_emailid(), mailSubject, mailText, ticket_no, getStatus(), "0", "", "DREAM_HDM"); } /*if (fbp.getMobOne() != null && fbp.getMobOne() != "" && fbp.getMobOne().trim().length() == 10 && (fbp.getMobOne().startsWith("9") || fbp.getMobOne().startsWith("8") || fbp.getMobOne().startsWith("7"))) { MMC.addMessage(fbp.getFeedback_allot_to(), fbp.getFeedback_to_dept(), fbp.getMobOne(), levelMsg, ticket_no, getStatus(), "0", "HDM"); }*/ if (fbp.getEmailIdOne() != null && !fbp.getEmailIdOne().equals("")) { mailText = CLH.getConfigMessage( fbp, mailheading, getStatus(), true, fbp.getClientFor(), fbp.getClientName(), fbp.getOfferingName()); MMC.addMail( fbp.getFeedback_allot_to(), fbp.getFeedback_to_dept(), fbp.getEmailIdOne(), mailSubject, mailText, fbp.getTicket_no(), "Pending", "0", "", "DREAM_HDM"); } } addActionMessage("Feedback Updated in " + getStatus() + " Successfully !!!"); returnResult = SUCCESS; } } catch (Exception e) { e.printStackTrace(); } } else { returnResult = LOGIN; } return returnResult; }
@SuppressWarnings("rawtypes") public String getFeedbackDetail() { String returnResult = ERROR; boolean sessionFlag = ValidateSession.checkSession(); if (sessionFlag) { try { String userName = (String) session.get("uName"); SessionFactory connectionSpace = (SessionFactory) session.get("connectionSpace"); ComplaintLodgeHelper CLH = new ComplaintLodgeHelper(); feedbackList = new ArrayList<FeedbackPojo>(); List data = null; String dept_subdept_id = ""; String contactLoggedId = null; String[] empData = CLH.getEmpDetailsByUserName( "DREAM_HDM", Cryptography.encrypt(userName, DES_ENCRYPTION_KEY), connectionSpace); if (empData != null && empData.length > 0) { dept_subdept_id = empData[4]; contactLoggedId = empData[0]; } if (dept_subdept_id != null && !dept_subdept_id.equals("")) { if (dataFlag != null && dataFlag.equals("M")) { toDate = DateUtil.convertDateToUSFormat(toDate); fromDate = DateUtil.convertDateToUSFormat(fromDate); } else { toDate = toDate; fromDate = fromDate; } data = CLH.getFeedbackDetail( "complaint_status", getFeedStatus(), fromDate, toDate, dept_subdept_id, contactLoggedId, "feedback.id", "ASC", "DREAM_HDM", searchField, searchString, searchOper, connectionSpace); } if (data != null && data.size() > 0) { setRecords(data.size()); int to = (getRows() * getPage()); @SuppressWarnings("unused") int from = to - getRows(); if (to > getRecords()) to = getRecords(); feedbackList = CLH.setFeedbackValues(data, getFeedStatus(), connectionSpace); setTotal((int) Math.ceil((double) getRecords() / (double) getRows())); } returnResult = SUCCESS; } catch (Exception e) { addActionError("Ooops!!! There is some problem in getting Feedback Data"); e.printStackTrace(); } } else { returnResult = LOGIN; } return returnResult; }