@php
    $rows = $simulateResult['rows'] ?? [];
    $summary = $simulateResult['summary'] ?? [];
    $fieldLabels = [
        'i_company_id' => 'Empresa interna (ID)',
        'group_id' => 'Grupo (ID)',
        'name' => 'Nome fantasia',
        'business_name' => 'Razão social',
        'opening_date' => 'Data de abertura',
        'document' => 'CNPJ (máscara na BD)',
        'type' => 'Tipo legal (1=Filial, 2=Matriz)',
        'company_characteristic_id' => 'Característica',
        'url' => 'Site',
        'zip_code' => 'CEP',
        'address' => 'Endereço',
        'number' => 'Número',
        'complement' => 'Complemento',
        'neighborhood' => 'Bairro',
        'city' => 'Cidade',
        'state' => 'UF',
        'company_size' => 'Porte',
        'is_active' => 'Ativa',
        'relationship_level' => 'Nível relacionamento',
        'company_capital' => 'Capital',
        'company_origin' => 'Origem país',
        'has_contract_pj' => 'Contrato PJ',
        'has_invoice_pj' => 'NF PJ',
        'flexible_benefits' => 'Benefícios flexíveis',
        'platform_flexible_benefits' => 'Plataforma benefícios',
        'company_payroll' => 'Empresa folha',
        'has_outpost' => 'Posto avançado',
        'has_doctor_company' => 'Médico na empresa',
        'doctor_company' => 'Qtd. médicos',
        'has_nursing_company' => 'Enfermagem',
        'nursing_company' => 'Qtd. enfermagem',
        'has_outpatient_company' => 'Ambulatório',
        'outpatient_company' => 'Qtd. ambulatório',
        'system_payroll' => 'Sistema folha',
        'type_visit' => 'Tipo visita',
        'frequency_visit' => 'Frequência visitas',
        'slug' => 'Slug (apelido)',
        'email' => 'E-mail',
        'phone' => 'Telefone',
        'nivel_planilha' => 'NIVEL (planilha)',
        'role' => 'Cargo (planilha)',
        'role_level' => 'Nível cargo (BD)',
        'hobbie' => 'Hobbie',
        'birth_date' => 'Aniversário',
        'company_id' => 'Empresa (ID)',
        'group_curve' => 'Curva do grupo (1–4)',
    ];
@endphp

