sfp_api_laravel_serprati/app/Services/UserService.php

<?php

namespace App\Services;

use App\Enums\UserStatusEnum;
use App\Enums\UserTypeEnum;
use App\Models\User;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Support\Facades\Auth;

class UserService
{
    public function authUser(): ?User
    {
        $user = Auth::user();
        return $user?->load(['position', 'sector'])
                     ->loadCount(['notificationSends as unread_notifications_count' => fn($q) => $q->where('read', false)]);
    }

    public function getAll(): Collection
    {
        return User::with(['position', 'sector'])->orderBy("created_at", "desc")->get();
    }

    public function getAllPaginated(array $filters = [], int $perPage = 10): \Illuminate\Pagination\LengthAwarePaginator
    {
        $query = $this->baseQuery($filters)
            ->with(['position', 'sector'])
            ->withMin('accessLogs', 'accessed_at')
            ->orderBy('name', 'asc');

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

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

    /**
     * Status existentes no conjunto filtrado, desconsiderando o próprio filtro de status.
     *
     * @return array<int, string>
     */
    public function getStatusOptions(array $filters = []): array
    {
        return $this->baseQuery($filters)
            ->toBase()
            ->distinct()
            ->pluck('status')
            ->filter()
            ->values()
            ->all();
    }

    private function baseQuery(array $filters): \Illuminate\Database\Eloquent\Builder
    {
        $query = User::query();

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

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

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

        if (!empty($filters['search'])) {
            $term = '%' . mb_strtolower($filters['search']) . '%';
            $query->where(function ($q) use ($term) {
                $q->whereRaw('UNACCENT(LOWER(name)) LIKE UNACCENT(?)', [$term])
                  ->orWhereRaw('UNACCENT(LOWER(email)) LIKE UNACCENT(?)', [$term])
                  ->orWhereRaw('UNACCENT(LOWER(COALESCE(cpf, \'\'))) LIKE UNACCENT(?)', [$term])
                  ->orWhereRaw('UNACCENT(LOWER(COALESCE(registration, \'\'))) LIKE UNACCENT(?)', [$term]);
            });
        }

        return $query;
    }

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

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

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

        if (!$model) {
            return null;
        }

        if (isset($data['status'])) {
            $newStatus = $data['status'] instanceof UserStatusEnum
                ? $data['status']
                : UserStatusEnum::from($data['status']);

            if ($newStatus === UserStatusEnum::INACTIVE && $model->status !== UserStatusEnum::INACTIVE) {
                $data['excluded_at'] = now();
            } elseif ($newStatus !== UserStatusEnum::INACTIVE) {
                $data['excluded_at'] = null;
            }
        }

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

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

        if (!$model) {
            return false;
        }

        return $model->delete();
    }

    public function setOnLeave(int $id, int $byUserId): ?User
    {
        $model = $this->findById($id);
        if (!$model) return null;

        $model->update([
            'status'               => UserStatusEnum::ON_LEAVE,
            'on_leave_at'          => now(),
            'on_leave_by_user_id'  => $byUserId,
        ]);

        return $model->fresh();
    }

    public function approve(int $id): ?User
    {
        $model = $this->findById($id);
        if (!$model) return null;

        $model->update([
            'status' => UserStatusEnum::ACTIVE,
        ]);

        return $model->fresh();
    }

    public function refuse(int $id): ?User
    {
        $model = $this->findById($id);
        if (!$model) return null;

        $model->update([
            'status' => UserStatusEnum::REFUSED,
        ]);

        return $model->fresh();
    }

    public function getUserTypes(): array
    {
        return UserTypeEnum::toArray();
    }
}