Array
(
    [id] => 76
    [magicpayUsername] => zF3sK2MIq1gwW+YutrloPw==
    [magicpayPassword] => XucSMjbbi6PxAW9Nquf1UJd4CPZQmqcBq+vCRI+jWXP9pJlF2rwDaClEIkwbr/vI
    [data_file_name] => 61.txt
    [user_type] => nmi
    [allow] => 1
    [full_sync] => 0
    [payment_sync] => 1
    [cust_sync] => 0
    [execute_status] => 0
    [execute_status_done] => 1
    [deposit_to_sync] => 
    [invoice_no_from_doc] => 0
    [payment_amount_manually] => 0
    [user_id] => 61
    [refreshtoken_expiry] => 
)
UPDATE quickbook_info SET execute_status=1,execute_status_done=0 where user_id=61

****12023-03-212023-03-25LeadHeroes
dVTGtQbJ32Ab23R54wM2G337shRTJYdT
nmi****
Array
(
    [0] => Array
        (
            [transaction_id] => 8174593381
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => complete
            [order_id] => 24312
            [authorization_code] => 02777Z
            [ponumber] => Array
                (
                )

            [order_description] => Lead Heroes - Order 24312 (T65 Leads Promo x 2)
            [first_name] => Paul
            [last_name] => Morada
            [address_1] => Array
                (
                )

            [address_2] => Array
                (
                )

            [company] => Array
                (
                )

            [city] => Array
                (
                )

            [state] => NA
            [postal_code] => Array
                (
                )

            [country] => Array
                (
                )

            [email] => moradainsuranceservices@gmail.com
            [phone] => 6238537770
            [fax] => Array
                (
                )

            [cell_phone] => Array
                (
                )

            [customertaxid] => Array
                (
                )

            [customerid] => Array
                (
                )

            [website] => Array
                (
                )

            [shipping_first_name] => Array
                (
                )

            [shipping_last_name] => Array
                (
                )

            [shipping_address_1] => Array
                (
                )

            [shipping_address_2] => Array
                (
                )

            [shipping_company] => Array
                (
                )

            [shipping_city] => Array
                (
                )

            [shipping_state] => Array
                (
                )

            [shipping_postal_code] => Array
                (
                )

            [shipping_country] => Array
                (
                )

            [shipping_email] => Array
                (
                )

            [shipping_carrier] => Array
                (
                )

            [tracking_number] => Array
                (
                )

            [shipping_date] => Array
                (
                )

            [shipping] => 0.00
            [shipping_phone] => Array
                (
                )

            [cc_number] => 5xxxxxxxxxxx3473
            [cc_hash] => 053070bb34dbc741cad9c9e4a02611e1
            [cc_exp] => 1127
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => 0
            [csc_response] => M
            [cardholder_auth] => Array
                (
                )

            [cc_start_date] => Array
                (
                )

            [cc_issue_number] => Array
                (
                )

            [check_account] => Array
                (
                )

            [check_hash] => Array
                (
                )

            [check_aba] => Array
                (
                )

            [check_name] => Array
                (
                )

            [account_holder_type] => Array
                (
                )

            [account_type] => Array
                (
                )

            [sec_code] => Array
                (
                )

            [drivers_license_number] => Array
                (
                )

            [drivers_license_state] => Array
                (
                )

            [drivers_license_dob] => Array
                (
                )

            [social_security_number] => Array
                (
                )

            [processor_id] => ems
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 521307
            [cc_type] => Mastercard
            [signature_image] => Array
                (
                )

            [duty_amount] => Array
                (
                )

            [discount_amount] => Array
                (
                )

            [national_tax_amount] => Array
                (
                )

            [summary_commodity_code] => Array
                (
                )

            [vat_tax_amount] => Array
                (
                )

            [vat_tax_rate] => Array
                (
                )

            [alternate_tax_amount] => Array
                (
                )

            [action] => Array
                (
                    [amount] => 1250.00
                    [action_type] => sale
                    [date] => 20230322034758
                    [success] => 1
                    [ip_address] => 97.124.225.106
                    [source] => api
                    [api_method] => direct_post
                    [tap_to_mobile] => false
                    [username] => LeadHeroes
                    [response_text] => Approved
                    [batch_id] => 0
                    [processor_batch_id] => Array
                        (
                        )

                    [response_code] => 100
                    [processor_response_text] => APPROVAL 02777Z 
                    [processor_response_code] => 00
                    [requested_amount] => 1250.00
                    [device_license_number] => Array
                        (
                        )

                    [device_nickname] => Array
                        (
                        )

                )

        )

    [1] => Array
        (
            [transaction_id] => 8176307327
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => complete
            [order_id] => 8176307327
            [authorization_code] => 006055
            [ponumber] => Array
                (
                )

            [order_description] => 25 T-65 leads. Price Per Lead: $25 (Promo Price). Total: $625
            [first_name] => Herbert
            [last_name] => Lambert
            [address_1] => 7196 Millers Glen Way
            [address_2] => Array
                (
                )

            [company] => Array
                (
                )

            [city] => Memphis
            [state] => TN
            [postal_code] => 38125
            [country] => US
            [email] => hlambmemphis@att.net
            [phone] => 9014972151
            [fax] => 9017538067
            [cell_phone] => Array
                (
                )

            [customertaxid] => Array
                (
                )

            [customerid] => Array
                (
                )

            [website] => Array
                (
                )

            [shipping_first_name] => Herbert
            [shipping_last_name] => Lambert
            [shipping_address_1] => 7196 Millers Glen Way
            [shipping_address_2] => Array
                (
                )

            [shipping_company] => Array
                (
                )

            [shipping_city] => Memphis
            [shipping_state] => TN
            [shipping_postal_code] => 38125
            [shipping_country] => US
            [shipping_email] => hlambmemphis@att.net
            [shipping_carrier] => Array
                (
                )

            [tracking_number] => Array
                (
                )

            [shipping_date] => Array
                (
                )

            [shipping] => 0.00
            [shipping_phone] => Array
                (
                )

            [cc_number] => 4xxxxxxxxxxx8689
            [cc_hash] => 3af7768ffa3aafda17499219f67179d2
            [cc_exp] => 1226
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => Y
            [csc_response] => M
            [cardholder_auth] => Array
                (
                )

            [cc_start_date] => Array
                (
                )

            [cc_issue_number] => Array
                (
                )

            [check_account] => Array
                (
                )

            [check_hash] => Array
                (
                )

            [check_aba] => Array
                (
                )

            [check_name] => Array
                (
                )

            [account_holder_type] => Array
                (
                )

            [account_type] => Array
                (
                )

            [sec_code] => Array
                (
                )

            [drivers_license_number] => Array
                (
                )

            [drivers_license_state] => Array
                (
                )

            [drivers_license_dob] => Array
                (
                )

            [social_security_number] => Array
                (
                )

            [processor_id] => payarc
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 415978
            [cc_type] => Visa
            [signature_image] => Array
                (
                )

            [duty_amount] => Array
                (
                )

            [discount_amount] => 0.00
            [national_tax_amount] => Array
                (
                )

            [summary_commodity_code] => Array
                (
                )

            [vat_tax_amount] => Array
                (
                )

            [vat_tax_rate] => Array
                (
                )

            [alternate_tax_amount] => Array
                (
                )

            [action] => Array
                (
                    [amount] => 625.00
                    [action_type] => sale
                    [date] => 20230322193042
                    [success] => 1
                    [ip_address] => 73.91.243.236
                    [source] => quickclick
                    [api_method] => Array
                        (
                        )

                    [tap_to_mobile] => false
                    [username] => LeadHeroes
                    [response_text] => Approved
                    [batch_id] => 0
                    [processor_batch_id] => Array
                        (
                        )

                    [response_code] => 100
                    [processor_response_text] => EXACT MATCH     
                    [processor_response_code] => 00
                    [requested_amount] => 625.00
                    [device_license_number] => Array
                        (
                        )

                    [device_nickname] => Array
                        (
                        )

                )

        )

    [2] => Array
        (
            [transaction_id] => 8176876378
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => complete
            [order_id] => 8176876378
            [authorization_code] => 05637G
            [ponumber] => Array
                (
                )

            [order_description] => PPA For The Last 12 Months: 24. Price Per PPA: $100. Total: $2,400.
            [first_name] => andrew
            [last_name] => Eachon
            [address_1] => 25 nw 23rd pl
            [address_2] => 6156
            [company] => Century Benefits
            [city] => Portland
            [state] => OR
            [postal_code] => 97210
            [country] => US
            [email] => andrewe@centurybenefits.com
            [phone] => 5036087768
            [fax] => Array
                (
                )

            [cell_phone] => Array
                (
                )

            [customertaxid] => Array
                (
                )

            [customerid] => Array
                (
                )

            [website] => Array
                (
                )

            [shipping_first_name] => andrew
            [shipping_last_name] => Eachon
            [shipping_address_1] => 25 nw 23rd pl
            [shipping_address_2] => 6156
            [shipping_company] => Century Benefits
            [shipping_city] => Portland
            [shipping_state] => OR
            [shipping_postal_code] => 97210
            [shipping_country] => US
            [shipping_email] => andrewe@centurybenefits.com
            [shipping_carrier] => Array
                (
                )

            [tracking_number] => Array
                (
                )

            [shipping_date] => Array
                (
                )

            [shipping] => 0.00
            [shipping_phone] => Array
                (
                )

            [cc_number] => 4xxxxxxxxxxx4486
            [cc_hash] => 08b09e416e8348095b42b027c75d6874
            [cc_exp] => 1025
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => Z
            [csc_response] => M
            [cardholder_auth] => Array
                (
                )

            [cc_start_date] => Array
                (
                )

            [cc_issue_number] => Array
                (
                )

            [check_account] => Array
                (
                )

            [check_hash] => Array
                (
                )

            [check_aba] => Array
                (
                )

            [check_name] => Array
                (
                )

            [account_holder_type] => Array
                (
                )

            [account_type] => Array
                (
                )

            [sec_code] => Array
                (
                )

            [drivers_license_number] => Array
                (
                )

            [drivers_license_state] => Array
                (
                )

            [drivers_license_dob] => Array
                (
                )

            [social_security_number] => Array
                (
                )

            [processor_id] => ems
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 400390
            [cc_type] => Visa
            [signature_image] => Array
                (
                )

            [duty_amount] => Array
                (
                )

            [discount_amount] => 0.00
            [national_tax_amount] => Array
                (
                )

            [summary_commodity_code] => Array
                (
                )

            [vat_tax_amount] => Array
                (
                )

            [vat_tax_rate] => Array
                (
                )

            [alternate_tax_amount] => Array
                (
                )

            [action] => Array
                (
                    [amount] => 2400.00
                    [action_type] => sale
                    [date] => 20230322231033
                    [success] => 1
                    [ip_address] => 193.29.61.7
                    [source] => quickclick
                    [api_method] => Array
                        (
                        )

                    [tap_to_mobile] => false
                    [username] => LeadHeroes
                    [response_text] => Approved
                    [batch_id] => 0
                    [processor_batch_id] => Array
                        (
                        )

                    [response_code] => 100
                    [processor_response_text] =>  ZIP  MATCH     
                    [processor_response_code] => 00
                    [requested_amount] => 2400.00
                    [device_license_number] => Array
                        (
                        )

                    [device_nickname] => Array
                        (
                        )

                )

        )

    [3] => Array
        (
            [transaction_id] => 8179337904
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => complete
            [order_id] => 24328
            [authorization_code] => 023317
            [ponumber] => Array
                (
                )

            [order_description] => Lead Heroes - Order 24328 (Final Expense Leads (Promo) x 1)
            [first_name] => Tracey
            [last_name] => Runte
            [address_1] => Array
                (
                )

            [address_2] => Array
                (
                )

            [company] => Array
                (
                )

            [city] => Array
                (
                )

            [state] => NA
            [postal_code] => Array
                (
                )

            [country] => Array
                (
                )

            [email] => tracey@harboradvantage.com
            [phone] => 888-626-9887
            [fax] => Array
                (
                )

            [cell_phone] => Array
                (
                )

            [customertaxid] => Array
                (
                )

            [customerid] => Array
                (
                )

            [website] => Array
                (
                )

            [shipping_first_name] => Array
                (
                )

            [shipping_last_name] => Array
                (
                )

            [shipping_address_1] => Array
                (
                )

            [shipping_address_2] => Array
                (
                )

            [shipping_company] => Array
                (
                )

            [shipping_city] => Array
                (
                )

            [shipping_state] => Array
                (
                )

            [shipping_postal_code] => Array
                (
                )

            [shipping_country] => Array
                (
                )

            [shipping_email] => Array
                (
                )

            [shipping_carrier] => Array
                (
                )

            [tracking_number] => Array
                (
                )

            [shipping_date] => Array
                (
                )

            [shipping] => 0.00
            [shipping_phone] => Array
                (
                )

            [cc_number] => 4xxxxxxxxxxx4878
            [cc_hash] => 100af359d92337b0c2dce176c6ece495
            [cc_exp] => 0227
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => 0
            [csc_response] => M
            [cardholder_auth] => Array
                (
                )

            [cc_start_date] => Array
                (
                )

            [cc_issue_number] => Array
                (
                )

            [check_account] => Array
                (
                )

            [check_hash] => Array
                (
                )

            [check_aba] => Array
                (
                )

            [check_name] => Array
                (
                )

            [account_holder_type] => Array
                (
                )

            [account_type] => Array
                (
                )

            [sec_code] => Array
                (
                )

            [drivers_license_number] => Array
                (
                )

            [drivers_license_state] => Array
                (
                )

            [drivers_license_dob] => Array
                (
                )

            [social_security_number] => Array
                (
                )

            [processor_id] => ems
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 414718
            [cc_type] => Visa
            [signature_image] => Array
                (
                )

            [duty_amount] => Array
                (
                )

            [discount_amount] => Array
                (
                )

            [national_tax_amount] => Array
                (
                )

            [summary_commodity_code] => Array
                (
                )

            [vat_tax_amount] => Array
                (
                )

            [vat_tax_rate] => Array
                (
                )

            [alternate_tax_amount] => Array
                (
                )

            [action] => Array
                (
                    [amount] => 625.00
                    [action_type] => sale
                    [date] => 20230323204646
                    [success] => 1
                    [ip_address] => 24.196.75.42
                    [source] => api
                    [api_method] => direct_post
                    [tap_to_mobile] => false
                    [username] => LeadHeroes
                    [response_text] => Approved
                    [batch_id] => 0
                    [processor_batch_id] => Array
                        (
                        )

                    [response_code] => 100
                    [processor_response_text] => APPROVAL 023317 
                    [processor_response_code] => 00
                    [requested_amount] => 625.00
                    [device_license_number] => Array
                        (
                        )

                    [device_nickname] => Array
                        (
                        )

                )

        )

    [4] => Array
        (
            [transaction_id] => 8179898292
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => pendingsettlement
            [order_id] => 24329
            [authorization_code] => 203440
            [ponumber] => Array
                (
                )

            [order_description] => Lead Heroes - Order 24329 (T65 Leads Promo x 1)
            [first_name] => RICHARD
            [last_name] => MORRIS
            [address_1] => Array
                (
                )

            [address_2] => Array
                (
                )

            [company] => Array
                (
                )

            [city] => Array
                (
                )

            [state] => NA
            [postal_code] => Array
                (
                )

            [country] => Array
                (
                )

            [email] => richard@insuranceproaz.com
            [phone] => 4802270172
            [fax] => Array
                (
                )

            [cell_phone] => Array
                (
                )

            [customertaxid] => Array
                (
                )

            [customerid] => Array
                (
                )

            [website] => Array
                (
                )

            [shipping_first_name] => Array
                (
                )

            [shipping_last_name] => Array
                (
                )

            [shipping_address_1] => Array
                (
                )

            [shipping_address_2] => Array
                (
                )

            [shipping_company] => Array
                (
                )

            [shipping_city] => Array
                (
                )

            [shipping_state] => Array
                (
                )

            [shipping_postal_code] => Array
                (
                )

            [shipping_country] => Array
                (
                )

            [shipping_email] => Array
                (
                )

            [shipping_carrier] => Array
                (
                )

            [tracking_number] => Array
                (
                )

            [shipping_date] => Array
                (
                )

            [shipping] => 0.00
            [shipping_phone] => Array
                (
                )

            [cc_number] => 3xxxxxxxxxx4009
            [cc_hash] => e28fb6a55ac4bdb0b2d6aff682194fe2
            [cc_exp] => 1123
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => 0
            [csc_response] => M
            [cardholder_auth] => Array
                (
                )

            [cc_start_date] => Array
                (
                )

            [cc_issue_number] => Array
                (
                )

            [check_account] => Array
                (
                )

            [check_hash] => Array
                (
                )

            [check_aba] => Array
                (
                )

            [check_name] => Array
                (
                )

            [account_holder_type] => Array
                (
                )

            [account_type] => Array
                (
                )

            [sec_code] => Array
                (
                )

            [drivers_license_number] => Array
                (
                )

            [drivers_license_state] => Array
                (
                )

            [drivers_license_dob] => Array
                (
                )

            [social_security_number] => Array
                (
                )

            [processor_id] => payarc
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 377231
            [cc_type] => American Express
            [signature_image] => Array
                (
                )

            [duty_amount] => Array
                (
                )

            [discount_amount] => Array
                (
                )

            [national_tax_amount] => Array
                (
                )

            [summary_commodity_code] => Array
                (
                )

            [vat_tax_amount] => Array
                (
                )

            [vat_tax_rate] => Array
                (
                )

            [alternate_tax_amount] => Array
                (
                )

            [action] => Array
                (
                    [amount] => 625.00
                    [action_type] => sale
                    [date] => 20230324003640
                    [success] => 1
                    [ip_address] => 72.223.114.50
                    [source] => api
                    [api_method] => direct_post
                    [tap_to_mobile] => false
                    [username] => LeadHeroes
                    [response_text] => Approved
                    [batch_id] => 0
                    [processor_batch_id] => Array
                        (
                        )

                    [response_code] => 100
                    [processor_response_text] => APPROVAL 203440 
                    [processor_response_code] => 00
                    [requested_amount] => 625.00
                    [device_license_number] => Array
                        (
                        )

                    [device_nickname] => Array
                        (
                        )

                )

        )

)
Invoice entry push in past. 8174593381
Invoice entry push in past. 8176307327
Invoice entry push in past. 8176876378
Invoice entry push in past. 8179337904
Invoice entry push in past. 8179898292
UPDATE quickbook_info SET execute_status_done=1 where user_id=61