Hospitality engine

Area locks touching a date

get/api/locks

Every lock overlapping one UTC calendar day, whatever tier it names. A lock running 22:00 into tomorrow's 02:00 is returned for both days; a host looking at either one needs to see it.

The overlap test is the same half-open comparison the allocator applies to instants and the public booking routes apply in SQL, so this screen and the booking page can never disagree about whether a lock covers a day.

Authorization

sessionCookie
sb-qxrvgfkjyvbngipqvslu-auth-token<token>

The dashboard's Supabase Auth session cookie, set at sign-in. Large sessions are split across numbered chunks (…auth-token.0, .1), so treat this as a cookie family rather than one name.

Every request re-validates it against the Auth server (getUser()), never by decoding the cookie locally: a JWT nothing has checked is not a credential. Tenancy is then read from the verified app_metadata.company_id claim and enforced by row-level security; it is never read from request input, on any route, ever.

role (admin / staff) is deliberately not in RLS. It gates specific actions in route code, the operations marked admin below, so hiding a button in the UI is cosmetic only, and a route's own check is the enforcement.

In: cookie

Query Parameters

date*string

UTC calendar date, YYYY-MM-DD.

Match^\d{4}-\d{2}-\d{2}$

Response Body

application/json

application/json

application/json

application/json

curl -X GET "https://example.com/api/locks?date=string"
{  "locks": [    {      "id": "497f6eca-6276-4993-bfeb-53cbbbba6f08",      "levelId": "a70368c7-b12e-43a9-9830-ab2485710b95",      "areaId": "ebbb2a49-d827-4796-8d8a-108c229835e9",      "tableId": "073fbfcb-cd05-4203-be18-a1ce6f8e4d2d",      "startsAt": "2019-08-24T14:15:22Z",      "endsAt": "2019-08-24T14:15:22Z",      "reason": "string"    }  ]}