public function Fraction::query in Fraction 2.x

Same name in this branch

1. 2.x src/Plugin/views/filter/Fraction.php \Drupal\fraction\Plugin\views\filter\Fraction::query()
2. 2.x src/Plugin/views/sort/Fraction.php \Drupal\fraction\Plugin\views\sort\Fraction::query()

Same name and namespace in other branches

1. 8 src/Plugin/views/sort/Fraction.php \Drupal\fraction\Plugin\views\sort\Fraction::query()

Called to add the sort to a query.

Overrides SortPluginBase::query

File

src/Plugin/views/sort/Fraction.php, line 22

Class

Fraction

Sort handler for Fraction fields.

Namespace

Drupal\fraction\Plugin\views\sort

Code

public function query() {

  // Ensure the main table for this field is included.
  $this
    ->ensureMyTable();

  // Formula for calculating the final value, by dividing numerator by denominator.
  // These are added as additional fields in hook_field_views_data_alter().
  $numerator = $this->tableAlias . '.' . $this->definition['additional fields']['numerator'];
  $denominator = $this->tableAlias . '.' . $this->definition['additional fields']['denominator'];

  // Multiply the numerator field by 1.0 so the database returns a decimal
  // from the computation.
  $formula = '1.0 * ' . $numerator . ' / ' . $denominator;

  // Add the orderby.
  $this->query
    ->addOrderBy(NULL, $formula, $this->options['order'], $this->tableAlias . '_decimal');
}