@extends('backend.admin_backend.admin_dashboard')

@section('admin')

@php

/*
|--------------------------------------------------------------------------
| AGM SMARTSCHOOL - ACADEMIC PERFORMANCE ANALYTICS DASHBOARD
|--------------------------------------------------------------------------
|
| PURPOSE:
|
| This dashboard gives the school administrator a complete picture
| of academic performance.
|
| The administrator can select:
|
| 1. Academic Session
| 2. Term
| 3. Class
|
| The dashboard then recalculates the academic analysis based on
| those selections.
|
|--------------------------------------------------------------------------
| IMPORTANT RESULT CALCULATION
|--------------------------------------------------------------------------
|
| We are using the "total" column from the results table.
|
| Example:
|
| Mathematics = 72
| English     = 65
| Biology     = 80
|
| Student average:
|
| (72 + 65 + 80) / 3
|
| This gives the student's average performance.
|
|--------------------------------------------------------------------------
*/


/*
|--------------------------------------------------------------------------
| IMPORT MODELS
|--------------------------------------------------------------------------
*/

use App\Models\Student;
use App\Models\StudentClasses;
use App\Models\Teacher;
use App\Models\Subject;
use App\Models\Result;
use App\Models\CbtTest;
use App\Models\CbtAttempt;

use Illuminate\Support\Facades\DB;


/*
|--------------------------------------------------------------------------
| BASIC SCHOOL STATISTICS
|--------------------------------------------------------------------------
|
| These figures are not affected by the analysis filter.
|
| They represent the entire school.
|
|--------------------------------------------------------------------------
*/

$totalstudent  = Student::count();

$totalsubject  = Subject::count();

$totalclass    = StudentClasses::count();

$totalteachers = Teacher::count();


/*
|--------------------------------------------------------------------------
| LOAD ALL ACADEMIC SESSIONS
|--------------------------------------------------------------------------
|
| We load sessions so the administrator can select which academic
| session should be analysed.
|
|--------------------------------------------------------------------------
*/

$academicSessions = DB::table('academic_sessions')
    ->orderByDesc('name')
    ->get();


/*
|--------------------------------------------------------------------------
| LOAD ALL TERMS
|--------------------------------------------------------------------------
|
| We load all available terms.
|
|--------------------------------------------------------------------------
*/

$terms = DB::table('terms')
    ->orderBy('id')
    ->get();


/*
|--------------------------------------------------------------------------
| LOAD ALL CLASSES
|--------------------------------------------------------------------------
|
| The administrator can analyse:
|
| - All classes
| - One particular class
|
|--------------------------------------------------------------------------
*/

$allClasses = StudentClasses::orderBy('class_name')
    ->get();


/*
|--------------------------------------------------------------------------
| CURRENT SESSION
|--------------------------------------------------------------------------
|
| We use the current academic session as the default selection.
|
|--------------------------------------------------------------------------
*/

$currentSessionRecord = DB::table('academic_sessions')
    ->where('is_current', 1)
    ->first();


/*
|--------------------------------------------------------------------------
| CURRENT TERM
|--------------------------------------------------------------------------
|
| We use the current term as the default selection.
|
|--------------------------------------------------------------------------
*/

$currentTermRecord = DB::table('terms')
    ->where('is_current', 1)
    ->first();


/*
|--------------------------------------------------------------------------
| GET FILTER VALUES
|--------------------------------------------------------------------------
|
| request()->get() allows the dashboard to remember the selected
| filter after the page reloads.
|
| Example:
|
| /admin/dashboard?session=2025/2026&term=First Term&class_id=5
|
|--------------------------------------------------------------------------
*/

$selectedSession = request()->get(
    'session',
    $currentSessionRecord->name ?? ''
);


$selectedTerm = request()->get(
    'term',
    $currentTermRecord->name ?? ''
);


/*
|--------------------------------------------------------------------------
| CLASS FILTER
|--------------------------------------------------------------------------
|
| "all" means analyse the entire school.
|
| Otherwise, the administrator can select a specific class.
|
|--------------------------------------------------------------------------
*/

$selectedClass = request()->get(
    'class_id',
    'all'
);


/*
|--------------------------------------------------------------------------
| DETERMINE SELECTED CLASS NAME
|--------------------------------------------------------------------------
*/

$selectedClassName = 'All Classes';


if ($selectedClass !== 'all') {

    $selectedClassRecord = StudentClasses::find(
        $selectedClass
    );

    if ($selectedClassRecord) {

        $selectedClassName =
            $selectedClassRecord->class_name;

    }

}


/*
|--------------------------------------------------------------------------
| DISPLAY PERIOD
|--------------------------------------------------------------------------
|
| This is displayed at the top of the dashboard so the admin always
| knows which academic period is being analysed.
|
|--------------------------------------------------------------------------
*/

$analysisPeriod =
    $selectedTerm . ' - ' . $selectedSession;


/*
|--------------------------------------------------------------------------
| RESULT QUERY
|--------------------------------------------------------------------------
|
| This is the most important query in the dashboard.
|
| Every academic analysis will start from this query.
|
| We filter by:
|
| TERM
| SESSION
|
| Then, if a specific class was selected, we also filter by:
|
| STUDENT CLASS
|
|--------------------------------------------------------------------------
*/

$resultQuery = Result::query()
    ->where(
        'term',
        $selectedTerm
    )
    ->where(
        'session',
        $selectedSession
    );


/*
|--------------------------------------------------------------------------
| APPLY CLASS FILTER
|--------------------------------------------------------------------------
*/

if ($selectedClass !== 'all') {

    $resultQuery->where(
        'student_classes_id',
        $selectedClass
    );

}


/*
|--------------------------------------------------------------------------
| CLONE RESULT QUERY
|--------------------------------------------------------------------------
|
| We will use the same base query for many different calculations.
|
| clone() prevents one calculation from changing another calculation.
|
|--------------------------------------------------------------------------
*/


/*
|--------------------------------------------------------------------------
| TOTAL RESULT RECORDS
|--------------------------------------------------------------------------
|
| Example:
|
| 30 students
| 8 subjects
|
| Total result records:
|
| 30 x 8 = 240
|
|--------------------------------------------------------------------------
*/

$totalResultRecords = (clone $resultQuery)
    ->count();


/*
|--------------------------------------------------------------------------
| STUDENTS WITH RESULTS
|--------------------------------------------------------------------------
|
| distinct student_id ensures that a student is counted only once,
| even though the student may have many subjects.
|
|--------------------------------------------------------------------------
*/

$studentsWithResults = (clone $resultQuery)
    ->distinct('student_id')
    ->count('student_id');


/*
|--------------------------------------------------------------------------
| OVERALL AVERAGE
|--------------------------------------------------------------------------
|
| We calculate the average of all result totals belonging to the
| selected term, session and optional class.
|
|--------------------------------------------------------------------------
*/

$overallAverage = (clone $resultQuery)
    ->whereNotNull('total')
    ->avg('total');


$overallAverage = round(
    $overallAverage ?? 0,
    2
);


/*
|--------------------------------------------------------------------------
| OVERALL PERCENTAGE
|--------------------------------------------------------------------------
|
| Your result total is already stored as a percentage-style score
| out of 100.
|
| Therefore:
|
| Average 68.50 = 68.50%
|
|--------------------------------------------------------------------------
*/

$overallPercentage = $overallAverage;


/*
|--------------------------------------------------------------------------
| PASS MARK
|--------------------------------------------------------------------------
|
| We are using 40 as the default pass mark based on the existing
| dashboard logic.
|
| You can later move this to school_settings so the administrator
| can configure it.
|
|--------------------------------------------------------------------------
*/

$passMark = 40;


/*
|--------------------------------------------------------------------------
| STUDENT AVERAGES
|--------------------------------------------------------------------------
|
| Here we calculate EACH student's average.
|
| Example:
|
| Student A:
|
| Mathematics = 70
| English     = 80
| Biology     = 60
|
| Average:
|
| (70 + 80 + 60) / 3 = 70
|
|--------------------------------------------------------------------------
*/

