Realtime Teller Queue Management System is a full-stack web application for managing queue flow across Teller and Customer Service counters. It brings three distinct user roles together in one unified system:
- Public Page — visitors can take a queue number on their own and track their live position in the queue without needing to log in.
- Staff Dashboard — counter agents can call the next ticket, start service, complete, or skip tickets, with statuses synced automatically.
- Admin Panel — administrators can monitor all counters in realtime, manage staff accounts and counter configuration, and view daily reports.
The system's core strength is its realtime updates powered by Server-Sent Events (SSE) — every change in queue status appears instantly across all screens (visitor, counter, and admin) with no manual refresh. Queue numbering is designed to be collision-free through a daily sequence mechanism backed by strict database constraints.
Key Features:
- Self-service ticket booking with idempotency (protection against double-submits)
- Realtime queue status updates via SSE
- Session-based authentication with STAFF & ADMIN roles
- Counter and service management (Teller / CS)
- Daily reports and activity audit logging
- Responsive, modern user interface
Tech Stack:
Next.js 16 (App Router) · React 19 · TypeScript · PostgreSQL · Prisma ORM · Server-Sent Events (SSE) · Tailwind CSS · Radix UI · bcrypt · Vercel
