View source
<?php
namespace Drupal\views\Plugin\views\pager;
use Drupal\Core\Cache\Cache;
use Drupal\Core\Cache\CacheableDependencyInterface;
use Drupal\Core\Form\FormStateInterface;
use Drupal\Core\Pager\PagerManagerInterface;
use Drupal\Core\Pager\PagerParametersInterface;
use Drupal\Core\Plugin\ContainerFactoryPluginInterface;
use Symfony\Component\DependencyInjection\ContainerInterface;
abstract class SqlBase extends PagerPluginBase implements CacheableDependencyInterface, ContainerFactoryPluginInterface {
protected $pagerManager;
protected $pagerParameters;
public function __construct(array $configuration, $plugin_id, $plugin_definition, PagerManagerInterface $pager_manager, PagerParametersInterface $pager_parameters) {
parent::__construct($configuration, $plugin_id, $plugin_definition);
$this->pagerManager = $pager_manager;
$this->pagerParameters = $pager_parameters;
}
public static function create(ContainerInterface $container, array $configuration, $plugin_id, $plugin_definition) {
return new static($configuration, $plugin_id, $plugin_definition, $container
->get('pager.manager'), $container
->get('pager.parameters'));
}
protected function defineOptions() {
$options = parent::defineOptions();
$options['items_per_page'] = [
'default' => 10,
];
$options['offset'] = [
'default' => 0,
];
$options['id'] = [
'default' => 0,
];
$options['total_pages'] = [
'default' => '',
];
$options['pagination_heading_level'] = [
'default' => 'h4',
];
$options['expose'] = [
'contains' => [
'items_per_page' => [
'default' => FALSE,
],
'items_per_page_label' => [
'default' => $this
->t('Items per page'),
],
'items_per_page_options' => [
'default' => '5, 10, 25, 50',
],
'items_per_page_options_all' => [
'default' => FALSE,
],
'items_per_page_options_all_label' => [
'default' => $this
->t('- All -'),
],
'offset' => [
'default' => FALSE,
],
'offset_label' => [
'default' => $this
->t('Offset'),
],
],
];
$options['tags'] = [
'contains' => [
'previous' => [
'default' => $this
->t('‹ Previous'),
],
'next' => [
'default' => $this
->t('Next ›'),
],
],
];
return $options;
}
public function buildOptionsForm(&$form, FormStateInterface $form_state) {
parent::buildOptionsForm($form, $form_state);
$pager_text = $this->displayHandler
->getPagerText();
$form['pagination_heading_level'] = [
'#title' => $this
->t('Heading Level'),
'#type' => 'select',
'#options' => $this->headingOptions,
'#default_value' => $this->options['pagination_heading_level'],
'#description' => $this
->t('Choose a heading level equal to or one lower than the preceding header.'),
'#fieldset' => 'style_settings',
];
$form['items_per_page'] = [
'#title' => $pager_text['items per page title'],
'#type' => 'number',
'#min' => 0,
'#description' => $pager_text['items per page description'],
'#default_value' => $this->options['items_per_page'],
];
$form['offset'] = [
'#type' => 'number',
'#min' => 0,
'#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'] = [
'#type' => 'number',
'#min' => 0,
'#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'] = [
'#type' => 'number',
'#min' => 0,
'#title' => $this
->t('Number of pages'),
'#description' => $this
->t('Leave empty to show all pages.'),
'#default_value' => $this->options['total_pages'],
];
$form['tags'] = [
'#type' => 'details',
'#open' => TRUE,
'#tree' => TRUE,
'#title' => $this
->t('Pager link labels'),
'#input' => TRUE,
];
$form['tags']['previous'] = [
'#type' => 'textfield',
'#title' => $this
->t('Previous page link text'),
'#default_value' => $this->options['tags']['previous'],
];
$form['tags']['next'] = [
'#type' => 'textfield',
'#title' => $this
->t('Next page link text'),
'#default_value' => $this->options['tags']['next'],
];
$form['expose'] = [
'#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'] = [
'#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'] = [
'#type' => 'textfield',
'#title' => $this
->t('Items per page label'),
'#required' => TRUE,
'#default_value' => $this->options['expose']['items_per_page_label'],
'#states' => [
'invisible' => [
'input[name="pager_options[expose][items_per_page]"]' => [
'checked' => FALSE,
],
],
],
];
$form['expose']['items_per_page_options'] = [
'#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' => [
'invisible' => [
'input[name="pager_options[expose][items_per_page]"]' => [
'checked' => FALSE,
],
],
],
];
$form['expose']['items_per_page_options_all'] = [
'#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'] = [
'#type' => 'textfield',
'#title' => $this
->t('All items label'),
'#default_value' => $this->options['expose']['items_per_page_options_all_label'],
'#states' => [
'invisible' => [
'input[name="pager_options[expose][items_per_page_options_all]"]' => [
'checked' => FALSE,
],
],
],
];
$form['expose']['offset'] = [
'#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'] = [
'#type' => 'textfield',
'#title' => $this
->t('Offset label'),
'#required' => TRUE,
'#default_value' => $this->options['expose']['offset_label'],
'#states' => [
'invisible' => [
'input[name="pager_options[expose][offset]"]' => [
'checked' => FALSE,
],
],
],
];
}
public function validateOptionsForm(&$form, FormStateInterface $form_state) {
$error = FALSE;
$exposed_options = $form_state
->getValue([
'pager_options',
'expose',
'items_per_page_options',
]);
if (str_contains($exposed_options, '.')) {
$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'));
}
if (!$form_state
->isValueEmpty([
'pager_options',
'expose',
'items_per_page',
]) && !$form_state
->isValueEmpty([
'pager_options',
'items_per_page',
])) {
$items_per_page = $form_state
->getValue([
'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).", [
'@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 ((int) $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);
}
public function setCurrentPage($number = NULL) {
if (isset($number)) {
$this->current_page = max(0, $number);
return;
}
$this->current_page = max(0, $this->pagerParameters
->findPage($this->options['id']));
}
public function getPagerTotal() {
if ($items_per_page = intval($this
->getItemsPerPage())) {
return ceil($this->total_items / $items_per_page);
}
else {
return 1;
}
}
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'];
}
}
$items_per_page = $this
->getItemsPerPage();
if (!empty($items_per_page)) {
$pager = $this->pagerManager
->createPager($this
->getTotalItems(), $this->options['items_per_page'], $this->options['id']);
if ($this
->getCurrentPage() >= $pager
->getTotalPages()) {
$this
->setCurrentPage($pager
->getTotalPages() - 1);
}
}
}
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 = [];
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'] = [
'#type' => 'select',
'#title' => $this->options['expose']['items_per_page_label'],
'#options' => $sanitized_options,
'#default_value' => $this
->getItemsPerPage(),
];
}
}
if ($this
->isOffsetExposed()) {
$form['offset'] = [
'#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 a number greater than or equal to 0.'));
}
}
}
public function getCacheMaxAge() {
return Cache::PERMANENT;
}
public function getCacheContexts() {
return [
'url.query_args',
];
}
public function getCacheTags() {
return [];
}
}