+--------------------------------------------------------------------+
| CiviCRM version 4.7 |
+--------------------------------------------------------------------+
+--------------------------------------------------------------------+
| CiviCRM version 4.7 |
+--------------------------------------------------------------------+
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_PseudoConstant::activityStatus(),
),
'priority_id' => array(
'title' => ts('Priority'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_PseudoConstant::activityStatus(),
),
'priority_id' => array(
'title' => ts('Priority'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_PseudoConstant::get('CRM_Activity_DAO_Activity', 'priority_id'),
),
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_PseudoConstant::get('CRM_Activity_DAO_Activity', 'priority_id'),
),
$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,