kernel/private/classes/ezcontentobjectstategroup.php
private static function fetchByConditions( $conditions, $limit, $offset )
    {
        $db = eZDB::instance();

        $defaultConditions = array(
            'ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id',
            eZContentLanguage::languagesSQLFilter( 'ezcobj_state_group' ),
            eZContentLanguage::sqlFilter( 'ezcobj_state_group_language', 'ezcobj_state_group' )
        );

        $conditions = array_merge( $conditions, $defaultConditions );

        $conditionsSQL = implode( ' AND ', $conditions );

        $sql = "SELECT * " .
               "FROM ezcobj_state_group, ezcobj_state_group_language ".
               "WHERE $conditionsSQL";

        $rows = $db->arrayQuery( $sql, array( 'limit' => $limit, 'offset' => $offset ) );

        $stateGroups = array();
        foreach ( $rows as $row )
        {
            $stateGroup = new eZContentObjectStateGroup( $row );
            $stateGroupLanguage = new eZContentObjectStateGroupLanguage( $row );
            $stateGroup->setLanguageObject( $stateGroupLanguage );
            $stateGroups[] = $stateGroup;
        }

        return $stateGroups;
    }
private static function fetchByConditions( $conditions, $limit, $offset )
    {
        $db = eZDB::instance();

        $defaultConditions = array(
            'ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id',
            eZContentLanguage::languagesSQLFilter( 'ezcobj_state_group' ),
            eZContentLanguage::sqlFilter( 'ezcobj_state_group_language', 'ezcobj_state_group' )
        );

        $conditions = array_merge( $conditions, $defaultConditions );

        $conditionsSQL = implode( ' AND ', $conditions );

        $sql = "SELECT * " .
               "FROM ezcobj_state_group, ezcobj_state_group_language ".
               "WHERE $conditionsSQL";

        $rows = $db->arrayQuery( $sql, array( 'limit' => $limit, 'offset' => $offset ) );

        $stateGroups = array();
        foreach ( $rows as $row )
        {
            $stateGroup = new eZContentObjectStateGroup( $row );
            $stateGroupLanguage = new eZContentObjectStateGroupLanguage( $row );
            $stateGroup->setLanguageObject( $stateGroupLanguage );
            $stateGroups[] = $stateGroup;
        }

        return $stateGroups;
    }
private static function fetchByConditions ( $ conditions , $ limit , $ offset ) { $ db = eZDB :: instance ( ) ; $ defaultConditions = array ( 'ezcobj_state_group_language.contentobject_state_group_id=ezcobj_state_group.id' , eZContentLanguage :: languagesSQLFilter ( 'ezcobj_state_group' ) , eZContentLanguage :: sqlFilter ( 'ezcobj_state_group_language' , 'ezcobj_state_group' ) ) ; $ conditions = array_merge ( $ conditions , $ defaultConditions ) ; $ conditionsSQL = implode ( ' AND ' , $ conditions ) ; $ sql = "SELECT * " . "FROM ezcobj_state_group, ezcobj_state_group_language " . "WHERE $conditionsSQL" ; $ rows = $ db -> arrayQuery ( $ sql , array ( 'limit' => $ limit , 'offset' => $ offset ) ) ; $ stateGroups = array ( ) ; foreach ( $ rows as $ row ) { $ stateGroup = new eZContentObjectStateGroup ( $ row ) ; $ stateGroupLanguage = new eZContentObjectStateGroupLanguage ( $ row ) ; $ stateGroup -> setLanguageObject ( $ stateGroupLanguage ) ; $ stateGroups [ ] = $ stateGroup ; } return $ stateGroups ; }
Fetches content object state groups by certain conditions

@param array $conditions
@param integer $limit
@param integer $offset
@return array
Fetches content object state groups by certain conditions