From 343c715059a7b276cae9d515547d45d38abb1ab8 Mon Sep 17 00:00:00 2001 From: seamuslee001 Date: Thu, 27 Feb 2014 10:23:02 +1100 Subject: [PATCH] Fix CRM-1475 membership contribution-detail report Fix the membership and contribution detail report when being used with ACLs see CRM-1475 --- CRM/Report/Form/Member/ContributionDetail.php | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/CRM/Report/Form/Member/ContributionDetail.php b/CRM/Report/Form/Member/ContributionDetail.php index 27bded09b0..a1ff802144 100644 --- a/CRM/Report/Form/Member/ContributionDetail.php +++ b/CRM/Report/Form/Member/ContributionDetail.php @@ -492,6 +492,7 @@ class CRM_Report_Form_Member_ContributionDetail extends CRM_Report_Form { LEFT JOIN civicrm_membership_status {$this->_aliases['civicrm_membership_status']} ON {$this->_aliases['civicrm_membership_status']}.id = {$this->_aliases['civicrm_membership']}.status_id + {$this->_aclFrom} "; //for premiums @@ -562,10 +563,10 @@ class CRM_Report_Form_Member_ContributionDetail extends CRM_Report_Form { $fillTemp = " INSERT INTO civireport_membership_contribution_detail (contribution_id, contact_id, membership_id) - SELECT contribution.id, contact.id, m.id + SELECT contribution.id, {$this->_aliases['civicrm_contact']}.id, m.id FROM civicrm_contribution contribution - INNER JOIN civicrm_contact contact - ON contact.id = contribution.contact_id AND contribution.is_test = 0 + INNER JOIN civicrm_contact {$this->_aliases['civicrm_contact']} + ON {$this->_aliases['civicrm_contact']}.id = contribution.contact_id AND contribution.is_test = 0 {$this->_aclFrom} LEFT JOIN civicrm_membership_payment mp ON contribution.id = mp.contribution_id -- 2.25.1