@extends('admin.layouts.app')
@section('title', 'Attendance Report')
@section('breadcrumb')
    <li class="breadcrumb-item active">Attendance Report</li>
@endsection
@section('content')
<div class="page-header">
    <div>
        <h1 class="page-title">Attendance Report</h1>
        <p class="page-subtitle">View subject-wise and student-wise attendance</p>
    </div>
</div>

<div class="card mb-4">
    <div class="card-header"><i class="bi bi-funnel me-2"></i>Filter Report</div>
    <div class="card-body">
        <form method="GET" class="row g-3">
            <div class="col-md-3">
                <label class="form-label">Class <span class="text-danger">*</span></label>
                <select name="class_id" class="form-select" required onchange="this.form.submit()">
                    <option value="">— Select Class —</option>
                    @foreach($classes as $c)
                        <option value="{{ $c->id }}" {{ request('class_id') == $c->id ? 'selected' : '' }}>{{ $c->name }}</option>
                    @endforeach
                </select>
            </div>
            @if($subjects->count())
            <div class="col-md-3">
                <label class="form-label">Subject</label>
                <select name="subject_id" class="form-select">
                    <option value="">All Subjects</option>
                    @foreach($subjects as $s)
                        <option value="{{ $s->id }}" {{ request('subject_id') == $s->id ? 'selected' : '' }}>{{ $s->name }}</option>
                    @endforeach
                </select>
            </div>
            @endif
            <div class="col-md-2">
                <label class="form-label">From Date</label>
                <input type="date" name="from_date" class="form-control" value="{{ request('from_date') }}">
            </div>
            <div class="col-md-2">
                <label class="form-label">To Date</label>
                <input type="date" name="to_date" class="form-control" value="{{ request('to_date') }}">
            </div>
            <div class="col-md-2 d-flex align-items-end gap-2">
                <button type="submit" class="btn btn-primary flex-grow-1">
                    <i class="bi bi-search me-1"></i>Generate
                </button>
            </div>
        </form>
    </div>
</div>

@if($report->count())
<!-- SUMMARY CARDS -->
@php
    $below75 = $report->filter(fn($r) => $r->percentage < 75)->count();
    $avgPct   = round($report->avg('percentage'), 1);
@endphp
<div class="row g-3 mb-3">
    <div class="col-md-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#dbeafe"><i class="bi bi-people" style="color:#2563eb"></i></div>
            <div><div class="stat-value">{{ $report->pluck('student_id')->unique()->count() }}</div><div class="stat-label">Students</div></div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#dcfce7"><i class="bi bi-percent" style="color:#16a34a"></i></div>
            <div><div class="stat-value">{{ $avgPct }}%</div><div class="stat-label">Avg Attendance</div></div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="stat-card">
            <div class="stat-icon" style="background:#fee2e2"><i class="bi bi-exclamation-triangle" style="color:#dc2626"></i></div>
            <div><div class="stat-value">{{ $below75 }}</div><div class="stat-label">Below 75% (rows)</div></div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header d-flex justify-content-between align-items-center">
        <span>Report — {{ $report->count() }} records</span>
        <button onclick="window.print()" class="btn btn-sm btn-outline-secondary">
            <i class="bi bi-printer me-1"></i>Print
        </button>
    </div>
    <div class="table-responsive">
        <table class="table table-hover mb-0">
            <thead>
                <tr>
                    <th>Student</th>
                    <th>Roll No.</th>
                    <th>Subject</th>
                    <th>Category</th>
                    <th>Total</th>
                    <th>Present</th>
                    <th>Absent</th>
                    <th>Attendance %</th>
                </tr>
            </thead>
            <tbody>
                @foreach($report as $row)
                <tr>
                    <td>
                        <a href="{{ route('admin.attendance.student', $row->student_id) }}" class="text-decoration-none" style="font-weight:500;font-size:0.87rem">
                            {{ $row->student_name }}
                        </a>
                        <div style="font-size:0.75rem;color:#64748b">{{ $row->student_code }}</div>
                    </td>
                    <td style="font-size:0.85rem">{{ $row->roll_no ?? '—' }}</td>
                    <td style="font-size:0.85rem">{{ $row->subject_name }}</td>
                    <td><span class="badge badge-soft-info" style="font-size:0.72rem">{{ $row->category }}</span></td>
                    <td>{{ $row->total_classes }}</td>
                    <td style="color:#16a34a;font-weight:500">{{ $row->attended }}</td>
                    <td style="color:#dc2626;font-weight:500">{{ $row->absent }}</td>
                    <td>
                        <div class="d-flex align-items-center gap-2">
                            <div class="progress flex-grow-1" style="height:7px;min-width:70px">
                                <div class="progress-bar {{ $row->percentage >= 75 ? 'bg-success' : ($row->percentage >= 60 ? 'bg-warning' : 'bg-danger') }}"
                                     style="width:{{ $row->percentage }}%"></div>
                            </div>
                            <span style="font-size:0.83rem;font-weight:600;min-width:40px;{{ $row->percentage < 75 ? 'color:#dc2626' : '' }}">
                                {{ $row->percentage }}%
                            </span>
                            @if($row->percentage < 75)
                                <i class="bi bi-exclamation-triangle-fill text-danger" style="font-size:0.8rem" title="Below 75%"></i>
                            @endif
                        </div>
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@elseif(request('class_id'))
<div class="card text-center py-5 text-muted">
    <i class="bi bi-inbox" style="font-size:3rem;opacity:0.3"></i>
    <p class="mt-2">No attendance records found for the selected filters</p>
</div>
@endif
@endsection