Add page to view all attendees

[iAmWillShepherd]

Fixes #33

Solution

I added a page where a presenter can see all the attendees who've ever downloaded their slides.

Groupies page

Testing

To test this correctly, you will need to create at least two accounts that have completed onboarding (aka the user has a completed profile in the database) to test this properly.

1. Start Supabase CLI, supabase start
2. Create the view using the script in db.sql
3. Start the dev server, yarn dev
4. Log in to your account, here
5. Navigate to the create preso page, fill out the form, and submit (you should be taken to the QR page if successful. If you get undefined in the URL bar, something failed, and you should leave a comment on the failure and repro steps.)
6. Navigate to the survey page and fill out the survey
7. Navigate to the groupies page
8. Observe that there is one audience member on the list
9. Return to step 4 and log in with a different user account.

Note, you may have already had surveys and preso created, so it may be easier to compare what's changed instead of focusing on the numbers indicated in the testing steps.

Resources

View creation script to run

https://github.com/OneSignalDevelopers/ngosi/blob/cc7c6e5cc49f949febf4d27fb7b0e7e96001bbcb/db.sql#L66-L78

Navigating to the Survey page from the QR page

References

• .in filter docs
• Suggestion to use a view instead of using the supabase client to do joins

[vercel[bot]]

This pull request is being automatically deployed with Vercel (learn more).
To see the status of your deployment, click below or on the icon next to each commit.

🔍 Inspect: https://vercel.com/onesignaldevs/ngosi/Cq1oLYKx4ZXZDnJZgXvbXEpky1Ru
✅ Preview: https://ngosi-git-where-the-groupies-at-onesignaldevs.vercel.app