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 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
    {
        $unitId = $this->resolveUnitId($user);

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

        unset($data['responsible']);

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

        return DB::transaction(function () use ($data, $responsibleData, $unitId): Student {
            $student = (new Student)
                ->fill(array_merge($data, ['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;
    }
}