Skip to content

Instantly share code, notes, and snippets.

@peas

peas/snippet-do-dao.java

Created November 30, 2010 01:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save peas/720944 to your computer and use it in GitHub Desktop.
Save peas/720944 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment