From 0e362aadf738d35ab84df3f1b6b159471b1ca911 Mon Sep 17 00:00:00 2001 From: Pradeep Nayak Date: Tue, 2 Jul 2019 09:43:48 +0100 Subject: [PATCH] Grab contribution status id from database --- CRM/PCP/BAO/PCP.php | 12 ++++++++++-- 1 file changed, 10 insertions(+), 2 deletions(-) diff --git a/CRM/PCP/BAO/PCP.php b/CRM/PCP/BAO/PCP.php index 367fa10429..b81189da64 100644 --- a/CRM/PCP/BAO/PCP.php +++ b/CRM/PCP/BAO/PCP.php @@ -224,14 +224,22 @@ ORDER BY target_entity_type, target_entity_id * Total amount */ public static function thermoMeter($pcpId) { + $completedStatusId = CRM_Core_PseudoConstant::getKey( + 'CRM_Contribute_BAO_Contribution', + 'contribution_status_id', + 'Completed' + ); $query = " SELECT SUM(cc.total_amount) as total FROM civicrm_pcp pcp LEFT JOIN civicrm_contribution_soft cs ON ( pcp.id = cs.pcp_id ) LEFT JOIN civicrm_contribution cc ON ( cs.contribution_id = cc.id) -WHERE pcp.id = %1 AND cc.contribution_status_id =1 AND cc.is_test = 0"; +WHERE pcp.id = %1 AND cc.contribution_status_id = %2 AND cc.is_test = 0"; - $params = [1 => [$pcpId, 'Integer']]; + $params = [ + 1 => [$pcpId, 'Integer'], + 2 => [$completedStatusId, 'Integer'], + ]; return CRM_Core_DAO::singleValueQuery($query, $params); } -- 2.25.1