Can't access attributes of stdClass in afterQuery method using pagination

[filipegomessouza]

Laravel Version

11.3.0

PHP Version

8.3.13

Database Driver & Version

No response

Description

I trying to use afterQuery method with Query Builder, but if pagination is used, some problems are happening.

Steps To Reproduce

Consider the given code:

DB::table('users')
        ->afterQuery(fn (Collection $users) => $users->map(function (stdClass $user)
        {
            $user->name = $user->name . ' last name';
        
            return $user;
        }))
        ->paginate()

The following error is obtained: Undefined property: stdClass::$name

But if i use ->get() instead ->paginate() method, it works.

Do someone know what is the problem with my code?

[MrVH-IR]

@filipegomessouza
Hello Friend. Here's what i believe is your problem-> afterQuery doesn't work directly with pagination because pagination returns a (LengthAwarePaginator). You Need to modify collection after pagination And Create a custom wrapper function Then Transform data after pagination
Try this ->

 Route::get('/users', function () {
    $users = DB::table('users')
        ->paginate()
        ->through(function ($user) {
            $user->name = $user->name . ' last name';
            return $user;
        });

    return $users;
});

Or You can use this->

Route::get('/users', function () {
    return tap(DB::table('users')->paginate(), function ($paginator) {
        $paginator->getCollection()->transform(function ($user) {
            $user->name = $user->name . ' last name';
            return $user;
        });
    });
});

through or tap are alternative approach. Both methods modify the collection after pagination and Maintains pagination Metadata

[filipegomessouza]

@MrVH-IR
Thank you for the answer.

The Eloquent Builder works normally with pagination. For example:

User::query()
        ->afterQuery(fn (Collection $users) => $users->map(function (User $user)
        {
            $user->name = $user->name . ' last name';
        
            return $user;
        }))
        ->paginate()

The above code works... The question that remains is why the eloquent builder works, but the query builder doesn't?