Extend Formidable Forms entries list with Pronamic Pay payment info/status

[remcotolsma]

Requested today in the following two HelpScout tickets:

In het overzicht bij Formidable kan ik niet zien wie er al heeft betaald

Internal HelpScout ticket: https://secure.helpscout.net/conversation/1604299059/22548/

I have connected Pronamic pay to Formidable Form and use Mollie as my payment gateway. I want to retrieve the payment status of each form to display it in a column at the entry list of Formidable Form. This will allow our agents to know at a glance which paid requests need to be processed without having to check the payment status in Pronamic Pay or Mollie.

Internal HelpScout ticket: https://secure.helpscout.net/conversation/1604764244/22552?folderId=1425720

In the following Gist a quick solution:
https://gist.github.com/remcotolsma/9738e8830764b4e517565e920dffd893

[rvdsteege]

Instead of dumping the payment in the column, $payment->get_status_label() can be used to only display the status label.

Are there any drawbacks/concerns before adding this to the plugin?

[remcotolsma]

The gist https://gist.github.com/remcotolsma/9738e8830764b4e517565e920dffd893 will result in an extra WordPress query for each row in the Formidable Forms entries list table? With 20 Formidable Forms entries we will have 20 additional WordPress queries. Posts 2 Posts describes this challenge in the each_connected Wiki: https://github.com/scribu/wp-posts-to-posts/wiki/each_connected. In https://github.com/wp-pay-extensions/memberpress/blob/2d4e057192acdbac323d6b7dc181d278dce75a3a/src/Admin/AdminTransactions.php#L128-L187 and https://github.com/wp-pay-extensions/memberpress/blob/2d4e057192acdbac323d6b7dc181d278dce75a3a/src/Admin/AdminSubscriptions.php#L63-L121 I also had this challenge. Something for a next meeting to discuss?

[remcotolsma]

Could also be a solution for: https://secure.helpscout.net/conversation/1759176738/23337?folderId=1425710.

Dus zodra iemand zich inschrijft moet hij/zij ook hebben betaald. Als dit ook terug te vinden is in de inzendingen (niet van panoramic pay, maar van Formidable forms) is dit ook oké.

Want zodra iemand niet betaalt, wordt hij/zij ook niet ingeschreven.

Graag hoor ik of jullie hier een oplossing voor hebben, alvast bedankt!

[remcotolsma]

I noticed the following option in:

Save payment status in a field
If you would like to save the status of a payment in a field in your form, follow the instructions below.

• https://formidableforms.com/knowledgebase/stripe/
• https://formidableforms.com/knowledgebase/formidable-paypal/

[rvdsteege]

I received a customer inquiry about updating a field in the entry with the payment status and created a Gist for this, which might come in handy if we want to add support for e.g. the configurable payment status field update settings.

https://gist.github.com/rvdsteege/d3ca3af59e7ef1800eca22d206808681

Internal Help Scout ticket: https://secure.helpscout.net/conversation/2003549536/24449/