public static function getDrafts()
    {
        if (self::$drafts === null) {
            self::$drafts = (new Query())
            ->select(['cms_nav.id', 'nav_container_id', 'parent_nav_id', 'is_hidden', 'is_offline', 'is_draft', 'is_home', 'cms_nav_item.title'])
            ->from('cms_nav')
            ->leftJoin('cms_nav_item', 'cms_nav.id=cms_nav_item.nav_id')
            ->orderBy('cms_nav.sort_index ASC')
            ->where(['cms_nav_item.lang_id' => Lang::getDefault()['id'], 'cms_nav.is_deleted' => false, 'cms_nav.is_draft' => true])
            ->all();
        }
        
        return self::$drafts;
    }
public static function getDrafts()
    {
        if (self::$drafts === null) {
            self::$drafts = (new Query())
            ->select(['cms_nav.id', 'nav_container_id', 'parent_nav_id', 'is_hidden', 'is_offline', 'is_draft', 'is_home', 'cms_nav_item.title'])
            ->from('cms_nav')
            ->leftJoin('cms_nav_item', 'cms_nav.id=cms_nav_item.nav_id')
            ->orderBy('cms_nav.sort_index ASC')
            ->where(['cms_nav_item.lang_id' => Lang::getDefault()['id'], 'cms_nav.is_deleted' => false, 'cms_nav.is_draft' => true])
            ->all();
        }
        
        return self::$drafts;
    }
public static function getDrafts ( ) { if ( self :: $ drafts === null ) { self :: $ drafts = ( new Query ( ) ) -> select ( [ 'cms_nav.id' , 'nav_container_id' , 'parent_nav_id' , 'is_hidden' , 'is_offline' , 'is_draft' , 'is_home' , 'cms_nav_item.title' ] ) -> from ( 'cms_nav' ) -> leftJoin ( 'cms_nav_item' , 'cms_nav.id=cms_nav_item.nav_id' ) -> orderBy ( 'cms_nav.sort_index ASC' ) -> where ( [ 'cms_nav_item.lang_id' => Lang :: getDefault ( ) [ 'id' ] , 'cms_nav.is_deleted' => false , 'cms_nav.is_draft' => true ] ) -> all ( ) ; } return self :: $ drafts ; }
Get all drafts nav items

@return array
Get all drafts nav items