$studentAverages = (clone $resultQuery)
    ->select(
        'student_id'
    )
    ->selectRaw(
        'AVG(total) as average_score'
    )
    ->selectRaw(
        'COUNT(*) as subject_count'
    )
    ->groupBy(
        'student_id'
    )
    ->get();


/*
|--------------------------------------------------------------------------
| ABOVE AND BELOW SCHOOL/CLASS AVERAGE
|--------------------------------------------------------------------------
|
| We compare each student's average with the calculated overall
| average of the current analysis.
|
|--------------------------------------------------------------------------
*/

$aboveAverageStudents = 0;

$belowAverageStudents = 0;


foreach ($studentAverages as $studentAverage) {

    if (
        $studentAverage->average_score
        >=
        $overallAverage
    ) {

        $aboveAverageStudents++;

    } else {

        $belowAverageStudents++;

    }

}


/*
|--------------------------------------------------------------------------
| PASSING AND FAILING STUDENTS
|--------------------------------------------------------------------------
|
| Student average >= 40:
|
| PASS
|
| Student average < 40:
|
| BELOW PASS MARK
|
|--------------------------------------------------------------------------
*/

$passingStudents = 0;

$failingStudents = 0;


foreach ($studentAverages as $studentAverage) {

    if (
        $studentAverage->average_score
        >=
        $passMark
    ) {

        $passingStudents++;

    } else {

        $failingStudents++;

    }

}


/*
|--------------------------------------------------------------------------
| PASS PERCENTAGE
|--------------------------------------------------------------------------
*/

$passPercentage = $studentsWithResults > 0

    ? round(
        (
            $passingStudents
            /
            $studentsWithResults
        )
        *
        100,
        2
    )

    : 0;


/*
|--------------------------------------------------------------------------
| FAIL PERCENTAGE
|--------------------------------------------------------------------------
*/

$failPercentage = $studentsWithResults > 0

    ? round(
        (
            $failingStudents
            /
            $studentsWithResults
        )
        *
        100,
        2
    )

    : 0;


/*
|--------------------------------------------------------------------------
| ABOVE AVERAGE PERCENTAGE
|--------------------------------------------------------------------------
*/

$aboveAveragePercentage = $studentsWithResults > 0

    ? round(
        (
            $aboveAverageStudents
            /
            $studentsWithResults
        )
        *
        100,
        2
    )

    : 0;


/*
|--------------------------------------------------------------------------
| BELOW AVERAGE PERCENTAGE
|--------------------------------------------------------------------------
*/

$belowAveragePercentage = $studentsWithResults > 0

    ? round(
        (
            $belowAverageStudents
            /
            $studentsWithResults
        )
        *
        100,
        2
    )

    : 0;


/*
|--------------------------------------------------------------------------
| CLASS PERFORMANCE
|--------------------------------------------------------------------------
|
| If "All Classes" is selected, we analyse every class.
|
| If one class is selected, only that class is analysed.
|
|--------------------------------------------------------------------------
*/

$classPerformance = [];


$classesForAnalysis =
    $selectedClass === 'all'

    ? $allClasses

    : $allClasses->where(
        'id',
        $selectedClass
    );


foreach (
    $classesForAnalysis
    as $class
) {


    /*
    |--------------------------------------------------------------------------
    | CLASS RESULT QUERY
    |--------------------------------------------------------------------------
    */

    $classResultQuery = Result::where(
        'student_classes_id',
        $class->id
    )
    ->where(
        'term',
        $selectedTerm
    )
    ->where(
        'session',
        $selectedSession
    );


    /*
    |--------------------------------------------------------------------------
    | CLASS AVERAGE
    |--------------------------------------------------------------------------
    */

    $classAverage =
        $classResultQuery->avg('total');


    /*
    |--------------------------------------------------------------------------
    | STUDENTS WITH RESULTS IN THIS CLASS
    |--------------------------------------------------------------------------
    */

    $classStudentCount =
        $classResultQuery
            ->distinct('student_id')
            ->count('student_id');


    /*
    |--------------------------------------------------------------------------
    | RESULT RECORD COUNT
    |--------------------------------------------------------------------------
    */

    $classResultCount =
        $classResultQuery->count();


    /*
    |--------------------------------------------------------------------------
    | SAVE CLASS ANALYSIS
    |--------------------------------------------------------------------------
    */

    $classPerformance[] = [

        'id' => $class->id,

        'name' => $class->class_name,

        'average' =>
            round(
                $classAverage ?? 0,
                2
            ),

        'students' =>
            $classStudentCount,

        'results' =>
            $classResultCount,

    ];

}


/*
|--------------------------------------------------------------------------
| CLASS CHART DATA
|--------------------------------------------------------------------------
*/

$classChartLabels = [];

$classChartAverages = [];


foreach (
    $classPerformance
    as $classData
) {

    $classChartLabels[] =
        $classData['name'];

    $classChartAverages[] =
        $classData['average'];

}


/*
|--------------------------------------------------------------------------
| CLASS ABOVE / BELOW AVERAGE
|--------------------------------------------------------------------------
|
| This tells the administrator how many students in each class are
| above or below the current analysis average.
|
|--------------------------------------------------------------------------
*/

$classAboveBelow = [];


foreach (
    $classesForAnalysis
    as $class
) {


    $studentClassResults =
        Result::where(
            'student_classes_id',
            $class->id
        )
        ->where(
            'term',
            $selectedTerm
        )
        ->where(
            'session',
            $selectedSession
        )
        ->select(
            'student_id'
        )
        ->selectRaw(
            'AVG(total) as average_score'
        )
        ->groupBy(
            'student_id'
        )
        ->get();


    $above = 0;

    $below = 0;


    foreach (
        $studentClassResults
        as $studentResult
    ) {

        if (
            $studentResult->average_score
            >=
            $overallAverage
        ) {

            $above++;

        } else {

            $below++;

        }

    }


    $classAboveBelow[] = [

        'class' =>
            $class->class_name,

        'above' =>
            $above,

        'below' =>
            $below,

    ];

}


/*
|--------------------------------------------------------------------------
| SUBJECT PERFORMANCE
|--------------------------------------------------------------------------
|
| We calculate the average result for every subject.
|
|--------------------------------------------------------------------------
*/

$subjectPerformance = [];


$subjects = Subject::orderBy(
    'subject_name'
)->get();


foreach (
    $subjects
    as $subject
) {


    /*
    |--------------------------------------------------------------------------
    | SUBJECT QUERY
    |--------------------------------------------------------------------------
    */

    $subjectResultQuery =
        (clone $resultQuery)
        ->where(
            'subject_id',
            $subject->id
        );


    /*
    |--------------------------------------------------------------------------
    | SUBJECT AVERAGE
    |--------------------------------------------------------------------------
    */

    $subjectAverage =
        $subjectResultQuery->avg(
            'total'
        );


    /*
    |--------------------------------------------------------------------------
    | SUBJECT STUDENT COUNT
    |--------------------------------------------------------------------------
    */

    $subjectStudentCount =
        $subjectResultQuery
            ->distinct('student_id')
            ->count('student_id');


    /*
    |--------------------------------------------------------------------------
    | SAVE SUBJECT ANALYSIS
    |--------------------------------------------------------------------------
    */

    $subjectPerformance[] = [

        'id' =>
            $subject->id,

        'name' =>
            $subject->subject_name,

        'average' =>
            round(
                $subjectAverage ?? 0,
                2
            ),

        'students' =>
            $subjectStudentCount,

    ];

}


/*
|--------------------------------------------------------------------------
| SUBJECT CHART DATA
|--------------------------------------------------------------------------
*/

$subjectChartLabels = [];

$subjectChartAverages = [];


foreach (
    $subjectPerformance
    as $subjectData
) {

    $subjectChartLabels[] =
        $subjectData['name'];

    $subjectChartAverages[] =
        $subjectData['average'];

}


/*
|--------------------------------------------------------------------------
| GRADE DISTRIBUTION
|--------------------------------------------------------------------------
|
| We count how many result records belong to each grade.
|
| Example:
|
| A = 50
| B = 80
| C = 100
| D = 40
|
|--------------------------------------------------------------------------
*/

