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
noshmim123Array
(
[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