@extends('layouts.finance')

@section('title', 'Students')
@section('subtitle', 'Enrolled students and outstanding tuition')

@section('content')
    <section class="card mb">
        <div class="section-head">
            <h2>Students</h2>
            <a class="btn btn-primary" href="{{ route('students.create') }}">+ Add Student</a>
        </div>
        <div class="card-pad">
            <form method="GET" action="{{ route('students') }}" class="row-form">
                <div>
                    <label class="label">Search</label>
                    <input class="field" name="q" value="{{ request('q') }}" placeholder="Name, code, email or phone">
                </div>
                <div>
                    <label class="label">Status</label>
                    <select class="field" name="status">
                        <option value="">All</option>
                        @foreach($statuses as $status)
                            <option value="{{ $status }}" @selected(request('status') === $status)>{{ ucfirst($status) }}</option>
                        @endforeach
                    </select>
                </div>
                <button class="btn">Filter</button>
            </form>
        </div>
    </section>

    <section class="card">
        <table>
            <thead>
            <tr>
                <th>Student</th>
                <th>Contact</th>
                <th>Active Courses</th>
                <th>Status</th>
                <th class="right">Outstanding</th>
                <th></th>
            </tr>
            </thead>
            <tbody>
            @forelse($students as $student)
                <tr>
                    <td>
                        <a href="{{ route('students.show', $student) }}"><strong>{{ $student->name }}</strong></a>
                        @if($student->student_code)
                            <div class="muted text-xs">{{ $student->student_code }}</div>
                        @endif
                    </td>
                    <td>
                        <div>{{ $student->phone ?: '—' }}</div>
                        <div class="muted text-xs">{{ $student->email }}</div>
                    </td>
                    <td>
                        @forelse($student->activeEnrollments as $enrollment)
                            <div>{{ $enrollment->course?->name }}
                                <span class="muted text-xs">{{ $enrollment->currency }} {{ number_format((float) $enrollment->monthly_fee, 2) }}/mo</span>
                            </div>
                        @empty
                            <span class="muted">No active enrollment</span>
                        @endforelse
                    </td>
                    <td>{{ ucfirst($student->status) }}</td>
                    <td class="right">
                        @forelse($outstandingByStudent->get($student->id, collect()) as $row)
                            <div>{{ $row->currency }} {{ number_format((float) $row->total, 2) }}</div>
                        @empty
                            <span class="muted">—</span>
                        @endforelse
                    </td>
                    <td class="actions">
                        <a class="btn btn-sm" href="{{ route('students.show', $student) }}">Open</a>
                        <a class="btn btn-sm" href="{{ route('students.edit', $student) }}">Edit</a>
                    </td>
                </tr>
            @empty
                <tr><td colspan="6" class="muted">No students yet. Add one to get started.</td></tr>
            @endforelse
            </tbody>
        </table>
        <div class="card-pad">{{ $students->links() }}</div>
    </section>
@endsection