http://debuggable.com/posts/how-to-paginate-a-search-using-the-cakephp-framework:48fc5f77-38d0-41e0-b711-77c64834cda3
-J.
On Dec 8, 3:45 pm, martinp <[EMAIL PROTECTED]> wrote:
> Hello
>
> I'd be grateful for any advice on the best way to do this. (Cake 1.2
> RC3)
>
> I have a model Course, which BelongsTo School, which hasMany
> Accommodation.
> I want to be able to filter by courses, types of school and types of
> accommodation.
>
> The results also need to be paginated.
>
> I've set up my model binding like this:
> $this->Course->bindModel(
> array(
> 'belongsTo' => array(
> 'School' => array(
> 'className' =>
> 'Schools.School',
> 'foreignKey' => 'school_id'
> )
> ),
> 'hasOne' => array(
> 'Accommodation' => array(
> 'className' =>
> 'Schools.Accommodation',
> 'foreignKey' => false,
> 'conditions' =>
> array('Accommodation.school_id =
> Course.school_id')
> )
> )
> ), false
> );
>
> The Course hasOne Accommodation rather than the School hasMany
> Accommodation to ensure that my accommodation results are returned and
> can be searched on.
>
> When I paginate I get a row for each accommodation as well as each
> course, i.e.:
>
> [rows] => Array
> (
> [0] => Array
> (
> [Course] => Array
> (
> [id] => 44
> [name] => Test course
> [school_id] => 4
> )
>
> [School] => Array
> (
> [id] => 4
> [name] => Test School
> )
>
> [Accommodation] => Array
> (
> [id] => 6
> [school_id] => 4
> [name] => Test Accommodation
> )
>
> )
>
> [1] => Array
> (
> [Course] => Array
> (
> [id] => 44
> [name] => Test course
> [school_id] => 4
>
> )
>
> [School] => Array
> (
> [id] => 4
> [name] => Test School
> )
>
> [Accommodation] => Array
> (
> [id] => 7
> [school_id] => 4
> [name] => Test Accommodation 2
> )
>
> )
> )
>
> What I'm looking to get is results 'grouped' by course, while still
> being able to filter by Accommodation field, e.g.:
>
> [rows] => Array
> (
> [0] => Array
> (
> [Course] => Array(...)
> [School] => Array(...)
> [Accommodation] => Array
> (
> [0] =>
> Array(...)
> [1] =>
> Array(...)
> )
> )
> )
>
> What's the best way to achieve this? Create a custom pagination query
> and then somehow manipulate the resulting results array?
>
> This is what I've added to my Course model so far:
>
> function paginate($conditions, $fields, $order, $limit, $page = 1,
> $recursive = null, $extra = array()) {
> $results = $this->find('all', array('conditions' => $conditions,
> 'fields' => $fields, 'order' => $order, 'limit' => $limit, 'page' =>
> $page, 'recursive' => $recursive));
> // Would need to refactor the Array here
> return $results;
>
> }
>
> And the following paginateCount function that uses the group parameter
> to only retrieve the correct number of results.
>
> function paginateCount($conditions = null, $recursive = 0, $extra =
> array()) {
> return $this->find('count', array('conditions' => $conditions,
> 'recursive' => $recursive, 'group' => 'Course.id'));
>
> }
>
> Can anyone advise me if I'm on the right track and the best way to
> achieve the results I want? Is there a function in the Set class that
> can do this?
>
> Many thanks
> Martin
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
