/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getAccountOwners(java.util.HashMap, java.util.ArrayList, java.util.ArrayList) */ public KwlReturnObject getAccountOwners( HashMap<String, Object> requestParams, ArrayList filter_names, ArrayList filter_params) throws ServiceException { List ll = null; int dl = 0; try { String Hql = ""; if (requestParams.containsKey("usersList") && requestParams.get("usersList") != null) { Hql = " select distinct c from accountOwners ao inner join ao.account c where c.crmLead.usersByCreatedbyid = c.usersByCreatedbyid.userID "; Hql += StringUtil.filterQuery(filter_names, "and"); StringBuffer usersList = (StringBuffer) requestParams.get("usersList"); Hql += " and ao.usersByUserid.userID in (" + usersList + ") "; } else { boolean distinctFlag = false; if (requestParams.containsKey("distinctFlag") && requestParams.get("distinctFlag") != null) { distinctFlag = (Boolean) requestParams.get("distinctFlag"); } if (distinctFlag) { Hql = "select distinct c from accountOwners ao inner join ao.account c "; } else { Hql = "select ao, c from accountOwners ao inner join ao.account c "; } Hql += StringUtil.filterQuery(filter_names, "where"); } ll = executeQuery(Hql, filter_params.toArray()); dl = ll.size(); boolean pagingFlag = false; if (requestParams.containsKey("pagingFlag") && requestParams.get("pagingFlag") != null) { pagingFlag = Boolean.parseBoolean(requestParams.get("pagingFlag").toString()); } if (pagingFlag) { int start = 0; int limit = 25; if (requestParams.containsKey("start") && requestParams.containsKey("limit")) { start = Integer.parseInt(requestParams.get("start").toString()); limit = Integer.parseInt(requestParams.get("limit").toString()); } ll = executeQueryPaging(Hql, filter_params.toArray(), new Integer[] {start, limit}); } } catch (Exception ex) { throw ServiceException.FAILURE("crmAccountDAOImpl.getAccountOwners : " + ex.getMessage(), ex); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getAccountProducts(java.util.ArrayList, java.util.ArrayList) */ public KwlReturnObject getAccountProducts(ArrayList filter_names, ArrayList filter_params) throws ServiceException { List ll = null; int dl = 0; try { String Hql = "from AccountProducts ap "; String filterQuery = StringUtil.filterQuery(filter_names, "where"); Hql += filterQuery; String selectInQuery = Hql; ll = executeQuery(selectInQuery, filter_params.toArray()); dl = ll.size(); } catch (Exception ex) { throw ServiceException.FAILURE( "crmAccountDAOImpl.getAccountProducts : " + ex.getMessage(), ex); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getAccountRevenue(java.util.HashMap, java.util.ArrayList, java.util.ArrayList) */ public double getAccountRevenue( HashMap<String, Object> requestParams, ArrayList filter_names, ArrayList filter_params) throws ServiceException { List ll = null; double revenue = 0.0; try { String hql = "select distinct c.accountid from accountOwners ao inner join ao.account c "; hql += StringUtil.filterQuery(filter_names, "where"); hql = " select sum(ca.revenue) from CrmAccount ca where ca.accountid in(" + hql + ")"; ll = executeQuery(hql, filter_params.toArray()); if (ll != null && ll.size() > 0) { revenue = ll.get(0) == null ? 0 : Double.parseDouble((String) ll.get(0)); } } catch (Exception ex) { throw ServiceException.FAILURE("crmAccountDAOImpl.getAccountOwners : " + ex.getMessage(), ex); } return revenue; }
// ******************* Account Project ************************* @Override public KwlReturnObject getAccountProjectDetails(ArrayList filter_names, ArrayList filter_params) throws ServiceException { List ll = null; int dl = 0; try { String Hql = " Select c FROM AccountProject c "; int start = 0; int limit = 10; String filterQuery = StringUtil.filterQuery(filter_names, "where"); Hql += filterQuery; // ll = executeQuery( Hql, filter_params.toArray()); // dl = ll.size(); ll = executeQueryPaging(Hql, filter_params.toArray(), new Integer[] {start, limit}); } catch (Exception e) { logger.warn(e.getMessage(), e); throw ServiceException.FAILURE("crmAccountDAOImpl.getAccounts : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getCrmAccountCustomData(java.util.HashMap) */ public KwlReturnObject getCrmAccountCustomData(HashMap<String, Object> requestParams) throws ServiceException { List ll = null; int dl = 0; try { ArrayList filter_names = new ArrayList(); ArrayList filter_params = new ArrayList(); if (requestParams.containsKey("filter_names")) { filter_names = new ArrayList((List<String>) requestParams.get("filter_names")); } if (requestParams.containsKey("filter_values")) { filter_params = new ArrayList((List<String>) requestParams.get("filter_values")); } String Hql = "from CrmAccountCustomData "; String filterQuery = StringUtil.filterQuery(filter_names, "where"); int ind = filterQuery.indexOf("("); if (ind > -1) { int index = Integer.valueOf(filterQuery.substring(ind + 1, ind + 2)); filterQuery = filterQuery.replaceAll("(" + index + ")", filter_params.get(index).toString()); filter_params.remove(index); } Hql += filterQuery; ll = executeQueryPaging(Hql, filter_params.toArray(), new Integer[] {0, 1}); dl = ll.size(); } catch (Exception e) { e.printStackTrace(); throw ServiceException.FAILURE( "crmAccountDAOImpl.getCrmAccountCustomData : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getAccounts(java.util.HashMap) */ public KwlReturnObject getAccounts(HashMap<String, Object> requestParams) throws ServiceException { List ll = null; int dl = 0; try { ArrayList filter_names = new ArrayList(); ArrayList filter_params = new ArrayList(); if (requestParams.containsKey("filter_names")) { filter_names = (ArrayList) requestParams.get("filter_names"); } if (requestParams.containsKey("filter_params")) { filter_params = (ArrayList) requestParams.get("filter_params"); } String Hql = "select distinct c from CrmAccount c "; if (filter_names.contains("INp.productId.productid")) { Hql += " inner join c.crmProducts as p "; } String filterQuery = StringUtil.filterQuery(filter_names, "where"); int ind = filterQuery.indexOf("("); if (ind > -1) { int index = Integer.valueOf(filterQuery.substring(ind + 1, ind + 2)); filterQuery = filterQuery.replaceAll("(" + index + ")", filter_params.get(index).toString()); filter_params.remove(index); } Hql += filterQuery; ll = executeQuery(Hql, filter_params.toArray()); dl = ll.size(); } catch (Exception e) { throw ServiceException.FAILURE("crmAccountDAOImpl.getActiveAccount : " + e.getMessage(), e); } return new KwlReturnObject(true, "002", "", ll, dl); }
/* (non-Javadoc) * @see com.krawler.spring.crm.accountModule.crmAccountDAO#getAllAccounts(java.util.HashMap, java.util.ArrayList, java.util.ArrayList) */ public KwlReturnObject getAllAccounts( HashMap<String, Object> requestParams, ArrayList filter_names, ArrayList filter_params) throws ServiceException { List ll = null; int dl = 0; try { String Hql = "select distinct c from accountOwners ao inner join ao.account c "; // String Hql = "select c from CrmAccount c "; String filterQuery = StringUtil.filterQuery(filter_names, "where"); Hql += filterQuery; int ind = Hql.indexOf("("); if (ind > -1) { int index = Integer.valueOf(Hql.substring(ind + 1, ind + 2)); Hql = Hql.replaceAll("(" + index + ")", filter_params.get(index).toString()); filter_params.remove(index); } if (requestParams.containsKey("ss") && requestParams.get("ss") != null) { String ss = StringEscapeUtils.escapeJavaScript(requestParams.get("ss").toString()); if (!StringUtil.isNullOrEmpty(ss)) { String[] searchcol = new String[] {"c.accountname"}; StringUtil.insertParamSearchString(filter_params, ss, 1); String searchQuery = StringUtil.getSearchString(ss, "and", searchcol); Hql += searchQuery; } } String selectInQuery = Hql; boolean pagingFlag = false; if (requestParams.containsKey("pagingFlag") && requestParams.get("pagingFlag") != null) { pagingFlag = Boolean.parseBoolean(requestParams.get("pagingFlag").toString()); } boolean countFlag = true; if (requestParams.containsKey("countFlag") && requestParams.get("countFlag") != null) { countFlag = Boolean.parseBoolean(requestParams.get("countFlag").toString()); } ArrayList order_by = null; ArrayList order_type = null; if (requestParams.containsKey("order_by")) order_by = (ArrayList) requestParams.get("order_by"); if (requestParams.containsKey("order_type")) order_type = (ArrayList) requestParams.get("order_type"); String orderQuery = StringUtil.orderQuery(order_by, order_type); if (StringUtil.isNullOrEmpty(orderQuery)) { orderQuery = " order by c.accountname "; } selectInQuery += orderQuery; if (countFlag) { ll = executeQuery(selectInQuery, filter_params.toArray()); dl = ll.size(); } if (pagingFlag) { int start = 0; int limit = 25; if (requestParams.containsKey("start") && requestParams.containsKey("limit")) { start = Integer.parseInt(requestParams.get("start").toString()); limit = Integer.parseInt(requestParams.get("limit").toString()); } ll = executeQueryPaging( selectInQuery, filter_params.toArray(), new Integer[] {start, limit}); if (!countFlag) { dl = ll.size(); } } } catch (Exception e) { throw ServiceException.FAILURE("crmAccountDAOImpl.getAllAccounts : " + e.getMessage(), e); } return new KwlReturnObject(true, KWLErrorMsgs.S01, "", ll, dl); }