From ea00b88720837cfefa946cb90d1bed58efd18f79 Mon Sep 17 00:00:00 2001 From: Edsel Date: Thu, 16 Mar 2017 14:25:36 +0530 Subject: [PATCH] CRM-20272 Removed line break ---------------------------------------- * CRM-20272: Add credit card type field for Contribution Summary Report https://issues.civicrm.org/jira/browse/CRM-20272 --- CRM/Report/Form/Contribute/Summary.php | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) diff --git a/CRM/Report/Form/Contribute/Summary.php b/CRM/Report/Form/Contribute/Summary.php index 59e66b11b0..33cdec1e55 100644 --- a/CRM/Report/Form/Contribute/Summary.php +++ b/CRM/Report/Form/Contribute/Summary.php @@ -535,11 +535,12 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { // for credit card type if ($this->isTableSelected('civicrm_financial_trxn')) { - $this->_from .= "\n LEFT JOIN civicrm_entity_financial_trxn eftcc - ON ({$this->_aliases['civicrm_contribution']}.id = eftcc.entity_id AND - eftcc.entity_table = 'civicrm_contribution') - LEFT JOIN civicrm_financial_trxn {$this->_aliases['civicrm_financial_trxn']} - ON {$this->_aliases['civicrm_financial_trxn']}.id = eftcc.financial_trxn_id"; + $this->_from .= " + LEFT JOIN civicrm_entity_financial_trxn eftcc + ON ({$this->_aliases['civicrm_contribution']}.id = eftcc.entity_id AND + eftcc.entity_table = 'civicrm_contribution') + LEFT JOIN civicrm_financial_trxn {$this->_aliases['civicrm_financial_trxn']} + ON {$this->_aliases['civicrm_financial_trxn']}.id = eftcc.financial_trxn_id"; } } -- 2.25.1