Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @idPagamentoVenda INT= 58663033;
- DECLARE @qtParcelas INT= 4;
- DECLARE @prTaxaAdministracao NUMERIC(9, 2)= 0.25;
- IF(
- (
- SELECT COUNT(*)
- FROM card.tbParcela
- WHERE idPagamentoVenda = @idPagamentoVenda
- AND idStatusParcela = 2
- ) = 0)
- BEGIN
- IF(
- (
- SELECT COUNT(*)
- FROM card.tbParcela
- WHERE idPagamentoVenda = @idPagamentoVenda
- ) <> @qtParcelas)
- BEGIN
- DECLARE @iterator INT= 0;
- DECLARE @cntCorrente INT=
- (
- SELECT TOP 1 COUNT(*)
- FROM card.tbParcela
- WHERE idPagamentoVenda = @idPagamentoVenda
- );
- DELETE FROM card.tbParcela
- WHERE idPagamentoVenda = @idPagamentoVenda;
- UPDATE card.tbPagamentoVenda
- SET
- qtParcelas = @qtParcelas
- WHERE idPagamentoVenda = @idPagamentoVenda;
- WHILE @qtParcelas > @iterator
- BEGIN
- INSERT INTO card.tbParcela
- SELECT t1.idPagamentoVenda 'idPagamentoVenda',
- @iterator + 1 'nrParcela',
- t1.idEmpresa 'idEmpresa',
- t1.dtEmissao 'dtEmissao',
- CONVERT(VARCHAR, DATEADD(DAY, 30, CONVERT(DATE, t1.dtEmissao, 103)), 23) 'dtVencimento',
- t1.vlPagamento / @qtParcelas 'vlParcela',
- @prTaxaAdministracao 'vlTaxaAdministracao',
- @cntCorrente 'idContaCorrente',
- NULL 'dtPagamento',
- NULL 'vlPago',
- 1 'idStatusParcela',
- NULL 'idMovimentoBanco'
- FROM card.tbPagamentoVenda t1
- WHERE t1.idPagamentoVenda = @idPagamentoVenda;
- SET @iterator = @iterator + 1;
- END;
- END;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement