From 74fdd414e2abc89748979289642a955f823179e0 Mon Sep 17 00:00:00 2001 From: Dave Greenberg Date: Tue, 7 Oct 2014 10:25:56 -0700 Subject: [PATCH] CRM-15374 - adjust query in getPaymentInfo to prevent extraneous fee-related rows showing up in Payment Info page. ---------------------------------------- * CRM-15374: https://issues.civicrm.org/jira/browse/CRM-15374 --- CRM/Contribute/BAO/Contribution.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Contribute/BAO/Contribution.php b/CRM/Contribute/BAO/Contribution.php index fde8e741e6..5c9dc2d9b9 100644 --- a/CRM/Contribute/BAO/Contribution.php +++ b/CRM/Contribute/BAO/Contribution.php @@ -3409,7 +3409,7 @@ WHERE eft.financial_trxn_id IN ({$trxnId}, {$baseTrxnId['financialTrxnId']}) SELECT ft.total_amount, con.financial_type_id, ft.payment_instrument_id, ft.trxn_date, ft.trxn_id, ft.status_id, ft.check_number FROM civicrm_contribution con LEFT JOIN civicrm_entity_financial_trxn eft ON (eft.entity_id = con.id AND eft.entity_table = 'civicrm_contribution') - LEFT JOIN civicrm_financial_trxn ft ON ft.id = eft.financial_trxn_id AND ft.to_financial_account_id != {$feeFinancialAccount} + INNER JOIN civicrm_financial_trxn ft ON ft.id = eft.financial_trxn_id AND ft.to_financial_account_id != {$feeFinancialAccount} WHERE con.id = {$contributionId} "; -- 2.25.1