<?php
/**
 * Clientes / Frequência — shell instantâneo.
 */
?>
<div class="pbi-page-header">
    <h1 class="pbi-page-title"><i class="bi bi-arrow-repeat me-2 text-accent"></i>Clientes</h1>
</div>
<?php include __DIR__ . '/_submenu.php' ?>

<form method="get" action="/clientes/frequencia" class="pbi-filtro-barra mb-3">
    <div class="pbi-filtro-row">
        <div class="pbi-filtro-field"><label class="pbi-filtro-label">De</label>
            <input type="date" name="data_ini" value="<?= \App\Core\View::e($filtros['dataIni']??'') ?>" class="pbi-filtro-input form-control"></div>
        <div class="pbi-filtro-field"><label class="pbi-filtro-label">Até</label>
            <input type="date" name="data_fim" value="<?= \App\Core\View::e($filtros['dataFim']??'') ?>" class="pbi-filtro-input form-control"></div>
        <button type="submit" class="pbi-btn-filtrar btn"><i class="bi bi-funnel me-1"></i>Filtrar</button>
    </div>
</form>

<!-- ── Área de gráficos (preenchida pelo JS) ──────────────────────────────── -->
<div id="charts-area" class="row g-3 mb-4" style="display:none!important"></div>

<!-- ── Tabela (async) ────────────────────────────────────────────────────── -->
<div class="pbi-card" id="card-frequencia">
    <div class="pbi-card-header d-flex justify-content-between">
        <span><i class="bi bi-arrow-repeat me-2"></i>Frequência de Clientes</span>
        <small class="text-muted" id="freq-badge">
            <span class="pbi-skeleton d-inline-block" style="width:100px;height:.75rem;border-radius:3px">&nbsp;</span>
        </small>
        <div class="pbi-hint" style="margin-top:.35rem">Mostra com que regularidade cada cliente compra no período. <strong>Visitas</strong> = quantas compras fez; <strong>Ticket Médio</strong> = valor médio gasto por compra.</div>
    </div>
    <div id="freq-body">
        <div class="table-responsive">
            <table class="pbi-table">
                <thead><tr>
                    <th>#</th><th>Cliente</th>
                    <th class="text-end">Visitas</th>
                    <th class="text-end">Valor Total</th>
                    <th class="text-end">Ticket Médio</th>
                    <th>Primeira</th><th>Última</th>
                </tr></thead>
                <tbody>
                <?php for ($i = 0; $i < 8; $i++): ?>
                <tr>
                    <?php foreach ([30,140,50,80,80,65,65] as $w): ?>
                    <td><span class="pbi-skeleton d-inline-block" style="width:<?= $w ?>px;height:.75rem;border-radius:3px">&nbsp;</span></td>
                    <?php endforeach; ?>
                </tr>
                <?php endfor; ?>
                </tbody>
            </table>
        </div>
    </div>
</div>

<script>
window.__CLIENTES_FREQ = {
    dataIni: <?= json_encode($filtros['dataIni']??'') ?>,
    dataFim: <?= json_encode($filtros['dataFim']??'') ?>
};
</script>