$gradeDistribution =
    (clone $resultQuery)
    ->select('grade')
    ->selectRaw(
        'COUNT(*) as total'
    )
    ->groupBy('grade')
    ->orderBy('grade')
    ->get();


$gradeLabels = [];

$gradeCounts = [];


foreach (
    $gradeDistribution
    as $grade
) {

    $gradeLabels[] =
        $grade->grade ?: 'N/A';

    $gradeCounts[] =
        $grade->total;

}


/*
|--------------------------------------------------------------------------
| TOP STUDENTS
|--------------------------------------------------------------------------
|
| We calculate the average of each student and display the students
| with the highest calculated averages.
|
| This is not changing their result.
|
| It is simply an analysis of the existing result records.
|
|--------------------------------------------------------------------------
*/

$topStudents =
    (clone $resultQuery)
    ->select(
        'student_id'
    )
    ->selectRaw(
        'AVG(total) as average_score'
    )
    ->selectRaw(
        'COUNT(*) as subject_count'
    )
    ->groupBy(
        'student_id'
    )
    ->orderByDesc(
        'average_score'
    )
    ->limit(10)
    ->get();


$topStudentData = [];


foreach (
    $topStudents
    as $studentResult
) {


    $student =
        Student::with('user')
        ->find(
            $studentResult->student_id
        );


    if (!$student) {

        continue;

    }


    /*
    |--------------------------------------------------------------------------
    | STUDENT NAME
    |--------------------------------------------------------------------------
    */

    $studentName =
        $student->user
        ? $student->user->name
        : 'Student #' . $student->id;


    /*
    |--------------------------------------------------------------------------
    | CLASS NAME
    |--------------------------------------------------------------------------
    */

    $studentClass =
        StudentClasses::find(
            $student->student_classes_id
        );


    $topStudentData[] = [

        'name' =>
            $studentName,

        'class' =>
            $studentClass
            ? $studentClass->class_name
            : 'N/A',

        'average' =>
            round(
                $studentResult->average_score,
                2
            ),

        'subjects' =>
            $studentResult->subject_count,

    ];

}


/*
|--------------------------------------------------------------------------
| STUDENTS BELOW AVERAGE
|--------------------------------------------------------------------------
|
| These are useful for identifying students that may need additional
| academic attention.
|
|--------------------------------------------------------------------------
*/

$studentsBelowAverage = [];


$belowAverageQuery =
    (clone $resultQuery)
    ->select(
        'student_id'
    )
    ->selectRaw(
        'AVG(total) as average_score'
    )
    ->selectRaw(
        'COUNT(*) as subject_count'
    )
    ->groupBy(
        'student_id'
    )
    ->having(
        DB::raw('AVG(total)'),
        '<',
        $overallAverage
    )
    ->orderBy(
        'average_score'
    )
    ->limit(20)
    ->get();


foreach (
    $belowAverageQuery
    as $studentResult
) {


    $student =
        Student::with('user')
        ->find(
            $studentResult->student_id
        );


    if (!$student) {

        continue;

    }


    $studentName =
        $student->user
        ? $student->user->name
        : 'Student #' . $student->id;


    $studentClass =
        StudentClasses::find(
            $student->student_classes_id
        );


    $studentsBelowAverage[] = [

        'name' =>
            $studentName,

        'class' =>
            $studentClass
            ? $studentClass->class_name
            : 'N/A',

        'average' =>
            round(
                $studentResult->average_score,
                2
            ),

    ];

}


/*
|--------------------------------------------------------------------------
| STUDENTS ABOVE AVERAGE
|--------------------------------------------------------------------------
*/

$studentsAboveAverage = [];


$aboveAverageQuery =
    (clone $resultQuery)
    ->select(
        'student_id'
    )
    ->selectRaw(
        'AVG(total) as average_score'
    )
    ->selectRaw(
        'COUNT(*) as subject_count'
    )
    ->groupBy(
        'student_id'
    )
    ->having(
        DB::raw('AVG(total)'),
        '>=',
        $overallAverage
    )
    ->orderByDesc(
        'average_score'
    )
    ->limit(20)
    ->get();


foreach (
    $aboveAverageQuery
    as $studentResult
) {


    $student =
        Student::with('user')
        ->find(
            $studentResult->student_id
        );


    if (!$student) {

        continue;

    }


    $studentName =
        $student->user
        ? $student->user->name
        : 'Student #' . $student->id;


    $studentClass =
        StudentClasses::find(
            $student->student_classes_id
        );


    $studentsAboveAverage[] = [

        'name' =>
            $studentName,

        'class' =>
            $studentClass
            ? $studentClass->class_name
            : 'N/A',

        'average' =>
            round(
                $studentResult->average_score,
                2
            ),

    ];

}


/*
|--------------------------------------------------------------------------
| CA / EXAM PERFORMANCE
|--------------------------------------------------------------------------
|
| This is one of the most useful additions.
|
| Instead of looking only at the final total, we can see how students
| performed in:
|
| CA1
| CA2
| CA3
| EXAM
|
| This can help the school identify whether students are performing
| consistently during continuous assessment or only during exams.
|
|--------------------------------------------------------------------------
*/

$componentPerformance = [

    'CA1' =>
        round(
            (clone $resultQuery)->avg('ca1') ?? 0,
            2
        ),

    'CA2' =>
        round(
            (clone $resultQuery)->avg('ca2') ?? 0,
            2
        ),

    'CA3' =>
        round(
            (clone $resultQuery)->avg('ca3') ?? 0,
            2
        ),

    'Exam' =>
        round(
            (clone $resultQuery)->avg('exam') ?? 0,
            2
        ),

];


/*
|--------------------------------------------------------------------------
| PUBLICATION ANALYSIS
|--------------------------------------------------------------------------
|
| This connects the dashboard with the result publication feature
| we built earlier.
|
|--------------------------------------------------------------------------
*/

$totalPublishedResults =
    (clone $resultQuery)
    ->where(
        'publish',
        1
    )
    ->count();


$totalUnpublishedResults =
    max(
        $totalResultRecords
        -
        $totalPublishedResults,
        0
    );


$publicationPercentage =
    $totalResultRecords > 0

    ? round(
        (
            $totalPublishedResults
            /
            $totalResultRecords
        )
        * 100,
        2
    )

    : 0;


/*
|--------------------------------------------------------------------------
| TERM-TO-TERM PERFORMANCE
|--------------------------------------------------------------------------
|
| This is useful when the admin selects a particular session.
|
| We calculate the average for:
|
| First Term
| Second Term
| Third Term
|
| It allows the dashboard to show academic movement across the year.
|
|--------------------------------------------------------------------------
*/

$termPerformance = [];


foreach (
    $terms
    as $term
) {


    $termAverageQuery =
        Result::where(
            'session',
            $selectedSession
        )
        ->where(
            'term',
            $term->name
        );


    /*
    |--------------------------------------------------------------------------
    | APPLY CLASS FILTER TO TERM ANALYSIS
    |--------------------------------------------------------------------------
    */

    if (
        $selectedClass !== 'all'
    ) {

        $termAverageQuery->where(
            'student_classes_id',
            $selectedClass
        );

    }


    $termAverage =
        $termAverageQuery->avg(
            'total'
        );


    $termPerformance[] = [

        'term' =>
            $term->name,

        'average' =>
            round(
                $termAverage ?? 0,
                2
            ),

    ];

}


/*
|--------------------------------------------------------------------------
| TERM CHART DATA
|--------------------------------------------------------------------------
*/

$termChartLabels = [];

$termChartAverages = [];


foreach (
    $termPerformance
    as $termData
) {

    $termChartLabels[] =
        $termData['term'];

    $termChartAverages[] =
        $termData['average'];

}


/*
|--------------------------------------------------------------------------
| CBT ANALYTICS
|--------------------------------------------------------------------------
|
| We keep your existing CBT dashboard functionality.
|
|--------------------------------------------------------------------------
*/

$totalTests =
    CbtTest::where(
        'term',
        $selectedTerm
    )
    ->where(
        'session',
        $selectedSession
    )
    ->count();


