MyResto System

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 Operational 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 Feedback: Food quality or facility complaints were submitted via paper registers, emails, or third-party forms with zero unified tracing.
• Opaque Statuses: Customers were left in the dark about whether their complaints were received, active, or resolved.
• Role-Based Access Disconnection: Allowing customers, dining managers, and brand auditors to share one system required secure, multi-tier endpoint gatekeeping.
• Slow Analytical Audits: Creating performance reports took hours of manual database sorting, masking recurring issues.

Our Technical Solution

We built a responsive web architecture utilizing the latest features of Next.js 15 and React 19, coupled with a robust relational backend:

• Full-Stack Next.js 15: Leveraged the App Router structure to optimize loading states. We built secure server actions alongside client-side state handling to ensure fast form inputs and table filtration.
• Relational MySQL Backend: Integrated a MySQL database using mysql2 and Prisma to design high-performance schemas mapping users, roles, categories, and audit logs.
• Granular Role Security: Secured API endpoints with customized JSON Web Token (JWT) verification, implementing authorization middleware to separate Customer interfaces from Admin control desks.
• Real-time Analytical Feeds: Embedded interactive dashboards with ApexCharts, giving administrators real-time charts of ticket backlogs and peak resolution hours.

User Flow & Resolution Cycles

The system is designed with specific interfaces tailored for each user category:

• The Customer: Logs in securely, uploads a complaint detailing the issue (with option to attach photos), selects the restaurant branch, and tracks ticket status in real-time.
• The Dining Manager: Receives instant dashboard updates, assigns tickets to specific departments, inputs logs, and updates the status to "Resolved."
• The Operations Admin: Generates automated monthly compliance reports, monitors team response times, and checks audit logs to ensure overall service accountability.

Business Outcomes

MyResto successfully modernized feedback management for busy restaurant dining rooms:

• 40% Faster Issue Resolution: Administrative tasks are automated, routing tickets directly to staff for faster action.
• Unified Data Transparency: Centralized all records to a single MySQL instance, preventing ticket loss and data lag.
• 95% Customer Satisfaction Rate: Pre-populated forms, status updates, and mobile responsiveness made feedback accessible and satisfying.