Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public List<DocumentoAssinanteTO> listAssinanteSemImagemByDocument(DocumentoTO documento, UsuarioDepartamentoTO ud) {
- StringBuilder hql = new StringBuilder();
- hql.append(" SELECT DA.id, ");
- hql.append(" DOC.id,");
- hql.append(" UD.id, ");
- hql.append(" D.id, ");
- hql.append(" U.id, ");
- hql.append(" U.nome,");
- hql.append(" DOC.id, ");
- hql.append(" FROM ").append(DocumentoAssinanteTO.class.getName()).append(" DA ");
- hql.append(" INNER JOIN DA.documento DOC ");
- hql.append(" INNER JOIN DA.usuarioDepartamento UD ");
- hql.append(" INNER JOIN UD.usuario U");
- hql.append(" INNER JOIN UD.departamento D");
- hql.append(" WHERE DOC = :idDocumento AND UD = :idUserDep ");
- hql.append(" AND U.assinatura IS NULL ");
- Query query = queryTransform(hql.toString());
- query.setLong("idDocumento", documento.getId());
- query.setLong("idUserDep", ud.getId());
- return query.list();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement