@extends('layouts.app')
@section('title', $titulo ?? 'Contatos Invalidados')
@section('content')
@include('components.seletor-contest')
 
 
<div style="display:flex;align-items:center;justify-content:space-between;flex-wrap:wrap;gap:.5rem;margin-bottom:1rem">
    <div>
        <h2 style="margin:0">❌ {{ $titulo ?? 'Contatos Invalidados' }}</h2>
        @if(!empty($descricao))
        <p style="margin:.25rem 0 0;color:var(--muted);font-size:.82rem">{!! $descricao !!}</p>
        @endif
    </div>
    <div class="stats-grid" style="max-width:380px;margin:0">
        <div class="stat-card stat-card-red">
            <div class="stat-number">{{ number_format($totalGeral) }}</div>
            <div class="stat-label">Total Invalidados</div>
        </div>
        <div class="stat-card">
            <div class="stat-number">{{ count($grupos) }}</div>
            <div class="stat-label">Operadores</div>
        </div>
    </div>
</div>
 
{{-- Filtros --}}
<form method="GET" action="{{ url()->current() }}"
      style="display:flex;flex-wrap:wrap;gap:.5rem;align-items:center;margin-bottom:1.25rem">
    <input type="text" name="q" value="{{ $busca }}"
           placeholder="Buscar por call sent ou call rcvd..."
           style="padding:.4rem .7rem;border:1px solid #ddd;border-radius:var(--radius);font-size:.88rem;min-width:240px">
    <select name="motivo"
            style="padding:.4rem .6rem;border:1px solid #ddd;border-radius:var(--radius);font-size:.88rem">
        <option value="">— Todos os motivos —</option>
        @foreach($motivos as $m)
            <option value="{{ $m->motivo }}" {{ $motivo===$m->motivo ? 'selected':'' }}>
                {{ $m->motivo }} ({{ number_format($m->total) }})
            </option>
        @endforeach
    </select>
    <button type="submit" class="btn btn-secondary" style="padding:.4rem .9rem">Filtrar</button>
    @if($busca || $motivo)
        <a href="{{ url()->current() }}"
           class="btn btn-secondary" style="padding:.4rem .9rem">✕ Limpar</a>
    @endif
</form>
 
{{-- Legenda --}}
<div style="margin-bottom:1rem;font-size:.82rem;display:flex;gap:1.25rem;align-items:center;flex-wrap:wrap">
    <span style="display:inline-flex;align-items:center;gap:.3rem">
        <span style="background:#dff0d8;border:1px solid #c3e6cb;width:14px;height:14px;display:inline-block;border-radius:2px"></span>
        Call Rcvd com ≥3 contatos confirmados na 1ª hora
    </span>
    <span style="display:inline-flex;align-items:center;gap:.3rem">
        <strong style="color:#2E7D32">1</strong> = válido &nbsp;
        <strong style="color:#C62828">0</strong> = inválido &nbsp;
        <span style="color:#bbb">—</span> = não aplicável (NULL)
    </span>
</div>
 
