LogiSync Enterprise — Sistema de Gestión de Cadena de Suministro & Logística Europea (ERP) con Patrón Transactional Outbox

graph TD
    subgraph ClientLayer ["Capa de Cliente (React 19 + TypeScript + Tailwind CSS v4)"]
        UI[Industrial Dashboard & Logistics Shell] --> Nav[Navegación Modular: Resumen / Rutas / Inventario / Picking / Outbox]
        Nav --> MapComp[Leaflet Map: Tiles ESRI Dark Gray Canvas + Pines Micro-Cápsula + HUD de Flota]
        Nav --> PickTerminal[Terminal Industrial de Picking: Emulador Láser EAN-13 + Bin Routing]
        Nav --> OutboxViewer[Inspector de Eventos Outbox: Payload JSON, Trace ID, Latencia y Reintento]
        Nav --> InvMatrix[Matriz de Inventario Multialmacén: Filtros de Reorden y Modales de Stock]
        UI --> ClientAPI[Dual-Mode API Client con Fallback Automático]
        ClientAPI -.->|GitHub Pages / Offline Standalone| MockEngine[Motor Reactivo en Memoria: 3 Hubs, 1.428 Envíos, 25k Eventos]
        ClientAPI -->|Producción / REST TLS| SpringBootAPI
    end

    subgraph BackendLayer ["Capa Backend (Spring Boot 3.3.3 & Java 21 LTS)"]
        SpringBootAPI[Spring MVC REST Controllers] --> TransManager[Spring Transaction Manager: ACID Transactions]
        TransManager --> InvService[Inventory Service: Asignación y Bloqueo Atómico]
        TransManager --> ShipService[Shipment Service: Despacho y Telemetría]
        TransManager --> PickService[Picking Service: Verificación de Bins y Cierre de Lotes]
        
        InvService --> OutboxRepo[(PostgreSQL 17: outbox_events)]
        ShipService --> OutboxRepo
        PickService --> OutboxRepo

        OutboxPublisher[OutboxPublisherScheduler: @Scheduled Poll & Batch Dispatch] -->|Polling SELECT FOR UPDATE| OutboxRepo
        OutboxPublisher -->|AMQP 0-9-1 Topic Exchange| RabbitMQBroker[RabbitMQ 3.13 Broker]
    end

    subgraph MessagingLayer ["Infraestructura de Mensajería & Event Streams"]
        RabbitMQBroker --> OrdersQ[Queue: supplychain.orders]
        RabbitMQBroker --> InvAllocQ[Queue: supplychain.inventory.allocated]
        RabbitMQBroker --> DispatchQ[Queue: supplychain.events.dispatch]
        RabbitMQBroker --> DLQ[Dead Letter Exchange: supplychain.dlx]
    end

erDiagram
    WAREHOUSES ||--o{ INVENTORY_ITEMS : "almacena"
    WAREHOUSES ||--o{ SHIPMENTS : "origen_de"
    WAREHOUSES ||--o{ PICKING_BATCHES : "ejecuta"
    PRODUCTS ||--o{ INVENTORY_ITEMS : "define_sku"
    PICKING_BATCHES ||--o{ PICKING_ITEMS : "contiene"
    INVENTORY_ITEMS ||--o{ PICKING_ITEMS : "reserva"

    WAREHOUSES {
        uuid id PK
        varchar code UK "Código W-ROT-01"
        varchar name "Nombre Almacén"
        numeric latitude "Latitud WGS-84"
        numeric longitude "Longitud WGS-84"
        varchar country "País sede"
        varchar address "Dirección logística"
        integer capacity_sqm "Superficie m²"
        boolean is_active "Estado operativo"
        timestamp created_at
    }

    PRODUCTS {
        uuid id PK
        varchar sku UK "Identificador SKU"
        varchar barcode UK "Código EAN-13"
        varchar name "Denominación técnica"
        varchar category "Categoría industrial"
        numeric unit_cost "Costo unitario EUR"
        varchar unit_of_measure "Unidad (PCS, KG)"
        integer min_threshold "Umbral mínimo"
        integer lead_time_days "Tiempo de reposición"
        timestamp created_at
    }

    INVENTORY_ITEMS {
        uuid id PK
        uuid warehouse_id FK
        uuid product_id FK
        integer quantity_on_hand "Stock físico"
        integer quantity_reserved "Stock reservado"
        integer quantity_available "Stock disponible"
        varchar location_aisle "Pasillo"
        varchar location_rack "Estantería"
        varchar location_shelf "Nivel / Cubeta"
        varchar batch_number "Lote de fabricación"
        date expiration_date "Fecha caducidad"
        enum reorder_status "OK | LOW | CRITICAL"
        timestamp created_at
    }

    SHIPMENTS {
        uuid id PK
        varchar tracking_number UK "TRK-XXXXX"
        uuid origin_warehouse_id FK
        varchar destination_city "Ciudad destino"
        varchar destination_country "País destino"
        varchar carrier "Transportista"
        enum status "PENDING | IN_TRANSIT | DELIVERED"
        enum transport_mode "ROAD_FREIGHT | MARITIME | AIR_CARGO | RAIL"
        numeric current_latitude
        numeric current_longitude
        integer progress_percent
        timestamp dispatched_at
        timestamp estimated_arrival
        timestamp delivered_at
    }

    PICKING_BATCHES {
        uuid id PK
        varchar batch_code UK "PK-XXXX"
        uuid warehouse_id FK
        varchar customer_name "Cliente corporativo"
        enum priority "STANDARD | HIGH | URGENT"
        enum status "PENDING | IN_PROGRESS | PACKED | DISPATCHED"
        integer total_items
        integer picked_items
        numeric progress_percent
        numeric total_weight_kg
        numeric total_volume_m3
        timestamp created_at
    }

    PICKING_ITEMS {
        uuid id PK
        uuid batch_id FK
        uuid inventory_item_id FK
        integer required_quantity
        integer picked_quantity
        boolean is_scanned
        enum status "PENDING | IN_PROGRESS | COMPLETED"
    }

    OUTBOX_EVENTS {
        uuid id PK
        varchar aggregate_type "Tipo agregado (Order, Inventory)"
        varchar aggregate_id "ID del agregado"
        varchar event_type "Tipo de evento de dominio"
        varchar routing_key "Clave de enrutamiento AMQP"
        text payload "Cuerpo JSON del evento"
        enum status "PENDING | PUBLISHED | FAILED"
        integer retry_count "Reintentos fallidos"
        text error_memo "Mensaje de excepción AMQP"
        varchar trace_id "Identificador OpenTelemetry"
        varchar span_id "Identificador de Span"
        integer delivery_latency_ms "Latencia en ms"
        timestamp created_at
        timestamp published_at
    }