Chris@0
|
1 <?php
|
Chris@0
|
2
|
Chris@0
|
3 namespace Drupal\node;
|
Chris@0
|
4
|
Chris@0
|
5 use Drupal\views\EntityViewsData;
|
Chris@0
|
6
|
Chris@0
|
7 /**
|
Chris@0
|
8 * Provides the views data for the node entity type.
|
Chris@0
|
9 */
|
Chris@0
|
10 class NodeViewsData extends EntityViewsData {
|
Chris@0
|
11
|
Chris@0
|
12 /**
|
Chris@0
|
13 * {@inheritdoc}
|
Chris@0
|
14 */
|
Chris@0
|
15 public function getViewsData() {
|
Chris@0
|
16 $data = parent::getViewsData();
|
Chris@0
|
17
|
Chris@0
|
18 $data['node_field_data']['table']['base']['weight'] = -10;
|
Chris@0
|
19 $data['node_field_data']['table']['base']['access query tag'] = 'node_access';
|
Chris@0
|
20 $data['node_field_data']['table']['wizard_id'] = 'node';
|
Chris@0
|
21
|
Chris@0
|
22 $data['node_field_data']['nid']['argument'] = [
|
Chris@0
|
23 'id' => 'node_nid',
|
Chris@0
|
24 'name field' => 'title',
|
Chris@0
|
25 'numeric' => TRUE,
|
Chris@0
|
26 'validate type' => 'nid',
|
Chris@0
|
27 ];
|
Chris@0
|
28
|
Chris@0
|
29 $data['node_field_data']['title']['field']['default_formatter_settings'] = ['link_to_entity' => TRUE];
|
Chris@0
|
30
|
Chris@0
|
31 $data['node_field_data']['title']['field']['link_to_node default'] = TRUE;
|
Chris@0
|
32
|
Chris@0
|
33 $data['node_field_data']['type']['argument']['id'] = 'node_type';
|
Chris@0
|
34
|
Chris@0
|
35 $data['node_field_data']['langcode']['help'] = $this->t('The language of the content or translation.');
|
Chris@0
|
36
|
Chris@0
|
37 $data['node_field_data']['status']['filter']['label'] = $this->t('Published status');
|
Chris@0
|
38 $data['node_field_data']['status']['filter']['type'] = 'yes-no';
|
Chris@0
|
39 // Use status = 1 instead of status <> 0 in WHERE statement.
|
Chris@0
|
40 $data['node_field_data']['status']['filter']['use_equal'] = TRUE;
|
Chris@0
|
41
|
Chris@0
|
42 $data['node_field_data']['status_extra'] = [
|
Chris@0
|
43 'title' => $this->t('Published status or admin user'),
|
Chris@0
|
44 'help' => $this->t('Filters out unpublished content if the current user cannot view it.'),
|
Chris@0
|
45 'filter' => [
|
Chris@0
|
46 'field' => 'status',
|
Chris@0
|
47 'id' => 'node_status',
|
Chris@0
|
48 'label' => $this->t('Published status or admin user'),
|
Chris@0
|
49 ],
|
Chris@0
|
50 ];
|
Chris@0
|
51
|
Chris@0
|
52 $data['node_field_data']['promote']['help'] = $this->t('A boolean indicating whether the node is visible on the front page.');
|
Chris@0
|
53 $data['node_field_data']['promote']['filter']['label'] = $this->t('Promoted to front page status');
|
Chris@0
|
54 $data['node_field_data']['promote']['filter']['type'] = 'yes-no';
|
Chris@0
|
55
|
Chris@0
|
56 $data['node_field_data']['sticky']['help'] = $this->t('A boolean indicating whether the node should sort to the top of content lists.');
|
Chris@0
|
57 $data['node_field_data']['sticky']['filter']['label'] = $this->t('Sticky status');
|
Chris@0
|
58 $data['node_field_data']['sticky']['filter']['type'] = 'yes-no';
|
Chris@0
|
59 $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
|
60
|
Chris@0
|
61 $data['node']['node_bulk_form'] = [
|
Chris@0
|
62 'title' => $this->t('Node operations bulk form'),
|
Chris@0
|
63 'help' => $this->t('Add a form element that lets you run operations on multiple nodes.'),
|
Chris@0
|
64 'field' => [
|
Chris@0
|
65 'id' => 'node_bulk_form',
|
Chris@0
|
66 ],
|
Chris@0
|
67 ];
|
Chris@0
|
68
|
Chris@0
|
69 // Bogus fields for aliasing purposes.
|
Chris@0
|
70
|
Chris@0
|
71 // @todo Add similar support to any date field
|
Chris@0
|
72 // @see https://www.drupal.org/node/2337507
|
Chris@0
|
73 $data['node_field_data']['created_fulldate'] = [
|
Chris@0
|
74 'title' => $this->t('Created date'),
|
Chris@0
|
75 'help' => $this->t('Date in the form of CCYYMMDD.'),
|
Chris@0
|
76 'argument' => [
|
Chris@0
|
77 'field' => 'created',
|
Chris@0
|
78 'id' => 'date_fulldate',
|
Chris@0
|
79 ],
|
Chris@0
|
80 ];
|
Chris@0
|
81
|
Chris@0
|
82 $data['node_field_data']['created_year_month'] = [
|
Chris@0
|
83 'title' => $this->t('Created year + month'),
|
Chris@0
|
84 'help' => $this->t('Date in the form of YYYYMM.'),
|
Chris@0
|
85 'argument' => [
|
Chris@0
|
86 'field' => 'created',
|
Chris@0
|
87 'id' => 'date_year_month',
|
Chris@0
|
88 ],
|
Chris@0
|
89 ];
|
Chris@0
|
90
|
Chris@0
|
91 $data['node_field_data']['created_year'] = [
|
Chris@0
|
92 'title' => $this->t('Created year'),
|
Chris@0
|
93 'help' => $this->t('Date in the form of YYYY.'),
|
Chris@0
|
94 'argument' => [
|
Chris@0
|
95 'field' => 'created',
|
Chris@0
|
96 'id' => 'date_year',
|
Chris@0
|
97 ],
|
Chris@0
|
98 ];
|
Chris@0
|
99
|
Chris@0
|
100 $data['node_field_data']['created_month'] = [
|
Chris@0
|
101 'title' => $this->t('Created month'),
|
Chris@0
|
102 'help' => $this->t('Date in the form of MM (01 - 12).'),
|
Chris@0
|
103 'argument' => [
|
Chris@0
|
104 'field' => 'created',
|
Chris@0
|
105 'id' => 'date_month',
|
Chris@0
|
106 ],
|
Chris@0
|
107 ];
|
Chris@0
|
108
|
Chris@0
|
109 $data['node_field_data']['created_day'] = [
|
Chris@0
|
110 'title' => $this->t('Created day'),
|
Chris@0
|
111 'help' => $this->t('Date in the form of DD (01 - 31).'),
|
Chris@0
|
112 'argument' => [
|
Chris@0
|
113 'field' => 'created',
|
Chris@0
|
114 'id' => 'date_day',
|
Chris@0
|
115 ],
|
Chris@0
|
116 ];
|
Chris@0
|
117
|
Chris@0
|
118 $data['node_field_data']['created_week'] = [
|
Chris@0
|
119 'title' => $this->t('Created week'),
|
Chris@0
|
120 'help' => $this->t('Date in the form of WW (01 - 53).'),
|
Chris@0
|
121 'argument' => [
|
Chris@0
|
122 'field' => 'created',
|
Chris@0
|
123 'id' => 'date_week',
|
Chris@0
|
124 ],
|
Chris@0
|
125 ];
|
Chris@0
|
126
|
Chris@0
|
127 $data['node_field_data']['changed_fulldate'] = [
|
Chris@0
|
128 'title' => $this->t('Updated date'),
|
Chris@0
|
129 'help' => $this->t('Date in the form of CCYYMMDD.'),
|
Chris@0
|
130 'argument' => [
|
Chris@0
|
131 'field' => 'changed',
|
Chris@0
|
132 'id' => 'date_fulldate',
|
Chris@0
|
133 ],
|
Chris@0
|
134 ];
|
Chris@0
|
135
|
Chris@0
|
136 $data['node_field_data']['changed_year_month'] = [
|
Chris@0
|
137 'title' => $this->t('Updated year + month'),
|
Chris@0
|
138 'help' => $this->t('Date in the form of YYYYMM.'),
|
Chris@0
|
139 'argument' => [
|
Chris@0
|
140 'field' => 'changed',
|
Chris@0
|
141 'id' => 'date_year_month',
|
Chris@0
|
142 ],
|
Chris@0
|
143 ];
|
Chris@0
|
144
|
Chris@0
|
145 $data['node_field_data']['changed_year'] = [
|
Chris@0
|
146 'title' => $this->t('Updated year'),
|
Chris@0
|
147 'help' => $this->t('Date in the form of YYYY.'),
|
Chris@0
|
148 'argument' => [
|
Chris@0
|
149 'field' => 'changed',
|
Chris@0
|
150 'id' => 'date_year',
|
Chris@0
|
151 ],
|
Chris@0
|
152 ];
|
Chris@0
|
153
|
Chris@0
|
154 $data['node_field_data']['changed_month'] = [
|
Chris@0
|
155 'title' => $this->t('Updated month'),
|
Chris@0
|
156 'help' => $this->t('Date in the form of MM (01 - 12).'),
|
Chris@0
|
157 'argument' => [
|
Chris@0
|
158 'field' => 'changed',
|
Chris@0
|
159 'id' => 'date_month',
|
Chris@0
|
160 ],
|
Chris@0
|
161 ];
|
Chris@0
|
162
|
Chris@0
|
163 $data['node_field_data']['changed_day'] = [
|
Chris@0
|
164 'title' => $this->t('Updated day'),
|
Chris@0
|
165 'help' => $this->t('Date in the form of DD (01 - 31).'),
|
Chris@0
|
166 'argument' => [
|
Chris@0
|
167 'field' => 'changed',
|
Chris@0
|
168 'id' => 'date_day',
|
Chris@0
|
169 ],
|
Chris@0
|
170 ];
|
Chris@0
|
171
|
Chris@0
|
172 $data['node_field_data']['changed_week'] = [
|
Chris@0
|
173 'title' => $this->t('Updated week'),
|
Chris@0
|
174 'help' => $this->t('Date in the form of WW (01 - 53).'),
|
Chris@0
|
175 'argument' => [
|
Chris@0
|
176 'field' => 'changed',
|
Chris@0
|
177 'id' => 'date_week',
|
Chris@0
|
178 ],
|
Chris@0
|
179 ];
|
Chris@0
|
180
|
Chris@0
|
181 $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
|
182 $data['node_field_data']['uid']['filter']['id'] = 'user_name';
|
Chris@0
|
183 $data['node_field_data']['uid']['relationship']['title'] = $this->t('Content author');
|
Chris@0
|
184 $data['node_field_data']['uid']['relationship']['help'] = $this->t('Relate content to the user who created it.');
|
Chris@0
|
185 $data['node_field_data']['uid']['relationship']['label'] = $this->t('author');
|
Chris@0
|
186
|
Chris@0
|
187 $data['node']['node_listing_empty'] = [
|
Chris@0
|
188 'title' => $this->t('Empty Node Frontpage behavior'),
|
Chris@0
|
189 'help' => $this->t('Provides a link to the node add overview page.'),
|
Chris@0
|
190 'area' => [
|
Chris@0
|
191 'id' => 'node_listing_empty',
|
Chris@0
|
192 ],
|
Chris@0
|
193 ];
|
Chris@0
|
194
|
Chris@0
|
195 $data['node_field_data']['uid_revision']['title'] = $this->t('User has a revision');
|
Chris@0
|
196 $data['node_field_data']['uid_revision']['help'] = $this->t('All nodes where a certain user has a revision');
|
Chris@0
|
197 $data['node_field_data']['uid_revision']['real field'] = 'nid';
|
Chris@0
|
198 $data['node_field_data']['uid_revision']['filter']['id'] = 'node_uid_revision';
|
Chris@0
|
199 $data['node_field_data']['uid_revision']['argument']['id'] = 'node_uid_revision';
|
Chris@0
|
200
|
Chris@0
|
201 $data['node_field_revision']['table']['wizard_id'] = 'node_revision';
|
Chris@0
|
202
|
Chris@0
|
203 // Advertise this table as a possible base table.
|
Chris@0
|
204 $data['node_field_revision']['table']['base']['help'] = $this->t('Content revision is a history of changes to content.');
|
Chris@0
|
205 $data['node_field_revision']['table']['base']['defaults']['title'] = 'title';
|
Chris@0
|
206
|
Chris@0
|
207 $data['node_field_revision']['nid']['argument'] = [
|
Chris@0
|
208 'id' => 'node_nid',
|
Chris@0
|
209 'numeric' => TRUE,
|
Chris@0
|
210 ];
|
Chris@0
|
211 // @todo the NID field needs different behaviour on revision/non-revision
|
Chris@0
|
212 // tables. It would be neat if this could be encoded in the base field
|
Chris@0
|
213 // definition.
|
Chris@0
|
214 $data['node_field_revision']['nid']['relationship']['id'] = 'standard';
|
Chris@0
|
215 $data['node_field_revision']['nid']['relationship']['base'] = 'node_field_data';
|
Chris@0
|
216 $data['node_field_revision']['nid']['relationship']['base field'] = 'nid';
|
Chris@0
|
217 $data['node_field_revision']['nid']['relationship']['title'] = $this->t('Content');
|
Chris@0
|
218 $data['node_field_revision']['nid']['relationship']['label'] = $this->t('Get the actual content from a content revision.');
|
Chris@17
|
219 $data['node_field_revision']['nid']['relationship']['extra'][] = [
|
Chris@17
|
220 'field' => 'langcode',
|
Chris@17
|
221 'left_field' => 'langcode',
|
Chris@17
|
222 ];
|
Chris@0
|
223
|
Chris@0
|
224 $data['node_field_revision']['vid'] = [
|
Chris@0
|
225 'argument' => [
|
Chris@0
|
226 'id' => 'node_vid',
|
Chris@0
|
227 'numeric' => TRUE,
|
Chris@0
|
228 ],
|
Chris@0
|
229 'relationship' => [
|
Chris@0
|
230 'id' => 'standard',
|
Chris@0
|
231 'base' => 'node_field_data',
|
Chris@0
|
232 'base field' => 'vid',
|
Chris@0
|
233 'title' => $this->t('Content'),
|
Chris@0
|
234 'label' => $this->t('Get the actual content from a content revision.'),
|
Chris@17
|
235 'extra' => [
|
Chris@17
|
236 [
|
Chris@17
|
237 'field' => 'langcode',
|
Chris@17
|
238 'left_field' => 'langcode',
|
Chris@17
|
239 ],
|
Chris@17
|
240 ],
|
Chris@0
|
241 ],
|
Chris@0
|
242 ] + $data['node_field_revision']['vid'];
|
Chris@0
|
243
|
Chris@0
|
244 $data['node_field_revision']['langcode']['help'] = $this->t('The language the original content is in.');
|
Chris@0
|
245
|
Chris@0
|
246 $data['node_revision']['revision_uid']['help'] = $this->t('Relate a content revision to the user who created the revision.');
|
Chris@0
|
247 $data['node_revision']['revision_uid']['relationship']['label'] = $this->t('revision user');
|
Chris@0
|
248
|
Chris@0
|
249 $data['node_field_revision']['table']['wizard_id'] = 'node_field_revision';
|
Chris@0
|
250
|
Chris@0
|
251 $data['node_field_revision']['status']['filter']['label'] = $this->t('Published');
|
Chris@0
|
252 $data['node_field_revision']['status']['filter']['type'] = 'yes-no';
|
Chris@0
|
253 $data['node_field_revision']['status']['filter']['use_equal'] = TRUE;
|
Chris@0
|
254
|
Chris@0
|
255 $data['node_field_revision']['promote']['help'] = $this->t('A boolean indicating whether the node is visible on the front page.');
|
Chris@0
|
256
|
Chris@0
|
257 $data['node_field_revision']['sticky']['help'] = $this->t('A boolean indicating whether the node should sort to the top of content lists.');
|
Chris@0
|
258
|
Chris@0
|
259 $data['node_field_revision']['langcode']['help'] = $this->t('The language of the content or translation.');
|
Chris@0
|
260
|
Chris@0
|
261 $data['node_field_revision']['link_to_revision'] = [
|
Chris@0
|
262 'field' => [
|
Chris@0
|
263 'title' => $this->t('Link to revision'),
|
Chris@0
|
264 'help' => $this->t('Provide a simple link to the revision.'),
|
Chris@0
|
265 'id' => 'node_revision_link',
|
Chris@0
|
266 'click sortable' => FALSE,
|
Chris@0
|
267 ],
|
Chris@0
|
268 ];
|
Chris@0
|
269
|
Chris@0
|
270 $data['node_field_revision']['revert_revision'] = [
|
Chris@0
|
271 'field' => [
|
Chris@0
|
272 'title' => $this->t('Link to revert revision'),
|
Chris@0
|
273 'help' => $this->t('Provide a simple link to revert to the revision.'),
|
Chris@0
|
274 'id' => 'node_revision_link_revert',
|
Chris@0
|
275 'click sortable' => FALSE,
|
Chris@0
|
276 ],
|
Chris@0
|
277 ];
|
Chris@0
|
278
|
Chris@0
|
279 $data['node_field_revision']['delete_revision'] = [
|
Chris@0
|
280 'field' => [
|
Chris@0
|
281 'title' => $this->t('Link to delete revision'),
|
Chris@0
|
282 'help' => $this->t('Provide a simple link to delete the content revision.'),
|
Chris@0
|
283 'id' => 'node_revision_link_delete',
|
Chris@0
|
284 'click sortable' => FALSE,
|
Chris@0
|
285 ],
|
Chris@0
|
286 ];
|
Chris@0
|
287
|
Chris@0
|
288 // Define the base group of this table. Fields that don't have a group defined
|
Chris@0
|
289 // will go into this field by default.
|
Chris@17
|
290 $data['node_access']['table']['group'] = $this->t('Content access');
|
Chris@0
|
291
|
Chris@0
|
292 // For other base tables, explain how we join.
|
Chris@0
|
293 $data['node_access']['table']['join'] = [
|
Chris@0
|
294 'node_field_data' => [
|
Chris@0
|
295 'left_field' => 'nid',
|
Chris@0
|
296 'field' => 'nid',
|
Chris@0
|
297 ],
|
Chris@0
|
298 ];
|
Chris@0
|
299 $data['node_access']['nid'] = [
|
Chris@0
|
300 'title' => $this->t('Access'),
|
Chris@0
|
301 'help' => $this->t('Filter by access.'),
|
Chris@0
|
302 'filter' => [
|
Chris@0
|
303 'id' => 'node_access',
|
Chris@0
|
304 'help' => $this->t('Filter for content by view access. <strong>Not necessary if you are using node as your base table.</strong>'),
|
Chris@0
|
305 ],
|
Chris@0
|
306 ];
|
Chris@0
|
307
|
Chris@0
|
308 // Add search table, fields, filters, etc., but only if a page using the
|
Chris@0
|
309 // node_search plugin is enabled.
|
Chris@0
|
310 if (\Drupal::moduleHandler()->moduleExists('search')) {
|
Chris@0
|
311 $enabled = FALSE;
|
Chris@0
|
312 $search_page_repository = \Drupal::service('search.search_page_repository');
|
Chris@0
|
313 foreach ($search_page_repository->getActiveSearchpages() as $page) {
|
Chris@0
|
314 if ($page->getPlugin()->getPluginId() == 'node_search') {
|
Chris@0
|
315 $enabled = TRUE;
|
Chris@0
|
316 break;
|
Chris@0
|
317 }
|
Chris@0
|
318 }
|
Chris@0
|
319
|
Chris@0
|
320 if ($enabled) {
|
Chris@0
|
321 $data['node_search_index']['table']['group'] = $this->t('Search');
|
Chris@0
|
322
|
Chris@0
|
323 // Automatically join to the node table (or actually, node_field_data).
|
Chris@0
|
324 // Use a Views table alias to allow other modules to use this table too,
|
Chris@0
|
325 // if they use the search index.
|
Chris@0
|
326 $data['node_search_index']['table']['join'] = [
|
Chris@0
|
327 'node_field_data' => [
|
Chris@0
|
328 'left_field' => 'nid',
|
Chris@0
|
329 'field' => 'sid',
|
Chris@0
|
330 'table' => 'search_index',
|
Chris@0
|
331 'extra' => "node_search_index.type = 'node_search' AND node_search_index.langcode = node_field_data.langcode",
|
Chris@17
|
332 ],
|
Chris@0
|
333 ];
|
Chris@0
|
334
|
Chris@0
|
335 $data['node_search_total']['table']['join'] = [
|
Chris@0
|
336 'node_search_index' => [
|
Chris@0
|
337 'left_field' => 'word',
|
Chris@0
|
338 'field' => 'word',
|
Chris@0
|
339 ],
|
Chris@0
|
340 ];
|
Chris@0
|
341
|
Chris@0
|
342 $data['node_search_dataset']['table']['join'] = [
|
Chris@0
|
343 'node_field_data' => [
|
Chris@0
|
344 'left_field' => 'sid',
|
Chris@0
|
345 'left_table' => 'node_search_index',
|
Chris@0
|
346 'field' => 'sid',
|
Chris@0
|
347 'table' => 'search_dataset',
|
Chris@0
|
348 'extra' => 'node_search_index.type = node_search_dataset.type AND node_search_index.langcode = node_search_dataset.langcode',
|
Chris@0
|
349 'type' => 'INNER',
|
Chris@0
|
350 ],
|
Chris@0
|
351 ];
|
Chris@0
|
352
|
Chris@0
|
353 $data['node_search_index']['score'] = [
|
Chris@0
|
354 'title' => $this->t('Score'),
|
Chris@0
|
355 'help' => $this->t('The score of the search item. This will not be used if the search filter is not also present.'),
|
Chris@0
|
356 'field' => [
|
Chris@0
|
357 'id' => 'search_score',
|
Chris@0
|
358 'float' => TRUE,
|
Chris@0
|
359 'no group by' => TRUE,
|
Chris@0
|
360 ],
|
Chris@0
|
361 'sort' => [
|
Chris@0
|
362 'id' => 'search_score',
|
Chris@0
|
363 'no group by' => TRUE,
|
Chris@0
|
364 ],
|
Chris@0
|
365 ];
|
Chris@0
|
366
|
Chris@0
|
367 $data['node_search_index']['keys'] = [
|
Chris@0
|
368 'title' => $this->t('Search Keywords'),
|
Chris@0
|
369 'help' => $this->t('The keywords to search for.'),
|
Chris@0
|
370 'filter' => [
|
Chris@0
|
371 'id' => 'search_keywords',
|
Chris@0
|
372 'no group by' => TRUE,
|
Chris@0
|
373 'search_type' => 'node_search',
|
Chris@0
|
374 ],
|
Chris@0
|
375 'argument' => [
|
Chris@0
|
376 'id' => 'search',
|
Chris@0
|
377 'no group by' => TRUE,
|
Chris@0
|
378 'search_type' => 'node_search',
|
Chris@0
|
379 ],
|
Chris@0
|
380 ];
|
Chris@0
|
381
|
Chris@0
|
382 }
|
Chris@0
|
383 }
|
Chris@0
|
384
|
Chris@0
|
385 return $data;
|
Chris@0
|
386 }
|
Chris@0
|
387
|
Chris@0
|
388 }
|