Skip to content

Instantly share code, notes, and snippets.

View XterraEngine-dev's full-sized avatar

Luis Cifuentes XterraEngine-dev

View GitHub Profile
@XterraEngine-dev
XterraEngine-dev / exportar_controller.rb
Created November 10, 2020 17:59
Ejemplo para exportación de archivos. xls rails
#Funcion en el controlador
def metodo
@modelo = Modelo.all #Listar modelo.
respond_to do |format|
#Enviar respuesta formato xls
format.xls {
send_data @modelo.to_csv({col_sep: "\t"}), #Dar saltos de lineas para que se reconsca como xls
filename: "NOMBRE_ARCHIVO.xls", #Nombre del archivo
type: 'text/csv; charset=utf-8' #Tipo de codificacion
}
$.fn.linedtextarea = function(options) {
// Get the Options
var opts = $.extend({}, $.fn.linedtextarea.defaults, options);
/*
* Helper function to make sure the line numbers are always
* kept up to the current system
*/
@XterraEngine-dev
XterraEngine-dev / index.html
Created August 21, 2020 22:39
Cursos prueba
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0" />
<title>Document</title>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
</head>
<body>
@XterraEngine-dev
XterraEngine-dev / validar-nit.js
Created August 21, 2020 16:52
Validar Nit Guatemala
function nitIsValid(nit) {
if (!nit) {
return true;
}
var nitRegExp = new RegExp('^[0-9]+(-?[0-9kK])?$');
if (!nitRegExp.test(nit)) {
return false;
}
@XterraEngine-dev
XterraEngine-dev / migrate.bash
Created June 23, 2020 12:29
Rails migrate data SQLite to Postgresql
gem install sequel
sequel -C sqlite://db/development.sqlite3 postgres://user:password@localhost/dbname
@XterraEngine-dev
XterraEngine-dev / guatemala.json
Created May 14, 2020 19:33
Coordenadas Departamentos y municipios Guatemala JSON
[
{
"nombre": "Usumatlán",
"lat": 14.9876401,
"lng": -89.7358563
},
{
"nombre": "Acatenango",
"lat": 14.5030911,
"lng": -90.8753056
We couldn’t find that file to show.
@XterraEngine-dev
XterraEngine-dev / basic.md
Created February 24, 2020 06:57 — forked from zenorocha/basic.md
New Firebase Auth vs Old Firebase Auth
@XterraEngine-dev
XterraEngine-dev / Selected range.yaml
Last active September 3, 2018 01:15
Get and set the currently selected range - Shared with Script Lab
name: Selected range
description: Get and set the currently selected range
author: XterraEngine-dev
host: EXCEL
api_set: {}
script:
content: |
$("#get-selection").click(getSelection);
$("#set-selection").click(setSelection);
@XterraEngine-dev
XterraEngine-dev / ANDROID VIEW PDF
Last active March 27, 2018 06:30
Android PDF VIEW
1) Download PDF in local storage
public class DownloadTaskPDF {
private static final String TAG = "Download Task";
private Context context;
private String downloadUrl = "", downloadFileName = "";
private ProgressDialog progressDialog;