$this->_groupBy = array();
if (!empty($this->_params['group_bys']) &&
is_array($this->_params['group_bys'])) {
$this->_groupBy = array();
if (!empty($this->_params['group_bys']) &&
is_array($this->_params['group_bys'])) {
// build the query to calulate duration sum
$sql = "SELECT SUM(activity_civireport.duration) as civicrm_activity_duration_total {$this->_from} {$this->_where} {$this->_groupBy} {$this->_having} {$this->_orderBy} {$this->_limit}";
// build the query to calulate duration sum
$sql = "SELECT SUM(activity_civireport.duration) as civicrm_activity_duration_total {$this->_from} {$this->_where} {$this->_groupBy} {$this->_having} {$this->_orderBy} {$this->_limit}";
public function modifyColumnHeaders() {
//CRM-16719 modify name of column
if (!empty($this->_columnHeaders['civicrm_activity_status_id'])) {
public function modifyColumnHeaders() {
//CRM-16719 modify name of column
if (!empty($this->_columnHeaders['civicrm_activity_status_id'])) {
$url = implode('&', $url);
$url = CRM_Report_Utils_Report::getNextUrl('activity', "reset=1&force=1&{$url}",
$this->_absoluteUrl,
$url = implode('&', $url);
$url = CRM_Report_Utils_Report::getNextUrl('activity', "reset=1&force=1&{$url}",
$this->_absoluteUrl,