@extends('layouts.app')

@section('content')
<div class="container py-4">
    <div class="d-flex justify-content-between align-items-center mb-4">
        <h3>{{ __('admin.all_students_report') }}</h3>
    </div>

    <div class="row mb-4">
        <div class="col-md-4">
            <div class="card shadow-sm border-0">
                <div class="card-body">
                    <h6>{{ __('admin.total_students') }}</h6>
                    <h3>{{ $totalStudents }}</h3>
                </div>
            </div>
        </div>

        <div class="col-md-4">
            <div class="card shadow-sm border-0">
                <div class="card-body">
                    <h6>{{ __('admin.active_students') }}</h6>
                    <h3>{{ $activeStudents }}</h3>
                </div>
            </div>
        </div>

        <div class="col-md-4">
            <div class="card shadow-sm border-0">
                <div class="card-body">
                    <h6>{{ __('admin.inactive_students') }}</h6>
                    <h3>{{ $inactiveStudents }}</h3>
                </div>
            </div>
        </div>
    </div>

    <div class="card shadow-sm border-0 mb-4">
        <div class="card-body">
            <form method="GET" action="{{ route('reports.students.all') }}">
                <div class="row g-3">
                    <div class="col-md-3">
                        <input type="text" name="search" value="{{ request('search') }}" class="form-control" placeholder="{{ __('admin.search_name_email_student_id') }}">
                    </div>

                    <div class="col-md-2">
                        <input type="text" name="faculty_id" value="{{ request('faculty_id') }}" class="form-control" placeholder="{{ __('admin.faculty_id') }}">
                    </div>

                    <div class="col-md-2">
                        <input type="text" name="department_id" value="{{ request('department_id') }}" class="form-control" placeholder="{{ __('admin.department_id') }}">
                    </div>

                    <div class="col-md-2">
                        <input type="text" name="program_id" value="{{ request('program_id') }}" class="form-control" placeholder="{{ __('admin.program_id') }}">
                    </div>

                    <div class="col-md-2">
                        <input type="text" name="semester_id" value="{{ request('semester_id') }}" class="form-control" placeholder="{{ __('admin.semester_id') }}">
                    </div>

                    <div class="col-md-1">
                        <select name="status" class="form-control">
                            <option value="">{{ __('admin.all_2') }}</option>
                            <option value="active" {{ request('status') == 'active' ? 'selected' : '' }}>{{ __('admin.active') }}</option>
                            <option value="inactive" {{ request('status') == 'inactive' ? 'selected' : '' }}>{{ __('admin.inactive') }}</option>
                            <option value="graduated" {{ request('status') == 'graduated' ? 'selected' : '' }}>{{ __('admin.graduated') }}</option>
                            <option value="dropped" {{ request('status') == 'dropped' ? 'selected' : '' }}>{{ __('admin.dropped') }}</option>
                        </select>
                    </div>

                    <div class="col-md-12 d-flex gap-2">
                        <button class="btn btn-primary">{{ __('admin.filter') }}</button>
                        <a href="{{ route('reports.students.all') }}" class="btn btn-secondary">{{ __('admin.reset') }}</a>
                    </div>
                </div>
            </form>
        </div>
    </div>

    <div class="card shadow-sm border-0">
        <div class="card-body table-responsive">
            <table class="table table-bordered align-middle">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>{{ __('admin.student_id') }}</th>
                        <th>{{ __('admin.name') }}</th>
                        <th>{{ __('admin.email') }}</th>
                        <th>{{ __('admin.faculty_2') }}</th>
                        <th>{{ __('admin.department') }}</th>
                        <th>{{ __('admin.program') }}</th>
                        <th>{{ __('admin.semester') }}</th>
                        <th>{{ __('admin.status') }}</th>
                        <th>{{ __('admin.action') }}</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($students as $student)
                        <tr>
                            <td>{{ $loop->iteration }}</td>
                            <td>{{ $student->student_id ?? '-' }}</td>
                            <td>{{ $student->name }}</td>
                            <td>{{ $student->email ?? '-' }}</td>
                            <td>{{ $student->studentRecord->faculty->name ?? '-' }}</td>
                            <td>{{ $student->studentRecord->department->name ?? '-' }}</td>
                            <td>{{ $student->studentRecord->program->name ?? '-' }}</td>
                            <td>{{ $student->studentRecord->semester->name ?? '-' }}</td>
                            <td>
                                <span class="badge bg-info">
                                    {{ $student->studentRecord->status ?? 'N/A' }}
                                </span>
                            </td>
                            <td>
                                <a href="{{ route('students.show', $student->id) }}" class="btn btn-sm btn-primary">
                                    {{ __('admin.view_profile') }}
                                </a>
                            </td>
                        </tr>
                    @empty
                        <tr>
                            <td colspan="10" class="text-center">{{ __('admin.no_students_found') }}</td>
                        </tr>
                    @endforelse
                </tbody>
            </table>

            {{ $students->links('pagination::bootstrap-4') }}
        </div>
    </div>
</div>
@endsection