vendredi 20 avril 2018

Use property value in select query in Laravel 5

Model Event -> id, guests_count, status. Model Guest -> id, event_id, confirmed.

I need something like this:

Event::where('status', 'opened')->whereNotIn('id', $nId)
                        ->has('guests', '<' , XXX)
                        ->get();

Instead XXX I need to use guests_count value - different value for each event - is this possible?

I'm trying to get all not filled events (count of guests relation < guests_count).

I'm using Laravel 5.4.



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2qMsjpK
via IFTTT

Aucun commentaire:

Enregistrer un commentaire