HR.Restaurant
An intelligent restaurant chatbot system powered by Python (Flask), MySQL, and Dialogflow. This project enables customers to interact with the restaurant through a natural language interface for reservations, order placements, menu navigation, and customer support -- all accessible via a responsive web platform.
Features
-
Dialogflow Chatbot Integration
- Make,or cancel reservations
- Explore the restaurant menu
- Place and update orders
- Track orders, give feedback, FAQs
-
NLP-based Interactions (via Dialogflow)
-
Admin Dashboard for managing users, orders, reservations, and feedback
-
Authentication System
- Signup / Login
- JWT-based session handling
- Password update (with or without JWT)
-
MySQL Database Integration
Technologies Used
| Layer | Tech Stack |
|---|---|
| Frontend | HTML, CSS, Bootstrap, JavaScript |
| Backend | Python (Flask), Flask-JWT |
| NLP Engine | Dialogflow |
| Database | MySQL (via XAMPP) |
| Tools | JWT, XAMPP, GitHub |
Project Structure
HR.Restaurant/
|
+-- src/
| +-- static/ # Static files (CSS, JS, etc.)
| +-- templates/ # HTML templates (index, login, admindashboard,base,feedback,orders,signup,updatepassword,up date profile,reservation ,userdashboard etc.)
| +-- app.py # Main Flask backend application
| +-- fetchdata.py # Database operations and utility functions
|
+-- database/
| +-- restaurant.sql # MySQL schema for the project
|
+-- doc/
| +-- SRS.pdf # Software Requirements Specification
| +-- DesignDoc.pdf # System Design Document
|
+-- requirements.txt # Python dependencies
+-- README.md # Project documentation
How to Run Locally
1. Clone the Repository
git clone https://github.com/hrranger5/HR.Restaurant.git
cd HR.Restaurant/src
cd HR.Restaurant/src
2. Create Virtual Environment and Activate
python -m venv venv
venv\Scripts\activate # For Windows
venv\Scripts\activate # For Windows
3. Install Dependencies
pip install -r ../requirements.txt
4. Set Up MySQL Database
- Open XAMPP and start Apache & MySQL.
- Open
phpMyAdminand create a database named:restaurant_chatbot - Import the SQL file located at:
/database/restaurant_chatbot.sql
5. Run the Application
python app.py
6. Visit in Browser
http://localhost:5000
Dialogflow Intents
| Use Case | Intents |
|---|---|
| Make Reservation | Make Reservation,Reservation Confirmation, Cancel_Reservation |
| Menu Navigation | Show Menu |
| Place Order | place-order, order-status ,add to cart |
| Customer Support | FAQs, Feedback, Track Order |
Project Documentation
| Document Name | Description | Location |
|---|---|---|
| SRS (Software Requirements Specification) | Functional and non-functional requirements | doc/SRS.pdf |
| Design Document | System architecture and design details | doc/DesignDoc.pdf |
| FinalReport | FYP detail | doc/FinalReport.pdf |
Author
- Name: Hafsa
- Roll No: BC210414048
- Project Type: Final Year Project (FYP)
- Domain: NLP-based Chatbot System
- Platform: Web
Future Enhancements
- OTP-based password reset
- Email/SMS confirmation for reservations
- Admin analytics dashboard
- Mobile app interface
Contact
For feedback or collaboration:
Email: hrranger555@gmail.com
License
This project is licensed under the MIT License.
(c) 2025 Hafsa - All rights reserved.