@extends('layouts.admin')

@section('title', setting('school_name', 'ShulePoint') . ' | Finance Reports')
@section('page-title', 'Finance Reports')

@section('content')
{{-- Statistic widgets --}}
<div class="row stat-strip">
    <div class="col-lg-4 col-6">
        <div class="stat-mini">
            <span class="stat-icon bg-success"><i class="fas fa-hand-holding-usd"></i></span>
            <div class="stat-text">
                <strong>KES {{ number_format($totals['collection'], 0) }}</strong>
                <span>Total collection</span>
            </div>
            <a href="{{ route('finance.reports', ['type' => 'collection']) }}" class="stat-link" title="Collection report"><i class="fas fa-arrow-right"></i></a>
        </div>
    </div>
    <div class="col-lg-4 col-6">
        <div class="stat-mini">
            <span class="stat-icon bg-warning"><i class="fas fa-exclamation-circle"></i></span>
            <div class="stat-text">
                <strong>KES {{ number_format($totals['balances'], 0) }}</strong>
                <span>Outstanding balances</span>
            </div>
            <a href="{{ route('finance.reports', ['type' => 'balances']) }}" class="stat-link" title="Balances report"><i class="fas fa-arrow-right"></i></a>
        </div>
    </div>
    <div class="col-lg-4 col-6">
        <div class="stat-mini">
            <span class="stat-icon bg-danger"><i class="fas fa-user-times"></i></span>
            <div class="stat-text">
                <strong>{{ number_format($totals['defaulters'], 0) }}</strong>
                <span>Defaulters</span>
            </div>
            <a href="{{ route('finance.reports', ['type' => 'defaulters']) }}" class="stat-link" title="Defaulters report"><i class="fas fa-arrow-right"></i></a>
        </div>
    </div>
</div>

{{-- Report type switcher --}}
<div class="card card-outline card-primary shadow-sm">
    <div class="card-header">
        <h3 class="card-title"><i class="fas fa-chart-bar mr-1"></i> Finance Reports</h3>
        <div class="card-tools">
            <a href="{{ route('finance.reports', ['type' => 'collection']) }}" class="btn btn-sm {{ $type === 'collection' ? 'btn-primary' : 'btn-outline-secondary' }}">Collection</a>
            <a href="{{ route('finance.reports', ['type' => 'balances']) }}" class="btn btn-sm {{ $type === 'balances' ? 'btn-primary' : 'btn-outline-secondary' }}">Balances</a>
            <a href="{{ route('finance.reports', ['type' => 'defaulters']) }}" class="btn btn-sm {{ $type === 'defaulters' ? 'btn-primary' : 'btn-outline-secondary' }}">Defaulters</a>
            <a href="{{ route('finance.reports.pdf', ['type' => $type, 'term_id' => $termId]) }}" class="btn btn-sm btn-outline-danger"><i class="fas fa-file-pdf mr-1"></i> PDF</a>
            <button type="button" class="btn btn-sm btn-outline-secondary" onclick="window.print()"><i class="fas fa-print mr-1"></i> Print</button>
        </div>
    </div>
</div>

