5 * Provide Views data and handlers for field.module.
7 * @ingroup views_module_handlers
11 * Implements hook_views_data().
13 * Field modules can implement hook_field_views_data() to override
14 * the default behavior for adding fields.
16 function field_views_data() {
18 foreach (field_info_fields() as $field) {
19 if ($field['storage']['type'] != 'field_sql_storage') {
23 $module = $field['module'];
24 $result = (array) module_invoke($module, 'field_views_data', $field);
27 $result = field_views_field_default_views_data($field);
29 drupal_alter('field_views_data', $result, $field, $module);
31 if (is_array($result)) {
32 $data = drupal_array_merge_deep($result, $data);
40 * Implements hook_views_data_alter().
42 * Field modules can implement hook_field_views_data_views_data_alter() to
43 * alter the views data on a per field basis. This is weirdly named so as
44 * not to conflict with the drupal_alter('field_views_data') in
47 function field_views_data_alter(&$data) {
48 foreach (field_info_fields() as $field) {
49 if ($field['storage']['type'] != 'field_sql_storage') {
53 $function = $field['module'] . '_field_views_data_views_data_alter';
54 if (function_exists($function)) {
55 $function($data, $field);
61 * Returns the label of a certain field.
63 * Therefore it looks up in all bundles to find the most used instance.
65 function field_views_field_label($field_name) {
66 $label_counter = array();
67 $all_labels = array();
68 // Count the amount of instances per label per field.
69 $instances = field_info_instances();
70 foreach ($instances as $entity_name => $entity_type) {
71 foreach ($entity_type as $bundle) {
72 if (isset($bundle[$field_name])) {
73 $label_counter[$bundle[$field_name]['label']] = isset($label_counter[$bundle[$field_name]['label']]) ? ++$label_counter[$bundle[$field_name]['label']] : 1;
74 $all_labels[$entity_name][$bundle[$field_name]['label']] = TRUE;
78 if (empty($label_counter)) {
79 return array($field_name, $all_labels);
81 // Sort the field lables by it most used label and return the most used one.
82 arsort($label_counter);
83 $label_counter = array_keys($label_counter);
84 return array($label_counter[0], $all_labels);
88 * Default views data implementation for a field.
90 function field_views_field_default_views_data($field) {
91 $field_types = field_info_field_types();
93 // Check the field module is available.
94 if (!isset($field_types[$field['type']])) {
100 $current_table = _field_sql_storage_tablename($field);
101 $revision_table = _field_sql_storage_revision_tablename($field);
103 // The list of entity:bundle that this field is used in.
104 $bundles_names = array();
105 $supports_revisions = FALSE;
106 $entity_tables = array();
107 $current_tables = array();
108 $revision_tables = array();
111 $group_name = count($field['bundles']) > 1 ? t('Field') : NULL;
113 // Build the relationships between the field table and the entity tables.
114 foreach ($field['bundles'] as $entity => $bundles) {
115 $entity_info = entity_get_info($entity);
116 $groups[$entity] = $entity_info['label'];
118 // Override Node to Content.
119 if ($groups[$entity] == t('Node')) {
120 $groups[$entity] = t('Content');
123 // If only one bundle use this as the default name.
124 if (empty($group_name)) {
125 $group_name = $groups[$entity];
128 $entity_tables[$entity_info['base table']] = $entity;
129 $current_tables[$entity] = $entity_info['base table'];
130 if (isset($entity_info['revision table'])) {
131 $entity_tables[$entity_info['revision table']] = $entity;
132 $revision_tables[$entity] = $entity_info['revision table'];
135 $data[$current_table]['table']['join'][$entity_info['base table']] = array(
136 'left_field' => $entity_info['entity keys']['id'],
137 'field' => 'entity_id',
139 array('field' => 'entity_type', 'value' => $entity),
140 array('field' => 'deleted', 'value' => 0, 'numeric' => TRUE),
144 if (!empty($entity_info['entity keys']['revision']) && !empty($entity_info['revision table'])) {
145 $data[$revision_table]['table']['join'][$entity_info['revision table']] = array(
146 'left_field' => $entity_info['entity keys']['revision'],
147 'field' => 'revision_id',
149 array('field' => 'entity_type', 'value' => $entity),
150 array('field' => 'deleted', 'value' => 0, 'numeric' => TRUE),
154 $supports_revisions = TRUE;
157 foreach ($bundles as $bundle) {
158 $bundles_names[] = t('@entity:@bundle', array('@entity' => $entity, '@bundle' => $bundle));
163 $tables[FIELD_LOAD_CURRENT] = $current_table;
164 if ($supports_revisions) {
165 $tables[FIELD_LOAD_REVISION] = $revision_table;
168 $add_fields = array('delta', 'language', 'bundle');
169 foreach ($field['columns'] as $column_name => $attributes) {
170 $add_fields[] = _field_sql_storage_columnname($field['field_name'], $column_name);
173 // Note: we don't have a label available here, because we are at the field
174 // level, not at the instance level. So we just go through all instances
175 // and take the one which is used the most frequently.
176 $field_name = $field['field_name'];
177 list($label, $all_labels) = field_views_field_label($field_name);
178 foreach ($tables as $type => $table) {
179 if ($type == FIELD_LOAD_CURRENT) {
180 $group = $group_name;
181 $old_column = 'entity_id';
182 $column = $field['field_name'];
185 $group = t('@group (historical data)', array('@group' => $group_name));
186 $old_column = 'revision_id';
187 $column = $field['field_name'] . '-' . $old_column;
190 $data[$table][$old_column]['field']['moved to'] = array($table, $column);
191 $data[$table][$column] = array(
194 'title short' => $label,
195 'help' => t('Appears in: @bundles.', array('@bundles' => implode(', ', $bundles_names))),
198 // Go through and create a list of aliases for all possible combinations of
199 // entity type + name.
201 $also_known = array();
202 foreach ($all_labels as $entity_name => $labels) {
203 foreach ($labels as $label_name => $true) {
204 if ($type == FIELD_LOAD_CURRENT) {
205 if ($group_name != $groups[$entity_name] || $label != $label_name) {
207 'base' => $current_tables[$entity_name],
208 'group' => $groups[$entity_name],
209 'title' => $label_name,
210 'help' => t('This is an alias of @group: @field.', array('@group' => $group_name, '@field' => $label)),
213 $also_known[] = t('@group: @field', array('@group' => $groups[$entity_name], '@field' => $label_name));
216 if ($group_name != $groups[$entity_name] && $label != $label_name && isset($revision_tables[$entity_name])) {
218 'base' => $revision_tables[$entity_name],
219 'group' => t('@group (historical data)', array('@group' => $groups[$entity_name])),
220 'title' => $label_name,
221 'help' => t('This is an alias of @group: @field.', array('@group' => $group_name, '@field' => $label)),
224 $also_known[] = t('@group (historical data): @field', array('@group' => $groups[$entity_name], '@field' => $label_name));
229 $data[$table][$column]['aliases'] = $aliases;
230 $data[$table][$column]['help'] .= ' ' . t('Also known as: !also.', array('!also' => implode(', ', $also_known)));
233 $keys = array_keys($field['columns']);
234 $real_field = reset($keys);
235 $data[$table][$column]['field'] = array(
237 'handler' => 'views_handler_field_field',
238 'click sortable' => TRUE,
239 'field_name' => $field['field_name'],
240 // Provide a real field for group by.
241 'real field' => $column . '_' . $real_field,
242 'additional fields' => $add_fields,
243 'entity_tables' => $entity_tables,
244 // Default the element type to div, let the UI change it if necessary.
245 'element type' => 'div',
246 'is revision' => $type == FIELD_LOAD_REVISION,
250 foreach ($field['columns'] as $column => $attributes) {
253 // Identify likely filters and arguments for each column based on field type.
254 switch ($attributes['type']) {
262 $filter = 'views_handler_filter_numeric';
263 $argument = 'views_handler_argument_numeric';
264 $sort = 'views_handler_sort';
268 // It does not make sense to sort by blob or text.
271 $filter = 'views_handler_filter_string';
272 $argument = 'views_handler_argument_string';
273 $sort = 'views_handler_sort';
278 if (count($field['columns']) == 1 || $column == 'value') {
279 $title = t('@label (!name)', array('@label' => $label, '!name' => $field['field_name']));
280 // CCK used the first 10 characters of $label. Probably doesn't matter.
281 $title_short = $label;
284 $title = t('@label (!name:!column)', array('@label' => $label, '!name' => $field['field_name'], '!column' => $column));
285 $title_short = t('@label:!column', array('@label' => $label, '!column' => $column));
288 foreach ($tables as $type => $table) {
289 if ($type == FIELD_LOAD_CURRENT) {
290 $group = $group_name;
293 $group = t('@group (historical data)', array('@group' => $group_name));
295 $column_real_name = $field['storage']['details']['sql'][$type][$table][$column];
297 // Load all the fields from the table by default.
298 $additional_fields = array_values($field['storage']['details']['sql'][$type][$table]);
300 $data[$table][$column_real_name] = array(
303 'title short' => $title_short,
304 'help' => t('Appears in: @bundles.', array('@bundles' => implode(', ', $bundles_names))),
307 // Go through and create a list of aliases for all possible combinations of
308 // entity type + name.
310 $also_known = array();
311 foreach ($all_labels as $entity_name => $labels) {
312 foreach ($labels as $label_name => $true) {
313 if ($group_name != $groups[$entity_name] || $label != $label_name) {
314 if (count($field['columns']) == 1 || $column == 'value') {
315 $alias_title = t('@label (!name)', array('@label' => $label_name, '!name' => $field['field_name']));
316 // CCK used the first 10 characters of $label. Probably doesn't matter.
319 $alias_title = t('@label (!name:!column)', array('@label' => $label_name, '!name' => $field['field_name'], '!column' => $column));
322 'group' => $groups[$entity_name],
323 'title' => $alias_title,
324 'help' => t('This is an alias of @group: @field.', array('@group' => $group_name, '@field' => $title)),
327 $also_known[] = t('@group: @field', array('@group' => $groups[$entity_name], '@field' => $title));
331 $data[$table][$column_real_name]['aliases'] = $aliases;
332 $data[$table][$column_real_name]['help'] .= ' ' . t('Also known as: !also.', array('!also' => implode(', ', $also_known)));
335 $data[$table][$column_real_name]['argument'] = array(
336 'field' => $column_real_name,
338 'handler' => $argument,
339 'additional fields' => $additional_fields,
340 'field_name' => $field['field_name'],
341 'empty field name' => t('- No value -'),
343 $data[$table][$column_real_name]['filter'] = array(
344 'field' => $column_real_name,
346 'handler' => $filter,
347 'additional fields' => $additional_fields,
348 'field_name' => $field['field_name'],
349 'allow empty' => TRUE,
351 if (!empty($allow_sort)) {
352 $data[$table][$column_real_name]['sort'] = array(
353 'field' => $column_real_name,
356 'additional fields' => $additional_fields,
357 'field_name' => $field['field_name'],
361 // Expose additional delta column for multiple value fields.
362 if ($field['cardinality'] > 1 || $field['cardinality'] == FIELD_CARDINALITY_UNLIMITED) {
363 $title_delta = t('@label (!name:delta)', array('@label' => $label, '!name' => $field['field_name']));
364 $title_short_delta = t('@label:delta', array('@label' => $label));
366 $data[$table]['delta'] = array(
368 'title' => $title_delta,
369 'title short' => $title_short_delta,
370 'help' => t('Delta - Appears in: @bundles.', array('@bundles' => implode(', ', $bundles_names))),
372 $data[$table]['delta']['field'] = array(
373 'handler' => 'views_handler_field_numeric',
375 $data[$table]['delta']['argument'] = array(
378 'handler' => 'views_handler_argument_numeric',
379 'additional fields' => $additional_fields,
380 'empty field name' => t('- No value -'),
381 'field_name' => $field['field_name'],
383 $data[$table]['delta']['filter'] = array(
386 'handler' => 'views_handler_filter_numeric',
387 'additional fields' => $additional_fields,
388 'field_name' => $field['field_name'],
389 'allow empty' => TRUE,
391 $data[$table]['delta']['sort'] = array(
394 'handler' => 'views_handler_sort',
395 'additional fields' => $additional_fields,
396 'field_name' => $field['field_name'],
400 // Expose additional language column for translatable fields.
401 if (!empty($field['translatable'])) {
402 $title_language = t('@label (!name:language)', array('@label' => $label, '!name' => $field['field_name']));
403 $title_short_language = t('@label:language', array('@label' => $label));
405 $data[$table]['language'] = array(
407 'title' => $title_language,
408 'title short' => $title_short_language,
409 'help' => t('Language - Appears in: @bundles.', array('@bundles' => implode(', ', $bundles_names))),
411 $data[$table]['language']['field'] = array(
412 'handler' => 'views_handler_field_locale_language',
414 $data[$table]['language']['argument'] = array(
415 'field' => 'language',
417 'handler' => 'views_handler_argument_locale_language',
418 'additional fields' => $additional_fields,
419 'empty field name' => t('<No value>'),
420 'field_name' => $field['field_name'],
422 $data[$table]['language']['filter'] = array(
423 'field' => 'language',
425 'handler' => 'views_handler_filter_locale_language',
426 'additional fields' => $additional_fields,
427 'field_name' => $field['field_name'],
428 'allow empty' => TRUE,
430 $data[$table]['language']['sort'] = array(
431 'field' => 'language',
433 'handler' => 'views_handler_sort',
434 'additional fields' => $additional_fields,
435 'field_name' => $field['field_name'],
445 * Have a different filter handler for lists. This should allow to select values of the list.
447 function list_field_views_data($field) {
448 $data = field_views_field_default_views_data($field);
449 foreach ($data as $table_name => $table_data) {
450 foreach ($table_data as $field_name => $field_data) {
451 if (isset($field_data['filter']) && $field_name != 'delta') {
452 if ($field['type'] == 'list_boolean') {
453 // Special handler for boolean fields.
454 $data[$table_name][$field_name]['filter']['handler'] = 'views_handler_filter_field_list_boolean';
457 $data[$table_name][$field_name]['filter']['handler'] = 'views_handler_filter_field_list';
460 if (isset($field_data['argument']) && $field_name != 'delta') {
461 if ($field['type'] == 'list_text') {
462 $data[$table_name][$field_name]['argument']['handler'] = 'views_handler_argument_field_list_string';
465 $data[$table_name][$field_name]['argument']['handler'] = 'views_handler_argument_field_list';