From f560446624d2f4f8d8a59ae891d0f3bb19846817 Mon Sep 17 00:00:00 2001 From: Edsel Date: Mon, 11 May 2015 17:07:06 +0530 Subject: [PATCH] ICM-13 Modified LYBUNT report to use temp table instead of modifiication to query --- CRM/Report/Form/Contribute/Lybunt.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php index 5271ca19aa..d73b9dc25e 100644 --- a/CRM/Report/Form/Contribute/Lybunt.php +++ b/CRM/Report/Form/Contribute/Lybunt.php @@ -388,8 +388,10 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { $sql = "CREATE TEMPORARY TABLE civicrm_contribution_temp AS SELECT {$this->_aliases['civicrm_contribution']}.id {$this->_from} 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' {$this->_where} AND - {$this->_aliases['civicrm_contribution']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") + {$this->_aliases['civicrm_line_item']}.entity_table = 'civicrm_contribution' + {$this->_where} + AND {$this->_aliases['civicrm_contribution']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") + AND {$this->_aliases['civicrm_line_item']}.financial_type_id IN (" . implode(',' , array_keys($financialTypes)) . ") GROUP BY {$this->_aliases['civicrm_contribution']}.id"; CRM_Core_DAO::executeQuery($sql); $this->_from .= " INNER JOIN civicrm_contribution_temp temp ON {$this->_aliases['civicrm_contribution']}.id = temp.id "; -- 2.25.1