@if($type === 'collection')
{{-- Collection by method --}}
<div class="card shadow-sm learner-card">
    <div class="card-header">
        <h3 class="card-title"><i class="fas fa-hand-holding-usd mr-1"></i> Collection by method
            <small class="text-muted ml-1">KES {{ number_format($totals['collection'], 0) }} total</small>
        </h3>
    </div>
    <div class="card-body table-responsive p-0">
        <table class="table learner-table table-hover text-nowrap mb-0">
            <thead>
                <tr>
                    <th>Method</th>
                    <th>Count</th>
                    <th>Total</th>
                </tr>
            </thead>
            <tbody>
                @forelse($collection as $c)
                    <tr>
                        <td><span class="class-pill">{{ $c->method }}</span></td>
                        <td>{{ $c->n }}</td>
                        <td class="font-weight-600">KES {{ number_format($c->total, 0) }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="3" class="text-center py-5">
                            <i class="fas fa-hand-holding-usd fa-3x text-muted mb-3"></i>
                            <p class="font-weight-bold mb-1">No collections yet</p>
                            <p class="text-muted small mb-0">Payments grouped by method will appear here.</p>
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endif

@if($type === 'balances')
{{-- Outstanding balances --}}
<div class="card shadow-sm learner-card">
    <div class="card-header">
        <h3 class="card-title"><i class="fas fa-exclamation-circle mr-1"></i> Outstanding balances
            <small class="text-muted ml-1">KES {{ number_format($totals['balances'], 0) }} total</small>
        </h3>
    </div>
    <div class="card-body table-responsive p-0">
        <table class="table learner-table table-hover text-nowrap mb-0">
            <thead>
                <tr>
                    <th>Invoice</th>
                    <th>Learner</th>
                    <th>Balance</th>
                </tr>
            </thead>
            <tbody>
                @forelse($balances as $b)
                    <tr>
                        <td><a href="{{ route('finance.invoices.show', $b) }}" class="learner-name">{{ $b->invoice_no }}</a></td>
                        <td>@if($b->learner)<span class="learner-name">{{ $b->learner->first_name }} {{ $b->learner->last_name }}</span> <span class="adm-chip ml-1">{{ $b->learner->admission_no }}</span>@else<span class="text-muted">#{{ $b->learner_id }}</span>@endif</td>
                        <td class="font-weight-600">KES {{ number_format($b->balance, 0) }}</td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="3" class="text-center py-5">
                            <i class="fas fa-check-circle fa-3x text-muted mb-3"></i>
                            <p class="font-weight-bold mb-1">No outstanding balances</p>
                            <p class="text-muted small mb-0">All invoices are fully paid.</p>
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>
@endif

@if($type === 'defaulters')
{{-- Defaulters --}}
<div class="card shadow-sm learner-card">
    <div class="card-header">
        <h3 class="card-title"><i class="fas fa-user-times mr-1"></i> Defaulters
            <small class="text-muted ml-1">{{ number_format($defaulters->total()) }} total</small>
        </h3>
    </div>
    <div class="card-body table-responsive p-0">
        <table class="table learner-table table-hover text-nowrap mb-0">
            <thead>
                <tr>
                    <th>Invoice</th>
                    <th>Learner</th>
                    <th>Balance</th>
                    <th>Status</th>
                </tr>
            </thead>
            <tbody>
                @forelse($defaulters as $d)
                    <tr>
                        <td><a href="{{ route('finance.invoices.show', $d) }}" class="learner-name">{{ $d->invoice_no }}</a></td>
                        <td>@if($d->learner)<span class="learner-name">{{ $d->learner->first_name }} {{ $d->learner->last_name }}</span> <span class="adm-chip ml-1">{{ $d->learner->admission_no }}</span>@else<span class="text-muted">#{{ $d->learner_id }}</span>@endif</td>
                        <td class="font-weight-600">KES {{ number_format($d->balance, 0) }}</td>
                        <td><span class="status-pill warn"><span class="dot"></span>{{ ucfirst($d->status) }}</span></td>
                    </tr>
                @empty
                    <tr>
                        <td colspan="4" class="text-center py-5">
                            <i class="fas fa-user-check fa-3x text-muted mb-3"></i>
                            <p class="font-weight-bold mb-1">No defaulters</p>
                            <p class="text-muted small mb-0">Every learner is up to date on fees.</p>
                        </td>
                    </tr>
                @endforelse
            </tbody>
        </table>
    </div>
    <div class="card-footer d-flex justify-content-between align-items-center flex-wrap">
        <small class="text-muted">Page {{ $defaulters->currentPage() }} of {{ $defaulters->lastPage() }} · {{ number_format($defaulters->total()) }} total</small>
        <div class="mb-0">{{ $defaulters->appends(['type' => $type])->links() }}</div>
    </div>
</div>
@endif
@endsection