@extends('layouts.app')
@section('title', 'Sales Report')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item active">Sales</li>
@endsection
@section('content')

<div class="page-header d-flex justify-content-between align-items-center">
    <div>
        <h1 class="page-title"><i class="bi bi-receipt me-2" style="color:#1d4ed8;"></i>Sales Report</h1>
        <p class="page-subtitle">{{ $from->format('d M Y') }} — {{ $to->format('d M Y') }}</p>
    </div>
    <button onclick="window.print()" class="btn btn-outline-secondary btn-sm"><i class="bi bi-printer me-1"></i>Print</button>
</div>

@php
    $saleTypeRetailSelected    = request('sale_type') === 'retail'    ? 'selected' : '';
    $saleTypeWholesaleSelected = request('sale_type') === 'wholesale' ? 'selected' : '';
@endphp

@include('reports.partials.date-filter', ['extraFilters' => '
<div class="col-auto">
    <select name="sale_type" class="form-select form-select-sm">
        <option value="">All Types</option>
        <option value="retail" '.$saleTypeRetailSelected.'>Retail</option>
        <option value="wholesale" '.$saleTypeWholesaleSelected.'>Wholesale</option>
    </select>
</div>
<div class="col-auto">
    <select name="payment_method" class="form-select form-select-sm">
        <option value="">All Methods</option>
        <option value="cash">Cash</option>
        <option value="card">Card</option>
        <option value="mobile_banking">Mobile Banking</option>
        <option value="bank_transfer">Bank Transfer</option>
    </select>
</div>'])

<div class="row g-3 mb-3">
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#dbeafe;"><i class="bi bi-receipt" style="color:#1d4ed8;"></i></div>
        <div><div class="stat-value">{{ number_format($totals->total_count) }}</div><div class="stat-label">Total Sales</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#d1fae5;"><i class="bi bi-cash-coin" style="color:#059669;"></i></div>
        <div><div class="stat-value" style="font-size:1rem;color:#059669;">৳{{ number_format($totals->total_revenue,0) }}</div><div class="stat-label">Revenue</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#dcfce7;"><i class="bi bi-graph-up" style="color:#16a34a;"></i></div>
        <div><div class="stat-value" style="font-size:1rem;color:#16a34a;">৳{{ number_format($totalProfit,0) }}</div><div class="stat-label">Profit</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:{{ $totals->total_due > 0 ? '#fee2e2' : '#d1fae5' }};"><i class="bi bi-clock" style="color:{{ $totals->total_due > 0 ? '#dc2626' : '#059669' }};"></i></div>
        <div><div class="stat-value" style="color:#dc2626;font-size:1rem;">৳{{ number_format($totals->total_due,0) }}</div><div class="stat-label">Outstanding Due</div></div></div>
    </div>
</div>

<div class="row g-3 mb-3">
    <div class="col-12 col-md-6">
        <div class="card">
            <div class="card-header fw-600">By Payment Method</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.85rem;">
                    <thead><tr><th>Method</th><th class="text-end">Count</th><th class="text-end">Total</th></tr></thead>
                    <tbody>
                        @foreach($byPaymentMethod as $m)
                        <tr>
                            <td>{{ ucfirst(str_replace('_',' ',$m->payment_method)) }}</td>
                            <td class="text-end">{{ $m->count }}</td>
                            <td class="text-end fw-600">৳{{ number_format($m->total,0) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="col-12 col-md-6">
        <div class="card">
            <div class="card-header fw-600">Daily Summary</div>
            <div class="card-body p-0" style="max-height:250px;overflow-y:auto;">
                <table class="table table-sm mb-0" style="font-size:.82rem;">
                    <thead style="position:sticky;top:0;background:#f8fafc;"><tr><th>Date</th><th class="text-end">Count</th><th class="text-end">Total</th></tr></thead>
                    <tbody>
                        @foreach($dailySummary as $d)
                        <tr>
                            <td>{{ \Carbon\Carbon::parse($d->sale_date)->format('d M Y') }}</td>
                            <td class="text-end">{{ $d->count }}</td>
                            <td class="text-end fw-600">৳{{ number_format($d->total,0) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header fw-600">Sales Transactions ({{ $sales->total() }})</div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table mb-0" style="font-size:.82rem;">
                <thead><tr><th>Invoice</th><th>Date</th><th>Customer</th><th>Type</th><th>Method</th><th class="text-end">Total</th><th class="text-end">Paid</th><th class="text-end">Due</th><th>Status</th></tr></thead>
                <tbody>
                    @forelse($sales as $sale)
                    <tr>
                        <td><a href="{{ route('sales.show', $sale) }}" style="font-family:monospace;color:#1d4ed8;font-weight:600;text-decoration:none;">{{ $sale->invoice_no }}</a></td>
                        <td>{{ $sale->sale_date->format('d M Y') }}</td>
                        <td>{{ $sale->customer?->name ?? 'Walk-in' }}</td>
                        <td><span class="badge {{ $sale->sale_type === 'wholesale' ? 'bg-warning text-dark' : 'bg-info' }}" style="font-size:.65rem;">{{ ucfirst($sale->sale_type) }}</span></td>
                        <td style="font-size:.78rem;">{{ ucfirst(str_replace('_',' ',$sale->payment_method)) }}</td>
                        <td class="text-end fw-600">৳{{ number_format($sale->total_amount,2) }}</td>
                        <td class="text-end text-success">৳{{ number_format($sale->paid_amount,2) }}</td>
                        <td class="text-end {{ $sale->due_amount > 0 ? 'text-danger fw-600' : '' }}">{{ $sale->due_amount > 0 ? '৳'.number_format($sale->due_amount,2) : '—' }}</td>
                        <td>@php $sc=['completed'=>'success','hold'=>'warning','returned'=>'danger']; @endphp<span class="badge bg-{{ $sc[$sale->status] ?? 'secondary' }}" style="font-size:.65rem;">{{ ucfirst($sale->status) }}</span></td>
                    </tr>
                    @empty
                    <tr><td colspan="9" class="text-center py-4 text-muted">No sales in this period</td></tr>
                    @endforelse
                </tbody>
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="5" class="fw-700 text-end">Totals:</td>
                        <td class="text-end fw-800">৳{{ number_format($totals->total_revenue,2) }}</td>
                        <td class="text-end fw-700 text-success">৳{{ number_format($totals->total_paid,2) }}</td>
                        <td class="text-end fw-700 text-danger">৳{{ number_format($totals->total_due,2) }}</td>
                        <td></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    @if($sales->hasPages())<div class="card-footer">{{ $sales->links() }}</div>@endif
</div>

@endsection