Skip to content

Instantly share code, notes, and snippets.

@johnvilsack
johnvilsack / ResponseQueryAuthCards
Created November 30, 2011 16:12
Response Query on Already Authorized Cards
SELECT
SYSOENT.ORDER_STATUS,
SYSOENT.PO_NUMBER,
SYSOENT.ORDER_NO,
SYSOENT.ORDER_SOURCE,
SYSOENT.AUTH_CODE,
SYSOENT.AUTH_DATE,
SYSOENT.CREATED_BY,
SYSOENT.ORDER_DATE,
SYSOENT.CUSTOMER_ID,
<?php
class CRUD {
private $DB;
public function __set($name, $v) {
switch ($name) {
case 'username':
$this->username = $v;
<?php
include('db.class.php');
// Instantiate
$CRUD = new CRUD();
// Set Connection Vars
$CRUD->database = "mysql:dbname=sessions;host=localhost";
$CRUD->username = 'test';
@johnvilsack
johnvilsack / index
Created December 16, 2011 15:41
Twitter Bootstrap Template w/ JQuery
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<title></title>
<meta name="description" content="">
<meta name="author" content="">
<!--[if lt IE 9]><script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script><![endif]-->
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
@johnvilsack
johnvilsack / IntermecFingerprintBarcodeDuplicator
Created April 10, 2012 22:35
Intermec Fingerprint Barcode Duplicator
1 PRINT "START OF PROGRAM"
2 SOUND 500,10
3 SOUND 500,10
50 'OPEN SCREEN'
51 OPEN "CONSOLE:" FOR OUTPUT AS 50
52 PRINT# 50, "SCAN BARCODE NOW"
100 'OPEN SCANNER'
105 OPEN "USBHOST:" FOR INPUT AS 100
110 RAWSCAN$=INPUT$(12,100)
115 UPC$=LEFT$(RAWSCAN$,11)
@johnvilsack
johnvilsack / IntermecFingerprintBarcodeDuplicator
Created April 11, 2012 16:06
Intermec Fingerprint Barcode Duplicator
1 '// Beep to confirm active //'
5 SOUND 500,10
6 SOUND 500,10
50 '// Open Console Screen //'
55 OPEN "CONSOLE:" FOR OUTPUT AS 50
60 PRINT# 50, "SCAN UPC NOW"
100 '// USB SCANNER //'
105 OPEN "USBHOST:" FOR INPUT AS 100
@johnvilsack
johnvilsack / gist:2360291
Created April 11, 2012 16:12
Intermec Fingerprint Barcode Duplicator (Double USB Scan)
1 '// Beep to confirm active //'
5 SOUND 500,10
6 SOUND 500,10
50 '// Open Console Screen //'
55 OPEN "CONSOLE:" FOR OUTPUT AS 50
60 PRINT# 50, "SCAN UPC NOW"
100 '// USB SCANNER //'
105 OPEN "USBHOST:" FOR INPUT AS 100
<!DOCTYPE html>
<html>
<head>
<link rel="stylesheet" href="http://code.jquery.com/mobile/1.1.0-rc.2/jquery.mobile-1.1.0-rc.2.css" />
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<script src="http://code.jquery.com/mobile/1.1.0-rc.2/jquery.mobile-1.1.0-rc.2.js"></script>
</head>
<body>
<div data-role="page" id="container" data-theme="c">
<div data-role="header" data-theme="a">
@johnvilsack
johnvilsack / JSON HAPPY
Created August 2, 2012 21:46
JSON HAPPY
{"WKLF42CU12 ":{"ITEM_ID":"WKLF42CU12 ","UPC":"013576951188","ITEM_DESC":"LIQUID FORCE CUSTOM WAKESURFER 4ft 2in '12 - **L12 ","PROD_CLASS_ID":"WAKESURFER ","AVAILABLE":3,"GENDER":" ","SIZE":"4ft 2in ","BRAND":"Liquid Force ","YEAR":2012,"EAN":" ","BIN":null,"PRICE_OURPRICE":399.99,"PRICE_PACKAGE":0,"PRICE_COST":175,"LIST_PRICE":399.99,"FOCUS_WORD":"Custom","COLOR":null,"REFINESIZE":null,"VNDR_ITEM_ID":"2095118 ","COMMITTED_QTY":0,"BIN_LOC":"H ","VENDOR_ID":"LIQUID","KIT_FLAG":" ","TAX_EXEMPT":"N","ON_ORDER_QTY":8,"EXPCT_DELIVERY":"Aug 9 2012 12:00:00:000AM","LEAD_TIME":0,"FIRST_SOLD":"Mar 1 2012 12:00:00:000AM","LAST_SOLD":"Mar 1 2012 12:00:00:000AM","DROP_SHIP":"N","MASTER_STOCK_ID":" ","CREATED_BY":"TRENA,10\/18\/11,16:07,IMPORT_IN","REFINE_SIZE":"4","COLORC":null,"MODEL":null,"COLORB":null,"UPC_DATE":null,"UPC_SOURCE":null,"UPC_IMPDATE":null,"QTY_PICKABLE":3,"LAST_EDIT_DATE":"Aug 1 2012 12:00:00:000AM","QTY_ON_HAND":3,"ONWEB":"TRUE","id":"wklf42cu12","url_id":"wklf42cu12zz-liquid-force-wakesurfer","image"
<script>
$('#formSearch').submit(function(e)
{
// Prevent default HTML Submit
e.preventDefault();
var postSearchTerm = $("input:text[name=formSearchTerm]").val();
// Fetch JSON
$.getJSON('process.php', { q: postSearchTerm }, function(data)