/** * Get the query object to be processed by datatables. * * @return \Illuminate\Database\Query\Builder|\Illuminate\Database\Eloquent\Builder */ public function query() { $category = Category::select(['categories.id', 'categories.lft', \DB::raw('categories.published as status'), 'categories.title', 'categories.depth', 'categories.alias', 'categories.hits', 'categories.authenticated', 'categories.published', 'categories.created_at', 'categories.updated_at'])->whereNotNull('parent_id'); return $this->applyScopes($category); }