From cbef4d617f4e644e6ae09cba42fd0b0a62521721 Mon Sep 17 00:00:00 2001 From: Lars SG Date: Tue, 27 Apr 2021 09:37:47 -0600 Subject: [PATCH] Add contribution recurring column, group by, filter --- CRM/Report/Form/Contribute/Summary.php | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/CRM/Report/Form/Contribute/Summary.php b/CRM/Report/Form/Contribute/Summary.php index c73da90e77..c82396201c 100644 --- a/CRM/Report/Form/Contribute/Summary.php +++ b/CRM/Report/Form/Contribute/Summary.php @@ -142,6 +142,11 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { 'non_deductible_amount' => [ 'title' => ts('Non-deductible Amount'), ], + 'contribution_recur_id' => [ + 'title' => ts('Contribution Recurring'), + 'dbAlias' => '!ISNULL(contribution_civireport.contribution_recur_id)', + 'type' => CRM_Utils_Type::T_BOOLEAN, + ], ], 'grouping' => 'contri-fields', 'filters' => [ @@ -180,6 +185,17 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { 'options' => CRM_Contribute_PseudoConstant::contributionPage(), 'type' => CRM_Utils_Type::T_INT, ], + 'contribution_recur_id' => [ + 'title' => ts('Contribution Recurring'), + 'operatorType' => CRM_Report_Form::OP_SELECT, + 'type' => CRM_Utils_Type::T_BOOLEAN, + 'options' => [ + '' => ts('Any'), + TRUE => ts('Yes'), + FALSE => ts('No'), + ], + 'dbAlias' => '!ISNULL(contribution_civireport.contribution_recur_id)', + ], 'total_amount' => [ 'title' => ts('Contribution Amount'), ], @@ -225,6 +241,11 @@ class CRM_Report_Form_Contribute_Summary extends CRM_Report_Form { 'options' => CRM_Contribute_PseudoConstant::contributionPage(), 'type' => CRM_Utils_Type::T_INT, ], + 'contribution_recur_id' => [ + 'title' => ts('Contribution Recurring'), + 'type' => CRM_Utils_Type::T_BOOLEAN, + 'dbAlias' => '!ISNULL(contribution_civireport.contribution_recur_id)', + ], ], ], 'civicrm_financial_trxn' => [ -- 2.25.1