@extends('layouts.app')
@section('title', 'Supplier Aging Report')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="{{ route('supplier-payments.index') }}">Supplier 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>Supplier Aging Report</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+' => []];
$grandTotal  = 0;
foreach ($report as $row) {
    $buckets[$row['bucket']][] = $row;
    $grandTotal += $row['current_due'];
}
@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 => $colors)
    <div class="col-6 col-md-3">
        <div class="card" style="border-left:3px solid #{{ $colors[1] }};">
            <div class="card-body py-3">
                <div style="font-size:.75rem;font-weight:700;color:#{{ $colors[1] }};">{{ $bucket }} DAYS</div>
                <div style="font-size:1.25rem;font-weight:800;color:#{{ $colors[1] }};">
                    ৳{{ number_format(collect($buckets[$bucket])->sum('current_due'), 0) }}
                </div>
                <div style="font-size:.75rem;color:#64748b;">{{ count($buckets[$bucket]) }} supplier(s)</div>
            </div>
        </div>
    </div>
    @endforeach
</div>

@foreach(['0-30'=>'success','31-60'=>'warning','61-90'=>'orange','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 === 'orange' ? 'warning' : $color }} me-2">{{ $bucket }} days</span>
        {{ count($buckets[$bucket]) }} supplier(s) &nbsp;—&nbsp;
        ৳{{ 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>Supplier</th><th>Phone</th><th>Oldest Invoice</th><th>Days</th><th class="text-end">Due Amount</th><th>Action</th></tr></thead>
            <tbody>
                @foreach($buckets[$bucket] as $row)
                <tr>
                    <td><a href="{{ route('suppliers.show', $row['supplier']) }}" style="font-weight:600;color:#1d4ed8;text-decoration:none;">{{ $row['supplier']->name }}</a></td>
                    <td>{{ $row['supplier']->phone ?? '—' }}</td>
                    <td>{{ $row['oldest_due'] ? \Carbon\Carbon::parse($row['oldest_due'])->format('d M Y') : '—' }}</td>
                    <td><span class="badge bg-{{ $color === 'orange' ? 'warning' : $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('supplier-payments.create', ['supplier_id' => $row['supplier']->id]) }}"
                           class="btn btn-sm btn-outline-success">
                            <i class="bi bi-cash me-1"></i>Pay
                        </a>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif
@endforeach

@endsection