@extends('layouts.app')

@section('title', 'Notas sem Contas a Pagar')
@section('topbar_title', '🚨 Auditoria: Notas sem Contas a Pagar')

@section('topbar_extra_actions')
    <a href="{{ route('visoes.exportar.auditoria-csv', ['filial' => $filialFiltro]) }}" class="btn-primary-action">
        <span>📥</span> Exportar CSV ({{ $filialFiltro === 'todas' ? 'Todas as Filiais' : 'Empresa ' . $filialFiltro }})
    </a>
@endsection

@section('styles')
<style>
    .filiais-filter-bar {
        display: flex;
        gap: 6px;
        align-items: center;
        flex-wrap: wrap;
        margin-bottom: 22px;
        padding: 6px;
        background: var(--bg-card);
        border: 1px solid var(--border-color);
        border-radius: 12px;
        width: fit-content;
    }
    .filial-pill {
        display: inline-flex;
        align-items: center;
        gap: 8px;
        padding: 7px 14px;
        border-radius: 8px;
        font-size: 0.84rem;
        font-weight: 600;
        text-decoration: none;
        color: var(--text-muted);
        transition: all 0.2s ease;
    }
    .filial-pill:hover {
        background: rgba(255, 255, 255, 0.05);
        color: var(--text-main);
    }
    .filial-pill.active {
        background: var(--brand-primary);
        color: #ffffff;
        box-shadow: 0 2px 8px rgba(0, 0, 0, 0.2);
    }
    .filial-count-badge {
        font-size: 0.72rem;
        padding: 2px 7px;
        border-radius: 999px;
        background: rgba(255, 255, 255, 0.12);
        color: var(--text-muted);
        font-weight: 700;
    }
    .filial-pill.active .filial-count-badge {
        background: rgba(255, 255, 255, 0.25);
        color: #ffffff;
    }

    .kpi-grid {
        display: grid;
        grid-template-columns: repeat(auto-fit, minmax(240px, 1fr));
        gap: 18px;
        margin-bottom: 28px;
    }

    .kpi-card {
        background: var(--bg-card);
        border: 1px solid var(--border-color);
        border-radius: 14px;
        padding: 22px;
        display: flex;
        flex-direction: column;
        gap: 8px;
        box-shadow: var(--shadow-card);
        transition: transform 0.2s, border-color 0.2s;
    }
    .kpi-card:hover {
        transform: translateY(-2px);
        border-color: var(--accent-blue);
    }

    .kpi-card-title {
        font-size: 0.8rem;
        color: var(--text-muted);
        font-weight: 700;
        text-transform: uppercase;
        letter-spacing: 0.05em;
    }

    .kpi-card-val {
        font-size: 1.75rem;
        font-weight: 800;
        color: var(--text-main);
        font-feature-settings: "tnum";
    }
    .kpi-card-val.danger { color: var(--accent-red); }
    .kpi-card-val.warning { color: var(--accent-amber); }
    .kpi-card-desc { font-size: 0.78rem; color: var(--text-muted); }

    .card-table {
        background: var(--bg-card);
        border: 1px solid var(--border-color);
        border-radius: 14px;
        overflow: hidden;
        box-shadow: var(--shadow-card);
    }

    .card-table-header {
        padding: 20px 24px;
        display: flex;
        justify-content: space-between;
        align-items: center;
        border-bottom: 1px solid var(--border-color);
        flex-wrap: wrap;
        gap: 14px;
    }

    .search-box {
        background: var(--bg-input);
        border: 1px solid var(--border-color);
        border-radius: 8px;
        padding: 9px 16px;
        color: var(--text-main);
        font-size: 0.88rem;
        width: 340px;
        outline: none;
        transition: border-color 0.2s;
    }
    .search-box:focus {
        border-color: var(--brand-primary);
    }

    .btn-primary-action {
        display: inline-flex;
        align-items: center;
        gap: 8px;
        padding: 8px 16px;
        border-radius: 8px;
        background: var(--brand-primary);
        color: #ffffff;
        font-size: 0.84rem;
        font-weight: 700;
        text-decoration: none;
        border: none;
        cursor: pointer;
        transition: all 0.2s;
        box-shadow: 0 2px 8px rgba(200, 16, 46, 0.3);
    }
    .btn-primary-action:hover {
        background: var(--brand-primary-hover);
        color: #ffffff;
    }

    .table-responsive {
        overflow-x: auto;
        max-height: 600px;
    }

    table {
        width: 100%;
        border-collapse: collapse;
        text-align: left;
        font-size: 0.84rem;
    }

    th {
        background: var(--border-color-subtle);
        padding: 13px 18px;
        font-weight: 700;
        color: var(--text-muted);
        border-bottom: 1px solid var(--border-color);
        position: sticky;
        top: 0;
        z-index: 10;
        font-size: 0.78rem;
        text-transform: uppercase;
        letter-spacing: 0.04em;
    }

    td {
        padding: 14px 18px;
        border-bottom: 1px solid var(--border-color-subtle);
        color: var(--text-main);
    }

    tr:hover td {
        background: var(--bg-card-hover);
    }

    .badge-risk {
        display: inline-block;
        padding: 4px 8px;
        border-radius: 6px;
        font-size: 0.72rem;
        font-weight: 700;
    }
    .badge-risk.critico { background: rgba(239, 68, 68, 0.18); color: #fca5a5; border: 1px solid rgba(239, 68, 68, 0.35); }
    .badge-risk.remessa { background: rgba(59, 130, 246, 0.15); color: #93c5fd; border: 1px solid rgba(59, 130, 246, 0.3); }
    .badge-risk.bonif { background: rgba(16, 185, 129, 0.15); color: #6ee7b7; border: 1px solid rgba(16, 185, 129, 0.3); }
    .badge-risk.retorno { background: rgba(245, 158, 11, 0.15); color: #fcd34d; border: 1px solid rgba(245, 158, 11, 0.3); }

    .sql-box {
        background: #0a0e17;
        border: 1px solid var(--border-color);
        border-radius: 10px;
        padding: 20px;
        font-family: 'JetBrains Mono', monospace;
        font-size: 0.82rem;
        color: #93c5fd;
        overflow-x: auto;
        line-height: 1.5;
        margin-top: 14px;
        white-space: pre;
    }
</style>
@endsection

@section('content')
    <div style="margin-bottom: 24px;">
        <h2 style="font-size: 1.5rem; font-weight: 800; letter-spacing: -0.02em;">
            Auditoria: Notas de Uso e Consumo sem Contas a Pagar
        </h2>
        <p style="color: var(--text-muted); font-size: 0.9rem; margin-top: 4px;">
            Confronto direto entre as notas registradas (<code>VETEIN01..05, 10..13</code>) e os títulos do Contas a Pagar (<code>VETEDP01..05, 10..13</code>) nas Empresas Físicas 1 a 5 e 10 a 13.
        </p>
        <div style="margin-top: 10px; display: inline-flex; align-items: center; gap: 8px; flex-wrap: wrap; background: rgba(59, 130, 246, 0.08); border: 1px solid rgba(59, 130, 246, 0.22); padding: 6px 14px; border-radius: 8px;">
            <span style="color: var(--accent-blue); font-weight: 700; font-size: 0.8rem;">🛡️ Regra de Negócio:</span>
            <span style="font-size: 0.82rem; color: var(--text-muted);">
                Filtro canônico por Ramos de <strong>Uso e Consumo (Ramo 4 - Material e Ramo 8 - Serviços)</strong>. Excluídos automaticamente materiais operacionais (Abbott, ST Jude, hospitais/OPME), operadoras de saúde (Amil, etc.), colaboradores, consultores e clientes (Vitória Hospitalar).
            </span>
        </div>
    </div>

    {{-- BARRA DE FILTROS POR EMPRESA FÍSICA --}}
    <div class="filiais-filter-bar">
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => 'todas']) }}" 
           class="filial-pill {{ $filialFiltro === 'todas' ? 'active' : '' }}">
            <span>🏢 Todas as Filiais</span>
            <span class="filial-count-badge">{{ number_format($totalGeralNotas, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '1']) }}" 
           class="filial-pill {{ $filialFiltro === '1' ? 'active' : '' }}">
            <span>01 - VH Matriz - ES (001)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['1'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '2']) }}" 
           class="filial-pill {{ $filialFiltro === '2' ? 'active' : '' }}">
            <span>02 - VH Filial SP (002)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['2'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '3']) }}" 
           class="filial-pill {{ $filialFiltro === '3' ? 'active' : '' }}">
            <span>03 - VH Filial MG (003)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['3'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '4']) }}" 
           class="filial-pill {{ $filialFiltro === '4' ? 'active' : '' }}">
            <span>04 - VH Filial RJ (004)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['4'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '5']) }}" 
           class="filial-pill {{ $filialFiltro === '5' ? 'active' : '' }}">
            <span>05 - VH Filial R.P.-SP (005)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['5'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '10']) }}" 
           class="filial-pill {{ $filialFiltro === '10' ? 'active' : '' }}">
            <span>10 - VH Conecta Matriz - RJ (10)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['10'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '11']) }}" 
           class="filial-pill {{ $filialFiltro === '11' ? 'active' : '' }}">
            <span>11 - VH Conecta Filial - SP (11)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['11'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '12']) }}" 
           class="filial-pill {{ $filialFiltro === '12' ? 'active' : '' }}">
            <span>12 - VH Conecta Filial - Rib.Preto/SP (12)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['12'] ?? 0, 0, ',', '.') }}</span>
        </a>
        <a href="{{ route('visoes.notas-sem-financeiro', ['filial' => '13']) }}" 
           class="filial-pill {{ $filialFiltro === '13' ? 'active' : '' }}">
            <span>13 - VH Rio Vix (13)</span>
            <span class="filial-count-badge">{{ number_format($totaisPorFilial['13'] ?? 0, 0, ',', '.') }}</span>
        </a>
    </div>

    @if ($erroConexao)
        <div style="background: rgba(239, 68, 68, 0.12); border: 1px solid var(--accent-red); border-radius: 12px; padding: 16px; margin-bottom: 24px; color: #fca5a5;">
            <strong>⚠️ Erro ao consultar banco de dados:</strong> {{ $erroConexao }}
        </div>
    @endif

    {{-- KPIS --}}
    <div class="kpi-grid">
        <div class="kpi-card">
            <span class="kpi-card-title">Total de Notas em Aberto</span>
            <span class="kpi-card-val">{{ number_format($kpisAuditoria['total_notas'], 0, ',', '.') }}</span>
            <span class="kpi-card-desc">{{ $filialFiltro === 'todas' ? 'Consolidado Empresas Físicas (1 a 5 e 10 a 13)' : 'Empresa Física ' . $filialFiltro }}</span>
        </div>
        <div class="kpi-card">
            <span class="kpi-card-title">Valor Total em Aberto</span>
            <span class="kpi-card-val warning">R$ {{ number_format($kpisAuditoria['valor_total'], 2, ',', '.') }}</span>
            <span class="kpi-card-desc">Soma real das despesas de uso/consumo sem contas a pagar</span>
        </div>
        <div class="kpi-card">
            <span class="kpi-card-title">🚨 Despesas sem Duplicata</span>
            <span class="kpi-card-val danger">R$ {{ number_format($kpisAuditoria['valor_critico'], 2, ',', '.') }}</span>
            <span class="kpi-card-desc">{{ $kpisAuditoria['total_critico'] }} notas com consumo direto/compras sem duplicata</span>
        </div>
        <div class="kpi-card">
            <span class="kpi-card-title">Escopo Atual</span>
            <span class="kpi-card-val" style="color: var(--accent-blue);">{{ $filialFiltro === 'todas' ? 'Todas (1 a 5)' : 'Empresa ' . $filialFiltro }}</span>
            <span class="kpi-card-desc">{{ count($auditoriaDados) }} mais recentes listadas abaixo</span>
        </div>
    </div>

    {{-- TABELA DE RESULTADOS --}}
    <div class="card-table">
        <div class="card-table-header">
            <div>
                <strong style="font-size: 1.05rem;">Notas de Uso e Consumo sem Passivo no Contas a Pagar</strong>
                <div style="font-size: 0.8rem; color: var(--text-muted);">Auditoria ao vivo no banco Oracle (Ramos 4 e 8)</div>
            </div>
            <div style="display: flex; align-items: center; gap: 10px;">
                <input type="text" id="filtroTabela" class="search-box" placeholder="🔍 Buscar por NF, Fornecedor, CNPJ ou CFOP..." onkeyup="filtrarLinhas()">
                <button type="button" class="btn-primary-action" onclick="abrirModalExportacao('{{ route('visoes.exportar.auditoria-csv') }}', {{ json_encode(['filial' => $filialFiltro]) }}, { titulo: 'Exportar Auditoria de Notas', subtitulo: 'Selecione o período de entrada ou exporte todo o histórico' })" title="Exportar dados para CSV">
                    <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" viewBox="0 0 24 24" fill="none" stroke="currentColor" stroke-width="2" stroke-linecap="round" stroke-linejoin="round"><path d="M21 15v4a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2v-4"/><polyline points="7 10 12 15 17 10"/><line x1="12" y1="15" x2="12" y2="3"/></svg>
                    <span>Exportar CSV</span>
                </button>
            </div>
        </div>

        <div class="table-responsive">
            <table id="tabelaAuditoria">
                <thead>
                    <tr>
                        <th>Filial</th>
                        <th>NF / Série</th>
                        <th>Emissão</th>
                        <th>Entrada</th>
                        <th>Ramo / Segmento</th>
                        <th>Fornecedor / Fabricante</th>
                        <th>CFOP</th>
                        <th>Classificação de Risco</th>
                        <th style="text-align: right;">Valor Total</th>
                        <th style="text-align: center;">Parc. NF</th>
                        <th style="text-align: center;">Títulos CP</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($auditoriaDados as $row)
                        @php
                            $risco = $row['classificacao_risco_fiscal'] ?? '';
                            $riscoClass = 'badge-risk';
                            if (str_contains($risco, 'CRÍTICO')) $riscoClass .= ' critico';
                            elseif (str_contains($risco, 'REMESSA')) $riscoClass .= ' remessa';
                            elseif (str_contains($risco, 'BONIFICAÇÃO')) $riscoClass .= ' bonif';
                            else $riscoClass .= ' retorno';
                        @endphp
                        <tr>
                            <td><strong>{{ $row['filial'] ?? '' }}</strong></td>
                            <td>
                                <strong>{{ $row['num_nota_fiscal'] ?? '' }}</strong>
                                <div style="font-size: 0.72rem; color: var(--text-muted);">Série: {{ $row['serie'] ?: '1' }}</div>
                            </td>
                            <td>{{ $row['dt_emissao'] ?? 'N/A' }}</td>
                            <td>{{ $row['dt_entrada'] ?? 'N/A' }}</td>
                            <td>
                                <span style="font-size: 0.72rem; padding: 3px 8px; border-radius: 6px; background: rgba(139, 92, 246, 0.15); color: #c4b5fd; font-weight: 700; border: 1px solid rgba(139, 92, 246, 0.3);">
                                    {{ $row['segmento_ramo'] ?? 'USO/CONSUMO' }}
                                </span>
                            </td>
                            <td>
                                <div style="max-width: 260px; font-weight: 600; white-space: nowrap; overflow: hidden; text-overflow: ellipsis;" title="{{ $row['razao_social_fornecedor'] ?? '' }}">
                                    {{ $row['razao_social_fornecedor'] ?? 'FORNECEDOR NÃO ENCONTRADO' }}
                                </div>
                                <div style="font-size: 0.72rem; color: var(--text-muted);">
                                    Cód: {{ $row['cod_fornecedor'] ?? '' }} | CNPJ: {{ !empty($row['cnpj_formatado']) ? $row['cnpj_formatado'] : (!empty($row['cnpj_fornecedor']) ? $row['cnpj_fornecedor'] : 'N/A') }}
                                </div>
                            </td>
                            <td><code>{{ $row['cfop'] ?? '' }}</code></td>
                            <td><span class="{{ $riscoClass }}">{{ $risco }}</span></td>
                            <td style="text-align: right; font-weight: 700; color: var(--text-main);">
                                R$ {{ number_format((float) ($row['valor_total_nota'] ?? 0), 2, ',', '.') }}
                            </td>
                            <td style="text-align: center;">{{ $row['qtd_parcelas_informada'] ?? 0 }}</td>
                            <td style="text-align: center; color: var(--accent-red); font-weight: 700;">
                                {{ $row['parcelas_no_contas_a_pagar'] ?? 0 }}
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="11" style="text-align: center; padding: 40px; color: var(--text-muted);">
                                Nenhuma nota fiscal em aberto encontrada ou banco indisponível no momento.
                            </td>
                        </tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </div>

    {{-- EXPANSOR SQL ORACLE --}}
    <div style="margin-top: 28px;">
        <details style="background: var(--bg-card); border: 1px solid var(--border-color); border-radius: 14px; padding: 18px 24px; box-shadow: var(--shadow-card);">
            <summary style="font-weight: 700; cursor: pointer; color: var(--accent-blue); outline: none;">
                📄 Visualizar Código SQL Nativo Oracle (AUDITORIA_NOTAS_ENTRADA_SEM_CONTAS_A_PAGAR.sql)
            </summary>
            <p style="font-size: 0.85rem; color: var(--text-muted); margin-top: 10px;">
                Esta consulta é executada diretamente no banco Oracle cruzando <code>VIMAN.VETEIN (01..05, 10..13)</code> com <code>VIMAN.VETEDP (01..05, 10..13)</code> e o cadastro <code>VIMAN.VETECL</code> (Chave Composta CLCODI + CLRAMO).
            </p>
            <pre class="sql-box">SELECT * FROM (@include('modulos.visoes.partials.sql-auditoria-preview'))</pre>
        </details>
    </div>
@endsection

@section('scripts')
<script>
    function filtrarLinhas() {
        const termo = document.getElementById('filtroTabela').value.toLowerCase();
        const linhas = document.querySelectorAll('#tabelaAuditoria tbody tr');

        linhas.forEach(linha => {
            const texto = linha.innerText.toLowerCase();
            linha.style.display = texto.includes(termo) ? '' : 'none';
        });
    }
</script>
@endsection