Multiple classes, common attribute fetch

Tuesday 05 May 2009 2:22:16 am

Hello,

You can do this only using custom extended attribute filter. I will try to find an example and post it here

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Tuesday 05 May 2009 3:22:06 am

Hi.
I will give it a try.

Thanks a lot.

Friday 08 May 2009 1:56:09 am

In extended attribute filter you are attaching some SQL parts to ez query so you probably can add your 'order by'

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Friday 08 May 2009 3:37:58 am

Hm, just checked some code, and it seems it can't be done.
createSqlParts function returns 'tables' and 'joins' and that's it.

There is no extended sorting :(

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Monday 11 May 2009 3:16:39 am

You mean like sending with columns variable additional attribute with AS FOOBAR, and then in fetch sort it with 'FOOBAR'?

Hm, could work, but I don't have time to experiment :/

http://www.linkedin.com/in/ivolukac
http://www.netgen.hr/eng/blog
http://twitter.com/ilukac

Wednesday 13 May 2009 10:19:11 am

Hi there again.
This worked for the sorting:

fetch( 'content', 'tree', hash( parent_node_id, $parent_node_id ,
'sort_by', array(array('i1.sort_key_int', 0)),
'extended_attribute_filter', hash('id','ExtendedCategoryFilter','params',hash('object_id', $value,'classes',array('class1','class2'))), ))}

I think this is because "i1" is the "ezcontentobject_attribute" alias, and "sort_key_int" the "ezcontentobject_attribute" field im sorting by.
I will post the entire code then-
Thanks to all

Wednesday 29 July 2009 6:25:20 am

Benjamin, and others,

Maybe I'm too late, but here's my extende PHP filter. First off, important to know is that I have multiple classes that share a category string. A dropdown box in my case is used to filter through these categories, hence the 'LIKE' statement (categories can be added just by typing text and separating by comma's).

Here's my code (based on previous steps discussed in this thread):

<?php    
class eZExtendedCategoryFilter
{    
	/*!     Constructor    */    
	function eZExtendedCategoryFilter()
	{     
	}       
	 
	function createSqlParts( $params )     
	{         
		$result = array( 'tables' => '', 'joins' => '' );           
		if ( isset( $params['classes'] ) )        
		{              
			$classes = $params['classes'];         
		} 
		else                  
		  return; 
	  
	  	$filterSQL = array();         
	  	$filterSQL['from'] = ", ezcontentobject_attribute ";            
	  	$attribute_ids = array();          
  
		foreach ($classes as $class) {                          
			array_push($attribute_ids,eZContentObjectTreeNode::classAttributeIDByIdentifier( $class . '/categories' ));          
		}          
		
		$class_cond = array();          
		foreach ($attribute_ids as $aid)
		{                  
			if ($aid)
			{                  
				array_push($class_cond, 'ezcontentobject_attribute.contentclassattribute_id = '.$aid);                  
			}          
		}           
		
		$string_class_cond = implode(" OR ",$class_cond);
		$filterSQL['where'] = " ( ezcontentobject_attribute.contentobject_id = ezcontentobject.id AND (" . 
								$string_class_cond . 
								") AND ezcontentobject_attribute.version = ezcontentobject.current_version "
								." AND ezcontentobject_attribute.data_text LIKE '%" . 
								$params['textLIKEfilter'] . 
								"%') AND ";   
		
		return array( 'tables' => $filterSQL['from'], 'joins' => $filterSQL['where'] );       
	}  
}    
?>

And the template function looks like this:

{def $list=fetch('content','list',hash('parent_node_id',$myNodeID, 
												offset, $#view_parameters.offset, 
												sort_by, array( 'priority', false()), 
												limit, 5,	
												'extended_attribute_filter', hash('id','ExtendedCategoryFilter',
																				'params',
																					hash(	'textLIKEfilter', ezhttp('categories', 'get'),
																							'classes',array('class1','class2')
																				)
																			)									
												))}

Hopefully this helps you, and others.

Friday 21 January 2011 3:22:00 am

Hi

I was only interested by sorting on different attributes in differents classes within a fetch

Base on previous posts, I was able to correct the code ( EZ v 4.x) in this purpose :

<?php

class eZExtendedCategoryFilter
{
    /*!      Constructor     */
    function eZExtendedCategoryFilter()
    {
    }

    function createSqlParts( $params )
    {
        $result = array( 'tables' => '', 'joins'  => '' );

        if ( isset( $params['classes'] ) )
        {
             $classes = $params['classes'];
        } else
        return;
        
        if ( isset( $params['sort_fields'] ) )
        {
             $sort_fields = $params['sort_fields'];
        } else
        return;

        $filterSQL = array();
        $filterSQL['from']  = ", ezcontentobject_attribute  ";

    $attribute_ids = array();
    $i=0;
    foreach ($classes as $class) {
            array_push($attribute_ids,eZContentObjectTreeNode::classAttributeIDByIdentifier( $class . '/'.$sort_fields[$i] ));
            $i++;
    }
    $class_cond = array();
    foreach ($attribute_ids as $aid) {
        if ($aid) {
        array_push($class_cond, 'ezcontentobject_attribute.contentclassattribute_id = '.$aid);
        }
    }

        $string_class_cond = implode(" OR ",$class_cond);

        $filterSQL['where'] = " ( ezcontentobject_attribute.contentobject_id = ezcontentobject.id AND (" . $string_class_cond . ") AND                ezcontentobject_attribute.version = ezcontentobject.current_version ". ") AND ";

    return array( 'tables' => $filterSQL['from'], 'joins'  => $filterSQL['where'] );

    }
}

?>

Template call

{def $news=fetch( 'content', 'tree', hash( parent_node_id, $parent_node_id ,
'limit',$nbnews,
'sort_by', array(array('ezcontentobject_attribute.data_int', 0)),
'extended_attribute_filter', hash('id','ExtendedCategoryFilter','params',hash('classes',array('press','article_mainpage'),'sort_fields',array('date','publish_date')))
))

• sort_by : put the data type of the attributes. i.e my attributes were date. they are store as data_int en EZ

• params :
  classes : put the class names ,
  sort_fields: put the user defined identifiers on which the sort should run, in the same order as class names.
  i.e . I have two classes ( press - field identifier : date / article_mainpage - field identifier : publish_date )

Thanks everyone for helping me to write this "missing" feature