CakePHP 3.x Specify a Different Count Query for Pagination

0
votes

I am trying to customize the pagination query for CakePHP I am using a Model based around a view. The view has some complex calculations in it and when the pagination runs it takes about 3 seconds to pull the 20 rows or so. Then it is running the same view wrapped in a count for the count used in pagination. I can run a simple table count on another table which would cut the load times in half but I am unable to find a simple way to customize a seperate query to run for the counts. Is this even possible?

I know another user asked this question but it was never answered.

Cakephp 3.x Custom Query Pagination

I have tried the way that is used to work in 2.x using a custom paginateCount function in both the entity and the table and neither works I dug through the API a bit but couldn't find anything related to the count specifically.

1
cakephpcountpaginationquery-buildercakephp-3.x
what have you tried? book.cakephp.org/3.0/en/controllers/components/pagination.html – MontrealDevOne
I have updated my post. I have tried the ways that used to work in CakePHP 2.x days and I have tried looking through the API component for pagination. – KaffineAddict
did you read the documentation at book.cakephp.org/3.0/en/controllers/components/pagination.html – MontrealDevOne
@MontrealDevOne Much like you asked two days ago... yes I have – KaffineAddict

1 Answers

1
votes

One option would be to use the query builder's counter() method to provide a callback that returns the number of records based on your custom query.

$query->counter(function (\Cake\ORM\Query $query) {
    // assuming $this uses \Cake\ORM\Locator\LocatorAwareTrait
    $OtherTable = $this->getTableLocator()->get('Other');
    $otherQuery = $OtherTable->find();

    // ...

    return $otherQuery->count();
});

The $query argument will be a clone of the query itself. You can either modify that one, or construct a completely new query.

See also