/** Add order directly to criteria. */
private static void addOrder(Criteria c, String sort, String order, boolean ignoreCase) {
if (ORDER_DESC.equals(order)) {
c.addOrder(ignoreCase ? Order.desc(sort).ignoreCase() : Order.desc(sort));
} else {
c.addOrder(ignoreCase ? Order.asc(sort).ignoreCase() : Order.asc(sort));
}
}
public final Map<String, Object> findByMap(
final Map<String, Object> params, int page, int rows, String order, boolean asc)
throws HibernateException {
Criteria criteria = getSession().createCriteria(clazz);
Long total;
if (null != params) criteria.add(Restrictions.allEq(params));
total = (Long) criteria.setProjection(Projections.rowCount()).uniqueResult();
criteria.setProjection(null).setResultTransformer(Criteria.ROOT_ENTITY);
if (page > 0 && rows > 0) criteria.setFirstResult((page - 1) * rows).setMaxResults(rows);
if (null != order) {
if (asc) criteria.addOrder(Order.asc(order));
else criteria.addOrder(Order.desc(order));
}
Map<String, Object> result = new HashMap<String, Object>();
result.put("total", total);
result.put("rows", (List<T>) criteria.list());
return result;
}
@SuppressWarnings("unchecked")
@Override
public List<Lancamento> listar(Conta conta, Date dataInicio, Date dataFim) {
Criteria criteria = this.session.createCriteria(Lancamento.class);
if (dataInicio != null && dataFim != null) {
criteria.add(Restrictions.between("data", dataInicio, dataFim));
} else if (dataInicio != null) {
criteria.add(Restrictions.ge("data", dataInicio));
} else if (dataFim != null) {
criteria.add(Restrictions.le("data", dataFim));
}
criteria.add(Restrictions.eq("conta", conta));
criteria.addOrder(Order.asc("data"));
return criteria.list();
}
