Rev 228 | Rev 242 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 228 | Rev 229 | ||
|---|---|---|---|
| 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.LojaDTO; |
|
| 11 | import br.com.ec.domain.dto.UsuarioDTO; |
12 | import br.com.ec.domain.dto.UsuarioDTO; |
| 12 | import br.com.ec.domain.dto.UsuarioLojaDTO; |
- | |
| 13 | import br.com.ec.domain.dto.UsuarioPerfilDTO; |
13 | import br.com.ec.domain.dto.UsuarioPerfilDTO; |
| 14 | import br.com.ec.domain.modal.Usuario; |
14 | import br.com.ec.domain.modal.Usuario; |
| 15 | import br.com.ec.repository.SistemaAbstractRepository; |
15 | import br.com.ec.repository.SistemaAbstractRepository; |
| 16 | import br.com.ec.repository.UsuarioRepository; |
16 | import br.com.ec.repository.UsuarioRepository; |
| 17 | 17 | ||
| Line 49... | Line 49... | ||
| 49 | }
|
49 | }
|
| 50 | return null; |
50 | return null; |
| 51 | }
|
51 | }
|
| 52 | 52 | ||
| 53 | @Override |
53 | @Override |
| 54 | public List<UsuarioLojaDTO> consultarLojasDoUsuario(Long sequencialUsuario) { |
- | |
| - | 54 | public List<LojaDTO> consultarLojasDoUsuario(Long sequencialUsuario) { |
|
| 55 | StringBuilder jpql = new StringBuilder(); |
55 | StringBuilder jpql = new StringBuilder(); |
| 56 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioLojaDTO(ul.loja.sequencial, ul.loja.descricao) FROM UsuarioLoja ul "); |
- | |
| - | 56 | 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 "); |
57 | jpql.append("WHERE ul.usuario.sequencial = :sequencialUsuario "); |
| 58 | jpql.append("ORDER BY ul.loja.ordenador "); |
58 | jpql.append("ORDER BY ul.loja.ordenador "); |
| 59 | try { |
59 | try { |
| 60 | return getEntityManager().createQuery(jpql.toString(), UsuarioLojaDTO.class) |
- | |
| - | 60 | return getEntityManager().createQuery(jpql.toString(), LojaDTO.class) |
|
| 61 | .setParameter("sequencialUsuario", sequencialUsuario) |
61 | .setParameter("sequencialUsuario", sequencialUsuario) |
| 62 | .getResultList(); |
62 | .getResultList(); |
| 63 | } catch (Exception ex) { |
- | |
| 64 | ex.printStackTrace(); |
- | |
| 65 | }
|
- | |
| 66 | return null; |
- | |
| 67 | }
|
- | |
| 68 | - | ||
| 69 | @Override |
- | |
| 70 | public List<UsuarioLojaDTO> consultarTodasLojasAtivas(Long sequencialUsuario) { |
- | |
| 71 | StringBuilder jpql = new StringBuilder(); |
- | |
| 72 | jpql.append("SELECT new br.com.ec.domain.dto.UsuarioLojaDTO(l.sequencial, l.descricao) FROM Loja l "); |
- | |
| 73 | jpql.append("WHERE l.ativo = TRUE "); |
- | |
| 74 | jpql.append("ORDER BY l.ordenador "); |
- | |
| 75 | try { |
- | |
| 76 | return getEntityManager().createQuery(jpql.toString(), UsuarioLojaDTO.class).getResultList(); |
- | |
| 77 | } catch (Exception ex) { |
63 | } catch (Exception ex) { |
| 78 | ex.printStackTrace(); |
64 | ex.printStackTrace(); |
| 79 | }
|
65 | }
|
| 80 | return null; |
66 | return null; |
| 81 | }
|
67 | }
|