Advertisement
Guest User

Untitled

a guest
Sep 30th, 2014
203
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. public List<DocumentoAssinanteTO> listAssinanteSemImagemByDocument(DocumentoTO documento, UsuarioDepartamentoTO ud) {
  2. StringBuilder hql = new StringBuilder();
  3. hql.append(" SELECT DA.id, ");
  4. hql.append(" DOC.id,");
  5. hql.append(" UD.id, ");
  6. hql.append(" D.id, ");
  7. hql.append(" U.id, ");
  8. hql.append(" U.nome,");
  9. hql.append(" DOC.id, ");
  10. hql.append(" FROM ").append(DocumentoAssinanteTO.class.getName()).append(" DA ");
  11. hql.append(" INNER JOIN DA.documento DOC ");
  12. hql.append(" INNER JOIN DA.usuarioDepartamento UD ");
  13. hql.append(" INNER JOIN UD.usuario U");
  14. hql.append(" INNER JOIN UD.departamento D");
  15. hql.append(" WHERE DOC = :idDocumento AND UD = :idUserDep ");
  16. hql.append(" AND U.assinatura IS NULL ");
  17.  
  18.  
  19. Query query = queryTransform(hql.toString());
  20. query.setLong("idDocumento", documento.getId());
  21. query.setLong("idUserDep", ud.getId());
  22.  
  23. return query.list();
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement