Tue, 21 Oct 2014 07:59:15 -0700

Array
(
    [action] => done
    [Transaction_Approved] => YES
    [x_response_code] => 1
    [x_zip] => 
    [Transaction_Tag] => 1382458166
    [x_fax] => 
    [x_MD5_Hash] => 30f0a18e56f2ae36e1b1dd67e3f07693
    [MerchantCountry] => Canada
    [CAVV_Algorithm] => 0
    [x_duty] => 
    [exact_issconf] => 
    [x_cust_id] => 
    [CAVV_Response] => 
    [Tax2Number] => 
    [x_reference_3] => 
    [x_response_subcode] => S
    [Bank_Resp_Code_2] => 
    [x_ship_to_address] => 
    [x_currency_code] => CAD
    [x_address] => 
    [CVD_Presence_Ind] => 0
    [Transaction_Error] => false
    [x_po_num] => 
    [x_login] => WSP-ELEME-G1pRIAAFfA
    [Card_Number] => ############9137
    [x_phone] => 
    [MerchantProvince] => Ontario
    [EXact_Resp_Code] => 00
    [XID] => 
    [x_freight] => 
    [x_test_request] => FALSE
    [exact_issname] => 
    [x_type] => 
    [x_description] => 
    [Retrieval_Ref_No] => 00000024
    [Tax2Amount] => 
    [x_ship_to_country] => 
    [Bank_Message] => APPROVED
    [CardHoldersName] => Vreneli Wall
    [x_ship_to_company] => 
    [TransactionCardType] => MASTERCARD
    [Client_Email] => 
    [x_company] => 
    [SurchargeAmount] => 0
    [MerchantCity] => KITCHENER
    [Ecommerce_Flag] => 7
    [x_trans_id] => 1382458166
    [x_tax] => 
    [exact_ctr] => =========== TRANSACTION RECORD ==========
ELEMENTARY SCHOOL NUTRITI
891 GUELPH ST #209
KITCHENER, ON N2H5Z2
Canada
WWW.ESNS.CA

TYPE: Purchase

ACCT: Mastercard  $ 16.00 CAD

CARD NUMBER : ############9137
DATE/TIME   : 21 Oct 14 10:59:13
REFERENCE # : 001 222365 M
AUTHOR. #   : 07468B
TRANS. REF. : 000000056620

    Approved - Thank You 000


Please retain this copy for your records.

Cardholder will pay above amount to card
issuer pursuant to cardholder agreement.
=========================================
    [x_fp_timestamp] => 1413903526
    [CVV2] => 
    [Tax1Number] => 
    [x_ship_to_zip] => 
    [Bank_Resp_Code] => 000
    [merchant_cookie_2] => 266516
    [x_country] => 
    [Expiry_Date] => 0415
    [x_ship_to_last_name] => 
    [x_response_reason_text] => Transaction has been approved
    [Client_IP] => 
    [Customer_Ref] => 
    [x_method] => 
    [DollarAmount] => 16.0
    [x_last_name] => 
    [x_invoice_num] => 000000056620
    [MerchantAddress] => 891 GUELPH ST #209
    [Secure_AuthResult] => 0
    [x_avs_code] => 
    [x_amount] => 16.00
    [x_cavv_response] => 
    [AVS] => 
    [x_email] => 
    [Tax1Amount] => 
    [x_ship_to_state] => 
    [EXact_Message] => Transaction Normal
    [Reference_3] => 
    [x_response_reason_code] => 1
    [x_state] => 
    [x_show_form] => PAYMENT_FORM
    [Authorization_Num] => 07468B
    [x_ship_to_first_name] => 
    [x_fp_sequence] => 56620
    [MerchantPostal] => N2H5Z2
    [Reference_No] => 000000056620
    [exact_wsp_version] => 1.7
    [Transaction_Type] => 00
    [x_first_name] => 
    [x_tax_exempt] => 
    [MerchantName] => ELEMENTARY SCHOOL NUTRITI
    [Language] => 0
    [Secure_AuthRequired] => 0
    [x_auth_code] => 07468B
    [x_cvv2_resp_code] => 
    [SequenceNo] => 222365
    [merchant_cookie_1] => 275
    [x_city] => 
    [ZipCode] => 
    [x_ship_to_city] => 
)



Insert ID: 37994

SELECT hloh.* FROM hotlunch_order_header as hloh, people as p WHERE hloh.school_num = 275 AND ordered_by_num = p.record_num AND ordered_by_type = p.people_type AND p.user_num = 266516 AND hloh.status NOT IN ('Paid','Complimentary','Concession')
Orders Found: 1
 - Order Paid: 1031229

Payment processed ok


