Added join types for joining mandate on either contribtion or contribution recur - Githubissues

Project60 / org.project60.sepa

SEPA direct debit integration with civicrm

19 stars 46 forks source link

Added join types for joining mandate on either contribtion or contribution recur #688

Closed jaapjansma closed 7 months ago

jaapjansma commented 7 months ago

The mandate table has a field called entity_table and a field entity_id. Depending on the value in entity_table we can join the mandate to a contribution recur or to a contribution.

This PR makes this possible to provide additional join types to the data processor.

New join types

Join Sepa Mandate on Contribution
Join Sepa Mandata on Contribution Recur

See screenshots below for those two join types:

2023-11-16_09-55 2023-11-16_09-54