@extends('layouts.app')
@section('title', 'Reports')
@section('content')
<h4 class="mb-3">Sales Reports</h4>
<form class="row g-2 mb-3">
    <div class="col-auto"><input type="date" name="from" value="{{ $from }}" class="form-control"></div>
    <div class="col-auto"><input type="date" name="to" value="{{ $to }}" class="form-control"></div>
    <div class="col-auto"><button class="btn btn-dark">Filter</button></div>
    <div class="col-auto"><a href="{{ route('reports.sales-register-export', ['from' => $from, 'to' => $to]) }}" class="btn btn-outline-dark">Export Sales Register (CSV)</a></div>
</form>

<div class="row g-3 mb-4">
    <div class="col-md-4"><div class="card p-3"><div class="text-muted small">Total Sales</div><div class="fs-4 fw-bold">{{ number_format($summary['total_sales'],2) }}</div></div></div>
    <div class="col-md-4"><div class="card p-3"><div class="text-muted small">Orders</div><div class="fs-4 fw-bold">{{ $summary['order_count'] }}</div></div></div>
    <div class="col-md-4"><div class="card p-3"><div class="text-muted small">Avg Order Value</div><div class="fs-4 fw-bold">{{ number_format($summary['avg_order_value'],2) }}</div></div></div>
</div>

<div class="row">
    <div class="col-md-6">
        <h6>Daily Sales</h6>
        <table class="table bg-white table-sm">
            <thead><tr><th>Date</th><th>Total</th></tr></thead>
            <tbody>
            @foreach ($dailySales as $d)
            <tr><td>{{ $d->date }}</td><td>{{ number_format($d->total,2) }}</td></tr>
            @endforeach
            </tbody>
        </table>
    </div>
    <div class="col-md-6">
        <h6>Top Products</h6>
        <table class="table bg-white table-sm">
            <thead><tr><th>Product</th><th>Qty Sold</th><th>Revenue</th></tr></thead>
            <tbody>
            @foreach ($topProducts as $p)
            <tr><td>{{ $p->name }}</td><td>{{ $p->qty_sold }}</td><td>{{ number_format($p->revenue,2) }}</td></tr>
            @endforeach
            </tbody>
        </table>
    </div>
</div>

@if ($branchSales && $branchSales->count())
<h6 class="mt-4">Sales by Branch</h6>
<table class="table bg-white table-sm" style="max-width:500px;">
    <thead><tr><th>Branch</th><th>Orders</th><th>Total</th></tr></thead>
    <tbody>
    @foreach ($branchSales as $b)
    <tr><td>{{ $b->name }}</td><td>{{ $b->order_count }}</td><td>{{ number_format($b->total,2) }}</td></tr>
    @endforeach
    </tbody>
</table>
@endif

@if ($paymentBreakdown->count())
<h6 class="mt-4">Sales by Payment Method</h6>
<table class="table bg-white table-sm" style="max-width:500px;">
    <thead><tr><th>Method</th><th>Payments</th><th>Total</th></tr></thead>
    <tbody>
    @foreach ($paymentBreakdown as $p)
    <tr>
        <td>{{ \App\Models\Payment::methodLabels()[$p->method] ?? ucfirst($p->method) }}</td>
        <td>{{ $p->payment_count }}</td>
        <td>{{ number_format($p->total,2) }}</td>
    </tr>
    @endforeach
    </tbody>
</table>
@endif

@if ($channelBreakdown->count())
<h6 class="mt-4">Sales by Channel (Net of Delivery Commission)</h6>
<table class="table bg-white table-sm" style="max-width:650px;">
    <thead><tr><th>Channel</th><th>Orders</th><th>Gross Sales</th><th>Platform Commission</th><th>Net</th></tr></thead>
    <tbody>
    @foreach ($channelBreakdown as $label => $row)
    <tr>
        <td>{{ $label }}</td>
        <td>{{ $row['order_count'] }}</td>
        <td>{{ number_format($row['gross'],2) }}</td>
        <td class="text-danger">{{ $row['commission'] > 0 ? '-'.number_format($row['commission'],2) : '-' }}</td>
        <td class="fw-bold">{{ number_format($row['net'],2) }}</td>
    </tr>
    @endforeach
    </tbody>
</table>
@endif
@endsection