View source
<?php
namespace Drupal\rate\Plugin\views\sort;
use Drupal\Core\Entity\EntityTypeManagerInterface;
use Drupal\views\Plugin\views\sort\SortPluginBase;
use Drupal\views\Views;
use Symfony\Component\DependencyInjection\ContainerInterface;
class RateSort extends SortPluginBase {
protected $entityTypeManager;
public function __construct(array $configuration, $plugin_id, $plugin_definition, EntityTypeManagerInterface $entityTypeManager) {
parent::__construct($configuration, $plugin_id, $plugin_definition);
$this->entityTypeManager = $entityTypeManager;
}
public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition) {
return new static($configuration, $plugin_id, $plugin_definition, $container
->get('entity_type.manager'));
}
public function query() {
$this
->ensureMyTable();
$id = $this->entityTypeManager
->getDefinition($this->tableAlias)
->get('entity_keys')['id'];
$configuration = [
'table' => 'votingapi_result',
'field' => 'entity_id',
'left_table' => $this->tableAlias . '._field_data',
'left_field' => $this->tableAlias . '.' . $id,
'operator' => '=',
'extra' => [
[
'field' => 'entity_type',
'value' => $this->tableAlias,
],
[
'field' => 'function',
'value' => 'vote_average',
],
],
];
$join = Views::pluginManager('join')
->createInstance('standard', $configuration);
$this->query
->addRelationship('vote', $join, $this->tableAlias . '._field_data');
$this->query
->addOrderBy('vote', 'value', $this->options['order']);
}
}