This file contains 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
-- Cria as UFs | |
SELECT | |
'var '||lower(uf_uf)||' = new UF("'||uf_uf||'");' as csharp_code | |
from cduf | |
where uf_uf != 'EX' | |
order by uf_uf; | |
-- Cria as associações entre UFs com as suas alíquotas de ICMS | |
SELECT | |
'icmsUfOrigemDestino.Add(new ICMS() { UF_IdUFOrigem = '||lower(ufo.uf_uf)||', UF_IdUFDestino = '||lower(ufd.uf_uf)||', Aliquota = '||replace(icms.icms,',','.')||'M, AliquotaICMS_FCP = '||icms_per_icms_fcp||'M });' AS csharp_code |
This file contains 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
-- Cria constantes para códigos de CST dado o imposto | |
select 'public const string '|| | |
replace( | |
replace( | |
replace( | |
replace ( | |
replace ( | |
replace( | |
replace( | |
replace(TIRA_CARACT_ESP(upper(valop.descr_op)), ' ', '_')||'_'||valor_op||' = "'||valor_op||'";', |
This file contains 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
-- Empresas que mais emitem NFS-e | |
SELECT | |
nf_ass id_assinante, | |
get_apelido_assinante(nf_ass) apelido_assinante, | |
cdempres.mnem_loc apelido_propria_empresa, | |
cdmun.mun_descr municipio, | |
cduf.uf_uf uf, | |
COUNT(*) qtd_nfs | |
FROM | |
espnf |
This file contains 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
SELECT | |
emp_ass id_assinante, | |
get_apelido_assinante(emp_ass) apelido_assinante, | |
cdempres.mnem_loc apelido_propria_empresa, | |
cduf.uf_uf uf_endereco_sede, | |
cnfvl.cnfvl_vl usa_a3, | |
( | |
SELECT | |
COUNT(*) | |
FROM |
This file contains 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
select nf_ass, get_apelido_assinante(nf_ass), cdempres.mnem_loc, cnfvl_vl, count(*) cont | |
from espnf inner join cdempres on locem = local | |
inner join cnfvl on cnfvl_emp = local and cnfvl.cnfvl_cd = 'MPD_CMPTK' | |
where nf_id_aplc_ext is not null | |
group by nf_ass, cdempres.mnem_loc, cnfvl_vl | |
order by cont desc; |
This file contains 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
/* Tela do jogo */ | |
#telaDoJogo { | |
border: 1px solid black; /* Borda preta com 1 pixel de largura. */ | |
width: 800px; /* Largura. */ | |
height: 600px; /* Altura.*/ | |
} |
This file contains 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
<canvas id="telaDoJogo"></canvas> |
This file contains 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
<!DOCTYPE html> | |
<html lang="en"> | |
<head> | |
<meta charset="UTF-8"> | |
<meta name="viewport" content="width=device-width, initial-scale=1.0"> | |
<meta http-equiv="X-UA-Compatible" content="ie=edge"> | |
<title>Quebra tijolos</title> | |
<!-- Referências aos arquivos de estilo CSS --> | |
<link rel="stylesheet" href="style.css"> |
This file contains 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
.conteudo { | |
position: fixed; | |
bottom: 0; | |
background: rgba(0, 0, 0, 0.5); | |
color: #f1f1f1; | |
width: 100%; | |
padding: 20px; | |
} | |
#meuBotao { |
This file contains 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
<div class="conteudo"> | |
<h1>Morning Coffee</h1> | |
<p> | |
O café é uma bebida produzida a partir dos grãos torrados do fruto do | |
cafeeiro. | |
</p> | |
<p> | |
É servido tradicionalmente quente, mas também pode ser consumido gelado. | |
O café é um estimulante, por possuir cafeína — geralmente 80 a 140 mg | |
para cada 207 ml dependendo do método de preparação. |