Called to add the sort to a query.
Overrides SortPluginBase::query
public function query() {
$this
->ensureMyTable();
$definition = array(
'table' => 'users',
'field' => 'uid',
'left_table' => $this->tableAlias,
'left_field' => 'last_comment_uid',
);
$join = drupal_container()
->get('plugin.manager.views.join')
->createInstance('standard', $definition);
// @todo this might be safer if we had an ensure_relationship rather than guessing
// the table alias. Though if we did that we'd be guessing the relationship name
// so that doesn't matter that much.
// $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->user_field = $this->query
->add_field($this->user_table, 'name');
// Add the field.
$this->query
->add_orderby(NULL, "LOWER(COALESCE({$this->user_table}.name, {$this->tableAlias}.{$this->field}))", $this->options['order'], $this->tableAlias . '_' . $this->field);
}