Michael Douglas Meneses de Souza michaelmeneses
michaelmeneses
/ usuarios-notas.sql
Created
July 8, 2016 17:34
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 | |
| 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
/ usuarios-notas-finais.sql
Created
August 4, 2016 13:28
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 | |
| 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
/ estados-brasileiros.json
Created
December 17, 2018 18:16
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
| { | |
| "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
/ cepeconline-dashboard.html
Created
December 19, 2018 13:24
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
| <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> |
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
| 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
/ move_progress.html
Last active
October 22, 2019 22:40
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
| <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
/ gist:b141c7ad16661c02d646588c1b777ce9
Created
December 13, 2019 22:15
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
| 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
/ gist:d117774e00a6b111bdabcecc0580888d
Created
December 18, 2019 20:27
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
| <?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
/ gist:b88a8ec84b5166c2c810aed31526c44a
Created
April 6, 2020 12:49
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
| 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>"); | |
| }); |
michaelmeneses
/ id_rsa.pub
Created
April 13, 2020 20:00
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
| ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAACAQC2051VF9V9FlNr8bIn9fKbtGgNKWs24L7ANCwWU/FazfDtiVFYNABPJ57sWxF4ci8DwibfJpTIjo3j6l0eHPc26J9cPGdrf7/ebSMaUiJiPydoNSFrQ+2NqMcmZ+4beasEPS+oBIrBC46VZSFNJ8G1RiJ0FXakKmp3OBWJ3L1KBoC7BKKLslRz21uV0ZdN2BLaTIRADiJEmhghf3LbDVBkppcKDf3zdOjphj7wada9DDdVh2q0F8ATqB5Dq6RScXbqBrDAgA//7+yV91iIuSiphj3C88I2yXfkYiuaFeJxP3fNQgRiFokQw/4gKKG1++GN3txb5zEXJvLrBmyvPXdcFwiQHMiSVV51mroZB9hVJ1U1AFRashbmP13uO9dNiWpFNEsB6WlD0mu6OcMMKW0B6LXDy7DRRF47wDBXQCGNG40RwRbRbOI/x0FK5z3CD+29pboS9UuXsvc0VIxYEDgJRXqCul9vZuThuJU1Al+TbMfp56m5u09MqjYQoCRHnkPQxw8L9b785iw86ji/23nVJpiuMBI1n9oXJsjpxwyXNZnUUtO+nzEhoQM/FbFCO/KUXv9tzA7XXsjNWSPjPL7stB63X+ONxgYPs3uUor3s9rH1Z0aVqyEAMO0L2W3PMVYxRoppWh4oI8hjDptL9Vvt75q+xNd4lMAHL/nScrxLXw== michael-middag |
OlderNewer