abstract class SqlBase in Zircon Profile 8

Same name in this branch

8 core/modules/views/src/Plugin/views/pager/SqlBase.php \Drupal\views\Plugin\views\pager\SqlBase
8 core/modules/migrate/src/Plugin/migrate/source/SqlBase.php \Drupal\migrate\Plugin\migrate\source\SqlBase

Same name and namespace in other branches

8.0 core/modules/views/src/Plugin/views/pager/SqlBase.php \Drupal\views\Plugin\views\pager\SqlBase

A common base class for sql based pager.

Hierarchy

class \Drupal\Component\Plugin\PluginBase implements DerivativeInspectionInterface, PluginInspectionInterface
- class \Drupal\Core\Plugin\PluginBase uses DependencySerializationTrait, StringTranslationTrait
  - class \Drupal\views\Plugin\views\PluginBase implements DependentPluginInterface, ContainerFactoryPluginInterface, ViewsPluginInterface
    class \Drupal\views\Plugin\views\pager\PagerPluginBase
    class \Drupal\views\Plugin\views\pager\SqlBase implements CacheableDependencyInterface

Expanded class hierarchy of SqlBase

File

core/modules/views/src/Plugin/views/pager/SqlBase.php, line 17: Contains \Drupal\views\Plugin\views\pager\SqlBase.

Namespace

Drupal\views\Plugin\views\pager

View source

abstract class SqlBase extends PagerPluginBase implements CacheableDependencyInterface {
  protected function defineOptions() {
    $options = parent::defineOptions();
    $options['items_per_page'] = array(
      'default' => 10,
    );
    $options['offset'] = array(
      'default' => 0,
    );
    $options['id'] = array(
      'default' => 0,
    );
    $options['total_pages'] = array(
      'default' => '',
    );
    $options['expose'] = array(
      'contains' => array(
        'items_per_page' => array(
          'default' => FALSE,
        ),
        'items_per_page_label' => array(
          'default' => $this
            ->t('Items per page'),
        ),
        'items_per_page_options' => array(
          'default' => '5, 10, 25, 50',
        ),
        'items_per_page_options_all' => array(
          'default' => FALSE,
        ),
        'items_per_page_options_all_label' => array(
          'default' => $this
            ->t('- All -'),
        ),
        'offset' => array(
          'default' => FALSE,
        ),
        'offset_label' => array(
          'default' => $this
            ->t('Offset'),
        ),
      ),
    );
    $options['tags'] = array(
      'contains' => array(
        'previous' => array(
          'default' => $this
            ->t('‹ Previous'),
        ),
        'next' => array(
          'default' => $this
            ->t('Next ›'),
        ),
      ),
    );
    return $options;
  }

