Reminder email sent to attendee claims the upcoming meeting is with the wrong person (Solution available). #48

Before submitting

• I've searched existing issues and this isn't a duplicate.
• This is a reproducible bug in Calnode — not a configuration/setup question or a feature request.

What's the bug?

Hello,
I spotted a weird, albeit easy to fix bug regarding the reminder email that gets sent to the attendee of a meeting, which I was able to fix, and I would like to share the solution here.

The reminder email sent to the attendee claimed that the meeting was to happen with the creator of the event type and not the host who had actually undertaken the meeting. For a one-man team this is fine, but for a setup with multiple people involved it would quickly lead to confusion, as it did in my case.

All emails were sent to the correct addresses, events were appointed to the correct host and saved in the correct calendar, so the sole problem was the name of the host in the reminder email sent to the attendee.
This looked like a background worker mixing things up, and sure enough, after looking around I located the faulty sql query responsible for the mix-up. After consulting the database schema, I managed to resolve the issue with just one change in the query.

Solution: In /internal/worker/worker.go, in the SendReminder function (around line 260), within the sql query replace "JOIN users u ON u.id = et.user_id" with "JOIN users u ON u.id = b.host_id". This will take into account the host the booking has been assigned to and not the user who created the event type.

@shockalotti, given that the fix was pretty straightforward and I already applied it, I would happily open a pr if you want me to.

Steps to reproduce

Steps to reproduce bug:

1. Create an event type
2. In its settings, go to the 'hosts' tab and assign a different host than yourself (the creator of the event type)
3. In the 'notifications' tab add a notification of your liking
4. Complete a booking
5. When the time you specified in step 3 comes, the attendee receives an email with the reminder, claiming the meeting is to happen between them and the creator of the event type and not the host it was assigned to (you can see who the meeting was assigned to in the 'bookings' tab)

Steps to resolve bug:

1. Go to /intenal/mailer/mailer.go file
2. Locate SendReminder function (around line 260)
3. Within said function, locate the sql query responsible for fetching the booking data
4. Replace 'JOIN users u ON u.id = et.user_id ', which cares about the owner of the event type (et) with 'JOIN users u ON u.id = b.host_id', which cares about the host responsible for the upcoming booking (b).

Calnode version / commit

v0.9.0

How are you running Calnode?

Railway / other PaaS

Logs, screenshots, or anything else

No response