Skip to content

Instantly share code, notes, and snippets.

View JRGGRoberto's full-sized avatar
🏛️
On work

Roberto JRGGRoberto

🏛️
On work
17 followers · 41 following
View GitHub Profile
@JRGGRoberto
JRGGRoberto / lista.html
Created April 9, 2024 17:57
Lista com numeração dinâmica
<!DOCTYPE html>
<html>
<body>
<h1>Título</h1>
<ol id="menu">
<li><a href="#cafe">Café</a></li>
<li><a href="#verde">Limão</a></li>
<li><a href="#laran">Orange</a></li>
@JRGGRoberto
JRGGRoberto / VIEW_projetostb.sql
Created March 15, 2024 13:48
View que junta todos os projetos
CREATE OR REPLACE VIEW `projetostb` AS
select
n.id AS id,
n.coordenador AS coordenador,
n.titulo AS titulo,
n.campus AS campus,
n.ano AS ano,
n.arq_projeto AS arq_projeto,
n.arq_relatorio AS arq_relatorio,
n.versao AS versao
@JRGGRoberto
JRGGRoberto / TabelaDinamica.html
Last active March 30, 2023 19:33
Tabela dinamica. Dados inseridos via input. Javascript
<!DOCTYPE html>
<html lang="en">
<head>
<title>Bootstrap Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/css/bootstrap.min.css">
<script src="https://cdn.jsdelivr.net/npm/jquery@3.6.3/dist/jquery.slim.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js"></script>
<script src="https://cdn.jsdelivr.net/npm/bootstrap@4.6.2/dist/js/bootstrap.bundle.min.js"></script>
@JRGGRoberto
JRGGRoberto / Array PHP
Created March 20, 2023 19:12
<!DOCTYPE html>
<html>
<body>
<?php
$total = 6;
class Blocos {
public $pos;
public $cor;
@JRGGRoberto
JRGGRoberto / PKG_KAF24F.pck
Last active January 30, 2019 14:01
KAF
CREATE OR REPLACE PACKAGE PKG_KAF24F is
-- Author : Roberto Gomes
-- Created : 25/01/2019
-- Purpose : Package para exportar dados para envio a KAF24h
-- http://kaf24h.com.br/
Procedure Cria_Registros;
Procedure Apagar_Registros(V_Id in out number);
Procedure MarcarComoEnviado(idReg in out number);
@JRGGRoberto
JRGGRoberto / Classe.dart
Last active December 25, 2018 14:49
Dart Flutter
class Pessoa {
String nome;
int idade;
double altura;
void dormir(){
print("$nome está dormindo!");
}
void aniver(){
@JRGGRoberto
JRGGRoberto / Oracle_Qry_where_case.sql
Last active December 20, 2018 16:56
Oracle SQL -2
select
'.config' doc,
case when af.dtliberacao >= t.tp_prms then 1 else 0 end Imprime
from tb_prms_glob t,
assistfinanc af
where
t.nm_prms = 'KIT_IMPRESSAO'
and af.numcontratoemp = :NUMCONTRATO
union
@JRGGRoberto
JRGGRoberto / GetDadoMySQL.php
Created September 15, 2016 15:57
Google Grafs- https://google-developers.appspot.com/chart/interactive/docs/gallery/areachart#loading
<?php
$conn = new mysqli("localhost","root","20gmtel14","Dashboards");
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql= "select DATE_FORMAT(dt, '%k:%i') as dt, n1, n2, n3, n4, n5, n6, n51, n52 from graf_log_trunks_sft order by id";
$result = $conn->query($sql);
@JRGGRoberto
JRGGRoberto / Load_Mon_Trafic.sql.sql
Last active September 15, 2016 14:47
Use Dashboards;
DROP TABLE IF EXISTS Mon_Trafic_Trunk_SFR2;
CREATE TABLE IF NOT EXISTS Mon_Trafic_Trunk_SFR2 (
col1 text,
col2 text,
col3 text,
col4 text,
col5 text,
@JRGGRoberto
JRGGRoberto / MySQL_Split.sql
Created September 13, 2016 11:15
DELIMITER $$
CREATE FUNCTION SPLIT_STR(
x VARCHAR(255),
delim VARCHAR(12),
pos INT
)
RETURNS VARCHAR(255) DETERMINISTIC
BEGIN
RETURN REPLACE(SUBSTRING(SUBSTRING_INDEX(x, delim, pos),
LENGTH(SUBSTRING_INDEX(x, delim, pos -1)) + 1),