How to paginate associated records?

by

The paginator doesn’t support paginating associations, you’ll have to read the associated records manually in a separate query, and paginate that one, something along the lines of this:

$product = $this->Products
    ->findBySlug($slug_prod)
    ->contain(['Metas', 'Attachments'])
    ->first();

$categoriesQuery = $this->Products->Categories
    ->find()
    ->innerJoinWith('Products', function (\Cake\ORM\Query $query) use ($product) {
        return $query->where([
            'Products.id' => $product->id,
        ]);
    })
    ->group('Categories.id');

$paginationOptions = [
    'limit' => 6,
    'order' => [
        'Categories.title' => 'ASC'
    ]
];

$categories = $this->paginate($categoriesQuery, $paginationOptions);

$this->set(compact('product', 'categories'));

Then in your view template you can display your $product and separately paginate $categories as usual.

See also

More Related Contents:

  1. How to filter by conditions for associated models?
  2. How to limit contained associations per record/group?
  3. How to use different datasources in a Query using cakephp3?
  4. Paginate from within a model in CakePHP
  5. How to create a `IN` clause in CakePHP query?
  6. CakePHP 3.0 installation: intl extension missing from system
  7. How to output custom HTTP body contents with CakePHP 3.4? Echoing causes “Unable to emit headers” error
  8. CakePHP 3.0 -> Between find condition
  9. Can I use one model inside of a different model in CakePHP?
  10. How do I write a join query across multiple tables in CakePHP?
  11. Cakephp-3.x: How to change the data type of a selected alias?
  12. How to setup cronjobs in cake php?
  13. How to safely use reserved SQL names?
  14. What is the equivalent to getLastInsertId() in Cakephp?
  15. How to Install DebugKit on CakePHP
  16. How do I create a keyValue pair (display field) by combining/having two fields in CakePHP 3?
  17. sum() function in cakephp query
  18. Check if a user has scrolled to the bottom (not just the window, but any element) [duplicate]
  19. Best way to parse bbcode
  20. Find total number of results in mySQL query with offset+limit
  21. PHP Fatal error: Class ‘PDO’ not found
  22. Fat models, skinny controllers and the MVC design pattern
  23. Pagination not work for the RecyclerView within NestedScrollView
  24. Select entries between dates in doctrine 2
  25. Subquery in doctrine2 notIN Function
  26. How to correctly use PagedResourcesAssembler from Spring Data?
  27. Custom pagination view in Laravel 5
  28. UITableView load more when scrolling to bottom like Facebook application
  29. SQL Server 2008 paging methods?
  30. CakePHP switch database (using same datasource) on the fly?

Leave a Comment