AarogyaQ — Smart Queues for Healthier Waiting
A production-grade, real-time healthcare queue management system designed to replace traditional paper-token waiting setups with automated client portals, active sound announcements, and direct spreadsheet log compiles.
Key Features
Receptionist Admin Dashboard
Patient Registration: Add patient details (Name, Age, Mobile) to dynamically allocate unique queue tokens (e.g., AQ-001).
Live Queue Table: Dynamic sorting, filtering, and row selection tools.
Control Station: Trigger "Call Next Patient" (which auto-completes the serving token) or cancel specific patient slots.
Consultation Settings: Modify standard checkup time durations (1–60 mins) to update wait estimates.
Analytics Engine: Responsive SVG Area & Bar charts depicting queue wait averages, peak patient times, and completed consultation logs (built without heavy external dependencies to guarantee compatibility with React 19).
Excel Export: A simple action trigger to instantly download database records directly to the local Downloads directory.
Patient Personal Portal
Simulated Google & OTP Logins: Native-looking Google Account Chooser popups and animated Mobile SMS OTP code toasts with countdown counters.
Profile Management: Maintain persistent medical records (Blood Group, Medical Conditions, Age, Gender) stored securely in client-side storage.
Live Waitlist Tracker: Shows active token ticket, queue position, estimated wait times, and progress bar updates in real-time.
Self-Queue Booker: Book waitlist queue tokens directly from mobile/web interfaces.
Patient Waiting Room TV Display
Midnight Dark Mode: Specially optimized layout for large hospital/waiting room television screens.
Serving Banner: Giant fonts displaying the active ticket number and called patient name.
Audio Voice Chime: Synthetic sound chimes and automated text-to-speech caller alerts powered by the browser's Web Audio API.
Helpline Ticker: Smoothly scrolling bottom ticker listing emergency contacts, clinic lines, and support emails.
Backend & Sync Architecture
Real-time WebSockets: Socket.IO synchronization ensuring 0ms delay updates across all patient and admin screens.
SQL Datastore: Persistent SQLite3 database logic managing patient wait lists and settings.
Local Excel Synchronizer: SheetJS compiler that automatically syncs the SQLite database to a local spreadsheet (AarogyaQ_Queue_Data.xlsx) in the project root folder on every database update.
Samarth Joshi
