Hotel Reservation System
Manage Reservation System of
multiple hotels.
SUMMARY
Reservation
System is used to manage reservations of multiple hotels. Reservation System
helps to manage hotel reservations dynamically. Admin creates hotel and add
various settings and features for each hotel.
TECHNOLOGIES
1. Eclipse 3.2 for development, debugging.
2. Tomcat 5.0 as the web server.
3. MySQL 4.1 as the database.
4. Java Tiger for compilation and to run Tomcat server.
5. SVN version control for versioning and code delivery.
6. Struts as the Web application framework.
7. Velocity templates
for the front end presentation.
PROJECTS IMPLEMENTATION DETAILS
This project supports multi language functionality. A user
can switch between languages. Switching is done at the time of login page using
link in red circle.
Figure 1
Figure 2
We can switch between languages English and Japanese using
this link in the login page. The remaining pages in the admin section will
display according to this locale we switch at the time of login.
Figure 3 (English
Locale)
Figure 4 (Japanese
Locale)
For a hotel the admin can setup following settings for each
Hotel:
a.
Plans
b.
Rooms
c.
Features
d.
Child Rates
e.
Room Rates
f.
Hotel Settings
g.
Day rates using
calendars
A. Create Hotels:
The hotel admin can create a hotel using the following
page:
Figure 5
On
click of ‘Add a New Hotel’ following page will display:
Figure 6
Add
Rooms:
Following page is used to add room for a hotel. We can
specify various features for each room like Maximum Number of People for a
room, Number of Rooms, room description, picture link etc.
Figure 7
Create
Plans:
For each hotel we can add multiple plans. For each plan we
can specify some features. Each plan will in turn contain several rooms. We can
set the room rates for each plan.
Figure 8
We Add/Update/Delete plan using this page. On click of
‘Update’ link in the above Figure following page will be shown:
Figure 9
We can add features, child
rates, rate calendar etc. using this page.
Calendars:
A hotel can manipulate its room
rates using following two calendars – Rate calendar and Percent calendar.
Figure 10
For a rate calendar we can select rate for each day like
below:
Figure 11
Percent calendar is used to discount the rate of a particular
day. We can manipulate the rate of a day can be changed using this calendar.
Figure 12
We can set the discount rates by
checking the date on which these discounts need to apply and input value in
‘Input Your Rate’ text box. Now on click of ‘SET’ button these rates will be
set.
Rate Types:
We can add rates which are
listed in under the ‘Select Your Rate’ in Figure 11 using the following page.
Figure 13
We can control room rates of
various rooms under each plan using these rates. On click of ‘PlanRateList’ in
Figure 8 following page will display. Using this page a user can set the rates
for each room.
Figure 14
User can set the rates by clicking ‘Add/Update’ link. A page
like below will be displayed. We can specify the rate for a specified number of
people.
Figure 15
Features:
We can give various ‘Features’ for a hotel which they want to
provide for their customers. Following is the page which will do
‘Add/Update/Read’.
Figure 16
On click of Add a Feature/Update
link following form will display. We can give name, description, and price;
specify whether this is for an entire order or for an individual person etc.
Figure 17
The option ‘individual’ and
‘entire’ is used to specify whether this is applicable for a whole order i.e.,
this feature will be charged for an entire order or an individual person i.e.,
the price will be added to each individual who stay in the hotel.
Child rates:
The child rate link in the main
menu is used to create various rates applicable for children.
Figure 18
The child rate form will be as
follows where we can specify various rates for a child:
Figure 19
We can give either an absolute
value for child rate or as percentage of adult’s rate. This also help to set
whether we need to calculate room rate as an adult or a separate adult bed is
required for a child or not etc.
Reservation Pages:
Following is the front end
screen for a hotel where the customer reserves the room. This will list all the
plans available for a hotel together with the description.
Figure 20
On click of ‘Reservation
Calendar’ in the above figure a list of rooms for which user set the rates will
display
Figure 21
On click of Check Room
Availability button a calendar with the following rates will display. In this
page each day is a link and customers can select a date for which they need a
reservation.
Figure 22
Figure 23
Customers can select number of
days for which they need stay and number of adults and children. They can also
choose various features which are offered by the hotel.
Now on click of Evaluation
button the Reservation cost details will be display for the customer.
Figure 24
Now they can fill up the form
which is provided in the bottom of the page to do their reservation.
Figure 25
After this a confirmation page
will be displayed with all the details of the customer. After confirming this
reservation a mail will be send to hotel’s authorized person and to the
customer.
Customers can cancel their
reservation if they want, using ‘Check/cancel a reservation’ in Figure 21. On
click of this link following form will display where the customer enters email
id and reservation number which the hotel assigned while confirming the order.
Figure 26
On click of confirm button customer’s order details will
display like below:
Figure 27
On click of confirm button their
order will be cancelled and a mail will be send to the hotel.
Reports:
Hotel can generate different
kinds of reports. Following are the reports generated for the reservation
system.
Plan Report: This will generate
a report for a year with the total amount of sales per months for each plan. On
click of ‘Report’ link in the main menu, two drop down boxes for ‘year’ and
‘report name’ will display. User can select appropriate report and submit it.
Figure 28
Room Report: This will generate
a report for a year with the total amount of sales per months for each room.
Figure 29
Order Report: This will generate a report based on the order.
Figure 30
Customer Report: Customer Report
link in the main menu is used to get the top 10 customers based on the number
of orders they have placed.
Figure 31
There are two at a glance pages which will give a report at a
glance.
- Room
Glance 2. Plan Glance
Room Glance:
Figure 32
This page will give details for
each day. We can lock the rooms - which implies that no more orders can be
place fro this room- by clicking ‘OK’ on each cell. On click of ‘OK’ link this
will be changed to ‘FULL’ (In red circle). We can switch between this by
clicking ‘OK’ and ‘FULL’. A user can lock all the rooms for a particular day by
clicking the ‘OK’ link on the top section (In green circle). We can see how
many rooms available and how many orders placed for a room on particular day
with this calendar. In the red circle left side cell will give the total number
of rooms available for a particular day. We can update this by clicking this. A
form like Figure 33 will display to update available room for a day. In the red
circle right side cell will give total number of orders for a room on that day.
On click of this link we will get the customer and order details of that day
for that room (In Figure 34).
Figure 33
The above form is used to update available room for a day.
Figure 33
A user can set the available rooms for a particular room for
two weeks by
clicking the ‘Set’ link on the right side in Figure 32. A form like below will display for the user
to set the room.
Figure 34
A user can also set available
rooms for all the rooms for a particular day. This can be done in by clicking
the ‘Set’ link on the bottom of the page in Figure 32.
Following form is used for this.
Figure 35
Plan Glance:
Figure 36
Plan Glace will show the
discount for a day. We can update the rate of these discounts by clicking the
week link (e.g. Sat) in on the top. On click of this following page will
display to update the rates.
Figure 37
On click of ‘Orders’ link in the
main menu we will get a list of orders like below:
Figure 38
We can export this file into CSV
file by clicking ‘Start Export’ button. We can ‘Delete’ or ‘Cancel’ an order
using corresponding links. On click of ‘Show Details’ the order details will
show up like below:
Figure 39
The ‘Member’ link in the main
menu is used to add/update/delete customers. Following is the page used for
this:
Figure 40