Skip to content

Instantly share code, notes, and snippets.

View gchacaltana's full-sized avatar
🎯
Focusing

Gonzalo Chacaltana gchacaltana

🎯
Focusing
  • Perú
View GitHub Profile
@gchacaltana
gchacaltana / sp_insert_bank_account_temp.sql
Created April 18, 2020 05:40
Capturar y devolver errores en procedimientos almacenados MySQL
DELIMITER $$
CREATE PROCEDURE dbxupl9xdb.sp_insertBankAccount(IN bank_account_type CHAR(4), IN bank_account_number INT)
BEGIN
DECLARE exit handler for SQLEXCEPTION
BEGIN
GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE,
@error_number = MYSQL_ERRNO, @error_message = MESSAGE_TEXT;
SET @full_error = CONCAT("ERROR ", @error_number, " (", @sqlstate, "): ", @error_message);
SELECT @error_number error_number, @full_error error_message;
@gchacaltana
gchacaltana / dropify.settings.js
Created February 11, 2020 00:52
Settings dropify JS
$('.dropify').dropify({
messages: {
'default': 'Arrastra y suelta un archivo aquí o haz clic',
'replace': 'Arrastra y suelta o haz clic para reemplazar el archivo',
'remove': 'Eliminar',
'error': 'Ooops!. Ocurrió un error interno de validación'
},
error: {
'fileSize': 'El archivo es demasiado grande. ({{ value }} max).',
'fileExtension': 'El archivo no está permitido. Solo esta permitido ({{ value }})',
Highcharts.setOptions({
lang: {
loading: 'Cargando...',
months: ['Enero', 'Febrero', 'Marzo', 'Abril', 'Mayo', 'Junio', 'Julio', 'Agosto', 'Septiembre', 'Octubre', 'Noviembre', 'Diciembre'],
weekdays: ['Domingo', 'Lunes', 'Martes', 'Miércoles', 'Jueves', 'Viernes', 'Sábado'],
shortMonths: ['Ene', 'Feb', 'Mar', 'Abr', 'May', 'Jun', 'Jul', 'Ago', 'Sep', 'Oct', 'Nov', 'Dic'],
exportButtonTitle: "Exportar",
printButtonTitle: "Importar",
rangeSelectorFrom: "Desde",
rangeSelectorTo: "Hasta",
@gchacaltana
gchacaltana / formato_numerico.js
Created June 27, 2019 20:55
Formato numérico API Number
/**
* Formato numérico americano
* Resultado: 1,000,000,000
* */
const numberFormatUS = new Intl.NumberFormat('en');
console.log(numberFormatUS.format(1000000000));
/**
* Formato numérico de perú
* Resultado: 1.000.000.000
@gchacaltana
gchacaltana / object_from_entries.js
Created June 27, 2019 20:54
Objec. fromEntries()
const objUserTwiter = new Map([
["name", "Gonzalo Chacaltana"],
["location", "Perú"],
["account", "@gchacaltanab"]
]);
console.log(Object.fromEntries(objUserTwiter));
/**
* Resultado:
* {name: "Gonzalo Chacaltana", location: "Perú", account: "@gchacaltanab"}
* */
@gchacaltana
gchacaltana / Object_entries.js
Created June 27, 2019 20:53
Object.entries()
let twitter = {
name: "Gonzalo Chacaltana",
location: "Perú",
account: "@gchacaltanab"
};
console.log(Object.entries(twitter));
/* Expected Output
[
["name", "Gonzalo Chacaltana"],
["location", "Perú"],
@gchacaltana
gchacaltana / metodo_flat_Array.js
Created June 27, 2019 20:52
Javascript News Flat Metod
/**
* Ejemplo de método flat con nivel
* */
let breed = ["Mamíferos",
["perros", ["Bulldog", "Labrador", "Boxer"]],
["gatos", ["Ragdoll", "Sphynx", "Angora"]]
];
console.log(breed.flat());
/**
@gchacaltana
gchacaltana / TravelRaffle.js
Created June 27, 2019 20:51
TravelRaggle - Sorteo
/*
* Sorteo de viajes - Manejo de atributos
* @author Gonzalo Chacaltana @gchacaltanab
* @class TravelRaffle
* **/
class TravelRaffle {
constructor() {
this._country = null;
}
@gchacaltana
gchacaltana / spread.js
Created June 27, 2019 20:50
Spread and rest Objects
let book = {
title: "Enterprise Agility: Being Agile In a Changing World",
isbn: "ISBN-13 978-1788990646",
publicationDate: "June 2018",
pages: 490,
editorial: "Packt Publishing"
};
let author = {
name: "Sunil Mundra",
twitterAccount: "@sunil_mundra",
@gchacaltana
gchacaltana / trimstart_trimend.js
Created June 27, 2019 20:48
Funcionalidades Javascript: TrimStrat y TrimEnd
/**
* Ejemplo de trimStart and trimEnd
* @@author Gonzalo Chacaltana Buleje <gchacaltanab@outlook.com>
* @class UserTwitter
* @version 1.0
*/
var UserTwitter = {
account: null,
name: null,
setAccount: function (str) {