@extends('adminlte::page')

@section('title', 'Fee Statements')

@section('content_header')
    <h1><i class="fas fa-coins"></i> Fee Statements</h1>
@stop

@section('content')
    <div class="card">
        <div class="card-header">
            <h3 class="card-title">Invoices</h3>
            <div class="card-tools">
                <form method="GET" action="{{ route('guardian.fees') }}" class="form-inline">
                    <select name="student_id" class="form-control mr-2" onchange="this.form.submit()">
                        <option value="">All Children</option>
                        @foreach($students as $student)
                            <option value="{{ $student->id }}" {{ request('student_id') == $student->id ? 'selected' : '' }}>
                                {{ $student->full_name }}
                            </option>
                        @endforeach
                    </select>
                </form>
            </div>
        </div>
        <div class="card-body table-responsive">
            <table class="table table-bordered">
    <thead>
         -
            <th>Student</th>
            <th>Bill ID</th>
            <th>Total Amount</th>
            <th>Amount Paid</th>
            <th>Balance</th>
            <th>Due Date</th>
            <th>Status</th>
         -
    </thead>
    <tbody>
        @forelse($invoices as $invoice)
            <tr>
                <td>{{ $invoice->student->full_name ?? 'N/A' }}</td>
                <td>{{ $invoice->bill_id }}</td>
                <td>${{ number_format($invoice->total_amount, 2) }}</td>
                <td>${{ number_format($invoice->amount_paid, 2) }}</td>
                <td>${{ number_format($invoice->balance, 2) }}</td>
                <td>{{ \Carbon\Carbon::parse($invoice->due_date)->format('d M Y') }}</td>
                <td>
                    @if($invoice->status == 'paid')
                        <span class="badge badge-success">Paid</span>
                    @elseif($invoice->status == 'partial')
                        <span class="badge badge-warning">Partial</span>
                    @else
                        <span class="badge badge-danger">Unpaid</span>
                    @endif
                </td>
            </tr>
        @empty
            <tr><td colspan="7" class="text-center">No fee records found.</td></tr>
        @endforelse
    </tbody>
</table>
            {{ $invoices->links() }}
        </div>
    </div>
@stop