From 6e28570c65a15e510b4ddb362c35e9108502cda9 Mon Sep 17 00:00:00 2001 From: Jaap Jansma Date: Mon, 31 May 2021 11:43:21 +0200 Subject: [PATCH] dev/financial#6 exclude template contributions from the contact summary and add a button to view them to the recurring contributions tab --- CRM/Contribute/BAO/Contribution.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Contribute/BAO/Contribution.php b/CRM/Contribute/BAO/Contribution.php index c65146e7a8..47b5ae4f60 100644 --- a/CRM/Contribute/BAO/Contribution.php +++ b/CRM/Contribute/BAO/Contribution.php @@ -2430,7 +2430,7 @@ LEFT JOIN civicrm_contribution contribution ON ( componentPayment.contribution_ SELECT contribution.id AS id FROM civicrm_contribution contribution LEFT JOIN civicrm_line_item i ON i.contribution_id = contribution.id AND i.entity_table = 'civicrm_contribution' $liWhere - WHERE contribution.is_test = 0 AND contribution.contact_id = {$contactId} + WHERE contribution.is_test = 0 AND contribution.is_template != '1' AND contribution.contact_id = {$contactId} $additionalWhere AND i.id IS NULL"; @@ -2438,7 +2438,7 @@ LEFT JOIN civicrm_contribution contribution ON ( componentPayment.contribution_ SELECT contribution.id FROM civicrm_contribution contribution INNER JOIN civicrm_contribution_soft softContribution ON ( contribution.id = softContribution.contribution_id ) - WHERE contribution.is_test = 0 AND softContribution.contact_id = {$contactId} "; + WHERE contribution.is_test = 0 AND contribution.is_template != '1' AND softContribution.contact_id = {$contactId} "; $query = "SELECT count( x.id ) count FROM ( "; $query .= $contactContributionsSQL; -- 2.25.1