  /**
   * Provide the default form for setting options.
   */
  public function buildOptionsForm(&$form, FormStateInterface $form_state) {
    parent::buildOptionsForm($form, $form_state);
    $pager_text = $this->displayHandler
      ->getPagerText();
    $form['items_per_page'] = array(
      '#title' => $pager_text['items per page title'],
      '#type' => 'number',
      '#description' => $pager_text['items per page description'],
      '#default_value' => $this->options['items_per_page'],
    );
    $form['offset'] = array(
      '#type' => 'number',
      '#title' => $this
        ->t('Offset (number of items to skip)'),
      '#description' => $this
        ->t('For example, set this to 3 and the first 3 items will not be displayed.'),
      '#default_value' => $this->options['offset'],
    );
    $form['id'] = array(
      '#type' => 'number',
      '#title' => $this
        ->t('Pager ID'),
      '#description' => $this
        ->t("Unless you're experiencing problems with pagers related to this view, you should leave this at 0. If using multiple pagers on one page you may need to set this number to a higher value so as not to conflict within the ?page= array. Large values will add a lot of commas to your URLs, so avoid if possible."),
      '#default_value' => $this->options['id'],
    );
    $form['total_pages'] = array(
      '#type' => 'number',
      '#title' => $this
        ->t('Number of pages'),
      '#description' => $this
        ->t('The total number of pages. Leave empty to show all pages.'),
      '#default_value' => $this->options['total_pages'],
    );
    $form['tags'] = array(
      '#type' => 'details',
      '#open' => TRUE,
      '#tree' => TRUE,
      '#title' => $this
        ->t('Pager link labels'),
      '#input' => TRUE,
    );
    $form['tags']['previous'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('Previous page link text'),
      '#default_value' => $this->options['tags']['previous'],
    );
    $form['tags']['next'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('Next page link text'),
      '#default_value' => $this->options['tags']['next'],
    );
    $form['expose'] = array(
      '#type' => 'details',
      '#open' => TRUE,
      '#tree' => TRUE,
      '#title' => $this
        ->t('Exposed options'),
      '#input' => TRUE,
      '#description' => $this
        ->t('Allow user to control selected display options for this view.'),
    );
    $form['expose']['items_per_page'] = array(
      '#type' => 'checkbox',
      '#title' => $this
        ->t('Allow user to control the number of items displayed in this view'),
      '#default_value' => $this->options['expose']['items_per_page'],
    );
    $form['expose']['items_per_page_label'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('Items per page label'),
      '#required' => TRUE,
      '#default_value' => $this->options['expose']['items_per_page_label'],
      '#states' => array(
        'invisible' => array(
          'input[name="pager_options[expose][items_per_page]"]' => array(
            'checked' => FALSE,
          ),
        ),
      ),
    );
    $form['expose']['items_per_page_options'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('Exposed items per page options'),
      '#required' => TRUE,
      '#description' => $this
        ->t('Set between which values the user can choose when determining the items per page. Separated by comma.'),
      '#default_value' => $this->options['expose']['items_per_page_options'],
      '#states' => array(
        'invisible' => array(
          'input[name="pager_options[expose][items_per_page]"]' => array(
            'checked' => FALSE,
          ),
        ),
      ),
    );
    $form['expose']['items_per_page_options_all'] = array(
      '#type' => 'checkbox',
      '#title' => $this
        ->t('Allow user to display all items'),
      '#default_value' => $this->options['expose']['items_per_page_options_all'],
    );
    $form['expose']['items_per_page_options_all_label'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('All items label'),
      '#default_value' => $this->options['expose']['items_per_page_options_all_label'],
      '#states' => array(
        'invisible' => array(
          'input[name="pager_options[expose][items_per_page_options_all]"]' => array(
            'checked' => FALSE,
          ),
        ),
      ),
    );
    $form['expose']['offset'] = array(
      '#type' => 'checkbox',
      '#title' => $this
        ->t('Allow user to specify number of items skipped from beginning of this view.'),
      '#default_value' => $this->options['expose']['offset'],
    );
    $form['expose']['offset_label'] = array(
      '#type' => 'textfield',
      '#title' => $this
        ->t('Offset label'),
      '#required' => TRUE,
      '#default_value' => $this->options['expose']['offset_label'],
      '#states' => array(
        'invisible' => array(
          'input[name="pager_options[expose][offset]"]' => array(
            'checked' => FALSE,
          ),
        ),
      ),
    );
  }
  public function validateOptionsForm(&$form, FormStateInterface $form_state) {

    // Only accept integer values.
    $error = FALSE;
    $exposed_options = $form_state
      ->getValue(array(
      'pager_options',
      'expose',
      'items_per_page_options',
    ));
    if (strpos($exposed_options, '.') !== FALSE) {
      $error = TRUE;
    }
    $options = explode(',', $exposed_options);
    if (!$error && is_array($options)) {
      foreach ($options as $option) {
        if (!is_numeric($option) || intval($option) == 0) {
          $error = TRUE;
        }
      }
    }
    else {
      $error = TRUE;
    }
    if ($error) {
      $form_state
        ->setErrorByName('pager_options][expose][items_per_page_options', $this
        ->t('Insert a list of integer numeric values separated by commas: e.g: 10, 20, 50, 100'));
    }

    // Make sure that the items_per_page is part of the expose settings.
    if (!$form_state
      ->isValueEmpty(array(
      'pager_options',
      'expose',
      'items_per_page',
    )) && !$form_state
      ->isValueEmpty(array(
      'pager_options',
      'items_per_page',
    ))) {
      $items_per_page = $form_state
        ->getValue(array(
        'pager_options',
        'items_per_page',
      ));
      if (array_search($items_per_page, $options) === FALSE) {
        $form_state
          ->setErrorByName('pager_options][expose][items_per_page_options', $this
          ->t("The <em>Exposed items per page</em> field's options must include the value from the <em>Items per page</em> field (@items_per_page).", array(
          '@items_per_page' => $items_per_page,
        )));
      }
    }
  }
  public function query() {
    if ($this
      ->itemsPerPageExposed()) {
      $query = $this->view
        ->getRequest()->query;
      $items_per_page = $query
        ->get('items_per_page');
      if ($items_per_page > 0) {
        $this->options['items_per_page'] = $items_per_page;
      }
      elseif ($items_per_page == 'All' && $this->options['expose']['items_per_page_options_all']) {
        $this->options['items_per_page'] = 0;
      }
    }
    if ($this
      ->isOffsetExposed()) {
      $query = $this->view
        ->getRequest()->query;
      $offset = $query
        ->get('offset');
      if (isset($offset) && $offset >= 0) {
        $this->options['offset'] = $offset;
      }
    }
    $limit = $this->options['items_per_page'];
    $offset = $this->current_page * $this->options['items_per_page'] + $this->options['offset'];
    if (!empty($this->options['total_pages'])) {
      if ($this->current_page >= $this->options['total_pages']) {
        $limit = $this->options['items_per_page'];
        $offset = $this->options['total_pages'] * $this->options['items_per_page'];
      }
    }
    $this->view->query
      ->setLimit($limit);
    $this->view->query
      ->setOffset($offset);
  }

