Encerrado

Build a reservation system for small hotel

Embed or create new reservation page for the website [login to view URL] all description, logos and pictures are already there. The goal is to eliminate duplicate reservations by updating the website room availability from and url in ics format. programing in php mysql jquery. Here is the table structure in the following steps:

1). create a mysql database with the following structure:

TABLE1: PROPERTY

property_id

property_name

property_type_id

TABLE2: ROOMS

room_id

property_id

room_name

type_id

TABLE3 GUESTS

guest_id

guest_first_name

guest_last_name

guest_email

guest_phone

TABLE4 RESERVATIONS

reservation_id

reservation_creation_date_time

property_id

room_id

receptionist_id

checkin_date

checkout_date

total_cost

TABLE5: RESERVATION_EXPENSES

expenses_id

reservation_id

total_cost_of_reservation

electricity_cost

maid_cost

grocery_cost

airport_transportation_cost

other_costs

TABLE7: OFICES

office_id

receptionist_name

receptionist_phone

receptionist_email

TABLE8: USERS

user_id

user_name

receptionist_id

user_type_id

2). Create a php script to pull and convert reserved dates from url in ics format and add it to the reservations table to set the unavailable dates for all individual rooms.

3). Create general availability calendar

On the website a screen shows an availability calendar on a long format from first to day to last day of the month on a single row of all the rooms in the database. Each cell contains information of the reservation for that day. Also shows its corresponding date of the month by small number Each cell contains a href to click to make a reservation if the dates are available.

4). Create a room availability calendar

create a small compact 1 month calendar with <PREV and NEXT> buttons to embed into a room description and details or reservations form of the corresponding room or property, every cell contains an href to a reservation form taking checkin_date y checkout_date to populate reservations table.

5). Create an ics formatted file to export single reservations made locally

6). Create a csv formatted file to export all reservations made locally.

7). create forms to insert and modify: users, receptionists, room types, Guests, reservations tables.

8). Create report of all the reservations, that shows room, guest name, checkin date, check out date, cost, who made it.

website name Meztli Apartments

[login to view URL]

Is my first time hiring a programer. Please let me know if you need other info.

Habilidades: AJAX, HTML, Javascript, MySQL, PHP

Veja mais: reservation systems hotel websites xml, build reservation system course project, seat reservation software hotel, hotel reservation systems, hotel reservation system wikipedia, best hotel booking engine, online hotel booking system, free hotel reservation system, best hotel management software, hotel reservation system software, hotel reservation software free, reservation eazy hotel booking system, build booking system hotel php mysql, reservation form hotel script, joomla build reservation system, build reservation system, reservation form hotel html, mysql reservation rooms hotel database, build reservation site, example reservation form hotel

Acerca do Empregador:
( 35 comentários ) faridabad, India

ID do Projeto: #18162278

6 freelancers estão ofertando em média $12/hora para esse trabalho

lavizsolutions

Hi,    All details are there, can we have a chat session to finalize the requirements. 1. Case Management system. [login to view URL] you can create activity, can view on calen Mais

$16 NZD / hora
(24 Comentários)
6.8
$10 NZD / hora
(231 Comentários)
6.5
jayprakashyadav

I can start Immediately..!! Hello, Greetings..!! I am an experienced full stack developer working with joomla , Word press, Shopify, big commerce, prestashop, volusion,wix and for over 9 years now. I have k Mais

$8 NZD / hora
(17 Comentários)
5.5
adamendvy

hello sir i can prepare the demo in 1 day. I have working booking hotel projects before. thanks

$8 NZD / hora
(3 Comentários)
2.0
cyberline

HI, We already have a built apartment/villa reservation system which is used for multiple properties. We can demo the same to you. Kindly download the screenshots of the admin interface from http://adminovation2018. Mais

$22 NZD / hora
(1 Comentário)
1.0
$8 NZD / hora
(1 Comentário)
0.0