Advisory Workstation Ticketing System
Minimal, server-first service request and ticketing application
COMPLETEDSOLO
Overview
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.
Project Details
ClientRichmond Capital LLC
RoleFull-Stack Developer
TimelineSep 2025 - Oct 2025
Duration2 Months
Technologies
Next.js 15PrismaPostgreSQLBetter AuthResendMinIOTailwind CSSZodVitestRadix UI
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.