123
Select * from quickbook_info where user_id=12
Array
(
    [id] => 106
    [magicpayUsername] => SyBE6x4Ka6GvQl5HgQwJRw==
    [magicpayPassword] => NvVKV5FsxUavJ/XpXFaM+g==
    [data_file_name] => 12.txt
    [user_type] => magicpay
    [sub_user_type] => 0
    [allow] => 1
    [full_sync] => 0
    [payment_sync] => 0
    [cust_sync] => 0
    [execute_status] => 1
    [execute_status_done] => 0
    [deposit_to_sync] => 14
    [invoice_no_from_doc] => 0
    [payment_amount_manually] => 1
    [user_id] => 12
    [refreshtoken_expiry] => 2024-06-09 10:20:08
)
UPDATE quickbook_info SET execute_status=1,execute_status_done=0 where user_id=12

****12024-02-272024-03-01mansiadroja1
Kavu2901Invoice entry push in past. 9260205867
Invoice entry push in past. 9262767511
Array
(
    [transaction_id] => 9262775706
    [partial_payment_id] => Array
        (
        )

    [partial_payment_balance] => Array
        (
        )

    [platform_id] => Array
        (
        )

    [transaction_type] => cc
    [condition] => pendingsettlement
    [order_id] => 3e6a0b0e-eab1-4ff5-913b-0b8db4669e76
    [authorization_code] => 123456
    [ponumber] => Array
        (
        )

    [order_description] => Array
        (
        )

    [first_name] => Anna
    [last_name] => Test
    [address_1] => Namal Tel Aviv
    [address_2] => Array
        (
        )

    [company] => Array
        (
        )

    [city] => New York
    [state] => Array
        (
        )

    [postal_code] => 10001
    [country] => Array
        (
        )

    [email] => annatest@test.com
    [phone] => Array
        (
        )

    [fax] => Array
        (
        )

    [cell_phone] => Array
        (
        )

    [customertaxid] => Array
        (
        )

    [customerid] => 864113332
    [website] => Array
        (
        )

    [shipping_first_name] => Anna
    [shipping_last_name] => Test
    [shipping_address_1] => Namal Tel Aviv
    [shipping_address_2] => Array
        (
        )

    [shipping_company] => Array
        (
        )

    [shipping_city] => New York
    [shipping_state] => Array
        (
        )

    [shipping_postal_code] => 10001
    [shipping_country] => Array
        (
        )

    [shipping_email] => Array
        (
        )

    [shipping_carrier] => Array
        (
        )

    [tracking_number] => Array
        (
        )

    [shipping_date] => Array
        (
        )

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

    [cc_number] => 4xxxxxxxxxxx3310
    [cc_hash] => 83bbd5e03fd825702647277fa4fde962
    [cc_exp] => 1124
    [cavv] => Array
        (
        )

    [cavv_result] => Array
        (
        )

    [xid] => Array
        (
        )

    [eci] => Array
        (
        )

    [directory_server_id] => Array
        (
        )

    [three_ds_version] => Array
        (
        )

    [avs_response] => N
    [csc_response] => Array
        (
        )

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

    [cash_discount] => Array
        (
        )

    [tip] => Array
        (
        )

    [card_balance] => Array
        (
        )

    [card_available_balance] => Array
        (
        )

    [entry_mode] => Keyed
    [cc_bin] => 491609
    [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
        (
        )

    [product] => Array
        (
            [sku] => test 1 week recur+ free trial 7 days
            [quantity] => 1.0000
            [description] => test 1 week recur+ free trial 7 days Paid plan
            [amount] => 5.0000
        )

    [action] => Array
        (
            [amount] => 5.00
            [action_type] => sale
            [date] => 20240229101921
            [success] => 1
            [ip_address] => 68.168.223.179
            [source] => api
            [api_method] => direct_post
            [tap_to_mobile] => false
            [username] => mansiadroja1
            [response_text] => SUCCESS
            [batch_id] => 0
            [processor_batch_id] => Array
                (
                )

            [response_code] => 100
            [processor_response_text] => Array
                (
                )

            [processor_response_code] => Array
                (
                )

            [device_license_number] => Array
                (
                )

            [device_nickname] => Array
                (
                )

        )

)
12Main invoice for quickbook 9262775706

Payment Id 45.00=amount
test amount and orderflag0
customer Id72024-02-29
QuickBooksOnline\API\Core\HttpClients\FaultHandler Object
(
    [context:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => 
    [httpStatusCode:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => 400
    [responseBody:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => Invalid Company StatusSubscription period has ended or canceled or there was a billing problem : You can't add data to QuickBooks Online Plus because your trial or subscription period ended, you canceled your subscription, or there was a billing problem. To update your subscription, click the gear icon and view your account information.
    [helpMsg:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => Invalid auth/bad request (got a 400, expected HTTP/1.1 20X or a redirect)
    [intuit_tid:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => 1-65e0b403-16c5b0fb2d185e5c6be51bad
    [intuitErrorType:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => ValidationFault
    [intuitErrorCode:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => 6190
    [intuitErrorElement:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => 
    [intuitErrorMessage:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => Invalid Company Status
    [intuitErrorDetail:QuickBooksOnline\API\Core\HttpClients\FaultHandler:private] => Subscription period has ended or canceled or there was a billing problem : You can't add data to QuickBooks Online Plus because your trial or subscription period ended, you canceled your subscription, or there was a billing problem. To update your subscription, click the gear icon and view your account information.
)
Created invoice Id=. 14invoice push
UPDATE quickbook_info SET execute_status_done=1 where user_id=12