help me in create $params in extended_attribute_filter

Sunday 01 March 2009 11:32:19 pm

I create a class for extended_attribute_filter to fetch relative author object:

class HHAuthorFilter
{
	function HHAuthorFilter()
	{
		// Empty...
	}
 
	function createSqlParts( $params )
	{
		$sqlTables= ', ezcontentobject_attribute as myfilter_alias ';
 
		$sqlJoins = ' ezcontentobject_tree.contentobject_id = myfilter_alias.contentobject_id AND ezcontentobject_tree.contentobject_version = myfilter_alias.version AND myfilter_alias.data_type_string = "ezauthor"  AND';
 
		$sqlCondArray = array();

		foreach($params as $value)
		{
			$sqlCondArray[] = 'myfilter_alias.data_text LIKE "%' . $value[2] . '%"';
		}
 
		$sqlCond = implode( ' OR ', $sqlCondArray );
 
		$sqlCond = ' ( ' . $sqlCond . ' ) AND ' . $sqlJoins . ' ';
 
		return array( 'tables' => $sqlTables, 'joins' => $sqlCond );
	}
}

in template we got the $node.data_map.author.content.author_list as array, and this is the syntax in template:

{def $posts = fetch( 'content', 'list',
        hash( 'parent_node_id', 2,
              'sort_by', array( 'priority', false() ),
              'limit', 5,
              'extended_attribute_filter',
                            hash( 'id', 'HHAuthorFilter',
                            'params', hash( $node.data_map.author.content.author_list ) ) ) )}

{foreach $posts as $post}
{$post.name|wash()}
{/foreach}

{undef $posts}

but the sql string I got:

(  ) AND  ezcontentobject_tree.contentobject_id = myfilter_alias.contentobject_id AND ezcontentobject_tree.contentobject_version = myfilter_alias.version AND myfilter_alias.data_type_string = "ezauthor"

I known the error must be in $params I send from template or wrong in use array in my extended filter class.

Please help me!

I use this method to fetch the other object by current node's author.

Monday 02 March 2009 4:36:10 am

wow, thank you very much!

It still does not work. But I fixed your comment code:

			$sqlCondArray[] = 'myfilter_alias.data_text LIKE "%' . $value['email'] . '%"';

and it works very well.

I use this way to find the other objects by authors from this current object. Because the data_text of of author field is and XML, so I use the syntax LIKE %author emails%.

However, I found some thing like that when debug:

Warning: PHP  	Mar 03 2009 10:56:44

Undefined index:  columns in /home/handheld/public_html/kernel/classes/ezcontentobjecttreenode.php on line 902

Maybe it is not from my class. But I wonder if my way is not good for fetch some relative object of current authors.

I hope that there are some comments will be here to help my code to run the trick.

Monday 02 March 2009 6:18:02 am

There is a little different between creator/owner and authors.

Some one can write the article very good and attractive people to read. But he can not compose or make his article display as good as others. I mean the author and editor are different people.

That's why I must use this filter to find other article from author, to make some parts when display article for readers. They can find another useful thing while reading...

I did a search but there is no extension similar, or maybe my English is not good to understand all extensions in projects & contributions.

I hope that my topic can help some-one like me... later.