View source
<?php
namespace Drupal\file;
use Drupal\views\EntityViewsData;
class FileViewsData extends EntityViewsData {
public function getViewsData() {
$data = parent::getViewsData();
$data['file_managed']['table']['base']['help'] = $this
->t('Files maintained by Drupal and various modules.');
$data['file_managed']['table']['base']['defaults']['field'] = 'filename';
$data['file_managed']['table']['wizard_id'] = 'file_managed';
$data['file_managed']['fid']['argument'] = [
'id' => 'file_fid',
'name field' => 'filename',
'numeric' => TRUE,
];
$data['file_managed']['fid']['relationship'] = [
'title' => $this
->t('File usage'),
'help' => $this
->t('Relate file entities to their usage.'),
'id' => 'standard',
'base' => 'file_usage',
'base field' => 'fid',
'field' => 'fid',
'label' => $this
->t('File usage'),
];
$data['file_managed']['uri']['field']['default_formatter'] = 'file_uri';
$data['file_managed']['filemime']['field']['default_formatter'] = 'file_filemime';
$data['file_managed']['extension'] = [
'title' => $this
->t('Extension'),
'help' => $this
->t('The extension of the file.'),
'real field' => 'filename',
'field' => [
'entity_type' => 'file',
'field_name' => 'filename',
'default_formatter' => 'file_extension',
'id' => 'field',
'click sortable' => FALSE,
],
];
$data['file_managed']['filesize']['field']['default_formatter'] = 'file_size';
$data['file_managed']['status']['field']['default_formatter_settings'] = [
'format' => 'custom',
'format_custom_false' => $this
->t('Temporary'),
'format_custom_true' => $this
->t('Permanent'),
];
$data['file_managed']['status']['filter']['id'] = 'file_status';
$data['file_managed']['uid']['relationship']['title'] = $this
->t('User who uploaded');
$data['file_managed']['uid']['relationship']['label'] = $this
->t('User who uploaded');
$data['file_usage']['table']['group'] = $this
->t('File Usage');
$data['file_usage']['table']['join'] = [
'file_managed' => [
'field' => 'fid',
'left_field' => 'fid',
],
'node_field_data' => [
'field' => 'id',
'left_field' => 'nid',
'extra' => [
[
'field' => 'type',
'value' => 'node',
],
],
],
'users_field_data' => [
'field' => 'id',
'left_field' => 'uid',
'extra' => [
[
'field' => 'type',
'value' => 'user',
],
],
],
'comment' => [
'field' => 'id',
'left_field' => 'cid',
'extra' => [
[
'field' => 'type',
'value' => 'comment',
],
],
],
'taxonomy_term_data' => [
'field' => 'id',
'left_field' => 'tid',
'extra' => [
[
'field' => 'type',
'value' => 'taxonomy_term',
],
],
],
];
$data['file_usage']['file_to_node'] = [
'title' => $this
->t('Content'),
'help' => $this
->t('Content that is associated with this file, usually because this file is in a field on the content.'),
'skip base' => [
'node_field_data',
'node_field_revision',
'users_field_data',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'id',
'relationship' => [
'title' => $this
->t('Content'),
'label' => $this
->t('Content'),
'base' => 'node_field_data',
'base field' => 'nid',
'relationship field' => 'id',
'extra' => [
[
'table' => 'file_usage',
'field' => 'type',
'operator' => '=',
'value' => 'node',
],
],
],
];
$data['file_usage']['node_to_file'] = [
'title' => $this
->t('File'),
'help' => $this
->t('A file that is associated with this node, usually because it is in a field on the node.'),
'skip base' => [
'file_managed',
'users_field_data',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'fid',
'relationship' => [
'title' => $this
->t('File'),
'label' => $this
->t('File'),
'base' => 'file_managed',
'base field' => 'fid',
'relationship field' => 'fid',
],
];
$data['file_usage']['file_to_user'] = [
'title' => $this
->t('User'),
'help' => $this
->t('A user that is associated with this file, usually because this file is in a field on the user.'),
'skip base' => [
'node_field_data',
'node_field_revision',
'users_field_data',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'id',
'relationship' => [
'title' => $this
->t('User'),
'label' => $this
->t('User'),
'base' => 'users',
'base field' => 'uid',
'relationship field' => 'id',
'extra' => [
[
'table' => 'file_usage',
'field' => 'type',
'operator' => '=',
'value' => 'user',
],
],
],
];
$data['file_usage']['user_to_file'] = [
'title' => $this
->t('File'),
'help' => $this
->t('A file that is associated with this user, usually because it is in a field on the user.'),
'skip base' => [
'file_managed',
'node_field_data',
'node_field_revision',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'fid',
'relationship' => [
'title' => $this
->t('File'),
'label' => $this
->t('File'),
'base' => 'file_managed',
'base field' => 'fid',
'relationship field' => 'fid',
],
];
$data['file_usage']['file_to_comment'] = [
'title' => $this
->t('Comment'),
'help' => $this
->t('A comment that is associated with this file, usually because this file is in a field on the comment.'),
'skip base' => [
'node_field_data',
'node_field_revision',
'users_field_data',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'id',
'relationship' => [
'title' => $this
->t('Comment'),
'label' => $this
->t('Comment'),
'base' => 'comment_field_data',
'base field' => 'cid',
'relationship field' => 'id',
'extra' => [
[
'table' => 'file_usage',
'field' => 'type',
'operator' => '=',
'value' => 'comment',
],
],
],
];
$data['file_usage']['comment_to_file'] = [
'title' => $this
->t('File'),
'help' => $this
->t('A file that is associated with this comment, usually because it is in a field on the comment.'),
'skip base' => [
'file_managed',
'node_field_data',
'node_field_revision',
'users_field_data',
'taxonomy_term_field_data',
],
'real field' => 'fid',
'relationship' => [
'title' => $this
->t('File'),
'label' => $this
->t('File'),
'base' => 'file_managed',
'base field' => 'fid',
'relationship field' => 'fid',
],
];
$data['file_usage']['file_to_taxonomy_term'] = [
'title' => $this
->t('Taxonomy Term'),
'help' => $this
->t('A taxonomy term that is associated with this file, usually because this file is in a field on the taxonomy term.'),
'skip base' => [
'node_field_data',
'node_field_revision',
'users_field_data',
'comment_field_data',
'taxonomy_term_field_data',
],
'real field' => 'id',
'relationship' => [
'title' => $this
->t('Taxonomy Term'),
'label' => $this
->t('Taxonomy Term'),
'base' => 'taxonomy_term_data',
'base field' => 'tid',
'relationship field' => 'id',
'extra' => [
[
'table' => 'file_usage',
'field' => 'type',
'operator' => '=',
'value' => 'taxonomy_term',
],
],
],
];
$data['file_usage']['taxonomy_term_to_file'] = [
'title' => $this
->t('File'),
'help' => $this
->t('A file that is associated with this taxonomy term, usually because it is in a field on the taxonomy term.'),
'skip base' => [
'file_managed',
'node_field_data',
'node_field_revision',
'users_field_data',
'comment_field_data',
],
'real field' => 'fid',
'relationship' => [
'title' => $this
->t('File'),
'label' => $this
->t('File'),
'base' => 'file_managed',
'base field' => 'fid',
'relationship field' => 'fid',
],
];
$data['file_usage']['module'] = [
'title' => $this
->t('Module'),
'help' => $this
->t('The module managing this file relationship.'),
'field' => [
'id' => 'standard',
],
'filter' => [
'id' => 'string',
],
'argument' => [
'id' => 'string',
],
'sort' => [
'id' => 'standard',
],
];
$data['file_usage']['type'] = [
'title' => $this
->t('Entity type'),
'help' => $this
->t('The type of entity that is related to the file.'),
'field' => [
'id' => 'standard',
],
'filter' => [
'id' => 'string',
],
'argument' => [
'id' => 'string',
],
'sort' => [
'id' => 'standard',
],
];
$data['file_usage']['id'] = [
'title' => $this
->t('Entity ID'),
'help' => $this
->t('The ID of the entity that is related to the file.'),
'field' => [
'id' => 'numeric',
],
'argument' => [
'id' => 'numeric',
],
'filter' => [
'id' => 'numeric',
],
'sort' => [
'id' => 'standard',
],
];
$data['file_usage']['count'] = [
'title' => $this
->t('Use count'),
'help' => $this
->t('The number of times the file is used by this entity.'),
'field' => [
'id' => 'numeric',
],
'filter' => [
'id' => 'numeric',
],
'sort' => [
'id' => 'standard',
],
];
$data['file_usage']['entity_label'] = [
'title' => $this
->t('Entity label'),
'help' => $this
->t('The label of the entity that is related to the file.'),
'real field' => 'id',
'field' => [
'id' => 'entity_label',
'entity type field' => 'type',
],
];
return $data;
}
}