Rev 382 | Rev 402 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed
| Rev 382 | Rev 383 | ||
|---|---|---|---|
| Line 12... | Line 12... | ||
| 12 | import br.com.ec.core.util.VerificadorUtil; |
12 | import br.com.ec.core.util.VerificadorUtil; |
| 13 | import br.com.ec.domain.dto.FormaPagamentoDTO; |
13 | import br.com.ec.domain.dto.FormaPagamentoDTO; |
| 14 | import br.com.ec.domain.dto.ParcelaDTO; |
14 | import br.com.ec.domain.dto.ParcelaDTO; |
| 15 | import br.com.ec.domain.dto.consulta.ParametrosConsultaLancamentosDTO; |
15 | import br.com.ec.domain.dto.consulta.ParametrosConsultaLancamentosDTO; |
| 16 | import br.com.ec.domain.dto.consulta.ParametrosConsultaParcelasDTO; |
16 | import br.com.ec.domain.dto.consulta.ParametrosConsultaParcelasDTO; |
| - | 17 | import br.com.ec.domain.model.FormaPagamento; |
|
| 17 | import br.com.ec.domain.model.Parcela; |
18 | import br.com.ec.domain.model.Parcela; |
| 18 | import br.com.ec.repository.ParcelaRepository; |
19 | import br.com.ec.repository.ParcelaRepository; |
| 19 | import br.com.ec.repository.SistemaAbstractRepository; |
20 | import br.com.ec.repository.SistemaAbstractRepository; |
| 20 | 21 | ||
| 21 | @Repository |
22 | @Repository |
| Line 150... | Line 151... | ||
| 150 | }
|
151 | }
|
| 151 | return sql.toString().replace(",)", ")"); |
152 | return sql.toString().replace(",)", ")"); |
| 152 | }
|
153 | }
|
| 153 | 154 | ||
| 154 | @Override |
155 | @Override |
| 155 | public void alterarDataPagamento(Long sequencialParcela, Date dataPagamento) { |
- | |
| - | 156 | public void conciliarParcelas(Date dataConciliacao, List<ParcelaDTO> parcelasSelecionadas) { |
|
| 156 | StringBuilder sql = new StringBuilder(); |
157 | StringBuilder sql = new StringBuilder(); |
| 157 | sql.append("UPDATE Parcela parcela SET parcela.dataPagamento = :dataPagamento "); |
- | |
| 158 | sql.append("WHERE parcela.sequencial = :sequencialParcela "); |
- | |
| - | 158 | sql.append("UPDATE Parcela parcela SET parcela.dataPagamento = :dataPagamento, parcela.indicadorConciliado = true "); |
|
| - | 159 | sql.append("WHERE parcela.sequencial IN ("); |
|
| - | 160 | StringBuilder sqlParcelas = new StringBuilder(""); |
|
| - | 161 | for (ParcelaDTO parcelaDTO : parcelasSelecionadas) { |
|
| - | 162 | sqlParcelas.append(parcelaDTO.getSequencial() + ","); |
|
| - | 163 | }
|
|
| - | 164 | sqlParcelas.append(") "); |
|
| - | 165 | sql.append(sqlParcelas.toString().replace(",)", ")")); |
|
| 159 | try { |
166 | try { |
| 160 | getEntityManager().createQuery(sql.toString()) |
167 | getEntityManager().createQuery(sql.toString()) |
| 161 | .setParameter("dataPagamento", dataPagamento) |
- | |
| 162 | .setParameter("sequencialParcela", sequencialParcela) |
- | |
| - | 168 | .setParameter("dataPagamento", dataConciliacao) |
|
| 163 | .executeUpdate(); |
169 | .executeUpdate(); |
| 164 | getEntityManager().flush(); |
170 | getEntityManager().flush(); |
| 165 | } catch(Exception ex) { |
171 | } catch(Exception ex) { |
| 166 | ex.printStackTrace(); |
172 | ex.printStackTrace(); |
| 167 | }
|
173 | }
|