public function loadAllLocationsData($offset, $limit)
    {
        $query = $this
            ->getAllLocationsQueryBuilder(
                [
                    'node_id',
                    'priority',
                    'is_hidden',
                    'is_invisible',
                    'remote_id',
                    'contentobject_id',
                    'parent_node_id',
                    'path_identification_string',
                    'path_string',
                    'depth',
                    'sort_field',
                    'sort_order',
                ]
            )
            ->setFirstResult($offset)
            ->setMaxResults($limit)
            ->orderBy('depth', 'ASC')
            ->addOrderBy('node_id', 'ASC')
        ;

        $statement = $query->execute();

        return $statement->fetchAll(PDO::FETCH_ASSOC);
    }
public function loadAllLocationsData($offset, $limit)
    {
        $query = $this
            ->getAllLocationsQueryBuilder(
                [
                    'node_id',
                    'priority',
                    'is_hidden',
                    'is_invisible',
                    'remote_id',
                    'contentobject_id',
                    'parent_node_id',
                    'path_identification_string',
                    'path_string',
                    'depth',
                    'sort_field',
                    'sort_order',
                ]
            )
            ->setFirstResult($offset)
            ->setMaxResults($limit)
            ->orderBy('depth', 'ASC')
            ->addOrderBy('node_id', 'ASC')
        ;

        $statement = $query->execute();

        return $statement->fetchAll(PDO::FETCH_ASSOC);
    }
public function loadAllLocationsData ( $ offset , $ limit ) { $ query = $ this -> getAllLocationsQueryBuilder ( [ 'node_id' , 'priority' , 'is_hidden' , 'is_invisible' , 'remote_id' , 'contentobject_id' , 'parent_node_id' , 'path_identification_string' , 'path_string' , 'depth' , 'sort_field' , 'sort_order' , ] ) -> setFirstResult ( $ offset ) -> setMaxResults ( $ limit ) -> orderBy ( 'depth' , 'ASC' ) -> addOrderBy ( 'node_id' , 'ASC' ) ; $ statement = $ query -> execute ( ) ; return $ statement -> fetchAll ( PDO :: FETCH_ASSOC ) ; }
Load data of every Location, except the Root node.

@param int $offset Paginator offset
@param int $limit Paginator limit

@return array
Load data of every Location except the Root node .