snippet-do-dao.java

Query query = session.createQuery("select sum(p.valor) " +
	"from ParcelaDeAula as p where " +
	"p.contrato.dataDeCriacao <= :data " +
	"and " +
	"(p.dataDePagamento >= :data " +
	"or (p.situacao = :situacao and (p.dataDePagamento = null and p.dataOriginalDeVencimento >= :data)) " +
				")");
	
query.setParameter("data", data);
query.setParameter("situacao", SituacaoDeParcela.PAGO);