@extends('layouts.app')
@section('title', 'Customer Aging Report')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('customer-payments.index') }}">Customer Payments</a></li>
<li class="breadcrumb-item active">Aging Report</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-clock-history me-2" style="color:#dc2626;"></i>Customer Receivable Aging</h1>
        <p class="page-subtitle">Outstanding dues by age — as of {{ now()->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
$buckets = ['0-30'=>[],'31-60'=>[],'61-90'=>[],'90+'=>[]];
foreach($report as $row) $buckets[$row['bucket']][] = $row;
@endphp

<div class="row g-3 mb-3">
    @foreach(['0-30'=>['d1fae5','059669'],'31-60'=>['fef3c7','d97706'],'61-90'=>['fed7aa','ea580c'],'90+'=>['fee2e2','dc2626']] as $bucket => $clr)
    <div class="col-6 col-md-3">
        <div class="card" style="border-left:3px solid #{{ $clr[1] }};">
            <div class="card-body py-3">
                <div style="font-size:.72rem;font-weight:700;color:#{{ $clr[1] }};">{{ $bucket }} DAYS</div>
                <div style="font-size:1.2rem;font-weight:800;color:#{{ $clr[1] }};">৳{{ number_format(collect($buckets[$bucket])->sum('current_due'),0) }}</div>
                <div style="font-size:.72rem;color:#64748b;">{{ count($buckets[$bucket]) }} customer(s)</div>
            </div>
        </div>
    </div>
    @endforeach
</div>

@foreach(['0-30'=>'success','31-60'=>'warning','61-90'=>'warning','90+'=>'danger'] as $bucket => $color)
@if(count($buckets[$bucket]))
<div class="card mb-3">
    <div class="card-header fw-600">
        <span class="badge bg-{{ $color }} me-2">{{ $bucket }} days</span>
        {{ count($buckets[$bucket]) }} customer(s) — ৳{{ number_format(collect($buckets[$bucket])->sum('current_due'),2) }}
    </div>
    <div class="card-body p-0">
        <table class="table table-sm mb-0" style="font-size:.85rem;">
            <thead><tr><th>Customer</th><th>Phone</th><th>Oldest Invoice</th><th>Days</th><th class="text-end">Due</th><th>Action</th></tr></thead>
            <tbody>
                @foreach($buckets[$bucket] as $row)
                <tr>
                    <td><a href="{{ route('customers.show', $row['customer']) }}" style="font-weight:600;color:#1d4ed8;text-decoration:none;">{{ $row['customer']->name }}</a></td>
                    <td>{{ $row['customer']->phone ?? '—' }}</td>
                    <td>{{ $row['oldest_due'] ? \Carbon\Carbon::parse($row['oldest_due'])->format('d M Y') : '—' }}</td>
                    <td><span class="badge bg-{{ $color }}">{{ $row['days_overdue'] }}d</span></td>
                    <td class="text-end fw-700 text-danger">৳{{ number_format($row['current_due'],2) }}</td>
                    <td>
                        <a href="{{ route('customer-payments.create', ['customer_id' => $row['customer']->id]) }}"
                           class="btn btn-sm btn-outline-primary">
                            <i class="bi bi-cash me-1"></i>Collect
                        </a>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif
@endforeach
@endsection