eagle-restaurant

bypuskar acharya

🍽️ Restaurant QR-Based Ordering System 📄 Complete Development Prompt / Specification 🎯 Project Goal Build a web-based Restaurant QR Ordering System that allows customers to scan a QR code at their table, browse a digital menu, place orders, and manage billing—while restaurant staff can monitor and manage orders in real time. ⸻ 🧩 Core Requirements 1. 📱 Customer-Side Features 🔹 QR Code Scanning • Each table has a unique QR code • QR redirects to: https://yourdomain.com/menu?table_id=TABLE_NUMBER • System must automatically detect the table ID ⸻ 🔹 Interactive Digital Menu • Display: • Food image • Name • Description • Price • Category (e.g., Drinks, Snacks, Main Course) • Features: • Search & filter • Add to cart • Quantity selection ⸻ 🔹 Real-Time Order Placement • Customers can: • Add/remove items • Update quantity • Place order instantly • Order is sent to backend in real time ⸻ 🔹 Ordering by Table • Every order must include: • table_id • order_items • total_price • timestamp ⸻ 🔹 Digital Bill View • Show: • Ordered items • Quantity • Price per item • Subtotal • Tax & service charge • Final total • Bill updates automatically when items are added ⸻ 🔹 (Optional) Order Tracking • Status shown to customer: • Pending • Preparing • Ready • Served ⸻ 🧑‍🍳 2. Admin / Restaurant Features 🔹 Live Order Dashboard • Display all incoming orders: • Table number • Items ordered • Time • Status • Real-time updates (WebSocket / polling) ⸻ 🔹 Order Management • Staff can: • Accept order • Update status: • Pending → Preparing → Served • Mark as completed ⸻ 🔹 Menu Management • Admin panel must allow: • Add new items • Edit existing items • Delete items • Upload images • Categorize items ⸻ 💰 3. Accounting & Billing Module 🔹 Automatic Bill Generation • Bill created automatically when order is placed • Linked to: • table_id • order_id ⸻ 🔹 Real-Time Bill Updates • Bill updates dynamically as: • Items are added/removed ⸻ 🔹 Tax & Charges Calculation • System should support: • VAT (e.g., 13%) • Service charge (optional) • Discounts • Formula example: total = subtotal + tax + service_charge - discount ⸻ 🔹 Daily Sales Tracking • Store all transactions • Calculate: • Total revenue per day • Number of orders • Average order value ⸻ 🔹 Profit & Reports • Generate reports: • Daily / Weekly / Monthly • Most popular items • Revenue trends ⸻ 💳 4. Payment Integration 🔹 Payment Methods • Cash (manual confirmation) • Digital Wallets: • eSewa • Khalti ⸻ 🔹 Payment Status Tracking Each order must have: • paid • unpaid • pending ⸻ 🏗️ 5. System Architecture 🔹 Frontend • Tech: • HTML, CSS, JavaScript • OR React (preferred) • Features: • Mobile responsive • Fast loading ⸻ 🔹 Backend • Options: • Node.js (Express) • OR PHP (Laravel) • OR Java (Spring Boot) ⸻ 🔹 Database (MySQL) Tables required: • tables → table_id, qr_code • menu_items → id, name, price, category, image • orders → id, table_id, status, total_price • order_items → order_id, item_id, quantity • payments → order_id, method, status • reports (optional) ⸻ 🔹 QR Code Logic • Generate QR per table: https://yourdomain.com/menu?table_id=5 • Use any QR library (e.g., qrcode.js or backend generator) ⸻ ⚡ 6. Technical Expectations • REST API or GraphQL • Real-time updates (Socket.io recommended) • Secure endpoints (basic auth for admin) • Clean UI/UX • Error handling • Scalable design ⸻ 🚀 7. Optional Enhancements • Customer login system • Multi-language support • Waiter notification system • Table reservation system • AI-based recommendations ⸻ 📦 Final Deliverables • Fully working web app • Admin dashboard • Database schema • QR code system • Payment integration (test/demo acceptable) • Documentation ⸻