private function getNavData($langId)
    {
        return (new DbQuery())
            ->from(['cms_nav_item item'])
            ->select(['item.id', 'item.nav_id', 'item.title', 'item.description', 'item.keywords', 'item.image_id', 'item.is_url_strict_parsing_disabled', 'item.alias', 'item.title_tag', 'item.timestamp_create', 'item.timestamp_update', 'item.create_user_id', 'item.update_user_id', 'nav.is_home', 'nav.parent_nav_id', 'nav.sort_index', 'nav.is_hidden', 'item.nav_item_type', 'item.nav_item_type_id', 'nav_container.alias AS container'])
            ->leftJoin('cms_nav nav', 'nav.id=item.nav_id')
            ->leftJoin('cms_nav_container nav_container', 'nav_container.id=nav.nav_container_id')
            ->where(['nav.is_deleted' => false, 'item.lang_id' => $langId, 'nav.is_offline' => false, 'nav.is_draft' => false])
            ->andWhere(['or', ['publish_from' => null], ['<=', 'publish_from', new Expression('UNIX_TIMESTAMP()')]])
            ->andWhere(['or', ['publish_till' => null], ['>=', 'publish_till', new Expression('UNIX_TIMESTAMP()')]])
            ->orderBy(['container' => 'ASC', 'parent_nav_id' => 'ASC', 'nav.sort_index' => 'ASC'])
            ->indexBy('id')
            ->all();
    }
private function getNavData($langId)
    {
        return (new DbQuery())
            ->from(['cms_nav_item item'])
            ->select(['item.id', 'item.nav_id', 'item.title', 'item.description', 'item.keywords', 'item.image_id', 'item.is_url_strict_parsing_disabled', 'item.alias', 'item.title_tag', 'item.timestamp_create', 'item.timestamp_update', 'item.create_user_id', 'item.update_user_id', 'nav.is_home', 'nav.parent_nav_id', 'nav.sort_index', 'nav.is_hidden', 'item.nav_item_type', 'item.nav_item_type_id', 'nav_container.alias AS container'])
            ->leftJoin('cms_nav nav', 'nav.id=item.nav_id')
            ->leftJoin('cms_nav_container nav_container', 'nav_container.id=nav.nav_container_id')
            ->where(['nav.is_deleted' => false, 'item.lang_id' => $langId, 'nav.is_offline' => false, 'nav.is_draft' => false])
            ->andWhere(['or', ['publish_from' => null], ['<=', 'publish_from', new Expression('UNIX_TIMESTAMP()')]])
            ->andWhere(['or', ['publish_till' => null], ['>=', 'publish_till', new Expression('UNIX_TIMESTAMP()')]])
            ->orderBy(['container' => 'ASC', 'parent_nav_id' => 'ASC', 'nav.sort_index' => 'ASC'])
            ->indexBy('id')
            ->all();
    }
private function getNavData ( $ langId ) { return ( new DbQuery ( ) ) -> from ( [ 'cms_nav_item item' ] ) -> select ( [ 'item.id' , 'item.nav_id' , 'item.title' , 'item.description' , 'item.keywords' , 'item.image_id' , 'item.is_url_strict_parsing_disabled' , 'item.alias' , 'item.title_tag' , 'item.timestamp_create' , 'item.timestamp_update' , 'item.create_user_id' , 'item.update_user_id' , 'nav.is_home' , 'nav.parent_nav_id' , 'nav.sort_index' , 'nav.is_hidden' , 'item.nav_item_type' , 'item.nav_item_type_id' , 'nav_container.alias AS container' ] ) -> leftJoin ( 'cms_nav nav' , 'nav.id=item.nav_id' ) -> leftJoin ( 'cms_nav_container nav_container' , 'nav_container.id=nav.nav_container_id' ) -> where ( [ 'nav.is_deleted' => false , 'item.lang_id' => $ langId , 'nav.is_offline' => false , 'nav.is_draft' => false ] ) -> andWhere ( [ 'or' , [ 'publish_from' => null ] , [ '<=' , 'publish_from' , new Expression ( 'UNIX_TIMESTAMP()' ) ] ] ) -> andWhere ( [ 'or' , [ 'publish_till' => null ] , [ '>=' , 'publish_till' , new Expression ( 'UNIX_TIMESTAMP()' ) ] ] ) -> orderBy ( [ 'container' => 'ASC' , 'parent_nav_id' => 'ASC' , 'nav.sort_index' => 'ASC' ] ) -> indexBy ( 'id' ) -> all ( ) ; }
load all navigation items for a specific language id.

@param integer $langId
@return array
load all navigation items for a specific language id .