From 7179bf0a6bbaf424cb2891a86a67bdd4866584f7 Mon Sep 17 00:00:00 2001 From: Kurund Jalmi Date: Mon, 17 Aug 2015 10:54:00 +0530 Subject: [PATCH] CRM-16719: stats fixes --- CRM/Report/Form/ActivitySummary.php | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/CRM/Report/Form/ActivitySummary.php b/CRM/Report/Form/ActivitySummary.php index dd9caf11ab..b851dbd7d9 100644 --- a/CRM/Report/Form/ActivitySummary.php +++ b/CRM/Report/Form/ActivitySummary.php @@ -460,15 +460,15 @@ class CRM_Report_Form_ActivitySummary extends CRM_Report_Form { $actSQL = "SELECT COUNT(DISTINCT {$this->_aliases['civicrm_activity']}.activity_type_id ) as civicrm_activity_activity_type_id_count, - COUNT({$this->_aliases['civicrm_activity']}.activity_type_id ) as civicrm_activity_activity_type_count, + COUNT(DISTINCT {$this->_aliases['civicrm_activity']}.id ) as civicrm_activity_activity_id_count, SUM({$this->_aliases['civicrm_activity']}.duration ) as civicrm_activity_activity_duration - {$this->_from} {$this->_where}"; + {$this->_from} {$this->_where} {$this->_groupBy}"; $actDAO = CRM_Core_DAO::executeQuery($actSQL); while ($actDAO->fetch()) { $totalType += $actDAO->civicrm_activity_activity_type_id_count; - $totalActivity += $actDAO->civicrm_activity_activity_type_count; + $totalActivity += $actDAO->civicrm_activity_activity_id_count; $totalDuration += $actDAO->civicrm_activity_activity_duration; } -- 2.25.1