Tue, 21 Oct 2014 04:25:33 -0700

Array
(
    [action] => done
    [Transaction_Approved] => YES
    [x_response_code] => 1
    [x_zip] => 
    [Transaction_Tag] => 1382413910
    [x_fax] => 
    [x_MD5_Hash] => 8e44724166b8f7cf354450df984f811d
    [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] => ############6589
    [x_phone] => 
    [MerchantProvince] => Ontario
    [EXact_Resp_Code] => 00
    [XID] => 
    [x_freight] => 
    [x_test_request] => FALSE
    [exact_issname] => 
    [x_type] => 
    [x_description] => 
    [Retrieval_Ref_No] => 00000004
    [Tax2Amount] => 
    [x_ship_to_country] => 
    [Bank_Message] => APPROVED
    [CardHoldersName] => Donna Janzen
    [x_ship_to_company] => 
    [TransactionCardType] => MASTERCARD
    [Client_Email] => 
    [x_company] => 
    [SurchargeAmount] => 0
    [MerchantCity] => KITCHENER
    [Ecommerce_Flag] => 7
    [x_trans_id] => 1382413910
    [x_tax] => 
    [exact_ctr] => =========== TRANSACTION RECORD ==========
ELEMENTARY SCHOOL NUTRITI
891 GUELPH ST #209
KITCHENER, ON N2H5Z2
Canada
WWW.ESNS.CA

TYPE: Purchase

ACCT: Mastercard  $ 34.70 CAD

CARD NUMBER : ############6589
DATE/TIME   : 21 Oct 14 07:25:32
REFERENCE # : 001 222345 M
AUTHOR. #   : 06015B
TRANS. REF. : 000000056479

    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] => 1413890650
    [CVV2] => 
    [Tax1Number] => 
    [x_ship_to_zip] => 
    [Bank_Resp_Code] => 000
    [merchant_cookie_2] => 231088
    [x_country] => 
    [Expiry_Date] => 0916
    [x_ship_to_last_name] => 
    [x_response_reason_text] => Transaction has been approved
    [Client_IP] => 
    [Customer_Ref] => 
    [x_method] => 
    [DollarAmount] => 34.7
    [x_last_name] => 
    [x_invoice_num] => 000000056479
    [MerchantAddress] => 891 GUELPH ST #209
    [Secure_AuthResult] => 0
    [x_avs_code] => 
    [x_amount] => 34.70
    [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] => 06015B
    [x_ship_to_first_name] => 
    [x_fp_sequence] => 56479
    [MerchantPostal] => N2H5Z2
    [Reference_No] => 000000056479
    [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] => 06015B
    [x_cvv2_resp_code] => 
    [SequenceNo] => 222345
    [merchant_cookie_1] => 271
    [x_city] => 
    [ZipCode] => 
    [x_ship_to_city] => 
)



Insert ID: 37973

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

Payment processed ok


