
johnbh3
Membros-
Total de ítens
712 -
Registro em
-
Última visita
Tipo de Conteúdo
Blocks
Notes ACBrLibNFe
Fóruns
Downloads
Calendário
Tudo que johnbh3 postou
-
Olá E bem usado este pdv mini 10 da elgin Android? Eu fiquei na dúvida. Eu preciso ter um back certo? Pra gravar no banco as informação? Ou é recomendável gravad em sqlite local? Ele aceitaria requisição rest ? Como tem.sido a aplicação de informação com este pdv da elgin pela comunidade? Outra coisa sobre aprovar o documento fiscal assinatura etc. Eu que preciso no back fazer ? Ou eu gero com acbr o XML e elgin que envia os documentos fiscais(minha dúvida de isto seria obrigatório ) me preocupa caso surja atualização ou erro e não ter como saber. Achei o produto bem legal só não sei o quanto ele é usado e se vale a pena é esta parte técnica de aprovação do nfce e guardar os dados.
-
Olá Pessoal boa noite, com fmx e possível ter aplicativo em maquenta do pagSeguro, ciclo, rede, Stone Elas em si tudo é android. Mas normalmente pra se aprovar o pagamento precisa falar com sdk da maquineta. Existe como isso delphi fmx? Ou outro equipamento pos, onde no final de venda ele realizad pagamento ali via débito, crédito enfim isto é bem comum hoje em dia. Conhecem case disso ? Se sim algum githut ? At John
-
OU no caso nem usar uma smartPos uma webAPI em android com FMX que faz a requisição Eu vi que o acbr tem uma ideia do que imagino com sitef e paygo, mas como sou micro dev tentar passar mensalidade de tef pra meu cliente eu já to fora
-
Ola Pessoal me desculpe e que não entenda nada deste nicho. Exemplo tenho um software de estacionamento no primeiro momento não quero emitir o cupom e sim processar o pagamento. O cupom vou deixar a API emitir. Mas queria imprimir o comprovante falando com pagamento como se fosse um SDK. Isto existe. Como se fosse um WebTef porém com mercadoPago, pagseguro por exemplo. Sei que tem o sitef e paygo. Mas elas são caras quando o cliente e tão pequeno. Estou completamente em duvida.
-
Se eu tentar com TPNGIMage Gerei uma no paint tb iVBORw0KGgoAAAANSUhEUgAAAFwAAAAjCAYAAAAZm21MAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAABrSURBVGhD7dCxDcAwAMMwp///3GboDZxEwPCus+29C/L8H6TgWMGxgmMFxwqOFRwrOFZwrOBYwbGCYwXHCo4VHCs4VnCs4FjBsYJjBccKjhUcKzhWcKzgWMGxgmMFxwqOFRwrOFZwrODU9gFYFAFFtI13jAAAAABJRU5ErkJggg== da erro tambem. da The file being readed is not a valid "Portable Network Graphics" image because it contains an invalid header. This file may be corruped, try obtaining it again. O erro ocorre em Result.LoadFromStream(Output);
-
Se eu tentar com TPNGIMage da The file being readed is not a valid "Portable Network Graphics" image because it contains an invalid header. This file may be corruped, try obtaining it again. O erro ocorre em Result.LoadFromStream(Output);
-
data:image/png;base64,PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiPz4KPHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIGhlaWdodD0iNTgyIiB3aWR0aD0iNTgyIiBjbGFzcz0icHlxcmNvZGUiPjxwYXRoIHRyYW5zZm9ybT0ic2NhbGUoNikiIHN0cm9rZT0iIzAwMCIgY2xhc3M9InB5cXJsaW5lIiBkPSJNNCA0LjVoN20xIDBoMW0yIDBoNG0yIDBoMW0zIDBoMm00IDBoMW01IDBoM20xIDBoMW00IDBoMW0zIDBoMW0xIDBoMm0xIDBoMW0yIDBoMm0xIDBoNG0yIDBoMW01IDBoMm0xIDBoMW0xIDBoMm0yIDBoM20xIDBoN20tODkgMWgxbTUgMGgxbTEgMGgxbTEgMGgxbTIgMGgxbTEgMGgxbTEgMGg1bTMgMGgxbTEgMGg0bTEgMGgxbTEgMGgxbTEgMGgxbTMgMGgzbTEgMGgzbTEgMGg0bTEgMGgxbTIgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTYgMGgzbTEgMGgxbTEgMGgzbTEgMGgxbTIgMGgxbTUgMGgxbS04OSAxaDFtMSAwaDNtMSAwaDFtMSAwaDNtMiAwaDFtMSAwaDJtMSAwaDltMSAwaDFtMiAwaDFtMiAwaDJtMyAwaDJtNiAwaDNtMiAwaDNtMSAwaDFtMiAwaDFtNCAwaDFtMSAwaDFtMSAwaDJtMSAwaDRtMiAwaDFtNCAwaDFtMSAwaDNtMSAwaDFtLTg5IDFoMW0xIDBoM20xIDBoMW0yIDBoM20xIDBoMW0zIDBoNW0xIDBoN20yIDBoMTBtMSAwaDFtMiAwaDFtMiAwaDFtMSAwaDFtMSAwaDFtMSAwaDNtMiAwaDFtMiAwaDJtNCAwaDJtMiAwaDRtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDNtMSAwaDFtLTg5IDFoMW0xIDBoM20xIDBoMW0yIDBoM20yIDBoMW0yIDBoNG0yIDBoMW0yIDBoMW0xIDBoMTBtMiAwaDFtNCAwaDFtMSAwaDFtMyAwaDFtMiAwaDVtMyAwaDNtMiAwaDFtMSAwaDJtMyAwaDJtMyAwaDFtMiAwaDFtMSAwaDNtMSAwaDFtLTg5IDFoMW01IDBoMW0xIDBoN20xIDBoMW00IDBoMW0xIDBoNm0zIDBoNW0zIDBoMm0yIDBoMW0xIDBoMW0xIDBoMW0xIDBoMW0zIDBoMW0zIDBoMW0yIDBoMW0yIDBoM20xIDBoMW0xIDBoMm0xIDBoNW0xIDBoMW0yIDBoMW01IDBoMW0tODkgMWg3bTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGg3bS04MSAxaDFtMSAwaDNtMSAwaDFtNCAwaDFtMiAwaDJtMyAwaDJtMyAwaDFtOCAwaDJtMSAwaDJtMSAwaDFtMSAwaDJtMyAwaDFtMyAwaDhtMiAwaDFtNSAwaDFtNSAwaDFtLTc5IDFoM20xIDBoMW0xIDBoMW0yIDBoMW0xIDBoM20xIDBoMW0xIDBoNG0xIDBoMm0xIDBoNm01IDBoMW0xIDBoMW0yIDBoMm0zIDBoM20xIDBoMW0xIDBoNW00IDBoMm0xIDBoMW01IDBoMW0xIDBoMm0xIDBoM20xIDBoM20yIDBoM20tODggMWgybTIgMGgxbTIgMGgxbTMgMGg0bTMgMGg0bTEgMGg1bTEgMGgxbTEgMGgybTIgMGgzbTEgMGgxbTIgMGgxbTMgMGgybTQgMGgxbTIgMGgybTEgMGgybTIgMGgxbTMgMGgxbTEgMGgxbTIgMGgxbTMgMGgxbTMgMGgxbTcgMGgxbS04OSAxaDJtMiAwaDZtMyAwaDJtMiAwaDFtMyAwaDFtMSAwaDFtMyAwaDFtMyAwaDJtMSAwaDJtMSAwaDRtMyAwaDJtMSAwaDFtMSAwaDVtMiAwaDFtNCAwaDFtNSAwaDVtMiAwaDZtMSAwaDFtMiAwaDRtLTc3IDFoMW0xIDBoMW0zIDBoMW0zIDBoMW0xIDBoMW0xIDBoM20xIDBoM20xIDBoMW0xIDBoMW0zIDBoMW03IDBoMW0yIDBoMW0xIDBoNG0xIDBoM20yIDBoMTJtOCAwaDNtLTg1IDFoMW00IDBoMm0xIDBoMW0yIDBoM20xIDBoNW0xIDBoMW02IDBoMW0xIDBoMW0zIDBoMW0xIDBoNG0zIDBoMm0xIDBoMW0zIDBoMW01IDBoMm0yIDBoMm0xIDBoMW01IDBoMm0zIDBoMm0yIDBoMW0xIDBoMW0xIDBoNm0tODggMWgxbTMgMGgybTEgMGg0bTEgMGgxbTEgMGgxbTQgMGg3bTEgMGgybTEgMGgxbTIgMGgxbTUgMGgxbTEgMGgxbTEgMGgxbTIgMGgybTEgMGgybTIgMGgzbTEgMGgzbTQgMGgxbTIgMGg0bTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTMgMGgxbTUgMGgxbS04OSAxaDVtMSAwaDNtMSAwaDFtMSAwaDNtNCAwaDhtMiAwaDFtMSAwaDJtMSAwaDNtMiAwaDFtMSAwaDNtMSAwaDdtMiAwaDJtMSAwaDFtMiAwaDRtNCAwaDFtMSAwaDJtMSAwaDNtMSAwaDJtMSAwaDFtMiAwaDNtMSAwaDFtLTg2IDFoMm0zIDBoMW00IDBoMW0yIDBoMW0xIDBoMW0xIDBoMW01IDBoMW0yIDBoMW0yIDBoNG0yIDBoMm0xIDBoMm0yIDBoMW0xIDBoMm01IDBoMm0zIDBoMm0zIDBoMm0xIDBoMW0xIDBoMW0yIDBoM20yIDBoMW0xIDBoMW0xIDBoMm0xIDBoMm0yIDBoMm0tODcgMWgzbTEgMGgxbTEgMGgxbTEgMGgybTEgMGgxbTIgMGgybTEgMGg3bTQgMGgxbTIgMGgybTEgMGgzbTMgMGgxbTEgMGgybTEgMGg0bTEgMGgzbTIgMGgybTEgMGgxbTIgMGgybTMgMGgybTUgMGgzbTEgMGgxbTEgMGgxbTEgMGg0bS04MyAxaDFtNCAwaDJtMSAwaDFtMiAwaDFtMiAwaDFtMiAwaDNtMiAwaDVtMiAwaDZtMSAwaDJtMSAwaDFtMiAwaDFtMyAwaDZtMSAwaDFtNSAwaDFtNSAwaDJtMyAwaDFtNiAwaDRtMiAwaDJtLTg5IDFoM20zIDBoMW0yIDBoM20yIDBoMm0xIDBoMW0xIDBoMW0xIDBoMW0yIDBoMW01IDBoMW0zIDBoMm0xIDBoMm0xIDBoMW0xIDBoMW0xIDBoM20yIDBoMm0xIDBoM20zIDBoMW0yIDBoMW0xIDBoM20yIDBoM20zIDBoM200IDBoMW0xIDBoM20tODYgMWgzbTEgMGgybTEgMGgxbTEgMGgxbTIgMGgxbTEgMGgybTEgMGgybTIgMGgybTEgMGgybTEgMGgybTEgMGgxbTUgMGgxbTMgMGgxbTEgMGgxbTEgMGgzbTEgMGg2bTMgMGgxbTEgMGgxbTIgMGgxbTEgMGgxbTEgMGgybTEgMGgxbTEgMGgybTMgMGgxbTIgMGgybTEgMGg0bTEgMGgxbS04OCAxaDNtMSAwaDZtMiAwaDRtMSAwaDFtMiAwaDFtMSAwaDFtNCAwaDJtMiAwaDFtNCAwaDNtNSAwaDJtNCAwaDJtMyAwaDNtMyAwaDVtMyAwaDJtNCAwaDJtMSAwaDRtMyAwaDJtLTg3IDFoMW0xIDBoM20zIDBoNG0xIDBoNW0yIDBoMW0xIDBoMW0zIDBoMW0yIDBoM20xIDBoM20xIDBoMW0zIDBoMW0zIDBoM20yIDBoOG0yIDBoMW0yIDBoMW0yIDBoMm0xIDBoMW00IDBoM200IDBoM20xIDBoNG0tODcgMWgxbTMgMGgzbTIgMGgxbTEgMGgybTEgMGgxbTMgMGg1bTEgMGgxbTIgMGgxbTIgMGgxbTEgMGg0bTEgMGgxbTEgMGgxbTIgMGgxbTEgMGgxbTIgMGgybTEgMGgxbTMgMGgybTMgMGg2bTMgMGgybTIgMGg0bTEgMGgxbTMgMGgxbTEgMGgybS04NyAxaDNtMSAwaDFtNSAwaDNtMSAwaDFtMSAwaDFtMSAwaDJtMyAwaDFtMiAwaDJtMSAwaDFtMSAwaDJtMiAwaDRtMiAwaDVtMSAwaDFtMSAwaDFtMSAwaDRtMSAwaDFtMTEgMGg3bTEgMGgxbTMgMGgzbTEgMGgybTEgMGgybS04OCAxaDFtMiAwaDFtMSAwaDRtMSAwaDFtMiAwaDJtMiAwaDFtNyAwaDFtNCAwaDNtMiAwaDFtMiAwaDFtMSAwaDJtMSAwaDFtMSAwaDFtMyAwaDFtMSAwaDNtMSAwaDJtNSAwaDNtMiAwaDJtMiAwaDFtMiAwaDJtMiAwaDJtMiAwaDFtMiAwaDFtLTg3IDFoMW00IDBoMW0xIDBoMW0yIDBoMW0xIDBoMm01IDBoM20xIDBoN20xIDBoMm0xIDBoMm0xIDBoMm0zIDBoM20xIDBoMm0yIDBoMW0yIDBoMm0yIDBoMm0zIDBoM20xIDBoNW0zIDBoM20xIDBoMW0xIDBoM20yIDBoMm0xIDBoMW0tODkgMWgxbTEgMGgybTEgMGgzbTIgMGgzbTIgMGgybTIgMGgxbTEgMGgybTEgMGgxbTIgMGgybTEgMGgxbTEgMGgzbTMgMGgybTEgMGg0bTEgMGgxbTIgMGgxbTIgMGgxbTQgMGgxbTUgMGgxbTEgMGgybTEgMGgxbTEgMGgxbTIgMGgxbTEgMGgxbTUgMGgxbTEgMGgxbTEgMGgzbS04OCAxaDRtMyAwaDFtMSAwaDNtMiAwaDRtMiAwaDFtMSAwaDFtMyAwaDFtMiAwaDJtNCAwaDJtMyAwaDJtMSAwaDFtNCAwaDJtMSAwaDFtMSAwaDNtNiAwaDFtMSAwaDFtMiAwaDFtMSAwaDFtMSAwaDFtMSAwaDJtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDJtMiAwaDFtLTg5IDFoMm0xIDBoN200IDBoM20xIDBoMW0xIDBoMTVtMSAwaDFtMSAwaDVtMSAwaDFtMSAwaDRtMiAwaDdtMSAwaDRtMiAwaDFtMSAwaDFtMSAwaDFtMyAwaDNtMiAwaDhtMSAwaDFtLTg5IDFoMm0yIDBoMW0zIDBoMW0zIDBoMm0xIDBoM20zIDBoMW0xIDBoMW0xIDBoNG0zIDBoMW0xIDBoMW02IDBoMW0yIDBoM20yIDBoM20xIDBoMm0zIDBoMm0yIDBoMW0xIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoM20xIDBoM20zIDBoMW0yIDBoMW0tODggMWgzbTEgMGgxbTEgMGgxbTEgMGgxbTMgMGgxbTQgMGgybTEgMGgxbTEgMGgybTMgMGgybTEgMGgxbTEgMGgxbTIgMGgzbTEgMGgzbTIgMGgxbTIgMGgxbTQgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTIgMGgxbTEgMGgzbTUgMGgybTEgMGgxbTEgMGgzbTEgMGgxbTEgMGgxbTEgMGgybS04NCAxaDFtMSAwaDFtMyAwaDFtMSAwaDNtMyAwaDRtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDJtMyAwaDFtMSAwaDRtMyAwaDFtMSAwaDRtMSAwaDJtMiAwaDNtMyAwaDRtNCAwaDFtMSAwaDRtNCAwaDFtMiAwaDJtMyAwaDJtLTg1IDFoMW0xIDBoN20yIDBoMW0xIDBoNG0zIDBoMm0xIDBoMm0yIDBoNW0xIDBoMW01IDBoMW01IDBoNm0xIDBoNm0xIDBoNW0xIDBoMW0yIDBoMm0xIDBoNG0xIDBoMW0xIDBoMTBtLTg5IDFoMW0yIDBoMW01IDBoMW0xIDBoMW0xMSAwaDFtMiAwaDJtMiAwaDJtMiAwaDFtMSAwaDRtMiAwaDFtMSAwaDFtMSAwaDFtMiAwaDFtMSAwaDFtMSAwaDFtMyAwaDJtNSAwaDFtMiAwaDNtNCAwaDJtMTEgMGgxbS04NyAxaDNtMSAwaDNtMyAwaDdtMiAwaDFtMyAwaDJtMyAwaDNtMSAwaDFtMiAwaDFtMyAwaDJtMSAwaDJtMiAwaDFtMSAwaDFtMyAwaDJtNCAwaDFtMSAwaDNtMiAwaDFtMSAwaDFtMSAwaDFtMSAwaDJtMSAwaDJtMiAwaDRtMSAwaDNtLTg3IDFoMW0xIDBoNG0yIDBoMW03IDBoM20yIDBoMW0yIDBoMW0xIDBoMW03IDBoMW0yIDBoMm0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoMW0yIDBoMW0xIDBoMW0yIDBoMW0yIDBoMm02IDBoM20xIDBoMW0yIDBoMW0yIDBoM20xIDBoMW0xIDBoMW0zIDBoMm0tODggMWgybTEgMGgxbTEgMGg2bTEgMGgxbTUgMGgybTIgMGgybTIgMGgxbTEgMGgybTQgMGgxbTIgMGgybTIgMGgybTIgMGgxbTIgMGgybTEgMGgybTIgMGgybTMgMGg1bTIgMGgybTIgMGgxbTIgMGgxbTEgMGgxbTQgMGgxbTEgMGgzbS04NyAxaDFtMiAwaDFtMSAwaDFtMSAwaDFtMiAwaDFtMSAwaDFtMSAwaDJtMSAwaDFtMiAwaDJtMSAwaDFtMyAwaDFtMiAwaDFtMSAwaDFtMSAwaDNtMyAwaDFtMiAwaDJtMyAwaDNtMyAwaDJtMSAwaDFtMiAwaDFtMSAwaDJtNCAwaDRtMiAwaDFtNCAwaDFtMSAwaDFtMiAwaDJtMSAwaDFtLTg2IDFoMW0zIDBoMW0yIDBoNm0xIDBoMm0xIDBoM20yIDBoMm0xIDBoNG0xIDBoMW00IDBoMW0xIDBoNW0zIDBoM20yIDBoNG0xIDBoMm0xIDBoNG0xIDBoMW01IDBoN20xIDBoM20yIDBoMW0tODMgMWgxbTEgMGgybTEgMGgxbTEgMGgybTEgMGgxbTEgMGgxbTQgMGgxbTIgMGg0bTIgMGgzbTEgMGgybTEgMGgxbTEgMGgzbTEgMGgxbTIgMGgzbTEgMGgxbTIgMGgxbTMgMGgybTIgMGgxbTMgMGgybTIgMGg2bTQgMGgxbTMgMGgxbTEgMGgxbTMgMGgybS04NyAxaDFtMyAwaDRtMiAwaDJtMSAwaDFtMSAwaDFtMSAwaDFtMiAwaDFtMiAwaDFtMSAwaDVtMyAwaDFtMyAwaDFtMSAwaDFtMSAwaDJtMSAwaDFtMSAwaDRtMSAwaDFtMiAwaDNtMSAwaDFtMSAwaDNtMyAwaDFtMyAwaDRtNiAwaDVtLTg2IDFoMW0xIDBoMW0xIDBoMW0zIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoM20xIDBoMW0xIDBoM20yIDBoM20xIDBoMW0xIDBoNW0zIDBoMW0xIDBoMm0yIDBoMm00IDBoMW01IDBoMm01IDBoMW0xIDBoMm0yIDBoMW00IDBoNG0xIDBoMW0yIDBoMW0tODcgMWgxbTIgMGgybTQgMGgxbTUgMGgxbTEgMGg0bTIgMGgybTMgMGgzbTEgMGgxbTIgMGgxbTEgMGg3bTkgMGg0bTIgMGgzbTEgMGgxbTMgMGgxbTEgMGgxbTEgMGgxbTEgMGg0bTEgMGgybTIgMGgxbTEgMGgybS04OCAxaDFtMiAwaDJtMiAwaDFtMyAwaDNtNyAwaDFtMSAwaDNtMSAwaDNtMSAwaDNtMSAwaDJtMSAwaDFtMSAwaDJtMSAwaDFtMiAwaDVtMSAwaDNtMiAwaDFtMSAwaDJtMSAwaDFtMSAwaDJtMSAwaDJtMiAwaDJtMSAwaDFtNCAwaDFtNSAwaDFtMSAwaDFtLTg4IDFoMW0yIDBoMm0xIDBoMm0zIDBoMW0yIDBoMm00IDBoNW0yIDBoMW0zIDBoMW0yIDBoM20xIDBoMm0yIDBoM201IDBoMW0zIDBoNW0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoMW0xIDBoMW0xIDBoNW0xIDBoMm0yIDBoMW0xIDBoMW0xIDBoM20tODkgMWgxbTEgMGgxbTEgMGgybTEgMGgxbTEgMGgzbTEgMGgxbTMgMGgxbTMgMGgybTEgMGgybTEgMGgxbTIgMGgybTIgMGg0bTEgMGgxbTEgMGgxbTEgMGgxbTMgMGgybTIgMGgybTIgMGgzbTYgMGgxbTEgMGg2bTExIDBoMm0yIDBoMW0tODUgMWg5bTEgMGgxbTEgMGgxbTQgMGgxbTUgMGgybTEgMGgybTEgMGgxbTIgMGgxbTIgMGgzbTQgMGgybTEgMGgxbTQgMGgybTIgMGgxbTQgMGgybTEgMGgxbTIgMGgxbTQgMGgxbTEgMGgxbTEgMGg0bTMgMGgxbTEgMGgxbS04NCAxaDNtMSAwaDFtMSAwaDNtNCAwaDNtMiAwaDFtMiAwaDFtMyAwaDFtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDJtMSAwaDJtNCAwaDJtNCAwaDNtMyAwaDFtMSAwaDNtMiAwaDFtMSAwaDRtMSAwaDJtMSAwaDFtMSAwaDJtLTc4IDFoM20yIDBoMm00IDBoMW0xIDBoMm0zIDBoMW0xIDBoMW0xIDBoMW01IDBoMm0yIDBoNW0yIDBoMW0xIDBoMW0zIDBoM20xIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0zIDBoMW0xIDBoNW0xIDBoMm0yIDBoMW0xIDBoM20xIDBoMW0xIDBoMW0xIDBoMW0xIDBoM20xIDBoMW0tODkgMWgybTEgMGgxbTYgMGgxbTUgMGgxbTUgMGg1bTEgMGg4bTEgMGg0bTQgMGg0bTIgMGgxbTEgMGgxbTEgMGgxbTMgMGgybTEgMGgybTIgMGg1bTMgMGgybTMgMGgxbTIgMGgxbTIgMGgxbTEgMGgybS04NiAxaDFtMSAwaDRtNCAwaDJtMSAwaDFtMiAwaDFtNCAwaDFtMTIgMGgzbTEgMGg0bTYgMGgzbTIgMGgxbTUgMGgybTEgMGgxbTEgMGgxbTIgMGgxbTIgMGg2bTEgMGgxbTEgMGgzbS04NSAxaDFtNiAwaDJtMSAwaDFtMSAwaDJtMyAwaDFtMiAwaDJtMSAwaDFtMiAwaDZtMiAwaDFtMSAwaDJtMSAwaDJtMiAwaDFtMiAwaDVtMSAwaDRtMSAwaDFtMSAwaDJtNyAwaDFtMiAwaDJtNiAwaDFtMyAwaDFtMyAwaDJtLTg5IDFoM20xIDBoMW0xIDBoM20yIDBoMm0xIDBoMW0xIDBoMW0xIDBoM20yIDBoMW03IDBoMW0xIDBoMW0xIDBoNG0xIDBoM20yIDBoMW0zIDBoMW0xIDBoMm00IDBoMW00IDBoMm0yIDBoMm0xIDBoMm0xIDBoMm0xIDBoM20xIDBoMW0yIDBoNW0tODcgMWgxbTEgMGgybTMgMGgxbTEgMGgzbTEgMGgybTIgMGgzbTEgMGgxbTUgMGgzbTEgMGgxbTEgMGgxbTIgMGgxbTEgMGg0bTEgMGgxbTMgMGgxbTIgMGgxbTIgMGgxbTEgMGgxbTEgMGgybTEgMGgxbTEgMGgxbTQgMGg0bTEgMGgxbTEgMGgybTIgMGgybTMgMGgxbTIgMGgxbTEgMGgxbS04OCAxaDFtMiAwaDVtMiAwaDFtNCAwaDNtMiAwaDNtMSAwaDJtMSAwaDZtMSAwaDNtMiAwaDJtMSAwaDJtMSAwaDFtMSAwaDNtMiAwaDZtMSAwaDFtMSAwaDNtMiAwaDJtMSAwaDRtMSAwaDFtMSAwaDhtMSAwaDJtLTg4IDFoMW0xIDBoM20zIDBoMW0xIDBoMW0xIDBoMm00IDBoMm03IDBoMm0zIDBoMW0xIDBoM20zIDBoNG0xIDBoM20yIDBoM20xIDBoMW0zIDBoMW0yIDBoMW0yIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoM20yIDBoMm0zIDBoMm0tODYgMWgybTEgMGgybTEgMGgxbTEgMGgzbTEgMGgzbTEgMGgybTEgMGgxbTIgMGgxbTMgMGgxbTEgMGgxbTEgMGgxbTEgMGg1bTEgMGgybTIgMGg0bTQgMGgybTIgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTIgMGgzbTIgMGgxbTYgMGgybTMgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbS04OCAxaDJtMSAwaDFtMyAwaDNtMiAwaDFtMSAwaDNtNSAwaDRtMSAwaDFtMyAwaDFtMSAwaDJtMiAwaDJtMiAwaDFtMiAwaDFtMSAwaDFtNSAwaDJtMyAwaDJtMiAwaDFtMSAwaDFtMSAwaDFtMSAwaDVtMSAwaDFtMSAwaDFtMyAwaDFtMyAwaDFtMiAwaDJtLTg5IDFoOW0xIDBoMm0xIDBoMm00IDBoMW0xIDBoMW0xIDBoMW0xIDBoMm0xIDBoNW0yIDBoMW0yIDBoNG0xIDBoMW0yIDBoMW0yIDBoMW0xIDBoOG0xIDBoNG00IDBoMW0xIDBoMW0xIDBoN20xIDBoNW0xIDBoMm0tODYgMWgxbTEgMGgybTQgMGgzbTIgMGgzbTEgMGgxbTIgMGgxbTEgMGgxbTEgMGgxbTEgMGgzbTEgMGgxbTEgMGgybTEgMGgxbTEgMGgybTEgMGgybTEgMGgybTEgMGgzbTEgMGgxbTMgMGg2bTEgMGgybTEgMGgybTIgMGgybTQgMGgxbTIgMGgxbTQgMGgybS04NiAxaDJtMyAwaDNtMSAwaDJtMSAwaDFtNSAwaDFtMyAwaDNtMSAwaDFtMiAwaDJtNiAwaDFtMSAwaDFtMSAwaDFtMSAwaDFtMiAwaDJtMSAwaDJtMSAwaDFtMiAwaDNtNyAwaDJtMiAwaDJtMSAwaDJtMSAwaDFtNyAwaDFtLTg0IDFoMW0xIDBoMm0xIDBoMW0yIDBoMW00IDBoMW00IDBoMW0xIDBoMW0xIDBoNG0xIDBoMW0xIDBoMW0xIDBoMW0zIDBoMm0zIDBoMW0zIDBoMW0xIDBoM20xIDBoMW0zIDBoMW01IDBoMW0zIDBoMW0xIDBoMm0xIDBoNG0xIDBoMW0xIDBoMW0xIDBoM20xIDBoNW0xIDBoMW0tODkgMWgybTEgMGg0bTIgMGgybTEgMGg2bTEgMGgybTEgMGgxbTEgMGgybTEgMGgybTEgMGgybTEgMGgxbTEgMGgxbTIgMGgxbTIgMGgxbTQgMGgybTEgMGgybTMgMGgxbTMgMGgybTEgMGgybTIgMGgybTEgMGgxbTQgMGgybTEgMGgybTMgMGgxbTEgMGgxbTIgMGgybS04NyAxaDVtMiAwaDJtMSAwaDJtMSAwaDFtMiAwaDJtMSAwaDFtMiAwaDJtNCAwaDZtNCAwaDJtMSAwaDJtMyAwaDNtNSAwaDJtMSAwaDJtNCAwaDFtMiAwaDFtMSAwaDZtNSAwaDJtMiAwaDJtMSAwaDJtLTg4IDFoM20xIDBoNG0xIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0yIDBoMW0xIDBoMW0yIDBoMm0yIDBoMm0xIDBoMW0yIDBoMW0zIDBoMW0xIDBoM20xIDBoMW0yIDBoMm0xIDBoNW0xIDBoMW0zIDBoMW0xIDBoMm0zIDBoM200IDBoMW00IDBoMW00IDBoMW0tODYgMWg0bTEgMGgxbTEgMGgxbTEgMGgxbTIgMGgybTEgMGgxbTIgMGgzbTEgMGg3bTEgMGgzbTEgMGgzbTEgMGg2bTUgMGgybTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgxbTQgMGgxbTQgMGgybTEgMGgybTEgMGgybTIgMGgzbTEgMGgxbTEgMGgybTEgMGgxbS04MyAxaDJtMyAwaDFtMiAwaDNtMiAwaDFtMyAwaDFtMyAwaDJtMSAwaDFtMSAwaDFtMSAwaDNtMSAwaDFtMSAwaDNtMiAwaDFtMiAwaDFtMSAwaDJtMiAwaDFtMiAwaDNtMSAwaDJtMSAwaDRtNiAwaDFtMSAwaDNtNCAwaDNtMSAwaDFtLTg2IDFoMm0xIDBoMW0yIDBoMW0xIDBoMm0xIDBoMm0xIDBoMW00IDBoMW0yIDBoMm0yIDBoMW0xIDBoMW0xIDBoMW0yIDBoMm0zIDBoMW0xIDBoNG0yIDBoMW0yIDBoMm0xIDBoMW0xIDBoMm00IDBoMm0yIDBoN20xIDBoMW0yIDBoMW0xIDBoMW00IDBoMW00IDBoMW0tODkgMWgybTEgMGgxbTEgMGgzbTIgMGgxbTQgMGgzbTYgMGgxbTEgMGgybTEgMGgybTIgMGgybTMgMGgxbTEgMGgybTEgMGgybTMgMGg0bTEgMGgxbTEgMGgxbTIgMGg2bTEgMGgxbTIgMGgzbTEgMGg1bTMgMGgybTMgMGgzbS04NCAxaDFtMyAwaDNtMyAwaDFtMSAwaDJtMSAwaDFtMSAwaDFtMSAwaDJtMiAwaDFtMSAwaDFtMSAwaDNtNCAwaDFtMSAwaDFtMyAwaDFtNSAwaDFtMSAwaDNtMSAwaDJtMSAwaDFtMyAwaDFtMyAwaDFtMSAwaDJtMSAwaDFtMSAwaDNtMyAwaDFtMSAwaDdtLTg2IDFoMW0yIDBoMm0xIDBoMW0zIDBoMm0xIDBoMW0xIDBoOG0xIDBoMm0xIDBoMm00IDBoMm0xIDBoMW0yIDBoM20zIDBoMm0zIDBoMm0xIDBoMW0xIDBoMm0xIDBoMm0xIDBoMm03IDBoM20xIDBoMW00IDBoNG0tODYgMWgzbTUgMGgybTIgMGgzbTIgMGgxbTEgMGgzbTEgMGgxbTEgMGgxbTEgMGgxbTIgMGgybTUgMGgxbTEgMGgzbTIgMGg3bTIgMGgxbTIgMGgybTEgMGgzbTQgMGgxbTEgMGgzbTQgMGgybTEgMGgxbTEgMGgxbTIgMGgzbTEgMGgybS04OCAxaDRtMSAwaDJtMSAwaDFtMyAwaDNtMiAwaDFtMyAwaDJtMSAwaDFtNCAwaDFtMSAwaDNtMiAwaDFtMSAwaDZtMiAwaDNtMSAwaDZtMyAwaDFtMiAwaDNtMiAwaDNtNCAwaDFtMSAwaDFtMiAwaDJtMyAwaDJtMSAwaDFtLTgwIDFoMW0xIDBoMm0xIDBoMW0yIDBoNG0yIDBoMW0yIDBoMW0yIDBoMW0xIDBoMm0xIDBoMW0xIDBoMW0zIDBoMW0yIDBoMW0xIDBoMW00IDBoMW0xIDBoM20xIDBoMW02IDBoMm0xIDBoNW0xIDBoMW0xIDBoMW0zIDBoMW0xIDBoMW0xIDBoM20tODIgMWgxbTIgMGgxbTUgMGgzbTEgMGgxbTIgMGg2bTEgMGg4bTEgMGgybTEgMGgxbTEgMGgxbTEgMGgxbTIgMGgybTIgMGgxbTEgMGgybTEgMGg0bTQgMGg0bTcgMGgxbTIgMGgybTMgMGgxbTIgMGgxbS04NSAxaDNtMSAwaDFtMiAwaDJtMSAwaDFtMyAwaDRtMSAwaDFtMSAwaDJtMSAwaDJtMSAwaDFtMyAwaDFtMSAwaDNtMSAwaDFtNCAwaDJtMSAwaDJtMSAwaDJtMiAwaDJtMSAwaDFtMiAwaDVtMyAwaDNtMSAwaDJtMyAwaDRtMiAwaDFtMiAwaDJtMSAwaDJtLTg5IDFoMW0xIDBoMm0xIDBoMm0xIDBoMW0xIDBoMW0xIDBoMm0xIDBoMm0xIDBoMm0yIDBoMW0xIDBoM20zIDBoMW0xIDBoMm0xIDBoNG0zIDBoMm01IDBoMm00IDBoMm0zIDBoMm0xIDBoMm0xIDBoMW0zIDBoMW00IDBoMW0xIDBoMW0yIDBoMW0yIDBoMW0zIDBoMW0tODggMWgxbTMgMGgybTIgMGgxbTEgMGgzbTQgMGgxbTEgMGgybTIgMGgzbTEgMGgxbTEgMGgxbTMgMGgxbTYgMGgxbTEgMGgxbTEgMGgxbTMgMGgxbTEgMGgxbTIgMGg1bTIgMGgxbTIgMGgybTIgMGg0bTQgMGgxbTQgMGgzbTEgMGgxbTIgMGgybS04OSAxaDFtMiAwaDFtMiAwaDFtMSAwaDFtMSAwaDJtNSAwaDFtMiAwaDFtMiAwaDJtMSAwaDFtMiAwaDFtMyAwaDFtNiAwaDFtMSAwaDJtMiAwaDFtMSAwaDNtMSAwaDFtNCAwaDNtMiAwaDJtMSAwaDNtMyAwaDNtMSAwaDFtMSAwaDFtMyAwaDFtMSAwaDNtLTg2IDFoMm0yIDBoMm0zIDBoMW0yIDBoMW0yIDBoMm0yIDBoNG0xIDBoM20xIDBoMW0xIDBoMW0xIDBoM20xIDBoMW0xIDBoMW04IDBoM200IDBoMW0yIDBoMW0xIDBoM20xIDBoMm0zIDBoM20zIDBoMW0xIDBoMW0xIDBoMW0xIDBoNm0yIDBoMW0tODkgMWgxbTIgMGgxbTIgMGgzbTMgMGgxbTMgMGgxbTEgMGgxbTEgMGgxbTIgMGgybTEgMGgxbTEgMGg1bTEgMGgxbTEgMGgxbTEgMGgxbTEgMGgybTIgMGgxbTIgMGgxbTUgMGg2bTEgMGgybTEgMGgxbTQgMGgybTIgMGgxbTIgMGgxbTEgMGgybTEgMGg4bS04MCAxaDFtMSAwaDJtMSAwaDFtMSAwaDZtMiAwaDFtMiAwaDFtMSAwaDFtMyAwaDJtMiAwaDFtMiAwaDVtMyAwaDFtMSAwaDJtMSAwaDFtMSAwaDFtMyAwaDJtMyAwaDJtMiAwaDFtMSAwaDRtMSAwaDFtMSAwaDFtMSAwaDFtMSAwaDFtMyAwaDFtMyAwaDFtLTg5IDFoN20yIDBoMW0yIDBoMm0yIDBoMW0yIDBoMW0yIDBoMW0yIDBoMm0xIDBoMW0xIDBoMW0xIDBoMW0xIDBoMm0yIDBoMW0yIDBoMW0xIDBoNG0xIDBoMm0xIDBoNG0xIDBoMW0xIDBoMW0xIDBoMW0xIDBoM20yIDBoMm0yIDBoMW0xIDBoMW0xIDBoNG0xIDBoMW0xIDBoMW0xIDBoMW0xIDBoMW0tODcgMWgxbTUgMGgxbTUgMGgzbTIgMGgybTEgMGgybTMgMGgybTEgMGgxbTMgMGgybTEgMGgxbTUgMGgxbTIgMGgxbTIgMGgxbTYgMGgxbTMgMGgybTEgMGgxbTIgMGgybTEgMGgxbTMgMGgxbTIgMGgxbTQgMGgybTMgMGgxbTIgMGgybS04OSAxaDFtMSAwaDNtMSAwaDFtMSAwaDNtMSAwaDJtMSAwaDFtMiAwaDFtMyAwaDNtMyAwaDZtMSAwaDFtMSAwaDJtNyAwaDFtMiAwaDFtMSAwaDhtMiAwaDVtMiAwaDNtMiAwaDFtMSAwaDNtMiAwaDdtMSAwaDFtLTg5IDFoMW0xIDBoM20xIDBoMW0xIDBoMW0yIDBoMW0xIDBoMW0zIDBoMW01IDBoMW0yIDBoMW0xIDBoMm0yIDBoMW01IDBoNm00IDBoMm01IDBoMW0xIDBoMW0yIDBoMW0yIDBoMW0yIDBoMW0yIDBoMm00IDBoMW0yIDBoMm0xIDBoMW01IDBoMW0tODggMWgxbTEgMGgzbTEgMGgxbTEgMGgxbTEgMGgxbTMgMGgzbTEgMGgxbTEgMGgxbTUgMGgxbTEgMGgzbTEgMGg1bTIgMGgxbTUgMGgybTIgMGgxbTEgMGgybTIgMGgxbTEgMGgybTEgMGgxbTEgMGgybTEgMGgxbTIgMGgxbTEgMGgxbTIgMGgxbTEgMGgybTIgMGgxbTIgMGg0bTEgMGgxbS04OCAxaDFtNSAwaDFtMyAwaDFtMiAwaDFtMSAwaDFtMiAwaDJtMSAwaDJtMiAwaDFtMiAwaDFtNSAwaDFtOCAwaDNtMSAwaDJtMiAwaDFtMSAwaDJtMiAwaDVtMSAwaDRtMSAwaDFtMSAwaDNtMSAwaDFtMiAwaDRtMiAwaDJtMiAwaDFtLTg4IDFoN200IDBoMm0yIDBoMm0xIDBoM20zIDBoMW0yIDBoM20yIDBoM20zIDBoMm0zIDBoMm01IDBoMW0zIDBoMW0yIDBoMW00IDBoM20xIDBoMW0xIDBoM20xIDBoMm0xIDBoMm01IDBoMW0xIDBoMyIvPjwvc3ZnPgo= Estou com esta imagem porem da erro na conversão em delphi. function Base64ToImage(const base64String: string): TBitmap; var Input: TStringStream; Output: TBytesStream; begin Result := TBitmap.Create; if Length(base64String) = 0 then Exit; Input := TStringStream.Create(base64String); Output := TBytesStream.Create; try Input.Position := 0; TNetEncoding.Base64.Decode(Input, Output); Output.Position := 0; Result.LoadFromStream(Output); finally Input.Free; Output.Free; end; end; Queria jogar ele no TRLImage do fortes. Ou seila em um TIMage mas ambos da erro Da erro Bitmapt is not valid mas ja alterei para PNGIMage e nada Estou usando o dephi xe7
-
Agora vou deitar pq briguei demais com isto hj kkk function HttpPostGetJSON(const URL: string; var JSON: String;const TimeOut: integer = 5000): Boolean; const CRLF : UTF8String = #13#10; var HTTP : THTTPSend; Data : TStringStream; begin HTTP := THTTPSend.Create; Data := TStringStream.Create(UTF8Encode(JSON), TEncoding.UTF8); JSON := ''; HTTP.Timeout := TimeOut; try HTTP.Headers.Add('Content-Type: application/json') ; HTTP.Headers.Add('x-api-key: ?????????????????????????????????????????') ; HTTP.MimeType := 'application/json'; Data.Position := 0; HTTP.Document.CopyFrom( Data, 0); Data.Size := 0; Result := HTTP.HTTPMethod('POST', URL); if Result then begin if HTTP.Document.Size > 0 then begin Data.LoadFromStream( HTTP.Document ); JSON := Data.DataString + CRLF + 'Result=' + HTTP.ResultString + CRLF+ 'Protocol='+HTTP.Protocol ; end; end else begin ShowMessage(HTTP.ResultCode.ToString) end; finally HTTP.Free; Data.Free; end; end; Da o mesmo 500 como retorno.
-
function Enviar(const pMetodo, pURL, pDadosEnvio: string; var pRetorno: TRetRequisicao): Boolean; var synHttp: THTTPSend; mstr: TMemoryStream; stmResp, stmDados: TStringStream; vs: RawByteString; tmp: string; LHeaders: TStringList; requestBody: TStringStream; begin synHttp := THTTPSend.Create; mstr := TMemoryStream.Create; LHeaders := TStringList.Create; LHeaders.Add('Content-Type: application/json'); LHeaders.Add('x-api-key: minhakey'); try vs := UTF8Encode(pDadosEnvio); //FH.StrParaStream(synHttp.Document, vs); ????? synHttp.MimeType := 'application/json'; //Tentei colocar no synHttp.Document mas nem sei se isto esta certo. requestBody := TStringStream.Create(vs); synHttp.Document.Position := 0 ; synHttp.Document.LoadFromStream(requestBody); for tmp in LHeaders do synHttp.Headers.Add(tmp); Result := synHttp.HTTPMethod(pMetodo, pURL); if Result then begin mstr.CopyFrom(synHttp.Document, 0); pRetorno.StatusCode := inttostr(synHttp.ResultCode); // pRetorno.Response := FH.AjustaChrEspecial(FH.MemoryStreamParaString(mstr), True); ??????????????? end else begin pRetorno.StatusCode := inttostr(synHttp.ResultCode); // pRetorno.Response := FH.SeStrVazia(synHttp.Sock.LastErrorDesc, synHttp.ResultString); ??????????????? end; finally synHttp.Free; mstr.Free; LHeaders.Free; end; end; Detalhe coloquei o type type TRetRequisicao = record StatusCode: String; Response: String; end; Retorna 500 de toda forma
-
Requisicao rest idhttp SSL3_GET_RECORD:wrong version number
um tópico no fórum postou johnbh3 Object Pascal - Delphi & Lazarus
function EnviarRequisicaoHTTP: string; var IdHTTP: TIdHTTP; SSLIOHandler: TIdSSLIOHandlerSocketOpenSSL; RequestBody: TStringStream; begin Result := ''; IdHTTP := TIdHTTP.Create(nil); SSLIOHandler := TIdSSLIOHandlerSocketOpenSSL.Create(nil); RequestBody := TStringStream.Create('{"x": "2333232", "x1": "12", "dt": "xxxxx}'); try try IdHTTP.Request.ContentType := 'application/json'; IdHTTP.Request.CustomHeaders.Add('x-api-dddddsdsds'); SSLIOHandler.SSLOptions.Method := sslvTLSv1_2; IdHTTP.IOHandler := SSLIOHandler; Result := IdHTTP.Post('URL', RequestBody); except on E: Exception do Result := 'Erro ao enviar a requisição: ' + E.Message; end; finally IdHTTP.Free; SSLIOHandler.Free; RequestBody.Free; end; end; Uso delphi xe7 da erro Erro ao enviar a requisição: Error connecting with SSL. error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number Inclusive usando restDebugger do delphi Com delphi alexandria vai numa boa. -
Ola Boa noite o ACBr tem algo sobre PIX do banco inter? https://developers.inter.co/references/pix
-
Sabem o que e isso? Erro :An invalid character was found in text content Enviando a NFe em MG
-
Pessoal, Estou emitindo um cupom nem sei pode isto, mas e um NFCe no valor de 160 mil reais. Mas e pra santa catarina e lá o limite e 200 mil. Retorno: Rejeição: NFC-e com valor total superior ao permitido para destinatário não identificado (Endereço) [R$ 10.000,00] mas esta identificado o endereço with EnderDest do begin xLgr := 'RUA TESTE'; xCpl := ''; xBairro := 'NAO ESPECIFICADO'; xMun := 'EXTERIOR'; cMun := 9999999; xPais := 'PARAGUAI'; cPais := 5860; CEP := 001001; UF:= 'EX'; nro := 0 end; end;
-
Sabem se existe caso gertec gpos 800 com Delphi e pago? O acbr tem algo ? Vi no git da gertec algo sobre Delphi rio será que funciona no Alexandria Tô meio perdido por onde começar baixei o repositório do git mas fiquei na dúvida se funciona e investir neste hardware e morrer na praia
-
EXECUTE BLOCK RETURNS ( MES VARCHAR(10), TOTAL_VR_DOC NUMERIC (18,2) ) AS DECLARE VARIABLE MonthNumber INTEGER; DECLARE VARIABLE ANO INTEGER; BEGIN MonthNumber = 1; WHILE (MonthNumber <= 12) DO BEGIN MonthNumber = MonthNumber + 1; MES = MonthNumber; ANO = EXTRACT(YEAR FROM current_date); SELECT COALESCE(SUM(VR_DOC), 0) FROM CT_DUPL WHERE EXTRACT(MONTH FROM DTA_CONT) = :MonthNumber AND EXTRACT(YEAR FROM DTA_CONT) = :ANO INTO: TOTAL_VR_DOC; SUSPEND; END END fiz isso daqui nao se e e uma boa
-
Eu fiz pra teste esta procedure debugando ela faz o que quero, porem não retorna dados qdo da o suspende. Queria que retornasse o grid de dados. Seria o caso de usar o RETURNS? CREATE PROCEDURE SP1 ( START_VAL INTEGER, END_VAL INTEGER) AS-- DECLARE VARIABLE MES_I INTEGER; DECLARE VARIABLE MES_STR VARCHAR(3); BEGIN MES_I = :START_VAL; WHILE (MES_I <= :END_VAL) DO BEGIN MES_STR = CASE MES_I WHEN 1 THEN 'Jan' WHEN 2 THEN 'Fev' WHEN 3 THEN 'Mar' WHEN 4 THEN 'Abr' WHEN 5 THEN 'Mai' WHEN 6 THEN 'Jun' WHEN 7 THEN 'Jul' WHEN 8 THEN 'Ago' WHEN 9 THEN 'Set' WHEN 10 THEN 'Out' WHEN 11 THEN 'Nov' WHEN 12 THEN 'Dez' END; MES_I = MES_I + 1; SUSPEND; END END O que eu realmente queria que deu certo neste SQL, mas qual o problema uma soma por mes ocorre que de teste so tenho registro na tabela no mes 08/2023 dai so retornou um registro e quando for 0 (Zero) pra janeiro que e o caso por não haver pagamentos em CT_DUPL gera um registro Ou seja queria os 12 meses como retorno mesmo que não haja pagamentos dai vi como alternativa fazer while em procedure ou tem outra sugestão vocês? SELECT EXTRACT(MONTH FROM DTA_CONT) AS MES, EXTRACT(YEAR FROM DTA_CONT) AS ANO, SUM(VR_DOC) AS TOTAL_VR_DOC FROM CT_DUPL WHERE EXTRACT(YEAR FROM DTA_CONT) = EXTRACT(YEAR FROM CURRENT_DATE) GROUP BY EXTRACT(MONTH FROM DTA_CONT), EXTRACT(YEAR FROM DTA_CONT) ORDER BY ANO, MES;
-
function GetAccessToken: string; var IdHTTP: TIdHTTP; SSLHandler: TIdSSLIOHandlerSocketOpenSSL; Params: TStringList; AccessTokenResponse: string; begin Result := ''; IdHTTP := TIdHTTP.Create(nil); SSLHandler := TIdSSLIOHandlerSocketOpenSSL.Create(IdHTTP); Params := TStringList.Create; try // Configurando o gerenciador SSL para permitir conexões seguras (HTTPS) IdHTTP.IOHandler := SSLHandler; // Configurando a versão do protocolo SSL/TLS para TLSv1.1 SSLHandler.SSLOptions.Method := sslvTLSv1_2; // Habilitar suporte ao protocolo TLSv1.1 e TLSv1.2 SSLHandler.SSLOptions.SSLVersions := [sslvTLSv1_2]; // Configurando o cabeçalho da solicitação IdHTTP.Request.ContentType := 'application/x-www-form-urlencoded'; IdHTTP.Request.UserAgent := 'PostmanRuntime/7.32.3'; IdHTTP.Request.Accept := '*/*'; IdHTTP.Request.AcceptEncoding := 'gzip, deflate, br'; IdHTTP.Request.Connection := 'keep-alive'; // Configurando a autenticação básica (Basic Auth) IdHTTP.Request.BasicAuthentication := True; IdHTTP.Request.Username := '123'; IdHTTP.Request.Password := '123'; // Parâmetros do corpo da solicitação Params.Add('grant_type=client_credentials'); Params.Add('scope=pos.api agreements.api b2bplatform.api accounts.api wallet.api'); try // Realizando a solicitação POST com os parâmetros no corpo AccessTokenResponse := IdHTTP.Post('https://utldoparceiro', Params); // Processando a resposta... // (código de processamento da resposta permanece o mesmo) except on E: Exception do begin ShowMessage(E.Message); end; end; finally Params.Free; IdHTTP.Free; end; end; no postman retorna sem problemas no delphi Obter token de API Error connecting with SSL. error:1408F10B:SSL routines:SSL3_GET_RECORD:wrong version number