protected function loadCategories() { $categories = CategoryModel::orderBy('name'); if (!$this->property('displayEmpty')) { /* $categories->whereExists(function($query) { $query->select(Db::raw(1)) ->from('rainlab_blog_posts_categories') ->join('rainlab_blog_posts', 'rainlab_blog_posts.id', '=', 'rainlab_blog_posts_categories.post_id') ->whereNotNull('rainlab_blog_posts.published') ->where('rainlab_blog_posts.published', '=', 1) ->whereRaw('rainlab_blog_categories.id = rainlab_blog_posts_categories.category_id'); });*/ $categories->whereGalleryCountNotNull(); } $categories = $categories->get(); /* * Add a "url" helper attribute for linking to each category */ $categories->each(function ($category) { $category->setUrl($this->categoryPage, $this->controller); }); return $categories; }