jgdoncel’s gists

jgdoncel / tree.css

Created May 28, 2024 11:08 — forked from dylancwood/tree.css

CSS to create a simple tree structure with connecting lines. No images or JS required.

	ul.tree, ul.tree ul {
	list-style: none;
	margin: 0;
	padding: 0;
	}
	ul.tree ul {
	margin-left: 10px;
	}
	ul.tree li {
	margin: 0;

jgdoncel / create_calendar_table.sql

Created March 22, 2024 11:53 — forked from vetali/create_calendar_table.sql

Calendar table for MySql

	SET FOREIGN_KEY_CHECKS = 0;
	/* Drop Tables */

	DROP TABLE IF EXISTS calendar CASCADE;

	/* Create Tables */

	CREATE TABLE calendar (
	id DATE NOT NULL,
	year SMALLINT NOT NULL,

jgdoncel / fn_split_string.sql

Created January 12, 2023 15:18

MySQL: Function to split string based on a separator and an extraction index

	/*
	Usage:
	SELECT fn_split_string('20156 2018-01-25',' ',1) AS one, fn_split_string('20156 2018-01-25',' ',2) AS two;
	+-------+------------+
	\| one \| two \|
	+-------+------------+
	\| 20156 \| 2018-01-25 \|
	+-------+------------+
	*/
	CREATE FUNCTION `fn_split_string`(

jgdoncel / GoogleChart.cs

Last active January 28, 2019 10:39

Clase para generar objetos compatibles con Google Chart (https://developers.google.com/chart/interactive/docs/reference#dataparam)

	using System.Collections.Generic;

	namespace GoogleChart {
	public class Col
	{
	public string id { get; set; }
	public string label { get; set; }
	public string type { get; set; }
	}

jgdoncel / Module.js

Created January 21, 2019 11:37 — forked from sdd/Module.js

Javascript Module pattern template. Shows a class with a constructor and public/private methods/properties. Also shows compatibility with CommonJS(eg Node.JS) and AMD (eg requireJS) as well as in a browser.

	/**
	* Created with JetBrains PhpStorm.
	* User: scotty
	* Date: 28/08/2013
	* Time: 19:39
	*/
	;(function(global){
	"use strict";

	var M = function() {

jgdoncel / vanilla-js-plugin.js

Created May 10, 2018 09:08 — forked from cferdinandi/vanilla-js-plugin.js

My starter template for vanilla JavaScript plugins.

	(function (root, factory) {
	if ( typeof define === 'function' && define.amd ) {
	define([], factory(root));
	} else if ( typeof exports === 'object' ) {
	module.exports = factory(root);
	} else {
	root.myPlugin = factory(root);
	}
	})(typeof global !== 'undefined' ? global : this.window \|\| this.global, function (root) {

jgdoncel / fn_remove_accents.sql

Last active March 19, 2025 13:06

MySQL Function to remove accents and special characters

	DROP FUNCTION IF EXISTS fn_remove_accents;
	DELIMITER \|
	CREATE FUNCTION fn_remove_accents( textvalue VARCHAR(10000) ) RETURNS VARCHAR(10000)

	BEGIN

	SET @textvalue = textvalue COLLATE utf8_general_ci;;

	-- ACCENTS
	SET @withaccents = 'ŠšŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØÙÚÛÜÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüýÿþƒ';

jgdoncel / invalidhandler

Created December 20, 2016 12:22

jquery.validate - Focus bootstrap tab with firts invalid element

	...
	invalidHandler: function(e, validator){
	if(validator.errorList.length)
	$('a[href="#' + jQuery(validator.errorList[0].element, '#tabs').closest(".tab-pane").attr('id') + '"]').tab('show')
	},
	...

jgdoncel / Function.Array-Group-By.php

Last active November 18, 2016 11:56 — forked from mcaskill/Function.Array-Group-By.php

PHP : Groups an array by a given key

	<?php

	if ( ! function_exists('array_group_by') ) :

	/**
	* Groups an array by a given key.
	*
	* Groups an array into arrays by a given key, or set of keys, shared between all array members.
	*
	* Based on {@author Jake Zatecky}'s {@link https://github.com/jakezatecky/array_group_by array_group_by()} function.

jgdoncel / new_gist_file_0

Created November 9, 2016 09:19

From http://stackoverflow.com/questions/3984287/how-to-show-alternate-image-if-source-image-is-not-found-onerror-working-in-ie

<img src="imagenotfound.gif" alt="Image not found" onerror="this.src='imagefound.gif';" />