Páginas filhas
  • Chave - Integração TOP x Protheus - Mensagem Única

Versões comparadas

Chave

  • Esta linha foi adicionada.
  • Esta linha foi removida.
  • A formatação mudou.
ClienteColigadaCNPJChave GeradaData LiberaçãoAprovadoresSCRIPT
GJP ADMINISTRADORA DE HOTEIS118.419.447/0001-653aa4dbccaf4e37b1a4c718e66753243702/12/2016Elisangela Mara de Moraes; Alaim Porto AlvarengaINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '3aa4dbccaf4e37b1a4c718e667532437')
TRIVALE ADMINISTRAÇÃO LTDA153.113.791/0001-22a1129ccb2c3f71dc08c9fdcd9c56e0c320/12/2016Alaim Porto Alvarenga

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'a1129ccb2c3f71dc08c9fdcd9c56e0c3')

TALISMA CONSTRUTORA E INCORPORADORA LTDA102.582.819/0001-30e328a6551e5a74f72299a3a665ca7a5010/02/2017Elisangela e AlaimINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'e328a6551e5a74f72299a3a665ca7a50')

CCN Automação

 


105.114.066/0001-26
d9eba898e194b29995eae10fa24b6847
f48251122e785793042d06d43b7daa4507/07/2017ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '
d9eba898e194b29995eae10fa24b6847
f48251122e785793042d06d43b7daa45')
CASITAS
MAC Engenharia Ltda
     
180083454/0005-36887cc2f0abcaecc0df47a7b880a9f0f202/06/2017ElisangelaINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '887cc2f0abcaecc0df47a7b880a9f0f2')
 
EXEMPLO/VAZIA1

21.867.387/0001-

58

 

   

58





INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR)

VALUES 

(1,'CHAVEPACOTEMU_1002','af660f55bdd5a5e30b855463394656ac')

CASITAS1

DDV120813JN5 

21.867.387/0001-58


24/07/2017Armando

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'a243f19247b91ae2f989979a1a3972e4')

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'af660f55bdd5a5e30b855463394656ac')

IGREJA PENTECOSTAL DEUS E AMOR143.208.040/0001-36d76b3e32e6e067cb2d38d413a17b23d418/08/2017ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'd76b3e32e6e067cb2d38d413a17b23d4')
TECMON
1 TECMON MONTAGENS TECNICAS INDUSTRIAIS  01.848.287/0001-77a70bf7dce86509edf0b1b76374f4b64531/10/2017Armando/ClaudiaINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'a70bf7dce86509edf0b1b76374f4b645')

DALLAS RENT A CAR - TICKET 2148247


1EMPRESA: RIO ALTO PARTICIPAÇÕES E EMPREENDIMENTOS IMOBILIARIOS S.A 
CNPJ: 14.590.454/0001-74
fd3637e17eca2db98d2067bff650ab8101/02/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'fd3637e17eca2db98d2067bff650ab81')
CASAS BAHIA159.291.534/0001-671fd0f776aa600af79eea2dbf9adec94d01/02/2018Armando

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '1fd0f776aa600af79eea2dbf9adec94d')

PONTO FORTE101.958.324/0001-08e2785fd46513836c9922f5386b31a18107/02/2018Armando

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'e2785fd46513836c9922f5386b31a181')

RPS ENGENHARIA 100.761.290/0001-96d0f9633616c4222dcaf8c51b8b14049a

02/04/2018

ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'd0f9633616c4222dcaf8c51b8b14049a')
ANPLA SERVE 104.246.346/0001-25bd2ea3bdd77867a1ef68b86ef8dd953d08/06/2018AArmando

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'bd2ea3bdd77867a1ef68b86ef8dd953d')

