HR.Restaurant

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,update 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

2. Create Virtual Environment and Activate

python -m venv venv
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 phpMyAdmin and 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 —