Rev 259 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 259 | Rev 325 | ||
|---|---|---|---|
| Line 6... | Line 6... | ||
| 6 | import javax.persistence.TypedQuery; |
6 | import javax.persistence.TypedQuery; |
| 7 | 7 | ||
| 8 | import org.springframework.stereotype.Repository; |
8 | import org.springframework.stereotype.Repository; |
| 9 | 9 | ||
| 10 | import br.com.ec.core.exception.NegocioException; |
10 | import br.com.ec.core.exception.NegocioException; |
| - | 11 | import br.com.ec.domain.dto.FuncionarioDTO; |
|
| 11 | import br.com.ec.domain.dto.LojaDTO; |
12 | import br.com.ec.domain.dto.LojaDTO; |
| 12 | import br.com.ec.domain.dto.UsuarioDTO; |
13 | import br.com.ec.domain.dto.UsuarioDTO; |
| 13 | import br.com.ec.domain.dto.UsuarioPerfilDTO; |
14 | import br.com.ec.domain.dto.UsuarioPerfilDTO; |
| 14 | import br.com.ec.domain.model.Usuario; |
15 | import br.com.ec.domain.model.Usuario; |
| 15 | import br.com.ec.repository.SistemaAbstractRepository; |
16 | import br.com.ec.repository.SistemaAbstractRepository; |
| Line 21... | Line 22... | ||
| 21 | private static final String USUARIO_INFORMADO_NAO_EXISTE_PARA_ESTA_PESSOA = "Usuário informado não existe para esta pessoa"; |
22 | private static final String USUARIO_INFORMADO_NAO_EXISTE_PARA_ESTA_PESSOA = "Usuário informado não existe para esta pessoa"; |
| 22 | 23 | ||
| 23 | @Override |
24 | @Override |
| 24 | public UsuarioDTO consultarPorLogin(String login, String senha) { |
25 | public UsuarioDTO consultarPorLogin(String login, String senha) { |
| 25 | StringBuilder jpql = new StringBuilder(); |
26 | StringBuilder jpql = new StringBuilder(); |
| 26 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioDTO(u.sequencial, u.login, u.nome) FROM Usuario u "); |
- | |
| 27 | jpql.append("WHERE u.login = :login AND u.senha = :senha AND u.ativo is true"); |
- | |
| - | 27 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioDTO("); |
|
| - | 28 | jpql.append(UsuarioDTO.CONSULTA_DTO_COMPLETA); |
|
| - | 29 | jpql.append(") FROM Usuario e "); |
|
| - | 30 | jpql.append("WHERE e.login = :login AND e.senha = :senha AND e.ativo is true"); |
|
| 28 | try { |
31 | try { |
| 29 | return getEntityManager().createQuery(jpql.toString(), UsuarioDTO.class) |
32 | return getEntityManager().createQuery(jpql.toString(), UsuarioDTO.class) |
| 30 | .setParameter("login", login) |
33 | .setParameter("login", login) |
| 31 | .setParameter("senha", senha) |
34 | .setParameter("senha", senha) |
| 32 | .getSingleResult(); |
35 | .getSingleResult(); |
| 33 | } catch (NoResultException nre) { |
36 | } catch (NoResultException nre) { |
| 34 | throw new NegocioException("Usuário não existe"); |
37 | throw new NegocioException("Usuário não existe"); |
| 35 | }
|
38 | }
|
| - | 39 | }
|
|
| - | 40 | ||
| - | 41 | @Override |
|
| - | 42 | public UsuarioDTO consultarPorPessoa(Long sequencialPessoa) { |
|
| - | 43 | StringBuilder jpql = new StringBuilder(); |
|
| - | 44 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioDTO("); |
|
| - | 45 | jpql.append(UsuarioDTO.CONSULTA_DTO_COMPLETA); |
|
| - | 46 | jpql.append(") FROM Usuario e "); |
|
| - | 47 | jpql.append("WHERE e.pessoa.sequencial = :sequencialPessoa"); |
|
| - | 48 | try { |
|
| - | 49 | return getEntityManager().createQuery(jpql.toString(), UsuarioDTO.class) |
|
| - | 50 | .setParameter("sequencialPessoa", sequencialPessoa) |
|
| - | 51 | .getSingleResult(); |
|
| - | 52 | } catch (NoResultException nre) { |
|
| - | 53 | nre.printStackTrace(); |
|
| - | 54 | }
|
|
| - | 55 | return null; |
|
| 36 | }
|
56 | }
|
| 37 | 57 | ||
| 38 | @Override |
58 | @Override |
| 39 | public List<UsuarioPerfilDTO> consultarPerfisDoUsuario(Long sequencialUsuario) { |
59 | public List<UsuarioPerfilDTO> consultarPerfisDoUsuario(Long sequencialUsuario) { |
| 40 | StringBuilder jpql = new StringBuilder(); |
60 | StringBuilder jpql = new StringBuilder(); |
| 41 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioPerfilDTO(uf.usuario.sequencial, uf.perfil.codigo) FROM UsuarioPerfil uf "); |
- | |
| 42 | jpql.append("WHERE uf.usuario.sequencial = :sequencialUsuario"); |
- | |
| - | 61 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioPerfilDTO("); |
|
| - | 62 | jpql.append(UsuarioPerfilDTO.CONSULTA_DTO_COMPLETA); |
|
| - | 63 | jpql.append(") FROM UsuarioPerfil e "); |
|
| - | 64 | jpql.append("WHERE e.usuario.sequencial = :sequencialUsuario "); |
|
| - | 65 | jpql.append("ORDER BY e.perfil.descricao "); |
|
| 43 | try { |
66 | try { |
| 44 | return getEntityManager().createQuery(jpql.toString(), UsuarioPerfilDTO.class) |
- | |
| 45 | .setParameter("sequencialUsuario", sequencialUsuario) |
- | |
| 46 | .getResultList(); |
- | |
| 47 | } catch (Exception ex) { |
- | |
| - | 67 | TypedQuery<UsuarioPerfilDTO> query = getEntityManager().createQuery(jpql.toString(), UsuarioPerfilDTO.class); |
|
| - | 68 | query.setParameter("sequencialUsuario", sequencialUsuario); |
|
| - | 69 | return query.getResultList(); |
|
| - | 70 | } catch(Exception ex) { |
|
| 48 | ex.printStackTrace(); |
71 | ex.printStackTrace(); |
| - | 72 | return null; |
|
| 49 | }
|
73 | }
|
| 50 | return null; |
- | |
| 51 | }
|
74 | }
|
| 52 | 75 | ||
| - | 76 | /*
|
|
| 53 | @Override |
77 | @Override
|
| 54 | public List<LojaDTO> consultarLojasDoUsuario(Long sequencialUsuario) { |
78 | public List<LojaDTO> consultarLojasDoUsuario(Long sequencialUsuario) {
|
| 55 | StringBuilder jpql = new StringBuilder(); |
79 | StringBuilder jpql = new StringBuilder();
|
| 56 | jpql.append("SELECT new br.com.ec.domain.dto.LojaDTO(ul.loja.sequencial, ul.loja.descricao) FROM UsuarioLoja ul "); |
80 | jpql.append("SELECT new br.com.ec.domain.dto.LojaDTO(ul.loja.sequencial, ul.loja.descricao) FROM UsuarioLoja ul ");
|
| 57 | jpql.append("WHERE ul.usuario.sequencial = :sequencialUsuario "); |
81 | jpql.append("WHERE ul.usuario.sequencial = :sequencialUsuario ");
|
| Line 63... | Line 87... | ||
| 63 | } catch (Exception ex) { |
87 | } catch (Exception ex) {
|
| 64 | ex.printStackTrace(); |
88 | ex.printStackTrace();
|
| 65 | }
|
89 | }
|
| 66 | return null; |
90 | return null;
|
| 67 | }
|
91 | }
|
| - | 92 | */
|
|
| 68 | 93 | ||
| 69 | @Override |
94 | @Override |
| 70 | public Integer obterQuantidadeUsuarioDiferenteComSenhaInformada(String login, String senha) { |
95 | public Integer obterQuantidadeUsuarioDiferenteComSenhaInformada(String login, String senha) { |
| 71 | StringBuilder jpql = new StringBuilder(); |
96 | StringBuilder jpql = new StringBuilder(); |
| 72 | jpql.append("SELECT COUNT(u) FROM Usuario u "); |
97 | jpql.append("SELECT COUNT(u) FROM Usuario u "); |