From 5fa8e57d6892e6e5361ce479f885765feb43e28d Mon Sep 17 00:00:00 2001 From: monishdeb Date: Thu, 10 Apr 2014 13:33:51 +0530 Subject: [PATCH] Minor change --- CRM/Report/Form/Event/ParticipantListCount.php | 2 +- CRM/Report/Form/Event/ParticipantListing.php | 5 ++--- 2 files changed, 3 insertions(+), 4 deletions(-) diff --git a/CRM/Report/Form/Event/ParticipantListCount.php b/CRM/Report/Form/Event/ParticipantListCount.php index b2d1904f10..06daf4293c 100644 --- a/CRM/Report/Form/Event/ParticipantListCount.php +++ b/CRM/Report/Form/Event/ParticipantListCount.php @@ -388,7 +388,7 @@ class CRM_Report_Form_Event_ParticipantListCount extends CRM_Report_Form_Event { ON {$this->_aliases['civicrm_contact']}.id = {$this->_aliases['civicrm_phone']}.contact_id AND {$this->_aliases['civicrm_phone']}.is_primary = 1 LEFT JOIN civicrm_line_item {$this->_aliases['civicrm_line_item']} - ON {$this->_aliases['civicrm_participant']}.id ={$this->_aliases['civicrm_line_item']}.entity_id AND {$this->_aliases['civicrm_line_item']}.entity_table = 'civicrm_participant'"; + ON {$this->_aliases['civicrm_line_item']}.entity_table = 'civicrm_participant' AND {$this->_aliases['civicrm_participant']}.id ={$this->_aliases['civicrm_line_item']}.entity_id"; } function storeWhereHavingClauseArray() { diff --git a/CRM/Report/Form/Event/ParticipantListing.php b/CRM/Report/Form/Event/ParticipantListing.php index 9657fef4fd..93dfdd58dc 100644 --- a/CRM/Report/Form/Event/ParticipantListing.php +++ b/CRM/Report/Form/Event/ParticipantListing.php @@ -495,9 +495,8 @@ GROUP BY cv.label if ($this->_lineitemField){ $this->_from .= " LEFT JOIN civicrm_line_item line_item_civireport - ON line_item_civireport.entity_id = {$this->_aliases['civicrm_participant']}.id AND - line_item_civireport.entity_table = 'civicrm_participant' - + ON line_item_civireport.entity_table = 'civicrm_participant' AND + line_item_civireport.entity_id = {$this->_aliases['civicrm_participant']}.id "; } } -- 2.25.1