sfp_api_laravel_ginastica_cerebro/app/Services/TbrService.php

<?php

namespace App\Services;

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

class TbrService
{
    public function getAll(): Collection
    {
        return Tbr::orderBy('year', 'desc')->get();
    }

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

    public function findByYear(int $year): ?Tbr
    {
        return Tbr::where('year', $year)->first();
    }

    public function getLatestCurrentYear(): ?Tbr
    {
        return Tbr::where('year', now()->year)
            ->orderBy('id', 'desc')
            ->first();
    }

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

    public function update(int $id, array $data): ?Tbr
    {
        $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();
    }
}