← Back to Systems CatalogCommercial Contract / Joebrown Palace Hotel and Suites

Joebrown Palace Hotel & Suites

Enterprise Hospitality Management OS & Guest Booking Webapp (Commissioned by Joebrown Palace Hotel & Suites)

Visit Live System Commission an Enterprise Build

https://joebrownhotel.com

Production

11-Tier Hardened RBAC

Operational Roles

Zero Double-Bookings (Atomic RPC)

Reservation Engine

Interactive 2D Drag & Drop

Floor Plan Canvas

100% Zero-Cost In-App WebSockets

Order Tracking Cost

Executive Architectural Overview

Bespoke enterprise hospitality operating system and guest portal commissioned by Joebrown Palace Hotel & Suites. Unifies atomic room reservations preventing double-bookings (book_room_atomically), Express QR check-in passes, frictionless digital dining with centered order tray modal, zero-cost in-app real-time order tracking via Supabase WebSockets, interactive 2D table floor plan canvas, multi-station Kitchen Display Systems (KDS), and room folio multi-tender billing.

Core Architectural Accomplishments

Architected atomic room reservation engine (book_room_atomically RPC) with strict double-booking prevention, automated rate tiering, and dual-rail settlement (Bachs card/USSD/crypto with instant bank transfer fallback).

Engineered interactive 2D drag-and-drop table floor plan canvas for restaurant & lounge operations with live order routing to dedicated bar and kitchen KDS stations.

Built JB AI Concierge: persistent Gemini Flash assistant with strict role-based tool separation and automated escalation to on-duty front desk staff over Supabase Realtime.

Implemented hardened 11-tier RBAC covering front desk, waiters, bartenders, kitchen chefs, accountants, and ownership with automated shift handover ledgering.

Deterministic Guarantees

Concurrency Model

Atomic room reservation RPC (book_room_atomically), idempotency keys on payment webhooks, zero double-booking guarantee.

AI & Protocol Layer

Gemini Flash AI Concierge with staff handoff, Supabase Realtime WebSocket event broadcast.

Database & Infrastructure

Dedicated Supabase PostgreSQL, edge middleware session guards, Resend transactional receipts.

SUBSYSTEMS • ARCHITECTURAL MODULES

Integrated System Components

MODULE 01

Atomic Room Booking Engine

Guarantees zero double-bookings via custom PL/pgSQL RPCs (book_room_atomically) with room date-range interval locks and instant receipt generation.

MODULE 02

Interactive 2D Table Floor Plan Canvas

Drag-and-drop table management with live visual occupancy states, waiter order taking, and multi-department order routing (bar, kitchen, grill).

MODULE 03

Multi-Station Kitchen Display System (KDS)

Real-time kitchen, bar, and grill display screens with acoustic order chimes, ticket timers, item preparation checkboxes, and bump bar functionality.

MODULE 04

JB AI Voice & Chat Concierge

Gemini Flash assistant equipped with strict RBAC tool boundaries to handle room requests, order inquiries, and automatic front desk handover.

MODULE 05

11-Tier Hardened RBAC & Shift Ledger

Granular roles for owners, managers, accountants, chefs, bartenders, and receptionists with structured shift handover notes and offline night mode toggles.

PRODUCTION STACK • VERIFIED

Technology Architecture Matrix

Frontend & Runtime

Next.js 16 (React 19)
Tailwind CSS
HTML5 Canvas (2D Drag & Drop)
Lucide Icons
Audio API Alerts

DB & Concurrency

Dedicated Supabase PostgreSQL
Supabase Realtime WebSockets
Atomic book_room_atomically RPC
Idempotent Transaction Ledger
Dynamic Role-to-Station Routing

AI & Realtime

JB AI Concierge (Gemini Flash)
Role-Gated Tool Separation
Instant KDS Ticket Dispatch
Shift Handover Ledger (staff_notes)
Realtime Front-Desk Escalation

Payments & Protocols

Bachs Gateway (Card, USSD, Crypto)
Automated Bank Transfer Verification
Receipt Screenshot Proof Uploads
Resend Transactional Mail
Room Folio Direct Billing

Previous Case Study

GEBO

Commission an Enterprise Platform

Next Case Study

DreamwiseHUB