public Long getResults() { return (Long) getSession() .createCriteria(persistentClass) .setProjection(Projections.count("id")) .uniqueResult(); }
@Override @Transactional(readOnly = true) public Integer countTotal() { Criteria crit = createCriteria(); crit.setProjection(Projections.count("rid")); return ((Number) crit.list().get(0)).intValue(); }
public int getUserDetailsCountBySessionId(String searchq, Long sessionPK) { Session session = getSession(); session.getTransaction().begin(); int totalRowCount = 0; Criteria criteria = session.createCriteria(BrowserDetails.class, "browserDetails"); criteria.createAlias("browserDetails.sessionDetails", "sessionDetails"); criteria.createAlias("browserDetails.deviceDetails", "deviceDetails"); criteria.createAlias("browserDetails.eventDetails", "eventDetails"); criteria.add(Restrictions.eq("sessionDetails.SID", sessionPK)); criteria.setProjection(Projections.count("eventDetails.EID")); if (!searchq.isEmpty()) { criteria.add( Restrictions.disjunction() .add(Restrictions.ilike("deviceDetails.deviceName", searchq, MatchMode.ANYWHERE)) .add(Restrictions.ilike("browserName", searchq, MatchMode.ANYWHERE)) .add(Restrictions.ilike("eventDetails.eventName", searchq, MatchMode.ANYWHERE)) .add(Restrictions.ilike("eventDetails.orientation", searchq, MatchMode.ANYWHERE))); } Long value = (Long) criteria.uniqueResult(); totalRowCount = Integer.valueOf(value.intValue()); session.getTransaction().commit(); session.close(); return totalRowCount; }
public TicketSummary getClosedTicketSummary(Terminal terminal) { Session session = null; TicketSummary ticketSummary = new TicketSummary(); try { session = getSession(); Criteria criteria = session.createCriteria(Ticket.class); criteria.add(Restrictions.eq(Ticket.PROP_CLOSED, Boolean.TRUE)); criteria.add(Restrictions.eq(Ticket.PROP_VOIDED, Boolean.FALSE)); criteria.add(Restrictions.eq(Ticket.PROP_REFUNDED, Boolean.FALSE)); criteria.add(Restrictions.eq(Ticket.PROP_DRAWER_RESETTED, Boolean.FALSE)); criteria.add(Restrictions.eq(Ticket.PROP_TERMINAL, terminal)); ProjectionList projectionList = Projections.projectionList(); projectionList.add(Projections.count(Ticket.PROP_ID)); projectionList.add(Projections.sum(Ticket.PROP_TOTAL_AMOUNT)); criteria.setProjection(projectionList); List list = criteria.list(); if (list.size() > 0) { Object[] o = (Object[]) list.get(0); ticketSummary.setTotalTicket(((Integer) o[0]).intValue()); ticketSummary.setTotalPrice(o[1] == null ? 0 : ((Double) o[1]).doubleValue()); } return ticketSummary; } finally { closeSession(session); } }
@Override @Transactional(readOnly = true, propagation = Propagation.SUPPORTS) public Long countConsoleInfos() { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(ConsoleInfo.class); criteria.setProjection(Projections.count("id")); return (Long) criteria.uniqueResult(); }
/** * 通过指定的起始数获取总集合 * * @return 集合总数 */ @SuppressWarnings("unchecked") public int getTotal() { Criteria query = this.getSession().createCriteria(FinalEvaluationInfo.class); query.setProjection(Projections.count("finalEvaluationID")); query.setMaxResults(1); List list = query.list(); int result = 0; if (list.size() > 0) { result = (Integer) list.get(0); } return result; }
public Integer getCountUserValidate(String staffPiority) { Criteria criteria = getSession().createCriteria(User.class); criteria.add(Restrictions.eq("validateStu", 0)); criteria.add(Restrictions.like("piority", "%" + staffPiority + "%")); ProjectionList projectionList = Projections.projectionList(); projectionList.add(Projections.count("validateStu")); criteria.setProjection(projectionList); Integer count = (Integer) criteria.uniqueResult(); closeSession(); return count; }
public int getUnservedOdlist() { Session session = sf.openSession(); int result = ((Number) session .createCriteria(BdyOrderlist.class) .add(Restrictions.eq("olState", 0)) .setProjection(Projections.count("odlistId")) .uniqueResult()) .intValue(); session.close(); return result; }
@Transactional(readOnly = true) @Override public boolean contains(String id, String password) { Long count = (Long) currentSession() .createCriteria(clazz) .setProjection(Projections.count("id")) .add(Restrictions.eq("id", id)) .add(Restrictions.eq("password", password)) .setMaxResults(1) .uniqueResult(); return count > 0; }
@Override public int obtenhaQuantidadePorUF(UF estado) { Criteria c = getSession().createCriteria(Cliente.class); c.createAlias("enderecoPrimario", "endp"); c.createAlias("enderecoSecundario", "ends"); Disjunction d = Restrictions.disjunction(); d.add(Restrictions.eq("endp.uf", estado.getSigla())); d.add(Restrictions.eq("ends.uf", estado.getSigla())); c.setProjection(Projections.count("codigo")); c.add(d); return (int) c.uniqueResult(); }
public int getCurrentUserCount(String searchq) throws Exception { Session session = getSession(); session.getTransaction().begin(); int totalRowCount = 0; Criteria criteria = session.createCriteria(SessionDetails.class); criteria.add(Restrictions.eq("status", "ACTIVE")).setProjection(Projections.count("SID")); ; Long value = (Long) criteria.uniqueResult(); totalRowCount = Integer.valueOf(value.intValue()); session.getTransaction().commit(); session.close(); return totalRowCount; }
@Transactional public Map<OandaAccount, Long> transactionsCountByAccount() { final String property = "account"; Criteria criteria = getSession() .createCriteria(OandaTransaction.class) .setProjection( Projections.projectionList() .add(Projections.groupProperty(property)) .add(Projections.count(property))); @SuppressWarnings("rawtypes") List results = criteria.list(); Map<OandaAccount, Long> accountCountMap = Maps.newLinkedHashMap(); for (Object row : results) { Object[] rowData = (Object[]) row; accountCountMap.put((OandaAccount) rowData[0], (Long) rowData[1]); } return accountCountMap; }
@Override public Projection buildProjection( String projectionField, ProjectionType projectionType, Iterator argsIterator) { Projection projection = new Projection(); projection.setField(projectionField); switch (projectionType) { case RowCount: projection.setDetails(Projections.rowCount()); break; case Count: projection.setDetails(Projections.count(projectionField)); break; case CountDistinct: projection.setDetails(Projections.countDistinct(projectionField)); break; case Maximum: projection.setDetails(Projections.max(projectionField)); break; case Minimum: projection.setDetails(Projections.min(projectionField)); break; case Average: projection.setDetails(Projections.avg(projectionField)); break; case Sum: projection.setDetails(Projections.sum(projectionField)); break; default: throw new RuntimeException("Unexpected projection type: " + projectionType); } return projection; }
public static long countChildOrgs(Organisation organisation, Session session) { Criteria crit = session.createCriteria(Organisation.class); crit.setCacheable(true); Disjunction notDeleted = Restrictions.disjunction(); notDeleted.add(Restrictions.isNull("deleted")); notDeleted.add(Restrictions.eq("deleted", Boolean.FALSE)); crit.add(notDeleted); crit.add(Restrictions.ne("id", organisation.getId())); Criteria critParentLink = crit.createCriteria("parentOrgLinks"); critParentLink.add(Restrictions.eq("owner", organisation)); crit.setProjection(Projections.count("id")); Object result = crit.uniqueResult(); if (result == null) { return 0; } else if (result instanceof Integer) { Integer i = (Integer) result; return i.longValue(); } else { return (long) result; } }