public KwlReturnObject getAuditDetails(HashMap<String, Object> requestParams) throws ServiceException { List ll = null; int dl = 0; try { StringBuffer usersList = null; if (requestParams.containsKey("userslist")) usersList = (StringBuffer) requestParams.get("userslist"); String groups = requestParams.get("groups").toString(); int start = Integer.parseInt(requestParams.get("start").toString()); int limit = Integer.parseInt(requestParams.get("limit").toString()); int interval = Integer.parseInt(requestParams.get("interval").toString()); String query = "from AuditTrail at where"; if (StringUtil.isNullOrEmpty(usersList.toString())) { query += " at.user.userID in (" + usersList + ") and"; } query += " DATEDIFF(date(now()),date(at.auditTime)) <= ? and " + "at.action.auditGroup.groupName in (" + groups + ") order by at.auditTime desc"; ll = HibernateUtil.executeQuery(hibernateTemplate, query, interval); dl = ll.size(); ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {interval}, new Integer[] {start, limit}); } catch (Exception e) { throw ServiceException.FAILURE( "auditTrailDAOImpl.getRecentActivityDetails : " + e.getMessage(), e); } return new KwlReturnObject(true, "002", "", ll, dl); }
public KwlReturnObject getRecentActivityDetails(HashMap<String, Object> requestParams) throws ServiceException { List ll = null; int dl = 0; String recid = ""; String companyid = ""; try { if (requestParams.containsKey("recid") && requestParams.get("recid") != null) { recid = requestParams.get("recid").toString(); } if (requestParams.containsKey("companyid") && requestParams.get("companyid") != null) { companyid = requestParams.get("companyid").toString(); } String query = "from AuditTrail where user.company.companyID=? and recid=? order by auditTime desc"; ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {companyid, recid}, new Integer[] {0, 15}); dl = ll.size(); } catch (Exception e) { throw ServiceException.FAILURE( "detailPanelDAOImpl.getRecentActivityDetails : " + e.getMessage(), e); } return new KwlReturnObject(true, KwlReturnMsg.S01, "", ll, dl); }
public KwlReturnObject getDocumentList( HashMap<String, Object> requestParams, StringBuffer usersList) throws ServiceException { String tagSearch = requestParams.containsKey("tag") ? requestParams.get("tag").toString() : ""; String quickSearch = requestParams.containsKey("ss") ? requestParams.get("ss").toString() : ""; int start = 0; int limit = 20; int dl = 0; Object[] params = null; if (requestParams.containsKey("start") && requestParams.containsKey("limit") && !StringUtil.isNullOrEmpty(requestParams.get("start").toString())) { start = Integer.parseInt(requestParams.get("start").toString()); limit = Integer.parseInt(requestParams.get("limit").toString()); } List ll = null; try { String companyid = requestParams.get("companyid").toString(); String Hql = "select c from com.krawler.common.admin.Docmap c where c.docid.company.companyID=? "; params = new Object[] {companyid}; if (!StringUtil.isNullOrEmpty(tagSearch)) { tagSearch = tagSearch.replaceAll("'", ""); Hql += " and c.docid.tags like '%" + tagSearch + "%' "; } if (!StringUtil.isNullOrEmpty(quickSearch)) { Hql += " and c.docid.docname like '" + quickSearch + "%' "; } String selectInQuery = Hql + " and c.docid.userid.userID in (" + usersList + ") order by c.docid.uploadedon desc "; ll = HibernateUtil.executeQuery(hibernateTemplate, selectInQuery, params); dl = ll.size(); ll = HibernateUtil.executeQueryPaging( hibernateTemplate, selectInQuery, params, new Integer[] {start, limit}); } catch (ServiceException ex) { throw ServiceException.FAILURE("documentDAOImpl.getDocumentList", ex); } return new KwlReturnObject(true, KwlReturnMsg.S01, "", ll, dl); }
public KwlReturnObject getAuditData(HashMap<String, Object> requestParams) throws ServiceException { int start = 0; int limit = 30; String groupid = ""; String searchtext = ""; String companyid = ""; List ll = null; int dl = 0; try { if (requestParams.containsKey("start") && requestParams.containsKey("limit") && !StringUtil.isNullOrEmpty(requestParams.get("start").toString())) { start = Integer.parseInt(requestParams.get("start").toString()); limit = Integer.parseInt(requestParams.get("limit").toString()); } if (requestParams.containsKey("groupid") && requestParams.get("groupid") != null) { groupid = requestParams.get("groupid").toString(); } if (requestParams.containsKey("search") && requestParams.get("search") != null) { searchtext = requestParams.get("search").toString(); } if (requestParams.containsKey("companyid") && requestParams.get("companyid") != null) { companyid = requestParams.get("companyid").toString(); } String auditID = ""; if (searchtext.compareTo("") != 0) { String query2 = searchtext + "*"; SearchBean bean = new SearchBean(); String indexPath = storageHandlerImplObj.GetAuditTrailIndexPath(); String[] searchWithIndex = {"details", "ipaddr", "username"}; Hits hitResult = bean.skynetsearchMulti(query2, searchWithIndex, indexPath); if (hitResult != null) { Iterator itrH = hitResult.iterator(); while (itrH.hasNext()) { Hit hit1 = (Hit) itrH.next(); org.apache.lucene.document.Document doc = hit1.getDocument(); auditID += "'" + doc.get("transactionid") + "',"; } if (auditID.length() > 0) { auditID = auditID.substring(0, auditID.length() - 1); } } } if (groupid.compareTo("") != 0 && searchtext.compareTo("") != 0) { /* query for both gid and search */ if (auditID.length() > 0) { String query = "from AuditTrail where user.company.companyID=? and ID in (" + auditID + ") and action.auditGroup.ID = ? order by auditTime desc"; ll = HibernateUtil.executeQuery( hibernateTemplate, query, new Object[] {companyid, groupid}); dl = ll.size(); ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {companyid, groupid}, new Integer[] {start, limit}); } else { dl = 0; ll = new ArrayList(); } } else if (groupid.compareTo("") != 0 && searchtext.compareTo("") == 0) { /* query only for gid */ String query = "from AuditTrail where user.company.companyID=? and action.auditGroup.ID = ? order by auditTime desc"; ll = HibernateUtil.executeQuery(hibernateTemplate, query, new Object[] {companyid, groupid}); dl = ll.size(); ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {companyid, groupid}, new Integer[] {start, limit}); } else if (groupid.compareTo("") == 0 && searchtext.compareTo("") != 0) { /* query only for search */ if (auditID.length() > 0) { String query = "from AuditTrail where user.company.companyID=? and ID in (" + auditID + ") order by auditTime desc"; ll = HibernateUtil.executeQuery(hibernateTemplate, query, new Object[] {companyid}); dl = ll.size(); ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {companyid}, new Integer[] {start, limit}); } else { dl = 0; ll = new ArrayList(); } } else { /* query for all */ String query = "from AuditTrail where user.company.companyID=? order by auditTime desc"; ll = HibernateUtil.executeQuery(hibernateTemplate, query, new Object[] {companyid}); dl = ll != null ? ll.size() : 0; ll = HibernateUtil.executeQueryPaging( hibernateTemplate, query, new Object[] {companyid}, new Integer[] {start, limit}); } } catch (IOException ex) { throw ServiceException.FAILURE(ex.getMessage(), ex); } catch (ServiceException ex) { throw ServiceException.FAILURE(ex.getMessage(), ex); } catch (Exception ex) { throw ServiceException.FAILURE(ex.getMessage(), ex); } return new KwlReturnObject(true, KwlReturnMsg.S01, "", ll, dl); }