Skip to content

Instantly share code, notes, and snippets.

View dperussina's full-sized avatar

Daniel Perussina dperussina

  • FragilePAK
  • Unknown
View GitHub Profile
<SPN_QAData xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<Questions>
<SPN_QAQuestion>
<ControlName>QA_A1</ControlName>
<AnswerText>False</AnswerText>
</SPN_QAQuestion>
<SPN_QAQuestion>
<ControlName>QA_A2A</ControlName>
<QuestionText>What is the best phone number to call on the day of the delivery?</QuestionText>
<AnswerText />
{
"arrivalTime": "00:40",
"controlNumber": "NSTP0000000059",
"longitude": null,
"latitude": null,
"Entered": "05/18/2017 09:55:00",
"PODFullName": "Ronn mercer",
"SignatureBase64": "iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAJEElEQVR4Xu3dT6htZRkH4J+DVNQwyEBBNCfRJEwaVIJ/JooZVCMTCswc6KgScmCKKQ4UFVQc6SBrklGDdCI00koxNbQUB4KUCRUkYaZhw3hpbd2cezxnn3P33ne9az0L5Nx73Wftdz3vx4+1v/2ttY6LjQABAk0EjmtSpzIJECAQgWUQECDQRkBgtWmVQgkQEFjGAAECbQQEVptWKZQAAYFlDBAg0EZAYLVplUIJEBBYxgABAm0EBFabVimUAAGBZQwQINBGQGC1aZVCCRAQWMYAAQJtBARWm1YplAABgWUMECDQRkBgtWmVQgkQEFjGAAECbQQEVptWKZQAAYFlDBAg0EZAYLVplUIJEBBYxgABAm0EBFabVimUAAGBZQwQINBGQGC1aZVCCRAQWMYAAQJtBARWm1YplAABgWUMECDQRkBgtWmVQgkQEFjGAAECbQQEVptWKZQAAYFlDBAg0EZAYLVplUIJEBBYxgABAm0EBFabVimUAAGBZQwQINBGQGC1aZVCCRAQWMYAAQJtBARWm1YplAABgWUMECDQRkBgtWmVQgkQEFjGAAECbQQEVptWKZQAAYFlDBAg0EZAYLVplUIJEBBYxgABAm0EBFabVimUAAGBZQwQINBGQGC1aZVCCRAQWMYAAQJtBARWm1YplAABgWUMECDQRkBgtWmVQgkQEFjGAAECbQQEVptWKZQAAYFlDBAg0EZAYLVplUIJEBBYxgABAm0EBFabVimUAAGBZQwQINBGQGC1aZVCCRAQWMYAAQJtBARWm1Y
USE [tagnet]
go
SELECT DISTINCT headers.[partnerprimaryorderid] AS 'YRC PRO' ,
/*
PLACE HOLDER FOR OVERSTOCK PARTNER
We need more info
*/
( CASE
SELECT a.serviceproviderid,
Sum(CASE
WHEN b.notecode = 'RE' THEN 1
ELSE 0
END) AS RECount,
Sum (CASE
WHEN a.lastupdate >= Dateadd(day, -2 + CASE Datediff(day, 0,
Getdate()) %
7
WHEN 0 THEN 1
var client = require('./http');
var qs = require('querystring');
var u = require('./u/u')
function main() {
var startDate = $("#start-date-input");
var endDate = $("#end-date-input");
var searchBtn = $("#search-btn");
var exportBtn = $("#export-btn");
var status = $("#status-fill")
exportBtn.click(function(e){
function route_GetOnHandByDateRange(req, res) {
u.log('[route_GetOnHandByDateRange] ', req.query);
var _cache = [];
var request = req.query;
function validateRequest(cb) {
var requestIsValid = true;
var errorText = "";
if (request.startDate == undefined || request.startDate == "" || request.startDate == null) {
requestIsValid = false;
function route_GetOnHandByDateRange(req, res) {
u.log('[route_GetOnHandByDateRange] ', req.query);
var _cache = [];
var request = req.query;
function validateRequest(cb) {
var requestIsValid = true;
var errorText = "";
if (request.startDate == undefined || request.startDate == "" || request.startDate == null) {
requestIsValid = false;
iVBORw0KGgoAAAANSUhEUgAAASwAAACWCAYAAABkW7XSAAAY50lEQVR4Xu2dXchuW1XHh2iYV8euxJtOoaLRxakuikA9GWggyikK8oBgFkXdqF0EIoQFggTC0TslwcQLDQqL7oKwLMG8MbUgITAtQktQg/CIX/HzrL977Lmf93nWep75PceCzbv3fteaH2OM+Z/ja475NIsnKDAfBd5nZr+2Tet3zeyd802xmxl9143kJ83sn0qO7GklG4+2gwKVKfATZgZY8fNTG2gVXUCV59djd/9uZg9vA/tRM+PfxZ4ArGKkjYYrUwCNCrDieZeZvaly/6t291Uze2ibfHE8Kd7BqlyMeVejwLPN7IlNm/qamf2imf1ttd6jI28SFseT4h0EP4MCBSngTcC/28CKHT+eehQIDaseraOngSnwOjP7k238ONb5e4BVfYY+aWbPNDN+Pqt096FhlaZwtF+CAooCfn4zBcMELEHlfW2GSbiPTvHWghT4ETP7iJnx8y83x3rRqNSCND46ZZmE/Pyhox8ffT80rKMUi/dbUeAxM/sLM8Ox/geRW9WKDQ/069MaiuNJ8Q66IWsMZFQK+CggjnXAKkzAfrjpAQsNq6gfMQCrH8bHSB6kwM+Z2e+b2c9vuVVkrIcJ2JekeMCKTPe+eBOjqUgBNKk3mhka1uNm9qGKfUdX+ymAtvvo9vrLSmu/oWHtZ0y8WYcC6fEa/h1PvxTAr4h/kef1LtWkyIgDsIqQNRq9kgLSqpDLcKxfScTKn8Gnt259/uHGt2JDCMAqRtpo+AAF0ox1zgWGr+oAARu+WvUMZwBWQ05H19+jgBf44jt00Dw7BQiMkBvHQxSXfxd7ArCKkTYavkABnOkf3gQ8SsGMKy5ox58MwBqXgTHyyxTwGevvd8X2Ln8Zb/RGATaerwRg9caWGE8uCgBW7MgI+i9t2eu52o526lMAfn4uAKs+4aPH8hQApAArMqKjblV5etfowZuExQsnhg+rBkujDyggnxXZ0AFW88gEvMQX
{
"updateObj": {
"loginParams": {
"username": "danp_idp",
"password": "danp_idp",
"longitude": null,
"latitude": null,
"city": null,
"idpSignature": null,
"available": "true",
@dperussina
dperussina / JSON UPDATE - Estimated PU and DL times
Created September 19, 2011 19:44
JSON UPDATE - Estimated PU and DL times
{
"updateObj": {
"loginParams": {
"password": "test",
"username": "joel_idp",
"longitude": "",
"latitude": ""
},
"jobMessageArray": [
{