@extends('layouts.inspinia')

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

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

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item active"><strong>Supplier Payments</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>Read-only report.</strong>
    Shows posted supplier payments only.
</div>

{{-- Filter Form --}}
<div class="card card-outline card-danger">
    <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-payments') }}">
            <div class="row">
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">From Date</label>
                        <input type="date" name="from_date" class="form-control form-control-sm" value="{{ $from }}">
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">To Date</label>
                        <input type="date" name="to_date" class="form-control form-control-sm" value="{{ $to }}">
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Supplier</label>
                        <select name="supplier_id" class="form-control form-control-sm">
                            <option value="">All Suppliers</option>
                            @foreach($suppliers as $s)
                                <option value="{{ $s->id }}" {{ request('supplier_id') == $s->id ? 'selected' : '' }}>{{ $s->name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-2">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Payment Method</label>
                        <select name="payment_method" class="form-control form-control-sm">
                            <option value="">All Methods</option>
                            @foreach($paymentMethods as $pm)
                                <option value="{{ $pm }}" {{ request('payment_method') === $pm ? 'selected' : '' }}>{{ ucfirst(str_replace('_', ' ', $pm)) }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>
                <div class="col-md-3">
                    <div class="form-group mb-2">
                        <label class="mb-1 small">Search</label>
                        <input type="text" name="search" class="form-control form-control-sm"
                               placeholder="Payment # or reference" value="{{ request('search') }}">
                    </div>
                </div>
            </div>
            <button type="submit" class="btn btn-sm btn-danger"><i class="fas fa-search mr-1"></i>Apply</button>
            <a href="{{ route('accounting-reports.supplier-payments') }}" class="btn btn-sm btn-secondary ml-1"><i class="fas fa-times mr-1"></i>Reset</a>
        </form>
    </div>
</div>

{{-- Summary Cards --}}
<div class="row">
    <div class="col-md-6 col-sm-6 col-12 mb-3">
        <div class="small-box bg-danger">
            <div class="inner"><h4>{{ number_format($totalPaid, 2) }}</h4><p>Total Supplier Payments</p></div>
            <div class="icon"><i class="fas fa-money-check-alt"></i></div>
        </div>
    </div>
    <div class="col-md-6 col-sm-6 col-12 mb-3">
        <div class="small-box bg-info">
            <div class="inner"><h4>{{ $paymentCount }}</h4><p>Payment Count</p></div>
            <div class="icon"><i class="fas fa-hashtag"></i></div>
        </div>
    </div>
</div>

{{-- By Method --}}
@if($byMethod->isNotEmpty())
<div class="card card-outline card-danger mb-3">
    <div class="card-header py-2"><h6 class="card-title mb-0">Payments by Method</h6></div>
    <div class="card-body p-0">
        <table class="table table-sm table-bordered mb-0">
            <thead class="thead-light">
                <tr><th>Method</th><th class="text-right">Total Paid</th><th class="text-right">Count</th></tr>
            </thead>
            <tbody>
                @foreach($byMethod as $row)
                <tr>
                    <td>{{ ucfirst(str_replace('_', ' ', $row->payment_method ?? 'N/A')) }}</td>
                    <td class="text-right">{{ number_format($row->total, 2) }}</td>
                    <td class="text-right">{{ $row->cnt }}</td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif

{{-- Payments Table --}}
<div class="card">
    <div class="card-header py-2">
        <h5 class="card-title mb-0">
            Payment List — {{ $from }} to {{ $to }}
            <span class="badge badge-info ml-2">{{ $payments->total() }} records</span>
        </h5>
    </div>
    <div class="card-body p-0">
        @if($payments->isEmpty())
            <div class="p-4 text-center text-muted"><i class="fas fa-inbox fa-2x mb-2 d-block"></i>No payments found for the selected filters.</div>
        @else
        <div class="table-responsive">
            <table class="table table-sm table-bordered table-hover mb-0">
                <thead class="thead-light">
                    <tr>
                        <th>Payment #</th>
                        <th>Date</th>
                        <th>Supplier</th>
                        <th class="text-right">Amount Paid</th>
                        <th class="text-right">Allocated</th>
                        <th class="text-right">Unapplied</th>
                        <th>Method</th>
                        <th>Reference</th>
                        <th>Posted By</th>
                        <th>Posted At</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($payments as $p)
                    <tr>
                        <td>{{ $p->payment_number }}</td>
                        <td>{{ $p->payment_date?->format('d/m/Y') }}</td>
                        <td>{{ $p->supplier?->name }}</td>
                        <td class="text-right font-weight-bold">{{ number_format($p->paid_amount, 2) }}</td>
                        <td class="text-right">{{ number_format($p->allocated_amount, 2) }}</td>
                        <td class="text-right {{ $p->unapplied_amount > 0 ? 'text-warning' : '' }}">{{ number_format($p->unapplied_amount, 2) }}</td>
                        <td>{{ ucfirst(str_replace('_', ' ', $p->payment_method ?? 'N/A')) }}</td>
                        <td>{{ $p->payment_reference ?? '—' }}</td>
                        <td>{{ $p->postedBy?->name ?? '—' }}</td>
                        <td>{{ $p->posted_at?->format('d/m/Y H:i') ?? '—' }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="thead-light font-weight-bold">
                    <tr>
                        <td colspan="3" class="text-right">Page Totals:</td>
                        <td class="text-right">{{ number_format($payments->sum('paid_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($payments->sum('allocated_amount'), 2) }}</td>
                        <td class="text-right">{{ number_format($payments->sum('unapplied_amount'), 2) }}</td>
                        <td colspan="4"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
        <div class="p-2">{{ $payments->links() }}</div>
        @endif
    </div>
</div>

@endsection