Manage hotelUs

Highest spenders

Enter number of spenders

Get All Properties

Select Property

Enter Name

Highest rated properties

Amenities that result in the highest property rating

Highest earning properties

Assign a guest to a reservation

Enter reservation id Enter phone number Enter first name Enter last name Enter date of birth

Most frequent reviewers

Get All Dates

Create Dates in Range

Enter start Date Enter End Date

Edit Holiday

Enter Date Enter Holiday Value

Create Date For Room Type

Enter Start Date Enter End Date Enter Room Type Enter Rate Enter Property Name

Get Room Between Dates

Enter Start Date Enter End Date Enter Property Name

Update Room Date

Enter Property Name Enter Room Number Enter Date Enter Rate

Add a new guest

Enter first name Enter last name Enter phone number Enter date of birth

Update an existing guest

Existing first name Existing last name Existing phone number Existing date of birth New first name New last name New phone number New date of birth

Find all guests

Get Guests For Reservation

Enter Reservation ID

Delete A Guest

Enter first name Enter last name Enter phone number Enter date of birth

{{ "Property Name: " + r.property_name}}

{{ "Phone Number: " + r.phone_number}}

{{ "Street Address: " + r.street_address}}

{{ "Unit Number: " + r.unit_number}}

{{ "Country: " + r.country}}

{{ "Postal Code: " + r.postal_code}}

{{ "User email: " + r.user_email }}

{{ "Total spend: " + r.total_spend }}

{{ "Property name: " + r.property_name }}

{{ "Average rating: " + r.avg_rating }}

{{ "Property name: " + r.property_name }}

{{ "Check In: " + r.check_in }}

{{ "Check Out: " + r.check_out }}

{{ "Reservation ID: " + r.reservation_id }}

{{ "Total Price: " + r.total_price }}

{{ "Email: " + r.user_email}}

{{ "Amenity name: " + r.amenity_name }}

{{ "Average rating: " + r.avg_rating }}

{{ "Property name: " + r.property_name }}

{{ "Earnings: " + r.max_value }}

{{ "User email: " + r.user_email }}

{{ "Average rating: " + r.avg_rating }}

{{ "Number of reviews: " + r.num_of_reviews }}

{{ "First name: " + r.first_name }}

{{ "Last name: " + r.last_name }}

{{ "Phone number: " + r.phone_number }}

{{ "Date of birth: " + r.dob.substring(0, 10) }}

{{ "Date: " + r.date.substring(0, 10) }}

{{ "Is Holiday: " + r.isHoliday}}

{{ "Property name: " + r.property_name }}

{{ "Date: " + r.date.substring(0, 10) }}

{{ "Rate: " + r.rate }}

{{ "Reservation ID: " + r.reservation_id }}

{{ "Room Number: " + r.room_num }}

{{ "First name: " + r.first_name }}

{{ "Last name: " + r.last_name }}

{{ "Phone number: " + r.phone_number }}

{{ "Date of birth: " + r.dob.substring(0, 10) }}