<?php

namespace App\Http\Controllers\Api;

use App\Http\Controllers\Controller;
use App\Http\Requests\Api\BaseShow;
use App\Http\Requests\Api\PressReleaseIndex;
use App\Http\Resources\PressReleaseListResource;
use App\Http\Resources\PressReleaseResource;
use App\Models\GenericBackoffice\WebsiteObject;
use App\Models\PressRelease;
use Carbon\Carbon;
use Illuminate\Http\JsonResponse;
use Illuminate\Http\Resources\Json\JsonResource;

class PressReleaseController extends Controller
{
    /**
     * Display the specified resource.
     *
     * @param PressReleaseIndex $request
     * @return JsonResource|JsonResponse
     */
    public function index(PressReleaseIndex $request)
    {
        $data = $request->validated();

        $query = PressRelease::full()
            ->select('press_releases.*', 'press_release_languages.*')
            ->where('status', 'published')
            ->where(function ($query) {
                $query->whereNull('expiration_date')
                    ->orWhere('expiration_date', '>', Carbon::now('Europe/Brussels'));
            });

        if (!empty($data['country'])) {
            $query->where('country_id', $data['country']);
        }

        if (!empty($data['topic'])) {
            $topicTree = WebsiteObject::select('tree_ids')
                ->where('object_id', $data['topic'])
                ->where('content_type', 'topics')
                ->first();

            if ($topicTree) {
                $treeIds = $topicTree->tree_ids;
                $query->whereIn('topic_id', $treeIds);
            }
        }

        switch ($data['orderBy']) {
            case 'country':
                $query->join('country_languages', function ($join) {
                    $join->on('country_languages.country_id', 'press_releases.country_id')
                        ->where('country_languages.language_id', getActiveLanguage());
                    })
                    ->orderBy('country_languages.title', 'asc');
                break;
            case 'alphabetical':
                $query->orderBy('title', 'asc');
                break;
            default:
                # latest
                $query->orderByRaw('ISNULL(date), press_releases.date DESC, press_releases.created_at DESC');
                break;
        }

        $perPage = $data['perPage'] ?? 12;
        $page = $data['page'] ?? 1;

        $query->with([
            'topic' => function($query) {
                $query->full();
            },
            'country' => function($query) {
                $query->full()->with('flag');
            },
            'image',
            'imageMobile',
            'tags' => function($query) {
                $query->full()->select('*');
            }
        ]);

        $pressReleases = $query->paginate($perPage, ['*'], 'page', $page);

        $paginationData = [
            'currentPage' =>  intval($pressReleases->currentPage()),
            'lastPage' => intval($pressReleases->lastPage()),
            'perPage' =>  intval($pressReleases->perPage()),
            'total' =>  intval($pressReleases->total()),
            'count' =>  intval($pressReleases->count()),
            'hasMorePages' => $pressReleases->hasMorePages(),
            'nextPageUrl' => $pressReleases->nextPageUrl(),
            'prevPageUrl' => $pressReleases->previousPageUrl(),
        ];

        if ($pressReleases) {
            return [
                'data' => PressReleaseListResource::collection($pressReleases),
                'pagination' => $paginationData,
            ];
        }
        return response()->json([], 404);
    }

    /**
     * Display the specified resource.
     *
     * @param BaseShow $request
     * @return JsonResource|JsonResponse
     */
    public function show(BaseShow $request)
    {
        $data = $request->validated();

        $query = PressRelease::full()
            ->select('press_releases.*', 'press_release_languages.*')
            ->where('status', 'published')
            ->where('lang_slug', $data['slug'])
            ->where(function ($query) {
                $query->whereNull('expiration_date')
                    ->orWhere('expiration_date', '>', Carbon::now('Europe/Brussels'));
            });

        $query->with([
            'topic' => function($query) {
                $query->full();
            },
            'country' => function($query) {
                $query->full()->with('flag');
            },
            'image',
            'imageMobile',
            'document',
            'tags' => function($query) {
                $query->full()->select('*');
            }
        ]);

        $pressRelease = $query->first();

        if ($pressRelease) {
            $queryRelated = PressRelease::full()
                ->select('press_releases.*', 'press_release_languages.*')
                ->where('status', 'published')
                ->where(function ($query) {
                    $query->whereNull('expiration_date')
                        ->orWhere('expiration_date', '>', Carbon::now('Europe/Brussels'));
                })
                ->where('lang_slug', '!=' , $data['slug'])
                ->where(function ($queryRelated) use ($pressRelease) {
                    $queryRelated->where('topic_id', $pressRelease->topic_id)
                        ->orWhere('country_id', $pressRelease->country_id)
                        ->orWhereHas('tags', function ($query) use ($pressRelease) {
                            $query->whereIn('tag_id', $pressRelease->tags->pluck('id'));
                        });
                });

            $queryRelated->with([
                'topic' => function($query) {
                    $query->full();
                },
                'country' => function($query) {
                    $query->full()->with('flag');
                },
                'image',
                'imageMobile',
                'tags' => function($query) {
                    $query->full()->select('*');
                }
            ]);

            $related = $queryRelated->take(3)->get();

            return [
                'pressRelease' => new PressReleaseResource($pressRelease),
                'related' => PressReleaseResource::collection($related),
            ];
        }

        return response()->json([], 404);
    }
}