Chris@0: <?php
Chris@0: 
Chris@0: namespace Drupal\node;
Chris@0: 
Chris@0: use Drupal\views\EntityViewsData;
Chris@0: 
Chris@0: /**
Chris@0:  * Provides the views data for the node entity type.
Chris@0:  */
Chris@0: class NodeViewsData extends EntityViewsData {
Chris@0: 
Chris@0:   /**
Chris@0:    * {@inheritdoc}
Chris@0:    */
Chris@0:   public function getViewsData() {
Chris@0:     $data = parent::getViewsData();
Chris@0: 
Chris@0:     $data['node_field_data']['table']['base']['weight'] = -10;
Chris@0:     $data['node_field_data']['table']['base']['access query tag'] = 'node_access';
Chris@0:     $data['node_field_data']['table']['wizard_id'] = 'node';
Chris@0: 
Chris@0:     $data['node_field_data']['nid']['argument'] = [
Chris@0:       'id' => 'node_nid',
Chris@0:       'name field' => 'title',
Chris@0:       'numeric' => TRUE,
Chris@0:       'validate type' => 'nid',
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['title']['field']['default_formatter_settings'] = ['link_to_entity' => TRUE];
Chris@0: 
Chris@0:     $data['node_field_data']['title']['field']['link_to_node default'] = TRUE;
Chris@0: 
Chris@0:     $data['node_field_data']['type']['argument']['id'] = 'node_type';
Chris@0: 
Chris@0:     $data['node_field_data']['langcode']['help'] = $this->t('The language of the content or translation.');
Chris@0: 
Chris@0:     $data['node_field_data']['status']['filter']['label'] = $this->t('Published status');
Chris@0:     $data['node_field_data']['status']['filter']['type'] = 'yes-no';
Chris@0:     // Use status = 1 instead of status <> 0 in WHERE statement.
Chris@0:     $data['node_field_data']['status']['filter']['use_equal'] = TRUE;
Chris@0: 
Chris@0:     $data['node_field_data']['status_extra'] = [
Chris@0:       'title' => $this->t('Published status or admin user'),
Chris@0:       'help' => $this->t('Filters out unpublished content if the current user cannot view it.'),
Chris@0:       'filter' => [
Chris@0:         'field' => 'status',
Chris@0:         'id' => 'node_status',
Chris@0:         'label' => $this->t('Published status or admin user'),
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['promote']['help'] = $this->t('A boolean indicating whether the node is visible on the front page.');
Chris@0:     $data['node_field_data']['promote']['filter']['label'] = $this->t('Promoted to front page status');
Chris@0:     $data['node_field_data']['promote']['filter']['type'] = 'yes-no';
Chris@0: 
Chris@0:     $data['node_field_data']['sticky']['help'] = $this->t('A boolean indicating whether the node should sort to the top of content lists.');
Chris@0:     $data['node_field_data']['sticky']['filter']['label'] = $this->t('Sticky status');
Chris@0:     $data['node_field_data']['sticky']['filter']['type'] = 'yes-no';
Chris@0:     $data['node_field_data']['sticky']['sort']['help'] = $this->t('Whether or not the content is sticky. To list sticky content first, set this to descending.');
Chris@0: 
Chris@0:     $data['node']['node_bulk_form'] = [
Chris@0:       'title' => $this->t('Node operations bulk form'),
Chris@0:       'help' => $this->t('Add a form element that lets you run operations on multiple nodes.'),
Chris@0:       'field' => [
Chris@0:         'id' => 'node_bulk_form',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     // Bogus fields for aliasing purposes.
Chris@0: 
Chris@0:     // @todo Add similar support to any date field
Chris@0:     // @see https://www.drupal.org/node/2337507
Chris@0:     $data['node_field_data']['created_fulldate'] = [
Chris@0:       'title' => $this->t('Created date'),
Chris@0:       'help' => $this->t('Date in the form of CCYYMMDD.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_fulldate',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['created_year_month'] = [
Chris@0:       'title' => $this->t('Created year + month'),
Chris@0:       'help' => $this->t('Date in the form of YYYYMM.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_year_month',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['created_year'] = [
Chris@0:       'title' => $this->t('Created year'),
Chris@0:       'help' => $this->t('Date in the form of YYYY.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_year',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['created_month'] = [
Chris@0:       'title' => $this->t('Created month'),
Chris@0:       'help' => $this->t('Date in the form of MM (01 - 12).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_month',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['created_day'] = [
Chris@0:       'title' => $this->t('Created day'),
Chris@0:       'help' => $this->t('Date in the form of DD (01 - 31).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_day',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['created_week'] = [
Chris@0:       'title' => $this->t('Created week'),
Chris@0:       'help' => $this->t('Date in the form of WW (01 - 53).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'created',
Chris@0:         'id' => 'date_week',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_fulldate'] = [
Chris@0:       'title' => $this->t('Updated date'),
Chris@0:       'help' => $this->t('Date in the form of CCYYMMDD.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_fulldate',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_year_month'] = [
Chris@0:       'title' => $this->t('Updated year + month'),
Chris@0:       'help' => $this->t('Date in the form of YYYYMM.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_year_month',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_year'] = [
Chris@0:       'title' => $this->t('Updated year'),
Chris@0:       'help' => $this->t('Date in the form of YYYY.'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_year',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_month'] = [
Chris@0:       'title' => $this->t('Updated month'),
Chris@0:       'help' => $this->t('Date in the form of MM (01 - 12).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_month',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_day'] = [
Chris@0:       'title' => $this->t('Updated day'),
Chris@0:       'help' => $this->t('Date in the form of DD (01 - 31).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_day',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['changed_week'] = [
Chris@0:       'title' => $this->t('Updated week'),
Chris@0:       'help' => $this->t('Date in the form of WW (01 - 53).'),
Chris@0:       'argument' => [
Chris@0:         'field' => 'changed',
Chris@0:         'id' => 'date_week',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['uid']['help'] = $this->t('The user authoring the content. If you need more fields than the uid add the content: author relationship');
Chris@0:     $data['node_field_data']['uid']['filter']['id'] = 'user_name';
Chris@0:     $data['node_field_data']['uid']['relationship']['title'] = $this->t('Content author');
Chris@0:     $data['node_field_data']['uid']['relationship']['help'] = $this->t('Relate content to the user who created it.');
Chris@0:     $data['node_field_data']['uid']['relationship']['label'] = $this->t('author');
Chris@0: 
Chris@0:     $data['node']['node_listing_empty'] = [
Chris@0:       'title' => $this->t('Empty Node Frontpage behavior'),
Chris@0:       'help' => $this->t('Provides a link to the node add overview page.'),
Chris@0:       'area' => [
Chris@0:         'id' => 'node_listing_empty',
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_data']['uid_revision']['title'] = $this->t('User has a revision');
Chris@0:     $data['node_field_data']['uid_revision']['help'] = $this->t('All nodes where a certain user has a revision');
Chris@0:     $data['node_field_data']['uid_revision']['real field'] = 'nid';
Chris@0:     $data['node_field_data']['uid_revision']['filter']['id'] = 'node_uid_revision';
Chris@0:     $data['node_field_data']['uid_revision']['argument']['id'] = 'node_uid_revision';
Chris@0: 
Chris@0:     $data['node_field_revision']['table']['wizard_id'] = 'node_revision';
Chris@0: 
Chris@0:     // Advertise this table as a possible base table.
Chris@0:     $data['node_field_revision']['table']['base']['help'] = $this->t('Content revision is a history of changes to content.');
Chris@0:     $data['node_field_revision']['table']['base']['defaults']['title'] = 'title';
Chris@0: 
Chris@0:     $data['node_field_revision']['nid']['argument'] = [
Chris@0:       'id' => 'node_nid',
Chris@0:       'numeric' => TRUE,
Chris@0:     ];
Chris@0:     // @todo the NID field needs different behaviour on revision/non-revision
Chris@0:     //   tables. It would be neat if this could be encoded in the base field
Chris@0:     //   definition.
Chris@0:     $data['node_field_revision']['nid']['relationship']['id'] = 'standard';
Chris@0:     $data['node_field_revision']['nid']['relationship']['base'] = 'node_field_data';
Chris@0:     $data['node_field_revision']['nid']['relationship']['base field'] = 'nid';
Chris@0:     $data['node_field_revision']['nid']['relationship']['title'] = $this->t('Content');
Chris@0:     $data['node_field_revision']['nid']['relationship']['label'] = $this->t('Get the actual content from a content revision.');
Chris@17:     $data['node_field_revision']['nid']['relationship']['extra'][] = [
Chris@17:       'field' => 'langcode',
Chris@17:       'left_field' => 'langcode',
Chris@17:     ];
Chris@0: 
Chris@0:     $data['node_field_revision']['vid'] = [
Chris@0:       'argument' => [
Chris@0:         'id' => 'node_vid',
Chris@0:         'numeric' => TRUE,
Chris@0:       ],
Chris@0:       'relationship' => [
Chris@0:         'id' => 'standard',
Chris@0:         'base' => 'node_field_data',
Chris@0:         'base field' => 'vid',
Chris@0:         'title' => $this->t('Content'),
Chris@0:         'label' => $this->t('Get the actual content from a content revision.'),
Chris@17:         'extra' => [
Chris@17:           [
Chris@17:             'field' => 'langcode',
Chris@17:             'left_field' => 'langcode',
Chris@17:           ],
Chris@17:         ],
Chris@0:       ],
Chris@0:     ] + $data['node_field_revision']['vid'];
Chris@0: 
Chris@0:     $data['node_field_revision']['langcode']['help'] = $this->t('The language the original content is in.');
Chris@0: 
Chris@0:     $data['node_revision']['revision_uid']['help'] = $this->t('Relate a content revision to the user who created the revision.');
Chris@0:     $data['node_revision']['revision_uid']['relationship']['label'] = $this->t('revision user');
Chris@0: 
Chris@0:     $data['node_field_revision']['table']['wizard_id'] = 'node_field_revision';
Chris@0: 
Chris@0:     $data['node_field_revision']['status']['filter']['label'] = $this->t('Published');
Chris@0:     $data['node_field_revision']['status']['filter']['type'] = 'yes-no';
Chris@0:     $data['node_field_revision']['status']['filter']['use_equal'] = TRUE;
Chris@0: 
Chris@0:     $data['node_field_revision']['promote']['help'] = $this->t('A boolean indicating whether the node is visible on the front page.');
Chris@0: 
Chris@0:     $data['node_field_revision']['sticky']['help'] = $this->t('A boolean indicating whether the node should sort to the top of content lists.');
Chris@0: 
Chris@0:     $data['node_field_revision']['langcode']['help'] = $this->t('The language of the content or translation.');
Chris@0: 
Chris@0:     $data['node_field_revision']['link_to_revision'] = [
Chris@0:       'field' => [
Chris@0:         'title' => $this->t('Link to revision'),
Chris@0:         'help' => $this->t('Provide a simple link to the revision.'),
Chris@0:         'id' => 'node_revision_link',
Chris@0:         'click sortable' => FALSE,
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_revision']['revert_revision'] = [
Chris@0:       'field' => [
Chris@0:         'title' => $this->t('Link to revert revision'),
Chris@0:         'help' => $this->t('Provide a simple link to revert to the revision.'),
Chris@0:         'id' => 'node_revision_link_revert',
Chris@0:         'click sortable' => FALSE,
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     $data['node_field_revision']['delete_revision'] = [
Chris@0:       'field' => [
Chris@0:         'title' => $this->t('Link to delete revision'),
Chris@0:         'help' => $this->t('Provide a simple link to delete the content revision.'),
Chris@0:         'id' => 'node_revision_link_delete',
Chris@0:         'click sortable' => FALSE,
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     // Define the base group of this table. Fields that don't have a group defined
Chris@0:     // will go into this field by default.
Chris@17:     $data['node_access']['table']['group'] = $this->t('Content access');
Chris@0: 
Chris@0:     // For other base tables, explain how we join.
Chris@0:     $data['node_access']['table']['join'] = [
Chris@0:       'node_field_data' => [
Chris@0:         'left_field' => 'nid',
Chris@0:         'field' => 'nid',
Chris@0:       ],
Chris@0:     ];
Chris@0:     $data['node_access']['nid'] = [
Chris@0:       'title' => $this->t('Access'),
Chris@0:       'help' => $this->t('Filter by access.'),
Chris@0:       'filter' => [
Chris@0:         'id' => 'node_access',
Chris@0:         'help' => $this->t('Filter for content by view access. <strong>Not necessary if you are using node as your base table.</strong>'),
Chris@0:       ],
Chris@0:     ];
Chris@0: 
Chris@0:     // Add search table, fields, filters, etc., but only if a page using the
Chris@0:     // node_search plugin is enabled.
Chris@0:     if (\Drupal::moduleHandler()->moduleExists('search')) {
Chris@0:       $enabled = FALSE;
Chris@0:       $search_page_repository = \Drupal::service('search.search_page_repository');
Chris@0:       foreach ($search_page_repository->getActiveSearchpages() as $page) {
Chris@0:         if ($page->getPlugin()->getPluginId() == 'node_search') {
Chris@0:           $enabled = TRUE;
Chris@0:           break;
Chris@0:         }
Chris@0:       }
Chris@0: 
Chris@0:       if ($enabled) {
Chris@0:         $data['node_search_index']['table']['group'] = $this->t('Search');
Chris@0: 
Chris@0:         // Automatically join to the node table (or actually, node_field_data).
Chris@0:         // Use a Views table alias to allow other modules to use this table too,
Chris@0:         // if they use the search index.
Chris@0:         $data['node_search_index']['table']['join'] = [
Chris@0:           'node_field_data' => [
Chris@0:             'left_field' => 'nid',
Chris@0:             'field' => 'sid',
Chris@0:             'table' => 'search_index',
Chris@0:             'extra' => "node_search_index.type = 'node_search' AND node_search_index.langcode = node_field_data.langcode",
Chris@17:           ],
Chris@0:         ];
Chris@0: 
Chris@0:         $data['node_search_total']['table']['join'] = [
Chris@0:           'node_search_index' => [
Chris@0:             'left_field' => 'word',
Chris@0:             'field' => 'word',
Chris@0:           ],
Chris@0:         ];
Chris@0: 
Chris@0:         $data['node_search_dataset']['table']['join'] = [
Chris@0:           'node_field_data' => [
Chris@0:             'left_field' => 'sid',
Chris@0:             'left_table' => 'node_search_index',
Chris@0:             'field' => 'sid',
Chris@0:             'table' => 'search_dataset',
Chris@0:             'extra' => 'node_search_index.type = node_search_dataset.type AND node_search_index.langcode = node_search_dataset.langcode',
Chris@0:             'type' => 'INNER',
Chris@0:           ],
Chris@0:         ];
Chris@0: 
Chris@0:         $data['node_search_index']['score'] = [
Chris@0:           'title' => $this->t('Score'),
Chris@0:           'help' => $this->t('The score of the search item. This will not be used if the search filter is not also present.'),
Chris@0:           'field' => [
Chris@0:             'id' => 'search_score',
Chris@0:             'float' => TRUE,
Chris@0:             'no group by' => TRUE,
Chris@0:           ],
Chris@0:           'sort' => [
Chris@0:             'id' => 'search_score',
Chris@0:             'no group by' => TRUE,
Chris@0:           ],
Chris@0:         ];
Chris@0: 
Chris@0:         $data['node_search_index']['keys'] = [
Chris@0:           'title' => $this->t('Search Keywords'),
Chris@0:           'help' => $this->t('The keywords to search for.'),
Chris@0:           'filter' => [
Chris@0:             'id' => 'search_keywords',
Chris@0:             'no group by' => TRUE,
Chris@0:             'search_type' => 'node_search',
Chris@0:           ],
Chris@0:           'argument' => [
Chris@0:             'id' => 'search',
Chris@0:             'no group by' => TRUE,
Chris@0:             'search_type' => 'node_search',
Chris@0:           ],
Chris@0:         ];
Chris@0: 
Chris@0:       }
Chris@0:     }
Chris@0: 
Chris@0:     return $data;
Chris@0:   }
Chris@0: 
Chris@0: }