This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<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 /> |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
USE [tagnet] | |
go | |
SELECT DISTINCT headers.[partnerprimaryorderid] AS 'YRC PRO' , | |
/* | |
PLACE HOLDER FOR OVERSTOCK PARTNER | |
We need more info | |
*/ | |
( CASE |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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){ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"updateObj": { | |
"loginParams": { | |
"username": "danp_idp", | |
"password": "danp_idp", | |
"longitude": null, | |
"latitude": null, | |
"city": null, | |
"idpSignature": null, | |
"available": "true", |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
{ | |
"updateObj": { | |
"loginParams": { | |
"password": "test", | |
"username": "joel_idp", | |
"longitude": "", | |
"latitude": "" | |
}, | |
"jobMessageArray": [ | |
{ |