mercredi 2 février 2022

Laravel 3 table join and query

I have 3 database tables. Users, diffacts, offdays.USERS table has user information. In offdays table, the user has date_start field, if a user's date_start field shows today's date, the user is allowed. If today's date appears in the user's date_start field in the diffacts table, I will get the duration field I will create a table at the front end and write the user name-permission status - duration status of each user. When I add today's date to the where part when I join query, it brings the users whose date_start field is today. I need all users, I would appreciate if you could help me.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire