/** * Build the class, adjusting the settings as compared to the main report. */ public function __construct() { parent::__construct(); $this->_autoIncludeIndexedFieldsAsOrderBys = 0; // Unset some defaults: $this->_columns['civicrm_phone']['fields']['phone']['default'] = FALSE; $this->_columns['civicrm_participant']['fields']['event_id']['default'] = FALSE; $this->_columns['civicrm_participant']['fields']['status_id']['default'] = FALSE; $this->_columns['civicrm_contribution']['fields']['contribution_status_id']['default'] = FALSE; if (array_key_exists('campaign_id', $this->_columns['civicrm_participant']['fields'])) { $this->_columns['civicrm_participant']['fields']['campaign_id']['default'] = FALSE; } $this->_columns['civicrm_event']['filters']['event_start_date']['default'] = 'this.year'; $this->_columns['civicrm_event']['fields']['event_id_hidden'] = array('name' => 'id', 'title' => ts('Event ID'), 'no_display' => TRUE, 'required' => TRUE); $this->_columns['civicrm_event']['fields']['event_start_date_month'] = array('title' => ts('Event Start Month'), 'dbAlias' => 'DATE_FORMAT(event_civireport.start_date, "%Y%m")', 'no_display' => TRUE, 'required' => TRUE); foreach ($this->_columns as $tableName => $table) { if (array_key_exists('order_bys', $table)) { unset($this->_columns[$tableName]['order_bys']); } } $this->_options = array(); }