This class is used to handle automatic model data pagination.
array<string, mixed>
Runtime config
bool
Whether the config property has already been configured with defaults
array<string, mixed>
Default pagination settings.
array<string, array>
Paging params after pagination operation is done.
Deletes a single config key.
Reads a config key.
Writes a config key.
Extracts the finder name and options out of the provided pagination options.
Prefixes the field with the table alias if possible.
Remove alias if needed.
Add "page" and "pageCount" params.
Add "prevPage" and "nextPage" params.
Add sorting / ordering params.
Add "start" and "end" params.
Build pagination params.
Check the limit parameter and ensure it's within the maxLimit bounds.
Merge provided config with existing config. Unlike config()
which does a recursive merge for nested keys, this method does a simple merge.
Extract pagination data needed
Shim method for reading the deprecated whitelist or allowedParameters options
Returns the config.
Returns the config for this specific key.
Get total count of records.
Get the settings for a $model. If there are no settings for a specific repository, the general settings will be used.
Get paging params after pagination operation.
Get query for fetching paginated results.
Shim method for reading the deprecated sortWhitelist or sortableFields options.
Merges the various options that Paginator uses. Pulls settings together from the following places:
Handles automatic pagination of model records.
Sets the config.
Validate that the desired sorting can be performed on the $object.
_configDelete(string $key): void
Deletes a single config key.
string
$key Key to delete.
void
Cake\Core\Exception\CakeException
_configRead(string|null $key): mixed
Reads a config key.
string|null
$key Key to read.
mixed
_configWrite(array<string, mixed>|string $key, mixed $value, string|bool $merge = false): void
Writes a config key.
array<string, mixed>|string
$key Key to write to.
mixed
$value Value to write.
string|bool
$merge optional True to merge recursively, 'shallow' for simple merge, false to overwrite, defaults to false.
void
Cake\Core\Exception\CakeException
_extractFinder(array<string, mixed> $options): array
Extracts the finder name and options out of the provided pagination options.
array<string, mixed>
$options the pagination options.
array
_prefix(Cake\Datasource\RepositoryInterface $object, array $order, bool $allowed = false): array
Prefixes the field with the table alias if possible.
Cake\Datasource\RepositoryInterface
$object Repository object.
array
$order Order array.
bool
$allowed optional Whether the field was allowed.
array
_removeAliases(array<string, mixed> $fields, string $model): array<string, mixed>
Remove alias if needed.
array<string, mixed>
$fields Current fields
string
$model Current model alias
array<string, mixed>
addPageCountParams(array<string, mixed> $params, array $data): array<string, mixed>
Add "page" and "pageCount" params.
array<string, mixed>
$params Paging params.
array
$data Paginator data.
array<string, mixed>
addPrevNextParams(array<string, mixed> $params, array $data): array<string, mixed>
Add "prevPage" and "nextPage" params.
array<string, mixed>
$params Paginator params.
array
$data Paging data.
array<string, mixed>
addSortingParams(array<string, mixed> $params, array $data): array<string, mixed>
Add sorting / ordering params.
array<string, mixed>
$params Paginator params.
array
$data Paging data.
array<string, mixed>
addStartEndParams(array<string, mixed> $params, array $data): array<string, mixed>
Add "start" and "end" params.
array<string, mixed>
$params Paging params.
array
$data Paginator data.
array<string, mixed>
buildParams(array<string, mixed> $data): array<string, mixed>
Build pagination params.
array<string, mixed>
$data Paginator data containing keys 'options', 'count', 'defaults', 'finder', 'numResults'.
array<string, mixed>
checkLimit(array<string, mixed> $options): array<string, mixed>
Check the limit parameter and ensure it's within the maxLimit bounds.
array<string, mixed>
$options An array of options with a limit key to be checked.
array<string, mixed>
configShallow(array<string, mixed>|string $key, mixed|null $value = null): $this
Merge provided config with existing config. Unlike config()
which does a recursive merge for nested keys, this method does a simple merge.
Setting a specific value:
$this->configShallow('key', $value);
Setting a nested value:
$this->configShallow('some.nested.key', $value);
Updating multiple config settings at the same time:
$this->configShallow(['one' => 'value', 'another' => 'value']);
array<string, mixed>|string
$key The key to set, or a complete array of configs.
mixed|null
$value optional The value to set.
$this
extractData(Cake\Datasource\RepositoryInterface $object, array<string, mixed> $params, array<string, mixed> $settings): array
Extract pagination data needed
Cake\Datasource\RepositoryInterface
$object The repository object.
array<string, mixed>
$params Request params
array<string, mixed>
$settings The settings/configuration used for pagination.
array
getAllowedParameters(): array<string>
Shim method for reading the deprecated whitelist or allowedParameters options
array<string>
getConfig(string|null $key = null, mixed $default = null): mixed
Returns the config.
Reading the whole config:
$this->getConfig();
Reading a specific value:
$this->getConfig('key');
Reading a nested value:
$this->getConfig('some.nested.key');
Reading with default value:
$this->getConfig('some-key', 'default-value');
string|null
$key optional The key to get or null for the whole config.
mixed
$default optional The return value when the key does not exist.
mixed
getConfigOrFail(string $key): mixed
Returns the config for this specific key.
The config value for this key must exist, it can never be null.
string
$key The key to get.
mixed
InvalidArgumentException
getCount(Cake\Datasource\QueryInterface $query, array $data): int|null
Get total count of records.
Cake\Datasource\QueryInterface
$query Query instance.
array
$data Pagination data.
int|null
getDefaults(string $alias, array<string, mixed> $settings): array<string, mixed>
Get the settings for a $model. If there are no settings for a specific repository, the general settings will be used.
string
$alias Model name to get settings for.
array<string, mixed>
$settings The settings which is used for combining.
array<string, mixed>
getPagingParams(): array<string, array>
Get paging params after pagination operation.
array<string, array>
getQuery(Cake\Datasource\RepositoryInterface $object, Cake\Datasource\QueryInterface|null $query, array<string, mixed> $data): Cake\Datasource\QueryInterface
Get query for fetching paginated results.
Cake\Datasource\RepositoryInterface
$object Repository instance.
Cake\Datasource\QueryInterface|null
$query Query Instance.
array<string, mixed>
$data Pagination data.
Cake\Datasource\QueryInterface
getSortableFields(array<string, mixed> $config): array<string>|null
Shim method for reading the deprecated sortWhitelist or sortableFields options.
array<string, mixed>
$config The configuration data to coalesce and emit warnings on.
array<string>|null
mergeOptions(array<string, mixed> $params, array $settings): array<string, mixed>
Merges the various options that Paginator uses. Pulls settings together from the following places:
The result of this method is the aggregate of all the option sets combined together. You can change config value allowedParameters
to modify which options/values can be set using request parameters.
array<string, mixed>
$params Request params.
array
$settings The settings to merge with the request data.
array<string, mixed>
paginate(Cake\Datasource\RepositoryInterfaceCake\Datasource\QueryInterface $object, array $params = [], array $settings = []): Cake\Datasource\ResultSetInterface
Handles automatic pagination of model records.
When calling paginate()
you can use the $settings parameter to pass in pagination settings. These settings are used to build the queries made and control other pagination settings.
If your settings contain a key with the current table's alias. The data inside that key will be used. Otherwise, the top level configuration will be used.
$settings = [ 'limit' => 20, 'maxLimit' => 100 ]; $results = $paginator->paginate($table, $settings);
The above settings will be used to paginate any repository. You can configure repository specific settings by keying the settings with the repository alias.
$settings = [ 'Articles' => [ 'limit' => 20, 'maxLimit' => 100 ], 'Comments' => [ ... ] ]; $results = $paginator->paginate($table, $settings);
This would allow you to have different pagination settings for Articles
and Comments
repositories.
By default CakePHP will automatically allow sorting on any column on the repository object being paginated. Often times you will want to allow sorting on either associated columns or calculated fields. In these cases you will need to define an allowed list of all the columns you wish to allow sorting on. You can define the allowed sort fields in the $settings
parameter:
$settings = [ 'Articles' => [ 'finder' => 'custom', 'sortableFields' => ['title', 'author_id', 'comment_count'], ] ];
Passing an empty array as sortableFields disallows sorting altogether.
You can paginate with any find type defined on your table using the finder
option.
$settings = [ 'Articles' => [ 'finder' => 'popular' ] ]; $results = $paginator->paginate($table, $settings);
Would paginate using the find('popular')
method.
You can also pass an already created instance of a query to this method:
$query = $this->Articles->find('popular')->matching('Tags', function ($q) { return $q->where(['name' => 'CakePHP']) }); $results = $paginator->paginate($query);
By using request parameter scopes you can paginate multiple queries in the same controller action:
$articles = $paginator->paginate($articlesQuery, ['scope' => 'articles']); $tags = $paginator->paginate($tagsQuery, ['scope' => 'tags']);
Each of the above queries will use different query string parameter sets for pagination data. An example URL paginating both results would be:
/dashboard?articles[page]=1&tags[page]=2
Cake\Datasource\RepositoryInterfaceCake\Datasource\QueryInterface
$object The repository or query to paginate.
array
$params optional Request params
array
$settings optional The settings/configuration used for pagination.
Cake\Datasource\ResultSetInterface
Cake\Datasource\Paging\Exception\PageOutOfBoundsException
setConfig(array<string, mixed>|string $key, mixed|null $value = null, bool $merge = true): $this
Sets the config.
Setting a specific value:
$this->setConfig('key', $value);
Setting a nested value:
$this->setConfig('some.nested.key', $value);
Updating multiple config settings at the same time:
$this->setConfig(['one' => 'value', 'another' => 'value']);
array<string, mixed>|string
$key The key to set, or a complete array of configs.
mixed|null
$value optional The value to set.
bool
$merge optional Whether to recursively merge or overwrite existing config, defaults to true.
$this
Cake\Core\Exception\CakeException
validateSort(Cake\Datasource\RepositoryInterface $object, array<string, mixed> $options): array<string, mixed>
Validate that the desired sorting can be performed on the $object.
Only fields or virtualFields can be sorted on. The direction param will also be sanitized. Lastly sort + direction keys will be converted into the model friendly order key.
You can use the allowedParameters option to control which columns/fields are available for sorting via URL parameters. This helps prevent users from ordering large result sets on un-indexed values.
If you need to sort on associated columns or synthetic properties you will need to use the sortableFields
option.
Any columns listed in the allowed sort fields will be implicitly trusted. You can use this to sort on synthetic columns, or columns added in custom find operations that may not exist in the schema.
The default order options provided to paginate() will be merged with the user's requested sorting field/direction.
Cake\Datasource\RepositoryInterface
$object Repository object.
array<string, mixed>
$options The pagination options being used for this request.
array<string, mixed>
Runtime config
array<string, mixed>
Whether the config property has already been configured with defaults
bool
Default pagination settings.
When calling paginate() these settings will be merged with the configuration you provide.
maxLimit
- The maximum limit users can choose to view. Defaults to 100limit
- The initial number of items per page. Defaults to 20.page
- The starting page, defaults to 1.allowedParameters
- A list of parameters users are allowed to set using request parameters. Modifying this list will allow users to have more influence over pagination, be careful with what you permit.array<string, mixed>
Paging params after pagination operation is done.
array<string, array>
© 2005–present The Cake Software Foundation, Inc.
Licensed under the MIT License.
CakePHP is a registered trademark of Cake Software Foundation, Inc.
We are not endorsed by or affiliated with CakePHP.
https://api.cakephp.org/4.4/class-Cake.Datasource.Paging.NumericPaginator.html