• Heroku webserver (US region) use PostgreSQL but we've used MySQL
• Due to US, the system will confuse you for a fraudster from the United States, several features that require authentication will be unavailable.
• but it FREE Demo App

The hotel management system is a database that contains the following:

1. A hotel booking system that allows users to pick a room from a hotel, pick a specific date, and view details about the hotel
2. A function to register new hotels to the database that only the admin can use.
3. A function to register new members to the database, where every member contains information about the members and any guest users can use.
4. A news information system, which is connected to membership, where users can view news that is created by the hotel managers.
5. A transaction system where users can create new transactions and hotel managers can remove transactions after completion.
6. A payment system where users can add banking information that is used for transactions.
7. A promotion system, which is connected to the payment system, that hotel managers can add to the database and users can view.
8. A rating system, which is connected to hotel detail, where only users can add ratings to each hotel for other users, hotel managers, and staff to view.
9. Users can view details about the hotel which include room, staff, and ratings which only the admin and manager can edit.

1. In the step of the payment, we have to join the Transaction Payment AllBook Promotion table together to get the room Book_Price from AllBook and you have to get the All_Price from the Payment table which this step the application needs to get the Promotion_Id to find which discount user use can calculate the All_Price.

2. When a user is going to book a hotel and room. We have to join the Room, hotel and room type table together to show which hotel and room, room type is available.

3. In rating transactions, we evaluate the score of each hotel by getting the Rating_Score from the Transaction table, querying the Room_Id from Allbook table, and using the Room_Id to identify which hotel the room is in from the Room table. After we got all the rating scores given to the specific hotel, we calculate the mean of it and display it along with the hotel name and address.

4. In getting news transactions, we use GetNews table to tell us which member gets specific news. Each time the member gets the news, we join the Member table and News table together and generate a new GetNews_Id in the GetNews table.

5. Therefore our hotel system have a feature that can add or remove hotel in our system. To do that we have to join the hotel table, room table, room type, staff/Manager table together. So that we can generate a new hotel.

• In order to book rooms with our service, the user needs to register as a guest first.
• For the employee, there’re two roles staff and manager.
  • Manager, manage the hotel, staff and promotion.
  • Staff, work in the hotel.
• The guest can book more than one room per transaction.
• The guest can apply a discount with the available promotion when paying for the rooms.
  • The promotion is applicable within the given duration.
• The guest can write the reviews to the hotel after resting at the hotel.
• The guest who resting at the hotel doesn’t have to be the one who paid for the service.
  • The guest can verify the identity by showing staff the (something).
• The guest can rest in the room between check-in and check-out time.
  • If the guest check-out later than the given time, the guest will have to pay for the next day's stay.

• Bootstrap 5.1.3

• Django 4.0.4
• Cloudinary

• MySQL
• XAMPP v.3.3.0
• PHP 7.4.9

• Register add member
• View Profile
• Login
• Logout
• Contact admin form
• Add Hotels
• View Hotels
• Edit Hotels
• Delete Hotels
• Add Promotions
• View Promotions
• Edit Promotions
• Delete Promotions
• Search Member
• Add Staff into hotel
• Remove Staff from DB
• Add News
• Remove News
• Send News to member
• Inbox Page
• Check Room Available
• Reserve Hotel Room
• Show All Books Page
• Clear Unwanted Books
• Free Hotel Room
• Calculater Final Price
• Payment System
• Confirm Payment (for all staffs)
• Write Reviews System (open for confirm transactions)
• Show latest 4 reviews in Hotels detail
• Calculate Culmulative Ratings

• Fixed navbar
• Deal with static files (define STATIC_ROOT & collectstatic before build app)
• Deal with media fiels (cloudinary storage)
• Contact Admin Form
• Admin Receive Form
• Password Recovery (not work in US-heroku)
• Email Notification (not work in US-heroku)
• Generate Token & Verify Link via Email (not work in US-heroku)
• Line Notification
• AJAX calculate price when booking
• Validate date-time booking promotion discount
• Play with Staff command (we have staff_level)
• Apply binary-indexed tree into DB

don't forget to install virtual environment

$ python3 -m pip install virtualenv
$ python3 -m virtualenv venv
$ source venv/bin/activate

clone this repo and install 3-rd party libaries

$ git clone https://github.com/Panichito/CPE231.git
$ cd CPE231
$ pip3 install -r requirements.txt

to runserver on localhost:8000

$ python3 manage.py runserver