@extends('layouts.app')

@section('content')
<div class="container">
    <div class="row justify-content-start">
        @include('layouts.left-menu')
        <div class="col-xs-11 col-sm-11 col-md-11 col-lg-10 col-xl-10 col-xxl-10">
            <div class="row pt-2">
                <div class="col ps-4">
                    <h1 class="display-6 mb-3">
                        <i class="bi bi-person-lines-fill"></i> Student List
                    </h1>
                    <nav aria-label="breadcrumb">
                        <ol class="breadcrumb">
                            <li class="breadcrumb-item"><a href="{{route('home')}}">Home</a></li>
                            <li class="breadcrumb-item active" aria-current="page">Student List</li>
                        </ol>
                    </nav>
                    @include('session-messages')

                    <!-- Stats Cards -->
                    <div class="row mb-4">
                        <div class="col-md-2">
                            <div class="card theme-card-primary shadow-sm">
                                <div class="card-body text-center p-3">
                                    <i class="bi bi-people-fill fs-2 mb-2"></i>
                                    <h3 class="fw-bold mb-0">{{ $totalStudents }}</h3>
                                    <small>Total Students</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card theme-card-info shadow-sm">
                                <div class="card-body text-center p-3">
                                    <i class="bi bi-gender-male fs-2 mb-2"></i>
                                    <h3 class="fw-bold mb-0">{{ $maleCount }}</h3>
                                    <small>Male</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-2">
                            <div class="card theme-card-pink shadow-sm">
                                <div class="card-body text-center p-3">
                                    <i class="bi bi-gender-female fs-2 mb-2"></i>
                                    <h3 class="fw-bold mb-0">{{ $femaleCount }}</h3>
                                    <small>Female</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card theme-card-success shadow-sm">
                                <div class="card-body text-center p-3">
                                    <i class="bi bi-check-circle-fill fs-2 mb-2"></i>
                                    <h3 class="fw-bold mb-0">{{ $paidCount }}</h3>
                                    <small>Fully Paid</small>
                                </div>
                            </div>
                        </div>
                        <div class="col-md-3">
                            <div class="card theme-card-danger shadow-sm">
                                <div class="card-body text-center p-3">
                                    <i class="bi bi-exclamation-circle-fill fs-2 mb-2"></i>
                                    <h3 class="fw-bold mb-0">{{ $unpaidCount }}</h3>
                                    <small>With Balance Due</small>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Filters -->
                    <div class="card shadow-sm mb-4">
                        <div class="card-header bg-light">
                            <h6 class="mb-0"><i class="bi bi-funnel"></i> Filter Students</h6>
                        </div>
                        <div class="card-body">
                            <form class="row g-3" action="{{route('student.list.show')}}" method="GET">
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">
                                        <i class="bi bi-calendar-range"></i> Session
                                    </label>
                                    <select class="form-select" name="session_id" onchange="this.form.submit()">
                                        @foreach($all_sessions as $session)
                                            <option value="{{$session->id}}" {{$session->id == $filter_session_id ? 'selected' : ''}}>
                                                {{$session->session_name}}
                                                @if($session->id == $current_session_id)
                                                    (Current)
                                                @endif
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">Start Date</label>
                                    <input type="date" name="start_date" class="form-control"
                                        value="{{ request('start_date') }}">
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">End Date</label>
                                    <input type="date" name="end_date" class="form-control"
                                        value="{{ request('end_date') }}">
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">Class</label>
                                    <select onchange="getSections(this);" class="form-select" name="class_id">
                                        <option value="0">All Classes</option>
                                        @isset($school_classes)
                                            @foreach ($school_classes as $school_class)
                                                <option value="{{$school_class->id}}" {{($school_class->id == request()->query('class_id'))?'selected':''}}>
                                                    {{$school_class->class_name}}
                                                </option>
                                            @endforeach
                                        @endisset
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">Section</label>
                                    <select class="form-select" id="section-select" name="section_id">
                                        <option value="0">All Sections</option>
                                        @if(request()->query('section_id'))
                                            <option value="{{request()->query('section_id')}}" selected>
                                                {{request()->query('section_name')}}
                                            </option>
                                        @endif
                                    </select>
                                </div>
                                <div class="col-md-2">
                                    <label class="form-label fw-bold">Search</label>
                                    <input type="text" class="form-control" name="search"
                                        placeholder="Name, Email, Phone, ID..."
                                        value="{{ request()->query('search') }}">
                                </div>
                                <div class="col-md-2 d-flex align-items-end">
                                    <button type="submit" class="btn btn-primary w-100">
                                        <i class="bi bi-search"></i> Filter
                                    </button>
                                </div>
                            </form>
                            @if(request()->hasAny(['class_id', 'section_id', 'search', 'start_date', 'end_date', 'session_id']))
                                <div class="mt-3">
                                    <a href="{{ route('student.list.show') }}" class="btn btn-sm btn-outline-secondary">
                                        <i class="bi bi-x-circle"></i> Clear All Filters
                                    </a>
                                    @if($filter_session_id != $current_session_id)
                                        <span class="badge bg-info ms-2">
                                            <i class="bi bi-info-circle"></i> Viewing {{$all_sessions->firstWhere('id', $filter_session_id)->session_name ?? ''}} session
                                        </span>
                                    @endif
                                </div>
                            @endif
                        </div>
                    </div>

                    <!-- Student List -->
                    <div class="bg-white border shadow-sm p-3">
                        <div class="d-flex justify-content-between align-items-center mb-3">
                            <h5 class="mb-0">
                                <i class="bi bi-list-ul"></i> Students 
                                <span class="badge bg-primary">{{ $studentList->total() }}</span>
                            </h5>
                            <small class="text-muted">
                                Showing {{ $studentList->firstItem() ?? 0 }} to {{ $studentList->lastItem() ?? 0 }} of {{ $studentList->total() }}
                            </small>
                        </div>

                        <div class="table-responsive">
                            <table class="table table-hover">
                                <thead class="table-light">
                                    <tr>
                                        <th scope="col">ID Card</th>
                                        <th scope="col">Photo</th>
                                        <th scope="col">Name</th>
                                        <th scope="col">Class</th>
                                        <th scope="col">Section</th>
                                        <th scope="col">Email</th>
                                        <th scope="col">Phone</th>
                                        <th scope="col">Actions</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($studentList as $student)
                                    <tr>
                                        <td class="fw-bold text-primary">{{$student->id_card_number}}</td>
                                        <td>
                                            @if (isset($student->student->photo))
                                                <img src="{{asset('/storage'.$student->student->photo)}}" 
                                                     class="rounded-circle" alt="Photo" height="35" width="35">
                                            @else
                                                <div class="bg-light rounded-circle d-inline-flex align-items-center justify-content-center" 
                                                     style="width: 35px; height: 35px;">
                                                    <i class="bi bi-person"></i>
                                                </div>
                                            @endif
                                        </td>
                                        <td>
                                            <strong>{{$student->student->first_name}} {{$student->student->last_name}}</strong>
                                            @if($student->student->gender == 'male')
                                                <i class="bi bi-gender-male text-info"></i>
                                            @else
                                                <i class="bi bi-gender-female text-danger"></i>
                                            @endif
                                        </td>
                                        <td>{{$student->schoolClass->class_name ?? 'N/A'}}</td>
                                        <td>{{$student->section->section_name ?? 'N/A'}}</td>
                                        <td><small>{{$student->student->email}}</small></td>
                                        <td><small>{{$student->student->phone}}</small></td>
                                        <td>
                                            <div class="d-flex gap-1">
                                                <a href="{{ route('student.print', ['id' => $student->student->id]) }}" 
                                                   class="btn btn-sm btn-outline-primary" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="View & Print Voucher">
                                                    <i class="bi bi-receipt"></i>
                                                </a>

                                                <a href="{{ route('student.attendance.show', ['id' => $student->student->id]) }}" 
                                                   class="btn btn-sm btn-outline-info" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="View Attendance Records">
                                                    <i class="bi bi-calendar-check"></i>
                                                </a>

                                                <a href="{{ route('student.profile.show', ['id' => $student->student->id]) }}" 
                                                   class="btn btn-sm btn-outline-secondary" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="View Student Profile">
                                                    <i class="bi bi-person"></i>
                                                </a>

                                                @can('edit users')
                                                <a href="{{ route('student.edit.show', ['id' => $student->student->id]) }}" 
                                                   class="btn btn-sm btn-outline-warning" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="Edit Student Information">
                                                    <i class="bi bi-pen"></i>
                                                </a>
                                                @endcan

                                                <a href="{{ route('student.promote.form', ['id' => $student->student->id]) }}" 
                                                   class="btn btn-sm btn-outline-success" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="Promote to Next Class">
                                                    <i class="bi bi-arrow-up-circle"></i>
                                                </a>

                                                <a href="{{ route('payments.edit', $student->student->id) }}" 
                                                   class="btn btn-sm btn-outline-success" 
                                                   data-bs-toggle="tooltip" 
                                                   data-bs-placement="top" 
                                                   title="Record Payment">
                                                    <i class="bi bi-cash-coin"></i>
                                                </a>

                                                @if(auth()->user()->role == 'admin')
                                                    <form action="{{ route('student.delete', ['id' => $student->student->id]) }}" 
                                                          method="POST" 
                                                          onsubmit="return confirm('Are you sure you want to delete this student?');"
                                                          class="d-inline">
                                                        @csrf
                                                        @method('DELETE')
                                                        <button type="submit" 
                                                                class="btn btn-sm btn-outline-danger" 
                                                                data-bs-toggle="tooltip" 
                                                                data-bs-placement="top" 
                                                                title="Delete Student (Admin Only)">
                                                            <i class="bi bi-trash"></i>
                                                        </button>
                                                    </form>
                                                @endif
                                            </div>
                                        </td>
                                    </tr>
                                    @empty
                                    <tr>
                                        <td colspan="8" class="text-center text-muted py-5">
                                            <i class="bi bi-inbox" style="font-size: 3rem;"></i>
                                            <p class="mt-2 mb-0">No students found</p>
                                            @if(request()->hasAny(['class_id', 'section_id', 'search']))
                                                <p><small>Try adjusting your filters</small></p>
                                            @endif
                                        </td>
                                    </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>

                        <!-- Pagination -->
                        <div class="d-flex justify-content-center mt-4">
                            {{ $studentList->links() }}
                        </div>
                    </div>
                </div>
            </div>
            @include('layouts.footer')
        </div>
    </div>
