Rafael Francischini rfunix
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Collections.Generic; | |
| using System.IO; | |
| using System.Linq; | |
| using System.Net; | |
| using System.Net.Sockets; | |
| using System.Security.Cryptography; | |
| using System.Text; | |
| using System.Text.RegularExpressions; | |
| using System.Threading.Tasks; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| divida["codigo_do_credor"] = int(dados_divida[0].replace("-", "").replace(" ", "")) if dados_divida[0] else 0 | |
| divida["cpf_ou_cnpj"] = int(dados_divida[1].replace("-", "").replace(" ", "")) if dados_divida[1] else 0 | |
| divida["titulo"] = REGEX_SPECIAL_CARACTER.sub("", dados_divida[2]) | |
| divida["codigo_do_titulo"] = int(dados_divida[3].replace("-", "").replace(" ", "")) if dados_divida[3] else 0 | |
| divida["codigo_do_servico_ou_produto"] = int(dados_divida[4].replace("-", "").replace(" ", "")) if dados_divida[4] else 0 | |
| divida["data_do_titulo"] = dados_divida[5] | |
| divida["vencimento_do_titulo"] = dados_divida[6] | |
| divida["valor_do_titulo"] = float(dados_divida[7].replace("-", "").replace(" ", "").replace(",", ".")) | |
| divida["valor_do_corrigido"] = float(dados_divida[8].replace("-", "").replace(" ", "").replace(",", ".")) | |
| divida["situacao"] = int(dados_divida[9].replace("-", "").replace(" ", "")) if dados_divida[9] else 0 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /****** Script do comando SelectTopNRows de SSMS ******/ | |
| SELECT VendasCorp.Diaria as Timestamp, | |
| VendasCorp.Descr_Regional as Regional, | |
| VendasCorp.Apelido_Pessoa as ApelidoLoja, | |
| VendasCorp.Nome_Pessoa as RazaoLoja, | |
| VendasCorp.Cobol_Cod_Loja as CodigoLoja, | |
| VendasCorp.Acumulado as DataAcumuladoAtualInicio, | |
| VendasCorp.Data_Acu_Fim as DataAcumuladoAtualFim, | |
| VendasCorp.Dia_Acum as AcumuladoAtual, | |
| VendasCorp.Acumulado_Ant as DataAcumuladoAnteriorInicio, |