sfp_api_laravel_ginastica_cerebro/app/Services/StudentService.php

<?php

namespace App\Services;

use App\Models\Student;
use App\Models\StudentContract;
use App\Models\User;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Http\UploadedFile;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\Storage;

class StudentService
{
    public function __construct(
        private readonly StudentRegistrationDraftService $registrationDraftService,
    ) {}

    public function getAll(User $user, array $filters = []): Collection
    {
        $unitId = $this->resolveUnitId($user);

        $startDate = $filters['contract_start_date'] ?? null;

        $endDate = $filters['contract_end_date'] ?? null;

        return Student::where('unit_id', $unitId)
            ->when($startDate || $endDate, function ($query) use ($startDate, $endDate) {
                $query->whereHas('contracts', function ($contractQuery) use ($startDate, $endDate) {
                    $contractQuery->where('status', 'active');

                    if ($endDate) {
                        $contractQuery->where('started_date', '<=', $endDate);
                    }

                    if ($startDate) {
                        $contractQuery->where(function ($periodQuery) use ($startDate) {
                            $periodQuery
                                ->whereNull('end_date')
                                ->orWhere('end_date', '>=', $startDate);
                        });
                    }
                });
            })
            ->orderBy('created_at', 'desc')
            ->get();
    }

    public function getFranchisorActive(array $unitIds = []): Collection
    {
        return Student::with('unit')
            ->whereHas('contracts', fn ($q) => $q->where('status', 'active'))
            ->when(!empty($unitIds), fn ($q) => $q->whereIn('unit_id', $unitIds))
            ->orderBy('name')
            ->get();
    }

    public function getFranchisorStudentDetail(int $id): ?array
    {
        $student = Student::with('unit')->find($id);

        if (!$student) {
            return null;
        }

        $contract = StudentContract::where('student_id', $id)
            ->where('status', 'active')
            ->first();

        return [
            'id'       => $student->id,
            'name'     => $student->name,
            'phone'    => $student->phone,
            'unit'     => $student->unit ? ['fantasy_name' => $student->unit->fantasy_name] : null,
            'protocol' => $contract?->protocol,
        ];
    }

    public function getFranchisorSummary(array $unitIds = []): array
    {
        $query = Student::query()->when(!empty($unitIds), fn ($q) => $q->whereIn('unit_id', $unitIds));

        $total  = $query->count();
        $active = (clone $query)->where('status', 'active')->count();

        return ['total' => $total, 'active' => $active];
    }

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

    public function create(User $user, array $data): Student
    {
        $token = $data['registration_draft_token'];

        $responsibleData = $data['responsible'] ?? null;

        $avatar = $data['avatar'] ?? null;

        return $this->registrationDraftService->consume(
            $user,
            $token,
            function (array $studentData, int $unitId) use ($responsibleData, $avatar): Student {
                if ($avatar !== null) {
                    $studentData['avatar'] = $avatar;
                }

                $studentData = $this->handlePhoto($studentData);

                return DB::transaction(function () use ($studentData, $responsibleData, $unitId): Student {
                    $student = (new Student)
                        ->fill(array_merge($studentData, ['unit_id' => $unitId]))
                        ->withResponsibleForCreation($responsibleData);

                    $student->save();

                    if ($responsibleData !== null) {
                        $student->responsibles()->create($responsibleData);
                    }

                    return $student->load('responsibles');
                });
            },
        );
    }

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

        if (!$model) {
            return null;
        }

        $data = $this->handlePhoto($data, $model->photo_url);

        $model->update($data);

        return $model->fresh();
    }

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

        if (!$model) {
            return false;
        }

        if ($model->photo_url) {
            Storage::delete($model->photo_url);
        }

        return $model->delete();
    }

    private function handlePhoto(array $data, ?string $oldPhotoPath = null): array
    {
        if (!isset($data['avatar'])) {
            return $data;
        }

        if ($data['avatar'] instanceof UploadedFile) {
            if ($oldPhotoPath) {
                Storage::delete($oldPhotoPath);
            }

            $data['photo_url'] = $data['avatar']->store('students/photos');
        } elseif (is_null($data['avatar'])) {
            if ($oldPhotoPath) {
                Storage::delete($oldPhotoPath);
            }

            $data['photo_url'] = null;
        }

        unset($data['avatar']);

        return $data;
    }

    private function resolveUnitId(User $user): int
    {
        $activeUnitId = request()->input('active_unit_id');

        if ($activeUnitId) {
            $unit = $user->units()->where('units.id', $activeUnitId)->first();

            abort_if(!$unit, 403, 'Unidade não autorizada para este usuário.');

            return $unit->id;
        }

        $unit = $user->units()->first();

        abort_if(!$unit, 403, 'Usuário sem unidade associada.');

        return $unit->id;
    }
}