Tue, 21 Oct 2014 07:08:51 -0700

Array
(
    [action] => done
    [Transaction_Approved] => YES
    [x_response_code] => 1
    [x_fp_timestamp] => 1413900396
    [x_zip] => 
    [Transaction_Tag] => 1382437250
    [x_fax] => 
    [x_MD5_Hash] => e4bbb1238802cfbff73eb648cb04a75d
    [MerchantCountry] => Canada
    [CAVV_Algorithm] => 0
    [x_duty] => 
    [merchant_cookie_2] => 266492
    [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] => ############1585
    [x_phone] => 
    [MerchantProvince] => Ontario
    [EXact_Resp_Code] => 00
    [XID] => 
    [x_freight] => 
    [exact_issname] => 
    [x_type] => 
    [x_description] => 
    [Retrieval_Ref_No] => 00000020
    [Tax2Amount] => 
    [x_ship_to_country] => 
    [x_currency_code] => CAD
    [Bank_Message] => APPROVED
    [CardHoldersName] => Sandra Royce
    [x_ship_to_company] => 
    [TransactionCardType] => VISA
    [Client_Email] => 
    [x_company] => 
    [merchant_cookie_1] => 275
    [x_login] => WSP-ELEME-G1pRIAAFfA
    [SurchargeAmount] => 0
    [MerchantCity] => KITCHENER
    [Ecommerce_Flag] => 7
    [x_trans_id] => 1382437250
    [x_tax] => 
    [exact_ctr] => =========== TRANSACTION RECORD ==========
ELEMENTARY SCHOOL NUTRITI
891 GUELPH ST #209
KITCHENER, ON N2H5Z2
Canada
WWW.ESNS.CA

TYPE: Purchase

ACCT: Visa  $ 43.60 CAD

CARD NUMBER : ############1585
DATE/TIME   : 21 Oct 14 10:08:49
REFERENCE # : 001 222361 M
AUTHOR. #   : 055366
TRANS. REF. : 000000056568

    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] => 0915
    [x_ship_to_last_name] => 
    [x_response_reason_text] => Transaction has been approved
    [Client_IP] => 
    [Customer_Ref] => 
    [x_method] => 
    [DollarAmount] => 43.6
    [x_last_name] => 
    [x_invoice_num] => 000000056568
    [MerchantAddress] => 891 GUELPH ST #209
    [Secure_AuthResult] => 0
    [x_avs_code] => 
    [x_amount] => 43.60
    [x_cavv_response] => 
    [AVS] => 
    [x_fp_sequence] => 56568
    [x_email] => 
    [Tax1Amount] => 
    [x_ship_to_state] => 
    [EXact_Message] => Transaction Normal
    [Reference_3] => 
    [x_response_reason_code] => 1
    [x_state] => 
    [Authorization_Num] => 055366
    [x_ship_to_first_name] => 
    [MerchantPostal] => N2H5Z2
    [Reference_No] => 000000056568
    [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] => 055366
    [x_cvv2_resp_code] => 
    [SequenceNo] => 222361
    [x_city] => 
    [ZipCode] => 
    [x_ship_to_city] => 
)



Insert ID: 37990

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 = 266492 AND hloh.status NOT IN ('Paid','Complimentary','Concession')
Orders Found: 2
 - Order Paid: 1031131
 - Order Paid: 1031140

Payment processed ok


