Rooms
Front desk
3
In house
13
Vacant
16
Rooms
Nothing has been charged to this stay yet.
Take it off the board
A cancellation needs the folio at zero — a deposit still sitting on it is money the property owes back. A no-show keeps the folio open, because a retention charge is the whole point of recording one.
Arriving · 2
Booked, due today or overdue. A booking still sitting here at midnight is a no-show, which phase 4 will say so about on its own.
-
Rohan Desai
D5F6JM · Room V1 · 2+2 · 2026-08-11 → 2026-08-14
-
Meera Dsouza
G2H7PQ · Room 101 · 1+0 · 2026-08-11 → 2026-08-13
Departing · 2
In house and due out today. What each owes is read from the folio, not stored — so a dinner charged five minutes ago is already in it.
Take a booking
Only vacant rooms that have been cleaned are offered. The overlap check runs again inside the transaction with the room locked, because a list drawn a minute ago is not a promise.
Pick a room, or leave it on "any room of the type" and sell the category — which is how hotels sell, and the only way an overbooked allotment has somewhere to live until somebody assigns a room. Leave the rate blank to take the rate plan's price, resolved for each night separately: a week that crosses a season boundary is not one number. Whatever is agreed is snapshotted onto the stay and never looked up again.
Every room
Two states, kept apart: whether it can be sold, and whether it has been cleaned. A room can be occupied and clean, or vacant and dirty, and one column would have to invent an order between them.
Room V1
Beach Villa · Beach
Vacant · ₹28,000.00
Room V2
Beach Villa · Beach
Vacant · ₹28,000.00
Room V3
Beach Villa · Beach
Vacant · ₹28,000.00
Room 203
Sea View · First
Vacant · ₹9,500.00
Room 204
Sea View · First
Vacant · ₹9,500.00
Room 205
Sea View · First
Vacant · ₹9,500.00
Room 206
Sea View · First
Vacant · ₹9,500.00
Room 101
Deluxe · Ground
Vacant · ₹6,500.00
Room 102
Deluxe · Ground
Vacant · ₹6,500.00
Room 103
Deluxe · Ground
Vacant · ₹6,500.00
Room 104
Deluxe · Ground
Vacant · ₹6,500.00
Room 302
Suite · Second
Vacant · ₹16,500.00
Room 303
Suite · Second
Vacant · ₹16,500.00
Room types · 4
The rate belongs to the type. Phase 3 puts plans and seasons above it; until then this is what a stay is priced from.
| Code | Name | Rate | Sleeps | Rooms |
|---|---|---|---|---|
| DLX | Deluxe | ₹6,500.00 | 3 | 4 |
| SEA | Sea View | ₹9,500.00 | 3 | 6 |
| SUITE | Suite | ₹16,500.00 | 4 | 3 |
| VILLA | Beach Villa | ₹28,000.00 | 5 | 3 |
Add a room
Two rooms numbered 214 in one property is an argument at the desk the database can simply prevent, so it does.