johnvilsack’s gists

johnvilsack / gas-onedit.js

Created August 21, 2019 21:08

GAS: onEdit Instantiation

	// This script runs every time a cell is changed
	function onEdit(e) {

	var thisSheet = SpreadsheetApp.getActiveSheet();
	var editedCell = e.range.getA1Notation();
	var editedRow = e.range.getRow();
	var editedCol = e.range.getColumn();
	var editedA1Col = columnToLetter(editedCol);

	// @@ DEBUG

johnvilsack / index.js

Last active August 29, 2015 14:26

Standard Index for ActiveScan index.js

	function onConnectivityChange(state) {
	console.log("Connection is: " + state);
	}

	function onBarcodeScanned(data) {
	console.log(data.barcode);
	}

	var app = {
	initialize: function() {

johnvilsack / index.js

Created July 30, 2015 18:29

Standard index.js for /ttatarinov/lineapro-phonegap-plugin

	function onDeviceConnected(data) {
	alert("onDeviceConnected: " + data);
	}

	function onSuccessScanPaymentCard(data) {
	alert("onSuccessScanPaymentCard: " + data);
	}

	function onBarcodeScanned(data) {
	alert("onBarcodeScanned: " + data.rawCodesArr);

johnvilsack / ClientSide CSV Rendering (Drag and Drop) Version

Created July 23, 2015 16:03

Drag and drop target that uses Papaparse to read a JSON file into an object; all client side.

	<!DOCTYPE html>
	<html>
	<head>
	<title></title>
	<meta name="viewport" content="width=device-width, initial-scale=1.0">
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.5/css/bootstrap.min.css">
	<style>
	html {margin-top:40px;}
	</style>
	</head>

johnvilsack / InventoryPull

Created July 22, 2015 15:33

	SELECT
	RTRIM(ITEM_ID) AS ITEM_ID
	FROM INVENTOR
	WHERE
	(
	ENTRY_DATE >= '2015-01-01'
	OR
	(AVAILABLE > 0 OR ON_ORDER_QTY > 0 OR COMMITTED_QTY > 0)
	)
	AND

johnvilsack / CONNECTSHIP_ORDERINFO

Created July 8, 2015 13:37

SQL View of ConnectShip order data

	SELECT
	dbo.SYSOENT.ORDER_STATUS,
	dbo.SHIPTO.SHIPTO_ID,
	dbo.SHIPTO.ORDER_NO,
	RTRIM(dbo.SHIPTO.SHIPMETH_CODE) AS SHIPMETH_CODE,
	RTRIM(dbo.SHIPTO.COMPANY_NAME) AS SHIPTO_COMPANY_NAME,
	RTRIM(dbo.SHIPTO.LAST_NAME) AS SHIPTO_LAST_NAME,
	RTRIM(dbo.SHIPTO.FIRST_NAME) AS SHIPTO_FIRST_NAME,
	RTRIM(dbo.SHIPTO.ADDRESS_LINE1) AS SHIPTO_ADDRESS_LINE1,

johnvilsack / gist:d401a52c6671c2450985

Created March 23, 2015 19:47

	// Use the package, HTTP.
	var http = require('http');

	// In the package HTTP, execute createServer
	http.createServer(function (req, res) {

	// When createServer sees a request, shoot a header with a status 200 (this means OK) and tell it the next bit is text/plain
	res.writeHead(200, {'Content-Type': 'text/plain'});

	// This is the bits that go to the browser

johnvilsack / gist:cfe7a36c0582d4ebf8cc

Created December 15, 2014 17:10

Simple PDO to File Cache for PHP

	<?php
	// This is a simple way to cache queries to your local filesystem while maintaining control over their freshness.
	// Great for those nasty archival queries that data changes don't happen to.
	// Free to all, forever - John Vilsack 2014


	$file = './cache/FILENAME.cache'; // Path and name of .cache file
	$expire = 900; // # of seconds before cache is stale

	// Function to create the cached file.

johnvilsack / Übersicht YouTube Widget

Created August 6, 2014 20:14

YouTube on your desktop, courtesy of Übersicht

	command: "",

	refreshFrequency: 138000,

	render: function (output) {
	return "<iframe width=\"1880\" height=\"1250\" src=\"//www.youtube.com/embed/lhdJODImBL8?version=3&autoplay=1&loop=1&controls=0&showinfo=0&playlist=lhdJODImBL8\" frameborder=\"0\" allowfullscreen></iframe>";
	},

	style: " \n\
	top: -100px \n\

johnvilsack / MYSQL-Select.go

Created July 14, 2014 18:55

Go: Idiomatic SELECT for MySQL

	package main

	import (
	"database/sql"
	"log"

	_ "github.com/go-sql-driver/mysql"
	)

	var (

John Vilsack johnvilsack