Store all data in JSON

[remcotolsma]

Currently not all payment and subscription data is stored in JSON:
https://docs.google.com/spreadsheets/d/1CJHnHcr9s8lkh4Fq9HQmlAThCK69eXiTC3UktyeQKYw/edit?usp=sharing

I think the payment and subscription JSON object should always contain all data, post meta is purely for query purposes.

To Do

• _pronamic_payment_action_url
• _pronamic_payment_adyen_details_result
• _pronamic_payment_adyen_payment_response #226
• _pronamic_payment_adyen_sdk_version
• Store _pronamic_payment_config_id in JSON #231
• _pronamic_payment_description
• _pronamic_payment_entrance_code
• Store _pronamic_payment_issuer in JSON #229
• Store _pronamic_payment_key in JSON #237
• Store _pronamic_payment_method in JSON #230
• _pronamic_payment_mollie_change_payment_state_url
• _pronamic_payment_mollie_customer_id
• _pronamic_payment_omnikassa_2_merchant_order_id
• Store _pronamic_payment_order_id in JSON #244
• _pronamic_payment_recurring
• _pronamic_payment_recurring_type
• Store _pronamic_payment_source in JSON #232
• _pronamic_payment_source_id
• _pronamic_payment_version
• _pronamic_payment_woocommerce_payment_method
• _pronamic_payment_woocommerce_payment_method_title
• _pronamic_subscription_config_id
• _pronamic_subscription_description
• _pronamic_subscription_key
• _pronamic_subscription_mollie_customer_id
• _pronamic_subscription_mollie_mandate_id
• _pronamic_subscription_payment_method
• _pronamic_subscription_source
• _pronamic_subscription_source_id

Pronamic Pay meta

Payments

Key	In JSON	In post meta
_pronamic_payment_action_url	❌	✅
_pronamic_payment_address	✅	✅
_pronamic_payment_adyen_details_result	❌	✅
_pronamic_payment_adyen_payment_response	❌	✅
_pronamic_payment_adyen_sdk_version	❌	✅
_pronamic_payment_amount	✅	✅
_pronamic_payment_city	✅	✅
_pronamic_payment_config_id	❌	✅
_pronamic_payment_consumer_account_number	✅	✅
_pronamic_payment_consumer_bic	✅	✅
_pronamic_payment_consumer_iban	✅	✅
_pronamic_payment_consumer_name	✅	✅
_pronamic_payment_country	✅	✅
_pronamic_payment_currency	✅	✅
_pronamic_payment_customer_name	✅	✅
_pronamic_payment_description	❌	✅
_pronamic_payment_email	✅	✅
_pronamic_payment_end_date	✅ (also through periods)	✅
_pronamic_payment_entrance_code	❌	✅
_pronamic_payment_first_name	✅	✅
_pronamic_payment_issuer	❌	✅
_pronamic_payment_key	❌	✅
_pronamic_payment_language	✅	✅
_pronamic_payment_last_name	✅	✅
_pronamic_payment_locale	✅	✅
_pronamic_payment_method	❌	✅
_pronamic_payment_mollie_change_payment_state_url	❌	✅
_pronamic_payment_mollie_customer_id	❌	✅
_pronamic_payment_omnikassa_2_merchant_order_id	❌	✅
_pronamic_payment_order_id	❌	✅
_pronamic_payment_recurring	❌	✅
_pronamic_payment_recurring_type	❌	✅
_pronamic_payment_source	❌	✅
_pronamic_payment_source_id	❌	✅
_pronamic_payment_start_date	✅ (also through periods)	✅
_pronamic_payment_status	✅	✅
_pronamic_payment_subscription_id	✅ through periods	✅
_pronamic_payment_telephone_number	✅	✅
_pronamic_payment_transaction_id	✅	✅
_pronamic_payment_user_agent	✅	✅
_pronamic_payment_user_ip	✅	✅
_pronamic_payment_version	❌	✅
_pronamic_payment_woocommerce_payment_method	❌	✅
_pronamic_payment_woocommerce_payment_method_title	❌	✅
_pronamic_payment_zip	✅	✅

Subscriptions

Key	In JSON	In post meta
_pronamic_subscription_amount	✅ through fases	✅
_pronamic_subscription_config_id	❌	✅
_pronamic_subscription_currency	✅ through fases	✅
_pronamic_subscription_customer_name	✅	✅
_pronamic_subscription_description	❌	✅
_pronamic_subscription_email	✅	✅
_pronamic_subscription_end_date	✅	✅
_pronamic_subscription_expiry_date	✅	✅
_pronamic_subscription_key	❌	✅
_pronamic_subscription_mollie_customer_id	❌	✅
_pronamic_subscription_mollie_mandate_id	❌	✅
_pronamic_subscription_next_payment	✅	✅
_pronamic_subscription_next_payment_delivery_date	✅	✅
_pronamic_subscription_payment_method	❌	✅
_pronamic_subscription_source	❌	✅
_pronamic_subscription_source_id	❌	✅
_pronamic_subscription_start_date	✅ through fases	✅
_pronamic_subscription_status	✅	✅

#212 (comment)

[remcotolsma]

Nice to know:

SELECT
	ID,
	post_content->"$.customer.name",
	post_content
FROM
	wp_2_posts
WHERE
	post_type = 'pronamic_payment'
		AND
	post_mime_type = 'application/json'
		AND
	post_content->"$.total_amount.value" > 200
;