Skip to content

Instantly share code, notes, and snippets.

View FabianoFaria's full-sized avatar

Fabiano FabianoFaria

3 followers · 2 following
  • Brazil
View GitHub Profile
@FabianoFaria
FabianoFaria / GetDateDiffFromNow
Created March 2, 2018 16:24
Diferença entre duas datas para versões antigas de PHP
function GetDateDiffFromNow($date1, $date2)
{
$unixOriginalDate = strtotime($date1);
$unixNowDate = strtotime($date2);
$difference = $unixNowDate - $unixOriginalDate ;
$days = (int)($difference / 86400);
$hours = (int)($difference / 3600);
$minutes = (int)($difference / 60);
$seconds = $difference;
$atrasado = false;
@FabianoFaria
FabianoFaria / publish php artisan
Created August 28, 2017 12:29
No need to create Makefile or something related, just copy "vendor/twitter/bootstrap/dist/css" and paste it into your "public/packages/" folder or simply run
php artisan asset:publish --path="vendor/twitter/bootstrap/dist/css" bootstrap/css
it worked for me.
@FabianoFaria
FabianoFaria / submit_resize.php
Created April 3, 2017 12:28
Função de upload e resize de imagem
function resizeImage($file, $savePath){
define ('MAX_WIDTH', 2500);//max image width
define ('MAX_HEIGHT', 2500);//max image height
define ('MAX_FILE_SIZE', 10485760);
//iamge save path
$path = $savePath.'/';
//size of the resize image
@FabianoFaria
FabianoFaria / Query filtrando por dia,hora e minuto
Last active March 22, 2017 11:53
SELECT selecionar dados de forma em hora em hora
<!-- ATUALIZANDO A QUERY PARA VERSÃO 5.7 -->
-- Seleciona a cada dia
SELECT a.*
FROM tb_dados a
INNER JOIN (
SELECT DATE(dt_criacao) date, DAY(dt_criacao) day, MIN(dt_criacao) min_date
FROM tb_dados GROUP BY DATE(dt_criacao),DAY(dt_criacao) ) b
ON DATE(a.dt_criacao) = b.date AND DAY(a.dt_criacao) = b.day AND a.dt_criacao = b.min_date
@FabianoFaria
FabianoFaria / gist:e75d44a8a4e04a390e4ecf6dc0e68229
Created February 9, 2017 16:37
Query MYSQL para seleciona a cada n° rows
SELECT UNIX_TIMESTAMP(dt_criacao) AS 'dt_criacao'
FROM (
SELECT
@row := @row +1 AS rownum, dt_criacao
FROM (
SELECT @row :=0) r, tb_dados WHERE num_sim = '1' AND dt_criacao BETWEEN '2017-02-01' AND '2017-02-09'
) ranked
WHERE rownum %30 =1
@FabianoFaria
FabianoFaria / Canvas JS
Created February 9, 2017 12:31
Utilização do framework de JS para a criação de tabelas gráficas
<?php
//var_dump($modelo->respDate);
//var_dump($modelo->respData);
//CARREGAR TODAS AS DATAS DO PERIODO SELECIONADO
//var_dump($modelo->respRawDate);
$dataUnix = $modelo->respRawDate;
$j = 0;
@FabianoFaria
FabianoFaria / dataMaiorQue
Created February 2, 2017 19:35
Data x maior que yy, formato 'yyyy/mm-dd'
/*
* Valida se a data fina é maior que a data inicio
*/
jQuery.validator.addMethod("greaterThan",
function(value, element, params) {
var temp = value.split("/");
var temp2 = $(params).val().split("/");
if (!/Invalid|NaN/.test(new Date(temp[2], (temp[1] - 1), temp[0]))) {
@FabianoFaria
FabianoFaria / Data maior que
Last active January 23, 2017 12:54
jQuery.validator.addMethod("greaterThan",
function(value, element, params) {
if (!/Invalid|NaN/.test(new Date(value))) {
return new Date(value) > new Date($(params).val());
}
return isNaN(value) && isNaN($(params).val())
|| (Number(value) > Number($(params).val()));
},'Must be greater than {0}.');
@FabianoFaria
FabianoFaria / gist:3b164936bdc667295c50
Created December 29, 2014 12:13
jQuery.validator.addMethod("cnpj", function(cnpj, element) {
cnpj = jQuery.trim(cnpj);// retira espaços em branco
// DEIXA APENAS OS NÚMEROS
cnpj = cnpj.replace('/','');
cnpj = cnpj.replace('.','');
cnpj = cnpj.replace('.','');
cnpj = cnpj.replace('-','');
var numeros, digitos, soma, i, resultado, pos, tamanho, digitos_iguais;
digitos_iguais = 1;
@FabianoFaria
FabianoFaria / gist:8cde1f2d88e9465b9959
Last active August 29, 2015 14:06
CPF jquery validate required not true
jQuery.validator.addMethod("verificaCPF", function(value, element) {
value = value.replace('.','');
value = value.replace('.','');
cpf = value.replace('-','');
while(cpf.length < 11) cpf = "0"+ cpf;