$totalAttempts =
    CbtAttempt::whereHas(
        'test',
        function ($q)
        use (
            $selectedTerm,
            $selectedSession
        ) {

            $q->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );

        }
    )
    ->count();


$completedAttempts =
    CbtAttempt::where(
        'status',
        'completed'
    )
    ->whereHas(
        'test',
        function ($q)
        use (
            $selectedTerm,
            $selectedSession
        ) {

            $q->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );

        }
    )
    ->count();


$inProgressAttempts =
    CbtAttempt::where(
        'status',
        'in_progress'
    )
    ->whereHas(
        'test',
        function ($q)
        use (
            $selectedTerm,
            $selectedSession
        ) {

            $q->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );

        }
    )
    ->count();


$passCount =
    CbtAttempt::where(
        'status',
        'completed'
    )
    ->whereHas(
        'test',
        function ($q)
        use (
            $selectedTerm,
            $selectedSession
        ) {

            $q->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );

        }
    )
    ->where(
        'score',
        '>=',
        40
    )
    ->count();


$failCount =
    CbtAttempt::where(
        'status',
        'completed'
    )
    ->whereHas(
        'test',
        function ($q)
        use (
            $selectedTerm,
            $selectedSession
        ) {

            $q->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );

        }
    )
    ->where(
        'score',
        '<',
        40
    )
    ->count();


/*
|--------------------------------------------------------------------------
| STUDENT GROWTH
|--------------------------------------------------------------------------
|
| This remains based on student registration date.
|
|--------------------------------------------------------------------------
*/

$monthlyStudents = [];

$months = [

    'Jan',
    'Feb',
    'Mar',
    'Apr',
    'May',
    'Jun',
    'Jul',
    'Aug',
    'Sep',
    'Oct',
    'Nov',
    'Dec'

];


foreach (
    $months
    as $index => $month
) {

    $monthlyStudents[] =
        Student::whereYear(
            'created_at',
            date('Y')
        )
        ->whereMonth(
            'created_at',
            $index + 1
        )
        ->count();

}


/*
|--------------------------------------------------------------------------
| CLASS ABOVE / BELOW CHART DATA
|--------------------------------------------------------------------------
*/

$classAboveLabels = [];

$classAboveCounts = [];

$classBelowCounts = [];


foreach (
    $classAboveBelow
    as $classData
) {

    $classAboveLabels[] =
        $classData['class'];

    $classAboveCounts[] =
        $classData['above'];

    $classBelowCounts[] =
        $classData['below'];

}


@endphp


<style>

/*
|--------------------------------------------------------------------------
| DASHBOARD STYLE
|--------------------------------------------------------------------------
*/

.dashboard-card {

    min-height:
        155px;

    transition:
        all .3s ease-in-out;

}


.dashboard-card:hover {

    transform:
        translateY(-7px);

    box-shadow:
        0 12px 25px
        rgba(0,0,0,.15)
        !important;

}


.dashboard-card .card-body {

    padding:
        1.6rem;

}


.dashboard-card h3 {

    font-size:
        1.8rem;

}


/*
|--------------------------------------------------------------------------
| ANALYSIS CARDS
|--------------------------------------------------------------------------
*/

.analysis-card {

    border:
        0;

    border-radius:
        18px;

    transition:
        all .3s ease;

}


.analysis-card:hover {

    transform:
        translateY(-5px);

    box-shadow:
        0 10px 25px
        rgba(0,0,0,.10)
        !important;

}


.analysis-icon {

    width:
        52px;

    height:
        52px;

    border-radius:
        14px;

    display:
        flex;

    align-items:
        center;

    justify-content:
        center;

    font-size:
        22px;

}


.metric-number {

    font-size:
        27px;

    font-weight:
        700;

}


.metric-title {

    font-size:
        13px;

    color:
        #6c757d;

}


/*
|--------------------------------------------------------------------------
| FILTER
|--------------------------------------------------------------------------
*/

.analysis-filter {

    border:
        0;

    border-radius:
        18px;

    box-shadow:
        0 8px 25px
        rgba(0,0,0,.08);

}


.analysis-filter label {

    font-weight:
        600;

    font-size:
        13px;

}


.analysis-filter select {

    min-height:
        45px;

    border-radius:
        10px;

}


/*
|--------------------------------------------------------------------------
| CHART
|--------------------------------------------------------------------------
*/

.chart-container {

    position:
        relative;

    width:
        100%;

    height:
        350px;

}


.small-chart {

    height:
        280px;

}


/*
|--------------------------------------------------------------------------
| TABLE
|--------------------------------------------------------------------------
*/

.analysis-table th {

    white-space:
        nowrap;

    font-size:
        13px;

}


.analysis-table td {

    vertical-align:
        middle;

    font-size:
        13px;

}


/*
|--------------------------------------------------------------------------
| PERIOD BADGE
|--------------------------------------------------------------------------
*/

.current-period {

    background:
        #f1f5f9;

    border-radius:
        12px;

    padding:
        11px 16px;

    font-size:
        13px;

}


/*
|--------------------------------------------------------------------------
| FILTER BUTTON
|--------------------------------------------------------------------------
*/

.filter-button {

    min-height:
        45px;

    border-radius:
        10px;

}


/*
|--------------------------------------------------------------------------
| ANIMATION
|--------------------------------------------------------------------------
*/

.animate-card {

    opacity:
        0;

    transform:
        translateY(25px);

    animation:
        dashboardPop
        .7s ease forwards;

    animation-delay:
        var(--delay,0s);

}


@keyframes dashboardPop {

    to {

        opacity:
            1;

        transform:
            translateY(0);

    }

}

</style>


<div class="container-fluid">


{{-- ============================================================= --}}
{{-- PAGE HEADER --}}
{{-- ============================================================= --}}

<div
    class="row animate-card"
    style="--delay:0s;"
>

    <div class="col-12">

        <div
            class="
            page-title-box
            d-sm-flex
            align-items-center
            justify-content-between
            "
        >

            <div>

                <h4 class="mb-sm-0">
                    Academic Performance Dashboard
                </h4>

                <p class="text-muted mb-0 mt-1">

                    Academic analysis,
                    performance monitoring
                    and result statistics

                </p>

            </div>


            <div class="current-period">

                <i class="fas fa-chart-line me-1"></i>

                <strong>

                    {{ $selectedTerm }}

                </strong>

                <span class="mx-1">
                    |
                </span>

                <strong>

                    {{ $selectedSession }}

                </strong>

                <span class="mx-1">
                    |
                </span>

                <strong>

                    {{ $selectedClassName }}

                </strong>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- ANALYSIS FILTER --}}
{{-- ============================================================= --}}

