public static String getAllLog( Connection conn, HttpServletRequest request, String companyid, String limit, String offset, String searchString, String dateString) throws ServiceException { ResultSet rs1 = null; String returnStr = ""; String[] searchStrObj = new String[] {"params", "actiontext"}; String myLikeString = StringUtil.getMySearchString(searchString, "and", searchStrObj); PreparedStatement pstmt = null; JSONObject resobj = new JSONObject(); JSONObject tempobj = new JSONObject(); JSONArray jarr = new JSONArray(); try { int count1 = 0; pstmt = conn.prepareStatement( "select count(*) AS count from actionlog al inner join actions a on al.actionid = a.actionid where companyid = ?" + myLikeString + dateString); pstmt.setString(1, companyid); StringUtil.insertParamSearchString(2, pstmt, searchString, searchStrObj.length); rs1 = pstmt.executeQuery(); if (rs1.next()) { count1 = rs1.getInt("count"); } String query1 = "select logid, al.actionid, actionby, projectid, params, timestamp from actionlog al inner join actions a on al.actionid = a.actionid where companyid = ?" + myLikeString + dateString + " order by timestamp DESC limit ? offset ?"; pstmt = conn.prepareStatement(query1); pstmt.setString(1, companyid); int cnt = StringUtil.insertParamSearchString(2, pstmt, searchString, searchStrObj.length); pstmt.setInt(cnt++, Integer.parseInt(limit)); pstmt.setInt(cnt++, Integer.parseInt(offset)); rs1 = pstmt.executeQuery(); while (rs1.next()) { tempobj = getJsonForAction(conn, pstmt, rs1, request, "all"); jarr.put(tempobj); } resobj.put("data", jarr); resobj.put("count", count1); returnStr = resobj.toString(); } catch (ServiceException ex) { throw ServiceException.FAILURE("AuditTrail.getAllLog", ex); } catch (SQLException ex) { throw ServiceException.FAILURE("AuditTrail.getAllLog", ex); } finally { return returnStr; } }
public ModelAndView downloadDocuments(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); JSONObject myjobj = new JSONObject(); KwlReturnObject kmsg = null; String details = ""; String auditAction = ""; try { String url = request.getParameter("url"); url = StringUtil.checkForNull(url); String applicant = request.getParameter("applicant"); applicant = StringUtil.checkForNull(applicant); Hashtable ht; if (applicant.equalsIgnoreCase("applicant")) { kmsg = hrmsExtApplDocsDAOObj.downloadDocument(url); ht = getExtDocumentDownloadHash(kmsg.getEntityList()); } else { kmsg = documentDAOObj.downloadDocument(url); ht = getDocumentDownloadHash(kmsg.getEntityList()); } String src = storageHandlerImplObj.GetDocStorePath(); // String src = "/home/trainee/"; if (request.getParameter("mailattch") != null) { src = src + ht.get("svnname"); } else { src = src + ht.get("userid").toString() + "/" + ht.get("svnname"); } File fp = new File(src); byte[] buff = new byte[(int) fp.length()]; FileInputStream fis = new FileInputStream(fp); int read = fis.read(buff); javax.activation.FileTypeMap mmap = new javax.activation.MimetypesFileTypeMap(); response.setContentType(mmap.getContentType(src)); response.setContentLength((int) fp.length()); response.setHeader( "Content-Disposition", request.getParameter("dtype") + "; filename=\"" + ht.get("Name") + "\";"); response.getOutputStream().write(buff); response.getOutputStream().flush(); response.getOutputStream().close(); String map = ht.get("relatedto").toString(); String refid = ht.get("recid").toString(); myjobj.put("success", true); } catch (Exception e) { System.out.println(e.getMessage()); } return new ModelAndView("jsonView", "model", myjobj.toString()); }
public static JSONArray getProductTypesJson(HttpServletRequest request, List list) throws ServiceException, SessionExpiredException { JSONArray jArr = new JSONArray(); try { Iterator itr = list.iterator(); while (itr.hasNext()) { Producttype ptype = (Producttype) itr.next(); JSONObject obj = new JSONObject(); obj.put("id", ptype.getID()); obj.put("name", ptype.getName()); jArr.put(obj); } } catch (JSONException ex) { throw ServiceException.FAILURE("getProductTypesJson : " + ex.getMessage(), ex); } return jArr; }
/** * this function will return a jsonstring given a resultset in a format that is required for * WTF.Grid just use this inside the ur jsp file and set the url for the grid datastore as that * jsp file */ public JSONObject GetJsonForGrid(SqlRowSet rs) { JSONObject jb = null; try { SqlRowSetMetaData rsmd = rs.getMetaData(); JSONArray jArr = new JSONArray(); while (rs.next()) { JSONObject jobj = new JSONObject(); for (int i = 1; i <= rsmd.getColumnCount(); i++) { if (rs.getObject(i) != null) jobj.put(rsmd.getColumnName(i), rs.getObject(i)); else jobj.put(rsmd.getColumnName(i), ""); } jArr.put(jobj); } if (jArr.length() > 0) jb = new JSONObject().put("data", jArr); } catch (Exception ex) { System.out.println("exception -->" + ex); } return jb; }
public void setCustomData(CrmAccount crmAcc, JSONArray cstmData) { StringBuffer fields = new StringBuffer("accountid,company"); StringBuffer qmarks = new StringBuffer("?,?"); ArrayList params = new ArrayList(); params.add(crmAcc.getAccountid()); params.add(crmAcc.getCompany().getCompanyID()); boolean hasValue = false; try { for (int i = 0; i < cstmData.length(); i++) { JSONObject jobj = cstmData.getJSONObject(i); if (jobj.has(Constants.Crm_custom_field)) { String fieldname = jobj.getString(Constants.Crm_custom_field); String fielddbname = jobj.getString(fieldname); String fieldValue = jobj.getString(fielddbname); hasValue = true; fielddbname = fielddbname.replace("c", "C"); Integer xtype = Integer.parseInt(jobj.getString("xtype")); if (!StringUtil.isNullOrEmpty(fieldValue) && !StringUtil.isNullOrEmpty(fieldValue.trim()) && !fieldValue.equalsIgnoreCase(Constants.field_data_undefined)) { fields.append(',').append(fielddbname); qmarks.append(",?"); params.add(fieldValue); } else { if (xtype == 7 || xtype == 8 || xtype == 4) { fields.append(',').append(fielddbname); qmarks.append(",?"); params.add(null); } else { fields.append(',').append(fielddbname); qmarks.append(",?"); params.add(""); } } } } } catch (NumberFormatException e) { e.printStackTrace(); } catch (JSONException e) { e.printStackTrace(); } if (hasValue) { StringBuffer sql = new StringBuffer("insert into crmaccountcustomdata (") .append(fields) .append(")VALUES(") .append(qmarks) .append(')'); updateJDBC(sql.toString(), params.toArray()); } }
public static JSONObject getJsonForAction( Connection conn, PreparedStatement pstmt, ResultSet rs, HttpServletRequest request, String callerFlag) throws ServiceException { java.text.SimpleDateFormat sdf1 = new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); JSONObject jobj = new JSONObject(); ResultSet rs2 = null; try { int aid = rs.getInt("actionid"); String author = AuthHandler.getAuthor(conn, rs.getString("actionby")); String params = rs.getString("params"); String userparam[] = params.split(","); String query2 = "select textkey from actions where actionid = ?"; pstmt = conn.prepareStatement(query2); pstmt.setInt(1, aid); rs2 = pstmt.executeQuery(); Object[] strParam = new Object[userparam.length]; for (int i = 0; i < userparam.length; i++) { strParam[i] = userparam[i]; } rs2.next(); String action = rs2.getString("textkey"); String useraction = MessageSourceProxy.getMessage(action, strParam, request); String sdtStr = Timezone.toCompanyTimezone( conn, rs.getTimestamp("timestamp").toString(), AuthHandler.getCompanyid(request)); jobj.put("logid", rs.getInt("logid")); jobj.put("actionby", author); jobj.put("description", useraction); if (callerFlag.equals("all") || callerFlag.equals("projname")) { String projectname = ""; String projid = rs.getString("projectid"); if (!StringUtil.isNullOrEmpty(projid)) { projectname = projdb.getProjectName(conn, projid); } jobj.put("projname", projectname); } jobj.put("timestamp", sdtStr); } catch (ServiceException ex) { Logger.getLogger(AuditTrail.class.getName()).log(Level.SEVERE, null, ex); } catch (JSONException ex) { throw ServiceException.FAILURE("AuditTrail.getJsonForAction", ex); } catch (Exception ex) { throw ServiceException.FAILURE("AuditTrail.getJsonForAction", ex); } finally { return jobj; } }
public ModelAndView deleteDocuments(HttpServletRequest request, HttpServletResponse response) { KwlReturnObject result; JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); // 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>(); requestParams.put("ids", request.getParameterValues("ids")); String applicant = request.getParameter("applicant"); applicant = StringUtil.checkForNull(applicant); if (applicant.equalsIgnoreCase("applicant")) { result = hrmsExtApplDocsDAOObj.deleteDocuments(requestParams); } else { result = documentDAOObj.deleteDocuments(requestParams); } if (result.isSuccessFlag()) { jobj.put("success", true); } else { jobj.put("success", false); } jobj1.put("data", jobj.toString()); jobj1.put("valid", true); txnManager.commit(status); } catch (Exception e) { System.out.println(e.getMessage()); txnManager.rollback(status); } finally { return new ModelAndView("jsonView", "model", jobj1.toString()); } }
@Override public KwlReturnObject saveAccountProject(JSONObject jobj1) throws ServiceException { JSONObject jobj = new JSONObject(); List ll = new ArrayList(); try { String companyid = jobj1.getString("companyid"); String userid = jobj1.getString("userid"); String projectName = jobj1.getString("projectName"); String accId = jobj1.getString("accId"); jobj.put("projectname", projectName); jobj.put("companyid", companyid); jobj.put("userid", userid); jobj.put("remoteapikey", ConfigReader.getinstance().get("remoteapikey")); jobj = apiCallHandlerService.callApp(jobj1.getString("appURL"), jobj, companyid, "12", true); if (jobj.has("success") && jobj.getBoolean("success")) { jobj = jobj.getJSONObject("data"); String projectId = jobj.getString("projectid"); String nickName = jobj.getString("nickname"); AccountProject ap = new AccountProject(); if (!StringUtil.isNullOrEmpty(accId)) { ap.setAccountId((CrmAccount) get(CrmAccount.class, accId)); } if (!StringUtil.isNullOrEmpty(nickName)) { ap.setNickName(nickName); } if (!StringUtil.isNullOrEmpty(projectId)) { ap.setProjectId(projectId); } if (!StringUtil.isNullOrEmpty(projectName)) { ap.setProjectName(projectName); } save(ap); jobj = new JSONObject(); jobj.put("projectid", ap.getProjectId()); } else { String errorCode = jobj.getString("errorcode"); jobj = new JSONObject(); jobj.put("errorcode", errorCode); } ll.add(jobj); } catch (JSONException e) { logger.warn(e.getMessage(), e); throw ServiceException.FAILURE("crmAccountDAOImpl.saveAccountProject : " + e.getMessage(), e); } catch (HibernateException e) { logger.warn(e.getMessage(), e); throw ServiceException.FAILURE("crmAccountDAOImpl.saveAccountProject : " + e.getMessage(), e); } catch (Exception e) { logger.warn(e.getMessage(), e); throw ServiceException.FAILURE("crmAccountDAOImpl.saveAccountProject : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, 0); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#editAccounts(com.krawler.utils.json.base.JSONObject) */ public KwlReturnObject editAccounts(JSONObject jobj) throws ServiceException { List ll = new ArrayList(); int dl = 0; try { String companyid = null; String userid = null; String id = ""; if (jobj.has("accountid")) { id = jobj.getString("accountid"); } CrmAccount crmAccount = (CrmAccount) get(CrmAccount.class, id); if (jobj.has("accountname")) { crmAccount.setAccountname(jobj.getString("accountname")); } if (jobj.has("accounttypeid")) { crmAccount.setCrmCombodataByAccounttypeid( (DefaultMasterItem) get(DefaultMasterItem.class, jobj.getString("accounttypeid"))); } if (jobj.has("companyid")) { companyid = jobj.getString("companyid"); crmAccount.setCompany((Company) get(Company.class, companyid)); } if (jobj.has("description")) { crmAccount.setDescription(jobj.getString("description")); } if (jobj.has("website")) { crmAccount.setWebsite(jobj.getString("website")); } if (jobj.has("email")) { crmAccount.setEmail(jobj.getString("email")); } if (jobj.has("address")) { crmAccount.setMailstreet(jobj.getString("address")); } if (jobj.has("productid")) { saveAccountProducts(new String[] {id}, jobj.getString("productid").split(",")); } if (jobj.has("price")) { crmAccount.setPrice(jobj.getString("price")); } if (jobj.has("phone")) { crmAccount.setPhone(jobj.getString("phone")); } if (jobj.has("revenue")) { crmAccount.setRevenue(jobj.getString("revenue")); } if (jobj.has("industryid")) { crmAccount.setCrmCombodataByIndustryid( (DefaultMasterItem) get(DefaultMasterItem.class, jobj.getString("industryid"))); } if (jobj.has("updatedon")) { crmAccount.setUpdatedOn(System.currentTimeMillis()); } if (jobj.has("createdon")) { crmAccount.setCreatedOn(jobj.getLong("createdon")); } else { crmAccount.setCreatedOn(System.currentTimeMillis()); } if (jobj.has("userid")) { userid = jobj.getString("userid"); crmAccount.setUsersByUpdatedbyid((User) get(User.class, userid)); // crmAccount.setUsersByCreatedbyid((User) hibernateTemplate.get(User.class, // userid)); } if (jobj.has("accountownerid")) { setMainAccOwner(new String[] {id}, jobj.getString("accountownerid")); // crmAccount.setUsersByUserid((User) hibernateTemplate.get(User.class, // jobj.getString("accountownerid"))); } if (jobj.has("validflag")) { crmAccount.setValidflag(Integer.parseInt(jobj.getString("validflag"))); } if (jobj.has("isarchive")) { crmAccount.setIsarchive(jobj.getBoolean("isarchive")); } if (jobj.has("deleteflag")) { crmAccount.setDeleteflag(Integer.parseInt(jobj.getString("deleteflag"))); try { if (Integer.parseInt(jobj.getString("deleteflag")) == 1) { String query = "delete from AccountProducts where accountid.accountid=?"; executeUpdate(query, id); } } catch (Exception te) { logger.warn("Products related to the account could not be deleted :", te); } } if (jobj.has("CrmAccountCustomDataobj")) { crmAccount.setCrmAccountCustomDataobj( (CrmAccountCustomData) get(CrmAccountCustomData.class, jobj.getString("CrmAccountCustomDataobj"))); } if (jobj.has("leadid")) { crmAccount.setCrmLead((CrmLead) get(CrmLead.class, jobj.getString("leadid"))); } saveOrUpdate(crmAccount); ll.add(crmAccount); } catch (JSONException e) { throw ServiceException.FAILURE("crmAccountDAOImpl.editAccounts : " + e.getMessage(), e); } catch (DataAccessException e) { throw ServiceException.FAILURE("crmAccountDAOImpl.editAccounts : " + e.getMessage(), e); } catch (Exception e) { throw ServiceException.FAILURE("crmAccountDAOImpl.editAccounts : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
public ModelAndView getDocs(HttpServletRequest request, HttpServletResponse response) { JSONObject jobj = new JSONObject(); JSONObject jobj1 = new JSONObject(); KwlReturnObject kmsg = null; KwlReturnObject result = null; try { HashMap<String, Object> requestParams = new HashMap<String, Object>(); ArrayList filter_names = new ArrayList(), filter_values = new ArrayList(); JSONArray jarr = new JSONArray(); String userid = ""; int start, limit; userid = request.getParameter("userid"); String currentuser = AuthHandler.getUserid(request); String ss = request.getParameter("ss"); if (request.getParameter("start") == null) { start = 0; limit = 15; } else { start = Integer.parseInt(request.getParameter("start")); limit = Integer.parseInt(request.getParameter("limit")); } if (request.getParameter("applicant").equalsIgnoreCase("applicant")) { filter_names.add("recid"); filter_values.add(userid); filter_names.add("docid.deleted"); filter_values.add(false); filter_names.add("docid.referenceid"); filter_values.add(userid); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); requestParams.put("ss", ss); requestParams.put("searchcol", new String[] {"docid.docname", "docid.docdesc"}); requestParams.put("start", start); requestParams.put("limit", limit); requestParams.put("allflag", false); result = hrmsExtApplDocsDAOObj.getDocs(requestParams); Iterator ite = result.getEntityList().iterator(); while (ite.hasNext()) { HrmsDocmap docs = (HrmsDocmap) ite.next(); JSONObject tmpObj = new JSONObject(); tmpObj.put("docid", docs.getDocid().getDocid()); tmpObj.put("docname", docs.getDocid().getDocname()); tmpObj.put("docdesc", docs.getDocid().getDocdesc()); tmpObj.put("uploadedby", docs.getDocid().getUploadedby()); Float dsize = Math.max(0, Float.parseFloat(docs.getDocid().getDocsize()) / 1024); tmpObj.put("docsize", String.valueOf(dsize)); tmpObj.put( "uploaddate", AuthHandler.getDateFormatter(request).format(docs.getDocid().getUploadedon())); jarr.put(tmpObj); } } else { filter_names.add("recid"); filter_values.add(userid); filter_names.add("docid.deleteflag"); filter_values.add(0); requestParams.put("filter_names", filter_names); requestParams.put("filter_values", filter_values); requestParams.put("ss", ss); requestParams.put("searchcol", new String[] {"docid.docname", "docid.docdesc"}); requestParams.put("start", start); requestParams.put("limit", limit); requestParams.put("allflag", false); result = documentDAOObj.getDocs(requestParams); Iterator ite = result.getEntityList().iterator(); while (ite.hasNext()) { Docmap docs = (Docmap) ite.next(); JSONObject tmpObj = new JSONObject(); tmpObj.put("docid", docs.getDocid().getDocid()); tmpObj.put("docname", docs.getDocid().getDocname()); tmpObj.put("docdesc", docs.getDocid().getDocdesc()); tmpObj.put( "uploadedby", docs.getDocid().getUserid().getFirstName() + " " + docs.getDocid().getUserid().getLastName()); Float dsize = Math.max(0, Float.parseFloat(docs.getDocid().getDocsize()) / 1024); tmpObj.put("docsize", String.valueOf(dsize)); tmpObj.put( "uploaddate", AuthHandler.getDateFormatter(request).format(docs.getDocid().getUploadedon())); jarr.put(tmpObj); } } jobj.put("data", jarr); jobj.put("count", result.getRecordTotalCount()); jobj1.put("data", jobj.toString()); jobj1.put("valid", true); } catch (Exception e) { System.out.println(e.getMessage()); } return new ModelAndView("jsonView", "model", jobj1.toString()); }
public static JSONArray getProductsJson(HttpServletRequest request, List list) throws JSONException, ServiceException { Iterator itr = list.iterator(); JSONArray jArr = new JSONArray(); Producttype producttype = new Producttype(); String productid = request.getParameter("productid"); Boolean nonSaleInventory = Boolean.parseBoolean((String) request.getParameter("loadInventory")); while (itr.hasNext()) { Object[] row = (Object[]) itr.next(); Product product = (Product) row[0]; Product parentProduct = product.getParent(); if (product.getID().equals(productid)) continue; ProductCyclecount pcObject = (ProductCyclecount) row[8]; JSONObject obj = new JSONObject(); obj.put("productid", product.getID()); obj.put("productname", product.getName()); obj.put("desc", product.getDescription()); UnitOfMeasure uom = product.getUnitOfMeasure(); obj.put("uomid", uom == null ? "" : uom.getID()); obj.put("uomname", uom == null ? "" : uom.getName()); obj.put("precision", uom == null ? 0 : (Integer) uom.getAllowedPrecision()); obj.put("leadtime", product.getLeadTimeInDays()); obj.put("syncable", product.isSyncable()); obj.put("reorderlevel", product.getReorderLevel()); obj.put("reorderquantity", product.getReorderQuantity()); obj.put( "purchaseaccountid", (product.getPurchaseAccount() != null ? product.getPurchaseAccount().getID() : "")); obj.put( "salesaccountid", (product.getSalesAccount() != null ? product.getSalesAccount().getID() : "")); obj.put( "purchaseretaccountid", (product.getPurchaseReturnAccount() != null ? product.getPurchaseReturnAccount().getID() : "")); obj.put( "salesretaccountid", (product.getSalesReturnAccount() != null ? product.getSalesReturnAccount().getID() : "")); obj.put("vendor", (product.getVendor() != null ? product.getVendor().getID() : "")); obj.put("vendornameid", (product.getVendor() != null ? product.getVendor().getName() : "")); obj.put( "producttype", (product.getProducttype() != null ? product.getProducttype().getID() : "")); obj.put( "vendorphoneno", (product.getVendor() != null ? product.getVendor().getContactNumber() : "")); obj.put("vendoremail", (product.getVendor() != null ? product.getVendor().getEmail() : "")); obj.put("type", (product.getProducttype() != null ? product.getProducttype().getName() : "")); obj.put("pid", product.getProductid()); obj.put("parentuuid", parentProduct == null ? "" : parentProduct.getID()); obj.put("parentid", parentProduct == null ? "" : parentProduct.getProductid()); obj.put("parentname", parentProduct == null ? "" : parentProduct.getName()); obj.put("level", row[1]); obj.put("leaf", row[2]); obj.put("purchaseprice", row[3]); obj.put("saleprice", row[4]); obj.put("quantity", (row[5] == null ? 0 : row[5])); obj.put("initialquantity", (row[6] == null ? 0 : row[6])); obj.put("initialprice", (row[7] == null ? 0 : row[7])); obj.put("salespricedatewise", (row[9] == null ? 0 : row[9])); obj.put("purchasepricedatewise", (row[10] == null ? 0 : row[10])); obj.put("initialsalesprice", (row[11] == null ? 0 : row[11])); obj.put("ccountinterval", pcObject != null ? pcObject.getCountInterval() : ""); obj.put("ccounttolerance", pcObject != null ? pcObject.getTolerance() : ""); SimpleDateFormat sdf = new SimpleDateFormat("MMMM d, yyyy hh:mm:ss aa"); // obj.put("createdon", (row[12]==null?"":sdf.format(row[12]))); // jArr.put(obj); if (nonSaleInventory && obj.get("producttype").equals(producttype.Inventory_Non_Sales)) { // Do Nothing } else { jArr.put(obj); } } return jArr; }
public ModelAndView addDocuments(HttpServletRequest request, HttpServletResponse response) throws ServletException { JSONObject jobj = new JSONObject(); JSONObject myjobj = new JSONObject(); List fileItems = null; KwlReturnObject kmsg = null; String auditAction = ""; boolean applicant = false; String id = java.util.UUID.randomUUID().toString(); PrintWriter out = null; // 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 { response.setContentType("text/html;charset=UTF-8"); out = response.getWriter(); String userid = sessionHandlerImplObj.getUserid(request); String map = request.getParameter("mapid"); HashMap<String, String> arrParam = new HashMap<String, String>(); boolean fileUpload = false; String docdesc; ArrayList<FileItem> fi = new ArrayList<FileItem>(); if (request.getParameter("fileAdd") != null) { DiskFileUpload fu = new DiskFileUpload(); fileItems = fu.parseRequest(request); documentDAOObj.parseRequest(fileItems, arrParam, fi, fileUpload); arrParam.put("IsIE", request.getParameter("IsIE")); if (arrParam.get("applicantid").equalsIgnoreCase("applicant")) { applicant = true; userid = arrParam.get("refid"); } if (StringUtil.isNullOrEmpty((String) arrParam.get("docdesc")) == false) { docdesc = (String) arrParam.get("docdesc"); } } for (int cnt = 0; cnt < fi.size(); cnt++) { String docID; if (applicant) { kmsg = hrmsExtApplDocsDAOObj.uploadFile( fi.get(cnt), userid, arrParam, profileHandlerDAOObj.getUserFullName(sessionHandlerImplObj.getUserid(request))); HrmsDocs doc = (HrmsDocs) kmsg.getEntityList().get(0); docID = doc.getDocid(); } else { kmsg = documentDAOObj.uploadFile(fi.get(cnt), userid, arrParam); Docs doc = (Docs) kmsg.getEntityList().get(0); docID = doc.getDocid(); } String companyID = sessionHandlerImplObj.getCompanyid(request); String userID = sessionHandlerImplObj.getUserid(request); String refid = arrParam.get("refid"); jobj.put("userid", userID); jobj.put("docid", docID); jobj.put("companyid", companyID); jobj.put("id", id); jobj.put("map", map); jobj.put("refid", refid); if (arrParam.get("applicantid").equalsIgnoreCase("applicant")) { hrmsExtApplDocsDAOObj.saveDocumentMapping(jobj); } else { documentDAOObj.saveDocumentMapping(jobj); } } myjobj.put("ID", id); txnManager.commit(status); } catch (Exception e) { System.out.println(e.getMessage()); txnManager.rollback(status); } finally { out.close(); } return new ModelAndView("jsonView", "model", myjobj.toString()); }
@Override public KwlReturnObject updateMassAccount(JSONObject jobj) throws ServiceException { List ll = new ArrayList(); String hqlVarPart = ""; List<Object> params = new ArrayList<Object>(); int dl = 0; try { String companyid = null; String userid = null; String[] accountids = (String[]) jobj.get("accountid"); if (jobj.has("accountname")) { hqlVarPart += " accountname = ?,"; params.add(jobj.getString("accountname")); } if (jobj.has("accounttypeid")) { hqlVarPart += " crmCombodataByAccounttypeid = ?,"; params.add(get(DefaultMasterItem.class, jobj.getString("accounttypeid"))); } if (jobj.has("companyid")) { hqlVarPart += " company = ?,"; params.add(get(Company.class, jobj.getString("companyid"))); } if (jobj.has("description")) { hqlVarPart += " description = ?,"; params.add(jobj.getString("description")); } if (jobj.has("website")) { hqlVarPart += " website = ?,"; params.add(jobj.getString("website")); } if (jobj.has("email")) { hqlVarPart += " email = ?,"; params.add(jobj.getString("email")); } if (jobj.has("address")) { hqlVarPart += " mailstreet = ?,"; params.add(jobj.getString("address")); } if (jobj.has("productid")) { saveAccountProducts(accountids, jobj.getString("productid").split(",")); } if (jobj.has("price")) { hqlVarPart += " price = ?,"; params.add(jobj.getString("price")); } if (jobj.has("phone")) { hqlVarPart += " phone = ?,"; params.add(jobj.getString("phone")); } if (jobj.has("revenue")) { hqlVarPart += " revenue = ?,"; params.add(jobj.getString("revenue")); } if (jobj.has("industryid")) { hqlVarPart += " crmCombodataByIndustryid = ?,"; params.add(get(DefaultMasterItem.class, jobj.getString("industryid"))); } if (jobj.has("updatedon")) { hqlVarPart += " updatedOn = ?,"; params.add(jobj.getLong("updatedon")); } if (jobj.has("createdon")) { Long createdOn = jobj.getLong("createdon"); hqlVarPart += " createdOn = ?,"; params.add(createdOn); } if (jobj.has("userid")) { hqlVarPart += " usersByUpdatedbyid = ?,"; params.add(get(User.class, jobj.getString("userid"))); } if (jobj.has("accountownerid")) { setMainAccOwner(accountids, jobj.getString("accountownerid")); } if (jobj.has("validflag")) { hqlVarPart += " validflag = ?,"; params.add(Integer.parseInt(jobj.getString("validflag"))); } if (jobj.has("deleteflag")) { hqlVarPart += " deleteflag = ?,"; params.add(Integer.parseInt(jobj.getString("deleteflag"))); String query = "delete from AccountProducts where accountid.accountid in (:accountids)"; Map map = new HashMap(); map.put("accountids", accountids); executeUpdate(query, null, map); } if (jobj.has("CrmAccountCustomDataobj") && jobj.getBoolean("CrmAccountCustomDataobj")) { linkCustomData(); } if (jobj.has("leadid")) { hqlVarPart += " crmLead = ?,"; params.add(get(CrmLead.class, jobj.getString("leadid"))); } hqlVarPart = hqlVarPart.substring(0, Math.max(0, hqlVarPart.lastIndexOf(','))); String hql = "update CrmAccount set " + hqlVarPart + " where accountid in (:accountids)"; Map map = new HashMap(); map.put("accountids", accountids); executeUpdate(hql, params.toArray(), map); } catch (JSONException e) { throw ServiceException.FAILURE("crmAccountDAOImpl.updateMassAccount : " + e.getMessage(), e); } catch (DataAccessException e) { throw ServiceException.FAILURE("crmAccountDAOImpl.updateMassAccount : " + e.getMessage(), e); } catch (Exception e) { throw ServiceException.FAILURE("crmAccountDAOImpl.updateMassAccount : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
private ByteArrayOutputStream getCsvData( JSONArray src, JSONArray store, HttpServletRequest request) throws ServiceException { ByteArrayOutputStream baos = new ByteArrayOutputStream(); StringBuilder resSB = new StringBuilder(); JSONObject temp = null; int fieldListLength = 0; try { String header = ""; temp = new JSONObject( "{data:[Project Start,Baseline Start,Actual Start," + "Start Variance,Project Finish,Baseline Finish,Actual Finish,Finish Variance," + "Scheduled,Baseline,Variance,Remaining,Actual,Scheduled,Baseline,Variance," + "Remaining,Actual,Scheduled,Baseline,Variance,Remaining,Actual,Percent Complete," + "Task not yet Started,Task in progress,Task Completed,Parent Tasks, Total Tasks]}"); JSONArray colHeader = temp.getJSONArray("data"); temp = new JSONObject( "{data:[Project Start Date,Baseline Start Date,Project Actual Start Date," + "Start Variance,Project End Date,Baseline End Date,Project End Date,End Variance," + "Scheduled Duration,Baseline Duration,Duration Variance,Remaining Duration," + "Actual Duration,Scheduled Cost,Baseline Cost,Cost Variance,Remaining Cost,Actual Cost," + "Scheduled Work,Baseline Work,Work Variance,Remaining Work,Actual Work,Percent Complete," + "Unstarted Tasks,Inprogress Tasks,Completed Tasks,Parent Tasks,Total Tasks]}"); JSONArray fieldList = temp.getJSONArray("data"); fieldListLength = fieldList.length(); for (int i = 0; i < src.length(); i++) { colHeader.put(src.getJSONObject(i).getString("type")); fieldList.put("count"); } fieldList.put("Total Resources"); colHeader.put("Total Resources"); for (int i = 0; i < colHeader.length(); i++) { header += "\"" + colHeader.get(i).toString() + "\","; } header = header.substring(0, (header.length() - 1)); header += "\n"; resSB.append(header); String dataIndexArrStr[] = new String[fieldList.length()]; for (int i = 0; i < fieldList.length(); i++) dataIndexArrStr[i] = fieldList.get(i).toString(); for (int i = 0; i < store.length(); i++) { temp = store.getJSONObject(i); String dstr = ""; for (int j = 0; j < fieldListLength; j++) dstr += "\"" + temp.getString(dataIndexArrStr[j]) + "\","; dstr = dstr.substring(0, (dstr.length() - 1)); dstr += "\n"; resSB.append(dstr); } for (int i = 0; i < src.length(); i++) { temp = src.getJSONObject(i); String dstr = ""; dstr += "\"" + temp.getString("count") + "\","; dstr = dstr.substring(0, (dstr.length() - 1)); resSB.append(dstr); } String dstr = ""; dstr += "\"" + store.getJSONObject(0).getString("Total Resources") + "\","; resSB.append(dstr); baos.write(resSB.toString().getBytes()); baos.close(); } catch (IOException ex) { throw ServiceException.FAILURE("ExportProjectReport.getCsvData", ex); } catch (JSONException e) { throw ServiceException.FAILURE("ExportProjectReport.getCsvData", e); } catch (Exception e) { throw ServiceException.FAILURE("ExportProjectReport.getCsvData", e); } return baos; }
protected void processRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, SessionExpiredException { JSONObject j = null; Connection conn = null; clearAll(); String projectId = request.getParameter("projectid"); ProjectName = request.getParameter("projname"); ReportName = request.getParameter("reportname"); String loginid = AuthHandler.getUserid(request); String userName = AuthHandler.getUserName(request); String companyid = AuthHandler.getCompanyid(request); String ipAddress = AuthHandler.getIPAddress(request); String exportType = request.getParameter("exporttype"); String filename = filename = ProjectName + "_" + ReportName + "." + exportType; ByteArrayOutputStream baos = null; try { conn = DbPool.getConnection(); String cmpcurr = ProfileHandler.getCmpCurrFromProj(conn, projectId); try { char a1 = (char) Integer.parseInt(cmpcurr, 16); currSymbol = Character.toString(a1); } catch (Exception e) { currSymbol = cmpcurr; } String baseid = request.getParameter("baselineid"); String jbase = projdb.getBaselineDetails(conn, baseid); JSONObject temp = new JSONObject(jbase); baseName = temp.getJSONArray("data").getJSONObject(0).getString("baselinename"); String reportJson = projdb.getProjectSummaryData(conn, projectId, baseid, loginid); j = projdb.getAllProjectSummaryData(reportJson); JSONArray store = j.getJSONArray("data"); JSONArray rstore = j.getJSONArray("resources"); if (StringUtil.equal(exportType, "pdf")) { baos = getPdfData(store, rstore, request); } else if (StringUtil.equal(exportType, "csv")) { JSONObject jtemp = new JSONObject(reportJson); rstore = jtemp.getJSONArray("resources"); baos = getCsvData(rstore, store, request); } String params = AuthHandler.getAuthor(conn, loginid) + " (" + userName + "), " + ReportName + ", " + exportType + " , " + ProjectName; AuditTrail.insertLog( conn, "1111", loginid, projectId, projectId, companyid, params, ipAddress, 0); } catch (ServiceException ex) { filename = "Problem_in_exporting_file." + exportType; DbPool.quietRollback(conn); } catch (JSONException e) { filename = "Problem_in_exporting_file." + exportType; DbPool.quietRollback(conn); } finally { DbPool.quietClose(conn); try { if (baos != null) { baos.close(); } } catch (IOException e) { } writeDataToFile(filename, baos, response); } }
public static String getActionLog(Connection conn, HttpServletRequest request) throws ServiceException { ResultSet rs = null; String returnStr = ""; PreparedStatement pstmt = null; String searchString = request.getParameter("ss"); String limit = request.getParameter("limit"); String offset = request.getParameter("start"); JSONObject resobj = new JSONObject(); JSONObject tempobj = new JSONObject(); JSONArray jarr = new JSONArray(); String likeClause = ""; try { String companyid = AuthHandler.getCompanyid(request); String loginid = AuthHandler.getUserid(request); String[] searchStrObj = new String[] {"params", "actiontext"}; String myLikeString = StringUtil.getMySearchString(searchString, "and", searchStrObj); String flag = ""; int count1 = 0; String type = request.getParameter("type"); String dateSting = getDateString(conn, request, loginid); if (StringUtil.isNullOrEmpty(type)) { flag = "no"; returnStr = getAllLog(conn, request, companyid, limit, offset, searchString, dateSting); } else { switch (Integer.parseInt(type)) { case 0: flag = "projname"; returnStr = getLog(conn, request, companyid, limit, offset, searchString, dateSting, flag); flag = "no"; break; case 1: String admintype = request.getParameter("admintype"); if (admintype.equals("0")) { likeClause = "and al.actionid like '31%' "; } else if (admintype.equals("1")) { likeClause = "and al.actionid like '32%' "; } else { likeClause = "and al.actionid like '33%' or al.actionid like '40%' "; } flag = "admin"; break; case 2: flag = "doc"; likeClause = "and al.actionid like '21%' "; break; case 3: flag = "all"; likeClause = "and projectid != '' "; break; case 4: flag = "admin"; likeClause = "and (al.actionid like '31%' or al.actionid like '32?' or al.actionid like '33?' or al.actionid like '40%')"; break; case 5: flag = "all"; likeClause = "and (al.actionid like '41%')"; break; } } if (!flag.equals("no")) { count1 = getCountQuery( conn, pstmt, companyid, likeClause, myLikeString, searchStrObj, searchString, dateSting); String query = "select logid, al.actionid, actionby, params, timestamp, projectid from actionlog al inner join actions a on al.actionid = a.actionid where companyid = ? " + likeClause + myLikeString + dateSting + " order by timestamp DESC limit ? offset ?"; pstmt = conn.prepareStatement(query); pstmt.setString(1, companyid); int cnt = StringUtil.insertParamSearchString(2, pstmt, searchString, searchStrObj.length); pstmt.setInt(cnt++, Integer.parseInt(limit)); pstmt.setInt(cnt++, Integer.parseInt(offset)); rs = pstmt.executeQuery(); while (rs.next()) { tempobj = getJsonForAction(conn, pstmt, rs, request, flag); jarr.put(tempobj); } resobj.put("data", jarr); resobj.append("count", count1); returnStr = resobj.toString(); } } catch (ServiceException ex) { Logger.getLogger(AuditTrail.class.getName()).log(Level.SEVERE, null, ex); } catch (Exception ex) { throw ServiceException.FAILURE("AuditTrail.getActionLog :" + ex.getMessage(), ex); } finally { return returnStr; } }
public void saveDocumentMapping(JSONObject jobj) throws ServiceException { try { Docmap docMap = new Docmap(); if (jobj.has("docid") && !StringUtil.isNullOrEmpty(jobj.getString("docid"))) { Docs doc = (Docs) hibernateTemplate.get(Docs.class, jobj.getString("docid")); docMap.setDocid(doc); if (jobj.has("companyid") && !StringUtil.isNullOrEmpty(jobj.getString("companyid"))) { Company company = (Company) hibernateTemplate.get(Company.class, jobj.getString("companyid")); doc.setCompany(company); } if (jobj.has("userid") && !StringUtil.isNullOrEmpty(jobj.getString("userid"))) { User user = (User) hibernateTemplate.get(User.class, jobj.getString("userid")); doc.setUserid(user); } } if (jobj.has("refid")) { docMap.setRecid(jobj.getString("refid")); } if (jobj.has("map")) { docMap.setRelatedto(jobj.getString("map")); } hibernateTemplate.save(docMap); } catch (Exception ex) { throw ServiceException.FAILURE("documentDAOImpl.saveDocumentMapping", ex); } }