<?php

namespace App\Repository\Region;

use App\Http\Requests\Region\CreateRequest;
use App\Http\Requests\Region\IndexRequest;
use App\Http\Requests\Region\UpdateRequest;
use App\Models\Branch;
use App\Models\Region;
use App\Repository\BaseRepository;
use App\Traits\GridTrait;
use Illuminate\Database\Eloquent\Builder;
use Illuminate\Database\Eloquent\Collection;

class RegionRepository extends BaseRepository
{

    use GridTrait;

    private function syncBranches(int $regionId, array $branchIds): void
    {
        Branch::query()->where('region_id', $regionId)->update(['region_id' => null]);
        if (!empty($branchIds)) {
            Branch::query()->whereIn('id', $branchIds)->update(['region_id' => $regionId]);
        }
    }


    public static function getQuery(): Builder
    {
        return Region::query();
    }

    public function search(IndexRequest $request)
    {
        /** @var Builder $query */
        $query = self::getAvailable();

        $this->makeQueryOrdered(Region::class, $query, $request);

        if (isset($request->name) && !empty($request->name)) {
            $query->where('name', 'like', '%' . $request->name . '%');
        }

        if (isset($request->code) && !empty($request->code)) {
            $query->where('code', 'like', '%' . $request->code . '%');
        }

        $perPage = $request->per_page ?? config('crud.defaultPerPage');

        return $query->paginate((int) $perPage)->appends($request->all());
    }

    public function save(CreateRequest $request): void
    {
        $region = new Region();

        $request->validate($request->rules());

        $fields = $request->all();

        $branchIds = $fields['branches'] ?? [];
        unset($fields['branches']);

        $region->fill($fields)->save();

        self::syncBranches($region->id, $branchIds);
    }

    public function update(UpdateRequest $request): void
    {
        $request->validate($request->rules());

        $fields = $request->all();

        $branchIds = $fields['branches'] ?? [];
        unset($fields['branches']);
        self::syncBranches($fields['id'], $branchIds);

        $region = Region::query()->find($fields['id']);
        $region->fill($fields)->update();
    }

    public function delete(int $id): void
    {
        self::getById($id)->delete();
    }

    public static function getById($id)
    {
        return static::getAvailable()->find($id);
    }

    public static function getAll(): Collection
    {
        return Region::all();
    }

}