MyResto — Restaurant Feedback & Operations Portal
Hospitality & Operations
MyResto — Restaurant Feedback & Operations Portal
Multi-Tier Ticket Dispatch, Dining Room Routing & Performance Analytics

Key Metrics & Impact
Automated ticket dispatch and instant routing directly to floor managers.
Centralized relational MySQL database eliminating lost paperwork or scattered emails.
Transparent live progress tracking with mobile-responsive feedback forms.
System Overview
Executive Summary
Efficient restaurant dining relies on transparent, dynamic feedback loops. Without a centralized tool to log, trace, and audit issues, customers face recurring service issues while restaurant managers lack the visibility to address them. To solve this, we engineered MyResto — a responsive, enterprise-grade restaurant management and complaint resolution platform built using Next.js 15 and React 19. MyResto connects customers, dining staff, and restaurant operations admins in a single dashboard, facilitating fast and accountable problem resolution.
The Project Challenge
Managing dining facilities for thousands of daily customer visits introduces complex, multi-party feedback channels. Prior to MyResto, multi-location restaurants struggled with fragmented paper comment logs, opaque ticket statuses where diners were left unaware of resolution progress, and slow manual spreadsheet reporting to audit recurring kitchen or facility bottlenecks.
Main Objectives
- Build a centralized complaint registration and tracking portal for dining customers
- Engineer an automated ticket dispatch workflow for floor and dining managers
- Implement secure multi-tier Role-Based Access Control (RBAC) via JWT middleware
- Design a high-performance relational database schema in MySQL using Prisma ORM
- Deliver real-time analytics and backlog charts for operations executives using ApexCharts
System Architecture
Role-Based Controls & Security
A granular multi-tier security model ensures complete endpoint gatekeeping: CUSTOMERS can securely submit feedback with photo attachments and track live ticket statuses; DINING MANAGERS receive instant alert feeds, assign tickets to specific departments, and log resolution notes; OPERATIONS ADMINS audit response times, configure branch settings, and export compliance reports.
Automated Workflows
Ticket workflows are automated end-to-end: new complaints trigger automatic status timestamps and branch department routing, real-time alert logs notify floor managers of escalated tickets, and monthly analytical audits compile automated compliance summaries.
UX Redesign & Styling System
Crafted with an accessible, high-performance modern UI using Tailwind CSS, featuring fast form inputs with photo upload previews, live status progress bars, and responsive analytical dashboards powered by ApexCharts for instant operational clarity.
Business Impact & Outcomes
- •Reduced complaint resolution cycles by 40% via automated dispatch
- •Achieved 100% data integrity with zero lost tickets across dining branches
- •Boosted overall customer dining satisfaction to 95%
- •Saved operations management hours of manual spreadsheet compiling each week