@extends('master.app')
@section('title','Accounts Payable Summary')

@section('body')
@php $fmt = fn($n)=> number_format((float)$n,2); @endphp

@push('styles')
<style>
    html, body { overflow-x:hidden !important; }
    .app-content, main, .container-fluid { overflow-x:hidden !important; max-width:100%; }
</style>
@endpush

<main class="app-content">
    <div class="card">
        <div class="card-header d-flex justify-content-between align-items-center flex-wrap gap-2">
            <div>
                <h5 class="mb-0">Accounts Payable Summary</h5>
                <small class="text-muted">Bills - Payments - Advances (Multi Currency)</small>
            </div>
            <div class="d-flex gap-2">
                <a class="btn btn-sm btn-outline-dark" href="{{ route('reporting.ap_summary.index') }}">
                    <i class="fa fa-rotate-left"></i> Reset
                </a>
                <a target="_blank" class="btn btn-sm btn-outline-dark" href="{{ route('reporting.ap_summary.print', request()->query()) }}">
                    <i class="fa fa-print"></i> Print
                </a>
            </div>
        </div>

        <div class="card-body">

            {{-- Filters --}}
            <form method="GET" action="{{ route('reporting.ap_summary.index') }}" class="row g-2 mb-3">
                <div class="col-md-3">
                    <label class="small text-muted">Supplier</label>
                    <select name="supplier_id" class="form-control select2">
                        <option value="">All Suppliers</option>
                        @foreach($suppliers as $s)
                            <option value="{{ $s->id }}" {{ request('supplier_id')==$s->id?'selected':'' }}>
                                {{ $s->name ?? ('Supplier #'.$s->id) }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="small text-muted">Currency</label>
                    <select name="currency_id" class="form-control select2">
                        <option value="">All</option>
                        @foreach($currencies as $cur)
                            <option value="{{ $cur->id }}" {{ request('currency_id')==$cur->id?'selected':'' }}>
                                {{ $cur->title_en ?? $cur->title_ps ?? ('CUR #'.$cur->id) }}
                            </option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="small text-muted">From</label>
                    <input type="date" class="form-control" name="date_from" value="{{ request('date_from') }}">
                </div>

                <div class="col-md-2">
                    <label class="small text-muted">To</label>
                    <input type="date" class="form-control" name="date_to" value="{{ request('date_to') }}">
                </div>

                <div class="col-md-3 d-flex align-items-end gap-2">
                    <div class="form-check" style="margin-bottom:8px;">
                        <input class="form-check-input" type="checkbox" name="only_open" value="1" {{ request('only_open')==1?'checked':'' }}>
                        <label class="form-check-label fw-bold">Only Open</label>
                    </div>
                    <button class="btn btn-primary btn-sm">
                        <i class="fa fa-filter"></i> Apply
                    </button>
                </div>
            </form>

            {{-- Table --}}
            <div class="table-responsive">
                <table class="table table-bordered table-sm align-middle">
                    <thead class="table-dark">
                        <tr>
                            <th>Supplier</th>
                            <th>Currency</th>
                            <th class="text-center">Bills</th>
                            <th class="text-end">Bills Total</th>
                            <th class="text-end">Payments</th>
                            <th class="text-end">Advances</th>
                            <th class="text-end">Outstanding</th>
                            <th class="text-end">Outstanding (Base)</th>
                        </tr>
                    </thead>
                    <tbody>
                        @forelse($rows as $r)
                            @php
                                $sup = $supplierLookup[$r['supplier_id']] ?? null;
                                $cur = $currencyLookup[$r['currency_id']] ?? null;

                                $supName = $sup->name ?? ('Supplier #'.$r['supplier_id']);
                                $curName = $cur->title_en ?? $cur->title_ps ?? ('CUR #'.$r['currency_id']);
                            @endphp
                            <tr>
                                <td class="fw-bold">{{ $supName }}</td>
                                <td>{{ $curName }}</td>
                                <td class="text-center fw-bold">{{ $r['bill_count'] }}</td>
                                <td class="text-end">{{ $fmt($r['bill_total']) }}</td>
                                <td class="text-end">{{ $fmt($r['payment_total']) }}</td>
                                <td class="text-end">{{ $fmt($r['advance_total']) }}</td>
                                <td class="text-end fw-bold">{{ $fmt($r['outstanding']) }}</td>
                                <td class="text-end fw-bold">{{ $fmt($r['outstanding_base']) }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="8" class="text-center text-muted py-4">No data found.</td>
                            </tr>
                        @endforelse
                    </tbody>

                    @if(count($rows))
                        <tfoot class="table-light">
                            <tr>
                                <th colspan="3" class="text-end">Totals</th>
                                <th class="text-end">{{ $fmt($totals['bill_total'] ?? 0) }}</th>
                                <th class="text-end">{{ $fmt($totals['payment_total'] ?? 0) }}</th>
                                <th class="text-end">{{ $fmt($totals['advance_total'] ?? 0) }}</th>
                                <th class="text-end">{{ $fmt($totals['outstanding'] ?? 0) }}</th>
                                <th class="text-end">{{ $fmt($totals['outstanding_base'] ?? 0) }}</th>
                            </tr>
                        </tfoot>
                    @endif
                </table>
            </div>

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