</div>

<script>
    function getSections(obj) {
        var class_id = obj.options[obj.selectedIndex].value;
        
        if (class_id == 0) {
            document.getElementById('section-select').innerHTML = '<option value="0">All Sections</option>';
            return;
        }

        var url = "{{route('get.sections.courses.by.classId')}}?class_id=" + class_id 

        fetch(url)
        .then((resp) => resp.json())
        .then(function(data) {
            var sectionSelect = document.getElementById('section-select');
            sectionSelect.options.length = 0;
            data.sections.unshift({'id': 0,'section_name': 'All Sections'})
            data.sections.forEach(function(section, key) {
                sectionSelect[key] = new Option(section.section_name, section.id);
            });
        })
        .catch(function(error) {
            console.log(error);
        });
    }

    // Initialize Bootstrap tooltips
    document.addEventListener('DOMContentLoaded', function() {
        var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'))
        var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
            return new bootstrap.Tooltip(tooltipTriggerEl)
        })
    });
</script>

<style>
    .theme-card-primary {
        background: linear-gradient(-45deg, #1054a9, #179ceb);
        color: white;
    }
    .theme-card-info {
        background: linear-gradient(135deg, #667eea 0%, #764ba2 100%);
        color: white;
    }
    .theme-card-pink {
        background: linear-gradient(135deg, #f093fb 0%, #f5576c 100%);
        color: white;
    }
    .theme-card-success {
        background: linear-gradient(135deg, #4facfe 0%, #00f2fe 100%);
        color: white;
    }
    .theme-card-danger {
        background: linear-gradient(135deg, #fa709a 0%, #fee140 100%);
        color: white;
    }
    .card {
        transition: transform 0.2s;
    }
    .card:hover {
        transform: translateY(-3px);
    }
</style>
@endsection