  /**
   * Set the current page.
   *
   * @param $number
   *   If provided, the page number will be set to this. If NOT provided,
   *   the page number will be set from the global page array.
   */
  public function setCurrentPage($number = NULL) {
    if (isset($number)) {
      $this->current_page = max(0, $number);
      return;
    }

    // If the current page number was not specified, extract it from the global
    // page array.
    global $pager_page_array;
    if (empty($pager_page_array)) {
      $pager_page_array = array();
    }

    // Fill in missing values in the global page array, in case the global page
    // array hasn't been initialized before.
    $page = $this->view
      ->getRequest()->query
      ->get('page');
    $page = isset($page) ? explode(',', $page) : array();
    for ($i = 0; $i <= $this->options['id'] || $i < count($pager_page_array); $i++) {
      $pager_page_array[$i] = empty($page[$i]) ? 0 : $page[$i];
    }

    // Don't allow the number to be less than zero.
    $this->current_page = max(0, intval($pager_page_array[$this->options['id']]));
  }
  public function getPagerTotal() {
    if ($items_per_page = intval($this
      ->getItemsPerPage())) {
      return ceil($this->total_items / $items_per_page);
    }
    else {
      return 1;
    }
  }

  /**
   * Update global paging info.
   *
   * This is called after the count query has been run to set the total
   * items available and to update the current page if the requested
   * page is out of range.
   */
  public function updatePageInfo() {
    if (!empty($this->options['total_pages'])) {
      if ($this->options['total_pages'] * $this->options['items_per_page'] < $this->total_items) {
        $this->total_items = $this->options['total_pages'] * $this->options['items_per_page'];
      }
    }

    // Don't set pager settings for items per page = 0.
    $items_per_page = $this
      ->getItemsPerPage();
    if (!empty($items_per_page)) {

      // Dump information about what we already know into the globals.
      global $pager_page_array, $pager_total, $pager_total_items, $pager_limits;

      // Set the limit.
      $pager_limits[$this->options['id']] = $this->options['items_per_page'];

      // Set the item count for the pager.
      $pager_total_items[$this->options['id']] = $this->total_items;

      // Calculate and set the count of available pages.
      $pager_total[$this->options['id']] = $this
        ->getPagerTotal();

      // See if the requested page was within range:
      if ($this->current_page >= $pager_total[$this->options['id']]) {

        // Pages are numbered from 0 so if there are 10 pages, the last page is 9.
        $this
          ->setCurrentPage($pager_total[$this->options['id']] - 1);
      }

      // Put this number in to guarantee that we do not generate notices when the pager
      // goes to look for it later.
      $pager_page_array[$this->options['id']] = $this->current_page;
    }
  }
  public function usesExposed() {
    return $this
      ->itemsPerPageExposed() || $this
      ->isOffsetExposed();
  }
  protected function itemsPerPageExposed() {
    return !empty($this->options['expose']['items_per_page']);
  }
  protected function isOffsetExposed() {
    return !empty($this->options['expose']['offset']);
  }
  public function exposedFormAlter(&$form, FormStateInterface $form_state) {
    if ($this
      ->itemsPerPageExposed()) {
      $options = explode(',', $this->options['expose']['items_per_page_options']);
      $sanitized_options = array();
      if (is_array($options)) {
        foreach ($options as $option) {
          $sanitized_options[intval($option)] = intval($option);
        }
        if (!empty($this->options['expose']['items_per_page_options_all']) && !empty($this->options['expose']['items_per_page_options_all_label'])) {
          $sanitized_options['All'] = $this->options['expose']['items_per_page_options_all_label'];
        }
        $form['items_per_page'] = array(
          '#type' => 'select',
          '#title' => $this->options['expose']['items_per_page_label'],
          '#options' => $sanitized_options,
          '#default_value' => $this
            ->getItemsPerPage(),
        );
      }
    }
    if ($this
      ->isOffsetExposed()) {
      $form['offset'] = array(
        '#type' => 'textfield',
        '#size' => 10,
        '#maxlength' => 10,
        '#title' => $this->options['expose']['offset_label'],
        '#default_value' => $this
          ->getOffset(),
      );
    }
  }
  public function exposedFormValidate(&$form, FormStateInterface $form_state) {
    if (!$form_state
      ->isValueEmpty('offset') && trim($form_state
      ->getValue('offset'))) {
      if (!is_numeric($form_state
        ->getValue('offset')) || $form_state
        ->getValue('offset') < 0) {
        $form_state
          ->setErrorByName('offset', $this
          ->t('Offset must be an number greater or equal than 0.'));
      }
    }
  }

