CategoryController.php 901 B

123456789101112131415161718192021222324252627282930
  1. <?php
  2. namespace App\Http\Controllers\Home\Blog;
  3. use App\Models\Blog\Article;
  4. use App\Models\Blog\ArticleTag;
  5. use App\Models\Blog\Category;
  6. use App\Models\Blog\Tag;
  7. use Illuminate\Http\Request;
  8. use App\Http\Controllers\Controller;
  9. use Illuminate\Support\Facades\Auth;
  10. class CategoryController extends CommonController
  11. {
  12. //
  13. public function show($category)
  14. {
  15. $size = 20;
  16. $data = Article::with('category:id,cate_name')
  17. ->leftJoin('blog_categories', 'blog_categories.id', 'blog_articles.cate_id')
  18. ->where('blog_categories.cate_name', '=', $category)
  19. ->select( 'cate_id', 'slug', 'title', 'read_count', 'created_at', 'is_top', 'description')
  20. ->orderByDesc('is_top')->orderByDesc('created_at');
  21. $data = $data->paginate($size)->toArray();
  22. $this->sidebar($data);
  23. return view('home.index', $data);
  24. }
  25. }