@extends('master.app')
@section('title', 'Customer Aging Report')

@section('pageCSS')
<style>
    .hero{
        border-radius:16px;
        padding:16px 18px;
        background: linear-gradient(135deg, #0d6efd, #4f46e5);
        color:#fff;
        position:relative;
        overflow:hidden;
    }
    .hero:before{
        content:"";
        position:absolute;
        width:220px;height:220px;border-radius:999px;
        right:-70px;top:-70px;
        background:rgba(255,255,255,.15);
    }
    .kpi{
        border:1px solid #e9ecef;
        border-radius:14px;
        background:#fff;
        padding:12px 14px;
        box-shadow:0 1px 2px rgba(0,0,0,.04);
        height:100%;
    }
    .kpi .label{ font-size:12px; color:#6c757d; }
    .kpi .value{ font-size:18px; font-weight:900; }
    .pill{
        display:inline-block;
        padding:4px 10px;
        border-radius:999px;
        font-size:12px;
        background:#f1f3f5;
    }

    @media print{
        .no-print{ display:none !important; }
        .card{ box-shadow:none !important; border:none !important; }
        body{ background:#fff !important; }
        table{ font-size:12px !important; }
        .table thead th{ background:#f2f2f2 !important; -webkit-print-color-adjust:exact; }
    }
</style>
@endsection

@section('body')
<main class="app-content">

    <div class="card shadow-sm">
        <div class="card-body">

            <div class="hero mb-3 d-flex justify-content-between align-items-start">
                <div>
                    <h4 class="mb-1">
                        <i class="fa fa-hourglass-half me-2"></i> Customer Aging Report
                    </h4>
                    <div class="opacity-75">
                        Outstanding invoices grouped by age buckets (As Of: <b>{{ $asOf }}</b>)
                    </div>
                    @if($info && $info->business_name)
                        <div class="mt-2">
                            <span class="pill"><i class="fa fa-building me-1"></i> {{ $info->business_name }}</span>
                        </div>
                    @endif
                </div>

                <div class="no-print d-flex gap-2">
                    <a href="{{ route('customer_aging_report.index') }}" class="btn btn-sm btn-light">
                        <i class="fa fa-rotate-left me-1"></i> Reset
                    </a>

                    <a href="{{ route('customer_aging_report.index', array_merge(request()->query(), ['print'=>1])) }}"
                       class="btn btn-sm btn-outline-light">
                        <i class="fa fa-print me-1"></i> Print View
                    </a>

                    <button onclick="window.print()" class="btn btn-sm btn-dark">
                        <i class="fa fa-print me-1"></i> Print
                    </button>
                </div>
            </div>

            {{-- Filters --}}
            <form method="GET" action="{{ route('customer_aging_report.index') }}" class="row g-2 mb-3 no-print">
                <div class="col-md-4">
                    <label class="form-label">Customer</label>
                    <select name="customer_id" class="form-select">
                        <option value="all">All</option>
                        @foreach($customers as $c)
                            <option value="{{ $c->id }}" {{ request('customer_id') == $c->id ? 'selected' : '' }}>
                                {{ $c->name }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">Currency</label>
                    <select name="currency_id" class="form-select">
                        <option value="all">All</option>
                        @foreach($currencies as $cur)
                            <option value="{{ $cur->id }}" {{ request('currency_id') == $cur->id ? 'selected' : '' }}>
                                {{ $cur->title_en }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">As Of Date</label>
                    <input type="date" name="as_of_date" value="{{ request('as_of_date', $asOf) }}" class="form-control">
                </div>

                <div class="col-md-2 d-flex align-items-end">
                    <div class="form-check">
                        <input class="form-check-input" type="checkbox" name="include_zero" value="1" id="inc0"
                               {{ request('include_zero') ? 'checked' : '' }}>
                        <label class="form-check-label" for="inc0">
                            Include Zero Balance
                        </label>
                    </div>
                </div>

                <div class="col-md-2 d-grid">
                    <label class="form-label">&nbsp;</label>
                    <button class="btn btn-primary">
                        <i class="fa fa-magnifying-glass me-1"></i> Search
                    </button>
                </div>
            </form>

            {{-- KPI --}}
            <div class="row g-2 mb-3">
                <div class="col-md-2">
                    <div class="kpi">
                        <div class="label">0 - 30 Days</div>
                        <div class="value text-success">{{ number_format($kpi->b0_30, 2) }}</div>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="kpi">
                        <div class="label">31 - 60 Days</div>
                        <div class="value text-warning">{{ number_format($kpi->b31_60, 2) }}</div>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="kpi">
                        <div class="label">61 - 90 Days</div>
                        <div class="value text-danger">{{ number_format($kpi->b61_90, 2) }}</div>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="kpi">
                        <div class="label">90+ Days</div>
                        <div class="value text-danger">{{ number_format($kpi->b90_plus, 2) }}</div>
                    </div>
                </div>
                <div class="col-md-4">
                    <div class="kpi">
                        <div class="label">Total Outstanding</div>
                        <div class="value">{{ number_format($kpi->total, 2) }}</div>
                        <div class="text-muted mt-1" style="font-size:12px;">
                            <i class="fa fa-circle-info me-1"></i> Based on invoice balances.
                        </div>
                    </div>
                </div>
            </div>

            {{-- Currency Totals (useful when all currency) --}}
            @if(request('currency_id','all') === 'all')
                <div class="table-responsive mb-3">
                    <table class="table table-bordered table-sm align-middle">
                        <thead class="table-light">
                            <tr>
                                <th>Currency</th>
                                <th class="text-end">0-30</th>
                                <th class="text-end">31-60</th>
                                <th class="text-end">61-90</th>
                                <th class="text-end">90+</th>
                                <th class="text-end">Total</th>
                            </tr>
                        </thead>
                        <tbody>
                            @foreach($totalsByCurrency as $t)
                                @if($t['total'] > 0)
                                    <tr>
                                        <td><b>{{ $t['currency'] }}</b></td>
                                        <td class="text-end">{{ number_format($t['b0_30'],2) }}</td>
                                        <td class="text-end">{{ number_format($t['b31_60'],2) }}</td>
                                        <td class="text-end">{{ number_format($t['b61_90'],2) }}</td>
                                        <td class="text-end">{{ number_format($t['b90_plus'],2) }}</td>
                                        <td class="text-end fw-bold">{{ number_format($t['total'],2) }}</td>
                                    </tr>
                                @endif
                            @endforeach
                            @if(collect($totalsByCurrency)->sum('total') <= 0)
                                <tr><td colspan="6" class="text-center text-muted">No totals</td></tr>
                            @endif
                        </tbody>
                    </table>
                </div>
            @endif

            {{-- Summary Table --}}
            <div class="table-responsive">
                <table class="table table-bordered table-sm align-middle">
                    <thead class="table-light">
                        <tr>
                            <th style="width:60px;">#</th>
                            <th>Customer</th>
                            <th style="width:90px;">CUR</th>
                            <th class="text-end" style="width:130px;">0-30</th>
                            <th class="text-end" style="width:130px;">31-60</th>
                            <th class="text-end" style="width:130px;">61-90</th>
                            <th class="text-end" style="width:130px;">90+</th>
                            <th class="text-end" style="width:140px;">Total</th>
                            <th class="text-center no-print" style="width:120px;">Action</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($rows as $i => $r)
                            @php
                                $custName = $customerNames[$r->customer_id] ?? 'Unknown';
                                $curName  = $currencyNames[$r->currency_id] ?? '-';
                            @endphp
                            <tr>
                                <td>{{ method_exists($rows,'firstItem') ? $rows->firstItem() + $i : ($i+1) }}</td>
                                <td class="fw-bold">{{ $custName }}</td>
                                <td>{{ $curName }}</td>

                                <td class="text-end text-success fw-bold">{{ number_format((float)$r->b0_30, 2) }}</td>
                                <td class="text-end text-warning fw-bold">{{ number_format((float)$r->b31_60, 2) }}</td>
                                <td class="text-end text-danger fw-bold">{{ number_format((float)$r->b61_90, 2) }}</td>
                                <td class="text-end text-danger fw-bold">{{ number_format((float)$r->b90_plus, 2) }}</td>

                                <td class="text-end fw-bold">{{ number_format((float)$r->total_outstanding, 2) }}</td>

                                <td class="text-center no-print">
                                    <a class="btn btn-sm btn-outline-primary"
                                       href="{{ route('customer_aging_report.index', array_merge(request()->query(), ['customer_id'=>$r->customer_id])) }}">
                                        <i class="fa fa-eye me-1"></i> Details
                                    </a>
                                </td>
                            </tr>
                        @empty
                            <tr><td colspan="9" class="text-center text-muted">No data found</td></tr>
                        @endforelse
                    </tbody>

                    {{-- Footer Totals --}}
                    <tfoot class="table-light">
                        <tr>
                            <th colspan="3" class="text-end">Grand Total</th>
                            <th class="text-end">{{ number_format($kpi->b0_30,2) }}</th>
                            <th class="text-end">{{ number_format($kpi->b31_60,2) }}</th>
                            <th class="text-end">{{ number_format($kpi->b61_90,2) }}</th>
                            <th class="text-end">{{ number_format($kpi->b90_plus,2) }}</th>
                            <th class="text-end">{{ number_format($kpi->total,2) }}</th>
                            <th class="no-print"></th>
                        </tr>
                    </tfoot>
                </table>
            </div>

            {{-- Pagination --}}
            @if(! $isPrint && method_exists($rows, 'links'))
                <div class="mt-2 no-print">
                    {{ $rows->links('pagination::bootstrap-4') }}
                </div>
            @endif

            {{-- Details Invoices (only when a single customer selected) --}}
            @if($customerId)
                <hr class="my-3">

                <div class="d-flex justify-content-between align-items-center">
                    <h6 class="mb-0">
                        <i class="fa fa-file-invoice me-2"></i> Invoice Details (Selected Customer)
                    </h6>
                    <div class="text-muted" style="font-size:12px;">
                        Showing invoices with invoice_date <= {{ $asOf }}
                    </div>
                </div>

                <div class="table-responsive mt-2">
                    <table class="table table-bordered table-sm align-middle">
                        <thead class="table-light">
                            <tr>
                                <th style="width:60px;">#</th>
                                <th style="width:110px;">Date</th>
                                <th style="width:120px;">Invoice #</th>
                                <th>Title</th>
                                <th style="width:90px;">CUR</th>
                                <th class="text-end" style="width:140px;">Final</th>
                                <th class="text-end" style="width:140px;">Received</th>
                                <th class="text-end" style="width:140px;">Balance</th>
                                <th class="text-end" style="width:90px;">Age</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $asOfCarbon = \Carbon\Carbon::parse($asOf);
                            @endphp

                            @forelse($details as $k => $b)
                                @php
                                    $age = $asOfCarbon->diffInDays(\Carbon\Carbon::parse($b->invoice_date));
                                @endphp
                                <tr>
                                    <td>{{ $k+1 }}</td>
                                    <td>{{ $b->invoice_date }}</td>
                                    <td class="fw-bold">{{ $b->invoice_number }}</td>
                                    <td>{{ $b->title }}</td>
                                    <td>{{ optional($b->currency)->title_en }}</td>
                                    <td class="text-end">{{ number_format((float)$b->final_amount,2) }}</td>
                                    <td class="text-end">{{ number_format((float)$b->received,2) }}</td>
                                    <td class="text-end fw-bold">{{ number_format((float)$b->balance,2) }}</td>
                                    <td class="text-end">
                                        <span class="badge bg-secondary">{{ $age }}d</span>
                                    </td>
                                </tr>
                            @empty
                                <tr><td colspan="9" class="text-center text-muted">No invoices</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            @endif

        </div>
    </div>

</main>
@endsection