Skip to content

Instantly share code, notes, and snippets.

View viniciusmelocodes's full-sized avatar
:octocat:
Serving customers with high quality projects

Vinícius Melo viniciusmelocodes

:octocat:
Serving customers with high quality projects
90 followers · 36 following
View GitHub Profile
@viniciusmelocodes
viniciusmelocodes / ORACLE_TODAS_TABELAS.SQL
Created February 3, 2022 19:08
SELECT
COL.COLUMN_ID,
COL.OWNER AS SCHEMA_NAME,
COL.TABLE_NAME,
COL.COLUMN_NAME,
COL.DATA_TYPE,
COL.DATA_LENGTH,
COL.DATA_PRECISION,
COL.DATA_SCALE,
COL.NULLABLE
@viniciusmelocodes
viniciusmelocodes / install_oci8_ubuntu20_php7.4.md
Created February 2, 2022 05:14 — forked from enlinea777/install_oci8_ubuntu20_php7.4.md
Install OCI8 (Oracle) in Ubuntu 20 with PHP 7.4
@viniciusmelocodes
viniciusmelocodes / install_oci8_ubuntu20_04_php7.4_oracle_11g.md
Last active February 2, 2022 05:18 — forked from eSkiSo/install_oci8_ubuntu20_php7.4.md
Install OCI8 (Oracle) in Ubuntu 20.04 with PHP 7.4 (Oracle 11G)
@viniciusmelocodes
viniciusmelocodes / select_apenas_registros_repetidos.sql
Created February 1, 2022 17:16
SELECT
CAD.CADASTRO_ID,
COUNT(*)
FROM
CADASTROS CAD
GROUP BY
CAD.CADASTRO_ID
HAVING
COUNT(*) > 1
@viniciusmelocodes
viniciusmelocodes / logoff_usuarios.ps1
Last active November 22, 2021 12:04
Logoff de usuário em PowerShell
quser | Select-Object -Skip 1 | ForEach-Object {
$id = ($_ -split ' +')[-5]
$sessioname = ($_ -split ' +')[-4]
# Apenas faz logoff dos usuários desconectados
if ($sessioname -eq 'Disco') {
#Write-Host $id
#Write-Host $sessioname
logoff $id
}
@viniciusmelocodes
viniciusmelocodes / treeview.css
Created November 20, 2021 03:46
#menutree li { list-style: none; }
li .menu_label + input[type=checkbox] { opacity: 0; }
li .menu_label { cursor: pointer; }
li .menu_label + input[type=checkbox] + ol > li { display: none; }
li .menu_label + input[type=checkbox]:checked + ol > li { display: block; }
@viniciusmelocodes
viniciusmelocodes / treeview_sql.sql
Created November 20, 2021 03:45
CREATE TABLE IF NOT EXISTS tab_treeview (
id int(12) NOT NULL AUTO_INCREMENT,
name varchar(255) NOT NULL,
title varchar(255) NOT NULL,
parent_id varchar(12) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7;
INSERT INTO tab_treeview (id, name, title, parent_id) VALUES
(1, 'Mumbai', 'The Film City', '3'),
@viniciusmelocodes
viniciusmelocodes / treeview-parte-2.php
Created November 20, 2021 03:43
/*Connecting to Database tempdb*/
mysql_connect('localhost', 'root');
mysql_select_db('tempdb');
/*Executing the select query to fetch data from table tab_treeview*/
$sqlqry="SELECT * FROM tab_treeview";
$result=mysql_query($sqlqry);
/*Defining an array*/
$arrayCountry = array();
@viniciusmelocodes
viniciusmelocodes / treeview.php
Last active November 20, 2021 03:44
function buildTree($array, $currentParent, $currLevel = 0, $prevLevel = -1) {
foreach ($array as $categoryId => $category) {
if ($currentParent == $category['parent_id']) {
if ($currLevel > $prevLevel) echo "<ol id='menutree'>";
if ($currLevel == $prevLevel) echo "</li>";
echo '<li> <label class="menu_label" for='.$categoryId.'>'.$category['name'].'</label><input type="checkbox" id='.$categoryId.' />';
if ($currLevel > $prevLevel) { $prevLevel = $currLevel; }
$currLevel++;
buildTree ($array, $categoryId, $currLevel, $prevLevel);
$currLevel--;
@viniciusmelocodes
viniciusmelocodes / lista_orgaos_emissores.html
Last active November 8, 2021 05:58
Lista de órgãos emissores do Brasil
<option value="ABNC">ABNC - Academia Brasileira de Neurocirurgia</option>
<option value="AGU">AGU - Advocacia-Geral da União</option>
<option value="ANAC">ANAC - Agência Nacional de Aviação Civil</option>
<option value="CAER">CAER - Clube de Aeronáutica</option>
<option value="CAU">CAU - Conselho de Arquitetura e Urbanismo</option>
<option value="CBM">CBM - Corpo de Bombeiro Militar</option>
<option value="CFA">CFA - Conselho Federal Administração</option>
<option value="CFB">CFB - Conselho Federal de Biblioteconomia</option>
<option value="CFBIO">CFBIO - Conselho Federal de Biologia</option>
<option value="CFBM">CFBM - Conselho Federal de Biomedicina</option>