test-helper
sql = SELECT id FROM ecom_orders WHERE status='NS' AND acctsyspri !='RECORDED'
B202508011:order:id: B202508011items:
epochorder: 1754059612
epochcomplete: 1
datemonth: 08
dateday: 01
dateyear: 2025
status: NS
statusinit: 1
statusenabled: 1
statusserviced: 1
statuscompleted: 0
statusinvprocessed: 1
statusreturnsproc: 0
ordreviewstatus: 0
ordreviewinfo:
mktexported:
paymethod: authnetan
payterms:
custponum:
xmultisite: DEFAULT
ordertotal: 150.38
recurtotal: 0.00
subtotal: 130.00
taxsptotal: 0.00
taxspshiptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
taxcshiptotal: 0.00
taxcrefshiptotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
custsurchargetotal: 0.00
disctotal: 0.00
shipdisctotal: 0.00
giftcerttotal: 0.00
shipwtaxgiftcerttotal: 0.00
surchgiftcerttotal: 0.00
adjposgiftcerttotal: 0.00
rebatetotal: 0.00
credittotal: 0.00
shiptotal: 20.38
shiptotalactual: 0.00
shiptotalmodified: 0
ordadjustpostotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 130.00
custpaytotal: 150.38
orderbalance: 0.00
disccode:
giftcert:
credit:
taxexemptnum:
disability:
custsaledesc:
custsurchargedesc:
ordadjustpos:
ordadjustneg:
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: Gregg
lname: Casagrande
company: SeaSucker, LLC
phone: 9419001845
email: gregg@seasucker.com
addone: 1912 44th Ave E
addtwo:
city: Bradenton
stateprov: Florida
country: United States
postalcode: 34203
rescom: C
customone: Agree
customtwo:
customthree:
customfour:
customfive:
customsix:
customseven:
customeight:
customnine:
customten:
commentsint:
commentsext:
referrer:
ipaddress: 47.203.147.31
proctoken:
sourceorder:
posordertype:
iswholesale: 0
iswholesalepremium: 0
isspecoffer: 0
channelid: DEFAULT
channelorderid:
channelcompleted: 0
suppresscustemail: 0
custorderemails:
intorderemails:
netreturntotal: 0.00
returnshiptaxtotal: 0.00
returnsurchargetotal: 0.00
returnordadjpostotal: 0.00
shipwtaxdiscreturned: 0
surchdiscreturned: 0
adjposdiscreturned: 0
taxspshiprate: 0.000
taxcshiprate: 0.000
shippingmemo:
acctsyspri:
acctsysalt:
acctsysdata:0:payments:id: B202508011-3VO4V1M7DR83
orderid: B202508011
epochorder: 1754059612
statusserviced: 1
statuscompleted: 0
statusreturned: 0
invcontrols: 0
invlocal: 1
invlocalshipmanager: 0
purchordsid:
purchorditemsreqid:
purchorditemsrec: 0
servstatus: N
shipstatus: P
itemname: Bondhus 13809, 5/32 Hex L-Wrench - Short (100)
itemnum: 13809
itemid: bondhus_13809
xinvid: bondhus_13809
itemquan: 5
itemopts:
itemnote:
recurtotal: 0.00
subtotal: 130.00
taxsptotal: 0.00
taxctotal: 0.00
taxcreftotal: 0.00
custsaletotal: 0.00
loyaltypointstotal: 0.00
disctotal: 0.00
giftcerttotal: 0.00
rebatetotal: 0.00
ordadjustnegtotal: 0.00
commtotal: 0.00
costtotal: 0.00
comptotal: 130.00
loyaltypointsredeemed: 0
loyaltypointsearned: 0
fname: Philip
lname: Macauley
company: SeaSucker, LLC
addone: 1912 44th Ave E
addtwo:
city: Bradenton
stateprov: Florida
country: United States
postalcode: 34203
rescom: C
shipmethod: FedEx Ground Service
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipweight: 2.200
epochship: 1
shipmanager:
shipmanagerbatch:
shipmanagershipment:
tracknumtype: OTHER
tracknums:
channelitemid:
dlfiles:
dlfilegets: 0
uploads:
barcode:
warehouseloc: A1
manufacturer: DEFAULT
vendorid: MINNESOTA-55362
catparent: Bondhus_Hex_L-wrenches_short_Bulk
addemtext:
customdata: QBID:BONDHUS
promoname:
giftcertissued:
autogiftcert: 0
autogiftcertsin: 0.00
giftcertstartdate:
giftcertexpdate:
taxsprate: 0.000
taxcrate: 0.000
netreturntotal: 0.00
discitemsreturned: 0
cartdata:randid: 3VO4V1M7DR83
isaddon: 0
taxcountrydisp: STANDARD
offergroup: VL9I6Z1MAP00
offerquantity: 5
id: bondhus_13809
offername: Bondhus 13809, 5/32 Hex L-Wrench - Short (100)
offernumber: 13809
offerimg: bondhus_13809.jpg
quantitymult: 1
quantity: 5
pricetype: REGPRICE
name: Bondhus 13809, 5/32 Hex L-Wrench - Short (100)
number: 13809
imgsm: bondhus_13809.jpg
manufacturer: DEFAULT
offertype: INVITEMS
disallowdiscount: 0
commok: 1
catparent: Bondhus_Hex_L-wrenches_short_Bulk
xupsell:
dlfiles:
addemtext:
customdata: QBID:BONDHUS
servreq: 0
discexclusions:
xinvid: bondhus_13809
vendorid: MINNESOTA-55362
dodrop: 0
barcode:
sinshipinfo:shiptype: Cdelmethod: C
shipstateprov: Minnesota
shipcountry: United States
shipzip: 55362
shipmustrate: 0
shipnumbox: 0
shiplength: 8.0
shipwidth: 3.5
shipheight: 2.5
shipnest: 0.0
shipweight: 2.200
customship: bondhus
warehouseloc: A1
shipfreethreshtrigger: 0
autogiftcert: 0
autogiftcertsin: 0
forceinv: 0
autoadd:
beonly: 0
offergiftpromo: 0.00
xinvcalc: LOCALUNL
forceprice: 0
taxinfo:ratebasissp:loyaltypoints: 0STANDARD: 1.000000ratebasisc:STANDARD: 1.000000classbasis:STANDARD: 1.000000
subtotal: 130
subtotalrec: 0
rebatetotal: 0
costtotal: 0
comptotal: 130.00
xpricemapid: DEFAULT-bondhus_13809-DEFAULT-bondhus_13809
sinprodprice:regprice: 26.000000sinprodloyaltypoints: 0
compprice: 26.000000
recurprice: 0
rebate: 0
cost: 0
optdisp: optids:
optselids:
sinoptprice:regprice: 0sinoptloyaltypoints: 0
compprice: 0
recurprice: 0
rebate: 0
cost: 0
uploads: savetype: CART
sortnum: 1
commtotal: 00:display:id: B202508011-Z241TK4L7U02
email: gregg@seasucker.com
orderid: B202508011
orderidorig:
creditid:
paytype: PAYMENTAPPLIED
paydesc: Payment
payattrib: ORDER
payamount: 150.38
paydate: 1754059612
payref:
paymethod: CREDITCARD
gatewayid: authnetan
proctransid: B202508011
cctype:
xmultisite: DEFAULT
acctsyspri:
acctsysalt:orderstatus:custom:C: Completedshipstatus:
NS: Pending Shipment
P: Pending Submission
PCE: Pending Customer Emailed
PPR: Pending Processing
PS: Partially Shipped
SV: Servicing
X: CancelledDP: Shipping Request Pendingservstatus:
DS: Shipping Requested
N: Not Applicable
P: Pending Shipment
S: ShippedN: Not Applicable
P: Servicing
S: Servicedordadjustpos: Positive Adjustmentgateway:
ordadjustneg: Negative Adjustment
disccode: Discount Code
giftcert: Gift Certificate
credit: Credits
loyaltypoints: Redeem Loyalty Points
taxexemptnum: Tax Exemption Number
disability: Disability Selection
commentsext: Comments
customtwo: How did you find us?
customone: Terms
customthree: Mandatory Signature Required
customfour: PO Number
customfive: Custom Field 5
customsix: Custom Field 6
customseven: Custom Field 7
customeight: Custom Field 8
customnine: Custom Field 9
customten: Custom Field 10id: authnetaninventory: realtimetracking:
name: Authorize.Net SIM - Payment Form
active: 1
xmultisite:
beonly: 0
urltype: E
dispname: Purchase using your credit card
disporder: 1000
fieldrc: x_response_code
fieldon: x_invoice_num
fieldtransid: x_invoice_num
fieldtotal: NotApplicable
validrc: 1
refurlstr: authorize.net
transkey: 5d2w52GA6hA6Ek2m
userid: 3v7WesKY62
postorder: 1
paymenttype: CREDITCARD
recursup: 0
incdisp: <?php // +-- // | This processor integration references an external // | URL for processing. All external processing gateways // | work in the same manner. An order information array // | is made available globally under the the global name // | 'ecom.order_summary'. // | // | This must set a global variable named 'ecom.olpform' // | which contains the form information to be posted to // | the external gateway URL. // | // | Anything printed within this code will be printed // | above the form instructions on the payment information // | page. // +-- // +-- // | THERE IS NO NEED TO EDIT THE CODE BELOW THIS POINT TO // | ACTIVATE THIS INTEGRATION. ONLY EDIT THIS CODE TO MODIFY // | HOW THIS INTEGRATION WORKS. BE SURE YOU KNOW WHAT YOU'RE // | DOING! // +-- // +-- // | Get a few global variables. // +-- $eol = $this->globals('core.eol'); $order = $this->globals('ecom.order_summary'); // +-- // | Printable form instructions. // +-- $instructions = "After verifying your order information and clicking the 'Continue' button, you will be directed to Authorize.net's secure site to enter your payment information. Once your payment information is entered and verified, you will be directed back to this web site for your order confirmation."; // +-- // | Create the SIM fingerprint. This requires the use of the // | hash extension to PHP. Make sure your host has enabled // | that extension. // +-- // +-- // | Make sure that the hash extension is loaded. // +-- $extension = 'hash'; $extension_load = $this->load_extension($extension); if ($this->IsError($extension_load)) { $extension = 'mhash'; $extension_load = $this->load_extension($extension); } // End of if statement. if ($this->IsError($extension_load)) { $message = 'The hash and mhash PHP extensions could not be loaded. This '; $message .= 'processing module requires either the hash or mhash PHP '; $message .= 'extensions to be loaded in order to function. This script '; $message .= 'attempted to load these extensions at runtime, however the current '; $message .= 'server configuration did not permit the script to make this '; $message .= 'runtime change. Contact your server administrator and request '; $message .= 'that either the hash or mhahs PHP extensions be loaded at run time.'; print '<p class="kstrong">' . $this->xhtml_encode($message) . '</p>' . $eol . $eol; return false; } // End of if statement. // +-- // | Create the SIM fingerprint. // +-- $x_fp_sequence = $order['order']['id']; $x_fp_sequence = preg_replace('/[^\d]/','',$x_fp_sequence); $x_fp_timestamp = $this->globals('core_datetime.epoch'); $x_fp_hash = $order['gateway']['userid'] . '^'; $x_fp_hash .= $x_fp_sequence . '^'; $x_fp_hash .= $x_fp_timestamp . '^'; $x_fp_hash .= $order['order']['orderbalance'] . '^'; if ($extension == 'hash') { $x_fp_hash = @hash_hmac('md5',$x_fp_hash,$order['gateway']['transkey']); } else { $x_fp_hash = @mhash(MHASH_MD5,$x_fp_hash,$order['gateway']['transkey']); $x_fp_hash = @bin2hex($x_fp_hash); } // End of if statement. // +-- // | Create our relay URL. // +-- $url_relay = $this->globals('core.url') . '/utilities/ecomrelaymeta.php'; // +-- // | Set up the olpform array. // +-- $olpform = array('url' => 'https://secure.authorize.net/gateway/transact.dll', 'button' => 'Continue', 'fields' => array()); // +-- // | Create the HIDDEN fields for the form. // +-- $olpform['fields']['HIDDEN'][] = array('name' => 'x_login', 'value' => $order['gateway']['userid']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_invoice_num', 'value' => $order['order']['id']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_cust_id', 'value' => $order['order']['id']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_amount', 'value' => $order['order']['orderbalance']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_first_name', 'value' => $order['order']['fname']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_last_name', 'value' => $order['order']['lname']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_company', 'value' => $order['order']['company']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_address', 'value' => $order['order']['addone'] . ' ' . $order['order']['addtwo']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_city', 'value' => $order['order']['city']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_state', 'value' => $order['order']['stateprov']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_country', 'value' => $order['order']['country']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_zip', 'value' => $order['order']['postalcode']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_phone', 'value' => $order['order']['phone']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_email', 'value' => $order['order']['email']); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_first_name', 'value' => $order['items'][0]['fname'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_last_name', 'value' => $order['items'][0]['lname'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_company', 'value' => $order['items'][0]['company'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_address', 'value' => $order['items'][0]['addone'] . ' ' . $order['items'][0]['addtwo'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_city', 'value' => $order['items'][0]['city'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_state', 'value' => $order['items'][0]['stateprov'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_country', 'value' => $order['items'][0]['country'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_ship_to_zip', 'value' => $order['items'][0]['postalcode'] ); $olpform['fields']['HIDDEN'][] = array('name' => 'x_show_form', 'value' => 'PAYMENT_FORM'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_method', 'value' => 'CC'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_type', 'value' => 'AUTH_ONLY'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_version', 'value' => '3.1'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_relay_response', 'value' => 'TRUE'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_relay_url', 'value' => $url_relay); $olpform['fields']['HIDDEN'][] = array('name' => 'x_receipt_link_method', 'value' => 'POST'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_header_html_payment_form', 'value' => 'Please complete the payment information below and click the Submit Transaction button to place your online order.'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_footer_html_payment_form', 'value' => 'After placing your online order, you will be presented with a printable receipt.'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_email_customer', 'value' => 'FALSE'); $olpform['fields']['HIDDEN'][] = array('name' => 'x_fp_hash', 'value' => $x_fp_hash); $olpform['fields']['HIDDEN'][] = array('name' => 'x_fp_sequence', 'value' => $x_fp_sequence); $olpform['fields']['HIDDEN'][] = array('name' => 'x_fp_timestamp', 'value' => $x_fp_timestamp); // +-- // | Create the DISPLAY fields for the form. // +-- $olpform['fields']['DISPLAY'][] = array('type' => 'PAYFORMCONTINUE', 'params' => array('name' => 'ecom_continue', 'required' => 1, 'display' => 'Payment Information', 'desc' => $instructions, 'option' => 'Enter Payment Information')); // +-- // | Globalize the $olpform array and return. // +-- $this->globals('ecom.olpform',$olpform); ?>FEDEX:id: FEDEXUPSTOOLS:id: UPSTOOLSUSPS:id: USPS
Welcome to BondhusTools.com, your one-stop shop for tools to turn fasteners!
