@extends('layouts.admin')
@section('page-title', 'Reports')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-3">
    <h4 class="fw-bold mb-0">Reports</h4>
    <a href="{{ route('admin.reports.export', request()->query()) }}" class="btn btn-outline-secondary"><i class="bi bi-download me-1"></i>Export CSV</a>
</div>

<form class="row g-2 mb-3">
    <div class="col-md-3">
        <select name="type" class="form-select" onchange="this.form.submit()">
            <option value="sales" @selected($type==='sales')>Sales Report</option>
            <option value="stock" @selected($type==='stock')>Stock Report</option>
            <option value="customers" @selected($type==='customers')>Customer Report</option>
        </select>
    </div>
    @if ($type === 'sales')
    <div class="col-md-3"><input type="date" name="from" class="form-control" value="{{ request('from') }}"></div>
    <div class="col-md-3"><input type="date" name="to" class="form-control" value="{{ request('to') }}"></div>
    <div class="col-md-3"><button class="btn btn-outline-secondary w-100">Apply</button></div>
    @endif
</form>

@if ($summary)
<div class="row g-3 mb-3">
    <div class="col-6 col-md-3"><div class="card"><div class="card-body"><div class="small text-muted text-uppercase">Total Orders</div><div class="fs-5 fw-bold">{{ $summary['total_orders'] }}</div></div></div></div>
    <div class="col-6 col-md-3"><div class="card"><div class="card-body"><div class="small text-muted text-uppercase">Total Sales</div><div class="fs-5 fw-bold">₹{{ number_format($summary['total_sales'],2) }}</div></div></div></div>
    <div class="col-6 col-md-3"><div class="card"><div class="card-body"><div class="small text-muted text-uppercase">Total GST</div><div class="fs-5 fw-bold">₹{{ number_format($summary['total_gst'],2) }}</div></div></div></div>
    <div class="col-6 col-md-3"><div class="card"><div class="card-body"><div class="small text-muted text-uppercase">Total Qty</div><div class="fs-5 fw-bold">{{ $summary['total_qty'] }}</div></div></div></div>
</div>
@endif

<div class="card">
    <div class="table-responsive">
        <table class="table mb-0">
            <thead>
                <tr>
                    @if ($rows->isNotEmpty())
                        @foreach (array_keys($rows->first()) as $col)
                            <th>{{ ucwords(str_replace('_',' ',$col)) }}</th>
                        @endforeach
                    @endif
                </tr>
            </thead>
            <tbody>
                @forelse ($rows as $row)
                <tr>@foreach ($row as $val)<td>{{ $val }}</td>@endforeach</tr>
                @empty
                <tr><td class="text-center text-muted py-4">No data for this report</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endsection