public function NcsLastCommentName::query in Views (for Drupal 7) 8.3

Same name in this branch

1. 8.3 lib/Views/comment/Plugin/views/sort/NcsLastCommentName.php \Views\comment\Plugin\views\sort\NcsLastCommentName::query()
2. 8.3 lib/Views/comment/Plugin/views/field/NcsLastCommentName.php \Views\comment\Plugin\views\field\NcsLastCommentName::query()

Called to add the field to a query.

Overrides FieldPluginBase::query

File

lib/Views/comment/Plugin/views/field/NcsLastCommentName.php, line 25

Definition of Views\comment\Plugin\views\field\NcsLastCommentName.

Class

NcsLastCommentName

Field handler to present the name of the last comment poster.

Namespace

Views\comment\Plugin\views\field

Code

public function query() {

  // last_comment_name only contains data if the user is anonymous. So we
  // have to join in a specially related user table.
  $this
    ->ensureMyTable();

  // join 'users' to this table via vid
  $definition = array(
    'table' => 'users',
    'field' => 'uid',
    'left_table' => $this->tableAlias,
    'left_field' => 'last_comment_uid',
    'extra' => array(
      array(
        'field' => 'uid',
        'operator' => '!=',
        'value' => '0',
      ),
    ),
  );
  $join = drupal_container()
    ->get('plugin.manager.views.join')
    ->createInstance('standard', $definition);

  // ncs_user alias so this can work with the sort handler, below.
  //    $this->user_table = $this->query->add_relationship(NULL, $join, 'users', $this->relationship);
  $this->user_table = $this->query
    ->ensure_table('ncs_users', $this->relationship, $join);
  $this->field_alias = $this->query
    ->add_field(NULL, "COALESCE({$this->user_table}.name, {$this->tableAlias}.{$this->field})", $this->tableAlias . '_' . $this->field);
  $this->user_field = $this->query
    ->add_field($this->user_table, 'name');
  $this->uid = $this->query
    ->add_field($this->tableAlias, 'last_comment_uid');
}