Build a reservation system for small hotel
$2-8 USD/小时
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.
项目ID: #18135141
关于项目
授予:
Hello, Hope you are doing well. I can help with you in your project Build a reservation system for small hotel. I can assure you the quality job. I have good experience in AJAX, HTML, Javascript, MySQL, PHP. W 更多
有17名威客正在参与此工作的竞标,均价$9/小时
hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you with my extensive skills.
Dear Sir, Is that possiable ig you come online on freelancer chat so we can discus more about your project positively. Waiting for your reply Thanks & Regards, Sharma
Dear Client. Greetings!! I minutely reviewed your requirement and understand that you are looking for an experienced expert Web Developer to built a Hotel Reservation system for your business. This project related on 更多
Dear Sir. I have read your description. I can do your 8 problems for your reservation site I am a web developer who is specialized in Web Design ,P H P,MEAN,React and so on.I’m applying for your project spec offer f 更多
Hello, I am a professional web developer with over 5 years of experience. My Skills include: 1- HTML 2- CSS 3- PHP 4- Javascript 5- WordPress 6- Code Igniter I have gone through your requirements, please se 更多
Hello Sir We are a team of expert developers , working on core PHP , codeigniter , laravel and wordpress. Will be able to make this reservation system for you. Would like to get more details on this. Thanks
We are a group of programmers from India who have been working with web Technologies for more than 2 years. We can provide you an optimized and cost effective solution. We are looking forward to working on your project 更多