<?php
/*
+--------------------------------------------------------------------+
- | CiviCRM version 4.6 |
+ | CiviCRM version 4.7 |
+--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2015 |
+ | Copyright CiviCRM LLC (c) 2004-2016 |
+--------------------------------------------------------------------+
| This file is a part of CiviCRM. |
| |
/**
*
* @package CRM
- * @copyright CiviCRM LLC (c) 2004-2015
+ * @copyright CiviCRM LLC (c) 2004-2016
* $Id$
*
*/
'sid' => array(
'name' => 'status_id',
'title' => ts('Participant Status'),
+ 'type' => CRM_Utils_Type::T_INT,
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Event_PseudoConstant::participantStatus(NULL, NULL, 'label'),
),
'name' => 'role_id',
'title' => ts('Participant Role'),
'operatorType' => CRM_Report_Form::OP_MULTISELECT_SEPARATOR,
+ 'type' => CRM_Utils_Type::T_INT,
'options' => CRM_Event_PseudoConstant::participantRole(),
),
'participant_register_date' => array(
'eid' => array(
'name' => 'event_type_id',
'title' => ts('Event Type'),
+ 'type' => CRM_Utils_Type::T_INT,
'operatorType' => CRM_Report_Form::OP_MULTISELECT,
'options' => CRM_Core_OptionGroup::values('event_type'),
),
'event_start_date' => array(
- 'name' => 'start_date',
+ 'name' => 'event_start_date',
'title' => ts('Event Start Date'),
'operatorType' => CRM_Report_Form::OP_DATE,
),
'event_end_date' => array(
- 'name' => 'end_date',
+ 'name' => 'event_end_date',
'title' => ts('Event End Date'),
'operatorType' => CRM_Report_Form::OP_DATE,
),
$this->_columnHeaders["blank_{$i}"]['title'] = "_ _ _ _";
}
}
+ $this->_selectClauses = $select;
$this->_select = "SELECT " . implode(', ', $select) . " ";
}
parent::groupBy();
if (empty($this->_groupBy)) {
$this->_groupBy = "GROUP BY {$this->_aliases['civicrm_participant']}.id";
+ $this->_groupBy .= CRM_Contact_BAO_Query::getGroupByFromSelectColumns($this->_selectClauses, "{$this->_aliases['civicrm_participant']}.id");
}
}