How to make table next_session change.

I'm currently developing a project that involves managing gaming sessions at tables. Here's how it works: an admin initiates a table, allowing players to join. The admin sets a specific date and time for the table to start. Once the scheduled time arrives, all players receive an on-screen notification indicating that the session is beginning. After the session concludes, the system updates the database to schedule the next session exactly one week from the current time. Which controller should I use to implement these features in my project? And what is the best approach to do so?

MohamedTammam

1 year ago

Level 51

Multiple approach in mind.

Run a cron job that updates session dates.
Create a table for session dates, and then fire a queue job after the session time to add new date in session_dates table. The last added date is the next date (That the way I prefere)

Please or to participate in this conversation.