From a4954f73f23d4d3b103bb2c6c7b453e96160a1dc Mon Sep 17 00:00:00 2001 From: pratikshad Date: Thu, 12 Feb 2015 19:02:37 +1000 Subject: [PATCH] CRM-15935 Fixed issue of Lybunt report includes people who made no contributions ---------------------------------------- * CRM-15935: Lybunt report includes people who made no contributions https://issues.civicrm.org/jira/browse/CRM-15935 --- CRM/Report/Form/Contribute/Lybunt.php | 7 +------ 1 file changed, 1 insertion(+), 6 deletions(-) diff --git a/CRM/Report/Form/Contribute/Lybunt.php b/CRM/Report/Form/Contribute/Lybunt.php index 0fd0009b6a..518db5bc97 100644 --- a/CRM/Report/Form/Contribute/Lybunt.php +++ b/CRM/Report/Form/Contribute/Lybunt.php @@ -267,12 +267,7 @@ class CRM_Report_Form_Contribute_Lybunt extends CRM_Report_Form { foreach ($table['filters'] as $fieldName => $field) { $clause = NULL; if ($fieldName == 'yid') { - $clause = "contribution_civireport.contact_id NOT IN -(SELECT distinct contri.contact_id FROM civicrm_contribution contri - WHERE contri.is_test = 0 AND " . - self::fiscalYearOffset('contri.receive_date') . " = $current_year) AND contribution_civireport.contact_id IN (SELECT distinct contri.contact_id FROM civicrm_contribution contri - WHERE " . self::fiscalYearOffset('contri.receive_date') . - " = $previous_year AND contri.is_test = 0)"; + $clause = self::fiscalYearOffset('contribution_civireport.receive_date') ." = $previous_year"; } elseif (CRM_Utils_Array::value('type', $field) & CRM_Utils_Type::T_DATE ) { -- 2.25.1