  /**
   * {@inheritdoc}
   */
  public function getCacheMaxAge() {
    return Cache::PERMANENT;
  }

  /**
   * {@inheritdoc}
   */
  public function getCacheContexts() {

    // The rendered link needs to play well with any other query parameter used
    // on the page, like other pagers and exposed filter.
    return [
      'url.query_args',
    ];
  }

  /**
   * {@inheritdoc}
   */
  public function getCacheTags() {
    return [];
  }

}

Members

Name	Modifiers	Type	Description	Overrides
DependencySerializationTrait::$_serviceIds	protected	property	An array of service IDs keyed by property name used for serialization.
DependencySerializationTrait::__sleep	public	function		1
DependencySerializationTrait::__wakeup	public	function		2
PagerPluginBase::$current_page		property
PagerPluginBase::$total_items		property
PagerPluginBase::$usesOptions	protected	property	Denotes whether the plugin has an additional options form. Overrides PluginBase::$usesOptions
PagerPluginBase::executeCountQuery	public	function	Execute the count query, which will be done just prior to the query itself being executed.	1
PagerPluginBase::exposedFormSubmit	public	function
PagerPluginBase::getCurrentPage	public	function	Get the current page.
PagerPluginBase::getItemsPerPage	public	function	Get how many items per page this pager will display.	1
PagerPluginBase::getOffset	public	function	Get the page offset, or how many items to skip.
PagerPluginBase::getPagerId	public	function	Get the pager id, if it exists
PagerPluginBase::getTotalItems	public	function	Get the total number of items.
PagerPluginBase::hasMoreRecords	public	function	Determine if there are more records available.
PagerPluginBase::postExecute	public	function	Perform any needed actions just after the query executing.	2
PagerPluginBase::preExecute	public	function	Perform any needed actions just prior to the query executing.
PagerPluginBase::preRender	public	function	Perform any needed actions just before rendering.
PagerPluginBase::render	public	function	Return the renderable array of the pager.	2
PagerPluginBase::setItemsPerPage	public	function	Set how many items per page this pager will display.
PagerPluginBase::setOffset	public	function	Set the page offset, or how many items to skip.
PagerPluginBase::submitOptionsForm	public	function	Provide the default form form for submitting options Overrides PluginBase::submitOptionsForm
PagerPluginBase::summaryTitle	public	function	Return a string to display as the clickable title for the pager plugin. Overrides PluginBase::summaryTitle	4
PagerPluginBase::useCountQuery	public	function	Determine if a pager needs a count query.	3
PagerPluginBase::usePager	public	function	Determine if this pager actually uses a pager.	2
PluginBase::$configuration	protected	property	Configuration information passed into the plugin.	2
PluginBase::$definition	public	property	Plugins's definition
PluginBase::$displayHandler	public	property	The display object this plugin is for.
PluginBase::$options	public	property	Options for this plugin will be held here.
PluginBase::$pluginDefinition	protected	property	The plugin implementation definition.
PluginBase::$pluginId	protected	property	The plugin_id.
PluginBase::$renderer	protected	property	Stores the render API renderer.	2
PluginBase::$view	public	property	The top object of a view.	1
PluginBase::calculateDependencies	public	function	Calculates dependencies for the configured plugin. Overrides DependentPluginInterface::calculateDependencies	20
PluginBase::create	public static	function	Creates an instance of the plugin. Overrides ContainerFactoryPluginInterface::create	50
PluginBase::DERIVATIVE_SEPARATOR		constant	A string which is used to separate base plugin IDs from the derivative ID.
PluginBase::destroy	public	function	Clears a plugin. Overrides ViewsPluginInterface::destroy	2
PluginBase::doFilterByDefinedOptions	protected	function	Do the work to filter out stored options depending on the defined options.
PluginBase::filterByDefinedOptions	public	function	Filter out stored options depending on the defined options. Overrides ViewsPluginInterface::filterByDefinedOptions
PluginBase::getAvailableGlobalTokens	public	function	Returns an array of available token replacements. Overrides ViewsPluginInterface::getAvailableGlobalTokens
PluginBase::getBaseId	public	function	Gets the base_plugin_id of the plugin instance. Overrides DerivativeInspectionInterface::getBaseId
PluginBase::getDerivativeId	public	function	Gets the derivative_id of the plugin instance. Overrides DerivativeInspectionInterface::getDerivativeId
PluginBase::getPluginDefinition	public	function	Gets the definition of the plugin implementation. Overrides PluginInspectionInterface::getPluginDefinition
PluginBase::getPluginId	public	function	Gets the plugin_id of the plugin instance. Overrides PluginInspectionInterface::getPluginId
PluginBase::getProvider	public	function	Returns the plugin provider. Overrides ViewsPluginInterface::getProvider
PluginBase::getRenderer	protected	function	Returns the render API renderer.	1
PluginBase::globalTokenForm	public	function	Adds elements for available core tokens to a form. Overrides ViewsPluginInterface::globalTokenForm
PluginBase::globalTokenReplace	public	function	Returns a string with any core tokens replaced. Overrides ViewsPluginInterface::globalTokenReplace
PluginBase::INCLUDE_ENTITY		constant	Include entity row languages when listing languages.
PluginBase::INCLUDE_NEGOTIATED		constant	Include negotiated languages when listing languages.
PluginBase::init	public	function	Initialize the plugin. Overrides ViewsPluginInterface::init	8
PluginBase::listLanguages	protected	function	Makes an array of languages, optionally including special languages.
PluginBase::pluginTitle	public	function	Return the human readable name of the display. Overrides ViewsPluginInterface::pluginTitle
PluginBase::preRenderAddFieldsetMarkup	public static	function	Moves form elements into fieldsets for presentation purposes. Overrides ViewsPluginInterface::preRenderAddFieldsetMarkup
PluginBase::preRenderFlattenData	public static	function	Flattens the structure of form elements. Overrides ViewsPluginInterface::preRenderFlattenData
PluginBase::queryLanguageSubstitutions	public static	function	Returns substitutions for Views queries for languages.
PluginBase::setOptionDefaults	protected	function	Fills up the options of the plugin with defaults.
PluginBase::themeFunctions	public	function	Provide a full list of possible theme templates used by this style. Overrides ViewsPluginInterface::themeFunctions	1
PluginBase::unpackOptions	public	function	Unpack options over our existing defaults, drilling down into arrays so that defaults don't get totally blown away. Overrides ViewsPluginInterface::unpackOptions
PluginBase::usesOptions	public	function	Returns the usesOptions property. Overrides ViewsPluginInterface::usesOptions	8
PluginBase::validate	public	function	Validate that the plugin is correct and can be saved. Overrides ViewsPluginInterface::validate	5
PluginBase::viewsTokenReplace	protected	function	Replaces Views' tokens in a given string. The resulting string will be sanitized with Xss::filterAdmin.	1
PluginBase::VIEWS_QUERY_LANGUAGE_SITE_DEFAULT		constant	Query string to indicate the site default language.
PluginBase::__construct	public	function	Constructs a PluginBase object. Overrides PluginBase::__construct
SqlBase::buildOptionsForm	public	function	Provide the default form for setting options. Overrides PluginBase::buildOptionsForm	1
SqlBase::defineOptions	protected	function	Information about options for all kinds of purposes will be held here. Overrides PluginBase::defineOptions	2
SqlBase::exposedFormAlter	public	function	Overrides PagerPluginBase::exposedFormAlter
SqlBase::exposedFormValidate	public	function	Overrides PagerPluginBase::exposedFormValidate
SqlBase::getCacheContexts	public	function	The cache contexts associated with this object. Overrides CacheableDependencyInterface::getCacheContexts
SqlBase::getCacheMaxAge	public	function	The maximum age for which this object may be cached. Overrides CacheableDependencyInterface::getCacheMaxAge
SqlBase::getCacheTags	public	function	The cache tags associated with this object. Overrides CacheableDependencyInterface::getCacheTags
SqlBase::getPagerTotal	public	function
SqlBase::isOffsetExposed	protected	function	Overrides PagerPluginBase::isOffsetExposed
SqlBase::itemsPerPageExposed	protected	function	Overrides PagerPluginBase::itemsPerPageExposed
SqlBase::query	public	function	Modify the query for paging Overrides PagerPluginBase::query
SqlBase::setCurrentPage	public	function	Set the current page. Overrides PagerPluginBase::setCurrentPage
SqlBase::updatePageInfo	public	function	Update global paging info. Overrides PagerPluginBase::updatePageInfo
SqlBase::usesExposed	public	function	Overrides PagerPluginBase::usesExposed
SqlBase::validateOptionsForm	public	function	Provide the default form form for validating options Overrides PagerPluginBase::validateOptionsForm
StringTranslationTrait::$stringTranslation	protected	property	The string translation service.
StringTranslationTrait::formatPlural	protected	function	Formats a string containing a count of items.
StringTranslationTrait::getNumberOfPlurals	protected	function	Returns the number of plurals supported by a given language.
StringTranslationTrait::getStringTranslation	protected	function	Gets the string translation service.
StringTranslationTrait::setStringTranslation	public	function	Sets the string translation service to use.	2
StringTranslationTrait::t	protected	function	Translates a string to the current language or to a given language.

You are here

abstract class SqlBase in Zircon Profile 8

Hierarchy

File

Namespace

Members

API Navigation