IACI1IPP-170808-4F0e2e57314e31c5532417eda197082802404/10/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'e2e57314e31c5532417eda1970828024')
RODOVIARIO LIDER SA119.662.576/0001-42d89c21d21893e013432679713e19b88012/11/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'd89c21d21893e013432679713e19b880')
SETTA ENGENHARIA LTDA107.907.178/0001-60da62338b832460b917c905547c93b36304/12/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'da62338b832460b917c905547c93b363')
PROGINOX PROYECTOS GASTRONÓMICOS SA DE CV 1PPG-130815-CZA 31092c0692a94b928fbad419773965e817/12/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '31092c0692a94b928fbad419773965e8')
EMPRESA CONSTRUCTORA DE CIUDADES INTELIGENTES SRL 1303396021683fad08e6c558544efe12ca93b5373117/12/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '683fad08e6c558544efe12ca93b53731')
PARANA IMOBILIARIA.110.629.636/0001-5099fff910e49f372c9b054843c06eb91a27/12/2018ArmandoINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '99fff910e49f372c9b054843c06eb91a')
ENGETEC CONSTRUCOES E MONTAGENS S/A103.852.459/0001-017e98ba73ac0a5b1bc664d1487457e75528/02/2019CláudiaINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '7e98ba73ac0a5b1bc664d1487457e755')
COMPASA101.382.022-0001/26a826633ef4f81f364e82ae2c3e957c6e02/05/2019

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', 'a826633ef4f81f364e82ae2c3e957c6e')

AUTTOM AUTOMAÇÃO E ROBÓTICA102.103.027/0001-355bfc36ea39e6e55ea7136c16c6b6dd4826/08/2020DouglasINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '5bfc36ea39e6e55ea7136c16c6b6dd48')
AUTOMASUL103.808.452/0001-9270e2ec6123f3d0dfe066860791e43895

 

AlexandreINSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002', '70e2ec6123f3d0dfe066860791e43895')
GRUPO AGIS 161.099.826/0001-44

05539c9eedf3a1957cfab9ab311a67d4

 

Alexandre

INSERTINTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES (1,'CHAVEPACOTEMU_1002','05539c9eedf3a1957cfab9ab311a67d4');


SCRIPT LIBERAR O EAI 2.0 (DISPONIVEL A PARTIR DA 12.1.19 e na 12.1.17)


INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR,VALORINT,VALOR)

VALUES (0,'LIBERACONVERSOREAI2','1',1,1)


Liberação da geração de Titulo Provisório:

INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR,VALORINT,VALOR)

VALUES 

VALUES (

...

0, '

...

GERATITULOPROVISORIO','

...

1'

...

,1,1)


...

 

 

 

HTML
	<script type="text/javascript">
	/*
 * A JavaScript implementation of the RSA Data Security, Inc. MD5 Message
 * Digest Algorithm, as defined in RFC 1321.
 * Copyright (C) Paul Johnston 1999 - 2000.
 * Updated by Greg Holt 2000 - 2001.
 * See http://pajhome.org.uk/site/legal.html for details.
 */
/*
 * Convert a 32-bit number to a hex string with ls-byte first
 */
var hex_chr = "0123456789abcdef";
function rhex(num)
{
  str = "";
  for(j = 0; j <= 3; j++)
    str += hex_chr.charAt((num >> (j * 8 + 4)) & 0x0F) +
           hex_chr.charAt((num >> (j * 8)) & 0x0F);
  return str;
}
/*
 * Convert a string to a sequence of 16-word blocks, stored as an array.
 * Append padding bits and the length, as described in the MD5 standard.
 */
function str2blks_MD5(str)
{
  nblk = ((str.length + 8) >> 6) + 1;
  blks = new Array(nblk * 16);
  for(i = 0; i < nblk * 16; i++) blks[i] = 0;
  for(i = 0; i < str.length; i++)
    blks[i >> 2] |= str.charCodeAt(i) << ((i % 4) * 8);
  blks[i >> 2] |= 0x80 << ((i % 4) * 8);
  blks[nblk * 16 - 2] = str.length * 8;
  return blks;
}
/*
 * Add integers, wrapping at 2^32. This uses 16-bit operations internally 
 * to work around bugs in some JS interpreters.
 */
