My database structure looks like this:
User
id - integer
user_user_group
user_id - integer
user_group_id - integer
meeting_user_group
user_group_id - integer
meeting_id - integer
meeting_mails
meeting_id - integer
sent - boolean
date - date
meetings
id - integer
I have a user from whom I need to get the meeting_mails where sent == false and date == today. Is there a smart way to do this in Laravel, or do I have to write an ugly SQL query by hand?
For performance reasons, I would like to make as little as possible with collections or arrays and let the database do as much as possible.
I'm using Laravel version 5.8
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire