Skip to content

Instantly share code, notes, and snippets.

View michaelmeneses's full-sized avatar

Michael Douglas Meneses de Souza michaelmeneses

8 followers · 10 following
View GitHub Profile
@michaelmeneses
michaelmeneses / usuarios-notas.sql
Created July 8, 2016 17:34
SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c.idnumber, ("u4m2_t"), ""), ("u4m1_t"), ""), ("u3m3_t"), ""), ("u3m2_t"), ""), ("u3m1_t"), ""), ("u2m3_t"), ""), ("u2m2_t"), ""), ("u2m1_t"), "") AS turma,
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c.shortname, ("TA"), ""), ("TB"), ""), ("TC"), ""), ("TD"), ""), ("TE"), ""), ("TF"), ""), ("TG"), ""), ("TH"), "") AS modulo,
u.username AS CPF,
concat(u.firstname, " ",u.lastname) AS nome,
gg.finalgrade AS notafinal
FROM
dbt_pdsead.mdl_user_enrolments ue
INNER JOIN
mdl_enrol e ON ue.enrolid = e.id
@michaelmeneses
michaelmeneses / usuarios-notas-finais.sql
Created August 4, 2016 13:28
SELECT
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c.idnumber, ("u1m2_t"), ""), ("u4m3_t"), ""), ("u4m2_t"), ""), ("u4m1_t"), ""), ("u3m3_t"), ""), ("u3m2_t"), ""), ("u3m1_t"), ""), ("u2m3_t"), ""), ("u2m2_t"), ""), ("u2m1_t"), "") AS turma,
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c.shortname, ("TA"), ""), ("TB"), ""), ("TC"), ""), ("TD"), ""), ("TE"), ""), ("TF"), ""), ("TG"), ""), ("TH"), "") AS modulo,
u.username AS CPF,
concat(u.firstname, " ",u.lastname) AS nome,
REPLACE(gg.finalgrade, ("."), ",") AS notafinal,
u.city AS cidade,
u.id,
REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(c.fullname, (" - Turma A"), ""), (" - Turma B"), ""), (" - Turma C"), ""), (" - Turma D"), ""), (" - Turma E"), ""), (" - Turma F"), ""), (" - Turma G"), ""), (" - Turma H"), "") as curso
FROM
@michaelmeneses
michaelmeneses / raspberry-open-url
Last active March 16, 2023 01:25
##################
##### MIDDAG #####
##################
# Install unclutter: sudo apt-get install unclutter
# Add in file .config/lxsession/LXDE-pi/autostart
@xset s off
@xset -dpms
@xset s noblank
@unclutter -idle 0.1
@chromium-browser --kiosk https://middag.com.br
@michaelmeneses
michaelmeneses / estados-brasileiros.json
Created December 17, 2018 18:16
{
"estados": [
{
"code": "4",
"name": "ACRE",
"cidades": [
{"value": "1", "name": "ACRELÂNDIA"},
{"value": "2", "name": "ASSIS BRASIL"},
{"value": "3", "name": "BRASILÉIA"},
{"value": "4", "name": "BUJARI"},
@michaelmeneses
michaelmeneses / cepeconline-dashboard.html
Created December 19, 2018 13:24
<section id="block_dashboard" class="row">
<div class="col-xl-3 col-md-6 col-sm-12">
<a href="/mod/page/view.php?id=139">
<div class="background color1">
<div class="icon">
<i class="fa fa-youtube-play" aria-hidden="true"></i>
</div>
<div class="caption">
<h2>Vídeo</h2>
<p>Conhecendo o novo AVA</p>
@michaelmeneses
michaelmeneses / .env
Created January 10, 2019 18:22
Enap - SecretariaVirtual
APP_ENV=local
APP_KEY=base64:mhs5ZcXOQIB8WUcCRfKoEAdBzZqhAUAoxQkcOeLLUl8=
APP_DEBUG=true
APP_LOG_LEVEL=debug
APP_URL=http://localhost:8000/
APP_TIMEZONE=America/Sao_Paulo
DB_CONNECTION=pgsql
DB_HOST=127.0.0.1
DB_PORT=5432
@michaelmeneses
michaelmeneses / move_progress.html
Last active October 22, 2019 22:40
<style type="text/css">
.path-course-view .block,
.path-course-view .course-content {
display: none;
}
.block_completion_progress .progressBarCell {
border: 0 !important;
height: 70px !important;
width: 80px !important;
@michaelmeneses
michaelmeneses / gist:b141c7ad16661c02d646588c1b777ce9
Created December 13, 2019 22:15
api_key:testWebhook
pro_cod:88414626
pro_name:Webhook
pro_email:webhook@eduzz.com
pro_document_number:99999999900
pro_value:null
trans_cod:1
trans_checkoutid:1
trans_value:19.7
trans_paid:19.7
@michaelmeneses
michaelmeneses / gist:d117774e00a6b111bdabcecc0580888d
Created December 18, 2019 20:27
<?php
/**
* Plugin Name: UniPRE
* Plugin URI: http://www.unipre.com.br/
* Description: Custom to UniPRE.
* Version: 2.5.0
* Author: Michael Meneses
* Author URI: http://www.michaelmeneses.com.br
* Requires at least: 4.4
* Tested up to: 4.7
@michaelmeneses
michaelmeneses / gist:b88a8ec84b5166c2c810aed31526c44a
Created April 6, 2020 12:49
require(['jquery'], function($) {
$('#section-0').before("<h1>Código HTML antes da tag.</h1>");
$('#section-0').prepend("<h1>Código HTML no início da tag>");
$('#section-0').append("<h1>Código HTML no final da tag>");
$('#section-0').afer("<h1>Código HTML após a tag>");
});