Tue, 21 Oct 2014 06:50:57 -0700

Array
(
    [action] => done
    [Transaction_Approved] => YES
    [x_response_code] => 1
    [x_fp_timestamp] => 1413899398
    [x_zip] => 
    [Transaction_Tag] => 1382433080
    [x_fax] => 
    [x_MD5_Hash] => 4d4570e44e77a2e5c72776f8e63b98ce
    [MerchantCountry] => Canada
    [CAVV_Algorithm] => 0
    [x_duty] => 
    [merchant_cookie_2] => 240098
    [exact_issconf] => 
    [x_cust_id] => 
    [CAVV_Response] => 
    [Tax2Number] => 
    [x_reference_3] => 
    [x_response_subcode] => S
    [Bank_Resp_Code_2] => 
    [x_ship_to_address] => 
    [x_address] => 
    [CVD_Presence_Ind] => 0
    [Transaction_Error] => false
    [x_po_num] => 
    [Card_Number] => ############7609
    [x_phone] => 
    [MerchantProvince] => Ontario
    [EXact_Resp_Code] => 00
    [XID] => 
    [x_freight] => 
    [exact_issname] => 
    [x_type] => 
    [x_description] => 
    [Retrieval_Ref_No] => 00000016
    [Tax2Amount] => 
    [x_ship_to_country] => 
    [x_currency_code] => CAD
    [Bank_Message] => APPROVED
    [CardHoldersName] => Lee Morris
    [x_ship_to_company] => 
    [TransactionCardType] => VISA
    [Client_Email] => 
    [x_company] => 
    [merchant_cookie_1] => 472
    [x_login] => WSP-ELEME-G1pRIAAFfA
    [SurchargeAmount] => 0
    [MerchantCity] => KITCHENER
    [Ecommerce_Flag] => 7
    [x_trans_id] => 1382433080
    [x_tax] => 
    [exact_ctr] => =========== TRANSACTION RECORD ==========
ELEMENTARY SCHOOL NUTRITI
891 GUELPH ST #209
KITCHENER, ON N2H5Z2
Canada
WWW.ESNS.CA

TYPE: Purchase

ACCT: Visa  $ 17.20 CAD

CARD NUMBER : ############7609
DATE/TIME   : 21 Oct 14 09:50:52
REFERENCE # : 001 222357 M
AUTHOR. #   : 016395
TRANS. REF. : 000000056556

    Approved - Thank You 000


Please retain this copy for your records.

Cardholder will pay above amount to card
issuer pursuant to cardholder agreement.
=========================================
    [CVV2] => 
    [Tax1Number] => 
    [x_ship_to_zip] => 
    [x_test_request] => FALSE
    [Bank_Resp_Code] => 000
    [x_show_form] => PAYMENT_FORM
    [x_country] => 
    [Expiry_Date] => 0216
    [x_ship_to_last_name] => 
    [x_response_reason_text] => Transaction has been approved
    [Client_IP] => 
    [Customer_Ref] => 
    [x_method] => 
    [DollarAmount] => 17.2
    [x_last_name] => 
    [x_invoice_num] => 000000056556
    [MerchantAddress] => 891 GUELPH ST #209
    [Secure_AuthResult] => 0
    [x_avs_code] => 
    [x_amount] => 17.20
    [x_cavv_response] => 
    [AVS] => 
    [x_fp_sequence] => 56556
    [x_email] => 
    [Tax1Amount] => 
    [x_ship_to_state] => 
    [EXact_Message] => Transaction Normal
    [Reference_3] => 
    [x_response_reason_code] => 1
    [x_state] => 
    [Authorization_Num] => 016395
    [x_ship_to_first_name] => 
    [MerchantPostal] => N2H5Z2
    [Reference_No] => 000000056556
    [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] => 016395
    [x_cvv2_resp_code] => 
    [SequenceNo] => 222357
    [x_city] => 
    [ZipCode] => 
    [x_ship_to_city] => 
)



Insert ID: 37986

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

Payment processed ok


