Skip to content

Instantly share code, notes, and snippets.

View gustavoreis's full-sized avatar

Gustavo Reis gustavoreis

2 followers · 6 following
View GitHub Profile
@gustavoreis
gustavoreis / productUrl
Last active April 10, 2018 14:50
Function de Google Spreadsheet que permite listar URLs por SKU.
function testProductUrl() {
var host = "www.domino.com.br";
var username = "USER_API";
var password = "SENHA_API"
//productUrl('34241', host, username, password);
productUrl('17345', host, username, password);
}
function productUrl(sku, host, username, password) {
@gustavoreis
gustavoreis / gist:e3de7cba7b8e73855d41524cbf391085
Created April 19, 2018 17:40
Invisible reCAPTCHA
<script src="https://www.google.com/recaptcha/api.js" async defer></script>
<script>
var element = document.getElementById("payment_card_confirm");
element.classList.add("g-recaptcha");
element.dataset.sitekey = "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX";
element.dataset.callback = "onSubmitCaptcha";
function onSubmitCaptcha(token) {
document.getElementById("payment_form").submit();
}
@gustavoreis
gustavoreis / gist:e5642f53488fe103854996be72e6c983
Created October 10, 2018 15:06
WEB-800042
{
"cod_pedidov": "WEB-800042",
"cliente": 9902886,
"cod_endereco": 18464,
"validade": "2018-11-07",
"data_emissao": "2018-10-09",
"data_entrega": "2018-10-19",
"total": 638.0,
"v_acerto": 0.0,
"quantidade": 2,
@gustavoreis
gustavoreis / request
Created December 12, 2018 17:14
<requisicao in_schema="F">
<loginws cd_loginws="lemonbasicstrn" cd_senhaws="475869"/>
<pedido acao="inc" cd_cliente="1002" nr_pedidocliente="TESTE00001" cd_representant="100000003" cd_condpgto="2" dt_pedido="2018-09-13" pr_desconto="0" tp_situacao="4" cd_operacao="1">
<pedidoItem cd_barraprd="BOL01200201" qt_solicitada="1" vl_unitario="398.0"/>
</pedido>
</requisicao>
@gustavoreis
gustavoreis / response
Created December 12, 2018 17:15
<retorno>
<pedido ds_resposta="Erro ao executar comando! Erro: ORA-02291: restricao de integridade (PES_CLIENTE_PED_PEDIDOC) violada - chave mae nao localizada; Metodo: TcConexao; dsKey: AE2AAB2FA027AA93A949F15340DB6D83D166ED0B64FF067CD9333CC17281FB72F9051A076BF57E97A6A4A9A7BC5BD363E01625364946B9C91D5EEE72F077FE123AD74EA5B2969382A8D91A5C97A2A3BF453ACE67F50E61809094AE233956E6769EB5B45AE31C0D1A20070076E6066293D42454A5C0D82CD96CED7FF108071A74848CADCB292EC93AC83B2D3126B1CE162538C452C754909FB3BBA6BC56E27F8C9DDF60EB096881FB0B06071641CB2E2729272D57ED52DF7199EE0D6E899DA1AEB640C1ABDD1647BE5DE17EED778F91A4A2AFB7A999DE6396AF49D81A5F98E81E53AAE51969FC7D948C8F9CD21128186EF1151E669A8C96DF77F76EF066F1748E9CA8AFA68A93C451D765F91632D74C2FE97BA6538ACEDE336EAE938EF45DBDB25DFB1855D14A30352C6FA5E53A2E140C76ED5ACCCF376CAC80F96DB9ABE85CC9BBAB9897F21D16162339D2255599EA277F8380818D88899B9F81F82B68D3424043392F66BDBE978BA1CB6F89EB0D6CACBE4E2D2D2D1371E16EF87290B48CF866C1C2A89BF0110800137DFB7885FF047DF31137AFB8B14CC4A5FE0300180C74EB54CF4
@gustavoreis
gustavoreis / 00117F28E1
Created December 13, 2018 12:01
{
"EMP": "04",
"FIL": "01",
"NOMEFANTASIA": "Murilo Silva",
"RAZAOSOCIAL": "Murilo Silva",
"CPFCNPJ": "35358228829",
"ENDERECO": "Avenida Marechal Deodoro, até 99998 - lado par",
"BAIRRO": "Gonzaga",
"CIDADE": "Santos",
"ESTADO": "SP",
@gustavoreis
gustavoreis / representante
Created December 13, 2018 12:18
Requests:
<XML xsi:type='xsd:string'>
<requisicao in_schema='F'>
<loginws cd_loginws='lemonbasicstrn' cd_senhaws='475869'/>
<pessoa acao='con'>
<representante cd_pessoa='37811'/>
</pessoa>
</requisicao>
</XML>
@gustavoreis
gustavoreis / problema encoding
Created December 14, 2018 17:18
<soapenv:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:udmDados-IdmDados">
<soapenv:Header/>
<soapenv:Body>
<urn:requisicao soapenv:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<XML xsi:type="xsd:string">
<requisicao in_schema="F">
<loginws cd_loginws="lemonbasicstrn" cd_senhaws="475869"/>
<pedido acao="inc" cd_cliente="1002" cd_representant="100000003" cd_condpgto="1" dt_pedido="2018-12-14" pr_desconto="0" tp_frete="1" tp_cobranca="0" tp_situacao="1" cd_operacao="001" nr_pedidocliente="TESTE001">
@gustavoreis
gustavoreis / listar URL das imagens de produtos
Created December 17, 2018 15:10
require 'csv'
CSV.open('images.csv') do |csv|
ProductAsset.includes(:product).find_each do |asset|
csv << [
asset.product.reference,
"https://a0.vnda.com.br/#{asset.file_uid}"
]
end
end
@gustavoreis
gustavoreis / lista_tags
Created July 29, 2019 13:59
Planilha de Tags
/** * Utiliza os dados contidos na planilha com nome 'Config' para listar os produtos. * * O que a planilha 'Config' deve conter (todos na coluna B): * Célula B1: Host; * Célula B2: Api User; * Célula B3: Api key; * * Retorna as colunas com as informações do pedido nessa ordem: Referência, Nome, Tags **/ function listProducts() { var spreadsheet = SpreadsheetApp.getActive(); var sheet = spreadsheet.getSheetByName('Configs'); var host = sheet.getRange(1, 2).getValue(); var username = sheet.getRange(2, 2).getValue(); var password = sheet.getRange(3, 2).getValue(); var page = 1; var data = []; do { var resources = getProducts(host, username, password, page); page++; insertInfo(data, resources); } while (resources.length > 0); return data; }
function getProducts(host, username, password, page) { var baseUrl = 'https://' + host + '/api/v2/products'; var query = '?page=' + page; var url = baseUrl + query; return callApi(url, username, password); }
function insertInfo(data, resources) { for (var index in resources