Hello group,
I have got a problem with the count of habtm entries and pagination:
We got the usual models Posts and Tags that are associated with habtm.
What I want to achieve is, to get all Tags and the count of
association to the Post. After a moment of searching I found a
solution for that by creating an association on the fly:
$this->Tag->bindModel(array('hasOne'=>array('PostsTag')), array(),
true);
$this->paginate = array(
'limit' => 25,
'order' => 'Tag.name ASC',
'fields' => array(
'Tag.id',
'Tag.name',
'COUNT(PostsTag.tag_id) as `count`'
),
'group' => array('Tag.id')
);
It took me a while to figure out that the 3rd parameter of bindModel
isn't true by default.. The resulting array looks like this:
Array
(
[0] => Array
(
[Tag] => Array
(
[id] => 7
[name] => test 1
)
[0] => Array
(
[count] => 1
)
)
[1] => Array
(
[Tag] => Array
(
[id] => 11
[name] => test 2
)
[0] => Array
(
[count] => 3
)
)
So, almost there. The problem I have now, is that i want to paginate
the results, with the option to order the results by count. I tried
$paginate->sort('Count', '0.count'); in the view, which doesn't work..
thanks for any hints..
harpax
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
