Skip to content

Instantly share code, notes, and snippets.

View jotapepinheiro's full-sized avatar
🏠
Working from home

João Paulo Pinheiro jotapepinheiro

🏠
Working from home
33 followers · 48 following
View GitHub Profile
@jotapepinheiro
jotapepinheiro / removeDuploEspaco.js
Created March 10, 2012 04:56
Javascript - REMOVE O 1º ESPAÇO E OS DUPLOS ESPAÇOS
//REMOVE O 1º ESPAÇO E OS DUPLOS ESPAÇOS
$(".removeDuploEspaco").bind('keyup', function(e){
e.preventDefault();
var inicio = /^[^\s].*/;
if(!this.value.match(inicio))
this.value = this.value.replace(/\s+/g,"");
else
this.value = this.value.replace(/\s+/g," ");
})
@jotapepinheiro
jotapepinheiro / timeToTexto.php
Created March 10, 2012 04:59
PHP - Transforma dias em data completa
<?php
function timeToTexto($time){
$retorno = array();
$anos = floor($time/(86400*365));
$time = $time%(86400*365);
$meses = floor($time/(86400*30));
$time = $time%(86400*30);
$dias = floor($time/86400);
$time = $time%86400;
$horas = floor($time/(3600));
@jotapepinheiro
jotapepinheiro / Ext.ux.form.HtmlLintEditor.js
Created March 14, 2012 14:36 — forked from iguigova/Ext.ux.form.HtmlLintEditor.js
ExtJS HtmlEditor extension to support copy and paste from MS Word
/*!
* Ext JS Library 3.2.1
* Copyright(c) 2006-2010 Ext JS, Inc.
* licensing@extjs.com
* http://www.extjs.com/license
*/
Ext.ns('Ext.ux.form');
/**
@jotapepinheiro
jotapepinheiro / converteMoeda.php
Created April 6, 2012 20:53
Conversão de Moedas
<?php
$preco=Convert('USD', 'BRL','535,93');
if($preco!=false){
echo $preco;
}
else{echo "conversão não possível";}
/**
* [Converte Moedas]
* @example http://www.google.com/finance/converter
@jotapepinheiro
jotapepinheiro / slugUrl.sql
Created April 10, 2012 04:35
SLUG URL POSTGRE FUNCTION
CREATE OR REPLACE FUNCTION public.url_slug (
s_texto text
)
RETURNS varchar AS
$body$
DECLARE
total integer;
BEGIN
s_texto := replace(s_texto , 'U$', 'dolares');
s_texto := replace(s_texto , 'R$', 'reais');
@jotapepinheiro
jotapepinheiro / dragdrop.html
Created April 10, 2012 12:47
Drag and Drop Grid Extjs
<!--
/*!
* Ext JS Library 3.0.0
* Copyright(c) 2006-2009 Ext JS, LLC
* licensing@extjs.com
* http://www.extjs.com/license
*/
-->
<html>
<head>
@jotapepinheiro
jotapepinheiro / url_slug.php
Last active June 3, 2016 21:00
SLUG URL PHP FUNCTION
<?php
function url_slug($str, $replace=array(), $delimiter='-', $maxLength=200) {
setlocale(LC_ALL, 'pt_BR.UTF8');
if( !empty($replace) ) {
$str = str_replace((array)$replace, ' ', $str);
}
$clean = iconv('UTF-8', 'ASCII//TRANSLIT', $str);
$clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $clean);
$clean = strtolower(trim(substr($clean, 0, $maxLength), '-'));
@jotapepinheiro
jotapepinheiro / caseSelect.sql
Created April 17, 2012 21:06
CASE SELECT
SELECT
P.DESTIPOPROC
,COUNT(P.DESTIPOPROC) AS TOTAL
FROM PROTOCOLO.HISTORICO H
RIGHT JOIN PROTOCOLO.PROCESSOS P ON (P.NUMPROCESSO=H.NUMPROCESSO)
JOIN PROTOCOLO.INTERESSADOS I ON (I.NUMPROCESSO=P.NUMPROCESSO)
WHERE TO_CHAR(H.DATTRAMITOU ,'DD/MON/YYYY') BETWEEN TO_DATE('{?Pm-DataIni}','DD/MM/YYYY') AND TO_DATE('{?Pm-DataFim}','DD/MM/YYYY')
AND
1 = ( CASE WHEN {?Pm-CargoA} = -1 THEN 1
WHEN H.CODORGAO = {?Pm-CargoA} THEN 1
@jotapepinheiro
jotapepinheiro / diffDatas.php
Last active October 3, 2015 16:58
Diferença entre datas
<?php
function datediff ($inicio, $fim, $tipo = 'd'){
list($dia1,$mes1,$ano1) = explode("/",$inicio);
list($dia2,$mes2,$ano2) = explode("/",$fim);
$data_inicio = mktime(0,0,0,$mes1,$dia1,$ano1);
$data_fim = mktime(0,0,0,$mes2,$dia2,$ano2);
$diferenca = ($data_fim - $data_inicio);
@jotapepinheiro
jotapepinheiro / PainelPadrao.js
Created April 29, 2012 02:50
Ext.extend - ARQUIVO PADRAO
CategoriasLista = Ext.extend(Ext.Panel, {
title : 'Titulo'
,$depends : [pluginFormUx + 'statusbar/StatusBar']//CARREGA ARQUIVOS DINAMICAMENTE
,layout : 'fit'
,initComponent: function() {
var tbar = new Ext.Toolbar({
items:
[
{