sfp_api_laravel_serprati/app/Services/AppointmentService.php

<?php

namespace App\Services;

use App\Enums\AppointmentStatusEnum;
use App\Enums\NotificationRecipientEnum;
use App\Models\Appointment;
use Carbon\Carbon;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Pagination\LengthAwarePaginator;
use Illuminate\Support\Str;

class AppointmentService
{
    public function __construct(protected NotificationService $notificationService) {}
    public function getAll(): Collection
    {
        return Appointment::with(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService'])
            ->orderBy('date', 'desc')
            ->get();
    }

    public function getAllByUser(int $userId): Collection
    {
        return Appointment::with(['userDependent', 'partnerAgreement', 'partnerAgreementService'])
            ->where('user_id', $userId)
            ->orderBy('date', 'desc')
            ->get();
    }

    public function getAllByPartnerUser(int $userId): Collection
    {
        return Appointment::with(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService'])
            ->whereHas('partnerAgreement', fn($q) => $q->where('user_id', $userId))
            ->orderBy('date', 'desc')
            ->get();
    }

    public function findById(int $id): ?Appointment
    {
        return Appointment::with(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService'])->find($id);
    }

    public function findByIdForPartnerUser(int $id, int $userId): ?Appointment
    {
        return Appointment::with(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService'])
            ->whereHas('partnerAgreement', fn($q) => $q->where('user_id', $userId))
            ->find($id);
    }

    public function create(array $data): Appointment
    {
        $data['order_number'] = $this->generateOrderNumber();
        $data['requested_at'] = now();

        return Appointment::create($data)
            ->load(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    public function notifyCreation(Appointment $model): void
    {
        $dateStr   = $model->date ? Carbon::parse($model->date)->format('d/m/Y') : null;
        $dependent = $model->userDependent?->name;
        $target    = $dependent ? "para o dependente {$dependent}" : 'para você';

        $message = $dateStr
            ? "Um agendamento #{$model->order_number} foi criado {$target}" . ($model->time ? " para {$dateStr} às {$model->time}" : " em {$dateStr}") . "."
            : "Um agendamento #{$model->order_number} foi criado {$target}.";

        $this->notificationService->createAutoForUser([
            'title'     => 'Novo agendamento',
            'message'   => $message,
            'recipient' => NotificationRecipientEnum::ASSOCIADO,
            'source'    => 'appointment',
            'source_id' => $model->id,
        ], $model->user_id);
    }

    public function update(int $id, array $data, ?int $approvingUserId = null): ?Appointment
    {
        $model = Appointment::find($id);

        if (!$model) {
            return null;
        }

        if (
            isset($data['status'])
            && $data['status'] === AppointmentStatusEnum::CONFIRMADO->value
            && $model->status !== AppointmentStatusEnum::CONFIRMADO
        ) {
            $data['auto_approved'] = false;
            $data['approved_by_user_id'] = $approvingUserId;
        }

        $model->update($data);
        return $model->fresh(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    public function delete(int $id): bool
    {
        $model = Appointment::find($id);

        if (!$model) {
            return false;
        }

        return $model->delete();
    }

    public function getAdminCounters(): array
    {
        return [
            'pendentes'  => Appointment::where('status', AppointmentStatusEnum::PENDENTE)->count(),
            'aprovados'  => Appointment::where('status', AppointmentStatusEnum::CONFIRMADO)->count(),
            'recusados'  => Appointment::where('status', AppointmentStatusEnum::RECUSADO)->count(),
        ];
    }

    public function getAllPaginated(array $filters = [], int $perPage = 10): LengthAwarePaginator
    {
        $query = Appointment::with(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService'])
            ->orderBy('requested_at', 'desc');

        if (!empty($filters['status'])) {
            $query->where('status', $filters['status']);
        }

        if (!empty($filters['search'])) {
            $term = '%' . mb_strtolower($filters['search']) . '%';
            $query->where(function ($q) use ($term) {
                $q->whereHas('user', function ($uq) use ($term) {
                    $uq->whereRaw('UNACCENT(LOWER(name)) LIKE UNACCENT(?)', [$term]);
                })->orWhereHas('userDependent', function ($dq) use ($term) {
                    $dq->whereRaw('UNACCENT(LOWER(name)) LIKE UNACCENT(?)', [$term]);
                })->orWhereHas('partnerAgreement', function ($pq) use ($term) {
                    $pq->whereRaw('UNACCENT(LOWER(company_name)) LIKE UNACCENT(?)', [$term]);
                })->orWhereHas('partnerAgreementService', function ($sq) use ($term) {
                    $sq->whereRaw('UNACCENT(LOWER(name)) LIKE UNACCENT(?)', [$term]);
                })->orWhereRaw('UNACCENT(LOWER(order_number)) LIKE UNACCENT(?)', [$term]);
            });
        }

        return $query->paginate($perPage);
    }

    public function approve(int $id, string $date, string $time, ?int $approvedByUserId = null): ?Appointment
    {
        $model = Appointment::find($id);
        if (!$model) return null;
        $model->update([
            'status'              => AppointmentStatusEnum::CONFIRMADO,
            'date'                => $date,
            'time'                => $time,
            'auto_approved'       => false,
            'approved_by_user_id' => $approvedByUserId,
        ]);
        $this->notificationService->createAutoForUser([
            'title'     => 'Agendamento confirmado',
            'message'   => "Seu agendamento #{$model->order_number} foi confirmado para " . Carbon::parse($date)->format('d/m/Y') . " às {$time}.",
            'recipient' => NotificationRecipientEnum::ASSOCIADO,
            'source'    => 'appointment',
            'source_id' => $model->id,
        ], $model->user_id);
        return $model->fresh(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    public function reject(int $id): ?Appointment
    {
        $model = Appointment::find($id);
        if (!$model) return null;
        $model->update(['status' => AppointmentStatusEnum::RECUSADO]);
        $this->notificationService->createAutoForUser([
            'title'     => 'Agendamento recusado',
            'message'   => "Seu agendamento #{$model->order_number} foi recusado.",
            'recipient' => NotificationRecipientEnum::ASSOCIADO,
            'source'    => 'appointment',
            'source_id' => $model->id,
        ], $model->user_id);
        return $model->fresh(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    public function approveByPartner(int $id, int $userId, string $date, string $time): ?Appointment
    {
        $model = Appointment::whereHas('partnerAgreement', fn($q) => $q->where('user_id', $userId))->find($id);
        if (!$model) return null;
        $model->update([
            'status'              => AppointmentStatusEnum::CONFIRMADO,
            'date'                => $date,
            'time'                => $time,
            'auto_approved'       => false,
            'approved_by_user_id' => $userId,
        ]);
        $this->notificationService->createAutoForUser([
            'title'     => 'Agendamento confirmado',
            'message'   => "Seu agendamento #{$model->order_number} foi confirmado para " . Carbon::parse($date)->format('d/m/Y') . " às {$time}.",
            'recipient' => NotificationRecipientEnum::ASSOCIADO,
            'source'    => 'appointment',
            'source_id' => $model->id,
        ], $model->user_id);
        return $model->fresh(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    public function rejectByPartner(int $id, int $userId): ?Appointment
    {
        $model = Appointment::whereHas('partnerAgreement', fn($q) => $q->where('user_id', $userId))->find($id);
        if (!$model) return null;
        $model->update(['status' => AppointmentStatusEnum::RECUSADO]);
        $this->notificationService->createAutoForUser([
            'title'     => 'Agendamento recusado',
            'message'   => "Seu agendamento #{$model->order_number} foi recusado.",
            'recipient' => NotificationRecipientEnum::ASSOCIADO,
            'source'    => 'appointment',
            'source_id' => $model->id,
        ], $model->user_id);
        return $model->fresh(['user', 'userDependent', 'partnerAgreement', 'partnerAgreementService']);
    }

    private function generateOrderNumber(): string
    {
        do {
            $number = 'AGD-' . strtoupper(Str::random(8));
        } while (Appointment::where('order_number', $number)->exists());

        return $number;
    }
}