@extends('layouts.app')
@section('title', 'Purchase Report')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item active">Purchases</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-cart-check me-2" style="color:#059669;"></i>Purchase 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>

@include('reports.partials.date-filter')

<div class="row g-3 mb-3">
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#d1fae5;"><i class="bi bi-cart-check" style="color:#059669;"></i></div>
        <div><div class="stat-value">{{ number_format($totals->total_count) }}</div><div class="stat-label">Purchases</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#dbeafe;"><i class="bi bi-currency-exchange" style="color:#1d4ed8;"></i></div>
        <div><div class="stat-value" style="font-size:1rem;color:#1d4ed8;">৳{{ number_format($totals->total_amount,0) }}</div><div class="stat-label">Total Value</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-cash" style="color:#059669;"></i></div>
        <div><div class="stat-value" style="font-size:1rem;color:#059669;">৳{{ number_format($totals->total_paid,0) }}</div><div class="stat-label">Paid</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#fee2e2;"><i class="bi bi-clock" style="color:#dc2626;"></i></div>
        <div><div class="stat-value" style="font-size:1rem;color:#dc2626;">৳{{ number_format($totals->total_due,0) }}</div><div class="stat-label">Due</div></div></div>
    </div>
</div>

<div class="row g-3 mb-3">
    <div class="col-12 col-md-5">
        <div class="card">
            <div class="card-header fw-600">By Supplier</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.82rem;">
                    <thead><tr><th>Supplier</th><th class="text-end">Count</th><th class="text-end">Total</th><th class="text-end">Due</th></tr></thead>
                    <tbody>
                        @foreach($bySupplier as $row)
                        <tr>
                            <td class="fw-600">{{ $row->supplier?->name }}</td>
                            <td class="text-end">{{ $row->count }}</td>
                            <td class="text-end">৳{{ number_format($row->total,0) }}</td>
                            <td class="text-end {{ $row->due > 0 ? 'text-danger fw-600' : '' }}">{{ $row->due > 0 ? '৳'.number_format($row->due,0) : '—' }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <div class="col-12 col-md-7">
        <div class="card">
            <div class="card-header fw-600">Top Purchased Items</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.82rem;">
                    <thead><tr><th>#</th><th>Product</th><th class="text-end">Qty</th><th class="text-end">Total Cost</th></tr></thead>
                    <tbody>
                        @foreach($topItems as $i => $item)
                        <tr>
                            <td style="color:#94a3b8;">{{ $i+1 }}</td>
                            <td>
                                <div class="fw-600">{{ $item->productVariant?->product?->name }}</div>
                                <div style="font-size:.72rem;color:#94a3b8;">{{ $item->productVariant?->variant_name }}</div>
                            </td>
                            <td class="text-end">{{ $item->total_qty }}</td>
                            <td class="text-end fw-600">৳{{ number_format($item->total_cost,0) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header fw-600">Purchase Records ({{ $purchases->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>Supplier</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($purchases as $pur)
                    <tr>
                        <td><a href="{{ route('purchases.show', $pur) }}" style="font-family:monospace;color:#059669;font-weight:600;text-decoration:none;">{{ $pur->invoice_no }}</a></td>
                        <td>{{ $pur->purchase_date->format('d M Y') }}</td>
                        <td>{{ $pur->supplier->name }}</td>
                        <td class="text-end fw-600">৳{{ number_format($pur->total_amount,2) }}</td>
                        <td class="text-end text-success">৳{{ number_format($pur->paid_amount,2) }}</td>
                        <td class="text-end {{ $pur->due_amount > 0 ? 'text-danger fw-600' : '' }}">{{ $pur->due_amount > 0 ? '৳'.number_format($pur->due_amount,2) : '—' }}</td>
                        <td>@php $pc=['received'=>'success','partial'=>'warning','paid'=>'success','ordered'=>'info','draft'=>'secondary']; @endphp<span class="badge bg-{{ $pc[$pur->status] ?? 'secondary' }}" style="font-size:.65rem;">{{ ucfirst($pur->status) }}</span></td>
                    </tr>
                    @empty
                    <tr><td colspan="7" class="text-center py-4 text-muted">No purchases in this period</td></tr>
                    @endforelse
                </tbody>
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="3" class="fw-700 text-end">Totals:</td>
                        <td class="text-end fw-800">৳{{ number_format($totals->total_amount,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($purchases->hasPages())<div class="card-footer">{{ $purchases->links() }}</div>@endif
</div>
@endsection