<div class="row mb-4">

    <div class="col-12">

        <div class="card analysis-filter">

            <div class="card-body">

                <div class="row align-items-end">


                    {{-- SESSION --}}
                    <div class="col-xl-3 col-md-6 mb-3">

                        <label
                            for="analysisSession"
                            class="form-label"
                        >

                            Academic Session

                        </label>

                        <select
                            id="analysisSession"
                            class="form-select"
                        >

                            @foreach(
                                $academicSessions
                                as $session
                            )

                                <option
                                    value="{{ $session->name }}"
                                    {{ $selectedSession == $session->name
                                        ? 'selected'
                                        : ''
                                    }}
                                >

                                    {{ $session->name }}

                                </option>

                            @endforeach

                        </select>

                    </div>


                    {{-- TERM --}}
                    <div class="col-xl-3 col-md-6 mb-3">

                        <label
                            for="analysisTerm"
                            class="form-label"
                        >

                            Term

                        </label>

                        <select
                            id="analysisTerm"
                            class="form-select"
                        >

                            @foreach(
                                $terms
                                as $term
                            )

                                <option
                                    value="{{ $term->name }}"
                                    {{ $selectedTerm == $term->name
                                        ? 'selected'
                                        : ''
                                    }}
                                >

                                    {{ $term->name }}

                                </option>

                            @endforeach

                        </select>

                    </div>


                    {{-- CLASS --}}
                    <div class="col-xl-3 col-md-6 mb-3">

                        <label
                            for="analysisClass"
                            class="form-label"
                        >

                            Class

                        </label>

                        <select
                            id="analysisClass"
                            class="form-select"
                        >

                            <option value="all"
                                {{ $selectedClass == 'all'
                                    ? 'selected'
                                    : ''
                                }}
                            >

                                All Classes

                            </option>


                            @foreach(
                                $allClasses
                                as $class
                            )

                                <option
                                    value="{{ $class->id }}"
                                    {{ $selectedClass == $class->id
                                        ? 'selected'
                                        : ''
                                    }}
                                >

                                    {{ $class->class_name }}

                                </option>

                            @endforeach

                        </select>

                    </div>


                    {{-- BUTTON --}}
                    <div class="col-xl-3 col-md-6 mb-3">

                        <button
                            type="button"
                            id="runAnalysis"
                            class="
                            btn
                            btn-primary
                            w-100
                            filter-button
                            "
                        >

                            <i class="fas fa-chart-bar me-1"></i>

                            Analyse Result

                        </button>

                    </div>

                </div>


                {{-- EXPLANATION --}}
                <div class="mt-2">

                    <small class="text-muted">

                        <i class="fas fa-info-circle me-1"></i>

                        Select an academic session,
                        term and class to recalculate
                        the complete academic analysis.

                    </small>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- BASIC SCHOOL STATISTICS --}}
{{-- ============================================================= --}}

<div class="row">


    {{-- STUDENTS --}}
    <div
        class="col-xl-3 col-md-6 mb-4 animate-card"
        style="--delay:.1s;"
    >

        <div
            class="
            card
            dashboard-card
            shadow-lg
            border-0
            rounded-4
            text-white
            "
            style="
            background:
            linear-gradient(
                135deg,
                #6a11cb,
                #2575fc
            );
            "
        >

            <div class="card-body">

                <div class="d-flex align-items-center">

                    <div class="flex-grow-1">

                        <p class="mb-1 fw-semibold">

                            Total Students

                        </p>

                        <h3
                            class="fw-bold mb-0"
                            style="color:white;"
                        >

                            {{ $totalstudent }}

                        </h3>

                    </div>


                    <div
                        class="
                        avatar-sm
                        bg-white
                        bg-opacity-25
                        rounded-3
                        d-flex
                        align-items-center
                        justify-content-center
                        "
                    >

                        <i class="ri-user-3-line fs-3"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- SUBJECTS --}}
    <div
        class="col-xl-3 col-md-6 mb-4 animate-card"
        style="--delay:.2s;"
    >

        <div
            class="
            card
            dashboard-card
            shadow-lg
            border-0
            rounded-4
            text-white
            "
            style="
            background:
            linear-gradient(
                135deg,
                #00b09b,
                #96c93d
            );
            "
        >

            <div class="card-body">

                <div class="d-flex align-items-center">

                    <div class="flex-grow-1">

                        <p class="mb-1 fw-semibold">

                            Total Subjects

                        </p>

                        <h3
                            class="fw-bold mb-0"
                            style="color:white;"
                        >

                            {{ $totalsubject }}

                        </h3>

                    </div>


                    <div
                        class="
                        avatar-sm
                        bg-white
                        bg-opacity-25
                        rounded-3
                        d-flex
                        align-items-center
                        justify-content-center
                        "
                    >

                        <i class="fas fa-book-open fs-3"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- CLASSES --}}
    <div
        class="col-xl-3 col-md-6 mb-4 animate-card"
        style="--delay:.3s;"
    >

        <div
            class="
            card
            dashboard-card
            shadow-lg
            border-0
            rounded-4
            text-white
            "
            style="
            background:
            linear-gradient(
                135deg,
                #ff416c,
                #ff4b2b
            );
            "
        >

            <div class="card-body">

                <div class="d-flex align-items-center">

                    <div class="flex-grow-1">

                        <p class="mb-1 fw-semibold">

                            Total Classes

                        </p>

                        <h3
                            class="fw-bold mb-0"
                            style="color:white;"
                        >

                            {{ $totalclass }}

                        </h3>

                    </div>


                    <div
                        class="
                        avatar-sm
                        bg-white
                        bg-opacity-25
                        rounded-3
                        d-flex
                        align-items-center
                        justify-content-center
                        "
                    >

                        <i class="ri-building-line fs-3"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- TEACHERS --}}
    <div
        class="col-xl-3 col-md-6 mb-4 animate-card"
        style="--delay:.4s;"
    >

        <div
            class="
            card
            dashboard-card
            shadow-lg
            border-0
            rounded-4
            text-white
            "
            style="
            background:
            linear-gradient(
                135deg,
                #36d1dc,
                #5b86e5
            );
            "
        >

            <div class="card-body">

                <div class="d-flex align-items-center">

                    <div class="flex-grow-1">

                        <p class="mb-1 fw-semibold">

                            Total Teachers

                        </p>

                        <h3
                            class="fw-bold mb-0"
                            style="color:white;"
                        >

                            {{ $totalteachers }}

                        </h3>

                    </div>


                    <div
                        class="
                        avatar-sm
                        bg-white
                        bg-opacity-25
                        rounded-3
                        d-flex
                        align-items-center
                        justify-content-center
                        "
                    >

                        <i class="fas fa-chalkboard-teacher fs-3"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- ACADEMIC SUMMARY --}}
{{-- ============================================================= --}}

<div class="row">


    {{-- OVERALL AVERAGE --}}
    <div class="col-xl-3 col-md-6 mb-4">

        <div class="card analysis-card shadow-sm">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <div class="metric-title">

                            Overall Average

                        </div>

                        <div
                            class="metric-number text-primary"
                        >

                            {{ number_format(
                                $overallAverage,
                                2
                            ) }}%

                        </div>

                        <small class="text-muted">

                            {{ $selectedClassName }}

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-primary-subtle
                        text-primary
                        "
                    >

                        <i class="fas fa-chart-line"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- STUDENTS WITH RESULTS --}}
    <div class="col-xl-3 col-md-6 mb-4">

        <div class="card analysis-card shadow-sm">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <div class="metric-title">

                            Students With Results

                        </div>

                        <div
                            class="metric-number text-success"
                        >

                            {{ $studentsWithResults }}

                        </div>

                        <small class="text-muted">

                            Students analysed

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-success-subtle
                        text-success
                        "
                    >

                        <i class="fas fa-user-check"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- ABOVE AVERAGE --}}
    <div class="col-xl-3 col-md-6 mb-4">

        <div class="card analysis-card shadow-sm">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <div class="metric-title">

                            Above Average

                        </div>

                        <div
                            class="metric-number text-info"
                        >

                            {{ $aboveAverageStudents }}

                        </div>

                        <small class="text-muted">

                            {{ $aboveAveragePercentage }}%

                            of analysed students

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-info-subtle
                        text-info
                        "
                    >

                        <i class="fas fa-arrow-up"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- BELOW AVERAGE --}}
    <div class="col-xl-3 col-md-6 mb-4">

        <div class="card analysis-card shadow-sm">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <div class="metric-title">

                            Below Average

                        </div>

                        <div
                            class="metric-number text-danger"
                        >

                            {{ $belowAverageStudents }}

                        </div>

                        <small class="text-muted">

                            {{ $belowAveragePercentage }}%

                            of analysed students

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-danger-subtle
                        text-danger
                        "
                    >

                        <i class="fas fa-arrow-down"></i>

                    </div>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- PASS / FAIL / PUBLICATION --}}
{{-- ============================================================= --}}

