Family Mandarin LLC · internal use only
Access is restricted to authorised staff.
Reservation Database
Today
ActionsExcelDataColumns
filters restored
Filter
—
0selected
Deadline zone:
Draft Not in use — this module will be developed in a later update.
Daily Map
A date × hotel grid derived from the reservation table.
Will catch: overlapping reservations on the same night and allotment breaches.
Will catch: the back-to-back rule (Departure = next Arrival).
Will output: unsold nights and materialisation rate per hotel.
Planned for a later update.
Draft This module is not in use yet — figures here are indicative only and must not be relied on for decisions.
Cancellation deadlines · next 14 days
Payment due · next 14 days
Supplier exposure
Project view
Arrivals by month rooms
Status mix
Security note. This sign-in screen manages roles, not security. Anyone who can open the file can read its source.
Real protection must be added on the server — Cloudflare Access or nginx basic auth on hotel.familymandarin.uz.
Users
Hotels
Suppliers
Default settings
Cancellation date = Arrival − days
Payment date = Arrival − days
Warning window (DECIDE zone) days
The first two only pre-fill dates when a new reservation is created; existing reservations are not touched.
The warning window decides when a reservation enters the DECIDE zone.
Data health
Activity log
New Reservation
v1
Version history — click a version to view it
This reservation is Confirmed. Saving any change will set its status to Amended.