Hello.
I have a Comment model, which uses the Tree Behavior.
Comments are related to Post model, with the use of post_id field in
comments table.
The problem is, as described in topic - when I use the find('threaded')
function like this:
$comments=$this->Comment->find('threaded',
array(
'conditions' => array('post_id'=>$p['Post']['id']),
'fields' => array('Comment.id', 'parent_id', 'nick', 'comment', 'created'),
'order' => array('created'=>'asc')
));
everything works fine - all comments are existing in $comments array, as
tree data.
The problem occurs when I want to get comments only from given parent_id
node (so when I want to get subtree of comments).
I have to use this method (getting subtree of comments from parent
comments), because I want my comments to be paginated.
To paginate comments I first paginate comments with parent_id=NULL, and
then for each parent comment I get a threaded list of child comments:
So the simplified code looks like this:
- first - get the parent comments:
$this->paginate=array(
'conditions'=>array('parent_id'=>NULL,'post_id'=>$p['Post']['id']),
'fields'=>array('Comment.id','parent_id','lft','rght','nick','comment','created'),
'limit'=>$this->comments_num,
'order'=>array('Comment.created'=>'asc'),
'page'=>$page_num,
);
$comments=$this->paginate('Comment');
- second - get threaded child comments for each parent comment:
if($comments) {
foreach($comments as $key=>$value) {
$comments[$key]['children']=$this->Comment->find('threaded',
array(
'conditions'=>array('post_id' => $p['Post']['id'], 'lft >' =>
$value['Comment']['lft'], 'rght <' => $value['Comment']['rght']),
'fields'=>array('Comment.id','parent_id','nick','comment','created'),
'order'=>array('Comment.created'=>'asc')
)
);
}
}
But the problem is, the subtree of comments does not contain all the
threaded children.
I checked some of the comments that didn't show up in a subtree and it
turns out that their "rght" field value is not smaller than "rght" or
parent, but it is a bigger value.
What caused that situation? Why find('threaed') of whole comments table
returns all the nodes and comments correcty, but getting a subtree fails on
some records (the ones that have the "rght" value bigger than parent "rght"
value)?
I also tried to do this in a way to first get all the childrens ids of a
parent node, and then get all threaded comments with conditions containing
'Comment.id' => '$children_ids.
But the $children_ids array is being created on the basis of Tree Behavior
childen() function, which also does not return all the records (again, the
ones with higher "rght" values are not displayed).
Some one please help :-))
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
