Hotel Reservation System Using QR Code
Hotel Reservation System Using QR Code
Hotel Reservation System Using QR Code
Chapter I
Introduction
Hotel reservation is a popular method for booking hotel rooms, also helpful for
making last minute travel arrangements. Guests can book rooms on a computer by
using online to protect their privacy and financial information. The hotel may drop the
price of a room if some rooms are still available. The advanced payment as well as the
such as hotel industry to bill their guests for services rendered and the billing report is
utilized by management to know the income generated. Hotel billing system is used to
capture the bill record of guest to come up with a total amount to be paid by the guest.
It is in this light that this study looks at the activities at Bluepool Garden Hotel,
which was built for vacation purposes only last 2013. The hotel contains two swimming
pools, for adults and kids. It also has a comfortable cottage and rooms to stay in. In the
first year of the business, they held already several occasions like birthdays and
The researchers observed that Bluepool Garden is still using the manual process
the reason of easily lost of information. Also in the billing section which gives them
2
hassle in manually counting money and writing the official receipt in a piece of paper,
The researchers saw the need to help the issues of Bluepool Garden, therefore
the researchers proposed a web-based booking and billing system that will improve the
facilitation of their booking and billing system. The advantage of this proposed web-
based booking and billing system is its main feature that infuses QR code technology,
storing guest information that will make it easier to book online and automatically
Project Context
Bluepool Garden was built for vacation purposes only after the earthquake last
2013. The proprietor Maria Paz Bacareza and the financer Edita Amplayo started
planning and building Bluepool Garden last February 20, 2017, in Bood, Maribojoc,
Bohol. As the project was going on, they have both decided to make it as a business
November 30, 2017, was the official opening of the Bluepool Garden. The
proprietor Maria Paz Bacareza manages it. The resort contains two swimming pools, for
adults and kids. It also has a comfortable cottage and rooms to stay in.
The Bluepool Garden celebrated its first anniversary last November 30, 2018. In
the first year of the business, they held already several occasions like birthdays and
weddings and many more. Now, the business grows bigger and bigger as they started
The current way of booking the Bluepool Garden Hotel is the admin just manually
write it to a sheet paper and input it into Microsoft Excel. So, the admin don't forget who
book on that particular day, which gives them hassle access to finding guests, which
leads them to inaccurate information of the guest. However, because of their natural
surroundings and affordable room rates, many travellers and tourists rent some room in
their hotel. And, it takes time for them to manually write the guests information and how
many days the guests will stay, also in the billing section. It will save time for them if the
guests use a web-based hotel booking system that will help them ease the transaction.
4
The result of this study is beneficial to the following person that is involved in the
Management
researchers of the said system that would improve the process flows better than
previously.
Employees
This study would give benefit to the management, who will be using to the newly
computerized technology for booking rooms of the hotel. This system can also secure to
Hotel Guests
This study could lessen the inconvenience to guests when they reserve for a
room. It would be easier and less hassle for them to review what they have filled up in
the booking site. All information that they inputted is stored in the QR code, which they
Researchers
This study will improve their skills and knowledge in advance technology by
building up a system, and become more mindful of the presence and benefits of new
technology.
5
Future Researchers
This study would function a guide within the area of Hotel Management System
Other Businesses
This study would encourage other businesses to upgrade from manual system to
web-based hotel booking and billing system. With this, it will further help business
owners small or big to uncover critical areas of these new-found technology process
rather than manually finding in a piece of paper. The proposed system will generates a
QR code after filling up the web-based booking system and it will be received by the
guest via Gmail. It is often used to be scanned by a webcam to find for the guest
information that is being stored in it. With this, it would work faster and look new to the
other system. Furthermore, the proposed system can contribute to the other studies
Description of Study
The proposed system for the Bluepool Garden hotel is a web-based hotel
booking and billing system, which specialized in the QR code technology. The guest
can book a room online using the web-based system. In the online booking, the guest
will fill up the required personal information. After filling up the information, the guest
can choose what room he/she is going to be reserved. And so that the system will
automatically calculate the bill of their chosen room. After the guest clicks the confirm
button, there will be a notification for the advanced payment for the room they wish to
be reserved. The guest must pay through bank deposit using the admin's bank account
as the receiver of the deposit money. The guest will take a picture with the deposit slip
as a sign of down payment and send it to the admin. After that, the inputted information
will go out to the admin's view in which, the admin will know who is accessing their
online booking. After the admin receives the picture, the admin will confirm the guest
reservation and generates a QR code sent to the guest's Gmail. The QR code will be
used to present by the guest to the hotel as a sign that they have already accessed the
online booking. A QR code is often used of the admin for an accurate finding of guest
information.
The admin controls the check-out section so that if the guest will check-out the
admin can manage the money transaction and can produce an official receipt. The
The main objective of the study is to design and develop a convenient Web-
based Booking and Billing System of Bluepool Garden Hotel. Specifically it aim to:
The scope of the study covers the different processes of the Bluepool Garden
Hotel.
1. Admin’s Privilege
This system has just a single user level the administrator where the administrator
accounts have full access to the system. The administrator can see the whole
guest who is staying and leaving the hotel, additionally the guest status.
2. Website Page
The guests can book online using the web-based system. Also, the system will
produce a QR code after the guest confirmed to his/her booking online. And the
3. Room Availability
8
The system can check the availability of the date together with the room to be
4. Payment Section
This system automatically computes the total bill of the guest in both walk-in and
online booking.
5. Creating Reports
The admin can generate reports of the guest who have been booked for the past
month.
Limitation
The system is exclusively designed for Bluepool Garden Hotel. Though the
system provides an online hotel booking and billing the guests are not allowed to pay
through card and checks. Because the hotel don’t have any bank accounts. The guests
only allowed paying their down payment through the owner’s bank account.
9
Research Methodology
This chapter describes how the researchers will collect the data and information
needed for the study. It defines who the respondents are and what focus of the research
is. This section also illustrates the process of the data gathering and tool used. This
section also presents the type of research, research method, and the research locale
Research Design
The problems of the existing system that Bluepool Garden is utilizing were
identified through conducting an interview. From the identified issues of the existing
system, the researchers will design a web-based booking and billing system that will
allow guests to book online and will accurately calculate the total bill of both online and
walk-in guest. This web-based booking and billing system will be infused with QR code
technology. A QR code works to the system that will be generated after filling up the
web-based booking system and it will be received by the guest via Gmail. This QR code
Research Environment
The study will be conducted at the Bluepool Garden which is located at Bood,
Maribojoc, Bohol.
10
Research Instrument
This study will utilize two (2) instruments: 1. Semi structured interview that will be
asked to the admin and users of Bluepool Garden Hotel; and 2. Programming
languages are used to create the system, this languages included the Laravel, React
Js, Html, Css. Together with its database storage the MySql.
Research Procedure
A letter of endorsement was prepared and sent to Bluepool Garden Hotel to ask
for approval in conducting the study on their establishment. Upon approval, the
researchers visited the hotel and interviewed with the administrator to identify the
current process of booking and billing of the hotel. After the interview, the researchers
started planning and discussing the structure and function of the system for the
Bluepool Garden Hotel. The proposed system is a web-based booking and billing
11
system. It has the scope to book online and can calculate the total bill of the guest on
both web and walk-in booking. It is infused with QR code technology, which is used for
the storage of guest information. The used of QR code gives advantage to the admin to
easily find for the guest information by just simply scan using a web camera.
When the system is deployed, one week is given to test the proposed system.
After the week of deployment was a day of collecting reactions and opinion as what the
CHAPTER II
Sobrevilla et al. (2009), studied an online reservation and billing system for Villa
Silvina Resort. The system will allow guests to browse their information and make a
reservation via the internet to improve their transactions and services. The website
made by the researchers has the features of the resort, and the system can follow every
one of the comforts accessible for the guests. The information additionally incorporates
the area, costs, weddings and capacities, offices and administrations and other
information that the resort can offer. The researchers will also make an easy to
understand the system that is increasingly advantageous for the guests to book
reservations and make transactions as far as expense and time. Similar to the study the
researcher’s systems will not just be favorable to the guest but the company too.
Adap et.al (2013), developed and proposed an online billing and reservation
system for Royal Palm Paradise Resort. The system will serve as a replacement for
their current manual procedure. This sort of system is relied upon to advance the hotel
for more guests and make the resort's system more accommodating for guests. Guest
information is stored in a database to monitor the records of the guest including the
reservations made. The assigned administrator will have access to the entire database
to be able to update or change their records. The proposed system won't just profit the
hotel's guest yet the retreat too, for all of their data, is organized and secured and will
Gamage (2014), developed a reservation system for Gayana Hotel that will give
remedies for the problems that are currently facing by the guest. Shifting to our system
can acquire advantages such as saving of time, man-hours, and space wastage. This
will increase the efficiency in hotel daily activities. The system aimed to build a fully
functional system to achieve efficiency in the hotel billing and reservation system. The
overall mission of system development is to make the hotel staff can quickly and easily
complete the hotel management task. It could save time when retrieving data from the
database. Interfaces will be designed user-friendly and the functions will be displayed
simply.
Bituin (2010), proposed an online reservation system for 658 Apartelle that will
provide fast retrieval of output in about guest information. Furthermore, because of its
features like online chat with the front desk wherein the guests can ask some questions
to the front desk. Hotel room mapping wherein the guests are enabled to take a tour in
the hotel facilities and to check the rooms. Room reservation system wherein the guests
can choose the room wanted and the online payment of fees for the guests. The
proposed system will surely give the not only the experience of touring the hotel but also
giving assurance for the hotel management that those who reserve at the hotel will
surely lounge. It will also have some limitation but it will still be upright to the need of the
because the system uses the internet, a cost-efficient measure for advertisement and
publicity. In conclusion, the proposed project will be a good alternative for the company
in upgrading its manual guest list record system to a computerized online guest list
database system.
14
replacement for the manual billing and reservation system of Adams Beach Resort. The
researcher's developed so that the company may have a systematized type of operation
and transaction, in addition to a trouble-free work for the officers-in-charge. The system
operated entirely online providing the guest with a friendly, simple yet powerful tool for
managing and optimizing throughput. Also, the researcher will develop a proficient and
useful system for Adams Beach Resort. There will be a reservation of packages,
Constante et.al (2011), proposed an online billing and reservation system for
Viewfort Terrace Viewhill Resort. The system has a database for the resort where all of
the company’s transactions are stored and it has added the ability to compute all the
billings of the guests. Having an online system is a cutting edge over other businesses.
So the researchers made a system that benefits the management and the guests. The
system has a user-friendly website that has a database for organizing the transaction
files. The system covers the reservation of rooms, amenities, and bills. With the
development of the system, all the transactions in the resort are stored in a database.
The generation of reports is easier since the system can eliminate the inconsistencies.
By the help of the system, the staff’s workload is lessened, thus making their work more
efficient.
15
Nuevo et.al (2012), developed an online billing and reservation system for La Luz
Beach Resort. The resort is presently accepting reservations through phone calls and
Different concerns were encountered such as; loss of records inability to accommodate
clients more effectively, and difficulty to handle the reservation process. Management
also has difficulty in computing the total bill of all guests. The purpose of this study is to
help management ease the workload and help them use technology. The researchers
used PHP which is a programming tool to make the proposed system possible. The
developed system may accommodate all guests at all times. The computation of bills is
automated and can generate weekly monthly and annual reports. It has back-up and
recovery modules which may be used when the system is down or unintentionally
removed.
(Eugine n.d.), studied and developed an online booking system for ABC Hotel.
Some problems exist in their current system: a. the guest’s details such as Name,
Address, Age and Duration of stay, are input during booking in. b. The documents are
transferred manually to the filing office for the compilation of the guest’s file. This
system will cover booking, accommodation, meals and accounts details. Moreover,
special services such as laundry, ironing, and room service will be automated by the
system also. Not to forget the additional facilities information that will be efficiently
handled by the system. To help the system smoothly carry out its intended purpose to
(Yeon KH. n.d.), studied and developed a web-based reservation for the Tune
Hotel that can generate online reservation of the hotel rooms at ease, reservation
confirmations by email and room availability lookup, summary and stay information grid.
Historic and current records of and revenues payments to the travel agency, source of a
business group, companies, etc. will be in a central database for security. Inquiry on
Chapter III
Technical Background
The Hotel Management System for Bluepool Garden aims to make an online
web-based reservation system and billing information for the guest. Which is more
efficient and uncomplicated by reducing the work wasted on manual labor. Such as
Software engineer Ken Beck first developed the Extreme Programming methodology
during the 1990s. It is one of the agile software development methodologies which is
designed to improve the quality of the software and the ability to adapt depending on the
18
small releases throughout the project, allowing the people involved in the project to check
and review the project’s development throughout the entire work. It follows a set of values
and principles to guide the team’s behavior namely communication, simplicity, feedback,
courage, and respect. It focuses on the continuous involvement of the customer to ensure
1. Planning – a step where the customer points out their desired functionality
he/she would like to see and provide enough detail to help the team (user
hardware requirements and the team creates a release schedule and divides
the project into iterations. The researchers interviewed the security personnel
on how they facilitate the parking lot and what are the requirements to avail a
parking space.
2. Design – this step gives importance to the value of simplicity. To start with a
simple design just enough to code the features and redesigning when required.
3. Coding – is a stage to implement the code, a coding in sets where one is at the
console and different reviews and gives inputs. Codes are supervised by the
technical adviser to make sure that the codes used are for the functionality of
4. Testing – this is the step where the codes, the software, and its functionality are
tested. The researchers would run a throughout the test to see if there is a bug,
error in the functionality and to make sure the software runs smoothly before
releasing. The testing would be done by the researchers and the client to make
sure the codes are working well and to receive comments about the software’s
functionality. In this step, the researcher needs to do hard testing to make sure
that the problems are corrected immediately and take the client’s comment into
account.
5. Release – Module would be shown to the admin staff and head security to
know if they have any comments or suggestions with how the software works.
Each feature would have a different schedule of release to ensure that the
features fit the user's needs and are easy to use. After each release, the
The Hotel Management System for Bluepool Garden will utilize the following
technologies.
make documents on the web. HTML outlines the layout and structure
that offers control over the layout and presentation of web pages by
it, the script gets directed to the browsers and it is up to the web
application.
22
Chapter IV
Analysis
This section covers the complete description of the Hotel Management System
for Bluepool Garden. It includes the specific activities made by the actors and the
system, the capabilities and functions, and their details. Additionally, the researchers
can use this segment as a reference during the development of the proposed online
The researchers make use of the Use Case Diagram and the Use Case
Narrative to illustrate and define the processes taking place and the people involved. Us
case diagrams describe the functionality of a system using actors and use cases. A use
case is a set of actions, services, and functions that the system requires to perform. The
"actors" are the people or entities working under distinct roles. Also, these diagrams and
narratives are significant for illustrating the functional requirements of a system that will
transition into design selections and development choices. They help specific
functionality executes.
23
Table No.2.Login
Step 5 Step 6
The user clicks the The system will delete the
checkout button information of the guest in
the view section.
Step3. Step 4
The user must receive The system will show the
advance payment and view that the guest is
clicks the Check In button. checked in.
Step 3. Step 4.
The user clicks the ‘book now The system will show the
button in the web-based text filled (where the user
system’ inputs the check-in date,
check-out date)
Step 5 Step 6
The user clicks submit button The system will show the
text filled that to be fill up
by the user as their
information(first name, last
name, age, Gmail account,
room type with a button
‘check available rooms'
beside it, number of
children, and a ‘signup to
Gmail' button besides the
Gmail account text filled). If
the user doesn't have any
Gmail account proceed to
step 6.1. Else if the user
will find available room
proceed to step 7. Else if
the user has already
gmailed account proceed
to step 6.
Step 6.1 Step 6.2
The user clicks the ‘signup to The system will
Gmail’ automatically locate to
Gmail sign up
29
Step 8 Step 9
The user clicks ‘submit The system will show the
button’ registered name of the
user together with their
information that they’d filled
up, the system also shows
their total payment. If the
user continues to proceed
to step 10. Else if the user
will cancel proceed to step
6
Step 10 Step 11
The user clicks the ‘submit’ The system generates a
button QR code and automatically
sends to their Gmail.
File Structure
Design
Figure No.3. Relational Database
34
Prototypes
Walk-in
Figure 1.1
This figure shows that the admin enter his/her username and password.
Figure 1.2
This figure shows that the guest going to book a room.
35
Figure 1.3
This figure shows that all the status of the guest will display.
Figure 2.2
This figure shows that the guest can set the date.
37
Figure 2.3
This figure shows that the guest can select room type.
38
Figure 2.4
This figure shows that the guest starts to create the information.
39
Figure 2.5
This figure shows that the guest can see all the details, booking summary and total
charges.
40
Figure 2.6
This figure shows the booking confirmation.
41
References
Almulhem, A., & Almulhem, A. (n.d.). Database Management system for Hotel
http://www.academia.edu/7093181/Database_Management_system_for_Hotel_DBMYS
https://www.academia.edu/36265171/HOTEL_MANAGEMENT_INFORMATION_SYST
EM_TO_IMPROVING_QUALITY_OF_SERVICE_THE_CONCEPT_PROTOTYPING_C
ASE_STUDY_ON_MUSAFIRA_HOTEL_YOGYAKART
Mutuku, A., & Mutuku, A. (n.d.). Page | 1 Baraka Hotel Inventory Management
https://www.academia.edu/9555704/Page_1_Baraka_Hotel_Inventory_Management_S
ystem_BARAKA_HOTEL_INVENTORY_MANAGEMENT_SYSTEM
KH, Y., & KH, Y. (n.d.). Republic of the Philippines Commission on Higher
https://www.academia.edu/14780746/Republic_of_the_Philippines_Commission_on_Hi
gher_Education_Higher_Education_Regional_Office_III_WEB-
BASED_HOTEL_RESERVATION_MANAGEMENT_SYSTEM_FOR_TUNE_HOTEL
42
Olaño, J., & Olaño, J. (n.d.). Bataan Heroes Memorial College WEB-BASED HOTEL
https://www.academia.edu/36746201/Bataan_Heroes_Memorial_College_WEB-
BASED_HOTEL_RESERVATION_SYSTEM_A_Case_Study
S., C. L., P., P. B., & Adap. (1970, January 01). Online billing and reservation
Online Billing and Reservation System ABR JARL. (n.d.). Retrieved from
https://www.scribd.com/doc/162735641/Online-Billing-and-Reservation-System-ABR-
JARL
https://www.coursehero.com/file/p5ljtk0q/8-The-Online-Reservation-with-Billing-System-
for-Puerto-Real-Resort-is-similar/
https://www.academia.edu/2112330/A_SAMPLE_HOTEL_MANAGEMENT_SYSTEM_P
ROJECT_DOCUMENTATION
https://www.projecttopics.org/customer-billing-system-hotel-
industry.html?fbclid=IwAR1N9_aVdknqfkieSBeFUAPeSzkvWdYp23ENZ2CO7tTDrXsU
QJx3PXsrxj0
Bemile, R., & Bemile, R. (n.d.). Online Hotel Reservation System. Retrieved from
https://www.academia.edu/10074981/Online_Hotel_Reservation_System
43
https://www.studymode.com/essays/658-Apartelle-Online-Reservation-System-
375787.html
proposal-document-for-hotel-management-system.
Https://Doi.org/10.3897/BDJ.4.e7720.” doi:10.3897/bdj.4.e7720.figure2f.
https://thesis.dlsud.edu.ph/736/
https://thesis.dlsud.edu.ph/736/
https://thesis.dlsud.edu.ph/791/
https://www.inettutor.com/source-code/hotel-room-reservation-and-billing-
system/?fbclid=IwAR3xR7BBeVjkjaA6LDvr2OvGOO0fZRQoNxKgjomlvlsWFHmeifdI2liyf
_o