<div class="row">


    {{-- PASS --}}
    <div class="col-xl-4 col-md-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <p class="text-muted mb-1">

                            Student Pass Rate

                        </p>

                        <h3
                            class="text-success fw-bold"
                        >

                            {{ $passPercentage }}%

                        </h3>

                        <small>

                            {{ $passingStudents }}
                            passing students

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-success-subtle
                        text-success
                        "
                    >

                        <i class="fas fa-check-circle"></i>

                    </div>

                </div>


                <div
                    class="progress mt-3"
                    style="height:8px;"
                >

                    <div
                        class="progress-bar bg-success"
                        style="
                        width:
                        {{ $passPercentage }}%;
                        "
                    ></div>

                </div>

            </div>

        </div>

    </div>


    {{-- FAIL --}}
    <div class="col-xl-4 col-md-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <p class="text-muted mb-1">

                            Below Pass Mark

                        </p>

                        <h3
                            class="text-danger fw-bold"
                        >

                            {{ $failPercentage }}%

                        </h3>

                        <small>

                            {{ $failingStudents }}

                            students below {{ $passMark }}%

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-danger-subtle
                        text-danger
                        "
                    >

                        <i class="
                            fas
                            fa-exclamation-triangle
                        "></i>

                    </div>

                </div>


                <div
                    class="progress mt-3"
                    style="height:8px;"
                >

                    <div
                        class="progress-bar bg-danger"
                        style="
                        width:
                        {{ $failPercentage }}%;
                        "
                    ></div>

                </div>

            </div>

        </div>

    </div>


    {{-- PUBLICATION --}}
    <div class="col-xl-4 col-md-12 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-body">

                <div class="d-flex justify-content-between">

                    <div>

                        <p class="text-muted mb-1">

                            Result Publication

                        </p>

                        <h3
                            class="text-primary fw-bold"
                        >

                            {{ $publicationPercentage }}%

                        </h3>

                        <small>

                            {{ $totalPublishedResults }}
                            published /

                            {{ $totalResultRecords }}
                            total

                        </small>

                    </div>


                    <div
                        class="
                        analysis-icon
                        bg-primary-subtle
                        text-primary
                        "
                    >

                        <i class="
                            fas
                            fa-cloud-upload-alt
                        "></i>

                    </div>

                </div>


                <div
                    class="progress mt-3"
                    style="height:8px;"
                >

                    <div
                        class="progress-bar bg-primary"
                        style="
                        width:
                        {{ $publicationPercentage }}%;
                        "
                    ></div>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- COMPONENT PERFORMANCE --}}
{{-- ============================================================= --}}

<div class="row">

    <div class="col-12 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Assessment Component Performance

                </h5>

                <small class="text-muted">

                    Average performance across CA1,
                    CA2, CA3 and Examination

                </small>

            </div>


            <div class="card-body">

                <div class="row">


                    @foreach(
                        $componentPerformance
                        as $component => $average
                    )

                        <div
                            class="
                            col-xl-3
                            col-md-6
                            mb-3
                            "
                        >

                            <div
                                class="
                                p-3
                                rounded-4
                                bg-light
                                "
                            >

                                <div
                                    class="
                                    d-flex
                                    justify-content-between
                                    "
                                >

                                    <span
                                        class="fw-semibold"
                                    >

                                        {{ $component }}

                                    </span>

                                    <strong>

                                        {{ number_format(
                                            $average,
                                            2
                                        ) }}%

                                    </strong>

                                </div>


                                <div
                                    class="progress mt-2"
                                    style="height:8px;"
                                >

                                    <div
                                        class="
                                        progress-bar
                                        "
                                        style="
                                        width:
                                        {{ min(
                                            $average,
                                            100
                                        ) }}%;
                                        "
                                    ></div>

                                </div>

                            </div>

                        </div>

                    @endforeach

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- CLASS PERFORMANCE CHART --}}
{{-- ============================================================= --}}

<div class="row">


    <div class="col-xl-8 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Class Performance

                </h5>

                <small class="text-muted">

                    Average score per class

                </small>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="classPerformanceChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>


    <div class="col-xl-4 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Above vs Below Average

                </h5>

                <small class="text-muted">

                    Current analysis

                </small>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="aboveBelowChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- SUBJECT PERFORMANCE --}}
{{-- ============================================================= --}}

<div class="row">


    <div class="col-xl-8 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Subject Performance

                </h5>

                <small class="text-muted">

                    Average result by subject

                </small>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="subjectPerformanceChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>


    <div class="col-xl-4 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Grade Distribution

                </h5>

                <small class="text-muted">

                    Distribution of recorded grades

                </small>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="gradeDistributionChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- TERM PERFORMANCE TREND --}}
{{-- ============================================================= --}}

<div class="row">

    <div class="col-12 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Academic Term Performance Trend

                </h5>

                <small class="text-muted">

                    Average performance across the selected session

                </small>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="termPerformanceChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- STUDENTS ABOVE / BELOW AVERAGE --}}
{{-- ============================================================= --}}

<div class="row">


    {{-- ABOVE --}}
    <div class="col-xl-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <div
                    class="
                    d-flex
                    justify-content-between
                    "
                >

                    <div>

                        <h5 class="mb-1">

                            Students Above Average

                        </h5>

                        <small class="text-muted">

                            Average ≥
                            {{ number_format(
                                $overallAverage,
                                2
                            ) }}%

                        </small>

                    </div>


                    <span class="badge bg-success">

                        {{ count(
                            $studentsAboveAverage
                        ) }}

                    </span>

                </div>

            </div>


            <div class="card-body p-0">

                <div class="table-responsive">

                    <table
                        class="
                        table
                        table-hover
                        align-middle
                        mb-0
                        analysis-table
                        "
                    >

                        <thead class="table-light">

                            <tr>

                                <th>
                                    #
                                </th>

                                <th>
                                    Student
                                </th>

                                <th>
                                    Class
                                </th>

                                <th>
                                    Average
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                            @forelse(
                                $studentsAboveAverage
                                as $index => $student
                            )

                                <tr>

                                    <td>
                                        {{ $index + 1 }}
                                    </td>

                                    <td class="fw-semibold">

                                        {{ $student['name'] }}

                                    </td>

                                    <td>

                                        {{ $student['class'] }}

                                    </td>

                                    <td>

                                        <span
                                            class="
                                            badge
                                            bg-success
                                            "
                                        >

                                            {{ number_format(
                                                $student['average'],
                                                2
                                            ) }}%

                                        </span>

                                    </td>

                                </tr>

                            @empty

                                <tr>

                                    <td
                                        colspan="4"
                                        class="
                                        text-center
                                        py-4
                                        "
                                    >

                                        No student result available.

                                    </td>

                                </tr>

                            @endforelse

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>


    {{-- BELOW --}}
    <div class="col-xl-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <div
                    class="
                    d-flex
                    justify-content-between
                    "
                >

                    <div>

                        <h5 class="mb-1">

                            Students Below Average

                        </h5>

                        <small class="text-muted">

                            Students requiring attention

                        </small>

                    </div>


                    <span class="badge bg-danger">

                        {{ count(
                            $studentsBelowAverage
                        ) }}

                    </span>

                </div>

            </div>


            <div class="card-body p-0">

                <div class="table-responsive">

                    <table
                        class="
                        table
                        table-hover
                        align-middle
                        mb-0
                        analysis-table
                        "
                    >

                        <thead class="table-light">

                            <tr>

                                <th>
                                    #
                                </th>

                                <th>
                                    Student
                                </th>

                                <th>
                                    Class
                                </th>

                                <th>
                                    Average
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                            @forelse(
                                $studentsBelowAverage
                                as $index => $student
                            )

                                <tr>

                                    <td>

                                        {{ $index + 1 }}

                                    </td>

                                    <td class="fw-semibold">

                                        {{ $student['name'] }}

                                    </td>

                                    <td>

                                        {{ $student['class'] }}

                                    </td>

                                    <td>

                                        <span
                                            class="
                                            badge
                                            bg-danger
                                            "
                                        >

                                            {{ number_format(
                                                $student['average'],
                                                2
                                            ) }}%

                                        </span>

                                    </td>

                                </tr>

                            @empty

                                <tr>

                                    <td
                                        colspan="4"
                                        class="
                                        text-center
                                        py-4
                                        "
                                    >

                                        No student below average.

                                    </td>

                                </tr>

                            @endforelse

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- TOP STUDENTS --}}
{{-- ============================================================= --}}

