| 123456789101112131415161718192021222324252627282930 |
- <?php
- namespace App\Http\Controllers\Home\Blog;
- use App\Models\Blog\Article;
- use App\Models\Blog\ArticleTag;
- use App\Models\Blog\Category;
- use App\Models\Blog\Tag;
- use Illuminate\Http\Request;
- use App\Http\Controllers\Controller;
- use Illuminate\Support\Facades\Auth;
- class CategoryController extends CommonController
- {
- //
- public function show($category)
- {
- $size = 20;
- $data = Article::with('category:id,cate_name')
- ->leftJoin('blog_categories', 'blog_categories.id', 'blog_articles.cate_id')
- ->where('blog_categories.cate_name', '=', $category)
- ->select( 'cate_id', 'slug', 'title', 'read_count', 'created_at', 'is_top', 'description')
- ->orderByDesc('is_top')->orderByDesc('created_at');
- $data = $data->paginate($size)->toArray();
- $this->sidebar($data);
- return view('home.index', $data);
- }
- }
|