@extends('admin.layout.app')
@section('title', $title)

@section('body')
<div class="d-flex flex-column flex-md-row align-items-start justify-content-between gap-3 mb-4">
    <div>
        <h3 class="fw-bold mb-1">{{ $title }}</h3>
        <p class="text-muted mb-0">{{ $subtitle }}</p>
    </div>
    <div class="d-flex flex-wrap gap-2">
        <a href="{{ route('reports.students.dashboard') }}" class="btn btn-outline-secondary rounded-pill">{{ __('admin.dashboard') }}</a>
        <a href="{{ route('reports.students.export', ['type' => $reportType, 'format' => 'xlsx'] + request()->query()) }}" class="btn btn-success rounded-pill">Export Excel</a>
        <a href="{{ route('reports.students.export', ['type' => $reportType, 'format' => 'csv'] + request()->query()) }}" class="btn btn-outline-success rounded-pill">Export CSV</a>
        <button type="button" onclick="window.print()" class="btn btn-outline-primary rounded-pill">{{ __('admin.print') }}</button>
    </div>
</div>

<div class="row g-3 mb-4">
    <div class="col-sm-6 col-xl-3"><div class="card border-0 shadow-sm rounded-4 h-100"><div class="card-body"><div class="text-muted small text-uppercase">{{ __('admin.report_rows') }}</div><div class="fs-3 fw-bold">{{ $cards['total'] }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card border-0 shadow-sm rounded-4 h-100"><div class="card-body"><div class="text-muted small text-uppercase">{{ __('admin.active') }}</div><div class="fs-3 fw-bold text-success">{{ $cards['active'] }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card border-0 shadow-sm rounded-4 h-100"><div class="card-body"><div class="text-muted small text-uppercase">{{ __('admin.graduated') }}</div><div class="fs-3 fw-bold text-primary">{{ $cards['graduated'] }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card border-0 shadow-sm rounded-4 h-100"><div class="card-body"><div class="text-muted small text-uppercase">{{ __('admin.suspended') }}</div><div class="fs-3 fw-bold text-danger">{{ $cards['suspended'] }}</div></div></div></div>
</div>

<div class="card border-0 shadow-sm rounded-4 mb-4">
    <div class="card-body">
        <form method="GET" class="row g-3 align-items-end">
            <div class="col-lg-3">
                <label class="form-label">{{ __('admin.search') }}</label>
                <input type="text" name="q" value="{{ $filters['q'] }}" class="form-control" placeholder="{{ __('admin.name_email_phone_student_no') }}">
            </div>
            <div class="col-md-6 col-lg-2">
                <label class="form-label">{{ __('admin.faculty_2') }}</label>
                <select name="faculty_id" class="form-select">
                    <option value="">{{ __('admin.all_2') }}</option>
                    @foreach($faculties as $faculty)
                        <option value="{{ $faculty->id }}" @selected((string)$filters['faculty_id'] === (string)$faculty->id)>{{ $faculty->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-6 col-lg-2">
                <label class="form-label">{{ __('admin.department') }}</label>
                <select name="department_id" class="form-select">
                    <option value="">{{ __('admin.all_2') }}</option>
                    @foreach($departments as $department)
                        <option value="{{ $department->id }}" @selected((string)$filters['department_id'] === (string)$department->id)>{{ $department->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-6 col-lg-2">
                <label class="form-label">{{ __('admin.program') }}</label>
                <select name="program_id" class="form-select">
                    <option value="">{{ __('admin.all_2') }}</option>
                    @foreach($programs as $program)
                        <option value="{{ $program->id }}" @selected((string)$filters['program_id'] === (string)$program->id)>{{ $program->name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-6 col-lg-2">
                <label class="form-label">{{ __('admin.semester') }}</label>
                <select name="semester_id" class="form-select">
                    <option value="">{{ __('admin.all_2') }}</option>
                    @foreach($semesters as $semester)
                        <option value="{{ $semester->id }}" @selected((string)$filters['semester_id'] === (string)$semester->id)>{{ $semester->name ?: ('Semester '.$semester->number) }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-6 col-lg-1">
                <label class="form-label">{{ __('admin.status') }}</label>
                <select name="status" class="form-select">
                    <option value="">{{ __('admin.all_2') }}</option>
                    @foreach(['active','graduated','suspended','inactive'] as $item)
                        <option value="{{ $item }}" @selected((string)$filters['status'] === $item)>{{ ucfirst($item) }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-12 d-flex gap-2">
                <button class="btn btn-primary rounded-pill px-4">{{ __('admin.apply_filters') }}</button>
                <a href="{{ url()->current() }}" class="btn btn-outline-secondary rounded-pill px-4">{{ __('admin.reset') }}</a>
            </div>
        </form>
    </div>
</div>

<div class="card border-0 shadow-sm rounded-4">
    <div class="card-body table-responsive">
        <table class="table table-hover align-middle mb-0">
            <thead class="table-light">
                <tr>
                    <th>#</th>
                    <th>{{ __('admin.student_2') }}</th>
                    <th>{{ __('admin.academic_placement') }}</th>
                    <th>{{ __('admin.status') }}</th>
                    <th>{{ __('admin.attendance_2') }}</th>
                    <th>{{ __('admin.fees') }}</th>
                    <th>{{ __('admin.flags') }}</th>
                    <th>{{ __('admin.action') }}</th>
                </tr>
            </thead>
            <tbody>
            @forelse($students as $student)
                @php($meta = $student->report_meta)
                <tr>
                    <td>{{ method_exists($students, 'firstItem') ? $students->firstItem() + $loop->index : $loop->iteration }}</td>
                    <td>
                        <div class="fw-semibold">{{ $student->name }}</div>
                        <div class="small text-muted">{{ $meta['student_no'] ?: 'No student no' }}</div>
                        <div class="small text-muted">{{ $student->email ?: 'No email' }}</div>
                        <div class="small text-muted">{{ $student->phone ?: ($student->studentRecord->phone ?? 'No phone') }}</div>
                    </td>
                    <td>
                        <div class="small"><strong>{{ __('admin.faculty_3') }}</strong> {{ $meta['faculty'] ?: '—' }}</div>
                        <div class="small"><strong>{{ __('admin.department_3') }}</strong> {{ $meta['department'] ?: '—' }}</div>
                        <div class="small"><strong>{{ __('admin.program_3') }}</strong> {{ $meta['program'] ?: '—' }}</div>
                        <div class="small"><strong>{{ __('admin.semester_3') }}</strong> {{ $meta['semester'] ?: '—' }}</div>
                    </td>
                    <td><span class="badge text-bg-secondary text-capitalize">{{ $meta['status'] }}</span></td>
                    <td>
                        @if($meta['attendance_rate'] !== null)
                            <span class="fw-semibold {{ $meta['attendance_rate'] < 75 ? 'text-danger' : 'text-success' }}">{{ $meta['attendance_rate'] }}%</span>
                        @else
                            <span class="text-muted">{{ __('admin.no_records') }}</span>
                        @endif
                    </td>
                    <td>
                        <span class="fw-semibold {{ $meta['outstanding'] > 0 ? 'text-danger' : 'text-success' }}">
                            {{ number_format($meta['outstanding'], 2) }}
                        </span>
                    </td>
                    <td style="min-width: 220px;">
                        @if(count($meta['missing_fields']) || count($meta['risk_flags']))
                            <div class="d-flex flex-wrap gap-1">
                                @foreach($meta['missing_fields'] as $flag)
                                    <span class="badge text-bg-warning">{{ $flag }}</span>
                                @endforeach
                                @foreach($meta['risk_flags'] as $flag)
                                    <span class="badge text-bg-danger">{{ $flag }}</span>
                                @endforeach
                            </div>
                        @else
                            <span class="text-success small">{{ __('admin.record_looks_good') }}</span>
                        @endif
                    </td>
                    <td>
                        <div class="d-flex flex-wrap gap-2">
                            <a href="{{ route('students.show', $student->id) }}" class="btn btn-sm btn-outline-primary rounded-pill">{{ __('admin.360_profile') }}</a>
                            <a href="{{ route('students.print', $student->id) }}" class="btn btn-sm btn-outline-secondary rounded-pill">{{ __('admin.print') }}</a>
                        </div>
                    </td>
                </tr>
            @empty
                <tr><td colspan="8" class="text-center py-5 text-muted">{{ __('admin.no_students_found_for_this_report') }}</td></tr>
            @endforelse
            </tbody>
        </table>
    </div>
</div>

@if(method_exists($students, 'links'))
    <div class="mt-4">{{ $students->links('pagination::bootstrap-4') }}</div>
@endif
@endsection