Find Jobs
Hire Freelancers

Build a reservation system for small hotel

$3-10 NZD / hour

Stengt
Lagt ut over 5 år siden

$3-10 NZD / hour

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.
Prosjekt-ID: 18162278

Om prosjektet

6 forslag
Eksternt prosjekt
Aktiv 5 år siden

Ønsker du å tjene penger?

Fordeler med budgivning på Freelancer

Angi budsjettet og tidsrammen
Få betalt for arbeidet ditt
Skisser forslaget ditt
Det er gratis å registrere seg og by på jobber
6 freelancers are bidding on average $12 NZD/time for this job
Brukeravatar
hello sir i can prepare the demo in 1 day. I have working booking hotel projects before. thanks
$8 NZD om 40 dager
5,0 (3 omtaler)
2,0
2,0

Om klienten

INDIAs flagg
faridabad, India
5,0
35
Medlem siden mar. 9, 2017

Klientbekreftelse

Takk! Vi har sendt deg en lenke for at du skal kunne kreve din gratis kreditt.
Noe gikk galt. Vær så snill, prøv på nytt.
Registrerte brukere Publiserte jobber
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Forhåndsvisning innlasting
Tillatelse gitt for geolokalisering.
Påloggingsøkten din er utløpt og du har blitt logget ut. Logg på igjen.