@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", "unchecked"})
public String viewDARReportData() {
if (ValidateSession.checkSession()) {
try {
SessionFactory connectionSpace = (SessionFactory) session.get("connectionSpace");
CommonOperInterface cbt = new CommonConFactory().createInterface();
String accountID = (String) session.get("accountid");
String userName = (String) session.get("uName");
DARReportHelper DRH = new DARReportHelper();
TaskRegistrationHelper TRH = new TaskRegistrationHelper();
StringBuilder query = new StringBuilder("");
query.append("select count(*) from task_registration");
List dataCount = cbt.executeAllSelectQuery(query.toString(), connectionSpace);
if (dataCount != null) {
BigInteger count = new BigInteger("3");
Object obdata = null;
for (Iterator it = dataCount.iterator(); it.hasNext(); ) {
obdata = (Object) it.next();
count = (BigInteger) obdata;
}
setRecords(count.intValue());
int to = (getRows() * getPage());
if (to > getRecords()) to = getRecords();
String userEmpID = null;
String alltedTo = null;
String empIdofuser = (String) session.get("empIdofuser");
if (empIdofuser == null || empIdofuser.split("-")[1].trim().equals("")) return ERROR;
userEmpID = empIdofuser.split("-")[1].trim();
String userContID = null;
userContID = TRH.getEmpDetailsByUserName("DAR", userName, connectionSpace)[0];
alltedTo = TRH.getContactListForReports(userEmpID, userContID, connectionSpace);
// System.out.println(">>>>>> FINAL CONTACT LIST IS AS :::: "+alltedTo);
query.setLength(0);
query.append("SELECT ");
List fieldNames =
Configuration.getColomnList(
"mapped_dar_configuration", accountID, connectionSpace, "dar_configuration");
List<Object> Listhb = new ArrayList<Object>();
int i = 0;
for (Iterator it = fieldNames.iterator(); it.hasNext(); ) {
obdata = (Object) it.next();
if (obdata != null) {
if (!obdata.toString().equalsIgnoreCase("userName")
&& !obdata.toString().equalsIgnoreCase("date")
&& !obdata.toString().equalsIgnoreCase("time")) {
if (obdata.toString().equalsIgnoreCase("tasktype")) {
query.append("ty.tasktype" + ",");
} else if (obdata.toString().equalsIgnoreCase("allotedto")) {
query.append("emp1.empName as allotedto,");
} else if (obdata.toString().equalsIgnoreCase("allotedby")) {
query.append("emp2.empName as allotedby,");
} else if (obdata.toString().equalsIgnoreCase("validate_By_2")) {
query.append("emp3.empName as val2,");
} else if (obdata.toString().equalsIgnoreCase("validate_By_1")) {
query.append("emp4.empName as val1,");
} else if (obdata.toString().equalsIgnoreCase("guidance")) {
query.append("emp5.empName as guidance,");
} else {
query.append("tr." + obdata.toString() + ",");
}
}
}
i++;
}
fieldNames.remove("userName");
fieldNames.remove("date");
fieldNames.remove("time");
i = 0;
List gridFields = new ArrayList();
List fieldNames1 =
Configuration.getColomnList(
"mapped_dar_configuration",
accountID,
connectionSpace,
"dar_submission_configuration");
for (Iterator it = fieldNames1.iterator(); it.hasNext(); ) {
obdata = (Object) it.next();
if (obdata != null) {
if (!obdata.toString().equalsIgnoreCase("taskname")
&& !obdata.toString().equalsIgnoreCase("id")
&& !obdata.toString().equalsIgnoreCase("userName")) {
gridFields.add(obdata.toString());
if (i < fieldNames1.size() - 1) query.append("ds." + obdata.toString() + ",");
else query.append("ds." + obdata.toString());
}
}
i++;
}
query.append(" FROM task_registration AS tr ");
query.append(" LEFT JOIN dar_submission AS ds ON ds.taskname=tr.id ");
query.append("LEFT JOIN compliance_contacts AS cc1 ON tr.allotedto=cc1.id ");
query.append("LEFT JOIN compliance_contacts AS cc2 ON tr.allotedby=cc2.id ");
query.append("LEFT JOIN compliance_contacts AS cc3 ON tr.validate_By_2=cc3.id ");
query.append("LEFT JOIN compliance_contacts AS cc4 ON tr.validate_By_1=cc4.id ");
query.append("LEFT JOIN compliance_contacts AS cc5 ON tr.guidance=cc5.id ");
query.append("LEFT JOIN employee_basic emp1 ON cc1.emp_id= emp1.id ");
query.append("LEFT JOIN employee_basic emp2 ON cc2.emp_id= emp2.id ");
query.append("LEFT JOIN employee_basic emp3 ON cc3.emp_id= emp3.id ");
query.append("LEFT JOIN employee_basic emp4 ON cc4.emp_id= emp4.id ");
query.append("LEFT JOIN employee_basic emp5 ON cc5.emp_id= emp5.id ");
query.append("LEFT JOIN task_type ty ON tr.tasktype= ty.id ");
if (fdate.split("-")[0].length() < 3) {
fdate = DateUtil.convertDateToUSFormat(fdate);
tdate = DateUtil.convertDateToUSFormat(tdate);
}
query.append(" WHERE ds.date BETWEEN '" + fdate + "' AND '" + tdate + "' ");
if (allotTo != null && !allotTo.equalsIgnoreCase("-1")) {
query.append(" AND tr.allotedTo='" + allotTo + "' ");
}
if (clientFor != null && !clientFor.equalsIgnoreCase("-1")) {
query.append(" AND tr.clientfor='" + clientFor + "' ");
}
if (taskTyp != null && !taskTyp.equalsIgnoreCase("-1")) {
query.append(" AND tr.tasktype='" + taskTyp + "' ");
}
if (taskPriority != null && !taskPriority.equalsIgnoreCase("-1")) {
query.append(" AND tr.priority='" + taskPriority + "' ");
}
if (statusWork != null && !statusWork.equalsIgnoreCase("-1")) {
query.append(" AND tr.status='" + statusWork + "' ");
}
if (alltedTo != null && alltedTo.length() > 0) {
query.append(" AND tr.allotedTo IN (" + alltedTo + ") ");
}
if (getSearchField() != null
&& getSearchString() != null
&& !getSearchField().equalsIgnoreCase("")
&& !getSearchString().equalsIgnoreCase("")) {
query.append(" and ");
if (getSearchOper().equalsIgnoreCase("eq")) {
query.append(" " + getSearchField() + " = '" + getSearchString() + "'");
} else if (getSearchOper().equalsIgnoreCase("cn")) {
query.append(" " + getSearchField() + " like '%" + getSearchString() + "%'");
} else if (getSearchOper().equalsIgnoreCase("bw")) {
query.append(" " + getSearchField() + " like '" + getSearchString() + "%'");
} else if (getSearchOper().equalsIgnoreCase("ne")) {
query.append(" " + getSearchField() + " <> '" + getSearchString() + "'");
} else if (getSearchOper().equalsIgnoreCase("ew")) {
query.append(" " + getSearchField() + " like '%" + getSearchString() + "'");
}
}
System.out.println("QUERY OF REPORT IS AS :::: " + query.toString());
List data = cbt.executeAllSelectQuery(query.toString(), connectionSpace);
for (int k = 0; k < gridFields.size(); k++) {
fieldNames.add(gridFields.get(k).toString());
}
if (data != null && data.size() > 0) {
String clientData = null;
String clientVal = null;
Object[] obdata11 = null;
for (Iterator it = data.iterator(); it.hasNext(); ) {
obdata11 = (Object[]) it.next();
Map<String, Object> one = new HashMap<String, Object>();
for (int k = 0; k < fieldNames.size(); k++) {
if (fieldNames.get(k) != null
&& obdata11[k] != null
&& !obdata11[k].toString().equalsIgnoreCase("")) {
if (obdata11[k].toString().matches("\\d{4}-[01]\\d-[0-3]\\d")) {
one.put(
fieldNames.get(k).toString(),
DateUtil.convertDateToIndianFormat(obdata11[k].toString()));
}
/*else if(fieldNames.get(k).toString().equalsIgnoreCase("attachment")|| fieldNames.get(k).toString().equalsIgnoreCase("attachmentt")||fieldNames.get(k).toString().equalsIgnoreCase("reviewDoc") )
{
String str=obdata11[k].toString().substring(obdata11[k].toString().indexOf("//"), obdata11[k].toString().length());
String docName=str.substring(14,str.length());
one.put(fieldNames.get(k).toString(),docName);
}*/
else if (fieldNames.get(k).toString().equalsIgnoreCase("clientfor")) {
clientVal = obdata11[k].toString();
if (obdata11[k].toString().equalsIgnoreCase("PA")) {
one.put(fieldNames.get(k).toString(), "Prospect Associate");
} else if (obdata11[k].toString().equalsIgnoreCase("PC")) {
one.put(fieldNames.get(k).toString(), "Prospect Client");
} else if (obdata11[k].toString().equalsIgnoreCase("N")) {
one.put(fieldNames.get(k).toString(), "Other");
} else if (obdata11[k].toString().equalsIgnoreCase("EC")) {
one.put(fieldNames.get(k).toString(), "Existing Client");
} else if (obdata11[k].toString().equalsIgnoreCase("EA")) {
one.put(fieldNames.get(k).toString(), "Existing Associate");
} else if (obdata11[k].toString().equalsIgnoreCase("IN")) {
one.put(fieldNames.get(k).toString(), "Internal");
}
} else if (fieldNames.get(k).toString().equalsIgnoreCase("cName")) {
clientData = obdata11[k].toString();
one.put(
fieldNames.get(k).toString(),
DRH.clientName(clientVal, obdata11[k].toString(), connectionSpace));
} else if (fieldNames.get(k).toString().equalsIgnoreCase("offering")) {
one.put(
fieldNames.get(k).toString(),
DRH.offeringName(
clientVal, clientData, obdata11[k].toString(), connectionSpace));
} else {
one.put(fieldNames.get(k).toString(), obdata11[k].toString());
}
} else {
one.put(fieldNames.get(k).toString(), "NA");
}
}
Listhb.add(one);
}
setViewList(Listhb);
setTotal((int) Math.ceil((double) getRecords() / (double) getRows()));
}
}
return SUCCESS;
} catch (Exception exp) {
exp.printStackTrace();
return ERROR;
}
} else {
return ERROR;
}
}
@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;
}
@SuppressWarnings("rawtypes")
public String viewAuditReport() {
System.out.println("viewAuditReport");
boolean sessionFlag = ValidateSession.checkSession();
if (sessionFlag) {
try {
masterViewList = new ArrayList<Object>();
List<Object> Listhb = new ArrayList<Object>();
List dataList = null;
StringBuilder query = new StringBuilder();
query.append(
"SELECT far.id,feed.clientId,feed.patientId,feed.clientName,far.feedDataId,action_type,far.comments,action_by FROM feedback_audit_report AS far ");
query.append(" INNER JOIN feedbackdata AS feed ON feed.id=far.feedDataId ");
query.append(" WHERE far.id!=0 ");
if (getFromDate() != null
&& getToDate() != null
&& !getFromDate().equalsIgnoreCase("")
&& !getToDate().equalsIgnoreCase("")) {
String str[] = getFromDate().split("-");
if (str[0] != null && str[0].length() > 3) {
query.append(
" AND far.insert_date BETWEEN '"
+ ((getFromDate()))
+ "' AND '"
+ ((getToDate()))
+ "'");
} else {
query.append(
" AND far.insert_date BETWEEN '"
+ (DateUtil.convertDateToUSFormat(getFromDate()))
+ "' AND '"
+ (DateUtil.convertDateToUSFormat(getToDate()))
+ "'");
}
}
query.append(" ORDER BY far.id DESC ");
System.out.println("query data:::::" + query);
dataList = cbt.executeAllSelectQuery(query.toString(), connectionSpace);
if (dataList != null && dataList.size() > 0) {
for (Iterator iterator = dataList.iterator(); iterator.hasNext(); ) {
Object[] object = (Object[]) iterator.next();
Map<String, Object> one = new HashMap<String, Object>();
one.put("id", (object[0]));
if (object[1] != null) {
one.put("clientId", (object[1]));
}
if (object[2] != null && !object[2].equals("-1")) {
one.put("patientId", (object[2]));
} else {
one.put("patientId", "NA");
}
if (object[3] != null && !object[3].equals("-1")) {
one.put("clientName", (object[3]));
} else {
one.put("clientName", "NA");
}
if (object[4] != null && !object[4].equals("-1")) {
one.put("feedDataId", (object[4]));
} else {
one.put("feedDataId", "NA");
}
if (object[5] != null && !object[5].equals("-1")) {
one.put("action_type", (object[5]));
} else {
one.put("action_type", "NA");
}
if (object[6] != null && !object[6].equals("-1")) {
one.put("comments", (object[6]));
} else {
one.put("comments", "NA");
}
if (object[7] != null && !object[7].equals("-1")) {
one.put("action_by", (object[7]));
} else {
one.put("action_by", "NA");
}
Listhb.add(one);
}
}
setMasterViewList(Listhb);
if (masterViewList != null && masterViewList.size() > 0) {
setRecords(masterViewList.size());
int to = (getRows() * getPage());
@SuppressWarnings("unused")
int from = to - getRows();
if (to > getRecords()) to = getRecords();
setTotal((int) Math.ceil((double) getRecords() / (double) getRows()));
}
return SUCCESS;
} catch (Exception e) {
e.printStackTrace();
return ERROR;
}
} else {
return LOGIN;
}
}