Paginate from within a model in CakePHP

by

The way I figured out how I can keep my complex find in my model without having to rewrite it a second time in the controller is by passing a $paginate boolean variable.

If $paginate is true, it returns just the options created, which can then be used in the controller’s pagination. If it’s false (meaning we don’t want to paginate), it returns the actual event results. So far this seems to be working.

In my getEvents() function (this method is in the Events model)

    if($paginate) {
        return $qOpts; // Just return the options for the paginate in the controller to use
    } else {
        $data = $this->find('all', $qOpts); // Return the actual events
        return $data;
    }

Then, in my Events/Index (events controller, index action – where I know I want pagination):

$this->Event->recursive = -1; // (or set recursive = -1 in the appModel)
$opts['paginate'] = true;

$paginateOptions = $this->Event->getEvents($opts);

$this->paginate = $paginateOptions; // Set paginate options to just-returned options
$data = $this->paginate('Event'); // Get paginate results
$this->set('data', $data); // Set variable to hold paginated results in view

More Related Contents:

  1. How to paginate associated records?
  2. How to filter by conditions for associated models?
  3. CakePHP 3.0 installation: intl extension missing from system
  4. How to limit contained associations per record/group?
  5. Fat models, skinny controllers and the MVC design pattern
  6. CakePHP 3.0 -> Between find condition
  7. How to use multiple databases dynamically for one model in CakePHP
  8. Can I use one model inside of a different model in CakePHP?
  9. Set Response Status Code [duplicate]
  10. How do I write a join query across multiple tables in CakePHP?
  11. How to setup cronjobs in cake php?
  12. How to use different datasources in a Query using cakephp3?
  13. What is the equivalent to getLastInsertId() in Cakephp?
  14. How to Install DebugKit on CakePHP
  15. CakePHP: best way to call an action of another controller with array as parameter?
  16. How to eliminate php5 Strict standards errors?
  17. How do I create a keyValue pair (display field) by combining/having two fields in CakePHP 3?
  18. How to create a `IN` clause in CakePHP query?
  19. CakePHP switch database (using same datasource) on the fly?
  20. sum() function in cakephp query
  21. Listing , pagination and search custom user data by role in wordpress
  22. How should a model be structured in MVC? [closed]
  23. Php-intl installation on XAMPP
  24. How to paginate a collection after get() in Laravel?
  25. How to set a default attribute value for a Laravel / Eloquent model?
  26. Undefined variable: $_SESSION
  27. what is difference between a Model and an Entity
  28. Efficient paging in MongoDB using mgo
  29. Rails: Skinny Controller vs. Fat Model, or should I make my Controller Anorexic?
  30. Cron Dispatcher CakePHP 2.0

Leave a Comment