public function references_handler_argument::title_query in References 7.2

Use entity title for % placeholders in argument titles.

@codingStandardsIgnoreStart

Overrides views_handler_argument_numeric::title_query

File

views/references_handler_argument.inc, line 20

Provide handler to replace reference with title.

Class

references_handler_argument

Default class for handler argument.

Code

public function title_query() {

  // @codingStandardsIgnoreEnd
  // Use the same table and field than those used for summary lists
  // ('name table', 'name field').
  $table_data = views_fetch_data($this->name_table);
  $table_info = $table_data['table']['join'][$this->table];
  $table = $table_info['table'];
  $key_field = $table_info['field'];
  $title_field = $this->name_field;
  $results = db_select($table, 'base_table')
    ->fields('base_table', array(
    $key_field,
    $title_field,
  ))
    ->condition("base_table.{$key_field}", $this->value)
    ->execute()
    ->fetchAllKeyed();

  // Sanitize titles and put them back in the correct order in an unkeyed
  // array.
  $titles = array();
  foreach ($this->value as $key) {
    if (isset($results[$key])) {
      $titles[] = check_plain($results[$key]);
    }
  }
  return $titles;
}