Rooms
Front desk
3
In house
13
Vacant
16
Rooms
| When | From | What | Amount | |
|---|---|---|---|---|
| 2026-08-11 04:12 | room | Room, 1 night | ₹16,500.00 | |
| 2026-08-11 16:12 | room service | Room service, breakfast | ₹1,850.00 |
A line is never edited or deleted. A mistake is reversed by a second line with the opposite sign pointing at the first, so both stay visible and the sum stays honest without anybody having to trust it.
Take it off the board
They are in the room. Somebody who has arrived is checked out, not cancelled.
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.