Skip to content

Instantly share code, notes, and snippets.

View woodyalan's full-sized avatar

Alan Ferreira dos Santos woodyalan

  • TOTVS
  • Campo Mourão - PR - Brasil
View GitHub Profile
[
{
"modelo": "Monza",
"marca": "Chevrolet",
"ano": 1990,
"quilometragem": 40000,
"cor": "Prata",
"valor": 8000.00,
"foto": "https://s2.glbimg.com/RXhS4869wbzUHe6wMJSun79KkOQ=/0x0:620x413/984x0/smart/filters:strip_icc()/i.s3.glbimg.com/v1/AUTH_cf9d035bf26b4646b105bd958f32089d/internal_photos/bs/2020/D/H/x6ZIJIT2KwZABkJrFyFA/2016-08-19-monza08.jpg"
},
@woodyalan
woodyalan / matriculas_pagas.sql
Created May 19, 2020 20:54
Primeiras Parcelas de Mensalidade Pagas
SELECT
MP.RA,
MP.IDHABILITACAOFILIAL,
MP.IDPERLET,
MP.CODSTATUS,
FL.DATABAIXA
FROM
vw_matricula vm
JOIN mat_curso_processo_pagamento mcpp (NOLOCK)
ON mcpp.id = vm.planoPagamentoId
<?php
require_once 'autoload.php';
$content = trim(file_get_contents("php://input"));
$decoded = json_decode($content, true);
extract($decoded);
$empresa = new \conteudoSite\Empresa();
@woodyalan
woodyalan / Dúvidas e Afirmações.txt
Last active June 24, 2019 20:22
Luis, tudo bem? Estamos alterando as consultas do Avaliah e precisamos entender alguns conceitos para termos certeza do que estamos mudando. Pode nos responder se as afirmações estão corretas e colocar resposta para as perguntas?
Consultas:
- Filtros
+ Algumas consultas possuem filtros relacionados a data de criação do registro. Podemos descartar?
- Cursos
+ Somente Graduação Presencial
- Grades
+ São todas as grades dos cursos acima?
<?php
session_start();
require_once 'autoload.php';
if ($pagina['id']) {
$paginasBloqueio = \web\PaginaBloqueio::getPaginaBloqueioByPagina($pagina['id']);
$publicoAtual = $_SESSION['interno']['publico'];
foreach ($paginasBloqueio as $paginaBloqueio) {
$bloqueiosConfiguracao = \web\ConfiguracaoBloqueio::getConfiguracaoBloqueio($publicoAtual,
@woodyalan
woodyalan / CampoEnum.js
Last active August 15, 2018 18:54
Rematrícula
const CampoEnum = {
NOME: 6,
CPF: 11,
RG: 12,
NASCIMENTO: 14,
USUARIO: 36,
RA: 30,
SEXO: 37,
PROFISSAO: 38,
NACIONALIDADE: 40,
ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQCqlQ7tLaencRZolDTQ/rGhOlKPED2zkmsZe0AtBz6U92+qxF/jZMenpj52UlL0/NlayYvCNwulMgGOzO/WajHI/xlRGu42Gq10PzTAqEL6Bvhu4l/R2HkQJc5vYO8g37TyvmzvpKtoI6XH5H5lzZ5Xdq3NpRYoaI/Dxzm1tg9mA6K1RhBtGfnaFpHQXro3WkHVHHgI8ENVuFbH9/IIzyvFdryE3Nh60Mnh0tv1xfRLxjjecozEudoXkMfguE+1/Kv0dGxDcJ6x2RCFn1i+zQMkxeIiCON25ZnIX59vixI5dZHIoogoo17wRvl8W/1182JlBPY+AtcaHftLWsV51FNz890C21qJXwKAQz0JcVIZqMDhVLgxOb9BmIc6gv6xLB42ZAnNF0KDVD1bnbKazrkohRk0jjFWwG5489ZnCqHWc/qzETURm7Z3xIKJiAfdgwoXo2yTHnfqA8v9SLFVjpztMvncu1arStZdF3CiwPT7EHIB88oLRwzJjjGxtqNAVxFksVHQ7ZiP0YRkX2Vn1yZDwxsGuB4mcNrQauLUO57oEtKyeTnF+wmUTjidR10lbgcVix3n2iYsVDArfH34FqzfNPotbXDH5C4DGS1h+wVpUUJLDjjXhWTStxtY6JuOnGa9iZb2mRgEbkpiIw0pDFph1Q0H8gjd6XcTGe8/9DC+pQ== alan.afs89@gmail.com
C:\Users\i8761\Projects\nodejs\webadmin-api\routes\processoSeletivo.js:8
router.post('/contatoProcesso', async (req,res,next) => {
^
SyntaxError: Unexpected token (
at createScript (vm.js:56:10)
at Object.runInThisContext (vm.js:97:10)
at Module._compile (module.js:542:28)
at Object.Module._extensions..js (module.js:579:10)
at Module.load (module.js:487:32)
$('#dataAula').datepicker({
maxDate: "0",
onSelect: function() {
loadAulas();
}
});
SELECT
CONVERT(DATE, DATA)
FROM
(
SELECT
DATA = DATEADD(DAY, rn - 1, '2016-07-25')
FROM
(
SELECT
TOP (DATEDIFF(DAY, '2016-07-25', DATEADD(DAY, (