Array
(
    [id] => 103
    [magicpayUsername] => Hh7Fon0TMqOYCWSI37OA8A==
    [magicpayPassword] => mAqSNSHLIXoEcwUa0rQ27g==
    [data_file_name] => 1.txt
    [user_type] => magicpay
    [allow] => 1
    [full_sync] => 0
    [payment_sync] => 1
    [cust_sync] => 0
    [execute_status] => 0
    [execute_status_done] => 1
    [deposit_to_sync] => 152
    [invoice_no_from_doc] => 0
    [payment_amount_manually] => 0
    [user_id] => 1
    [refreshtoken_expiry] => 2022-11-17 11:12:40
)
UPDATE quickbook_info SET execute_status=1,execute_status_done=0 where user_id=1

****12022-08-062022-08-10magicpay123
noshmim123
Array
(
    [0] => Array
        (
            [transaction_id] => 7478771637
            [partial_payment_id] => Array
                (
                )

            [partial_payment_balance] => Array
                (
                )

            [platform_id] => Array
                (
                )

            [transaction_type] => cc
            [condition] => complete
            [order_id] => Array
                (
                )

            [authorization_code] => 681400
            [ponumber] => Array
                (
                )

            [order_description] => quickBook invoic id 25896
            [first_name] => Mariano
            [last_name] => Rodriguez Arroyo
            [address_1] => 10 Calle Pedro Albizu Campos
            [address_2] => Array
                (
                )

            [company] => Array
                (
                )

            [city] => Lares
            [state] => PR
            [postal_code] => 00669
            [country] => PR
            [email] => farmaciadecomunidad@gmail.com
            [phone] => (787) 897-2050
            [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] => 4xxxxxxxxxxx8403
            [cc_hash] => 3a40fe41c09252013bb115efe0363602
            [cc_exp] => 0327
            [cavv] => Array
                (
                )

            [cavv_result] => Array
                (
                )

            [xid] => Array
                (
                )

            [eci] => Array
                (
                )

            [directory_server_id] => Array
                (
                )

            [three_ds_version] => Array
                (
                )

            [avs_response] => D
            [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] => firstdataomaha
            [tax] => 0.00
            [currency] => USD
            [surcharge] => Array
                (
                )

            [cash_discount] => Array
                (
                )

            [tip] => Array
                (
                )

            [card_balance] => Array
                (
                )

            [card_available_balance] => Array
                (
                )

            [entry_mode] => Keyed
            [cc_bin] => 454952
            [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
                (
                    [0] => Array
                        (
                            [amount] => 830.98
                            [action_type] => sale
                            [date] => 20220808111517
                            [success] => 1
                            [ip_address] => 74.91.8.138
                            [source] => api
                            [api_method] => direct_post
                            [tap_to_mobile] => false
                            [username] => magicpay123
                            [response_text] => APPROVED
                            [batch_id] => 0
                            [processor_batch_id] => Array
                                (
                                )

                            [response_code] => 100
                            [processor_response_text] => TKT CODE  028771
                            [processor_response_code] => 0
                            [requested_amount] => 830.98
                            [device_license_number] => Array
                                (
                                )

                            [device_nickname] => Array
                                (
                                )

                        )

                    [1] => Array
                        (
                            [amount] => 830.98
                            [action_type] => settle
                            [date] => 20220808221752
                            [success] => 1
                            [ip_address] => Array
                                (
                                )

                            [source] => internal
                            [api_method] => Array
                                (
                                )

                            [tap_to_mobile] => false
                            [username] => Array
                                (
                                )

                            [response_text] => CLOSE____830.98
                            [batch_id] => 564985626
                            [processor_batch_id] => 8
                            [response_code] => 100
                            [processor_response_text] => Array
                                (
                                )

                            [processor_response_code] => 0
                            [device_license_number] => Array
                                (
                                )

                            [device_nickname] => Array
                                (
                                )

                        )

                )

        )

)
Invoice entry push in past. 7478771637
UPDATE quickbook_info SET execute_status_done=1 where user_id=1