Service 4

Magellan Dashboard

The operator-facing Next.js application backed by a FastAPI service. The single pane of glass over the entire HotelMap supply chain — connections, blocked bookings, contract extraction, agent conversations, SOD analytics, dev tools, and a read-only SQL query engine.

Functional areas

Area 1

Supply Chain Overview

Connections, blocked bookings, VIP detection, block alerts. Grouped Event → Hotel → Block hierarchy with caching for expensive joins.

Area 2

Ghost Extractor

Drag-and-drop PDF upload, extraction queue, batch dedup by content hash, flag for review, dismiss, and delete.

Area 3

Agent Control Panel

Sender allowlists, conversation monitoring, polling control, stage visualization, per-conversation action approval.

Area 4

Booking Analytics

SOD bookings, connections, blocked matches with confidence scoring, duplo rate-push statistics.

Area 5

Dev Tools

Test pages for verify-contract, dupload, event-match, blockload, search, manual upload-rates, and book.

Area 6

Analytics & SQL

Read-only SQL query engine against the warehouse — list_tables and run_query with row caps for safety.

UI pattern library

Charts

Canvas-based bar / line / donut, SVG sparklines, small multiples grid. Shared rendering conventions across pages.

Layout

Dashboard composition hierarchy, shared D data object pattern, KPI stat tiles with trend sparklines, scroll-spy navigation, print styles for reports.

Tables

Sortable / filterable tables, status pills, confidence colour coding, interactive tooltips, chart annotation overlays.