<style>
@keyframes pbi-pulse{0%,100%{opacity:1}50%{opacity:.4}}
.pbi-skeleton{background:var(--pbi-border,#e2e8f0);animation:pbi-pulse 1.4s ease-in-out infinite;pointer-events:none;color:transparent!important}
</style>

<script>
(function(){
'use strict';

var ini = window.__CLIENTES_FREQ.dataIni;
var fim = window.__CLIENTES_FREQ.dataFim;
var qs  = '?data_ini='+encodeURIComponent(ini)+'&data_fim='+encodeURIComponent(fim);

function fmtR(v){return 'R$ '+parseFloat(v||0).toLocaleString('pt-BR',{minimumFractionDigits:2,maximumFractionDigits:2});}
function fmtData(s){if(!s)return'—';return s.substring(8,10)+'/'+s.substring(5,7)+'/'+s.substring(0,4);}
function esc(s){var d=document.createElement('div');d.textContent=s||'';return d.innerHTML;}
function apiFetch(url){
    return fetch(url,{credentials:'same-origin'}).then(function(r){
        if(!r.ok)return r.json().then(function(e){throw new Error(e.erro||'HTTP '+r.status);});
        return r.json();
    });
}

function renderFrequencia(linhas) {
    document.getElementById('freq-badge').textContent = linhas.length + ' clientes no período';
    if (!linhas.length) {
        document.getElementById('freq-body').innerHTML =
            '<p class="text-center text-muted py-4">Nenhum dado encontrado no período.</p>';
        return;
    }
    var rows = linhas.map(function(r, i){
        return '<tr>'
            + '<td class="text-muted">'+(i+1)+'</td>'
            + '<td>'+esc(r.NOME||'—')+'</td>'
            + '<td class="text-end fw-bold text-accent">'+parseInt(r.QTD_VISITAS||0)+'x</td>'
            + '<td class="text-end">'+fmtR(r.VALOR_TOTAL||0)+'</td>'
            + '<td class="text-end">'+fmtR(r.TICKET_MEDIO||0)+'</td>'
            + '<td>'+fmtData(r.PRIMEIRA)+'</td>'
            + '<td>'+fmtData(r.ULTIMA)+'</td>'
            + '</tr>';
    }).join('');
    document.getElementById('freq-body').innerHTML =
        '<div class="table-responsive"><table class="pbi-table">'
        + '<thead><tr><th>#</th><th>Cliente</th>'
        + '<th class="text-end">Visitas</th><th class="text-end">Valor Total</th>'
        + '<th class="text-end">Ticket Médio</th><th>Primeira</th><th>Última</th>'
        + '</tr></thead><tbody>'+rows+'</tbody></table></div>';

    // Gráficos top 10
    var top10 = linhas.slice(0,10);
    if (top10.length && typeof echarts !== 'undefined') {
        var area = document.getElementById('charts-area');
        area.style.removeProperty('display');
        area.innerHTML =
            '<div class="col-md-6"><div class="pbi-card h-100">'
            + '<div class="pbi-card-header"><i class="bi bi-bar-chart-horizontal me-2"></i>Top 10 — Visitas</div>'
            + '<div id="chartVisitas" style="height:280px"></div></div></div>'
            + '<div class="col-md-6"><div class="pbi-card h-100">'
            + '<div class="pbi-card-header"><i class="bi bi-currency-dollar me-2"></i>Top 10 — Valor Total</div>'
            + '<div id="chartValorFreq" style="height:280px"></div></div></div>';

        var nomes  = top10.map(function(r){return (r.NOME||'—').substring(0,20);});
        var visits = top10.map(function(r){return parseInt(r.QTD_VISITAS||0);});
        var totais = top10.map(function(r){return Math.round(parseFloat(r.VALOR_TOTAL||0)*100)/100;});
        var nRev   = nomes.slice().reverse();
        var ax     = {color:'#64748b',fontSize:11};

        var c1 = echarts.init(document.getElementById('chartVisitas'));
        c1.setOption({backgroundColor:'transparent',tooltip:{trigger:'axis'},
            xAxis:{type:'value',axisLabel:ax},
            yAxis:{type:'category',data:nRev,axisLabel:{color:ax.color,fontSize:ax.fontSize,width:120,overflow:'truncate'}},
            series:[{type:'bar',data:visits.slice().reverse(),itemStyle:{color:'#4f8ef7'},
                label:{show:true,position:'right',color:'#475569'}}]});

        var c2 = echarts.init(document.getElementById('chartValorFreq'));
        c2.setOption({backgroundColor:'transparent',
            tooltip:{trigger:'axis',formatter:function(p){return 'R$ '+p[0].data.toLocaleString('pt-BR',{minimumFractionDigits:2});}},
            xAxis:{type:'value',axisLabel:{color:ax.color,fontSize:ax.fontSize,formatter:function(v){return 'R$'+(v/1000).toFixed(0)+'k';}}},
            yAxis:{type:'category',data:nRev,axisLabel:{color:ax.color,fontSize:ax.fontSize,width:120,overflow:'truncate'}},
            series:[{type:'bar',data:totais.slice().reverse(),itemStyle:{color:'#22c55e'},
                label:{show:true,position:'right',color:'#475569',formatter:function(p){return 'R$'+(p.data/1000).toFixed(1)+'k';}}}]});

        window.addEventListener('resize',function(){c1.resize();c2.resize();});
    }
}

window.addEventListener('DOMContentLoaded', function(){
    apiFetch('/api/clientes/frequencia'+qs)
        .then(function(d){renderFrequencia(d.linhas||[]);})
        .catch(function(e){
            document.getElementById('freq-body').innerHTML=
                '<div class="px-3 py-3 alert alert-warning small">Erro: '+esc(e.message)+'</div>';
        });
});

})();
</script>
