Skip to content

Instantly share code, notes, and snippets.

View gustavoreis's full-sized avatar

Gustavo Reis gustavoreis

View GitHub Profile
@mixin transition($elements: all, $time: 300ms, $timing-function: ease) {
-webkit-transition: $elements $time $timing-function;
-moz-transition: $elements $time $timing-function;
-ms-transition: $elements $time $timing-function;
-o-transition: $elements $time $timing-function;
transition: $elements $time $timing-function;
}
$background-color-content: #fff;
body,html{-webkit-font-smoothing:antialiased;text-rendering:optimizeSpeed}@font-face{font-family:'Helvetica Neue';src:url(../fonts/Helvetica/HelveticaNeue-Bold.woff2?312854022) format("woff2"),url(../fonts/Helvetica/HelveticaNeue-Bold.woff?879917307) format("woff"),url(../fonts/Helvetica/HelveticaNeue-Bold.ttf?259156923) format("truetype");font-weight:700;font-style:normal;font-display:swap}@font-face{font-family:'Helvetica Neue';src:url(../fonts/Helvetica/HelveticaNeue-UltraLight.woff2?30907493) format("woff2"),url(../fonts/Helvetica/HelveticaNeue-UltraLight.woff?2553453) format("woff"),url(../fonts/Helvetica/HelveticaNeue-UltraLight.ttf?287678228) format("truetype");font-weight:100;font-style:normal;font-display:swap}@font-face{font-family:'Helvetica Neue';src:url(../fonts/Helvetica/HelveticaNeue-Light.woff2?358559171) format("woff2"),url(../fonts/Helvetica/HelveticaNeue-Light.woff?307603448) format("woff"),url(../fonts/Helvetica/HelveticaNeue-Light.ttf?500977910) format("truetype");font-weight:300;font-sty
@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
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
<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">
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>
{
"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",
<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
<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>
{
"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,