Skip to content

Instantly share code, notes, and snippets.

/**
* Very simple way to check if a file exists on this domain.
* Use with the jQuery library.
*
* Important: Works only on the same domain.
* Cross-domain-requests have to be done in another way (see JSONP)!
*
* Use: console.log( "/data/list.json".fileExists() );
*/
String.prototype.fileExists = function() {
@anderson-mota
anderson-mota / gist:5084347
Created March 4, 2013 18:36
Group By com multiplos Selects.
SELECT ca.* ,
(SELECT count(u.id)
FROM psd_user_event u
WHERE u.periodoEscolhido = 'manhã' and u.idEvento = ca.id) as totalUsersManha,
(SELECT count(u.id)
FROM psd_user_event u
WHERE u.periodoEscolhido = 'tarde' and u.idEvento = ca.id) as totalUsersTarde
FROM psd_calendario ca
group by ca.id
@anderson-mota
anderson-mota / gist:5173725
Created March 15, 2013 22:47
Background position animate para Mozilla.
if ($.browser.mozilla) {
$('.tag').css({
'background-position': 'center 0px',
'-moz-transition': 'all 1500ms ease'
})
} else {
$('.tag').animate({
'background-position-y': 0
}, 1500);
}
@anderson-mota
anderson-mota / Pager.php
Created March 19, 2013 18:37
Pager - Pagination
<?php
class Pager
{
public $path;
public $page = 1;
public $perPage = 15;
public $offset;
public $totalPages;
@anderson-mota
anderson-mota / Utils.php
Created March 20, 2013 18:52
Definir limite de caracteres para frases.
public static function containString($string, $maxLength, $append = "...") {
if(strlen($string) <= $maxLength) {
return $string;
}
$lastPos = strrpos(substr($string, 0, $maxLength), " ");
$lastPos or $lastPos = $maxLength;
return substr($string, 0, $lastPos).$append;
}
@anderson-mota
anderson-mota / gist:5223811
Created March 22, 2013 18:56
Exporta para XLS
<?php
$result= array(
array('id'=>1, 'name'=>'teste 1', 'date'=>'2013-03-15'),
array('id'=>2, 'name'=>'teste 2', 'date'=>'2013-03-16'),
array('id'=>3, 'name'=>'teste 3', 'date'=>'2013-03-17'),
array('id'=>4, 'name'=>'teste 4', 'date'=>'2013-03-18'),
array('id'=>5, 'name'=>'teste 5', 'date'=>'2013-03-19'),
array('id'=>6, 'name'=>'teste 6', 'date'=>'2013-03-20'),
array('id'=>7, 'name'=>'teste 7', 'date'=>'2013-03-21'),
array('id'=>8, 'name'=>'teste 8', 'date'=>'2013-03-22'),
@anderson-mota
anderson-mota / functions.php
Created April 13, 2013 06:15
Script para executar Ajax no wp
<?php
function scriptAjax($id_form, $resposta){
?>
<script type="text/javascript">
var $jquery = jQuery.noConflict();
$jquery(document).ready(function($) {
$('#<?php echo $id_form; ?>').submit(function(e) {
e.preventDefault();
var img = "<img src='<?php bloginfo('template_url'); ?>/images/ajax-loader.gif' alt='Aguarde...' />";
@anderson-mota
anderson-mota / gist:5444503
Created April 23, 2013 15:24
dateTimeDiff (Para PHP 5.2)
<php
function dateTimeDiff($date1, $date2) {
$alt_diff = new stdClass();
$alt_diff->y = floor(abs($date1->format('U') - $date2->format('U')) / (60*60*24*365));
$alt_diff->m = floor((floor(abs($date1->format('U') - $date2->format('U')) / (60*60*24)) - ($alt_diff->y * 365))/30);
$alt_diff->d = floor(floor(abs($date1->format('U') - $date2->format('U')) / (60*60*24)) - ($alt_diff->y * 365) - ($alt_diff->m * 30));
$alt_diff->h = floor(floor(abs($date1->format('U') - $date2->format('U')) / (60*60)) - ($alt_diff->y * 365*24) - ($alt_diff->m * 30 * 24 ) - ($alt_diff->d * 24) );
$alt_diff->i = floor(floor(abs($date1->format('U') - $date2->format('U')) / (60)) - ($alt_diff->y * 365*24*60) - ($alt_diff->m * 30 * 24 *60) - ($alt_diff->d * 24 * 60) - ($alt_diff->h * 60) );
$alt_diff->s = floor(floor(abs($date1->format('U') - $date2->format('U'))) - ($alt_diff->y * 365*24*60*60) - ($alt_diff->m * 30 * 24 *60*60) - ($alt_diff->d * 24 * 60*60) - ($alt_diff->h * 60*60) - ($alt_diff->i * 60) )
@anderson-mota
anderson-mota / gist:5454193
Last active December 16, 2015 15:09
Plugin Alert para Bootstrap e Handlebars.
function(){
var alertTpl = Handlebars.compile($("#alert-tpl").html());
$.fn.alertIntra = function(message, _class){
_class = _class || "alert-info";
var icon_class = "icon-info-sign";
if(_class == "alert-warning"){
icon_class = "icon-exclamation-sign";
}else if(_class == "alert-error"){
@anderson-mota
anderson-mota / gist:5463532
Created April 25, 2013 21:54
Plugin para Upload com Ajax (IE não suporta)
var formData = new FormData() || false;
$.fn.uploadIntra = function(callback){
var elem = $(this).get(0);
var i = 0,
len = elem.files.length,
reader, file;
for ( ; len--; i++ ) {
file = elem.files[i];