function add(x, y)
{
  var lsw = (x & 0xFFFF) + (y & 0xFFFF);
  var msw = (x >> 16) + (y >> 16) + (lsw >> 16);
  return (msw << 16) | (lsw & 0xFFFF);
}
/*
 * Bitwise rotate a 32-bit number to the left
 */
function rol(num, cnt)
{
  return (num << cnt) | (num >>> (32 - cnt));
}
/*
 * These functions implement the basic operation for each round of the
 * algorithm.
 */
function cmn(q, a, b, x, s, t)
{
  return add(rol(add(add(a, q), add(x, t)), s), b);
}
function ff(a, b, c, d, x, s, t)
{
  return cmn((b & c) | ((~b) & d), a, b, x, s, t);
}
function gg(a, b, c, d, x, s, t)
{
  return cmn((b & d) | (c & (~d)), a, b, x, s, t);
}
function hh(a, b, c, d, x, s, t)
{
  return cmn(b ^ c ^ d, a, b, x, s, t);
}
function ii(a, b, c, d, x, s, t)
{
  return cmn(c ^ (b | (~d)), a, b, x, s, t);
}
/*
 * Take a string and return the hex representation of its MD5.
 */
function calcMD5(str)
{
  x = str2blks_MD5(str);
  a =  1732584193;
  b = -271733879;
  c = -1732584194;
  d =  271733878;
  for(i = 0; i < x.length; i += 16)
  {
    olda = a;
    oldb = b;
    oldc = c;
    oldd = d;
    a = ff(a, b, c, d, x[i+ 0], 7 , -680876936);
    d = ff(d, a, b, c, x[i+ 1], 12, -389564586);
    c = ff(c, d, a, b, x[i+ 2], 17,  606105819);
    b = ff(b, c, d, a, x[i+ 3], 22, -1044525330);
    a = ff(a, b, c, d, x[i+ 4], 7 , -176418897);
    d = ff(d, a, b, c, x[i+ 5], 12,  1200080426);
    c = ff(c, d, a, b, x[i+ 6], 17, -1473231341);
    b = ff(b, c, d, a, x[i+ 7], 22, -45705983);
    a = ff(a, b, c, d, x[i+ 8], 7 ,  1770035416);
    d = ff(d, a, b, c, x[i+ 9], 12, -1958414417);
    c = ff(c, d, a, b, x[i+10], 17, -42063);
    b = ff(b, c, d, a, x[i+11], 22, -1990404162);
    a = ff(a, b, c, d, x[i+12], 7 ,  1804603682);
    d = ff(d, a, b, c, x[i+13], 12, -40341101);
    c = ff(c, d, a, b, x[i+14], 17, -1502002290);
    b = ff(b, c, d, a, x[i+15], 22,  1236535329);    
    a = gg(a, b, c, d, x[i+ 1], 5 , -165796510);
    d = gg(d, a, b, c, x[i+ 6], 9 , -1069501632);
    c = gg(c, d, a, b, x[i+11], 14,  643717713);
    b = gg(b, c, d, a, x[i+ 0], 20, -373897302);
    a = gg(a, b, c, d, x[i+ 5], 5 , -701558691);
    d = gg(d, a, b, c, x[i+10], 9 ,  38016083);
    c = gg(c, d, a, b, x[i+15], 14, -660478335);
    b = gg(b, c, d, a, x[i+ 4], 20, -405537848);
    a = gg(a, b, c, d, x[i+ 9], 5 ,  568446438);
    d = gg(d, a, b, c, x[i+14], 9 , -1019803690);
    c = gg(c, d, a, b, x[i+ 3], 14, -187363961);
    b = gg(b, c, d, a, x[i+ 8], 20,  1163531501);
    a = gg(a, b, c, d, x[i+13], 5 , -1444681467);
    d = gg(d, a, b, c, x[i+ 2], 9 , -51403784);
    c = gg(c, d, a, b, x[i+ 7], 14,  1735328473);
    b = gg(b, c, d, a, x[i+12], 20, -1926607734);
    
    a = hh(a, b, c, d, x[i+ 5], 4 , -378558);
    d = hh(d, a, b, c, x[i+ 8], 11, -2022574463);
    c = hh(c, d, a, b, x[i+11], 16,  1839030562);
    b = hh(b, c, d, a, x[i+14], 23, -35309556);
    a = hh(a, b, c, d, x[i+ 1], 4 , -1530992060);
    d = hh(d, a, b, c, x[i+ 4], 11,  1272893353);
    c = hh(c, d, a, b, x[i+ 7], 16, -155497632);
    b = hh(b, c, d, a, x[i+10], 23, -1094730640);
    a = hh(a, b, c, d, x[i+13], 4 ,  681279174);
    d = hh(d, a, b, c, x[i+ 0], 11, -358537222);
    c = hh(c, d, a, b, x[i+ 3], 16, -722521979);
    b = hh(b, c, d, a, x[i+ 6], 23,  76029189);
    a = hh(a, b, c, d, x[i+ 9], 4 , -640364487);
    d = hh(d, a, b, c, x[i+12], 11, -421815835);
    c = hh(c, d, a, b, x[i+15], 16,  530742520);
    b = hh(b, c, d, a, x[i+ 2], 23, -995338651);
    a = ii(a, b, c, d, x[i+ 0], 6 , -198630844);
    d = ii(d, a, b, c, x[i+ 7], 10,  1126891415);
    c = ii(c, d, a, b, x[i+14], 15, -1416354905);
    b = ii(b, c, d, a, x[i+ 5], 21, -57434055);
    a = ii(a, b, c, d, x[i+12], 6 ,  1700485571);
    d = ii(d, a, b, c, x[i+ 3], 10, -1894986606);
    c = ii(c, d, a, b, x[i+10], 15, -1051523);
    b = ii(b, c, d, a, x[i+ 1], 21, -2054922799);
    a = ii(a, b, c, d, x[i+ 8], 6 ,  1873313359);
    d = ii(d, a, b, c, x[i+15], 10, -30611744);
    c = ii(c, d, a, b, x[i+ 6], 15, -1560198380);
    b = ii(b, c, d, a, x[i+13], 21,  1309151649);
    a = ii(a, b, c, d, x[i+ 4], 6 , -145523070);
    d = ii(d, a, b, c, x[i+11], 10, -1120210379);
    c = ii(c, d, a, b, x[i+ 2], 15,  718787259);
    b = ii(b, c, d, a, x[i+ 9], 21, -343485551);
    a = add(a, olda);
    b = add(b, oldb);
    c = add(c, oldc);
    d = add(d, oldd);
  }
  return rhex(a) + rhex(b) + rhex(c) + rhex(d);
}
 
	
	function teste()
	{
		var coligada = document.getElementById('coligada').value;
		
		var cnpj = document.getElementById('cnpj').value;
				
		var scriptt = "INSERT INTO HCPARAMETROS (CODCOLIGADA,NOMECOLUNA,VALORSTR) VALUES ({1},'CHAVEPACOTEMU_1002', '{0}')"
		document.getElementById('resultado').value = 
			calcMD5(coligada + cnpj + '1002')
		document.getElementById('scriptparametro').value = scriptt.replace("{0}",
			 document.getElementById('resultado').value).replace("{1}",coligada);
		
	}

	</script>

<b>Liberação de Chave Integração TOP x Protheus</b>
<BR>
<BR>
Código de Coligada:
<BR>
<input type="text" name="coligada" id="coligada" size="60">
<BR>
<BR>
CNPJ:
<BR>
<input type="text" name="cnpj" id="cnpj" size="60">
<BR>
<BR>
<input type="button" value="GERAR CHAVE" onclick="teste()">
<BR>
<BR>
MD5:
<BR>
<input type="text" name="resultado" id="resultado" size="60">
<BR>
<br>
Script:
<BR>
<textarea name="scriptparametro" id="scriptparametro" cols="40" rows="5"></textarea>
<BR>

...

a6fd1bbad1c1633bad1406c6625ebb75 - Coligada 8 - Tadeu Augusto Pina

...