@extends('layouts.inspinia')

@section('title', 'Debtors & Creditors Summary')

@section('content_header', 'Debtors & Creditors Summary')

@section('breadcrumb')
    <li class="breadcrumb-item"><a href="{{ route('accounting-reports.index') }}">Accounting Reports</a></li>
    <li class="breadcrumb-item active"><strong>Debtors &amp; Creditors</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>
    Balances are derived from <code>customers.current_balance</code> and <code>suppliers.current_balance</code>
    maintained by the Sales and Purchase posting engines. These are operational balances, not GL ledger accounts.
</div>

{{-- Search --}}
<div class="card card-outline card-primary">
    <div class="card-header"><h5 class="card-title mb-0"><i class="fas fa-search mr-1"></i>Search</h5></div>
    <div class="card-body py-2">
        <form method="GET" action="{{ route('accounting-reports.debtors-creditors') }}">
            <div class="row align-items-end">
                <div class="col-md-4">
                    <input type="text" name="search" class="form-control form-control-sm"
                           placeholder="Filter by customer or supplier name" value="{{ $search }}">
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-sm btn-primary"><i class="fas fa-search mr-1"></i>Filter</button>
                    <a href="{{ route('accounting-reports.debtors-creditors') }}" class="btn btn-sm btn-secondary ml-1"><i class="fas fa-times mr-1"></i>Clear</a>
                </div>
            </div>
        </form>
    </div>
</div>

{{-- Net Position Cards --}}
<div class="row">
    <div class="col-md-3 col-sm-6 col-12 mb-3">
        <div class="small-box bg-danger">
            <div class="inner">
                <h4>{{ number_format($totalReceivable, 2) }}</h4>
                <p>Total Receivable <small class="d-block">{{ $debtorCount }} customers with balance</small></p>
            </div>
            <div class="icon"><i class="fas fa-users"></i></div>
        </div>
    </div>
    <div class="col-md-3 col-sm-6 col-12 mb-3">
        <div class="small-box bg-warning">
            <div class="inner">
                <h4>{{ number_format($totalPayable, 2) }}</h4>
                <p>Total Payable <small class="d-block">{{ $creditorCount }} suppliers with balance</small></p>
            </div>
            <div class="icon"><i class="fas fa-truck"></i></div>
        </div>
    </div>
    <div class="col-md-3 col-sm-6 col-12 mb-3">
        <div class="small-box {{ $netPosition >= 0 ? 'bg-success' : 'bg-danger' }}">
            <div class="inner">
                <h4>{{ number_format($netPosition, 2) }}</h4>
                <p>Net Position {{ $netPosition >= 0 ? '(Net Receivable)' : '(Net Payable)' }}</p>
            </div>
            <div class="icon"><i class="fas fa-balance-scale"></i></div>
        </div>
    </div>
    <div class="col-md-3 col-sm-6 col-12 mb-3">
        <div class="small-box bg-info">
            <div class="inner">
                <h4>{{ $totalCustomers }} / {{ $totalSuppliers }}</h4>
                <p>Customers / Suppliers (Total)</p>
            </div>
            <div class="icon"><i class="fas fa-address-book"></i></div>
        </div>
    </div>
</div>

