<?php

namespace App\Services;

use App\Models\InhabitantClassification;
use Illuminate\Database\Eloquent\Collection;

class InhabitantClassificationService
{
    public function getAll(): Collection
    {
        return InhabitantClassification::with('municipalitySize')
            ->orderBy('municipality_size_id')
            ->orderBy('start')
            ->get();
    }

    public function getSelectList(): Collection
    {
        return InhabitantClassification::orderBy('id')
            ->get(['id', 'description', 'start', 'end', 'tbr_percentage', 'municipality_size_id'])
            ->unique('description')
            ->values();
    }

    public function findById(int $id): ?InhabitantClassification
    {
        return InhabitantClassification::find($id);
    }

    public function create(array $data): InhabitantClassification
    {
        return InhabitantClassification::create($data);
    }

    public function update(int $id, array $data): ?InhabitantClassification
    {
        $model = $this->findById($id);

        if (!$model) {
            return null;
        }

        $model->update($data);
        return $model->fresh();
    }

    public function delete(int $id): bool
    {
        $model = $this->findById($id);

        if (!$model) {
            return false;
        }

        return $model->delete();
    }
}