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

@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">{{ __('admin.student_reports') }}</h3>
        <p class="text-muted mb-0">{{ __('admin.review_student_status_placement_and_activity_in_one_pla') }}</p>
    </div>
    <a href="{{ route('students.create') }}" class="btn btn-primary rounded-pill px-4 py-2">
        <i class="fas fa-plus me-2"></i> {{ __('admin.new_student') }}
    </a>
</div>

<div class="row g-3 mb-4">
    <div class="col-sm-6 col-xl-3"><div class="card shadow-sm border-0 rounded-4 h-100"><div class="card-body"><div class="d-flex align-items-center justify-content-between mb-3"><div><div class="text-uppercase text-muted small">{{ __('admin.total_students') }}</div><div class="fs-2 fw-bold">{{ $stats['total'] }}</div></div><span class="badge bg-primary rounded-pill py-2 px-3">{{ __('admin.all_2') }}</span></div><div class="text-muted small">{{ __('admin.dataset_last_updated_automatically') }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card shadow-sm border-0 rounded-4 h-100"><div class="card-body"><div class="d-flex align-items-center justify-content-between mb-3"><div><div class="text-uppercase text-muted small">{{ __('admin.active_students') }}</div><div class="fs-2 fw-bold text-success">{{ $stats['active'] }}</div></div><i class="fas fa-user-check fa-2x text-success"></i></div><div class="text-muted small">{{ __('admin.currently_enrolled_students') }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card shadow-sm border-0 rounded-4 h-100"><div class="card-body"><div class="d-flex align-items-center justify-content-between mb-3"><div><div class="text-uppercase text-muted small">{{ __('admin.graduated') }}</div><div class="fs-2 fw-bold text-primary">{{ $stats['graduated'] }}</div></div><i class="fas fa-graduation-cap fa-2x text-primary"></i></div><div class="text-muted small">{{ __('admin.students_who_completed_their_program') }}</div></div></div></div>
    <div class="col-sm-6 col-xl-3"><div class="card shadow-sm border-0 rounded-4 h-100"><div class="card-body"><div class="d-flex align-items-center justify-content-between mb-3"><div><div class="text-uppercase text-muted small">{{ __('admin.suspended') }}</div><div class="fs-2 fw-bold text-danger">{{ $stats['suspended'] }}</div></div><i class="fas fa-user-slash fa-2x text-danger"></i></div><div class="text-muted small">{{ __('admin.students_with_temporary_holds') }}</div></div></div></div>
</div>

<div class="card shadow-sm border-0 rounded-4">
    <div class="card-body p-4">
        @if(session('msg')) <div class="alert alert-info rounded-3">{{ session('msg') }}</div> @endif

        <form method="GET" class="row gx-3 gy-3 mb-4">
            <div class="col-lg-4"><label class="form-label">{{ __('admin.search') }}</label><div class="input-group"><span class="input-group-text bg-white border-end-0"><i class="fas fa-search"></i></span><input type="text" name="q" value="{{ $q }}" class="form-control border-start-0" placeholder="{{ __('admin.name_email_phone_tazkira') }}"></div></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)$facultyId === (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)$departmentId === (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)$programId === (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)$semesterId === (string)$semester->id)>{{ $semester->name }}</option>@endforeach</select></div>
            <div class="col-md-6 col-lg-2"><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)$status === $item)>{{ ucfirst($item) }}</option>@endforeach</select></div>
            <div class="col-12 d-flex flex-wrap gap-2"><button type="submit" class="btn btn-primary rounded-pill px-4">{{ __('admin.apply') }}</button><a href="{{ route('students.index') }}" class="btn btn-outline-secondary rounded-pill px-4">{{ __('admin.reset') }}</a></div>
        </form>

        <div class="table-responsive border rounded-4 overflow-hidden">
            <table class="table table-hover 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.courses') }}</th>
                        <th>{{ __('admin.activity') }}</th>
                        <th>{{ __('admin.actions') }}</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($students as $s)
                        @php
                            $profile = $s->studentRecord;
                            $program = $profile?->program;
                            $department = $program?->department;
                            $faculty = $department?->faculty;
                            $semester = $profile?->currentSemester;
                        @endphp
                        <tr>
                            <td class="align-middle">{{ $s->id }}</td>
                            <td class="align-middle">
                                <div class="fw-semibold">{{ $s->name }}</div>
                                <div class="text-muted small">{{ $s->email }}</div>
                                <div class="text-muted small">{{ $s->phone ?: 'No phone' }}</div>
                            </td>
                            <td class="align-middle">
                                <div class="small"><strong>{{ __('admin.faculty_3') }}</strong> {{ $faculty?->name ?: '—' }}</div>
                                <div class="small"><strong>{{ __('admin.department_3') }}</strong> {{ $department?->name ?: '—' }}</div>
                                <div class="small"><strong>{{ __('admin.program_3') }}</strong> {{ $program?->name ?: '—' }}</div>
                                <div class="small"><strong>{{ __('admin.semester_3') }}</strong> {{ $semester?->name ?: '—' }}</div>
                            </td>
                            <td class="align-middle">
                                @php
                                    $status = $profile?->status ?: 'unknown';
                                    $badge = match ($status) { 'active' => 'bg-success', 'graduated' => 'bg-primary', 'suspended' => 'bg-danger', default => 'bg-secondary' };
                                @endphp
                                <span class="badge {{ $badge }} text-capitalize">{{ $status }}</span>
                            </td>
                            <td class="align-middle">{{ $s->enrolled_courses_count }}</td>
                            <td class="align-middle">
                                <div class="small">{{ __('admin.quizzes') }}: {{ $s->quiz_attempts_count }}</div>
                                <div class="small">{{ __('admin.assignments') }}: {{ $s->assignment_submissions_count }}</div>
                            </td>
                            <td class="align-middle">
                                <div class="d-flex flex-wrap gap-2">
                                    <a class="btn btn-sm btn-outline-info rounded-pill" href="{{ route('students.show', $s->id) }}">{{ __('admin.report') }}</a>
                                    <a class="btn btn-sm btn-outline-primary rounded-pill" href="{{ route('students.edit', $s->id) }}">{{ __('admin.edit') }}</a>
                                </div>
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="7" class="text-center py-5 text-muted">{{ __('admin.no_students_found') }}</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="mt-4">{{ $students->links('pagination::bootstrap-4') }}</div>
    </div>
</div>
@endsection