@extends('dashboard.admin.layouts.master')

@section('content')
    <div class="d-flex flex-column flex-column-fluid">
        <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
            <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
                <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                    <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">{{ trans('sales.reports.aging_title') }}</h1>
                </div>
            </div>
        </div>

        <div id="kt_app_content" class="app-content flex-column-fluid">
            <div id="kt_app_content_container" class="app-container container-xxl">

                <div class="card mb-7">
                    <div class="card-body py-5">
                        <form method="GET" action="{{ route('admin.dashboard.sales.reports.aging') }}" class="row g-4 align-items-end">
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('sales.reports.customer') }}</label>
                                <select name="customer_id" data-control="select2" data-allow-clear="true" data-placeholder="{{ trans('sales.reports.customer_placeholder') }}" class="form-select">
                                    <option></option>
                                    @foreach($customers as $customer)
                                        <option value="{{ $customer->id }}" @selected(($selectedFilters['customer_id'] ?? '') == $customer->id)>{{ $customer->code }} - {{ $customer->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('sales.reports.branch') }}</label>
                                <select name="branch_id" data-control="select2" data-allow-clear="true" data-placeholder="{{ trans('sales.reports.branch_placeholder') }}" class="form-select">
                                    <option></option>
                                    @foreach($branches as $branch)
                                        <option value="{{ $branch->id }}" @selected(($selectedFilters['branch_id'] ?? '') == $branch->id)>{{ $branch->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <button type="submit" class="btn btn-primary">{{ trans('sales.reports.apply') }}</button>
                            </div>
                        </form>
                    </div>
                </div>

                <div class="card">
                    <div class="card-body py-4">
                        <div class="table-responsive">
                            <table class="table align-middle table-row-dashed fs-7 gy-4">
                                <thead>
                                <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                    <th>{{ trans('sales.reports.customer') }}</th>
                                    <th>{{ trans('sales.reports.invoice_number') }}</th>
                                    <th>{{ trans('sales.reports.invoice_date') }}</th>
                                    <th>{{ trans('sales.reports.due_date') }}</th>
                                    <th>{{ trans('sales.reports.total_amount') }}</th>
                                    <th>{{ trans('sales.reports.paid_amount') }}</th>
                                    <th>{{ trans('sales.reports.balance') }}</th>
                                    <th>{{ trans('sales.reports.days_overdue') }}</th>
                                    <th>{{ trans('sales.reports.current') }}</th>
                                    <th>{{ trans('sales.reports.bucket_1_30') }}</th>
                                    <th>{{ trans('sales.reports.bucket_31_60') }}</th>
                                    <th>{{ trans('sales.reports.bucket_61_90') }}</th>
                                    <th>{{ trans('sales.reports.bucket_over_90') }}</th>
                                </tr>
                                </thead>
                                <tbody class="text-gray-600 fw-semibold">
                                @forelse($rows as $row)
                                    <tr>
                                        <td>{{ $row->customer_code }} — {{ $row->customer_name }}</td>
                                        <td>{{ $row->invoice_number }}</td>
                                        <td>{{ $row->invoice_date }}</td>
                                        <td>{{ $row->due_date }}</td>
                                        <td>{{ number_format($row->total_amount, 2) }}</td>
                                        <td>{{ number_format($row->paid_amount, 2) }}</td>
                                        <td class="fw-bold">{{ number_format($row->balance, 2) }}</td>
                                        <td>
                                            @if($row->days_overdue > 0)
                                                <span class="badge badge-light-danger">{{ $row->days_overdue }}</span>
                                            @else
                                                <span class="badge badge-light-success">{{ trans('sales.reports.current') }}</span>
                                            @endif
                                        </td>
                                        <td>{{ $row->aging_bucket === 'current' ? number_format($row->balance, 2) : '-' }}</td>
                                        <td>{{ $row->aging_bucket === '1_30' ? number_format($row->balance, 2) : '-' }}</td>
                                        <td>{{ $row->aging_bucket === '31_60' ? number_format($row->balance, 2) : '-' }}</td>
                                        <td>{{ $row->aging_bucket === '61_90' ? number_format($row->balance, 2) : '-' }}</td>
                                        <td>{{ $row->aging_bucket === 'over_90' ? number_format($row->balance, 2) : '-' }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="13" class="text-center py-10 text-muted">{{ trans('sales.reports.no_data') }}</td>
                                    </tr>
                                @endforelse
                                </tbody>
                                @if($rows->isNotEmpty())
                                    <tfoot class="fw-bold fs-6">
                                    <tr>
                                        <td colspan="6" class="text-end">{{ trans('sales.reports.balance') }}</td>
                                        <td>{{ number_format($rows->sum('balance'), 2) }}</td>
                                        <td></td>
                                        <td>{{ number_format($rows->where('aging_bucket', 'current')->sum('balance'), 2) }}</td>
                                        <td>{{ number_format($rows->where('aging_bucket', '1_30')->sum('balance'), 2) }}</td>
                                        <td>{{ number_format($rows->where('aging_bucket', '31_60')->sum('balance'), 2) }}</td>
                                        <td>{{ number_format($rows->where('aging_bucket', '61_90')->sum('balance'), 2) }}</td>
                                        <td>{{ number_format($rows->where('aging_bucket', 'over_90')->sum('balance'), 2) }}</td>
                                    </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>

            </div>
        </div>
    </div>
@endsection