Next.js
OVERVIEW
A college event registration platform enabling students to register, make payments, upload receipts, and verify participation. Includes an admin dashboard and QR-based check-in system. Implements role-based access for admins and coordinators to manage events, verify submissions, and track participant data in real time.
TECH STACK
Next.jsSupabaseTypeScript
KEY FEATURES
- Team and individual event registration with UPI/cash payment submission and receipt upload
- Signed QR-code generation and scan-based check-in for events and food checkpoints with duplicate-scan protection
- Admin dashboard for verifying payments, assigning lot numbers, and tracking live attendance
- Role-based access via Clerk auth separating admins, coordinators, and members
HOW IT WORKS
- 01A participant registers through the Next.js form, which writes a new row to the registrations table
- 02The payment receipt uploads to Supabase Storage and creates a row in the payments table for review
- 03A sequential lot number is assigned for on-spot registrations
- 04Admins verify payments and track live attendance from a role-checked dashboard
- 05On event day, a QR scanner decodes each participant's signed code and logs check-in/attendance
CHALLENGES
Manually-submitted UPI/cash receipts and on-spot registrations both need sequential lot numbers without collisions under concurrent sign-ups, plus strict admin/coordinator role separation. Solved with a dedicated lot-number generator, Supabase Row Level Security, and a permissions table gating every admin action.
METRICS
7
Database tables
25
API routes
22,386
TS/TSX LOC
56
npm dependencies