@extends('layouts.app')

@section('header_title', 'Financeiro - Relatorio de Faturamento')
@section('header_description', 'Analise faturamento por periodo, forma de pagamento e desempenho de produtos.')

@section('content')
<section class="page-head-row">
    <h2>Periodo do Relatorio</h2>
    <div class="page-actions">
        <a href="{{ route('finance.cash-flow.index') }}" class="secondary-btn">Fluxo de Caixa</a>
        <a href="{{ route('finance.payable.index') }}" class="secondary-btn">Contas a Pagar</a>
    </div>
</section>

<article class="card panel form-panel">
    <form method="GET" action="{{ route('finance.revenue.index') }}" class="grid-form">
        <div>
            <label for="from">Data inicial</label>
            <input id="from" name="from" type="date" value="{{ $from }}" required>
        </div>

        <div>
            <label for="to">Data final</label>
            <input id="to" name="to" type="date" value="{{ $to }}" required>
        </div>

        <div class="full-width form-actions">
            <button type="submit" class="primary-btn">Gerar Relatorio</button>
        </div>
    </form>
</article>

<section class="kpi-grid" style="margin-top: 14px;">
    <article class="card kpi-card">
        <p class="kpi-label">Faturamento Total</p>
        <h3>R$ {{ number_format($totalRevenue, 2, ',', '.') }}</h3>
        <span class="kpi-delta">No periodo selecionado</span>
    </article>

    <article class="card kpi-card">
        <p class="kpi-label">Quantidade de Vendas</p>
        <h3>{{ $salesCount }}</h3>
        <span class="kpi-delta">Vendas concluidas</span>
    </article>

    <article class="card kpi-card">
        <p class="kpi-label">Ticket Medio</p>
        <h3>R$ {{ number_format($avgTicket, 2, ',', '.') }}</h3>
        <span class="kpi-delta">Valor medio por venda</span>
    </article>

    <article class="card kpi-card">
        <p class="kpi-label">Melhor Dia</p>
        <h3>{{ $bestDay ? \Carbon\Carbon::parse($bestDay->ref_date)->format('d/m/Y') : '-' }}</h3>
        <span class="kpi-delta">{{ $bestDay ? 'R$ '.number_format((float) $bestDay->total_amount, 2, ',', '.') : 'Sem vendas' }}</span>
    </article>
</section>

<section class="content-grid">
    <article class="card panel">
        <div class="panel-head">
            <h2>Faturamento Diario</h2>
        </div>
        <div class="table-wrap">
            <table>
                <thead>
                    <tr>
                        <th>Data</th>
                        <th>Vendas</th>
                        <th>Faturamento</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($dailyRevenue as $day)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($day->ref_date)->format('d/m/Y') }}</td>
                            <td>{{ (int) $day->total_sales }}</td>
                            <td>R$ {{ number_format((float) $day->total_amount, 2, ',', '.') }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="3" class="empty-row">Sem dados de faturamento diario.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </article>

    <article class="card panel">
        <div class="panel-head">
            <h2>Recebimento por Forma</h2>
        </div>
        <div class="table-wrap">
            <table>
                <thead>
                    <tr>
                        <th>Forma</th>
                        <th>Total</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($paymentByMethod as $payment)
                        <tr>
                            <td>{{ str_replace('_', ' ', ucfirst($payment->method)) }}</td>
                            <td>R$ {{ number_format((float) $payment->total_amount, 2, ',', '.') }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="2" class="empty-row">Sem pagamentos no periodo.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </article>
</section>

<section class="content-grid" style="margin-top: 14px;">
    <article class="card panel">
        <div class="panel-head">
            <h2>Top Produtos</h2>
        </div>
        <div class="table-wrap">
            <table>
                <thead>
                    <tr>
                        <th>Produto</th>
                        <th>SKU</th>
                        <th>Qtd</th>
                        <th>Faturamento</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($topProducts as $item)
                        <tr>
                            <td>{{ $item->description }}</td>
                            <td>{{ $item->sku }}</td>
                            <td>{{ number_format((float) $item->total_qty, 3, ',', '.') }}</td>
                            <td>R$ {{ number_format((float) $item->total_revenue, 2, ',', '.') }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="4" class="empty-row">Sem itens vendidos no periodo.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </article>

    <article class="card panel">
        <div class="panel-head">
            <h2>Desempenho por Hora</h2>
        </div>
        <div class="table-wrap">
            <table>
                <thead>
                    <tr>
                        <th>Hora</th>
                        <th>Vendas</th>
                        <th>Faturamento</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse ($revenueByHour as $hour)
                        <tr>
                            <td>{{ str_pad((string) $hour->ref_hour, 2, '0', STR_PAD_LEFT) }}:00</td>
                            <td>{{ (int) $hour->total_sales }}</td>
                            <td>R$ {{ number_format((float) $hour->total_amount, 2, ',', '.') }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="3" class="empty-row">Sem dados por hora no periodo.</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
    </article>
</section>

<section class="page-head-row" style="margin-top: 14px;">
    <h2>Faturamento Mensal (ultimos 12 meses)</h2>
</section>

<article class="card panel">
    <div class="table-wrap">
        <table>
            <thead>
                <tr>
                    <th>Mes</th>
                    <th>Faturamento</th>
                </tr>
            </thead>
            <tbody>
                @forelse ($monthlyRevenue as $month)
                    <tr>
                        <td>{{ \Carbon\Carbon::createFromFormat('Y-m', $month->ref_month)->format('m/Y') }}</td>
                        <td>R$ {{ number_format((float) $month->total_amount, 2, ',', '.') }}</td>
                    </tr>
                @empty
                    <tr><td colspan="2" class="empty-row">Sem historico mensal disponivel.</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</article>
@endsection