From f86a797b0148cca78717624ae5e725d0478d6bd0 Mon Sep 17 00:00:00 2001 From: Edsel Date: Thu, 21 May 2015 18:43:11 +0530 Subject: [PATCH] ICM-1 Fixed contribution summary report to use temporary table approach rather than modifying query --- CRM/Report/Form/Contribute/Summary.php | 6 +----- 1 file changed, 1 insertion(+), 5 deletions(-) diff --git a/CRM/Report/Form/Contribute/Summary.php b/CRM/Report/Form/Contribute/Summary.php index dedda88088..50f3d283b1 100644 --- a/CRM/Report/Form/Contribute/Summary.php +++ b/CRM/Report/Form/Contribute/Summary.php @@ -453,9 +453,6 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { LEFT JOIN civicrm_email {$this->_aliases['civicrm_email']} ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_email']}.contact_id AND {$this->_aliases['civicrm_email']}.is_primary = 1) - LEFT JOIN civicrm_line_item {$this->_aliases['civicrm_line_item']} - ON {$this->_aliases['civicrm_contribution']}.id = {$this->_aliases['civicrm_line_item']}.contribution_id AND - {$this->_aliases['civicrm_line_item']}.entity_table = 'civicrm_contribution' LEFT JOIN civicrm_phone {$this->_aliases['civicrm_phone']} ON ({$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND @@ -468,6 +465,7 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { {$this->_aliases['civicrm_address']}.contact_id AND {$this->_aliases['civicrm_address']}.is_primary = 1\n"; } + $this->getPermissionedFTQuery($this); } /** @@ -663,8 +661,6 @@ ROUND(AVG({$this->_aliases['civicrm_contribution_soft']}.amount), 2) as civicrm_ */ public function postProcess() { $this->buildACLClause($this->_aliases['civicrm_contact']); - CRM_Financial_BAO_FinancialType::buildPermissionedClause($this->_whereClauses, NULL, $this->_aliases['civicrm_contribution']); - CRM_Financial_BAO_FinancialType::buildPermissionedClause($this->_whereClauses, NULL, $this->_aliases['civicrm_line_item']); parent::postProcess(); } -- 2.25.1