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 App\Support\Cpf;
use Illuminate\Database\Eloquent\Collection;
use Illuminate\Support\Facades\Auth;
use Illuminate\Support\Str;

class UserService
{
    public function authUser(): ?User
    {
        $user = Auth::user();

        if (!$user) {
            return null;
        }

        if ($user->isParceiro()) {
            $user->loadMissing('partnerAgreement');
        }

        return $user->load(['position', 'sector', 'dependents',])->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 getAssociadosForSelect(?string $search, int $perPage): \Illuminate\Pagination\LengthAwarePaginator
    {
        return $this->baseQuery([
            'type'   => UserTypeEnum::ASSOCIADO->value,
            'search' => $search,
        ])
            ->where('status', UserStatusEnum::ACTIVE)
            ->orderBy('name')
            ->paginate($perPage, ['id', 'name', 'registration']);
    }

    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']) . '%';
            $cpfTerm = ($digits = Cpf::digits($filters['search'])) ? '%' . $digits . '%' : null;

            $query->where(function ($q) use ($term, $cpfTerm) {
                $q->whereRaw('UNACCENT(LOWER(name)) LIKE UNACCENT(?)', [$term])
                    ->orWhereRaw('UNACCENT(LOWER(email)) LIKE UNACCENT(?)', [$term])
                    ->orWhereRaw('UNACCENT(LOWER(COALESCE(registration, \'\'))) LIKE UNACCENT(?)', [$term])
                    ->orWhereRaw("TO_CHAR(admission_date, 'DD/MM/YYYY') LIKE ?", [$term])
                    ->orWhereRaw("TO_CHAR(expiry_date, 'DD/MM/YYYY') LIKE ?", [$term])
                    ->orWhereHas('position', function ($p) use ($term) {
                        $p->whereRaw('UNACCENT(LOWER(positions.name)) LIKE UNACCENT(?)', [$term]);
                    });

                if ($cpfTerm) {
                    $q->orWhere('cpf', 'LIKE', $cpfTerm);
                }
            });
        }

        if (isset($filters['first_access']) && $filters['first_access'] !== '') {
            $accessed = filter_var($filters['first_access'], FILTER_VALIDATE_BOOLEAN);
            $accessed ? $query->whereHas('accessLogs') : $query->whereDoesntHave('accessLogs');
        }

        return $query;
    }

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

    public function create(array $data): User
    {
        if (empty($data['password'])) {
            $data['password'] = Str::random(32);
        }

        return User::create($data);
    }

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

        if (!$model) {
            return null;
        }

        if (array_key_exists('password', $data) && empty($data['password'])) {
            unset($data['password']);
        }

        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();
    }
}