<div class="row">
    {{-- Top Debtors --}}
    <div class="col-md-6 mb-3">
        <div class="card card-outline card-danger">
            <div class="card-header py-2"><h6 class="card-title mb-0"><i class="fas fa-user-clock mr-1"></i>Top 10 Debtors</h6></div>
            <div class="card-body p-0">
                @if($topDebtors->isEmpty())
                    <div class="p-3 text-muted text-center small">No debtors found.</div>
                @else
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light">
                        <tr><th>#</th><th>Customer</th><th>Phone</th><th class="text-right">Balance (TZS)</th></tr>
                    </thead>
                    <tbody>
                        @foreach($topDebtors as $i => $d)
                        <tr>
                            <td>{{ $i + 1 }}</td>
                            <td>{{ $d->name }}</td>
                            <td>{{ $d->phone ?? '—' }}</td>
                            <td class="text-right font-weight-bold text-danger">{{ number_format($d->current_balance, 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>

    {{-- Top Creditors --}}
    <div class="col-md-6 mb-3">
        <div class="card card-outline card-warning">
            <div class="card-header py-2"><h6 class="card-title mb-0"><i class="fas fa-truck-moving mr-1"></i>Top 10 Creditors</h6></div>
            <div class="card-body p-0">
                @if($topCreditors->isEmpty())
                    <div class="p-3 text-muted text-center small">No creditors found.</div>
                @else
                <table class="table table-sm table-bordered mb-0">
                    <thead class="thead-light">
                        <tr><th>#</th><th>Supplier</th><th>Phone</th><th class="text-right">Balance (TZS)</th></tr>
                    </thead>
                    <tbody>
                        @foreach($topCreditors as $i => $c)
                        <tr>
                            <td>{{ $i + 1 }}</td>
                            <td>{{ $c->name }}</td>
                            <td>{{ $c->phone ?? '—' }}</td>
                            <td class="text-right font-weight-bold text-warning">{{ number_format($c->current_balance, 2) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
                @endif
            </div>
        </div>
    </div>
</div>

{{-- Full Debtor List --}}
<div class="card card-outline card-danger">
    <div class="card-header py-2">
        <h5 class="card-title mb-0">
            All Debtors (Balance &gt; 0)
            <span class="badge badge-danger ml-2">{{ $debtors->total() }} records</span>
        </h5>
    </div>
    <div class="card-body p-0">
        @if($debtors->isEmpty())
            <div class="p-4 text-center text-muted"><i class="fas fa-check-circle fa-2x mb-2 d-block text-success"></i>No outstanding customer balances.</div>
        @else
        <div class="table-responsive">
            <table class="table table-sm table-bordered table-hover mb-0">
                <thead class="thead-light">
                    <tr><th>Customer</th><th>Phone</th><th>Email</th><th class="text-right">Balance (TZS)</th></tr>
                </thead>
                <tbody>
                    @foreach($debtors as $d)
                    <tr>
                        <td>{{ $d->name }}</td>
                        <td>{{ $d->phone ?? '—' }}</td>
                        <td>{{ $d->email ?? '—' }}</td>
                        <td class="text-right text-danger font-weight-bold">{{ number_format($d->current_balance, 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
        <div class="p-2">{{ $debtors->links() }}</div>
        @endif
    </div>
</div>

{{-- Full Creditor List --}}
<div class="card card-outline card-warning mt-3">
    <div class="card-header py-2">
        <h5 class="card-title mb-0">
            All Creditors (Balance &gt; 0)
            <span class="badge badge-warning ml-2">{{ $creditors->total() }} records</span>
        </h5>
    </div>
    <div class="card-body p-0">
        @if($creditors->isEmpty())
            <div class="p-4 text-center text-muted"><i class="fas fa-check-circle fa-2x mb-2 d-block text-success"></i>No outstanding supplier balances.</div>
        @else
        <div class="table-responsive">
            <table class="table table-sm table-bordered table-hover mb-0">
                <thead class="thead-light">
                    <tr><th>Supplier</th><th>Phone</th><th>Email</th><th class="text-right">Balance (TZS)</th></tr>
                </thead>
                <tbody>
                    @foreach($creditors as $c)
                    <tr>
                        <td>{{ $c->name }}</td>
                        <td>{{ $c->phone ?? '—' }}</td>
                        <td>{{ $c->email ?? '—' }}</td>
                        <td class="text-right text-warning font-weight-bold">{{ number_format($c->current_balance, 2) }}</td>
                    </tr>
                    @endforeach
                </tbody>
            </table>
        </div>
        <div class="p-2">{{ $creditors->links() }}</div>
        @endif
    </div>
</div>

@endsection