<div class="row">

    <div class="col-12 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Top Student Performance

                </h5>

                <small class="text-muted">

                    Highest calculated student averages

                </small>

            </div>


            <div class="card-body">

                <div class="table-responsive">

                    <table
                        class="
                        table
                        table-hover
                        align-middle
                        analysis-table
                        "
                    >

                        <thead class="table-light">

                            <tr>

                                <th>
                                    #
                                </th>

                                <th>
                                    Student
                                </th>

                                <th>
                                    Class
                                </th>

                                <th>
                                    Average
                                </th>

                                <th>
                                    Subjects
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                            @forelse(
                                $topStudentData
                                as $index => $student
                            )

                                <tr>

                                    <td>

                                        <span
                                            class="
                                            badge
                                            bg-primary
                                            rounded-circle
                                            "
                                        >

                                            {{ $index + 1 }}

                                        </span>

                                    </td>


                                    <td class="fw-semibold">

                                        {{ $student['name'] }}

                                    </td>


                                    <td>

                                        {{ $student['class'] }}

                                    </td>


                                    <td>

                                        <strong
                                            class="text-success"
                                        >

                                            {{ number_format(
                                                $student['average'],
                                                2
                                            ) }}%

                                        </strong>

                                    </td>


                                    <td>

                                        {{ $student['subjects'] }}

                                    </td>

                                </tr>

                            @empty

                                <tr>

                                    <td
                                        colspan="5"
                                        class="text-center py-4"
                                    >

                                        No result available.

                                    </td>

                                </tr>

                            @endforelse

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- CLASS PERFORMANCE TABLE --}}
{{-- ============================================================= --}}

<div class="row">

    <div class="col-12 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Detailed Class Analysis

                </h5>

                <small class="text-muted">

                    Student population and academic average

                </small>

            </div>


            <div class="card-body">

                <div class="table-responsive">

                    <table
                        class="
                        table
                        table-hover
                        align-middle
                        analysis-table
                        "
                    >

                        <thead class="table-light">

                            <tr>

                                <th>
                                    #
                                </th>

                                <th>
                                    Class
                                </th>

                                <th>
                                    Students
                                </th>

                                <th>
                                    Result Records
                                </th>

                                <th>
                                    Average
                                </th>

                                <th>
                                    Performance
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                            @forelse(
                                $classPerformance
                                as $index => $classData
                            )

                                <tr>

                                    <td>

                                        {{ $index + 1 }}

                                    </td>


                                    <td class="fw-semibold">

                                        {{ $classData['name'] }}

                                    </td>


                                    <td>

                                        {{ $classData['students'] }}

                                    </td>


                                    <td>

                                        {{ $classData['results'] }}

                                    </td>


                                    <td>

                                        <strong>

                                            {{ number_format(
                                                $classData['average'],
                                                2
                                            ) }}%

                                        </strong>

                                    </td>


                                    <td
                                        style="min-width:200px;"
                                    >

                                        <div
                                            class="progress"
                                            style="height:8px;"
                                        >

                                            <div
                                                class="
                                                progress-bar
                                                "
                                                style="
                                                width:
                                                {{ min(
                                                    $classData['average'],
                                                    100
                                                ) }}%;
                                                "
                                            ></div>

                                        </div>

                                    </td>

                                </tr>

                            @empty

                                <tr>

                                    <td
                                        colspan="6"
                                        class="
                                        text-center
                                        py-4
                                        "
                                    >

                                        No class result available.

                                    </td>

                                </tr>

                            @endforelse

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- SUBJECT ANALYSIS --}}
{{-- ============================================================= --}}

<div class="row">

    <div class="col-xl-7 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    Subject Analysis

                </h5>

                <small class="text-muted">

                    Average performance for each subject

                </small>

            </div>


            <div class="card-body">

                <div class="table-responsive">

                    <table
                        class="
                        table
                        table-hover
                        align-middle
                        analysis-table
                        "
                    >

                        <thead class="table-light">

                            <tr>

                                <th>
                                    #
                                </th>

                                <th>
                                    Subject
                                </th>

                                <th>
                                    Students
                                </th>

                                <th>
                                    Average
                                </th>

                            </tr>

                        </thead>


                        <tbody>

                            @forelse(
                                $subjectPerformance
                                as $index => $subjectData
                            )

                                <tr>

                                    <td>

                                        {{ $index + 1 }}

                                    </td>


                                    <td class="fw-semibold">

                                        {{ $subjectData['name'] }}

                                    </td>


                                    <td>

                                        {{ $subjectData['students'] }}

                                    </td>


                                    <td>

                                        <span
                                            class="
                                            badge
                                            {{
                                                $subjectData['average']
                                                >=
                                                $passMark

                                                ? 'bg-success'

                                                : 'bg-danger'
                                            }}
                                            "  style="font-size:14px;"
                                        >

                                            {{ number_format(
                                                $subjectData['average'],
                                                2
                                            ) }}%

                                        </span>

                                    </td>

                                </tr>

                            @empty

                                <tr>

                                    <td
                                        colspan="4"
                                        class="
                                        text-center
                                        py-4
                                        "
                                    >

                                        No subject result available.

                                    </td>

                                </tr>

                            @endforelse

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    </div>


    {{-- CBT --}}
    <div class="col-xl-5 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-1">

                    CBT Activity

                </h5>

                <small class="text-muted">

                    {{ $selectedTerm }}
                    -
                    {{ $selectedSession }}

                </small>

            </div>


            <div class="card-body">


                <div
                    class="
                    d-flex
                    justify-content-between
                    mb-3
                    "
                >

                    <span>
                        Total Tests
                    </span>

                    <strong>
                        {{ $totalTests }}
                    </strong>

                </div>


                <div
                    class="
                    d-flex
                    justify-content-between
                    mb-3
                    "
                >

                    <span>
                        Total Attempts
                    </span>

                    <strong>
                        {{ $totalAttempts }}
                    </strong>

                </div>


                <div
                    class="
                    d-flex
                    justify-content-between
                    mb-3
                    "
                >

                    <span>
                        Completed Attempts
                    </span>

                    <strong
                        class="text-success"
                    >

                        {{ $completedAttempts }}

                    </strong>

                </div>


                <div
                    class="
                    d-flex
                    justify-content-between
                    mb-3
                    "
                >

                    <span>
                        In Progress
                    </span>

                    <strong
                        class="text-warning"
                    >

                        {{ $inProgressAttempts }}

                    </strong>

                </div>


                <hr>


                <div
                    class="
                    d-flex
                    justify-content-between
                    mb-3
                    "
                >

                    <span>
                        CBT Pass
                    </span>

                    <strong
                        class="text-success"
                    >

                        {{ $passCount }}

                    </strong>

                </div>


                <div
                    class="
                    d-flex
                    justify-content-between
                    "
                >

                    <span>
                        CBT Fail
                    </span>

                    <strong
                        class="text-danger"
                    >

                        {{ $failCount }}

                    </strong>

                </div>

            </div>

        </div>

    </div>

</div>



{{-- ============================================================= --}}
{{-- STUDENT GROWTH + CBT --}}
{{-- ============================================================= --}}

<div class="row">


    {{-- STUDENT GROWTH --}}
    <div class="col-xl-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-primary text-white">

                <h5 class="mb-0 text-white">

                    Student Growth

                </h5>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="studentGrowthChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>


    {{-- CBT --}}
    <div class="col-xl-6 mb-4">

        <div class="card shadow-sm border-0 rounded-4">

            <div class="card-header bg-transparent">

                <h5 class="mb-0">

                    CBT Pass / Fail

                </h5>

            </div>


            <div class="card-body">

                <div class="chart-container">

                    <canvas
                        id="cbtPassFailChart"
                    ></canvas>

                </div>

            </div>

        </div>

    </div>

</div>


</div>



{{-- ============================================================= --}}
{{-- JAVASCRIPT --}}
{{-- ============================================================= --}}

<script>

