List of usage examples for org.springframework.web.servlet.support RequestContextUtils getLocale
public static Locale getLocale(HttpServletRequest request)
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView saveUser(HttpServletRequest request, HttpServletResponse response) { JSONObject jobj = new JSONObject(); Integer codeid2 = null;//from w ww . j a va2 s . co m KwlReturnObject result = null; String msg = ""; int roleflag = 0; String employeeIdFormat = ""; boolean isStadardEmpFormatWithIdAvilable = false; //Create transaction DefaultTransactionDefinition def = new DefaultTransactionDefinition(); def.setName("JE_Tx"); def.setPropagationBehavior(TransactionDefinition.PROPAGATION_REQUIRED); def.setIsolationLevel(TransactionDefinition.ISOLATION_READ_UNCOMMITTED); TransactionStatus status = txnManager.getTransaction(def); try { HashMap<String, Object> requestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(), filter_values = new ArrayList(); HashMap newhm = new FileUploadHandler().getItems(request); HashMap<String, String> hm = new HashMap<String, String>(); for (Object key : newhm.keySet()) { hm.put(key.toString(), new String(newhm.get(key.toString()).toString().getBytes("iso-8859-1"), "UTF-8")); } String id = (String) hm.get("userid"); //String lastname = (String) hm.get("lastname"); //lastname = new String (lastname.getBytes ("iso-8859-1"), "UTF-8"); if (!StringUtil.isNullOrEmpty((String) hm.get("employeeid"))) { String[] codeid = ((String) hm.get("employeeid")).split("-"); for (int x = 0; x < codeid.length; x++) { if (codeid[x].matches("[0-9]*") == true) { codeid2 = Integer.parseInt(codeid[x]); } else { employeeIdFormat += (codeid[x] + "-"); } } if (employeeIdFormat.length() > 0) { employeeIdFormat = employeeIdFormat.substring(0, employeeIdFormat.length() - 1); } } if (StringUtil.isNullOrEmpty(employeeIdFormat)) employeeIdFormat = null; String companyid = sessionHandlerImplObj.getCompanyid(request); String pwd = null; if (!StringUtil.isNullOrEmpty(id)) { requestParams.clear(); // filter_names.add("employeeid"); // filter_values.add(codeid2); // // filter_names.add("userID"); // filter_values.add(id); // // filter_names.add("company.companyID"); // filter_values.add(companyid); // // requestParams.put("filter_names", filter_names); // requestParams.put("filter_values", filter_values); // // result = hrmsCommonDAOObj.getUsers(requestParams); // if (result.getEntityList().isEmpty()) { requestParams.put("employeeIdFormat", employeeIdFormat); requestParams.put("userID", id); requestParams.put("employeeid", codeid2); requestParams.put("request", request); isStadardEmpFormatWithIdAvilable = isStadardEmpFormatWithIdAvilable(requestParams); String standardEmpId = getStadardEmpFormat(requestParams); if (standardEmpId != null && employeeIdFormat != null && standardEmpId.equals(employeeIdFormat)) { employeeIdFormat = null; } requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("employeeid"); filter_values.add(codeid2); if (employeeIdFormat == null) { filter_names.add("IS employeeIdFormat"); } else { filter_names.add("employeeIdFormat"); filter_values.add(employeeIdFormat); } filter_names.add("!userID"); filter_values.add(id); filter_names.add("user.company.companyID"); filter_values.add(companyid); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUseraccount(requestParams); if (!result.getEntityList().isEmpty() || isStadardEmpFormatWithIdAvilable) { throw new Exception("Employee ID already present."); } // } requestParams.clear(); requestParams.put("id", id); if (((String) hm.get("formname")).equals("user")) { if (!StringUtil.isNullOrEmpty((String) hm.get("templateid"))) { requestParams.put("templateid", (String) hm.get("templateid")); } else { requestParams.put("templateid", " "); } } } else { requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("userLogin.userName"); filter_values.add(hm.get("username")); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUsers(requestParams); if (!result.getEntityList().isEmpty()) { throw new Exception("User name not available."); } requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("employeeid"); filter_values.add(codeid2); filter_names.add("company.companyID"); filter_values.add(companyid); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getUsers(requestParams); if (!result.getEntityList().isEmpty()) { throw new Exception("Employee ID already present."); } requestParams.clear(); requestParams.put("username", hm.get("username")); pwd = AuthHandler.generateNewPassword(); requestParams.put("pwd", AuthHandler.getSHA1(pwd)); requestParams.put("companyid", companyid); } requestParams.put("fname", hm.get("firstname")); requestParams.put("lname", hm.get("lastname")); requestParams.put("emailid", hm.get("emailid")); requestParams.put("address", hm.get("address")); requestParams.put("contactno", hm.get("contactnumber")); requestParams.put("empid", codeid2); requestParams.put("employeeIdFormat", employeeIdFormat); requestParams.put("companyid", companyid); int histsave = 0; String histdept = ""; String histdesig = ""; String histsal = ""; Date saveDate = new Date(); SimpleDateFormat fmt = new SimpleDateFormat("yyyy/MM/dd"); saveDate = new Date(fmt.format(saveDate)); String updatedby = sessionHandlerImplObj.getUserid(request); Useraccount ua = (Useraccount) kwlCommonTablesDAOObj.getObject("com.krawler.common.admin.Useraccount", id); if (!StringUtil.isNullOrEmpty((String) hm.get("roleid")) && !hm.get("roleid").equals(ua.getRole().getID())) { if (ua.getRole().getID().equals("1") && hrmsCommonDAOObj.isCompanySuperAdmin(id, companyid)) {//Can't Edit role for super admin roleflag = 1; } else { String newRoleId = hm.get("roleid").toString(); if (StringUtil.equal(newRoleId, Role.COMPANY_USER)) { // Check whether new Role is Company User/ Company Employee List<Empprofile> childList = organizationChartDAOObj.getChildNode(id); // Check for child list before changing its role to Employee. if (childList.size() > 0) { roleflag = 2; } else { requestParams.put("roleid", newRoleId); } } else { requestParams.put("roleid", newRoleId); } } } if (!StringUtil.isNullOrEmpty((String) hm.get("designationid"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) hm.get("designationid")) != ua.getDesignationid()) { histdesig = (ua.getDesignationid() == null) ? "" : ua.getDesignationid().getId(); histsave = 1; } requestParams.put("designationid", hm.get("designationid")); } if (!StringUtil.isNullOrEmpty((String) hm.get("department"))) { if ((MasterData) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.master.MasterData", (String) hm.get("department")) != ua.getDepartment()) { histdept = (ua.getDepartment() == null) ? "" : ua.getDepartment().getId(); if (histsave == 0) { histdesig = (ua.getDesignationid() == null) ? "" : ua.getDesignationid().getId(); } histsave = 2; } requestParams.put("department", hm.get("department")); } if (!StringUtil.isNullOrEmpty((String) hm.get("salary"))) { String tempsal = "0"; if (((String) hm.get("salary")).length() > 0) { tempsal = hm.get("salary").toString(); } if (!tempsal.equals(ua.getSalary())) { if (ua.getSalary() != null) { histsal = ua.getSalary(); } } requestParams.put("salary", tempsal); } if (!StringUtil.isNullOrEmpty((String) hm.get("accno"))) { if (((String) hm.get("accno")).length() > 0) { requestParams.put("accno", hm.get("accno")); } else { requestParams.put("accno", "0"); } } if (!StringUtil.isNullOrEmpty((String) hm.get("formatid"))) { requestParams.put("formatid", hm.get("formatid")); } String diff = null; if (!StringUtil.isNullOrEmpty((String) hm.get("tzid"))) { KWLTimeZone timeZone = (KWLTimeZone) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.KWLTimeZone", (String) hm.get("tzid")); diff = timeZone.getDifference(); requestParams.put("tzid", hm.get("tzid")); } if (!StringUtil.isNullOrEmpty((String) hm.get("aboutuser"))) { requestParams.put("aboutuser", hm.get("aboutuser")); } String imageName = ""; if (newhm.get("userimage") != null) { imageName = ((FileItem) (newhm.get("userimage"))).getName(); if (!StringUtil.isNullOrEmpty(imageName)) { requestParams.put("userimage", hm.get("userimage")); } } result = hrmsCommonDAOObj.saveUser(requestParams, RequestContextUtils.getLocale(request)); if (!StringUtil.isNullOrEmpty(imageName)) { User user = (User) result.getEntityList().get(0); String fileName = user.getImage().substring(user.getImage().lastIndexOf("/") + 1, user.getImage().length()); new FileUploadHandler().uploadImage((FileItem) (newhm.get("userimage")), fileName, StorageHandler.GetProfileImgStorePath(), 100, 100, false, false); } msg = result.getMsg(); requestParams.clear(); if (histsave == 1) { histdept = ua.getDepartment().getId(); } if (histsave == 1 || histsave == 2) { String latestUpdate = ""; HashMap<String, Object> requestParams2 = new HashMap<String, Object>(); requestParams2.put("id", id); requestParams2.put("cat", Emphistory.Emp_Desg_change); result = hrmsCommonDAOObj.getLastUpdatedHistory(requestParams2); latestUpdate = result.getEntityList().get(0).toString(); if (!latestUpdate.equals("")) { latestUpdate = latestUpdate.replace("-", "/"); requestParams.put("Joindate", fmt.parse(latestUpdate)); } requestParams.put("Department", histdept); requestParams.put("Designation", histdesig); requestParams.put("Userid", id); requestParams.put("Empid", ua.getEmployeeid()); requestParams.put("Updatedon", saveDate); requestParams.put("Updatedby", updatedby); requestParams.put("Category", Emphistory.Emp_Desg_change); result = hrmsCommonDAOObj.addEmphistory(requestParams); } if (!histsal.equals("")) { requestParams.clear(); requestParams.put("Userid", id); requestParams.put("Salary", histsal); requestParams.put("Updatedon", saveDate); requestParams.put("Updatedby", updatedby); requestParams.put("Category", Emphistory.Emp_Salary); result = hrmsCommonDAOObj.addEmphistory(requestParams); } sessionHandlerImplObj.updatePreferences(request, null, (StringUtil.isNullOrEmpty((String) hm.get("formatid")) ? null : (String) hm.get("formatid")), (StringUtil.isNullOrEmpty((String) hm.get("tzid")) ? null : (String) hm.get("tzid")), diff); if (roleflag == 1) { msg = msg + " " + messageSource.getMessage("hrms.common.Rolecannotbechangedforsuperadministrator", null, "Role cannot be changed for Super Administrator.", RequestContextUtils.getLocale(request)); jobj.put("roleflag", roleflag); } if (roleflag == 2) { msg = msg + " <br><br><br>" + messageSource.getMessage( "hrms.common.rolecannotbechangedtocompanyemployee", null, "Note : Role cannot be changed to Company Employee. Please re-assign or remove its child node in Organization Chart before changing its role to Company Employee.", RequestContextUtils.getLocale(request)); jobj.put("roleflag", roleflag); } jobj.put("msg", msg); jobj.put("success", true); txnManager.commit(status); } catch (Exception e) { try { if (e.getMessage().equals("Employee ID already present.")) { jobj.put("msg", e.getMessage()); } } catch (Exception ex) { e.printStackTrace(); } e.printStackTrace(); txnManager.rollback(status); } return new ModelAndView("jsonView", "model", jobj.toString()); }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView getAllUserDetails(HttpServletRequest request, HttpServletResponse response) throws JSONException { JSONObject jobj = new JSONObject(); int count;/*from w w w .ja va 2 s . c om*/ HashMap<String, Object> requestParams = new HashMap<String, Object>(); KwlReturnObject result = null; try { ArrayList params = new ArrayList(); ArrayList filter_names = new ArrayList(); ArrayList order_by = new ArrayList(); ArrayList order_type = new ArrayList(); filter_names.add("ua.user.company.companyID"); filter_names.add("ua.user.deleteflag"); params.add(sessionHandlerImplObj.getCompanyid(request)); params.add(0); // @@ useraccount // if(!StringUtil.isNullOrEmpty(request.getParameter("combo"))){ // // order_by.add("u.firstName"); // order_type.add("asc"); // }else{ // // order_by.add("u.employeeid"); // order_type.add("asc"); // } requestParams.put("filter_names", filter_names); requestParams.put("filter_values", params); requestParams.put("order_by", order_by); requestParams.put("order_type", order_type); requestParams.put("ss", request.getParameter("ss")); requestParams.put("searchcol", new String[] { "u.firstName", "u.lastName" }); // requestParams.put("start", Integer.valueOf(request.getParameter("start"))); // requestParams.put("limit", Integer.valueOf(request.getParameter("limit"))); result = hrmsCommonDAOObj.getEmpprofileuser(requestParams); List list = result.getEntityList(); count = result.getRecordTotalCount(); for (int ctr = 0; ctr < count; ctr++) { Object[] row = (Object[]) list.get(ctr); JSONObject obj = new JSONObject(); Empprofile e = null; Useraccount ua = (Useraccount) row[1]; User u = ua.getUser(); if (row[0] != null) { e = (Empprofile) row[0]; if (!StringUtil.isNullOrEmpty(e.getStatus())) { obj.put("status", e.getStatus()); } else { obj.put("status", "Pending"); } } else { obj.put("status", "Incomplete"); } obj.put("department", (ua.getDepartment() == null ? "" : ua.getDepartment().getId())); obj.put("departmentname", (ua.getDepartment() == null ? "" : ua.getDepartment().getValue())); obj.put("role", (ua.getRole() == null ? "" : ua.getRole().getID())); String name = ""; if (ua.getRole() != null && ua.getRole().getCompany() != null) { name = ua.getRole().getName(); } else { name = messageSource.getMessage("hrms.common.role." + ua.getRole().getID(), null, ua.getRole().getName(), RequestContextUtils.getLocale(request)); } obj.put("rolename", (ua.getRole() == null ? "" : name)); obj.put("userid", u.getUserID()); obj.put("username", u.getUserLogin().getUserName()); obj.put("fname", u.getFirstName()); obj.put("lname", u.getLastName()); obj.put("fullname", u.getFirstName() + " " + (u.getLastName() == null ? "" : u.getLastName())); obj.put("image", u.getImage()); obj.put("emailid", u.getEmailID()); obj.put("lastlogin", (u.getUserLogin().getLastActivityDate() == null ? "" : sessionHandlerImplObj.getDateFormatter(request) .format(u.getUserLogin().getLastActivityDate()))); obj.put("aboutuser", u.getAboutUser()); obj.put("address", u.getAddress()); obj.put("contactno", u.getContactNumber()); obj.put("designation", ua.getDesignationid() == null ? "" : ua.getDesignationid().getValue()); obj.put("designationid", ua.getDesignationid() == null ? "" : ua.getDesignationid().getId()); obj.put("salary", ua.getSalary()); obj.put("accno", ua.getAccno()); obj.put("templateid", ua.getTemplateid() != null ? ua.getTemplateid() : ""); requestParams.clear(); requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request)); requestParams.put("empid", ua.getEmployeeid()); // result = profileHandlerDAOObj.getEmpidFormatEdit(requestParams); obj.put("employeeid", ua.getEmployeeid() == null ? "" : profileHandlerDAOObj.getEmpidFormatEdit(requestParams).getEntityList().get(0)); // List lst1 = HibernateUtil.executeQuery(session, "from Assignmanager where assignemp.userID=? and managerstatus=1", u.getUserID()); // Iterator itr1 = lst1.iterator(); requestParams.clear(); // requestParams.put("userid", u.getUserID()); // requestParams.put("managerstatus", 1); filter_names.clear(); params.clear(); filter_names.add("assignemp.userID"); params.add(u.getUserID()); filter_names.add("managerstatus"); params.add(1); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", params); result = hrmsCommonDAOObj.getAssignmanager(requestParams); List lst1 = result.getEntityList(); for (int cnt = 0; cnt < lst1.size(); cnt++) { Assignmanager asm = (Assignmanager) lst1.get(cnt); if (asm.getAssignman() != null) { obj.append("managerid", asm.getAssignman().getUserID()); obj.append("manager", asm.getAssignman().getFirstName() + " " + asm.getAssignman().getLastName()); } } if (lst1.size() == 0) { obj.put("manager", " "); obj.put("managerid", " "); } jobj.append("data", obj); // jArr.put(obj); // lst1 = HibernateUtil.executeQuery(session, "from Assignreviewer where employee.userID=? and reviewerstatus=1", u.getUserID()); // itr1 = lst1.iterator(); requestParams.clear(); requestParams.put("userid", u.getUserID()); requestParams.put("reviewerstatus", 1); result = hrmsCommonDAOObj.getAssignreviewer(requestParams); lst1 = result.getEntityList(); for (int cnt1 = 0; cnt1 < lst1.size(); cnt1++) { Assignreviewer rev = (Assignreviewer) lst1.get(cnt1); if (rev.getReviewer() != null) { obj.append("reviewerid", rev.getReviewer().getUserID()); obj.append("reviewer", rev.getReviewer().getFirstName() + " " + rev.getReviewer().getLastName()); } } if (lst1.size() == 0) { obj.put("reviewer", " "); obj.put("reviewerid", " "); } jobj.append("data", obj); } jobj.put("count", count); } catch (Exception e) { System.out.print(e); } finally { if (!jobj.has("data")) { jobj.put("count", 0); jobj.put("data", ""); } JSONObject jobj1 = new JSONObject(); jobj1.put("valid", true); jobj1.put("data", jobj); return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.crm.caseModule.crmCaseReportController.java
public JSONObject getescalatedCasesReportJson(List<CrmCase> ll, HttpServletRequest request, boolean export, int totalSize) { JSONArray jarr = new JSONArray(); JSONObject jobjTemp = new JSONObject(); JSONObject commData = new JSONObject(); JSONArray jarrColumns = new JSONArray(); JSONArray jarrRecords = new JSONArray(); JSONObject jMeta = new JSONObject(); try {//from ww w . j a v a2s. c om String companyid = sessionHandlerImpl.getCompanyid(request); String qucikSerachFields = request.getParameter("quickSearchFields"); for (CrmCase obj : ll) { JSONObject tmpObj = new JSONObject(); tmpObj.put("casename", obj.getCasename()); tmpObj.put("subject", obj.getSubject()); tmpObj.put("createdon", obj.getCreatedOn() == null ? "" : obj.getCreatedOn()); tmpObj.put("createdo", obj.getCreatedOn() == null ? "" : obj.getCreatedOn()); tmpObj.put("casestatus", (obj.getCrmCombodataByCasestatusid() != null ? obj.getCrmCombodataByCasestatusid().getValue() : "")); tmpObj.put("accountname", (obj.getCrmAccount() != null ? obj.getCrmAccount().getAccountname() : "")); tmpObj.put("caseowner", obj.getUsersByUserid().getFirstName() + " " + obj.getUsersByUserid().getLastName()); tmpObj.put("priority", (obj.getCrmCombodataByCasepriorityid() != null ? obj.getCrmCombodataByCasepriorityid().getValue() : "")); tmpObj.put("accountname", (obj.getCrmAccount() != null ? obj.getCrmAccount().getAccountname() : "")); tmpObj.put("contactname", (obj.getCrmContact() != null ? (StringUtil.checkForNull(obj.getCrmContact().getFirstname()) + " " + StringUtil.checkForNull(obj.getCrmContact().getLastname())).trim() : "")); tmpObj.put("description", obj.getDescription()); tmpObj.put("type", (obj.getCrmCombodataByCasetypeid() != null ? obj.getCrmCombodataByCasetypeid().getValue() : "")); jarr.put(tmpObj); } commData.put("coldata", jarr); if (export) { List<DefaultHeader> ll1 = crmManagerCommon.getHeaderName(crmCommonDAOObj, "Case"); for (DefaultHeader obj : ll1) { String newHeader = crmManagerCommon.getNewColumnHeader(crmCommonDAOObj, obj.getDefaultHeader(), "Case", companyid); if (StringUtil.equal(Header.CASESTATUSHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.report.casereport.casestatus", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.report.casereport.casestatus", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "casestatus"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASEDESCRIPTIONHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "description"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASESUBJECTHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); String Hdr = StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.subject", null, RequestContextUtils.getLocale(request)) : newHeader; if (StringUtil.equal(Header.CASESUBJECTHEADER, qucikSerachFields)) { jobjTemp.put("qucikSearchText", Hdr); } jobjTemp.put("header", Hdr); jobjTemp.put("tip", Hdr); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "subject"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASECONTACTHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.contactname", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.contactname", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "contactname"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASEPRIORITYHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.priority", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.priority", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "priority"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASETYPEHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.report.casereport.casetype", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.report.casereport.casetype", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "type"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASEACCOUNTHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.accountname", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.accountname", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "accountname"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASECREATIONDATEHEADER, obj.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.createdon", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? messageSource.getMessage("crm.case.defaultheader.createdon", null, RequestContextUtils.getLocale(request)) : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("title", "createdo"); jobjTemp.put("dataIndex", "createdo"); jobjTemp.put("align", "center"); jobjTemp.put("xtype", "datefield"); jobjTemp.put("editor", "new Wtf.form.DateField({format:WtfGlobal.getOnlyDateFormat()})"); jobjTemp.put("renderer", "WtfGlobal.onlyDateRendererTZ"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } } jobjTemp = new JSONObject(); jobjTemp.put("name", "type"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "description"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "contactname"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "subject"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "casestatus"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "accountname"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "caseowner"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "createdo"); jobjTemp.put("dateFormat", "time"); jobjTemp.put("type", "date"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "priority"); jarrRecords.put(jobjTemp); commData.put("columns", jarrColumns); jMeta.put("totalProperty", "totalCount"); jMeta.put("root", "coldata"); jMeta.put("fields", jarrRecords); jMeta.put("id", "asd"); commData.put("metaData", jMeta); } commData.put("success", true); commData.put("totalCount", totalSize); } catch (Exception e) { LOGGER.warn(e.getMessage(), e); } return commData; }
From source file:com.krawler.spring.crm.dashboard.CrmDashboardController.java
private String getReportWidgetLinks(HttpServletRequest request) throws ServiceException { String jdata = ""; try {/*from w w w.jav a 2 s . co m*/ ArrayList li = new ArrayList(); crmdashboardHandler.getLeadsReportsLink(sessionHandlerImpl.getPerms(request, "Lead Report"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getAccountReportsLink(sessionHandlerImpl.getPerms(request, "AccountReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getContactReportsLink(sessionHandlerImpl.getPerms(request, "ContactReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getOpportunityReportsLink(sessionHandlerImpl.getPerms(request, "OpportunityReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getActivityReportsLink(sessionHandlerImpl.getPerms(request, "ActivityReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getCaseReportsLink(sessionHandlerImpl.getPerms(request, "CaseReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getProductReportsLink(sessionHandlerImpl.getPerms(request, "ProductReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getOpportunityProductReportsLink(request, li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getSalesReportsLink(sessionHandlerImpl.getPerms(request, "SalesReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getCampaignReportsLink(sessionHandlerImpl.getPerms(request, "CampaignReport"), li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getTargetReportsLink(request, li, RequestContextUtils.getLocale(request)); crmdashboardHandler.getGoalReportsLink(request, li, RequestContextUtils.getLocale(request)); li = getBubbleSortList(li); int start = Integer.parseInt(request.getParameter("start")); int limit = Integer.parseInt(request.getParameter("limit")); String limitReport = request.getParameter("limitReport"); if (!StringUtil.isNullOrEmpty(limitReport)) { limit = Integer.parseInt(limitReport); } limit = (start + limit) > li.size() ? li.size() : (start + limit); List currli = (List) li.subList(start, limit); Iterator it = currli.iterator(); ArrayList newArr = new ArrayList(); while (it.hasNext()) { newArr.add(it.next()); } JSONObject jobj = new JSONObject("{\"count\":" + li.size() + ",\"data\":" + newArr.toString() + "}"); jdata = jobj.toString(); } catch (JSONException ex) { logger.warn(ex.getMessage(), ex); throw ServiceException.FAILURE(ex.getMessage(), ex); } catch (Exception ex) { logger.warn(ex.getMessage(), ex); throw ServiceException.FAILURE(ex.getMessage(), ex); } return jdata; }
From source file:com.krawler.spring.crm.emailMarketing.crmEmailMarketingController.java
public ModelAndView targetListForImport(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); JSONArray jarr = new JSONArray(); JSONObject jobjTemp = new JSONObject(); JSONArray jarrColumns = new JSONArray(); JSONArray jarrRecords = new JSONArray(); JSONObject jMeta = new JSONObject(); try {/* w w w . jav a 2 s .c o m*/ HashMap<String, Object> requestParams = new HashMap<String, Object>(); HashMap<String, Object> innerrequestParams = new HashMap<String, Object>(); String companyid = sessionHandlerImpl.getCompanyid(request); ArrayList filter_names = new ArrayList(); ArrayList filter_params = new ArrayList(); filter_names.add("deleted"); filter_params.add(0); filter_names.add("creator.company.companyID"); filter_params.add(companyid); filter_names.add("saveflag"); filter_params.add(1); filter_names.add("!id"); filter_params.add(request.getParameter("tlid")); if (request.getParameter("ss") != null && !StringUtil.isNullOrEmpty(request.getParameter("ss"))) { requestParams.put("ss", request.getParameter("ss")); } requestParams.put("start", StringUtil.checkForNull(request.getParameter("start"))); requestParams.put("limit", StringUtil.checkForNull(request.getParameter("limit"))); requestParams.put("filter_names", filter_names); requestParams.put("filter_params", filter_params); KwlReturnObject kmsg = crmEmailMarketingDAOObj.getTargetList(requestParams); Iterator ite = kmsg.getEntityList().iterator(); while (ite.hasNext()) { TargetList obj = (TargetList) ite.next(); JSONObject jtemp = new JSONObject(); jtemp.put("relatedid", obj.getId()); jtemp.put("name", obj.getName()); jtemp.put("targetlistDescription", obj.getDescription()); innerrequestParams.clear(); innerrequestParams.put("listID", obj.getId()); filter_names.clear(); filter_params.clear(); filter_names.add("targetlisttargets.targetlistid.id"); filter_params.add(obj.getId()); innerrequestParams.put("filter_names", filter_names); innerrequestParams.put("filter_params", filter_params); innerrequestParams.put("companyid", companyid); KwlReturnObject innerkmsg = crmEmailMarketingDAOObj.getTargetListTargets(innerrequestParams); jtemp.put("targetscount", innerkmsg.getRecordTotalCount()); jarr.put(jtemp); } jobjTemp = new JSONObject(); jobjTemp.put("header", mSource.getMessage("crm.targetlists.targetlistname", null, RequestContextUtils.getLocale(request)));//"Target List Name"); jobjTemp.put("tip", mSource.getMessage("crm.targetlists.targetlistname", null, RequestContextUtils.getLocale(request)));//"Target List Name"); jobjTemp.put("pdfwidth", 60); jobjTemp.put("dataIndex", "name"); jarrColumns.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("header", mSource.getMessage("crm.targetlists.targetlistname", null, RequestContextUtils.getLocale(request)));//"No of Targets"); jobjTemp.put("tip", mSource.getMessage("crm.targetlists.targetlistname", null, RequestContextUtils.getLocale(request)));//"No of Targets"); jobjTemp.put("pdfwidth", 60); jobjTemp.put("dataIndex", "targetscount"); jarrColumns.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("header", mSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)));//"Description"); jobjTemp.put("tip", mSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)));//"Description"); jobjTemp.put("pdfwidth", 60); jobjTemp.put("dataIndex", "targetlistDescription"); jarrColumns.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "targetscount"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "name"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "emailid"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "relatedto"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "company"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "targetlistDescription"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "relatedid"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "fname"); jarrRecords.put(jobjTemp); jobj.put("columns", jarrColumns); jMeta.put("totalProperty", "totalCount"); jMeta.put("root", "data"); jMeta.put("fields", jarrRecords); jobj.put("metaData", jMeta); jobj.put("totalCount", kmsg.getRecordTotalCount()); jobj.put("data", jarr); } catch (ServiceException e) { logger.warn(e.getMessage(), e); } catch (Exception e) { logger.warn(e.getMessage(), e); } return new ModelAndView("jsonView", "model", jobj.toString()); }
From source file:com.krawler.spring.crm.dashboard.CrmDashboardController.java
private String getCustomReportWidgetLinks(HttpServletRequest request, List ll) throws ServiceException { String jdata = ""; try {//from w ww .ja v a 2 s .co m List li = crmdashboardHandler.getCustomReportLinks(request, ll, RequestContextUtils.getLocale(request)); // li = getBubbleSortList(li); int start = Integer.parseInt(request.getParameter("start")); int limit = Integer.parseInt(request.getParameter("limit")); String limitReport = request.getParameter("limitReport"); if (!StringUtil.isNullOrEmpty(limitReport)) { limit = Integer.parseInt(limitReport); } limit = (start + limit) > li.size() ? li.size() : (start + limit); List currli = (List) li.subList(start, limit); Iterator it = currli.iterator(); JSONArray newArr = new JSONArray(); while (it.hasNext()) { newArr.put(new JSONObject(it.next().toString())); } JSONObject jobj = new JSONObject(); jobj.put("count", li.size()); jobj.put("data", newArr); jdata = jobj.toString(); } catch (JSONException ex) { logger.warn(ex.getMessage(), ex); throw ServiceException.FAILURE(ex.getMessage(), ex); } catch (Exception ex) { logger.warn(ex.getMessage(), ex); throw ServiceException.FAILURE(ex.getMessage(), ex); } return jdata; }
From source file:com.krawler.spring.hrms.rec.job.hrmsRecJobController.java
public ModelAndView jobsearch(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject result = null;//from ww w .j a v a 2 s .c o m JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); String jobtype = "Internal"; int count = 0; String status = ""; String userid = request.getParameter("userid"); String ss = request.getParameter("ss"); int start = 0; int limit = 15; HashMap<String, Object> requestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(), filter_values = new ArrayList(); if (request.getParameter("start") != null) { start = Integer.parseInt(request.getParameter("start")); limit = Integer.parseInt(request.getParameter("limit")); } try { List lst = null; if (StringUtil.isNullOrEmpty(request.getParameter("position"))) { filter_names.add("!jobtype"); filter_names.add("company.companyID"); filter_names.add("delflag"); filter_names.add("<=startdate"); filter_names.add(">=enddate"); filter_values.add(jobtype); filter_values.add(sessionHandlerImplObj.getCompanyid(request)); filter_values.add(0); filter_values.add(new Date()); filter_values.add(new Date()); } else { filter_names.add("position.id"); filter_names.add("!jobtype"); filter_names.add("company.companyID"); filter_names.add("delflag"); filter_names.add("<=startdate"); filter_names.add(">=enddate"); filter_values.add(request.getParameter("position")); filter_values.add(jobtype); filter_values.add(sessionHandlerImplObj.getCompanyid(request)); filter_values.add(0); filter_values.add(new Date()); filter_values.add(new Date()); } requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); requestParams.put("searchcol", new String[] { "jobid" }); requestParams.put("ss", ss); requestParams.put("allflag", false); requestParams.put("start", start); requestParams.put("limit", limit); result = hrmsRecJobDAOObj.getPositionmain(requestParams); lst = result.getEntityList(); count = result.getRecordTotalCount(); for (int ctr = 0; ctr < count; ctr++) { Positionmain extmt = (Positionmain) lst.get(ctr); JSONObject tmpObj = new JSONObject(); tmpObj.put("jid", extmt.getPositionid()); // status = getappPositionstatus(userid,extmt.getPositionid(), session, request); filter_names.clear(); filter_values.clear(); filter_names.add("configjobapplicant.id"); filter_names.add("position.positionid"); filter_names.add("delflag"); filter_values.add(userid); filter_values.add(extmt.getPositionid()); filter_values.add(0); requestParams.clear(); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsRecJobDAOObj.getPositionstatus(requestParams); Allapplications app = null; if (StringUtil.checkResultobjList(result)) { app = (Allapplications) result.getEntityList().get(0); status = app.getStatus(); } else { status = "none"; } if (status.equalsIgnoreCase("none")) { tmpObj.put("status", 0); tmpObj.put("selectionstatus", messageSource.getMessage("hrms.recruitment.not.applied", null, RequestContextUtils.getLocale(request))); } else { tmpObj.put("status", 1); tmpObj.put("applicationid", app.getId()); tmpObj.put("selectionstatus", status); } tmpObj.put("jobname", extmt.getPosition().getValue()); tmpObj.put("jobpositionid", extmt.getJobid()); tmpObj.put("jdescription", extmt.getDetails()); requestParams.clear(); requestParams.put("request", request); DateFormat df = kwlCommonTablesDAOObj.getUserDateFormatter( sessionHandlerImplObj.getDateFormatID(request), sessionHandlerImplObj.getUserTimeFormat(request), sessionHandlerImplObj.getTimeZoneDifference(request)); tmpObj.put("jstartdate", df.format(extmt.getStartdate())); tmpObj.put("jenddate", df.format(extmt.getEnddate())); tmpObj.put("jdepartment", extmt.getDepartmentid().getValue()); tmpObj.put("posmasterid", extmt.getPosition().getId()); jobj.append("data", tmpObj); } if (jobj.isNull("data")) { jobj.put("data", new com.krawler.utils.json.JSONArray()); } jobj.put("count", count); jobj1.put("data", jobj.toString()); jobj1.put("valid", true); } catch (Exception e) { } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView getEmpHistory(HttpServletRequest request, HttpServletResponse response) { JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); int count = 0; List list = null;/*w ww.j av a2 s . co m*/ Iterator itr; KwlReturnObject result; try { String userid = request.getParameter("userid"); String cmpid = sessionHandlerImplObj.getCompanyid(request); HashMap<String, Object> requestParams = new HashMap<String, Object>(); requestParams.put("filter_names", Arrays.asList("userid.userID", "userid.company.companyID")); requestParams.put("filter_values", Arrays.asList(userid, cmpid)); requestParams.put("allflag", false); StringUtil.checkpaging(requestParams, request); result = hrmsCommonDAOObj.getEmpHistory(requestParams); count = result.getRecordTotalCount(); list = result.getEntityList(); itr = list.iterator(); JSONArray jArr = new JSONArray(); while (itr.hasNext()) { JSONObject obj = new JSONObject(); Emphistory ehst = (Emphistory) itr.next(); obj.put("designation", (ehst.getDesignation() != null ? ehst.getDesignation().getValue() : "")); obj.put("department", (ehst.getDepartment() != null ? ehst.getDepartment().getValue() : "")); obj.put("startdate", ehst.getJoindate() != null ? sessionHandlerImplObj.getDateFormatter(request).format(ehst.getJoindate()) : ""); obj.put("enddate", ehst.getUpdatedon() != null ? sessionHandlerImplObj.getDateFormatter(request).format(ehst.getUpdatedon()) : ""); obj.put("salary", ehst.getSalary() != null ? ehst.getSalary() : ""); obj.put("category", ehst.getCategory().equals("1") ? messageSource.getMessage("hrms.common.designation", null, "Designation", RequestContextUtils.getLocale(request)) : messageSource.getMessage("hrms.common.Salary", null, "Salary", RequestContextUtils.getLocale(request))); obj.put("hid", ehst.getHid()); jArr.put(obj); } requestParams.clear(); requestParams.put("filter_names", Arrays.asList("userID.userID")); requestParams.put("filter_values", Arrays.asList(userid)); requestParams.put("allflag", false); StringUtil.checkpaging(requestParams, request); result = hrmsCommonDAOObj.getPayHistory(requestParams); count += result.getRecordTotalCount(); list = result.getEntityList(); itr = list.iterator(); while (itr.hasNext()) { JSONObject jobjtemp = new JSONObject(); Payhistory group = (Payhistory) itr.next(); jobjtemp.put("designation", group.getDesign()); jobjtemp.put("department", group.getDepartment()); jobjtemp.put("salary", group.getNet()); jobjtemp.put("startdate", sessionHandlerImplObj.getDateFormatter(request).format(group.getCreatedon())); jobjtemp.put("enddate", sessionHandlerImplObj.getDateFormatter(request).format(group.getCreatedfor())); jobjtemp.put("category", messageSource.getMessage("hrms.Featurelist.payroll", null, "Payroll", RequestContextUtils.getLocale(request))); jobjtemp.put("hid", group.getHistoryid()); jArr.put(jobjtemp); } jobj.put("count", count); jobj.put("data", jArr); jobj1.put("data", jobj); jobj1.put("valid", true); } catch (Exception e) { e.printStackTrace(); } return new ModelAndView(successView, "model", jobj1.toString()); }
From source file:com.krawler.spring.crm.caseModule.crmCaseReportController.java
public JSONObject getaccountsWithCaseReportJson(List<CrmCase> ll, HttpServletRequest request, boolean export, int totalSize) { JSONArray jarr = new JSONArray(); JSONObject jobjTemp = new JSONObject(); JSONObject commData = new JSONObject(); JSONArray jarrColumns = new JSONArray(); JSONArray jarrRecords = new JSONArray(); JSONObject jMeta = new JSONObject(); try {/*from ww w. j a va2s . c om*/ String companyid = sessionHandlerImpl.getCompanyid(request); String qucikSerachFields = request.getParameter("quickSearchFields"); for (CrmCase obj : ll) { JSONObject tmpObj = new JSONObject(); tmpObj.put("casename", obj.getCasename()); tmpObj.put("subject", obj.getSubject()); tmpObj.put("createdon", obj.getCreatedOn() == null ? "" : obj.getCreatedOn()); tmpObj.put("createdo", obj.getCreatedOn() == null ? "" : obj.getCreatedOn()); tmpObj.put("casestatus", (obj.getCrmCombodataByCasestatusid() != null ? obj.getCrmCombodataByCasestatusid().getValue() : "")); tmpObj.put("accountname", (obj.getCrmAccount() != null ? obj.getCrmAccount().getAccountname() : "")); tmpObj.put("type", (obj.getCrmCombodataByCasetypeid() != null ? obj.getCrmCombodataByCasetypeid().getValue() : "")); tmpObj.put("priority", (obj.getCrmCombodataByCasepriorityid() != null ? obj.getCrmCombodataByCasepriorityid().getValue() : "")); tmpObj.put("description", obj.getDescription()); jarr.put(tmpObj); } commData.put("coldata", jarr); if (export) { String newHeader = crmManagerCommon.getNewColumnHeader(crmCommonDAOObj, Header.ACCOUNTNAMEHEADER, "Account", companyid); jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader) ? "Account Name" : newHeader); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader) ? "Account Name" : newHeader); jobjTemp.put("pdfwidth", 60); jobjTemp.put("dataIndex", "accountname"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); List<DefaultHeader> ll2 = crmManagerCommon.getHeaderName(crmCommonDAOObj, "Case"); for (DefaultHeader obj1 : ll2) { String newHeader2 = crmManagerCommon.getNewColumnHeader(crmCommonDAOObj, obj1.getDefaultHeader(), "Case", companyid); if (StringUtil.equal(Header.CASESUBJECTHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); String Hdr = StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casesubject", null, RequestContextUtils.getLocale(request)) : newHeader2; if (StringUtil.equal(Header.CASESUBJECTHEADER, qucikSerachFields)) { jobjTemp.put("qucikSearchText", Hdr); } jobjTemp.put("header", Hdr); jobjTemp.put("tip", Hdr); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "subject"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASEPRIORITYHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casepriority", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casepriority", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "priority"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASETYPEHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casetype", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casetype", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "type"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASESTATUSHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casestatus", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.report.casereport.casestatus", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "combo"); jobjTemp.put("dataIndex", "casestatus"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASEDESCRIPTIONHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.case.defaultheader.desc", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("pdfwidth", 60); jobjTemp.put("xtype", "textfield"); jobjTemp.put("dataIndex", "description"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } else if (StringUtil.equal(Header.CASECREATIONDATEHEADER, obj1.getDefaultHeader())) { jobjTemp = new JSONObject(); jobjTemp.put("header", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.case.defaultheader.createdon", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("tip", StringUtil.isNullOrEmpty(newHeader2) ? messageSource.getMessage("crm.case.defaultheader.createdon", null, RequestContextUtils.getLocale(request)) : newHeader2); jobjTemp.put("title", "createdo"); jobjTemp.put("pdfwidth", 60); jobjTemp.put("align", "center"); jobjTemp.put("dataIndex", "createdo"); jobjTemp.put("xtype", "datefield"); jobjTemp.put("editor", "new Wtf.form.DateField({format:WtfGlobal.getOnlyDateFormat()})"); jobjTemp.put("renderer", "WtfGlobal.onlyDateRendererTZ"); StringUtil.escapeJSONObject(jobjTemp, "header", "tip"); jarrColumns.put(jobjTemp); } } jobjTemp = new JSONObject(); jobjTemp.put("name", "subject"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "casestatus"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "accountname"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "caseowner"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "createdo"); jobjTemp.put("dateFormat", "time"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "priority"); jarrRecords.put(jobjTemp); commData.put("columns", jarrColumns); jobjTemp = new JSONObject(); jobjTemp.put("name", "type"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "description"); jarrRecords.put(jobjTemp); jobjTemp = new JSONObject(); jobjTemp.put("name", "createdo"); jobjTemp.put("dateFormat", "time"); jobjTemp.put("type", "date"); jarrRecords.put(jobjTemp); jMeta.put("totalProperty", "totalCount"); jMeta.put("root", "coldata"); jMeta.put("fields", jarrRecords); jMeta.put("id", "asd"); commData.put("metaData", jMeta); } commData.put("success", true); commData.put("totalCount", totalSize); } catch (Exception e) { LOGGER.warn(e.getMessage(), e); } return commData; }
From source file:com.krawler.spring.hrms.common.hrmsCommonController.java
public ModelAndView exportUserInfo(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject kmsg = null;/* ww w .jav a2s .c om*/ JSONObject jobj = new JSONObject(); JSONArray jarr = new JSONArray(); JSONObject countobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); try { String Searchjson = request.getParameter("searchJson"); String appendCase = "and"; String companyid = sessionHandlerImplObj.getCompanyid(request); String lid = StringUtil.checkForNull(request.getParameter("lid")); HashMap<String, Object> requestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList( Arrays.asList("ua.user.company.companyID", "ua.user.deleteflag")); ArrayList filter_values = new ArrayList(Arrays.asList(companyid, 0)); requestParams.put("ss", StringUtil.checkForNull(request.getParameter("ss"))); requestParams.put("allflag", true); requestParams.put("searchcol", new String[] { "u.firstName", "u.lastName", "ua.department.value", "ua.designationid.value", "ua.role.name", "u.emailID" }); if (request.getParameter("combo") != null) { requestParams.put("combo", request.getParameter("combo")); } else { requestParams.put("combo", ""); } StringUtil.checkpaging(requestParams, request); SimpleDateFormat df = new SimpleDateFormat("yyyy/MM/dd"); if (!StringUtil.isNullOrEmpty(request.getParameter("stdate"))) { filter_names.add(">=emp.joindate"); filter_values.add(new Date(df.format(new Date(request.getParameter("stdate"))))); filter_names.add("<=emp.joindate"); filter_values.add(new Date(df.format(new Date(request.getParameter("enddate"))))); } if (!StringUtil.isNullOrEmpty(Searchjson)) { getMyAdvanceSearchparams(Searchjson, filter_names); insertParamAdvanceSearchString(filter_values, Searchjson); } requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); kmsg = hrmsCommonDAOObj.getUserDetailsHrms(requestParams); List lst = kmsg.getEntityList(); jarr = kwlCommonTablesDAOObj.getDetailsJson(lst, 0, "com.krawler.common.admin.User"); int count = 0; for (int ctr = 0; ctr < jarr.length(); ctr++) { jobj = jarr.getJSONObject(ctr); Object[] row = (Object[]) lst.get(ctr); User u = (User) jobj.get("instance"); Useraccount ua = (Useraccount) kwlCommonTablesDAOObj .getObject("com.krawler.common.admin.Useraccount", row[0].toString()); if (row[1] != null) { Empprofile e = (Empprofile) kwlCommonTablesDAOObj.getObject("com.krawler.hrms.ess.Empprofile", row[1].toString()); if (!StringUtil.isNullOrEmpty(e.getStatus())) { jobj.put("status", messageSource.getMessage("hrms.administration." + e.getStatus(), null, e.getStatus(), RequestContextUtils.getLocale(request))); } else { jobj.put("status", messageSource.getMessage("hrms.administration.Pending", null, "Pending", RequestContextUtils.getLocale(request))); } jobj.put("dob", e.getDoB() == null ? "" : e.getDoB()); jobj.put("gender", e.getGender() == null ? "" : e.getGender()); jobj.put("bloodgrp", e.getBloodgrp() == null ? "" : e.getBloodgrp()); jobj.put("fathername", e.getFathername() == null ? "" : e.getFathername()); jobj.put("mothername", e.getMothername() == null ? "" : e.getMothername()); jobj.put("passportno", e.getPassportno() == null ? "" : e.getPassportno()); jobj.put("joindate", e.getJoindate() == null ? "" : e.getJoindate()); jobj.put("confirmdate", e.getConfirmdate() == null ? "" : e.getConfirmdate()); jobj.put("middlename", e.getMiddlename() == null ? "" : e.getMiddlename()); jobj.put("keyskills", e.getKeyskills() == null ? "" : e.getKeyskills()); jobj.put("wkstarttime", e.getWkstarttime() == null ? "" : e.getWkstarttime()); jobj.put("wkendtime", e.getWkendtime() == null ? "" : e.getWkendtime()); jobj.put("weekoff", e.getWeekoff() == null ? "" : e.getWeekoff()); jobj.put("pannumber", e.getPanno() == null ? "" : e.getPanno()); jobj.put("updatedon", e.getUpdated_on() == null ? "" : e.getUpdated_on()); } else { jobj.put("status", messageSource.getMessage("hrms.recruitment.InComplete", null, "Incomplete", RequestContextUtils.getLocale(request))); jobj.put("dob", ""); jobj.put("gender", ""); jobj.put("bloodgrp", ""); jobj.put("fathername", ""); jobj.put("mothername", ""); jobj.put("passportno", ""); jobj.put("joindate", ""); jobj.put("confirmdate", ""); jobj.put("middlename", ""); jobj.put("keyskills", ""); jobj.put("wkstarttime", ""); jobj.put("wkendtime", ""); jobj.put("weekoff", ""); } jobj.put("department", (ua.getDepartment() == null ? "" : ua.getDepartment().getId())); jobj.put("departmentname", (ua.getDepartment() == null ? "" : ua.getDepartment().getValue())); jobj.put("role", (ua.getRole() == null ? "" : ua.getRole().getID())); String name = ""; if (ua.getRole() != null && ua.getRole().getCompany() != null) { name = ua.getRole().getName(); } else { name = messageSource.getMessage("hrms.common.role." + ua.getRole().getID(), null, ua.getRole().getName(), RequestContextUtils.getLocale(request)); } jobj.put("rolename", (ua.getRole() == null ? "" : name)); jobj.put("username", u.getUserLogin().getUserName()); jobj.put("fullname", u.getFirstName() + " " + (u.getLastName() == null ? "" : u.getLastName())); jobj.put("lastlogin", (u.getUserLogin().getLastActivityDate() == null ? "" : sessionHandlerImplObj.getDateFormatter(request) .format(u.getUserLogin().getLastActivityDate()))); jobj.put("designation", ua.getDesignationid() == null ? "" : ua.getDesignationid().getValue()); jobj.put("designationid", ua.getDesignationid() == null ? "" : ua.getDesignationid().getId()); jobj.put("templateid", ua.getTemplateid() != null ? ua.getTemplateid() : ""); jobj.put("salary", ua.getSalary() != null ? ua.getSalary() : ""); jobj.put("accno", ua.getAccno() != null ? ua.getAccno() : ""); jobj.put("createdon", ua.getUser().getCreatedon() != null ? ua.getUser().getCreatedon() : ""); requestParams.clear(); requestParams.put("companyid", sessionHandlerImplObj.getCompanyid(request)); requestParams.put("empid", ua.getEmployeeid()); KwlReturnObject result; // KwlReturnObject result = profileHandlerDAOObj.getEmpidFormatEdit(requestParams); if (ua.getEmployeeIdFormat() == null) { jobj.put("employeeid", ua.getEmployeeid() == null ? "" : profileHandlerDAOObj.getEmpidFormatEdit(requestParams).getEntityList().get(0)); } else { requestParams.put("standardEmpId", profileHandlerDAOObj.getEmpidFormatEdit(requestParams) .getEntityList().get(0).toString()); requestParams.put("employeeIdFormat", ua.getEmployeeIdFormat()); jobj.put("employeeid", profileHandlerDAOObj.getNewEmployeeIdFormat(requestParams)); } requestParams.clear(); filter_names.add("assignemp.userID"); filter_values.add(u.getUserID()); filter_names.add("managerstatus"); filter_values.add(1); requestParams.put("filter_names", Arrays.asList("assignemp.userID", "managerstatus", "assignman.deleteflag")); requestParams.put("filter_values", Arrays.asList(u.getUserID(), 1, 0)); result = hrmsCommonDAOObj.getAssignmanager(requestParams); List lst1 = result.getEntityList(); Iterator itr1 = lst1.iterator(); if (itr1.hasNext()) { String manager = ""; while (itr1.hasNext()) { Assignmanager asm = (Assignmanager) itr1.next(); if (asm.getAssignman() != null) { jobj.append("managerid", asm.getAssignman().getUserID()); manager += asm.getAssignman().getFirstName() + " " + asm.getAssignman().getLastName() + ","; } } jobj.put("manager", manager.substring(0, manager.length() - 1)); } else { jobj.put("manager", " "); jobj.put("managerid", " "); } requestParams.clear(); filter_names.clear(); filter_values.clear(); filter_names.add("employee.userID"); filter_values.add(u.getUserID()); filter_names.add("reviewer.deleteflag"); filter_values.add(0); filter_names.add("reviewerstatus"); filter_values.add(1); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); result = hrmsCommonDAOObj.getAssignreviewer(requestParams); lst1 = result.getEntityList(); itr1 = lst1.iterator(); if (itr1.hasNext()) { String reviewer = ""; while (itr1.hasNext()) { Assignreviewer rev = (Assignreviewer) itr1.next(); if (rev.getReviewer() != null) { jobj.append("reviewerid", rev.getReviewer().getUserID()); reviewer += rev.getReviewer().getFirstName() + " " + rev.getReviewer().getLastName() + ","; } } jobj.put("reviewer", reviewer.substring(0, reviewer.length() - 1)); } else { jobj.put("reviewer", " "); jobj.put("reviewerid", " "); } jarr.put(ctr, jobj); count++; } countobj.put("data", jarr); countobj.put("count", kmsg.getRecordTotalCount()); exportDAOImplObj.processRequest(request, response, countobj); } catch (Exception e) { e.printStackTrace(); } return new ModelAndView("jsonView", "model", jobj.toString()); }