S25 Sprint 2- Cron Job email notification

[johannesq23]

Context

We want the options for event notifications before the event takes place, 48 hours in advance. We would like to run a cron job every day to remind the users that they have an event, and if they cannot make it, they should cancel.

Requirements

We will be using github actions to make the cron job. Look into how to create a cron job in /.github/workflows. This is the workflow I wrote on my last team you can use as a reference.

We want this to be optional, so once again, create a toggle button that asks the admin if they want users to be notified 48 hours before event in the event creation page.

Create an api endpoint in /api/registrations, this will filter all registrations within the 24-48 hour time frame + have a "sendReminderEmail" boolean set to true. and send an email to them.

You will once again need to make some schema changes, namely in eventparent and registrations, but don't worry about setting up any new migration code. Use the mailersend API as before, to send a reminder email. I will look into creating a new mailersend template and get back you you on that.

As always, start early and message me if you have any questions related to functionality or anything.

Acceptance Criteria

• Cron Job created and runs every 24 hours
• Event create modal updated
• Schemas changed accordingly
• Notifications sent out to users correctly
• Appropriate testing is completed