@extends('layouts.app')

@section('title', 'Hub de Integrações')
@section('topbar_title', '⚡ Hub de Integrações & APIs')

@section('styles')
    <style>
        .hub-grid {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(340px, 1fr));
            gap: 20px;
            margin-bottom: 28px;
        }

        .hub-card {
            background: var(--surface, #ffffff);
            border: 1px solid var(--surface-border, #e2e8f0);
            border-radius: var(--radius-lg, 14px);
            padding: 24px;
            position: relative;
            box-shadow: var(--shadow-sm, 0 1px 2px rgba(0,0,0,0.05));
            transition: all 0.25s ease;
            display: flex;
            flex-direction: column;
            justify-content: space-between;
        }

        .hub-card:hover {
            box-shadow: var(--shadow-md, 0 4px 6px -1px rgba(0,0,0,0.07));
            border-color: rgba(220, 38, 38, 0.3);
        }

        .hub-card-header {
            display: flex;
            align-items: center;
            justify-content: space-between;
            margin-bottom: 16px;
        }

        .hub-card-brand {
            display: flex;
            align-items: center;
            gap: 14px;
        }

        .hub-icon-wrapper {
            width: 48px;
            height: 48px;
            border-radius: 12px;
            display: flex;
            align-items: center;
            justify-content: center;
            font-weight: 800;
            font-size: 20px;
            color: #ffffff;
        }

        .hub-icon-uber {
            background: #000000;
            border: 1px solid #333333;
        }

        .hub-icon-onfly {
            background: linear-gradient(135deg, #0047FF, #002699);
            box-shadow: 0 4px 12px rgba(0, 71, 255, 0.28);
        }

        .hub-tab-btn {
            background: transparent;
            border: none;
            padding: 10px 18px;
            font-size: 13px;
            font-weight: 600;
            color: var(--text-muted, #64748b);
            cursor: pointer;
            border-bottom: 2px solid transparent;
            transition: all 0.2s ease;
            display: inline-flex;
            align-items: center;
            gap: 6px;
        }

        .hub-tab-btn.active {
            color: var(--brand-crimson, #c8102e);
            border-bottom-color: var(--brand-crimson, #c8102e);
        }

        .hub-icon-99 {
            background: linear-gradient(135deg, #f59e0b, #d97706);
        }

        .hub-icon-gupy {
            background: linear-gradient(135deg, #3b82f6, #1d4ed8);
        }

        .hub-card-title {
            font-size: 16px;
            font-weight: 700;
            color: var(--text-main, #0f172a);
            margin-bottom: 2px;
        }

        .hub-card-subtitle {
            font-size: 12px;
            color: var(--text-muted, #64748b);
        }

        .hub-badge {
            display: inline-flex;
            align-items: center;
            gap: 6px;
            padding: 4px 10px;
            border-radius: 9999px;
            font-size: 11px;
            font-weight: 600;
            text-transform: uppercase;
            letter-spacing: 0.04em;
        }

        .hub-badge-active {
            background: #f0fdf4;
            color: #16a34a;
            border: 1px solid #bbf7d0;
        }

        .hub-badge-inactive {
            background: #fef2f2;
            color: #dc2626;
            border: 1px solid #fecaca;
        }

        .hub-badge-soon {
            background: #f8fafc;
            color: #64748b;
            border: 1px solid #e2e8f0;
        }

        .hub-metrics-row {
            display: grid;
            grid-template-columns: repeat(auto-fit, minmax(200px, 1fr));
            gap: 16px;
            margin-bottom: 24px;
        }

        .metric-card {
            background: var(--surface, #ffffff);
            border: 1px solid var(--surface-border, #e2e8f0);
            border-radius: var(--radius-md, 10px);
            padding: 16px 20px;
            box-shadow: var(--shadow-sm);
        }

        .metric-card-label {
            font-size: 12px;
            font-weight: 600;
            color: var(--text-muted, #64748b);
            text-transform: uppercase;
            letter-spacing: 0.04em;
            margin-bottom: 6px;
        }

        .metric-card-value {
            font-size: 24px;
            font-weight: 800;
            color: var(--text-main, #0f172a);
        }

        .metric-card-sub {
            font-size: 11px;
            color: var(--text-subtle, #94a3b8);
            margin-top: 4px;
        }

        .hub-form-group {
            margin-bottom: 14px;
        }

        .hub-form-label {
            display: block;
            font-size: 12px;
            font-weight: 600;
            color: var(--text-body, #1e293b);
            margin-bottom: 6px;
        }

        .hub-form-input {
            width: 100%;
            padding: 9px 12px;
            border-radius: var(--radius-sm, 6px);
            border: 1px solid var(--surface-border, #e2e8f0);
            background: var(--bg-ink, #f8fafc);
            color: var(--text-main, #0f172a);
            font-size: 13px;
            font-family: inherit;
            transition: all 0.2s ease;
        }

        .hub-form-input:focus {
            outline: none;
            border-color: var(--brand-crimson, #c8102e);
            box-shadow: 0 0 0 3px rgba(200, 16, 46, 0.12);
            background: var(--surface, #ffffff);
        }

        .hub-actions-bar {
            display: flex;
            align-items: center;
            gap: 10px;
            margin-top: 18px;
            flex-wrap: wrap;
        }

        .hub-btn {
            display: inline-flex;
            align-items: center;
            justify-content: center;
            gap: 6px;
            padding: 9px 16px;
            border-radius: var(--radius-sm, 6px);
            font-size: 13px;
            font-weight: 600;
            cursor: pointer;
            transition: all 0.2s ease;
            text-decoration: none;
            border: 1px solid transparent;
        }

        .hub-btn-primary {
            background: var(--brand-crimson, #c8102e);
            color: #ffffff;
        }

        .hub-btn-primary:hover {
            background: #b91c1c;
            box-shadow: 0 4px 12px rgba(200, 16, 46, 0.25);
        }

        .hub-btn-secondary {
            background: var(--surface, #ffffff);
            border-color: var(--surface-border, #e2e8f0);
            color: var(--text-body, #1e293b);
        }

        .hub-btn-secondary:hover {
            background: var(--bg-ink, #f8fafc);
            border-color: var(--text-muted, #64748b);
        }

        .hub-btn-outline {
            background: transparent;
            border-color: var(--brand-crimson, #c8102e);
            color: var(--brand-crimson, #c8102e);
        }

        .hub-btn-outline:hover {
            background: var(--accent-red-soft, #fef2f2);
        }

        .hub-toggle {
            display: flex;
            align-items: center;
            gap: 8px;
            font-size: 13px;
            font-weight: 600;
            cursor: pointer;
            user-select: none;
        }

        .hub-table-wrapper {
            background: var(--surface, #ffffff);
            border: 1px solid var(--surface-border, #e2e8f0);
            border-radius: var(--radius-lg, 14px);
            padding: 20px;
            box-shadow: var(--shadow-sm);
        }

        .hub-table-header {
            display: flex;
            align-items: center;
            justify-content: space-between;
            margin-bottom: 16px;
            flex-wrap: wrap;
            gap: 12px;
        }

        .hub-table {
            width: 100%;
            border-collapse: collapse;
            font-size: 13px;
        }

        .hub-table th {
            text-align: left;
            padding: 10px 12px;
            border-bottom: 2px solid var(--surface-border, #e2e8f0);
            color: var(--text-muted, #64748b);
            font-weight: 600;
            font-size: 12px;
            text-transform: uppercase;
            letter-spacing: 0.03em;
        }

        .hub-table td {
            padding: 12px;
            border-bottom: 1px solid var(--surface-border-subtle, #f1f5f9);
            color: var(--text-body, #1e293b);
        }

        .hub-table tr:hover td {
            background: var(--bg-ink, #f8fafc);
        }

        .alert-banner {
            padding: 12px 16px;
            border-radius: var(--radius-sm, 6px);
            margin-bottom: 20px;
            font-size: 13px;
            display: flex;
            align-items: center;
            gap: 10px;
        }

        .alert-success {
            background: #f0fdf4;
            border: 1px solid #bbf7d0;
            color: #15803d;
        }

        .alert-danger {
            background: #fef2f2;
            border: 1px solid #fecaca;
            color: #991b1b;
        }

        .status-dot {
            width: 8px;
            height: 8px;
            border-radius: 50%;
            display: inline-block;
    </style>
@endsection

@section('content')

            {{-- Flash Messages --}}
            @if (session('success'))
                <div class="alert-banner alert-success">
                    <span>✅</span>
                    <div>{{ session('success') }}</div>
                </div>
            @endif

            @if (session('error') || $errors->any())
                <div class="alert-banner alert-danger">
                    <span>⚠️</span>
                    <div>
                        @if (session('error'))
                            <div>{{ session('error') }}</div>
                        @endif
                        @foreach ($errors->all() as $error)
                            <div>{{ $error }}</div>
                        @endforeach
                    </div>
                </div>
            @endif

            {{-- Metric Cards --}}
            <div class="hub-metrics-row" style="grid-template-columns: repeat(auto-fit, minmax(220px, 1fr));">
                <div class="metric-card">
                    <div class="metric-card-label">Viagens Urbanas (Uber)</div>
                    <div class="metric-card-value" style="display: flex; align-items: baseline; gap: 8px;">
                        <span>{{ number_format($totalTrips, 0, ',', '.') }}</span>
                        <span style="font-size: 13px; font-weight: normal; color: var(--text-muted);">R$ {{ number_format($totalSpent, 2, ',', '.') }}</span>
                    </div>
                    <div class="metric-card-sub">Base de transporte para o Superset</div>
                </div>

                <div class="metric-card">
                    <div class="metric-card-label">Viagens & Despesas (Onfly)</div>
                    <div class="metric-card-value" style="display: flex; align-items: baseline; gap: 8px; color: #0047FF;">
                        <span>{{ number_format($totalOnflyExpenses, 0, ',', '.') }}</span>
                        <span style="font-size: 13px; font-weight: normal; color: var(--text-muted);">R$ {{ number_format($totalOnflySpent, 2, ',', '.') }}</span>
                    </div>
                    <div class="metric-card-sub">Aéreo, hotéis e reembolsos</div>
                </div>

                <div class="metric-card">
                    <div class="metric-card-label">Total Acumulado de Despesas</div>
                    <div class="metric-card-value" style="color: #15803d;">
                        R$ {{ number_format($totalSpent + $totalOnflySpent, 2, ',', '.') }}
                    </div>
                    <div class="metric-card-sub">Transporte + Aéreo + Hotéis + Diárias</div>
                </div>

                <div class="metric-card">
                    <div class="metric-card-label">Conectores Ativos</div>
                    <div class="metric-card-value" style="font-size: 15px; display: flex; flex-direction: column; gap: 4px; margin-top: 4px;">
                        <div style="display: flex; align-items: center; gap: 6px;">
                            <span class="status-dot" style="background: {{ ($uberSetting && $uberSetting->is_active) ? '#16a34a' : '#94a3b8' }};"></span>
                            <span style="font-size: 13px; font-weight: 600;">Uber: {{ ($uberSetting && $uberSetting->is_active) ? 'Ativo' : 'Inativo' }}</span>
                        </div>
                        <div style="display: flex; align-items: center; gap: 6px;">
                            <span class="status-dot" style="background: {{ ($onflySetting && $onflySetting->is_active) || $totalOnflyExpenses > 0 ? '#0047FF' : '#94a3b8' }};"></span>
                            <span style="font-size: 13px; font-weight: 600;">Onfly: {{ ($onflySetting && $onflySetting->is_active) ? 'Ativo' : ($totalOnflyExpenses > 0 ? 'Relatórios OK' : 'Não Configurado') }}</span>
                        </div>
                    </div>
                    <div class="metric-card-sub">Sincronização integrada ao Superset</div>
                </div>
            </div>

            {{-- Integration Cards Grid --}}
            <div class="hub-grid">

                {{-- CARD UBER --}}
                <div class="hub-card" style="border-top: 3px solid #000000;">
                    <div>
                        <div class="hub-card-header">
                            <div class="hub-card-brand">
                                <div class="hub-icon-wrapper hub-icon-uber">
                                    UB
                                </div>
                                <div>
                                    <div class="hub-card-title">Uber for Business</div>
                                    <div class="hub-card-subtitle">Viagens Corporativas & Recibos</div>
                                </div>
                            </div>
                            <div>
                                @if ($uberSetting && $uberSetting->is_active)
                                    <span class="hub-badge hub-badge-active">● Ativo</span>
                                @else
                                    <span class="hub-badge hub-badge-inactive">● Inativo</span>
                                @endif
                            </div>
                        </div>

                        <p style="font-size: 13px; color: var(--text-muted); line-height: 1.5; margin-bottom: 14px;">
                            Integração direta via OAuth 2.0 (Client Credentials - Receipts API). As viagens corporativas são sincronizadas diariamente e alimentam o banco de dados consumido pelo Apache Superset.
                        </p>

                        {{-- Status Visual do Token OAuth --}}
                        @if ($uberSetting?->getCredential('token_expires_at'))
                            @php
                                $expiresAt = \Carbon\Carbon::parse($uberSetting->getCredential('token_expires_at'));
                                $isValid = $expiresAt->isFuture();
                                $currentEnv = $uberSetting->getCredential('environment', 'production');
                                $envName = ($currentEnv === 'sandbox') ? 'Sandbox (Testes)' : 'Produção';
                            @endphp
                            <div style="margin-bottom: 16px; padding: 10px 14px; border-radius: 8px; font-size: 12px; display: flex; align-items: center; gap: 10px; background: {{ $isValid ? '#f0fdf4' : '#fef2f2' }}; border: 1px solid {{ $isValid ? '#bbf7d0' : '#fecaca' }}; color: {{ $isValid ? '#15803d' : '#b91c1c' }};">
                                <span style="font-size: 16px;">{{ $isValid ? '🔒' : '⚠️' }}</span>
                                <div>
                                    <strong style="font-size: 13px;">{{ $isValid ? 'Token Ativo e Autenticado' : 'Token Expirado' }}</strong>
                                    <div style="font-size: 11px; margin-top: 2px; opacity: 0.9;">
                                        {{ $isValid ? 'Válido até ' . $expiresAt->format('d/m/Y H:i') : 'Expirou em ' . $expiresAt->format('d/m/Y H:i') }}
                                        — Ambiente: <strong>{{ $envName }}</strong>
                                    </div>
                                </div>
                            </div>
                        @endif

                        <form method="POST" action="{{ route('integracoes.uber.update') }}">
                            @csrf

                            {{-- Seletor de Ambiente --}}
                            <div class="hub-form-group">
                                <label class="hub-form-label" for="environment">Ambiente da Uber API</label>
                                <select id="environment" name="environment" class="hub-form-input" style="cursor: pointer;">
                                    <option value="production" {{ old('environment', $uberSetting?->getCredential('environment', 'production')) === 'production' ? 'selected' : '' }}>
                                        🟢 Produção (auth.uber.com — Dados reais da empresa)
                                    </option>
                                    <option value="sandbox" {{ old('environment', $uberSetting?->getCredential('environment')) === 'sandbox' ? 'selected' : '' }}>
                                        🟡 Sandbox / Testes (sandbox-login.uber.com — Ambiente de simulação)
                                    </option>
                                </select>
                                <span style="font-size: 11px; color: var(--text-muted); display: block; margin-top: 4px;">
                                    Configure de acordo com o tipo da sua aplicação no <a href="https://developer.uber.com/dashboard" target="_blank" style="color: var(--brand-crimson); text-decoration: underline;">Uber Developer Dashboard</a>.
                                </span>
                            </div>

                            <div class="hub-form-group">
                                <label class="hub-form-label" for="client_id">Client ID (API Key)</label>
                                <input type="text" id="client_id" name="client_id" class="hub-form-input" required 
                                       value="{{ old('client_id', $uberSetting?->getCredential('client_id')) }}" 
                                       placeholder="ex: MlS2tHT8AuIAXbGJniGX1yuhVcKJioXJ">
                            </div>

                            <div class="hub-form-group">
                                <label class="hub-form-label" for="client_secret">
                                    Client Secret
                                    @if ($uberSetting?->getCredential('client_secret'))
                                        <span style="color: #16a34a; font-weight: normal; font-size: 11px;">(Criptografado no banco)</span>
                                    @endif
                                </label>
                                <input type="password" id="client_secret" name="client_secret" class="hub-form-input"
                                       placeholder="{{ $uberSetting?->getCredential('client_secret') ? '••••••••••••••••••••••••' : 'Insira o secret da Uber' }}">
                            </div>

                            <div class="hub-form-group">
                                <label class="hub-form-label" for="scope" style="display: flex; justify-content: space-between; align-items: center; margin-bottom: 6px;">
                                    <span>Escopos de Acesso (Scope)</span>
                                    <span style="font-size: 11px; font-weight: normal; color: var(--text-muted);">Clique para marcar ou digite livremente</span>
                                </label>

                                {{-- Seletores rápidos (Chips selecionáveis) --}}
                                @php
                                    $savedScope = (string) old('scope', $uberSetting?->getCredential('scope', 'business.receipts'));
                                    $selectedScopes = preg_split('/\s+/', trim($savedScope));
                                @endphp
                                <div style="display: flex; flex-wrap: wrap; gap: 8px; margin-bottom: 8px;">
                                    <label style="display: inline-flex; align-items: center; gap: 6px; padding: 6px 12px; border-radius: 6px; border: 1px solid #cbd5e1; background: #ffffff; cursor: pointer; font-size: 12px; user-select: none;">
                                        <input type="checkbox" class="scope-checkbox" value="business.receipts" {{ in_array('business.receipts', $selectedScopes) ? 'checked' : '' }} onchange="syncScopes()">
                                        <span>📄 <strong>business.receipts</strong> <span style="color: #64748b;">(Recibos/Faturas)</span></span>
                                    </label>

                                    <label style="display: inline-flex; align-items: center; gap: 6px; padding: 6px 12px; border-radius: 6px; border: 1px solid #cbd5e1; background: #ffffff; cursor: pointer; font-size: 12px; user-select: none;">
                                        <input type="checkbox" class="scope-checkbox" value="business.trips" {{ in_array('business.trips', $selectedScopes) ? 'checked' : '' }} onchange="syncScopes()">
                                        <span>🚗 <strong>business.trips</strong> <span style="color: #64748b;">(Viagens)</span></span>
                                    </label>

                                    <label style="display: inline-flex; align-items: center; gap: 6px; padding: 6px 12px; border-radius: 6px; border: 1px solid #cbd5e1; background: #ffffff; cursor: pointer; font-size: 12px; user-select: none;">
                                        <input type="checkbox" class="scope-checkbox" value="business.organizations" {{ in_array('business.organizations', $selectedScopes) ? 'checked' : '' }} onchange="syncScopes()">
                                        <span>🏢 <strong>business.organizations</strong> <span style="color: #64748b;">(Organização)</span></span>
                                    </label>

                                    <label style="display: inline-flex; align-items: center; gap: 6px; padding: 6px 12px; border-radius: 6px; border: 1px solid #cbd5e1; background: #ffffff; cursor: pointer; font-size: 12px; user-select: none;">
                                        <input type="checkbox" class="scope-checkbox" value="business.users" {{ in_array('business.users', $selectedScopes) ? 'checked' : '' }} onchange="syncScopes()">
                                        <span>👥 <strong>business.users</strong> <span style="color: #64748b;">(Usuários)</span></span>
                                    </label>
                                </div>

                                {{-- Campo de texto livre e editável --}}
                                <input type="text" id="scope" name="scope" class="hub-form-input" 
                                       value="{{ old('scope', $uberSetting?->getCredential('scope', 'business.receipts')) }}"
                                       oninput="syncCheckboxesFromInput()"
                                       placeholder="ex: business.receipts business.trips">
                                <span style="font-size: 11px; color: var(--text-muted); display: block; margin-top: 4px;">
                                    Marque as caixas acima para selecionar ou edite/digite diretamente os escopos desejados (separados por espaço).
                                </span>
                            </div>

                            <div class="hub-form-group">
                                <label class="hub-form-label" for="organization_id">
                                    ID da Organização Uber for Business (UUID Opcional)
                                </label>
                                <input type="text" id="organization_id" name="organization_id" class="hub-form-input"
                                       value="{{ old('organization_id', $uberSetting?->getCredential('organization_id')) }}"
                                       placeholder="ex: 123e4567-e89b-12d3-a456-426614174000">
                                <span style="font-size: 11px; color: var(--text-muted); display: block; margin-top: 4px;">
                                    Enviado no header <code>x-uber-organizationuuid</code> caso seja requerido pela sua conta corporativa.
                                </span>
                            </div>

                            <div class="hub-form-group" style="margin-top: 16px;">
                                <label class="hub-toggle">
                                    <input type="checkbox" name="is_active" value="1" {{ old('is_active', $uberSetting?->is_active) ? 'checked' : '' }}>
                                    <span>Habilitar sincronização automática diária (03:00)</span>
                                </label>
                            </div>

                            <div class="hub-actions-bar">
                                <button type="submit" class="hub-btn hub-btn-primary">
                                    💾 Salvar Configurações
                                </button>
                        </form>

                        {{-- Botão de Testar Conexão --}}
                        <form method="POST" action="{{ route('integracoes.uber.test') }}" style="display: inline;">
                            @csrf
                            <button type="submit" class="hub-btn hub-btn-secondary" title="Testa a autenticação OAuth com a API">
                                🔌 Testar Conexão
                            </button>
                        </form>

                        {{-- Botão de Sincronizar Manualmente --}}
                        <form method="POST" action="{{ route('integracoes.uber.sync') }}" style="display: inline;">
                            @csrf
                            <button type="submit" class="hub-btn hub-btn-outline" title="Disparar sincronização de viagens agora">
                                ⚡ Sincronizar Agora
                            </button>
                        </form>
                            </div>
                    </div>
                </div>

                {{-- CARD ONFLY (VIAGENS, AÉREO, HOTÉIS & DESPESAS) --}}
                <div class="hub-card" style="border-top: 3px solid #0047FF;">
                    <div>
                        <div class="hub-card-header">
                            <div class="hub-card-brand">
                                <div class="hub-icon-wrapper hub-icon-onfly">
                                    FLY
                                </div>
                                <div>
                                    <div class="hub-card-title">Onfly Viagens & Despesas</div>
                                    <div class="hub-card-subtitle">Passagens Aéreas, Hotéis & Reembolsos</div>
                                </div>
                            </div>
                            <div>
                                @if ($onflySetting && $onflySetting->is_active)
                                    <span class="hub-badge hub-badge-active">● Ativo</span>
                                @elseif ($totalOnflyExpenses > 0)
                                    <span class="hub-badge" style="background: #eff6ff; color: #1d4ed8; border: 1px solid #bfdbfe;">● {{ $totalOnflyExpenses }} Despesas</span>
                                @else
                                    <span class="hub-badge" style="background: #f8fafc; color: #64748b; border: 1px solid #e2e8f0;">● Disponível</span>
                                @endif
                            </div>
                        </div>

                        <p style="font-size: 13px; color: var(--text-muted); line-height: 1.5; margin-bottom: 16px;">
                            Conexão direta com a plataforma Onfly. Permite automatizar o fluxo de despesas corporativas, passagens aéreas, reservas de hotéis e prestação de contas no Apache Superset.
                        </p>

                        {{-- SEÇÃO DE IMPORTAÇÃO DE RELATÓRIO CSV ONFLY --}}
                        <div style="background: #eff6ff; border: 1px dashed #bfdbfe; border-radius: 8px; padding: 14px 16px; margin-bottom: 18px;">
                            <div style="display: flex; align-items: center; justify-content: space-between; margin-bottom: 8px;">
                                <strong style="font-size: 13px; color: #1e40af; display: flex; align-items: center; gap: 6px;">
                                    <span>📑</span> Importar Relatório Onfly (CSV)
                                </strong>
                                <span style="font-size: 11px; color: #1d4ed8; background: #dbeafe; padding: 2px 8px; border-radius: 4px; font-weight: 600;">
                                    Rápido & Direto
                                </span>
                            </div>
                            <p style="font-size: 12px; color: #1e3a8a; margin-bottom: 12px; line-height: 1.4;">
                                Exporte a planilha de despesas ou viagens no painel da Onfly (CSV) e envie abaixo para consolidação automática e idempotente.
                            </p>

                            <form method="POST" action="{{ route('integracoes.onfly.import_csv') }}" enctype="multipart/form-data" style="display: flex; gap: 10px; align-items: center; flex-wrap: wrap;">
                                @csrf
                                <input type="file" name="csv_file" accept=".csv,.txt" required class="hub-form-input" style="padding: 6px 10px; font-size: 12px; background: #ffffff; flex: 1; min-width: 200px;">
                                <button type="submit" class="hub-btn" style="background: #0047FF; color: #ffffff; border: none; font-size: 12px; padding: 8px 14px; white-space: nowrap;">
                                    📤 Importar CSV
                                </button>
                            </form>
                        </div>

                        {{-- FORMULÁRIO DE CONFIGURAÇÃO DA API ONFLY --}}
                        <form method="POST" action="{{ route('integracoes.onfly.update') }}">
                            @csrf
                            <div class="hub-form-group">
                                <label class="hub-form-label" for="onfly_api_key">
                                    API Key / Bearer Token Onfly
                                    @if ($onflySetting?->getCredential('api_key'))
                                        <span style="color: #16a34a; font-weight: normal; font-size: 11px;">(Criptografado no banco)</span>
                                    @endif
                                </label>
                                <input type="password" id="onfly_api_key" name="api_key" class="hub-form-input"
                                       placeholder="{{ $onflySetting?->getCredential('api_key') ? '••••••••••••••••••••••••' : 'Insira a chave da API Onfly' }}">
                                <span style="font-size: 11px; color: var(--text-muted); display: block; margin-top: 4px;">
                                    Obtenha a chave de integração no menu de Configurações / Integrações da sua conta Onfly.
                                </span>
                            </div>

                            <div class="hub-form-group">
                                <label class="hub-form-label" for="onfly_api_endpoint">Endpoint Base da API</label>
                                <input type="text" id="onfly_api_endpoint" name="api_endpoint" class="hub-form-input"
                                       value="{{ old('api_endpoint', $onflySetting?->getCredential('api_endpoint', 'https://api.onfly.com.br/v2')) }}"
                                       placeholder="https://api.onfly.com.br/v2">
                            </div>

                            <div class="hub-form-group" style="margin-top: 14px;">
                                <label class="hub-toggle">
                                    <input type="checkbox" name="is_active" value="1" {{ old('is_active', $onflySetting?->is_active) ? 'checked' : '' }}>
                                    <span>Habilitar sincronização automática diária (03:00)</span>
                                </label>
                            </div>

                            <div class="hub-actions-bar">
                                <button type="submit" class="hub-btn hub-btn-primary" style="background: #0047FF;">
                                    💾 Salvar Configurações
                                </button>
                        </form>

                        {{-- Botão de Testar Conexão Onfly --}}
                        <form method="POST" action="{{ route('integracoes.onfly.test') }}" style="display: inline;">
                            @csrf
                            <button type="submit" class="hub-btn hub-btn-secondary" title="Testa a autenticação com a API da Onfly">
                                🔌 Testar Conexão
                            </button>
                        </form>

                        {{-- Botão de Sincronizar Manualmente Onfly --}}
                        <form method="POST" action="{{ route('integracoes.onfly.sync') }}" style="display: inline;">
                            @csrf
                            <button type="submit" class="hub-btn hub-btn-outline" title="Sincronizar despesas da Onfly agora">
                                ⚡ Sincronizar Agora
                            </button>
                        </form>
                            </div>
                    </div>
                </div>

                {{-- CARD 99 EMPRESAS (EXPANSÃO) --}}
                <div class="hub-card" style="opacity: 0.85; border-top: 3px solid #f59e0b;">
                    <div>
                        <div class="hub-card-header">
                            <div class="hub-card-brand">
                                <div class="hub-icon-wrapper hub-icon-99">
                                    99
                                </div>
                                <div>
                                    <div class="hub-card-title">99 Empresas</div>
                                    <div class="hub-card-subtitle">Gestão de Frotas & Corridas</div>
                                </div>
                            </div>
                            <span class="hub-badge hub-badge-soon">Em Breve</span>
                        </div>

                        <p style="font-size: 13px; color: var(--text-muted); line-height: 1.5; margin-bottom: 18px;">
                            Conector preparado para expansão multi-provedores no Hub. Permitirá consolidar despesas de transporte urbano de todos os aplicativos em um único data mart.
                        </p>

                        <div class="hub-form-group">
                            <label class="hub-form-label">API Key / Token 99</label>
                            <input type="text" class="hub-form-input" disabled placeholder="Disponível na próxima versão">
                        </div>
                    </div>

                    <div style="font-size: 12px; color: var(--text-subtle); padding-top: 14px; border-top: 1px dashed var(--surface-border);">
                        Status: Módulo estruturado no catálogo de integrações.
                    </div>
                </div>

                {{-- CARD GUPY (EXPANSÃO) --}}
                <div class="hub-card" style="opacity: 0.85; border-top: 3px solid #3b82f6;">
                    <div>
                        <div class="hub-card-header">
                            <div class="hub-card-brand">
                                <div class="hub-icon-wrapper hub-icon-gupy">
                                    GP
                                </div>
                                <div>
                                    <div class="hub-card-title">Gupy Admissão / ATS</div>
                                    <div class="hub-card-subtitle">Gestão de Colaboradores & RH</div>
                                </div>
                            </div>
                            <span class="hub-badge hub-badge-soon">Em Breve</span>
                        </div>

                        <p style="font-size: 13px; color: var(--text-muted); line-height: 1.5; margin-bottom: 18px;">
                            Sincronização automática de dados cadastrais de colaboradores para enriquecer os centros de custo e rateio das corridas no Superset.
                        </p>

                        <div class="hub-form-group">
                            <label class="hub-form-label">Gupy Secret Token</label>
                            <input type="text" class="hub-form-input" disabled placeholder="Disponível na próxima versão">
                        </div>
                    </div>

                    <div style="font-size: 12px; color: var(--text-subtle); padding-top: 14px; border-top: 1px dashed var(--surface-border);">
                        Status: Módulo estruturado no catálogo de integrações.
                    </div>
                </div>

            </div>

            {{-- Preview Tables for Superset --}}
            <div class="hub-table-wrapper">
                <div class="hub-table-header" style="flex-wrap: wrap; gap: 12px;">
                    <div>
                        <div style="display: flex; gap: 8px; border-bottom: 1px solid var(--surface-border, #e2e8f0); margin-bottom: 8px;">
                            <button type="button" class="hub-tab-btn active" id="tab-btn-uber" onclick="switchTable('uber')">
                                🚗 Viagens Uber (<code>uber_trips</code>)
                                <span style="background: #f1f5f9; color: #475569; font-size: 11px; padding: 2px 6px; border-radius: 9999px;">{{ $totalTrips }}</span>
                            </button>
                            <button type="button" class="hub-tab-btn" id="tab-btn-onfly" onclick="switchTable('onfly')">
                                ✈️ Viagens & Despesas Onfly (<code>onfly_expenses</code>)
                                <span style="background: #eff6ff; color: #0047FF; font-size: 11px; padding: 2px 6px; border-radius: 9999px;">{{ $totalOnflyExpenses }}</span>
                            </button>
                        </div>
                        <div style="font-size: 12px; color: var(--text-muted);">
                            Estes dados alimentam diretamente os painéis de auditoria e despesas corporativas no Apache Superset.
                        </div>
                    </div>
                    <div>
                        <span class="erp-tag" style="background: #f0fdf4; color: #16a34a; border: 1px solid #bbf7d0;">
                            ● Destino Superset Online
                        </span>
                    </div>
                </div>

                {{-- TABELA UBER --}}
                <div id="table-uber-view">
                    @if ($recentTrips->isNotEmpty())
                        <div style="overflow-x: auto;">
                            <table class="hub-table">
                                <thead>
                                    <tr>
                                        <th>Trip ID</th>
                                        <th>Colaborador</th>
                                        <th>E-mail</th>
                                        <th>Embarque (Data/Hora)</th>
                                        <th>Origem</th>
                                        <th>Destino</th>
                                        <th>Valor (R$)</th>
                                        <th>Status</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($recentTrips as $trip)
                                        <tr>
                                            <td style="font-family: 'JetBrains Mono', monospace; font-size: 12px; font-weight: 600;">
                                                {{ Str::limit($trip->trip_id, 14) }}
                                            </td>
                                            <td style="font-weight: 600;">{{ $trip->employee_name ?? '—' }}</td>
                                            <td style="color: var(--text-muted); font-size: 12px;">{{ $trip->employee_email ?? '—' }}</td>
                                            <td>{{ $trip->pickup_time ? $trip->pickup_time->format('d/m/Y H:i') : '—' }}</td>
                                            <td style="font-size: 12px;" title="{{ $trip->pickup_address }}">
                                                {{ Str::limit($trip->pickup_address, 30) ?? '—' }}
                                            </td>
                                            <td style="font-size: 12px;" title="{{ $trip->dropoff_address }}">
                                                {{ Str::limit($trip->dropoff_address, 30) ?? '—' }}
                                            </td>
                                            <td style="font-weight: 700; color: #15803d;">
                                                R$ {{ number_format((float) $trip->total_amount, 2, ',', '.') }}
                                            </td>
                                            <td>
                                                <span style="padding: 2px 8px; border-radius: 4px; font-size: 11px; font-weight: 600; background: #f1f5f9; color: #475569;">
                                                    {{ ucfirst($trip->status ?? 'Concluída') }}
                                                </span>
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div style="text-align: center; padding: 36px 20px; color: var(--text-muted); font-size: 14px;">
                            <div style="font-size: 28px; margin-bottom: 8px;">🚗</div>
                            <strong>Nenhuma viagem da Uber sincronizada ainda.</strong><br>
                            Configure as credenciais acima e clique em <em>"Sincronizar Agora"</em> ou aguarde a execução agendada das 03:00.
                        </div>
                    @endif
                </div>

                {{-- TABELA ONFLY --}}
                <div id="table-onfly-view" style="display: none;">
                    @if ($recentOnflyExpenses->isNotEmpty())
                        <div style="overflow-x: auto;">
                            <table class="hub-table">
                                <thead>
                                    <tr>
                                        <th>ID Despesa</th>
                                        <th>Colaborador</th>
                                        <th>E-mail</th>
                                        <th>Centro de Custo</th>
                                        <th>Categoria</th>
                                        <th>Data</th>
                                        <th>Valor Total (R$)</th>
                                        <th>Status</th>
                                        <th>Comprovante</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @foreach ($recentOnflyExpenses as $exp)
                                        <tr>
                                            <td style="font-family: 'JetBrains Mono', monospace; font-size: 12px; font-weight: 600; color: #0047FF;">
                                                {{ Str::limit($exp->expense_id, 14) }}
                                            </td>
                                            <td style="font-weight: 600;">{{ $exp->employee_name ?? '—' }}</td>
                                            <td style="color: var(--text-muted); font-size: 12px;">{{ $exp->employee_email ?? '—' }}</td>
                                            <td style="font-size: 12px; font-weight: 500;">{{ $exp->cost_center ?? 'Geral' }}</td>
                                            <td>
                                                <span style="padding: 2px 8px; border-radius: 4px; font-size: 11px; font-weight: 600; background: #f0f9ff; color: #0284c7; border: 1px solid #bae6fd;">
                                                    {{ $exp->category ?? 'Despesa' }}
                                                </span>
                                            </td>
                                            <td>{{ $exp->expense_date ? $exp->expense_date->format('d/m/Y') : '—' }}</td>
                                            <td style="font-weight: 700; color: #15803d;">
                                                R$ {{ number_format((float) $exp->total_amount, 2, ',', '.') }}
                                            </td>
                                            <td>
                                                <span style="padding: 2px 8px; border-radius: 4px; font-size: 11px; font-weight: 600; background: {{ $exp->status === 'rejected' ? '#fef2f2' : ($exp->status === 'paid' ? '#ecfdf5' : '#eff6ff') }}; color: {{ $exp->status === 'rejected' ? '#dc2626' : ($exp->status === 'paid' ? '#059669' : '#2563eb') }};">
                                                    {{ ucfirst($exp->status ?? 'Aprovada') }}
                                                </span>
                                            </td>
                                            <td style="text-align: center;">
                                                @if ($exp->receipt_url)
                                                    <a href="{{ $exp->receipt_url }}" target="_blank" style="color: #0047FF; font-size: 12px; text-decoration: underline;">
                                                        📎 Ver Recibo
                                                    </a>
                                                @else
                                                    <span style="color: var(--text-subtle); font-size: 11px;">—</span>
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>
                    @else
                        <div style="text-align: center; padding: 36px 20px; color: var(--text-muted); font-size: 14px;">
                            <div style="font-size: 28px; margin-bottom: 8px;">✈️</div>
                            <strong>Nenhuma despesa da Onfly registrada ainda.</strong><br>
                            Configure a API Key ou importe um arquivo CSV no card <em>"Onfly Viagens & Despesas"</em> acima para visualizar os dados aqui.
                        </div>
                    @endif
                </div>
            </div>
@endsection

@section('scripts')
<script>
    function syncScopes() {
        const checkboxes = document.querySelectorAll('.scope-checkbox');
        const input = document.getElementById('scope');
        if (!input) return;

        // Escopos padrão rastreados pelos checkboxes
        const standardScopes = Array.from(checkboxes).map(cb => cb.value);

        // Escopos personalizados que o usuário porventura digitou no input
        const currentTyped = input.value.trim().split(/\s+/).filter(s => s && !standardScopes.includes(s));

        // Escopos marcados nos checkboxes
        const checkedScopes = Array.from(checkboxes).filter(cb => cb.checked).map(cb => cb.value);

        // Combina marcados + personalizados
        const merged = [...checkedScopes, ...currentTyped];
        input.value = merged.join(' ');
    }

    function syncCheckboxesFromInput() {
        const input = document.getElementById('scope');
        if (!input) return;

        const typedScopes = input.value.trim().split(/\s+/);
        const checkboxes = document.querySelectorAll('.scope-checkbox');

        checkboxes.forEach(cb => {
            cb.checked = typedScopes.includes(cb.value);
        });
    }

    function switchTable(provider) {
        const uberView = document.getElementById('table-uber-view');
        const onflyView = document.getElementById('table-onfly-view');
        const tabUber = document.getElementById('tab-btn-uber');
        const tabOnfly = document.getElementById('tab-btn-onfly');

        if (provider === 'onfly') {
            if (uberView) uberView.style.display = 'none';
            if (onflyView) onflyView.style.display = 'block';
            if (tabUber) tabUber.classList.remove('active');
            if (tabOnfly) tabOnfly.classList.add('active');
        } else {
            if (uberView) uberView.style.display = 'block';
            if (onflyView) onflyView.style.display = 'none';
            if (tabUber) tabUber.classList.add('active');
            if (tabOnfly) tabOnfly.classList.remove('active');
        }
    }
</script>
@endsection