Rev 268 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 268 | Rev 325 | ||
|---|---|---|---|
| Line 7... | Line 7... | ||
| 7 | import javax.persistence.TypedQuery; |
7 | import javax.persistence.TypedQuery; |
| 8 | 8 | ||
| 9 | import org.springframework.stereotype.Repository; |
9 | import org.springframework.stereotype.Repository; |
| 10 | 10 | ||
| 11 | import br.com.ec.core.util.VerificadorUtil; |
11 | import br.com.ec.core.util.VerificadorUtil; |
| - | 12 | import br.com.ec.domain.dto.FuncionarioDTO; |
|
| 12 | import br.com.ec.domain.dto.VendedorDTO; |
13 | import br.com.ec.domain.dto.VendedorDTO; |
| 13 | import br.com.ec.domain.model.Vendedor; |
14 | import br.com.ec.domain.model.Vendedor; |
| 14 | import br.com.ec.repository.SistemaAbstractRepository; |
15 | import br.com.ec.repository.SistemaAbstractRepository; |
| 15 | import br.com.ec.repository.VendedorRepository; |
16 | import br.com.ec.repository.VendedorRepository; |
| 16 | 17 | ||
| Line 70... | Line 71... | ||
| 70 | }
|
71 | }
|
| 71 | */
|
72 | */
|
| 72 | @Override |
73 | @Override |
| 73 | public VendedorDTO consultarVendedorPorPessoa(Long sequencialPessoa) { |
74 | public VendedorDTO consultarVendedorPorPessoa(Long sequencialPessoa) { |
| 74 | StringBuilder jpql = new StringBuilder(); |
75 | StringBuilder jpql = new StringBuilder(); |
| 75 | jpql.append("SELECT new br.com.ec.domain.dto.VendedorDTO(v.sequencial, v.pessoa.sequencial, v.nome, v.loja.sequencial, v.loja.descricao) "); |
- | |
| 76 | jpql.append("FROM Vendedor v "); |
- | |
| 77 | jpql.append("WHERE v.pessoa.sequencial = :sequencialPessoa"); |
- | |
| - | 76 | jpql.append("SELECT new br.com.ec.domain.dto.VendedorDTO("); |
|
| - | 77 | jpql.append(VendedorDTO.CONSULTA_DTO_COMPLETA); |
|
| - | 78 | jpql.append(") FROM Vendedor e "); |
|
| - | 79 | jpql.append("WHERE e.pessoa.sequencial = :sequencialPessoa"); |
|
| 78 | try { |
80 | try { |
| 79 | return getEntityManager().createQuery(jpql.toString(), VendedorDTO.class) |
81 | return getEntityManager().createQuery(jpql.toString(), VendedorDTO.class) |
| 80 | .setParameter("sequencialPessoa", sequencialPessoa) |
82 | .setParameter("sequencialPessoa", sequencialPessoa) |
| 81 | .getSingleResult(); |
83 | .getSingleResult(); |
| 82 | } catch (NoResultException nre) { |
84 | } catch (NoResultException nre) { |