@forelse($grupos as $callSent => $qsos)
<div style="margin-bottom:2.5rem">
 
    {{-- Cabeçalho do grupo --}}
    <div style="background:var(--blue);color:#fff;padding:.5rem 1rem;
                border-radius:var(--radius) var(--radius) 0 0;font-weight:bold;font-size:.9rem;
                display:flex;justify-content:space-between;align-items:center">
        <span>Call Sent: {{ $callSent }}</span>
        <span style="opacity:.85;font-weight:normal;font-size:.82rem">{{ count($qsos) }} registro(s)</span>
    </div>
 
    <div style="overflow-x:auto">
    <table style="width:100%;border-collapse:collapse;font-size:.79rem">
        <thead>
            <tr style="background:#e8eef7">
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;white-space:nowrap">Call Sent</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;white-space:nowrap">Call Rcvd</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3">Exch Sent</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3">Exch Rcvd</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;white-space:nowrap">Contest Name</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;white-space:nowrap">Date Time</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;white-space:nowrap">Categoria Participante</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_contest">V.Contest</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_date">V.Date</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_categoria">V.Categ</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_exchange">V.Exch</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_hq">V.HQ</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_tempqso">V.Tempo</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="valid_trocaband">V.TrocaBnd</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3;text-align:center" title="confirmado">V.Contato</th>
                <th style="padding:.35rem .5rem;border:1px solid #d0d7e3">Motivo</th>
            </tr>
        </thead>
        <tbody>
            @foreach($qsos as $r)
            @php
                $primeiraHora = date('Y-m-d H:59:59', strtotime($r->date_time));
                $confsRcvd = isset($confirmados[$r->call_rcvd])
                    ? $confirmados[$r->call_rcvd]->filter(fn($c) =>
                        $c->date_time >= $r->date_time && $c->date_time <= $primeiraHora)
                        ->values()
                    : collect();
                $highlight = $confsRcvd->count() >= 3;
                // Colorir células com valor 0 (inválido)
                // Estilo: null=cinza(n/a), 0=vermelho(inválido), 1=verde(válido)
                $stv = function($v) {
                    if (is_null($v)) return 'color:#bbb';
                    return $v == 0 ? 'color:#C62828;font-weight:bold' : 'color:#2E7D32';
                };
                $stl = function($v) {
                    if (is_null($v)) return '—';
                    return $v;
                };
            @endphp
            <tr style="background:{{ $highlight ? '#dff0d8' : '#fff' }}">
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8"><strong>{{ $r->call_sent }}</strong></td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8">{{ $r->call_rcvd }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8">{{ $r->exch_sent }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;{{ $r->exch_rcvd === 'XX' ? 'color:#C62828;font-weight:bold' : '' }}">{{ $r->exch_rcvd }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8">{{ $r->contest_name }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;white-space:nowrap">{{ $r->date_time }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;font-size:.73rem">{{ $r->categoria_participante }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_contest) }}">{{ $stl($r->valid_contest) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_date) }}">{{ $stl($r->valid_date) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_categoria) }}">{{ $stl($r->valid_categoria) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_exchange) }}">{{ $stl($r->valid_exchange) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_hq) }}">{{ $stl($r->valid_hq) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_tempqso) }}">{{ $stl($r->valid_tempqso) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->valid_trocaband) }}">{{ $stl($r->valid_trocaband) }}</td>
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;text-align:center;{{ $stv($r->confirmado) }}">{{ $stl($r->confirmado) }}</td>
                @php
                    // Sanitiza motivo corrompido (charset issues do banco)
                    $mot = $r->motivo ?? '';
                    $mot = mb_convert_encoding($mot, 'UTF-8', 'UTF-8');
                    $mot = preg_replace('/[^ -~À-ÿ]/u', '?', $mot);
                @endphp
                <td style="padding:.3rem .5rem;border:1px solid #e8e8e8;color:#C62828;font-size:.73rem" title="{{ $r->motivo }}">{{ $mot }}</td>
            </tr>
            @if($highlight)
            <tr style="background:#f0faf0">
                <td colspan="16" style="padding:.3rem 1rem;border:1px solid #e8e8e8;font-size:.76rem;color:#2E7D32">
                    <strong>{{ $r->call_rcvd }}</strong> — {{ $confsRcvd->count() }} contatos confirmados na 1ª hora:
                    {{ $confsRcvd->map(fn($c) => "{$c->call_sent} ({$c->date_time})")->implode(' | ') }}
                </td>
            </tr>
            @endif
            @endforeach
        </tbody>
        <tfoot>
            <tr style="background:#f0f4fa;font-weight:bold">
                <td colspan="16" style="padding:.4rem .5rem;border:1px solid #d0d7e3;font-size:.82rem">
                    Total de registros para {{ $callSent }}: {{ count($qsos) }}
                </td>
            </tr>
        </tfoot>
    </table>
    </div>
</div>
@empty
<p style="color:#aaa;text-align:center;padding:2rem">Nenhum contato invalidado encontrado.</p>
@endforelse
 
@if($totalGeral > 0)
<div style="background:#f0f0f0;border-radius:var(--radius);padding:.75rem 1rem;
            font-weight:bold;font-size:.9rem;margin-top:.5rem">
    Total geral de registros inválidos: {{ number_format($totalGeral) }}
</div>
@endif
 
@endsection