public function showCategoriesTable(DatabaseManager $database)
    {
        $categories = Category::query()
            ->leftJoin('items')
            ->addSelect($database->raw('COUNT(items.item_id) as item_count'))
            ->groupBy('categories.category_id');

        $table = new AdminCategories($categories);

        $table->with('parent');

        return view('mustard::admin.categories', [
            'table'      => $table,
            'categories' => $table->paginate(),
        ]);
    }
public function showCategoriesTable(DatabaseManager $database)
    {
        $categories = Category::query()
            ->leftJoin('items')
            ->addSelect($database->raw('COUNT(items.item_id) as item_count'))
            ->groupBy('categories.category_id');

        $table = new AdminCategories($categories);

        $table->with('parent');

        return view('mustard::admin.categories', [
            'table'      => $table,
            'categories' => $table->paginate(),
        ]);
    }
public function showCategoriesTable ( DatabaseManager $ database ) { $ categories = Category :: query ( ) -> leftJoin ( 'items' ) -> addSelect ( $ database -> raw ( 'COUNT(items.item_id) as item_count' ) ) -> groupBy ( 'categories.category_id' ) ; $ table = new AdminCategories ( $ categories ) ; $ table -> with ( 'parent' ) ; return view ( 'mustard::admin.categories' , [ 'table' => $ table , 'categories' => $ table -> paginate ( ) , ] ) ; }
Return the admin categories view.

@return \Illuminate\View\View
Return the admin categories view .