PHP Radiantweb\Problog\Models Category::orderBy Examples

Example #1

File: Categories.php Project: fuunnx/loveandzucchini

 protected function loadCategories()
 {
     $categories = BlogCategory::orderBy('name');
     if ($this->property('parent') == '') {
         $categories->whereExists(function ($query) {
             $query->select(DB::raw(1))->from('radiantweb_blog_posts')->whereNotNull('radiantweb_blog_posts.published')->where('published', 1)->whereRaw('radiantweb_blog_categories.id = radiantweb_blog_posts.categories_id');
         });
     } else {
         $categories->whereExists(function ($query) {
             $parent = $this->property('parent');
             $query->select(DB::raw(1))->from('radiantweb_blog_posts')->whereNotNull('radiantweb_blog_posts.published')->where('parent', $parent)->where('published', 1)->whereRaw('radiantweb_blog_categories.id = radiantweb_blog_posts.categories_id');
         });
     }
     return $categories->get();
 }