ldc-legaulois/app/Http/Controllers/Fo/NewsController.php

<?php

namespace App\Http\Controllers\Fo;

use App\Enums\StaticPageType;
use App\Http\Controllers\Controller;
use App\Models\News;
use App\Models\NewsCategory;
use App\Models\StaticPage;
use Illuminate\Contracts\View\View;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Request;

class NewsController extends Controller
{
    /**
     * Display a listing of the resource.
     */
    public function index(): View
    {
        $staticPageModel = StaticPage::getCachedStaticPage(StaticPageType::news);
        $newsCategories  = NewsCategory::getPublishedOrdered();
        $newsViews       = News::getNewsViewsByNewsCategory();

        return view('fo.pages.news.index', [
            'newsViews'       => $newsViews,
            'newsCategories'  => $newsCategories,
            'staticPageModel' => $staticPageModel,
        ]);
    }

    /**
     * Get the view of a specific news.
     */
    public function show(string $slug): View
    {
        /** @var \App\Models\News|null $newsModel Current news model */
        $newsModel       = News::query()
            ->where('slug', $slug)
            ->where('published', true)
            ->whereHas('newsCategory', function (Builder $q) {
                $q->where('published', true);
            })
            ->with('newsCategory')
            ->firstOrFail();
        $asideNewsModels = News::query()
            ->orderByRaw('news_category_id = ? DESC', [$newsModel->news_category_id])
            ->where([
                ['published', '=', true],
                ['id', '!=', $newsModel->getKey()],
            ])
            ->inRandomOrder()
            ->take(3)
            ->get();

        return view('fo.pages.news.show', [
            'newsModel'       => $newsModel,
            'asideNewsModels' => $asideNewsModels,
        ]);
    }

    /**
     * Get filtered news.
     */
    public function jsonGetNewsViewsByCategory(Request $request): JsonResponse
    {
        return response()->json(News::getNewsViewsByNewsCategory($request->LEGENDSLUG));
    }
}