<?php
/**
 * Clientes / Ticket Médio — shell instantâneo.
 */
?>
<div class="pbi-page-header">
    <h1 class="pbi-page-title"><i class="bi bi-receipt me-2 text-accent"></i>Clientes</h1>
</div>
<?php include __DIR__ . '/_submenu.php' ?>

<form method="get" action="/clientes/ticket-medio" 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>

<!-- ── KPIs skeleton ─────────────────────────────────────────────────────── -->
<div class="pbi-kpi-grid mb-4" id="kpi-grid">
    <?php for ($i = 0; $i < 3; $i++): ?>
    <div class="pbi-kpi-card">
        <div class="pbi-kpi-label pbi-skeleton" style="width:60%;height:.8rem;border-radius:4px">&nbsp;</div>
        <div class="pbi-kpi-value pbi-skeleton mt-2" style="width:80%;height:1.6rem;border-radius:4px">&nbsp;</div>
    </div>
    <?php endfor; ?>
</div>
<div class="pbi-hint mb-4" style="margin-top:0"><strong>Ticket Médio</strong> = valor médio gasto por compra do cliente. <strong>Clientes Fidelizados</strong> = clientes que compraram 2 ou mais vezes no período.</div>

<!-- ── Gráfico (async) ───────────────────────────────────────────────────── -->
<div id="chart-container" style="display:none!important">
    <div class="pbi-card mb-4">
        <div class="pbi-card-header"><i class="bi bi-bar-chart-horizontal me-2"></i>Top 10 — Ticket Médio por Cliente</div>
        <div class="pbi-hint mb-2" style="margin-top:0">Os 10 clientes que gastam mais por compra, em média. Quanto maior a barra, maior o valor médio de cada compra do cliente.</div>
        <div id="chartTicket" style="height:280px"></div>
    </div>
</div>

<!-- ── Tabela (async) ────────────────────────────────────────────────────── -->
<div class="pbi-card" id="card-ticket">
    <div class="pbi-card-header d-flex justify-content-between">
        <span><i class="bi bi-receipt me-2"></i>Ticket por Cliente</span>
        <small class="text-muted" id="ticket-badge">
            <span class="pbi-skeleton d-inline-block" style="width:80px;height:.75rem;border-radius:3px">&nbsp;</span>
        </small>
        <div class="pbi-hint" style="margin-top:.35rem"><strong>Compras</strong> = quantas vezes o cliente comprou; <strong>Valor Total</strong> = quanto gastou no total; <strong>Ticket Médio</strong> = valor médio por compra.</div>
    </div>
    <div id="ticket-body">
        <div class="table-responsive">
            <table class="pbi-table">
                <thead><tr>
                    <th>#</th><th>Cliente</th>
                    <th class="text-end">Compras</th>
                    <th class="text-end">Valor Total</th>
                    <th class="text-end">Ticket Médio</th>
                    <th>Última Compra</th>
                </tr></thead>
                <tbody>
                <?php for ($i = 0; $i < 8; $i++): ?>
                <tr>
                    <?php foreach ([30,130,50,80,80,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_TICKET = {
    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_TICKET.dataIni;
var fim = window.__CLIENTES_TICKET.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 renderTicket(linhas) {
    var total = linhas.length;
    var mediaGeral = total > 0
        ? linhas.reduce(function(s,r){return s+parseFloat(r.TICKET_MEDIO||0);},0)/total
        : 0;
    var maiorTicket = total > 0 ? parseFloat(linhas[0].TICKET_MEDIO||0) : 0;

    // KPIs
    document.getElementById('kpi-grid').innerHTML =
        '<div class="pbi-kpi-card"><div class="pbi-kpi-label">Clientes Fidelizados</div>'
        + '<div class="pbi-kpi-value">'+total+'</div>'
        + '<div class="pbi-kpi-sub">≥ 2 compras no período</div></div>'
        + '<div class="pbi-kpi-card"><div class="pbi-kpi-label">Ticket Médio Geral</div>'
        + '<div class="pbi-kpi-value text-accent">'+fmtR(mediaGeral)+'</div></div>'
        + '<div class="pbi-kpi-card"><div class="pbi-kpi-label">Maior Ticket</div>'
        + '<div class="pbi-kpi-value text-success">'+(total?fmtR(maiorTicket):'—')+'</div></div>';

    document.getElementById('ticket-badge').textContent = total + ' clientes';

    if (!linhas.length) {
        document.getElementById('ticket-body').innerHTML =
            '<p class="text-center text-muted py-4">Sem dados 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">'+parseInt(r.QTD_NOTAS||0)+'x</td>'
            + '<td class="text-end">'+fmtR(r.VALOR_TOTAL||0)+'</td>'
            + '<td class="text-end fw-bold text-accent">'+fmtR(r.TICKET_MEDIO||0)+'</td>'
            + '<td>'+fmtData(r.ULTIMA_COMPRA)+'</td>'
            + '</tr>';
    }).join('');

    document.getElementById('ticket-body').innerHTML =
        '<div class="table-responsive"><table class="pbi-table">'
        + '<thead><tr><th>#</th><th>Cliente</th>'
        + '<th class="text-end">Compras</th><th class="text-end">Valor Total</th>'
        + '<th class="text-end">Ticket Médio</th><th>Última Compra</th>'
        + '</tr></thead><tbody>'+rows+'</tbody></table></div>';

    // Gráfico top 10
    var top10 = linhas.slice(0,10);
    if (top10.length && typeof echarts !== 'undefined') {
        document.getElementById('chart-container').style.removeProperty('display');
        var nomes   = top10.map(function(r){return (r.NOME||'—').substring(0,20);});
        var tickets = top10.map(function(r){return Math.round(parseFloat(r.TICKET_MEDIO||0)*100)/100;});
        var nRev    = nomes.slice().reverse();
        var ax      = {color:'#64748b',fontSize:11};
        var c = echarts.init(document.getElementById('chartTicket'));
        c.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.toFixed(0);}}},
            yAxis:{type:'category',data:nRev,axisLabel:{color:ax.color,fontSize:ax.fontSize,width:130,overflow:'truncate'}},
            series:[{type:'bar',data:tickets.slice().reverse(),itemStyle:{color:'#4f8ef7'},
                label:{show:true,position:'right',color:'#475569',formatter:function(p){return 'R$ '+p.data.toLocaleString('pt-BR',{minimumFractionDigits:2});}}}]});
        window.addEventListener('resize',function(){c.resize();});
    }
}

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

})();
</script>
