$db_info['table'], 'left_field' => 'vid', 'field' => 'vid', ); $columns = array(); $arguments = array(); $filters = array(); foreach ($db_info['columns'] as $column => $attributes) { $columns[] = $attributes['column']; $sorts[] = !empty($attributes['sortable']) ? TRUE : FALSE; // Identify likely filters and arguments for each column based on field type. switch ($attributes['type']) { case 'numeric': case 'int': case 'mediumint': case 'tinyint': case 'bigint': case 'serial': case 'float': $filters[] = 'views_handler_filter_numeric_content'; $arguments[] = 'views_handler_argument_content'; break; case 'text': case 'blob': // TODO add markup handlers for these types default: $filters[] = 'views_handler_filter_string_content'; $arguments[] = 'views_handler_argument_string_content'; break; } } $data[$columns[0]] = array( 'group' => t('Content'), 'title' => t($field_types[$field['type']]['label']) .': '. t($field['widget']['label']) . ' ('. $field['field_name'] .')', 'help' => t($field_types[$field['type']]['label']) .' - '. t('Appears in: @types', array('@types' => implode(', ', $types))), 'field' => array( 'field' => $columns[0], 'table' => $db_info['table'], 'handler' => 'views_handler_field_content_multiple', 'click sortable' => $sorts[0], 'additional fields' => $columns, 'content_field_name' => $field['field_name'], 'allow empty' => TRUE, // Access control modules should implement content_views_access_callback(). 'access callback' => 'content_views_access_callback', 'access arguments' => array($field), ), 'argument' => array( 'field' => $columns[0], 'table' => $db_info['table'], 'handler' => $arguments[0], 'click sortable' => $sorts[0], // TODO used in once place in node.views.inc, should we use it here? 'name field' => '', // TODO 'additional fields' => $columns, 'content_field_name' => $field['field_name'], 'allow empty' => TRUE, ), 'filter' => array( 'field' => $columns[0], 'title' => t($field['widget']['label']), 'table' => $db_info['table'], 'handler' => $filters[0], 'additional fields' => $columns, 'content_field_name' => $field['field_name'], 'allow empty' => TRUE, ), ); // TODO do we need different handling for sorts with Views 2, // especially when relationships are involved? if (!empty($sorts[0])) { $data[$columns[0]]['sort'] = array( 'field' => $columns[0], 'table' => $db_info['table'], 'handler' => 'views_handler_sort_content', 'additional fields' => $columns, 'content_field_name' => $field['field_name'], 'allow empty' => TRUE, ); } // TODO: provide automatic filters, sorts, and arguments for each column, not just the first? return array($table_alias => $data); } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_filter_string_content extends views_handler_filter_string { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_filter_numeric_content extends views_handler_filter_numeric { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_filter_many_to_one_content extends views_handler_filter_many_to_one { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; $field = $this->content_field; $this->value_title = $field['widget']['label']; } function get_value_options() { $this->value_options = $this->allowed_values(); } // Get allowed values from hook_allowed_values(), if any, // or from content_allowed_values(); function allowed_values() { $field = $this->content_field; $function = $field['module'] .'_allowed_values'; $options = function_exists($function) ? $function($field) : content_allowed_values($field); return (array) $options; } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_sort_content extends views_handler_sort { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_argument_content extends views_handler_argument { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; } } /** * The subclass simply adds properties, * for field-specific subclasses to use if they need to. */ class views_handler_argument_string_content extends views_handler_argument_string { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); $this->additional_fields = $this->definition['additional fields']; } } /** * The subclass adds basic field and formatter info, * for field-specific subclasses to use if they need to. * * Fields could extend this class if they want field and formatter handling * but don't want the multiple value grouping options created by * views_handler_field_content_multiple. */ class views_handler_field_content extends views_handler_field_node { var $content_field; function construct() { parent::construct(); $this->content_field = content_fields($this->definition['content_field_name']); } function options(&$options) { parent::options($options); $field = $this->content_field; // Override views_handler_field_node's default label $options['label'] = ''; $options['label_type'] = 'widget'; $options['format'] = 'default'; } /** * Provide formatter option. */ function options_form(&$form, &$form_state) { parent::options_form($form, $form_state); // TODO: do we want the 'link to node' checkbox ? // That's usually formatters business... $field = $this->content_field; $options = $this->options; $field_types = _content_field_types(); $formatters = array(); if (is_array($field_types[$field['type']]['formatters'])) { foreach ($field_types[$field['type']]['formatters'] as $name => $info) { $formatters[$name] = t($info['label']); } } $form['format'] = array( '#title' => t('Format'), '#type' => 'select', '#options' => $formatters, '#required' => TRUE, '#default_value' => $options['format'], '#weight' => 0, ); $form['label_type'] = array( '#title' => t('Label'), '#type' => 'radios', '#options' => array( 'none' => t('None'), 'widget' => t('Widget label (@label)', array('@label' => $field['widget']['label'])), 'custom' => t('Custom'), ), '#default_value' => $options['label_type'], '#weight' => 1, ); $form['label'] = array( '#title' => t('Custom label'), '#type' => 'textfield', '#default_value' => $options['label'], '#process' => array('views_process_dependency'), '#dependency' => array('radio:options[label_type]' => array('custom')), '#weight' => 2, ); } function label() { $field = $this->content_field; switch ($this->options['label_type']) { case 'none': return ''; case 'widget': return t($field['widget']['label']); default: return $this->options['label']; } } function options_validate($form, &$form_state) { } /** * Provide text for the administrative summary */ function admin_summary() { // Display the formatter name. $field = $this->content_field; $field_types = _content_field_types(); if (isset($field_types[$field['type']]['formatters'][$this->options['format']])) { return t($field_types[$field['type']]['formatters'][$this->options['format']]['label']); } } function render($values) { $field = $this->content_field; $options = $this->options; $db_info = content_database_info($field); // $values will be used as a fake $node object; // we provide a build_mode for rendering. // TODO: we can stick any value in there - // what would make most sense ? row_style ? $values->build_mode = 'views'; $item = array(); foreach ($db_info['columns'] as $column => $attributes) { $item[$column] = $values->{$this->table_alias .'_'. $attributes['column']}; } return $this->render_link(content_format($field, $item, $options['format'], $values), $values); } function query() { // Many of our formatters need the node type name, so let's be // sure it's in the query. $this->view->query->add_field('node', 'type'); parent::query(); } } /** * An extended subclass for field handling that adds multiple field grouping. * * Fields that want multiple value grouping options in addition to basic * field and formatter handling can extend this class. */ class views_handler_field_content_multiple extends views_handler_field_content { var $defer_query; function options(&$options) { parent::options($options); $field = $this->content_field; $options['multiple'] = array( 'group' => TRUE, 'multiple_number' => '', 'multiple_from' => '', 'multiple_reversed' => FALSE, ); } /** * Provide 'group multiple values' option. */ function options_form(&$form, &$form_state) { parent::options_form($form, $form_state); $field = $this->content_field; $options = $this->options; $form['multiple'] = array( '#access' => $field['multiple'], ); $form['multiple']['group'] = array( '#title' => t('Group multiple values'), '#type' => 'checkbox', '#default_value' => $options['multiple']['group'], ); // Make the string translatable by keeping it as a whole rather than // translating prefix and suffix separately. list($prefix, $suffix) = explode('@count', t('Show @count value(s)')); $form['multiple']['multiple_number'] = array( '#type' => 'textfield', '#size' => 5, '#field_prefix' => $prefix, '#field_suffix' => $suffix, '#default_value' => $options['multiple']['multiple_number'], '#prefix' => '
', ); list($prefix, $suffix) = explode('@count', t('starting from @count')); $form['multiple']['multiple_from'] = array( '#type' => 'textfield', '#size' => 5, '#field_prefix' => $prefix, '#field_suffix' => $suffix, '#default_value' => $options['multiple']['multiple_from'], ); $form['multiple']['multiple_reversed'] = array( '#title' => t('Reversed (start from last values)'), '#type' => 'checkbox', '#default_value' => $options['multiple']['multiple_reversed'], '#suffix' => '
', ); } function query() { $field = $this->content_field; $options = $this->options; // if (in_array($field['handler'], array('content_views_field_handler_group', 'content_views_field_handler_first', 'content_views_field_handler_last'))) { // TODO: multiple_number / multiple_from // We can also optimize the query when only one value should be retrieved $this->defer_query = $options['multiple']['group'] && $field['multiple']; // If this is not a grouped field, use the generic field handler query. if (!$this->defer_query) { return parent::query(); } // We don't add anything to the query. The data is retrieved in pre_render() // in order to avoid duplicate results. $this->field_alias = $this->real_field; // If the field is sortable (table sort), we just have to join the table // ("Node: Distinct" will be required to avoid duplicates...) // if ($field['sortable']) { // $this->ensure_my_table(); // } } function pre_render($values) { // There are no values to render in a summary view. if (isset($this->view->build_info['summary'])) { return parent::pre_render($values); } // If this is not a grouped field, use the parent pre_render(). if (!$this->defer_query || empty($values)) { return parent::pre_render($values); } $field = $this->content_field; $db_info = content_database_info($field); $options = $this->options; $this->field_values = array(); // Build the list of nids to retrieve. // TODO: try fetching from cache_content first ?? $nids = array(); foreach ($values as $value) { $nids[] = $value->nid; } // List columns to retrieve. $table_alias = content_views_tablename($field); $query_columns = array("$table_alias.delta AS delta"); foreach ($db_info['columns'] as $column => $attributes) { $query_columns[] = "$table_alias.$attributes[column] AS $column"; } // Make sure node.nid is aliased so it isn't confused with // nodereference's nid column. $query = "SELECT node.nid AS parent_nid, ". implode(', ', $query_columns) . " FROM {node} node". " LEFT JOIN {". $db_info['table'] ."} $table_alias ON node.vid = $table_alias.vid". " WHERE node.nid IN (". implode(',', $nids) .")". " ORDER BY node.nid ASC, $table_alias.delta ". ($options['multiple']['multiple_reversed'] ? 'DESC' : 'ASC'); // TODO: Select all deltas or only a subset. $result = $options['multiple']['multiple_number'] ? db_query_range($query, $options['multiple']['multiple_from'], $options['multiple']['multiple_number']) : db_query($query); while ($item = db_fetch_array($result)) { $this->field_values[$item['parent_nid']][$item['delta']] = $item; } } function render($values) { // If this is not a grouped field, use the parent render(). if (!$this->defer_query || empty($this->field_values)) { return parent::render($values); } $field = $this->content_field; $options = $this->options; // $values will be used as a fake $node object; // we provide a build_mode for rendering. // TODO: we can stick any value in there - // what would make most sense ? row_style ? $values->build_mode = 'views'; // This needs to be set for the $this->render_link() to work. It would // have been set in the query, if we hadn't bypassed the normal query. // TODO there may be a better way to do this. $this->aliases['nid'] = 'nid'; $items = array(); foreach ($this->field_values[$values->{$this->additional_fields['nid']}] as $item) { $value = content_format($field, $item, $options['format'], $values); if (!empty($value)) { $items[] = $this->render_link($value, $values); } } if (count($items) > 1) { // TODO: could we use generic field display ? return theme('content_view_multiple_field', $items, $field, $values); } elseif (count($items) == 1) { return $items[0]; } else { return ''; } } } function theme_content_view_multiple_field($items, $field, $values) { $output = ''; foreach ($items as $item) { $output .= '
'. $item .'
'; } return $output; }