Rev 523 | Rev 648 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 523 | Rev 528 | ||
|---|---|---|---|
| Line 1... | Line 1... | ||
| 1 | package br.com.ec.repository.jpa; |
1 | package br.com.ec.repository.jpa; |
| 2 | 2 | ||
| - | 3 | import java.util.Date; |
|
| 3 | import java.util.List; |
4 | import java.util.List; |
| 4 | 5 | ||
| 5 | import org.springframework.stereotype.Repository; |
6 | import org.springframework.stereotype.Repository; |
| 6 | 7 | ||
| 7 | import br.com.ec.domain.dto.ConsolidacoesDTO; |
- | |
| 8 | import br.com.ec.domain.dto.VigenciaDTO; |
8 | import br.com.ec.domain.dto.VigenciaDTO; |
| 9 | import br.com.ec.domain.model.Vigencia; |
9 | import br.com.ec.domain.model.Vigencia; |
| 10 | import br.com.ec.repository.SistemaAbstractRepository; |
10 | import br.com.ec.repository.SistemaAbstractRepository; |
| 11 | import br.com.ec.repository.VigenciaRepository; |
11 | import br.com.ec.repository.VigenciaRepository; |
| 12 | 12 | ||
| Line 62... | Line 62... | ||
| 62 | ex.printStackTrace(); |
62 | ex.printStackTrace(); |
| 63 | return null; |
63 | return null; |
| 64 | }
|
64 | }
|
| 65 | }
|
65 | }
|
| 66 | 66 | ||
| 67 | /*
|
- | |
| 68 | @Override
|
67 | @Override |
| 69 | public List<Vigencia> consultarVigenciasSemAvaliacoes() {
|
- | |
| - | 68 | public Vigencia consultarVigenciaDoPeriodo(Date periodo) { |
|
| 70 | StringBuilder sql = new StringBuilder();
|
69 | StringBuilder sql = new StringBuilder(); |
| 71 | sql.append("SELECT e FROM Vigencia e WHERE (SELECT COUNT(*) FROM Avaliacao a WHERE a.vigencia.sequencial = e.sequencial) = 0 ");
|
- | |
| 72 | sql.append("ORDER BY e.dataInicio DESC");
|
- | |
| - | 70 | sql.append("SELECT e FROM Vigencia e WHERE e.dataInicio <= :periodo AND e.dataFim >= :periodo "); |
|
| 73 | try {
|
71 | try { |
| 74 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).getResultList();
|
- | |
| - | 72 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).setParameter("periodo", periodo).getSingleResult(); |
|
| 75 | } catch(Exception ex) {
|
73 | } catch(Exception ex) { |
| 76 | ex.printStackTrace();
|
74 | ex.printStackTrace(); |
| 77 | return null;
|
75 | return null; |
| 78 | }
|
76 | }
|
| 79 | }
|
77 | }
|
| 80 |
|
78 | |
| - | 79 | /*
|
|
| 81 | @Override
|
80 | @Override
|
| 82 | public List<Vigencia> consultarUltimasVigencias() {
|
- | |
| - | 81 | public List<Vigencia> consultarVigenciasSemAvaliacoes() {
|
|
| 83 | StringBuilder sql = new StringBuilder();
|
82 | StringBuilder sql = new StringBuilder();
|
| 84 | sql.append("SELECT e FROM Vigencia e ");
|
- | |
| - | 83 | sql.append("SELECT e FROM Vigencia e WHERE (SELECT COUNT(*) FROM Avaliacao a WHERE a.vigencia.sequencial = e.sequencial) = 0 ");
|
|
| 85 | sql.append("ORDER BY e.dataInicio DESC");
|
84 | sql.append("ORDER BY e.dataInicio DESC");
|
| 86 | try {
|
85 | try {
|
| 87 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).setMaxResults(5).getResultList();
|
- | |
| - | 86 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).getResultList();
|
|
| 88 | } catch(Exception ex) {
|
87 | } catch(Exception ex) {
|
| 89 | ex.printStackTrace();
|
88 | ex.printStackTrace();
|
| 90 | return null;
|
89 | return null;
|
| 91 | }
|
90 | }
|
| 92 | }
|
91 | }
|
| 93 |
|
92 |
|
| 94 | @Override
|
93 | @Override
|
| 95 | public Vigencia consultarVigenciaDoPeriodo(Date periodo) {
|
- | |
| - | 94 | public List<Vigencia> consultarUltimasVigencias() {
|
|
| 96 | StringBuilder sql = new StringBuilder();
|
95 | StringBuilder sql = new StringBuilder();
|
| 97 | sql.append("SELECT e FROM Vigencia e WHERE e.dataInicio <= :periodo AND e.dataFim >= :periodo ");
|
- | |
| - | 96 | sql.append("SELECT e FROM Vigencia e ");
|
|
| - | 97 | sql.append("ORDER BY e.dataInicio DESC");
|
|
| 98 | try {
|
98 | try {
|
| 99 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).setParameter("periodo", periodo).getSingleResult();
|
- | |
| - | 99 | return getEntityManager().createQuery(sql.toString(), Vigencia.class).setMaxResults(5).getResultList();
|
|
| 100 | } catch(Exception ex) {
|
100 | } catch(Exception ex) {
|
| 101 | ex.printStackTrace();
|
101 | ex.printStackTrace();
|
| 102 | return null;
|
102 | return null;
|
| 103 | }
|
103 | }
|
| 104 | }
|
104 | }
|