Skip to content

Latest commit

 

History

History
153 lines (123 loc) · 3.86 KB

README.md

File metadata and controls

153 lines (123 loc) · 3.86 KB

🤖 Hotel & Restaurant Management Chatbots

A powerful dual-bot system featuring a Hotel Booking Assistant and Restaurant Order Manager trainned with organic Dataset. Built with Python and MySQL for seamless automation of hospitality services.

🌟 Features

🏨 Hotel Booking Bot

  • 📝 Process new room bookings
  • 🔍 Check room availability in real-time
  • 💾 Store booking information in MySQL database
  • 🔄 Update room status automatically

🍽️ Restaurant Order Bot

  • 🛒 Take new food orders
  • 📋 Manage menu items
  • 💳 Process order details
  • 📦 Store order history in MySQL database

🛠️ Tech Stack

  • 📍 Python 3.8+
  • 🗄️ MySQL Database
  • 🔌 mysql-connector-python
  • 🤖 Python's built-in libraries

📋 Prerequisites

  • Python 3.8 or higher
  • MySQL Server
  • pip (Python package manager)
  • Basic knowledge of SQL queries

🚀 Getting Started

1. Clone the Repository

git clone https://github.com/yourusername/hotel-restaurant-bots.git
cd hotel-restaurant-bots

2. Database Setup

-- Create the hotel_bookings table
CREATE TABLE hotel_bookings (
    booking_id INT AUTO_INCREMENT PRIMARY KEY,
    guest_name VARCHAR(100),
    room_number INT,
    check_in DATE,
    check_out DATE,
    status VARCHAR(20),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- Create the restaurant_orders table
CREATE TABLE restaurant_orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    customer_name VARCHAR(100),
    items JSON,
    total_amount DECIMAL(10,2),
    order_status VARCHAR(20),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

4. Environment Setup

Replace email password with your gmail SMTP to send email alert after booking.

5. Run the Bots

# For Hotel Booking Bot
python bot.py

# For Restaurant Order Bot
python bot2.py

💻 Usage

Hotel Booking Bot

# Example interaction with Hotel Bot
python bot.py

# Bot commands:
/book - Book a new room
/availability - Check available rooms
/status - Check booking status
/help - Show all commands

Restaurant Order Bot

# Example interaction with Restaurant Bot
python bot2.py

# Example commands:
/menu - Show menu items
/order - Place new order
/status - Check order status
/help - Show all commands

But you can chat normally, the bot will understand as it is trainned with real dataset.

📊 Database Schema

Hotel Bookings Table

Column Type Description
booking_id INT Primary Key
guest_name VARCHAR(100) Guest's full name
room_number INT Assigned room number
check_in DATE Check-in date
check_out DATE Check-out date
status VARCHAR(20) Booking status
created_at TIMESTAMP Booking creation time

Restaurant Orders Table

Column Type Description
order_id INT Primary Key
customer_name VARCHAR(100) Customer's name
items JSON Ordered items details
total_amount DECIMAL Order total
order_status VARCHAR(20) Order status
created_at TIMESTAMP Order creation time

🔧 Configuration

Both bots can be configured through their respective config files:

  • config/hotel_config.py
  • config/restaurant_config.py

🤝 Contributing

  1. Fork the repository
  2. Create your feature branch (git checkout -b feature/AmazingFeature)
  3. Commit your changes (git commit -m 'Add some AmazingFeature')
  4. Push to the branch (git push origin feature/AmazingFeature)
  5. Open a Pull Request

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

👥 Support

For support:

⭐ Show your support

Give a ⭐️ if this project helped you!

Made with ❤️ by Robin | © 2024 All rights reserved