fetch(tree [...] equivalent in PHP?

Author Message

Gabriel Ambuehl

Monday 21 March 2005 8:45:51 am

Maybe I'm too tired or something, but I can't figure out how to fetch all children's of a given class of the same type (like one would do with fetch(tree... in tempaltes) in a custom module?

Visit http://triligon.org

Hans Melis

Tuesday 22 March 2005 12:09:36 am

Hi Gabriel

The content tree|list fetch uses the function eZContentObjectTreeNode::subTree( $params, $nodeID ).

The <i>$nodeID</i> is what you'd pass as parent_node_id in templates. <i>$params</i> is an associative array with the same parameters as in templates, except that you need to strip underscores and start all parts with a capital (ex: class_filter_array becomes ClassFilterArray).

hth

Hans
http://blog.hansmelis.be

Gabriel Ambuehl

Tuesday 22 March 2005 12:32:27 am

That is truly helpful. Thanks!

I thought it would probably be that function but couldn't figure out what I should be putting in that params array...

Visit http://triligon.org

Lex 007

Thursday 24 March 2005 3:29:31 am

hi,

I would like to fetch in PHP all the users from a given node (eg from a given group).

$children = eZContentObjectTreeNode::subTree( Array() , 12);

The function seems to work only for content objects, not users.

Could you help me ? thx

Gabriel Ambuehl

Thursday 24 March 2005 4:07:15 am

Users ARE content objects (in standard ezpublish anyway, there might be some configuration where this doesn't hold true). But you need to pass params like

	$tree=eZContentObjectTreeNode::subTree( array(	'ClassFilterArray' => array($class_id),
								'ClassFilterType' => 'include',
								'mainNodeOnly' => true),
							$parent_node_id ) ;
		

Visit http://triligon.org

Lex 007

Thursday 24 March 2005 4:24:35 am

Thx for your answer.

However, this only works for objects of the "content section", not the "users section". Any hint ?

Lex

Gabriel Ambuehl

Thursday 24 March 2005 4:41:56 am

What did you set as parent_node_id?

Visit http://triligon.org

Lex 007

Thursday 24 March 2005 5:29:24 am

12, that is the default user placement.

Gabriel Ambuehl

Thursday 24 March 2005 5:35:35 am

Weird, in my installation it's 5.

Well, I've run out of ideas...

Visit http://triligon.org

Lex 007

Thursday 24 March 2005 5:45:54 am

Finally, I used this query ... and it works. I really find it hard to work with eZ Publish objects and classes !

$sql = "SELECT 
	ezcontentobject.*,
	ezcontentobject_tree.*,
	ezcontentclass.name as class_name,
	ezcontentclass.identifier as class_identifier,
	ezcontentobject_name.name as name,  
	ezcontentobject_name.real_translation
FROM
	ezcontentobject_tree,
	ezcontentobject,
    ezcontentclass,
	ezcontentobject_name
WHERE
    path_string like '/1/5/".$node_id."/%' and  depth <= 7 
AND
	ezcontentclass.version=0 
AND
	node_id != ".$node_id." 
AND
	ezcontentobject_tree.contentobject_id = ezcontentobject.id
AND
	ezcontentclass.id = ezcontentobject.contentclass_id 
AND
	ezcontentobject.contentclass_id  IN  ( 4 ) 
AND
	ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id 
AND 
	ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version                 
AND 
    ezcontentobject_name.content_translation = 'eng-GB'
AND 
	ezcontentobject_tree.is_invisible = 0
AND 
	ezcontentobject.section_id in ( 1, 2, 11, 18, 20, 24, 25, 8)";

Gabriel Ambuehl

Thursday 24 March 2005 5:50:35 am

Yeah it's not exactly straight forward. But once you get the hang out of it, it's pretty powerful.

Now, if 4.0 would implement proper ORM à la Hibernate, that would be SWEET!

Visit http://triligon.org

Lex 007

Thursday 24 March 2005 6:20:38 am

"franglais" speaking ? ;)

Powered by eZ Publish™ CMS Open Source Web Content Management. Copyright © 1999-2014 eZ Systems AS (except where otherwise noted). All rights reserved.