Kalhara JA← All Works
KJA·2025 · Case study
Advisory Workstation Tickets
Minimal, server-first service request and ticketing application
The brief
A robust, production-grade service request management system featuring Role-Based Access Control, automated workflows, and secure file handling. Built with a focus on type safety and complete test coverage.
Approach
Built on Next.js 15 / Prisma / PostgreSQL with Better Auth for RBAC, PostgreSQL trigram search for tickets, and MinIO/S3 for secure attachment handling — with full test coverage via Vitest.
Outcome
Delivered a production-grade service-request system for Richmond Capital LLC with automated email notifications, full audit logging, and complete type safety end-to-end.
Key features
Role-Based Access Control (RBAC)
Secure authentication and authorization for 'user' (requester) and 'admin' roles using Better Auth.
Ticket Life-cycle Management
Comprehensive ticket handling with statuses, priorities, comment threads, and file attachments.
Smart Email Notifications
Automated notifications via Resend for ticket creation, comments, and status changes with built-in de-duplication.
Advanced Search
High-performance text search using PostgreSQL trigram extensions and Full-Text Search.
Secure Attachment Handling
Storage via MinIO/S3 with secure download proxies and RBAC-controlled access.
Full Audit Logging
Traceability for every action within the system, including IP tracking and state change serialization.