Inline query scope with parameter

How can I pass a parameter to an inline query scope?

   $shows = Show::upcoming()->with(
        ['events' => function($q, $reward) {
            $q->restrictDays($reward->ticket_restrictions);
        }]
    )->get();

This causes the following error:

Too few arguments to function App\Http\Controllers\EventController::App\Http\Controllers{closure}(), 1 passed in /vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php on line 629 and exactly 2 expected

MichalOravec

4 years ago

Level 75

$shows = Show::upcoming()->with(['events' => function ($q) use ($reward) {
    $q->restrictDays($reward->ticket_restrictions);
}])->get();

Docs: https://www.php.net/manual/en/functions.anonymous.php (Look for Example #3 Inheriting variables from the parent scope)

tykus

4 years ago

Level 104

If you are using PHP 7.4 or above, you can use short Closures (so do not need to worry about variable scope within the Closure):

$shows = Show::upcoming()
    ->with(['events' => fn ($q) => $q->restrictDays($reward->ticket_restrictions)])
    ->get();

Please or to participate in this conversation.