@extends('layouts.inspinia')

@section('title', 'Supplier Aging Report')

@section('content_header', 'Supplier Aging Report')

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.aging.index') }}">Aging Overview</a></li>
    <li class="breadcrumb-item active"><strong>Supplier Aging</strong></li>
@endsection

@section('content')

<div class="alert alert-secondary border-left border-secondary py-2 mb-3">
    <i class="fas fa-info-circle mr-1"></i>
    <strong>Operational aging report — not full accounting GL.</strong>
    Supplier invoices are tracked in base currency (TZS). This report shows how long payables have been outstanding.
</div>

@php
    $bucketColors = [
        'current' => 'success',
        '1_30'    => 'info',
        '31_60'   => 'warning',
        '61_90'   => 'orange',
        '90_plus' => 'danger',
    ];
@endphp

{{-- Filters --}}
<div class="card card-outline card-success">
    <div class="card-header"><h5 class="card-title mb-0"><i class="fas fa-filter mr-1"></i>Filters</h5></div>
    <div class="card-body py-2">
        <form method="GET" action="{{ route('accounting-reports.supplier-aging') }}">
            <div class="row align-items-end">
                <div class="col-md-2">
                    <div class="form-group mb-0">
                        <label class="mb-1">As-Of Date</label>
                        <input type="date" name="as_of_date" class="form-control form-control-sm"
                               value="{{ $asOfDate->toDateString() }}">
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group mb-0">
                        <label class="mb-1">Supplier</label>
                        <select name="supplier_id" class="form-control form-control-sm">
                            <option value="">All Suppliers</option>
                            @foreach($suppliers as $sup)
                                <option value="{{ $sup->id }}"
                                    {{ request('supplier_id') == $sup->id ? 'selected' : '' }}>
                                    {{ $sup->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-sm btn-primary">
                        <i class="fas fa-filter mr-1"></i>Apply
                    </button>
                    <a href="{{ route('accounting-reports.supplier-aging') }}" class="btn btn-sm btn-secondary ml-1">
                        <i class="fas fa-times mr-1"></i>Clear
                    </a>
                    <a href="{{ route('accounting-reports.aging.index', ['as_of_date' => $asOfDate->toDateString()]) }}"
                       class="btn btn-sm btn-outline-secondary ml-1">
                        <i class="fas fa-arrow-left mr-1"></i>Overview
                    </a>
                </div>
            </div>
        </form>
    </div>
</div>

{{-- Totals Summary Bar --}}
<div class="row">
    @foreach(['current' => 'Current', '1_30' => '1–30 Days', '31_60' => '31–60 Days', '61_90' => '61–90 Days', '90_plus' => '90+ Days'] as $key => $label)
    <div class="col-md-2 col-sm-4 col-6">
        <div class="info-box shadow-sm">
            <span class="info-box-icon bg-{{ $bucketColors[$key] }}"><i class="fas fa-clock"></i></span>
            <div class="info-box-content">
                <span class="info-box-text">{{ $label }}</span>
                <span class="info-box-number" style="font-size:13px;">TZS {{ number_format($totals[$key], 0) }}</span>
            </div>
        </div>
    </div>
    @endforeach
    <div class="col-md-2 col-sm-4 col-6">
        <div class="info-box shadow-sm bg-dark">
            <span class="info-box-icon"><i class="fas fa-coins"></i></span>
            <div class="info-box-content">
                <span class="info-box-text text-white">Total Payable</span>
                <span class="info-box-number text-white" style="font-size:13px;">TZS {{ number_format($totals['total_balance'], 0) }}</span>
            </div>
        </div>
    </div>
</div>

{{-- Supplier Summary Table --}}
<div class="card">
    <div class="card-header">
        <h5 class="card-title mb-0">
            Supplier Summary — As of {{ $asOfDate->format('d M Y') }}
            <small class="text-muted ml-2">(all amounts in TZS)</small>
        </h5>
        <div class="card-tools">
            <span class="badge badge-secondary">{{ $supplierRows->count() }} supplier(s)</span>
        </div>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-bordered table-hover table-sm mb-0">
                <thead class="thead-light">
                <tr>
                    <th>#</th>
                    <th>Supplier</th>
                    <th class="text-right text-success">Current</th>
                    <th class="text-right text-info">1–30 Days</th>
                    <th class="text-right text-warning">31–60 Days</th>
                    <th class="text-right" style="color:#fd7e14;">61–90 Days</th>
                    <th class="text-right text-danger">90+ Days</th>
                    <th class="text-right font-weight-bold">Total Payable (TZS)</th>
                </tr>
                </thead>
                <tbody>
                @forelse($supplierRows as $i => $row)
                    <tr class="{{ $row['90_plus'] > 0 ? 'table-danger' : ($row['61_90'] > 0 ? 'table-warning' : '') }}">
                        <td>{{ $i + 1 }}</td>
                        <td><strong>{{ $row['supplier']?->name ?? '—' }}</strong></td>
                        <td class="text-right">
                            @if($row['current'] > 0)
                                <span class="text-success">{{ number_format($row['current'], 0) }}</span>
                            @else<span class="text-muted">—</span>@endif
                        </td>
                        <td class="text-right">
                            @if($row['1_30'] > 0)
                                <span class="text-info">{{ number_format($row['1_30'], 0) }}</span>
                            @else<span class="text-muted">—</span>@endif
                        </td>
                        <td class="text-right">
                            @if($row['31_60'] > 0)
                                <span class="text-warning">{{ number_format($row['31_60'], 0) }}</span>
                            @else<span class="text-muted">—</span>@endif
                        </td>
                        <td class="text-right">
                            @if($row['61_90'] > 0)
                                <span style="color:#fd7e14;">{{ number_format($row['61_90'], 0) }}</span>
                            @else<span class="text-muted">—</span>@endif
                        </td>
                        <td class="text-right">
                            @if($row['90_plus'] > 0)
                                <span class="text-danger font-weight-bold">{{ number_format($row['90_plus'], 0) }}</span>
                            @else<span class="text-muted">—</span>@endif
                        </td>
                        <td class="text-right font-weight-bold">{{ number_format($row['total_balance'], 0) }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="8" class="text-center text-muted py-3">No outstanding supplier invoices found.</td>
                    </tr>
                @endforelse
                </tbody>
                @if($supplierRows->count() > 0)
                <tfoot class="bg-light font-weight-bold">
                    <tr>
                        <td colspan="2">TOTAL (TZS)</td>
                        <td class="text-right text-success">{{ number_format($totals['current'], 0) }}</td>
                        <td class="text-right text-info">{{ number_format($totals['1_30'], 0) }}</td>
                        <td class="text-right text-warning">{{ number_format($totals['31_60'], 0) }}</td>
                        <td class="text-right" style="color:#fd7e14;">{{ number_format($totals['61_90'], 0) }}</td>
                        <td class="text-right text-danger">{{ number_format($totals['90_plus'], 0) }}</td>
                        <td class="text-right">{{ number_format($totals['total_balance'], 0) }}</td>
                    </tr>
                </tfoot>
                @endif
            </table>
        </div>
    </div>
</div>

{{-- Invoice Detail Table --}}
<div class="card">
    <div class="card-header">
        <h5 class="card-title mb-0">Invoice Detail</h5>
        <div class="card-tools">
            <span class="badge badge-secondary">{{ $invoices->count() }} invoice(s)</span>
        </div>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-bordered table-hover table-sm mb-0">
                <thead class="thead-light">
                <tr>
                    <th>#</th>
                    <th>Invoice #</th>
                    <th>Supplier</th>
                    <th>Invoice Date</th>
                    <th>Due / Aging Date</th>
                    <th class="text-right">Total Amount</th>
                    <th class="text-right">Amount Paid</th>
                    <th class="text-right">Balance Due</th>
                    <th class="text-right">Days Overdue</th>
                    <th>Bucket</th>
                </tr>
                </thead>
                <tbody>
                @forelse($invoices as $i => $inv)
                    @php
                        $bucketLabel = match($inv->bucket) {
                            'current'  => 'Current',
                            '1_30'     => '1–30 Days',
                            '31_60'    => '31–60 Days',
                            '61_90'    => '61–90 Days',
                            '90_plus'  => '90+ Days',
                            default    => $inv->bucket,
                        };
                        $badgeColor = $bucketColors[$inv->bucket] ?? 'secondary';
                    @endphp
                    <tr>
                        <td>{{ $i + 1 }}</td>
                        <td class="font-monospace">{{ $inv->supplier_invoice_number }}</td>
                        <td>{{ $inv->supplier?->name ?? '—' }}</td>
                        <td>{{ $inv->invoice_date?->format('d-m-Y') ?? '—' }}</td>
                        <td>
                            {{ $inv->aging_date?->format('d-m-Y') ?? '—' }}
                            @if(!$inv->due_date)
                                <small class="text-muted">(inv.date)</small>
                            @endif
                        </td>
                        <td class="text-right">{{ number_format($inv->total_amount, 2) }}</td>
                        <td class="text-right">{{ number_format($inv->amount_paid, 2) }}</td>
                        <td class="text-right font-weight-bold">{{ number_format($inv->balance_due, 2) }}</td>
                        <td class="text-right">
                            @if($inv->days_overdue > 0)
                                <span class="text-danger font-weight-bold">{{ $inv->days_overdue }}</span>
                            @elseif($inv->days_overdue == 0)
                                <span class="text-success">0</span>
                            @else
                                <span class="text-muted">{{ abs($inv->days_overdue) }} left</span>
                            @endif
                        </td>
                        <td>
                            <span class="badge badge-{{ $badgeColor }}">{{ $bucketLabel }}</span>
                        </td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="10" class="text-center text-muted py-3">No invoices found.</td>
                    </tr>
                @endforelse
                </tbody>
            </table>
        </div>
    </div>
    <div class="card-footer text-muted" style="font-size:12px;">
        <i class="fas fa-info-circle mr-1"></i>
        Aging date uses <strong>due date</strong> where set, otherwise falls back to invoice date.
        Only posted invoices with balance &gt; 0 are included.
    </div>
</div>

@endsection