TableSortExtender.php

Same filename in this branch
  1. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/TableSortExtender.php
Same filename and directory in other branches
  1. 8.9.x core/lib/Drupal/Core/Database/Query/TableSortExtender.php
  2. 10 core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/TableSortExtender.php
  3. 10 core/lib/Drupal/Core/Database/Query/TableSortExtender.php
  4. 11.x core/tests/fixtures/database_drivers/module/core_fake/src/Driver/Database/CoreFakeWithAllCustomClasses/TableSortExtender.php
  5. 11.x core/lib/Drupal/Core/Database/Query/TableSortExtender.php

Namespace

Drupal\Core\Database\Query

File

core/lib/Drupal/Core/Database/Query/TableSortExtender.php

View source
<?php

namespace Drupal\Core\Database\Query;

use Drupal\Core\Database\Connection;
use Drupal\Core\Utility\TableSort;

/**
 * Query extender class for tablesort queries.
 */
class TableSortExtender extends SelectExtender {
  
  /**
   * {@inheritdoc}
   */
  public function __construct(SelectInterface $query, Connection $connection) {
    parent::__construct($query, $connection);
    // Add convenience tag to mark that this is an extended query. We have to
    // do this in the constructor to ensure that it is set before preExecute()
    // gets called.
    $this->addTag('tablesort');
  }
  
  /**
   * Order the query based on a header array.
   *
   * @param array $header
   *   Table header array.
   *
   * @return \Drupal\Core\Database\Query\SelectInterface
   *   The called object.
   *
   * @see table.html.twig
   */
  public function orderByHeader(array $header) {
    $context = TableSort::getContextFromRequest($header, \Drupal::request());
    if (!empty($context['sql'])) {
      // Based on code from \Drupal\Core\Database\Connection::escapeTable(),
      // but this can also contain a dot.
      $field = preg_replace('/[^A-Za-z0-9_.]+/', '', $context['sql']);
      // orderBy() will ensure that only ASC/DESC values are accepted, so we
      // don't need to sanitize that here.
      $this->orderBy($field, $context['sort']);
    }
    return $this;
  }

}

Classes

Title Deprecated Summary
TableSortExtender Query extender class for tablesort queries.

Buggy or inaccurate documentation? Please file an issue. Need support? Need help programming? Connect with the Drupal community.