From d34263912b7e62a75e100496d8f9cf5f00a74897 Mon Sep 17 00:00:00 2001 From: Edsel Date: Thu, 23 Apr 2015 17:51:12 +0530 Subject: [PATCH] CIVI-28 Contribution count tab modified --- CRM/Contribute/BAO/Contribution.php | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) diff --git a/CRM/Contribute/BAO/Contribution.php b/CRM/Contribute/BAO/Contribution.php index 70fc765036..5570fbe299 100644 --- a/CRM/Contribute/BAO/Contribution.php +++ b/CRM/Contribute/BAO/Contribution.php @@ -1886,11 +1886,15 @@ LEFT JOIN civicrm_contribution contribution ON ( componentPayment.contribution_ if (!$contactId) { return 0; } + CRM_Financial_BAO_FinancialType::getAvailableFinancialTypes($financialTypes); $contactContributionsSQL = " SELECT contribution.id AS id FROM civicrm_contribution contribution - WHERE contribution.is_test = 0 AND contribution.contact_id = {$contactId} "; + LEFT JOIN civicrm_line_item i ON i.contribution_id = contribution.id AND i.entity_table = 'civicrm_contribution' + WHERE contribution.is_test = 0 AND contribution.contact_id = {$contactId} + AND contribution.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") + AND i.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") "; $contactSoftCreditContributionsSQL = " SELECT contribution.id -- 2.25.1