$view = new view(); $view->name = 'contact_by_source'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_contact'; $view->human_name = 'Contact by source'; $view->core = 7; $view->api_version = '3.0'; $view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */ /* Display: Master */ $handler = $view->new_display('default', 'Master', 'default'); $handler->display->display_options['title'] = 'Contact by source'; $handler->display->display_options['use_more_always'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['access']['type'] = 'role'; $handler->display->display_options['access']['role'] = array( 3 => '3', ); $handler->display->display_options['cache']['type'] = 'none'; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['exposed_form']['type'] = 'basic'; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '100'; $handler->display->display_options['style_plugin'] = 'table'; /* Field: CiviCRM Contacts: Contact ID */ $handler->display->display_options['fields']['id']['id'] = 'id'; $handler->display->display_options['fields']['id']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['id']['field'] = 'id'; /* Field: CiviCRM Contacts: Created Date */ $handler->display->display_options['fields']['created_date']['id'] = 'created_date'; $handler->display->display_options['fields']['created_date']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['created_date']['field'] = 'created_date'; $handler->display->display_options['fields']['created_date']['date_format'] = 'custom'; $handler->display->display_options['fields']['created_date']['custom_date_format'] = 'M Y'; $handler->display->display_options['fields']['created_date']['second_date_format'] = 'search_api_facetapi_YEAR'; /* Field: CiviCRM Contacts: Source of Contact Data */ $handler->display->display_options['fields']['source']['id'] = 'source'; $handler->display->display_options['fields']['source']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['source']['field'] = 'source'; /* Sort criterion: CiviCRM Contacts: Created Date */ $handler->display->display_options['sorts']['created_date']['id'] = 'created_date'; $handler->display->display_options['sorts']['created_date']['table'] = 'civicrm_contact'; $handler->display->display_options['sorts']['created_date']['field'] = 'created_date'; $handler->display->display_options['sorts']['created_date']['granularity'] = 'month'; /* Filter criterion: CiviCRM Contacts: Source of Contact Data */ $handler->display->display_options['filters']['source']['id'] = 'source'; $handler->display->display_options['filters']['source']['table'] = 'civicrm_contact'; $handler->display->display_options['filters']['source']['field'] = 'source'; $handler->display->display_options['filters']['source']['operator'] = 'not empty'; /* Filter criterion: CiviCRM Contacts: Created Date */ $handler->display->display_options['filters']['created_date']['id'] = 'created_date'; $handler->display->display_options['filters']['created_date']['table'] = 'civicrm_contact'; $handler->display->display_options['filters']['created_date']['field'] = 'created_date'; $handler->display->display_options['filters']['created_date']['operator'] = 'between'; $handler->display->display_options['filters']['created_date']['value']['min'] = '2016-01-01'; $handler->display->display_options['filters']['created_date']['value']['max'] = '2016-06-01'; $handler->display->display_options['filters']['created_date']['exposed'] = TRUE; $handler->display->display_options['filters']['created_date']['expose']['operator_id'] = 'created_date_op'; $handler->display->display_options['filters']['created_date']['expose']['label'] = 'Created Date'; $handler->display->display_options['filters']['created_date']['expose']['operator'] = 'created_date_op'; $handler->display->display_options['filters']['created_date']['expose']['identifier'] = 'created_date'; $handler->display->display_options['filters']['created_date']['expose']['remember_roles'] = array( 2 => '2', 1 => 0, 8 => 0, 5 => 0, 4 => 0, 6 => 0, 7 => 0, 3 => 0, ); /* Display: Aggregated */ $handler = $view->new_display('page', 'Aggregated', 'page'); $handler->display->display_options['path'] = 'admin/civi-contact-by-source-aggregation'; /* Display: Pivot */ $handler = $view->new_display('page', 'Pivot', 'page_1'); $handler->display->display_options['defaults']['group_by'] = FALSE; $handler->display->display_options['group_by'] = TRUE; $handler->display->display_options['defaults']['style_plugin'] = FALSE; $handler->display->display_options['style_plugin'] = 'views_pivot'; $handler->display->display_options['style_options']['columns'] = array( 'created_date' => 'created_date', 'source' => 'source', 'id' => 'id', 'nothing' => 'nothing', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'created_date' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, 'pivot_row_extra' => 0, 'pivot_row_aggregate' => 'sum', 'pivot_row_aggregate_label' => '', 'pivot_col_aggregate' => 'sum', 'pivot_col_aggregate_label' => '', ), 'source' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, 'pivot_row_extra' => 0, 'pivot_row_aggregate' => 'sum', 'pivot_row_aggregate_label' => '', 'pivot_col_aggregate' => 'sum', 'pivot_col_aggregate_label' => '', ), 'id' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, 'pivot_row_extra' => 0, 'pivot_row_aggregate' => 'sum', 'pivot_row_aggregate_label' => 'Total', 'pivot_col_aggregate' => 'sum', 'pivot_col_aggregate_label' => 'Total', ), 'nothing' => array( 'align' => '', 'separator' => '', 'empty_column' => 0, 'pivot_row_extra' => 0, 'pivot_row_aggregate' => '0', 'pivot_row_aggregate_label' => '', 'pivot_col_aggregate' => '0', 'pivot_col_aggregate_label' => '', ), ); $handler->display->display_options['style_options']['pivot_col'] = 'source'; $handler->display->display_options['style_options']['pivot_row'] = 'created_date'; $handler->display->display_options['style_options']['pivot_mode_multi_values'] = '0'; $handler->display->display_options['defaults']['style_options'] = FALSE; $handler->display->display_options['defaults']['row_plugin'] = FALSE; $handler->display->display_options['row_plugin'] = 'fields'; $handler->display->display_options['defaults']['row_options'] = FALSE; $handler->display->display_options['defaults']['fields'] = FALSE; /* Field: CiviCRM Contacts: Created Date */ $handler->display->display_options['fields']['created_date']['id'] = 'created_date'; $handler->display->display_options['fields']['created_date']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['created_date']['field'] = 'created_date'; $handler->display->display_options['fields']['created_date']['date_format'] = 'custom'; $handler->display->display_options['fields']['created_date']['custom_date_format'] = 'M Y'; $handler->display->display_options['fields']['created_date']['second_date_format'] = 'search_api_facetapi_YEAR'; /* Field: CiviCRM Contacts: Source of Contact Data */ $handler->display->display_options['fields']['source']['id'] = 'source'; $handler->display->display_options['fields']['source']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['source']['field'] = 'source'; /* Field: COUNT(CiviCRM Contacts: Contact ID) */ $handler->display->display_options['fields']['id']['id'] = 'id'; $handler->display->display_options['fields']['id']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['id']['field'] = 'id'; $handler->display->display_options['fields']['id']['group_type'] = 'count'; $handler->display->display_options['fields']['id']['label'] = ''; $handler->display->display_options['fields']['id']['alter']['alter_text'] = TRUE; $handler->display->display_options['fields']['id']['alter']['text'] = '1'; $handler->display->display_options['fields']['id']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['id']['separator'] = ''; /* Field: Global: Custom text */ $handler->display->display_options['fields']['nothing']['id'] = 'nothing'; $handler->display->display_options['fields']['nothing']['table'] = 'views'; $handler->display->display_options['fields']['nothing']['field'] = 'nothing'; $handler->display->display_options['fields']['nothing']['exclude'] = TRUE; $handler->display->display_options['fields']['nothing']['alter']['text'] = '[id] '; $handler->display->display_options['path'] = 'admin/civi-contact-month-by-source-pivot'; /* Display: List */ $handler = $view->new_display('block', 'List', 'block_1'); $handler->display->display_options['defaults']['group_by'] = FALSE;