Live Ticket Sales System
Overview
A production-ready theatre ticket sales system built for the actual Medallion Theatre. The system handles real customer reservations, seat management, and performance scheduling.
Frontend built with Next.js App Router running on port 3000. Backend API with Express and PostgreSQL database on Neon (serverless Postgres). Authentication via JWT with role-based access control for clerks and managers.
Live Features
Real Reservations
Handles actual customer ticket purchases. Double-booking prevention ensures every seat can only be sold once.
Revenue Tracking
Dashboard displays total revenue, tickets sold, and occupancy rates. Real-time stats update as reservations come in.
Patron Database
Customer profiles with contact info and order history. Staff can search by name or patron ID for quick lookup.
Performance Management
Schedule matinee and evening shows. Track available vs sold seats for each performance.
Seat Categories
602 total seats with real-time availability
Staff Roles
- -Clerk
Can search patrons, make reservations, view seat availability, and generate Will Call receipts.
- -Manager
Full access including user management, performance scheduling, ticket cancellation, and reports.
Problem Solved
The theatre previously used manual paper-based reservations. This caused:
- - Lost reservations
- - Double bookings for popular shows
- - No way to track available seats in real-time
- - Difficulty generating reports
The new system handles all ticket sales digitally with automatic conflict prevention. Staff can now see real-time seat availability and prevent double bookings at the point of sale.