public function views_handler_argument_many_to_one::summary_query in Views (for Drupal 7) 7.3

Same name and namespace in other branches

1. 6.3 handlers/views_handler_argument_many_to_one.inc \views_handler_argument_many_to_one::summary_query()
2. 6.2 handlers/views_handler_argument_many_to_one.inc \views_handler_argument_many_to_one::summary_query()

Build the info for the summary query.

This must:

• add_groupby: group on this field in order to create summaries.
• add_field: add a 'num_nodes' field for the count. Usually it will be a count on $view->base_field
• set_count_field: Reset the count field so we get the right paging.

Return value

string The alias used to get the number of records (count) for this entry.

Overrides views_handler_argument::summary_query

File

handlers/views_handler_argument_many_to_one.inc, line 169

Definition of views_handler_argument_many_to_one.

Class

views_handler_argument_many_to_one

Argument handler for fields that have many-to-one table relationships.

Code

public function summary_query() {
  $field = $this->table . '.' . $this->field;
  $join = $this
    ->get_join();
  if (!empty($this->options['require_value'])) {
    $join->type = 'INNER';
  }
  if (empty($this->options['add_table']) || empty($this->view->many_to_one_tables[$field])) {
    $this->table_alias = $this->query
      ->ensure_table($this->table, $this->relationship, $join);
  }
  else {
    $this->table_alias = $this->helper
      ->summary_join();
  }

  // Add the field.
  $this->base_alias = $this->query
    ->add_field($this->table_alias, $this->real_field);
  $this
    ->summary_name_field();
  return $this
    ->summary_basics();
}