<div class="sim-results" id="sim-results">
    <div class="sim-summary">
        <div class="sim-stat">
            <span class="sim-stat-n">{{ $summary['total'] ?? 0 }}</span>
            <span class="sim-stat-l">Linhas</span>
        </div>
        <div class="sim-stat sim-stat--create">
            <span class="sim-stat-n">{{ $summary['would_create'] ?? 0 }}</span>
            <span class="sim-stat-l">Criariam</span>
        </div>
        <div class="sim-stat sim-stat--update">
            <span class="sim-stat-n">{{ $summary['would_update'] ?? 0 }}</span>
            <span class="sim-stat-l">Atualizariam</span>
        </div>
        <div class="sim-stat sim-stat--skip">
            <span class="sim-stat-n">{{ $summary['skipped'] ?? 0 }}</span>
            <span class="sim-stat-l">Ignoradas</span>
        </div>
        <div class="sim-stat sim-stat--error">
            <span class="sim-stat-n">{{ $summary['errors'] ?? 0 }}</span>
            <span class="sim-stat-l">Erros</span>
        </div>
    </div>

    <div class="sim-toolbar">
        <input type="search" id="sim-filter" class="sim-search" placeholder="Filtrar por CNPJ, nome, grupo, linha…" autocomplete="off">
        <button type="button" class="sim-btn-ghost" id="sim-expand-all">Expandir tudo</button>
        <button type="button" class="sim-btn-ghost" id="sim-collapse-all">Recolher tudo</button>
        <label class="sim-check">
            <input type="checkbox" id="sim-show-debug"> Mostrar integrações (Localize / debug)
        </label>
    </div>

    <p class="sim-flow-hint">
        <strong>Ordem de gravação:</strong>
        <span class="sim-pill">groups</span> →
        <span class="sim-pill">companies</span> →
        <span class="sim-pill">company_type_index</span> →
        <span class="sim-pill">company_contacts</span>
    </p>

    <div class="sim-rows">
        @foreach($rows as $idx => $row)
            @php
                $status = $row['status'] ?? '';
                $preview = $row['preview'] ?? null;
                $payloadDb = $preview['payload_gravar_banco'] ?? null;
                $debug = $preview['integracao_debug'] ?? null;
                $companyReg = data_get($payloadDb, 'companies.registro', []);
                $searchBlob = mb_strtolower(implode(' ', array_filter([
                    (string) ($row['line'] ?? ''),
                    (string) ($row['cnpj'] ?? ''),
                    (string) ($row['cnpj_digitos'] ?? ''),
                    (string) ($companyReg['name'] ?? ''),
                    (string) ($companyReg['business_name'] ?? ''),
                    (string) data_get($payloadDb, 'groups.registro.name', ''),
                    (string) ($row['message'] ?? ''),
                ])));
                $action = $row['action'] ?? $status;
                $warnings = $row['warnings'] ?? [];
            @endphp
            <details class="sim-row sim-row--{{ $status }}" data-search="{{ $searchBlob }}"{{ ($idx < 3 && $status === 'preview') ? ' open' : '' }}>
                <summary class="sim-row-head">
                    <span class="sim-line">L{{ $row['line'] ?? '?' }}</span>
                    @if($status === 'preview')
                        <span class="sim-badge sim-badge--{{ str_contains($action, 'update') ? 'update' : 'create' }}">
                            {{ $action === 'would_update' ? 'ATUALIZAR' : 'CRIAR' }}
                        </span>
                        <span class="sim-cnpj">{{ $row['cnpj'] ?? '—' }}</span>
                        <span class="sim-empresa">{{ $companyReg['name'] ?? '—' }}</span>
                        <span class="sim-grupo">{{ data_get($payloadDb, 'groups.registro.name', '') }}</span>
                        @if(count($warnings))
                            <span class="sim-warn-count" title="{{ count($warnings) }} aviso(s)">⚠ {{ count($warnings) }}</span>
                        @endif
                    @elseif($status === 'error')
                        <span class="sim-badge sim-badge--error">ERRO</span>
                        <span class="sim-msg">{{ $row['message'] ?? 'Falha' }}</span>
                    @elseif($status === 'skipped')
                        <span class="sim-badge sim-badge--skip">IGNORADA</span>
                        <span class="sim-msg">{{ $row['message'] ?? '' }}</span>
                    @else
                        <span class="sim-badge">{{ $status }}</span>
                    @endif
                </summary>

                @if($status === 'preview' && $payloadDb)
                    <div class="sim-row-body">
                        @if(count($warnings))
                            <div class="sim-warnings">
                                <strong>Avisos</strong>
                                <ul>
                                    @foreach($warnings as $w)
                                        <li>{{ $w }}</li>
                                    @endforeach
                                </ul>
                            </div>
                        @endif

                        @php $g = $payloadDb['groups'] ?? []; @endphp
                        <div class="sim-table-block">
                            <div class="sim-table-head">
                                <span class="sim-table-icon">①</span>
                                <h3>Tabela <code>groups</code></h3>
                                @php $gOp = $g['operacao'] ?? 'nenhuma'; @endphp
                                <span class="sim-op sim-op--{{ $gOp === 'nenhuma' ? 'none' : (str_contains($gOp, 'insert') ? 'insert' : 'update') }}">
                                    {{ strtoupper(str_replace('_', ' ', $gOp)) }}
                                </span>
                            </div>
                            @if(($g['sera_criado_novo_grupo'] ?? false))
                                <p class="sim-note sim-note--info">Novo grupo será criado antes da empresa.</p>
                            @elseif(($g['group_id_existente'] ?? null))
                                <p class="sim-note">Grupo já existe — ID <strong>{{ $g['group_id_existente'] }}</strong>{{ $gOp !== 'nenhuma' ? ', curva será atualizada' : '' }}.</p>
                            @endif
                            <table class="sim-kv">
                                <tbody>
                                    @foreach(($g['registro'] ?? []) as $col => $val)
                                        <tr>
                                            <th>{{ $fieldLabels[$col] ?? $col }}</th>
                                            <td>@include('imports.partials.companies-simulate-cell', ['value' => $val])</td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>

                        <div class="sim-table-block sim-table-block--main">
                            <div class="sim-table-head">
                                <span class="sim-table-icon">②</span>
                                <h3>Tabela <code>companies</code></h3>
                                <span class="sim-op sim-op--{{ str_contains($action, 'update') ? 'update' : 'insert' }}">
                                    {{ str_contains($action, 'update') ? 'UPDATE' : 'INSERT' }}
                                </span>
                            </div>
                            <table class="sim-kv">
                                <tbody>
                                    @foreach($companyReg as $col => $val)
                                        <tr @class(['sim-row-highlight' => in_array($col, ['document', 'opening_date', 'slug', 'group_id'], true)])>
                                            <th>{{ $fieldLabels[$col] ?? $col }}</th>
                                            <td>
                                                @if($col === 'document' && !empty($row['cnpj']))
                                                    <span class="sim-mask">{{ $row['cnpj'] }}</span>
                                                    <span class="sim-dim">({{ $val }})</span>
                                                @else
                                                    @include('imports.partials.companies-simulate-cell', ['value' => $val])
                                                @endif
                                            </td>
                                        </tr>
                                    @endforeach
                                </tbody>
                            </table>
                        </div>

                        @php $ct = $payloadDb['company_type_index'] ?? []; @endphp
                        <div class="sim-table-block">
                            <div class="sim-table-head">
                                <span class="sim-table-icon">③</span>
                                <h3>Tabela <code>company_type_index</code> <span class="sim-rel">(N:N com <code>company_types</code>)</span></h3>
                                <span class="sim-op sim-op--sync">SYNC</span>
                            </div>
                            @php $typeIds = $ct['company_type_ids'] ?? []; @endphp
                            @if($typeIds === [])
                                <p class="sim-note sim-note--muted">Nenhum tipo associado nesta linha.</p>
                            @else
                                <p class="sim-note">Após gravar a empresa, serão ligados os IDs:</p>
                                <div class="sim-chips">
                                    @foreach($typeIds as $tid)
                                        <span class="sim-chip">company_type_id = <strong>{{ $tid }}</strong></span>
                                    @endforeach
                                </div>
                                @if($debug['company_types_origem_planilha'] ?? null)
                                    @php $orig = $debug['company_types_origem_planilha']; @endphp
                                    <table class="sim-kv sim-kv--compact">
                                        <tbody>
                                            <tr><th>Segmento (planilha)</th><td>{{ $orig['tipo_negocio_segmento'] ?: '—' }}</td></tr>
                                            <tr><th>Ramo (planilha)</th><td>{{ $orig['ramo_atividade'] ?: '—' }}</td></tr>
                                        </tbody>
                                    </table>
                                @endif
                            @endif
                        </div>

                        @php $contact = $payloadDb['company_contacts'] ?? null; @endphp
                        <div class="sim-table-block">
                            <div class="sim-table-head">
                                <span class="sim-table-icon">④</span>
                                <h3>Tabela <code>company_contacts</code></h3>
                                @if($contact)
                                    <span class="sim-op sim-op--insert">INSERT / UPDATE</span>
                                @else
                                    <span class="sim-op sim-op--none">—</span>
                                @endif
                            </div>
                            @if($contact)
                                @if(!empty($contact['nota']))
                                    <p class="sim-note sim-note--info">{{ $contact['nota'] }}</p>
                                @endif
                                @php $inferenciaCargo = $contact['inferencia_role_level'] ?? null; @endphp
                                @if($inferenciaCargo)
                                    <table class="sim-kv sim-kv--compact sim-kv--highlight">
                                        <tbody>
                                            <tr>
                                                <th>{{ $fieldLabels['nivel_planilha'] }}</th>
                                                <td>{{ $inferenciaCargo['nivel_planilha'] ?? '—' }}</td>
                                            </tr>
                                            <tr>
                                                <th>Inferência → <code>role_level</code></th>
                                                <td>
                                                    <strong>{{ $inferenciaCargo['role_level_exibicao'] ?? '—' }}</strong>
                                                    @if(!empty($inferenciaCargo['fonte']))
                                                        <span class="muted">via coluna {{ $inferenciaCargo['fonte'] }}</span>
                                                    @endif
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                @endif
                                <table class="sim-kv">
                                    <tbody>
                                        @foreach(($contact['registro'] ?? []) as $col => $val)
                                            <tr>
                                                <th>{{ $fieldLabels[$col] ?? $col }}</th>
                                                <td>@include('imports.partials.companies-simulate-cell', [
                                                    'value' => $val,
                                                    'column' => $col,
                                                    'inferencia' => $inferenciaCargo,
                                                ])</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            @else
                                <p class="sim-note sim-note--muted">Sem nome de contacto na planilha — nada gravado em <code>company_contacts</code>.</p>
                            @endif
                        </div>

                        @if($debug)
                            <details class="sim-debug" data-debug-panel>
                                <summary>Integrações e debug (Localize, data abertura)</summary>
                                <div class="sim-debug-inner">
                                    @if($debug['data_abertura'] ?? null)
                                        @php $da = $debug['data_abertura']; @endphp
                                        <h4>Data de abertura</h4>
                                        <table class="sim-kv sim-kv--compact">
                                            <tbody>
                                                <tr><th>Valor que vai para <code>opening_date</code></th><td><strong>{{ $da['valor_resolvido'] ?? '—' }}</strong></td></tr>
                                                <tr><th>Planilha</th><td>{{ $da['planilha_data_abertura'] ?: '—' }}</td></tr>
                                                <tr><th>Localize (candidatos)</th><td>{{ implode(', ', $da['candidatos_localize'] ?? []) ?: '—' }}</td></tr>
                                            </tbody>
                                        </table>
                                    @endif
                                    @if(!empty($debug['localize_basic']['founding_date']))
                                        <p class="sim-note">Localize <code>basic.founding_date</code>: <strong>{{ $debug['localize_basic']['founding_date'] }}</strong></p>
                                    @endif
                                    <details class="sim-json-wrap">
                                        <summary>JSON completo (integracao_debug)</summary>
                                        <pre class="sim-json">@json($debug, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE)</pre>
                                    </details>
                                </div>
                            </details>
                        @endif
                    </div>
                @endif
            </details>
        @endforeach
    </div>

    <details class="sim-raw-json">
        <summary>Ver JSON bruto completo da simulação</summary>
        <pre>@json($simulateResult, JSON_PRETTY_PRINT | JSON_UNESCAPED_UNICODE)</pre>
    </details>
</div>

<script>
(function () {
    const root = document.getElementById('sim-results');
    if (!root) return;

    const filter = document.getElementById('sim-filter');
    const showDebug = document.getElementById('sim-show-debug');
    const rows = root.querySelectorAll('.sim-row[data-search]');

    filter?.addEventListener('input', function () {
        const q = this.value.trim().toLowerCase();
        rows.forEach(function (el) {
            const blob = el.getAttribute('data-search') || '';
            el.style.display = !q || blob.includes(q) ? '' : 'none';
        });
    });

    document.getElementById('sim-expand-all')?.addEventListener('click', function () {
        root.querySelectorAll('.sim-row').forEach(function (d) { d.open = true; });
    });
    document.getElementById('sim-collapse-all')?.addEventListener('click', function () {
        root.querySelectorAll('.sim-row').forEach(function (d) { d.open = false; });
    });

    function toggleDebug(show) {
        root.querySelectorAll('[data-debug-panel]').forEach(function (d) {
            d.open = show;
            d.style.display = show ? '' : 'none';
        });
    }
    showDebug?.addEventListener('change', function () { toggleDebug(this.checked); });
    toggleDebug(false);
})();
</script>