$view = new view(); $view->name = 'clients_civi_pages'; $view->description = ''; $view->tag = 'default'; $view->base_table = 'civicrm_contact'; $view->human_name = 'clients civi pages'; $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'] = 'clients civi pages'; $handler->display->display_options['use_more_always'] = FALSE; $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'] = '10'; $handler->display->display_options['style_plugin'] = 'default'; $handler->display->display_options['row_plugin'] = 'fields'; /* Header: Global: Text area */ $handler->display->display_options['header']['area']['id'] = 'area'; $handler->display->display_options['header']['area']['table'] = 'views'; $handler->display->display_options['header']['area']['field'] = 'area'; $handler->display->display_options['header']['area']['content'] = 'This is a demonstration View that is part of Fuzion\'s treasure trove of useful things for CiviCRM and Drupal developments.

'; $handler->display->display_options['header']['area']['format'] = 'full_html'; /* 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'; $handler->display->display_options['fields']['id']['label'] = ''; $handler->display->display_options['fields']['id']['exclude'] = TRUE; $handler->display->display_options['fields']['id']['element_label_colon'] = FALSE; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name']['id'] = 'display_name'; $handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 0; /* Sort criterion: CiviCRM Contacts: Display Name */ $handler->display->display_options['sorts']['display_name']['id'] = 'display_name'; $handler->display->display_options['sorts']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['sorts']['display_name']['field'] = 'display_name'; /* Contextual filter: CiviCRM Contacts: Display Name */ $handler->display->display_options['arguments']['display_name']['id'] = 'display_name'; $handler->display->display_options['arguments']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['arguments']['display_name']['field'] = 'display_name'; $handler->display->display_options['arguments']['display_name']['default_action'] = 'default'; $handler->display->display_options['arguments']['display_name']['default_argument_type'] = 'raw'; $handler->display->display_options['arguments']['display_name']['default_argument_options']['index'] = '1'; $handler->display->display_options['arguments']['display_name']['summary']['number_of_records'] = '0'; $handler->display->display_options['arguments']['display_name']['summary']['format'] = 'default_summary'; $handler->display->display_options['arguments']['display_name']['summary_options']['items_per_page'] = '25'; $handler->display->display_options['arguments']['display_name']['limit'] = '0'; /* Filter criterion: CiviCRM Contacts: Contact Type */ $handler->display->display_options['filters']['contact_type']['id'] = 'contact_type'; $handler->display->display_options['filters']['contact_type']['table'] = 'civicrm_contact'; $handler->display->display_options['filters']['contact_type']['field'] = 'contact_type'; $handler->display->display_options['filters']['contact_type']['value'] = array( 'Organization' => 'Organization', ); /* Filter criterion: CiviCRM Contacts: Is Deleted */ $handler->display->display_options['filters']['is_deleted']['id'] = 'is_deleted'; $handler->display->display_options['filters']['is_deleted']['table'] = 'civicrm_contact'; $handler->display->display_options['filters']['is_deleted']['field'] = 'is_deleted'; $handler->display->display_options['filters']['is_deleted']['value'] = '0'; /* Filter criterion: CiviCRM Tags: Name */ $handler->display->display_options['filters']['name']['id'] = 'name'; $handler->display->display_options['filters']['name']['table'] = 'civicrm_tag'; $handler->display->display_options['filters']['name']['field'] = 'name'; $handler->display->display_options['filters']['name']['value'] = array( 7 => '7', ); /* Display: List of Civi Orgs */ $handler = $view->new_display('page', 'List of Civi Orgs', 'page_1'); $handler->display->display_options['defaults']['title'] = FALSE; $handler->display->display_options['title'] = 'List of organisations (example of View displaying CiviCRM contacts)'; $handler->display->display_options['defaults']['pager'] = FALSE; $handler->display->display_options['pager']['type'] = 'full'; $handler->display->display_options['pager']['options']['items_per_page'] = '50'; $handler->display->display_options['pager']['options']['offset'] = '0'; $handler->display->display_options['pager']['options']['id'] = '0'; $handler->display->display_options['pager']['options']['quantity'] = '9'; $handler->display->display_options['defaults']['style_plugin'] = FALSE; $handler->display->display_options['style_plugin'] = 'table'; $handler->display->display_options['style_options']['columns'] = array( 'id' => 'id', 'display_name' => 'display_name', 'country' => 'country', ); $handler->display->display_options['style_options']['default'] = '-1'; $handler->display->display_options['style_options']['info'] = array( 'id' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'display_name' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), 'country' => array( 'sortable' => 0, 'default_sort_order' => 'asc', 'align' => '', 'separator' => '', 'empty_column' => 0, ), ); $handler->display->display_options['defaults']['style_options'] = FALSE; $handler->display->display_options['defaults']['row_plugin'] = FALSE; $handler->display->display_options['defaults']['row_options'] = FALSE; $handler->display->display_options['defaults']['fields'] = FALSE; /* 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'; $handler->display->display_options['fields']['id']['label'] = ''; $handler->display->display_options['fields']['id']['exclude'] = TRUE; $handler->display->display_options['fields']['id']['element_label_colon'] = FALSE; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name']['id'] = 'display_name'; $handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name']['label'] = 'Organisation Name'; $handler->display->display_options['fields']['display_name']['alter']['make_link'] = TRUE; $handler->display->display_options['fields']['display_name']['alter']['path'] = 'civi-orgs/[display_name]'; $handler->display->display_options['fields']['display_name']['element_label_colon'] = FALSE; $handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 0; /* Field: CiviCRM Address: Country */ $handler->display->display_options['fields']['country']['id'] = 'country'; $handler->display->display_options['fields']['country']['table'] = 'civicrm_address'; $handler->display->display_options['fields']['country']['field'] = 'country'; /* Field: CiviCRM Custom: Client info: Clients since */ $handler->display->display_options['fields']['clients_since_47']['id'] = 'clients_since_47'; $handler->display->display_options['fields']['clients_since_47']['table'] = 'civicrm_value_client_info_7'; $handler->display->display_options['fields']['clients_since_47']['field'] = 'clients_since_47'; $handler->display->display_options['fields']['clients_since_47']['date_format'] = 'custom'; $handler->display->display_options['fields']['clients_since_47']['custom_date_format'] = 'Y'; $handler->display->display_options['fields']['clients_since_47']['second_date_format'] = 'long'; $handler->display->display_options['defaults']['arguments'] = FALSE; $handler->display->display_options['path'] = 'civi-orgs/list'; /* Display: Civi Org page */ $handler = $view->new_display('page', 'Civi Org page', 'page'); $handler->display->display_options['defaults']['title'] = FALSE; $handler->display->display_options['title'] = 'Display page for specific CiviCRM organisation (example of View with Contextual filter)'; $handler->display->display_options['defaults']['query'] = FALSE; $handler->display->display_options['query']['type'] = 'views_query'; $handler->display->display_options['query']['options']['distinct'] = TRUE; $handler->display->display_options['defaults']['fields'] = FALSE; /* 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'; $handler->display->display_options['fields']['id']['label'] = 'CiviID'; $handler->display->display_options['fields']['id']['exclude'] = TRUE; $handler->display->display_options['fields']['id']['separator'] = ''; /* Field: CiviCRM Contacts: Display Name */ $handler->display->display_options['fields']['display_name']['id'] = 'display_name'; $handler->display->display_options['fields']['display_name']['table'] = 'civicrm_contact'; $handler->display->display_options['fields']['display_name']['field'] = 'display_name'; $handler->display->display_options['fields']['display_name']['label'] = 'Org name'; $handler->display->display_options['fields']['display_name']['link_to_civicrm_contact'] = 0; /* Field: CiviCRM Address: Country */ $handler->display->display_options['fields']['country']['id'] = 'country'; $handler->display->display_options['fields']['country']['table'] = 'civicrm_address'; $handler->display->display_options['fields']['country']['field'] = 'country'; $handler->display->display_options['fields']['country']['location_type'] = '0'; $handler->display->display_options['fields']['country']['location_op'] = '0'; $handler->display->display_options['fields']['country']['is_primary'] = 1; $handler->display->display_options['fields']['country']['is_billing'] = 0; $handler->display->display_options['fields']['country']['country_display'] = '2'; /* Field: CiviCRM Custom: Client info: Clients since */ $handler->display->display_options['fields']['clients_since_47']['id'] = 'clients_since_47'; $handler->display->display_options['fields']['clients_since_47']['table'] = 'civicrm_value_client_info_7'; $handler->display->display_options['fields']['clients_since_47']['field'] = 'clients_since_47'; $handler->display->display_options['fields']['clients_since_47']['date_format'] = 'custom'; $handler->display->display_options['fields']['clients_since_47']['custom_date_format'] = 'Y'; $handler->display->display_options['fields']['clients_since_47']['second_date_format'] = 'long'; $handler->display->display_options['path'] = 'civi-orgs/%';