document.addEventListener(
    'DOMContentLoaded',
    function () {


        /*
        |--------------------------------------------------------------------------
        | ANALYSIS FILTER
        |--------------------------------------------------------------------------
        |
        | When the administrator clicks "Analyse Result", we send the
        | selected values through the URL.
        |
        | Example:
        |
        | dashboard?session=2025/2026
        | &term=First%20Term
        | &class_id=5
        |
        | Laravel then reads those values using request()->get().
        |
        |--------------------------------------------------------------------------
        */

        const analysisButton =
            document.getElementById(
                'runAnalysis'
            );


        if (analysisButton) {

            analysisButton.addEventListener(
                'click',
                function () {


                    /*
                    |--------------------------------------------------------------------------
                    | GET SELECTED VALUES
                    |--------------------------------------------------------------------------
                    */

                    const session =
                        document.getElementById(
                            'analysisSession'
                        ).value;


                    const term =
                        document.getElementById(
                            'analysisTerm'
                        ).value;


                    const classId =
                        document.getElementById(
                            'analysisClass'
                        ).value;


                    /*
                    |--------------------------------------------------------------------------
                    | BUILD URL
                    |--------------------------------------------------------------------------
                    */

                    const url =
                        new URL(
                            window.location.href
                        );


                    /*
                    |--------------------------------------------------------------------------
                    | ADD FILTER PARAMETERS
                    |--------------------------------------------------------------------------
                    */

                    url.searchParams.set(
                        'session',
                        session
                    );


                    url.searchParams.set(
                        'term',
                        term
                    );


                    url.searchParams.set(
                        'class_id',
                        classId
                    );


                    /*
                    |--------------------------------------------------------------------------
                    | RELOAD DASHBOARD
                    |--------------------------------------------------------------------------
                    |
                    | Laravel will receive the new filter values and recalculate
                    | every academic statistic.
                    |
                    |--------------------------------------------------------------------------
                    */

                    window.location.href =
                        url.toString();

                }
            );

        }



        /*
        |--------------------------------------------------------------------------
        | CLASS PERFORMANCE CHART
        |--------------------------------------------------------------------------
        */

        const classChartElement =
            document.getElementById(
                'classPerformanceChart'
            );


        if (classChartElement) {

            new Chart(
                classChartElement,
                {

                    type:
                        'bar',

                    data: {

                        labels:
                            @json(
                                $classChartLabels
                            ),

                        datasets: [

                            {

                                label:
                                    'Average Score (%)',

                                data:
                                    @json(
                                        $classChartAverages
                                    ),

                                backgroundColor:
                                    'rgba(54,162,235,.7)',

                                borderColor:
                                    'rgba(54,162,235,1)',

                                borderWidth:
                                    1,

                                borderRadius:
                                    8

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        scales: {

                            y: {

                                beginAtZero:
                                    true,

                                max:
                                    100

                            }

                        }

                    }

                }
            );

        }



        /*
        |--------------------------------------------------------------------------
        | ABOVE / BELOW AVERAGE CHART
        |--------------------------------------------------------------------------
        */

        const aboveBelowElement =
            document.getElementById(
                'aboveBelowChart'
            );


        if (aboveBelowElement) {

            new Chart(
                aboveBelowElement,
                {

                    type:
                        'doughnut',

                    data: {

                        labels: [

                            'Above Average',

                            'Below Average'

                        ],

                        datasets: [

                            {

                                data: [

                                    {{ $aboveAverageStudents }},

                                    {{ $belowAverageStudents }}

                                ],

                                backgroundColor: [

                                    '#198754',

                                    '#dc3545'

                                ],

                                borderWidth:
                                    0

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        plugins: {

                            legend: {

                                position:
                                    'bottom'

                            }

                        }

                    }

                }

            );

        }



        /*
        |--------------------------------------------------------------------------
        | SUBJECT PERFORMANCE CHART
        |--------------------------------------------------------------------------
        */

        const subjectChartElement =
            document.getElementById(
                'subjectPerformanceChart'
            );


        if (subjectChartElement) {

            new Chart(
                subjectChartElement,
                {

                    type:
                        'bar',

                    data: {

                        labels:
                            @json(
                                $subjectChartLabels
                            ),

                        datasets: [

                            {

                                label:
                                    'Average Score (%)',

                                data:
                                    @json(
                                        $subjectChartAverages
                                    ),

                                backgroundColor:
                                    'rgba(25,135,84,.7)',

                                borderColor:
                                    'rgba(25,135,84,1)',

                                borderWidth:
                                    1,

                                borderRadius:
                                    7

                            }

                        ]

                    },

                    options: {

                        indexAxis:
                            'y',

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        scales: {

                            x: {

                                beginAtZero:
                                    true,

                                max:
                                    100

                            }

                        }

                    }

                }

            );

        }



        /*
        |--------------------------------------------------------------------------
        | GRADE DISTRIBUTION
        |--------------------------------------------------------------------------
        */

        const gradeChartElement =
            document.getElementById(
                'gradeDistributionChart'
            );


        if (gradeChartElement) {

            new Chart(
                gradeChartElement,
                {

                    type:
                        'doughnut',

                    data: {

                        labels:
                            @json(
                                $gradeLabels
                            ),

                        datasets: [

                            {

                                data:
                                    @json(
                                        $gradeCounts
                                    ),

                                backgroundColor: [

                                    '#198754',

                                    '#0d6efd',

                                    '#ffc107',

                                    '#fd7e14',

                                    '#dc3545',

                                    '#6f42c1',

                                    '#20c997'

                                ],

                                borderWidth:
                                    0

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        plugins: {

                            legend: {

                                position:
                                    'bottom'

                            }

                        }

                    }

                }

            );

        }



        /*
        |--------------------------------------------------------------------------
        | TERM PERFORMANCE TREND
        |--------------------------------------------------------------------------
        */

        const termChartElement =
            document.getElementById(
                'termPerformanceChart'
            );


        if (termChartElement) {

            new Chart(
                termChartElement,
                {

                    type:
                        'line',

                    data: {

                        labels:
                            @json(
                                $termChartLabels
                            ),

                        datasets: [

                            {

                                label:
                                    'Average Score (%)',

                                data:
                                    @json(
                                        $termChartAverages
                                    ),

                                borderWidth:
                                    3,

                                tension:
                                    .4,

                                fill:
                                    false,

                                pointRadius:
                                    5

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        scales: {

                            y: {

                                beginAtZero:
                                    true,

                                max:
                                    100

                            }

                        }

                    }

                }

            );

        }



        /*
        |--------------------------------------------------------------------------
        | STUDENT GROWTH
        |--------------------------------------------------------------------------
        */

        const studentGrowthElement =
            document.getElementById(
                'studentGrowthChart'
            );


        if (studentGrowthElement) {

            new Chart(
                studentGrowthElement,
                {

                    type:
                        'line',

                    data: {

                        labels:
                            @json(
                                $months
                            ),

                        datasets: [

                            {

                                label:
                                    'Students',

                                data:
                                    @json(
                                        $monthlyStudents
                                    ),

                                backgroundColor:
                                    'rgba(54,162,235,.15)',

                                borderColor:
                                    'rgba(54,162,235,1)',

                                borderWidth:
                                    3,

                                fill:
                                    true,

                                tension:
                                    .4

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        scales: {

                            y: {

                                beginAtZero:
                                    true

                            }

                        }

                    }

                }

            );

        }



        /*
        |--------------------------------------------------------------------------
        | CBT PASS / FAIL
        |--------------------------------------------------------------------------
        */

        const cbtChartElement =
            document.getElementById(
                'cbtPassFailChart'
            );


        if (cbtChartElement) {

            new Chart(
                cbtChartElement,
                {

                    type:
                        'doughnut',

                    data: {

                        labels: [

                            'Pass',

                            'Fail'

                        ],

                        datasets: [

                            {

                                data: [

                                    {{ $passCount }},

                                    {{ $failCount }}

                                ],

                                backgroundColor: [

                                    '#198754',

                                    '#dc3545'

                                ],

                                borderWidth:
                                    0

                            }

                        ]

                    },

                    options: {

                        responsive:
                            true,

                        maintainAspectRatio:
                            false,

                        plugins: {

                            legend: {

                                position:
                                    'bottom'

                            }

                        }

                    }

                }

            );

        }


    }
);

</script>


@endsection