Modify the query for paging
This is called during the build phase and can directly modify the query.
Overrides PagerPluginBase::query
public function query() {
if ($this
->itemsPerPageExposed()) {
$query = drupal_container()
->get('request')->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 = drupal_container()
->get('request')->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);
}