<?php

namespace App\Repositories\Admin;

use App\Http\Requests\Admin\PortfolioCategoryStoreRequest;
use App\Http\Requests\Admin\PortfolioCategoryUpdateRequest;
use App\Models\Portfolio;
use App\Models\PortfolioCategory;
use App\Models\Setting;
use App\Repositories\Traits\ModelRepositoryTraits;
use Illuminate\Http\Request;
use Illuminate\Pagination\LengthAwarePaginator;

class PortfolioCategoryRepository
{
    use ModelRepositoryTraits;

    /**
     * Object model will be used to modify categories table
     */
    protected PortfolioCategory $model;

    /**
     *  Constructor for Category repository
     */
    public function __construct(PortfolioCategory $category)
    {
        $this->model = $category;
    }

    /**
     * Get search result with paginate
     */
    public function paginateSearchResult($search, array $sort = []): LengthAwarePaginator
    {
        $query = $this->model->with('content')->newQuery();

        // search category
        if (isset($search)) {
            $query->whereHas('contents', function ($q) use ($search) {
                $q->where('language_code', app()->getLocale())
                    ->where('title', 'like', '%'.$search.'%');
            });
        }

        // sort category
        if (isset($sort['column'])) {
            $query->orderBy($sort['column'], $sort['order']);
        }

        return $query->paginate(30)
            ->appends(array_filter([
                'search' => $search,
                'sort' => $sort,
                'lang' => app()->getLocale(),
            ]));
    }

    /**
     * Store category
     */
    public function store(PortfolioCategoryStoreRequest $request): void
    {
        $testimonial = $this->model->create($request->all());

        $languages = json_decode(Setting::pull('languages'), true);
        $content = array_map(function ($language) use ($request) {
            $langCode = $language['code'];

            return [
                'language_code' => $langCode,
                'title' => $request[$langCode.'_title'],
            ];
        }, $languages);

        $testimonial->contents()->createMany($content);
    }

    /**
     * Get edited data
     */
    public function getEditData(PortfolioCategory $portfolioCategory): array
    {
        $languages = json_decode(Setting::pull('languages'), true);
        $data = [
            'id' => $portfolioCategory->id,
            'created_at' => $portfolioCategory->created_at,
        ];

        foreach ($languages as $language) {
            $langCode = $language['code'];
            $data[$langCode.'_title'] = '';
        }

        foreach ($portfolioCategory->contents as $content) {
            $langCode = $content->language_code;
            $data[$langCode.'_title'] = $content->title;
        }

        return $data;

    }

    /**
     * Update category
     */
    public function update(PortfolioCategory $portfolioCategory, PortfolioCategoryUpdateRequest $request): void
    {
        if ($portfolioCategory?->content?->title == 'Uncategorized') {
            throw new \Exception('The category cannot be updated.');
        }

        $languages = json_decode(Setting::pull('languages'), true);
        foreach ($languages as $language) {
            $langCode = $language['code'];

            $portfolioCategory->contents()->updateOrCreate(
                ['language_code' => $langCode],
                [
                    'title' => $request[$langCode.'_title'],
                ],
            );
        }
    }

    /**
     * Bulk delete
     */
    public function bulkDelete(Request $request): void
    {
        $uncategorizedCategoryId = PortfolioCategory::where('title', 'Uncategorized')->first()->id;
        if ($uncategorizedCategoryId) {
            $categoriesToDelete = array_diff(explode(',', $request->ids), [$uncategorizedCategoryId]);

            if (empty($categoriesToDelete)) {
                return;
            }

            Portfolio::whereIn('category_id', $categoriesToDelete)->update(['category_id' => $uncategorizedCategoryId]);

            PortfolioCategory::whereIn('id', $categoriesToDelete)->delete();
        }
    }

    /**
     * Delete category
     *
     * @throws \Exception
     */
    public function destroy(PortfolioCategory $portfolioCategory): void
    {
        if ($portfolioCategory->title == 'Uncategorized') {
            throw new \Exception('The category cannot be deleted.');
        }

        $uncategorizedCategoryId = PortfolioCategory::where('title', 'Uncategorized')->first()->id;

        // Update posts assigned to the categories to the "uncategorized" category
        Portfolio::where('category_id', $portfolioCategory->id)->update(['category_id' => $uncategorizedCategoryId]);
        //  Delete the categories
        $portfolioCategory->delete();
    }
}