{{-- ================================================================

     STUDENT DASHBOARD
     RESULT ANALYSIS + CBT ANALYSIS
================================================================ --}}

@extends('backend.student_backend.student_dashboard')

@section('student')

@php

    /*
    |--------------------------------------------------------------------------
    | IMPORT REQUIRED MODELS
    |--------------------------------------------------------------------------
    |
    | We are keeping the calculations inside this Blade because the
    | existing dashboard structure already works this way.
    |
    | Later, when the system becomes very large, these calculations
    | can be moved into a Controller/Service for better performance.
    |
    */

    use App\Models\Student;
    use App\Models\Result;
    use App\Models\Subject;
    use App\Models\StudentClasses;
    use App\Models\AssignClassSubjectStudent;
    use App\Models\CbtTest;
    use App\Models\CbtAttempt;
    use Illuminate\Support\Facades\DB;


    /*
    |--------------------------------------------------------------------------
    | 1. GET LOGGED-IN STUDENT
    |--------------------------------------------------------------------------
    |
    | We NEVER use a student ID supplied by the browser.
    |
    | Instead, we use the authenticated user's ID and find the student
    | belonging to that user.
    |
    | This prevents Student A from changing a URL and viewing Student B's
    | results.
    |
    */

    $loggedInStudent = Student::where('user_id', auth()->id())->first();


    /*
    |--------------------------------------------------------------------------
    | SAFETY CHECK
    |--------------------------------------------------------------------------
    |
    | If no student profile is connected to the logged-in account,
    | create empty collections so the dashboard does not crash.
    |
    */

    if (!$loggedInStudent) {

        $assignedRecords = collect();

        $studentResults = collect();

        $studentPerformance = collect();

        $subjectPerformance = collect();

        $classPerformance = collect();

    } else {


        /*
        |--------------------------------------------------------------------------
        | 2. GET THE STUDENT'S ASSIGNED SUBJECTS / CLASSES
        |--------------------------------------------------------------------------
        |
        | VERY IMPORTANT:
        |
        | We do NOT simply get every class or every subject.
        |
        | We use AssignClassSubjectStudent because that table tells us:
        |
        | student_id
        | student_classes_id
        | subject_id
        | session
        | term
        |
        | Therefore, this is the correct source for determining what
        | this particular student is allowed to see.
        |
        */

        $assignedRecords = AssignClassSubjectStudent::with([
                'subject',
                'class'
            ])
            ->where('student_id', $loggedInStudent->id)
            ->get();


        /*
        |--------------------------------------------------------------------------
        | 3. CURRENT TERM AND SESSION
        |--------------------------------------------------------------------------
        */

        $currentTerm = DB::table('terms')
            ->where('is_current', 1)
            ->value('name');

        $currentSession = DB::table('academic_sessions')
            ->where('is_current', 1)
            ->value('name');


        /*
        |--------------------------------------------------------------------------
        | 4. FILTER DATA
        |--------------------------------------------------------------------------
        |
        | We only display terms/sessions that actually appear in the
        | student's assignment records.
        |
        */

        $availableTerms = $assignedRecords
            ->pluck('term')
            ->filter()
            ->unique()
            ->values();

        $availableSessions = $assignedRecords
            ->pluck('session')
            ->filter()
            ->unique()
            ->sort()
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 5. SELECTED FILTER VALUES
        |--------------------------------------------------------------------------
        |
        | Student can choose:
        |
        | - Session
        | - Term
        | - Class
        |
        | Subject does not need a separate filter because the dashboard
        | analyzes all subjects assigned to the selected class.
        |
        */

        $selectedTerm = request(
            'analysis_term',
            $currentTerm
        );

        $selectedSession = request(
            'analysis_session',
            $currentSession
        );

        $selectedClass = request(
            'analysis_class',
            'all'
        );


        /*
        |--------------------------------------------------------------------------
        | 6. FILTER ASSIGNMENTS
        |--------------------------------------------------------------------------
        |
        | First filter the assignment table.
        |
        | This guarantees that the student only analyzes subjects/classes
        | actually assigned to that student.
        |
        */

        $filteredAssignments = $assignedRecords
            ->filter(function ($assignment) use (
                $selectedTerm,
                $selectedSession,
                $selectedClass
            ) {

                /*
                |--------------------------------------------------------------------------
                | SESSION MATCH
                |--------------------------------------------------------------------------
                */

                if (
                    $selectedSession &&
                    $assignment->session != $selectedSession
                ) {
                    return false;
                }


                /*
                |--------------------------------------------------------------------------
                | TERM MATCH
                |--------------------------------------------------------------------------
                */

                if (
                    $selectedTerm &&
                    $assignment->term != $selectedTerm
                ) {
                    return false;
                }


                /*
                |--------------------------------------------------------------------------
                | CLASS MATCH
                |--------------------------------------------------------------------------
                */

                if (
                    $selectedClass !== 'all' &&
                    (string) $assignment->student_classes_id !== (string) $selectedClass
                ) {
                    return false;
                }


                return true;
            })
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 7. GET ASSIGNED CLASS IDs
        |--------------------------------------------------------------------------
        */

        $assignedClassIds = $filteredAssignments
            ->pluck('student_classes_id')
            ->filter()
            ->unique()
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 8. GET ASSIGNED SUBJECT IDs
        |--------------------------------------------------------------------------
        */

        $assignedSubjectIds = $filteredAssignments
            ->pluck('subject_id')
            ->filter()
            ->unique()
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 9. GET THE STUDENT'S RESULTS
        |--------------------------------------------------------------------------
        |
        | The result query is restricted by:
        |
        | 1. Logged-in student
        | 2. Selected session
        | 3. Selected term
        | 4. Assigned classes
        | 5. Assigned subjects
        |
        */

        $resultQuery = Result::with([
                'subject',
                'studentClass'
            ])
            ->where(
                'student_id',
                $loggedInStudent->id
            )
            ->where(
                'term',
                $selectedTerm
            )
            ->where(
                'session',
                $selectedSession
            );


        /*
        |--------------------------------------------------------------------------
        | ONLY ASSIGNED CLASSES
        |--------------------------------------------------------------------------
        */

        if ($assignedClassIds->count() > 0) {

            $resultQuery->whereIn(
                'student_classes_id',
                $assignedClassIds
            );

        } else {

            /*
            |--------------------------------------------------------------------------
            | If no assignment exists, return no result.
            |--------------------------------------------------------------------------
            */

            $resultQuery->whereRaw('1 = 0');

        }


        /*
        |--------------------------------------------------------------------------
        | ONLY ASSIGNED SUBJECTS
        |--------------------------------------------------------------------------
        */

        if ($assignedSubjectIds->count() > 0) {

            $resultQuery->whereIn(
                'subject_id',
                $assignedSubjectIds
            );

        } else {

            $resultQuery->whereRaw('1 = 0');

        }


        /*
        |--------------------------------------------------------------------------
        | GET RESULTS
        |--------------------------------------------------------------------------
        */

        $studentResults = $resultQuery
            ->orderBy('subject_id')
            ->get();


        /*
        |--------------------------------------------------------------------------
        | 10. PASS MARK
        |--------------------------------------------------------------------------
        |
        | Your existing school result system uses 40 as the pass mark.
        |
        */

        $passMark = 40;


        /*
        |--------------------------------------------------------------------------
        | 11. TOTAL SUBJECTS
        |--------------------------------------------------------------------------
        */

        $totalSubjects = $studentResults
            ->pluck('subject_id')
            ->unique()
            ->count();


        /*
        |--------------------------------------------------------------------------
        | 12. OVERALL STUDENT AVERAGE
        |--------------------------------------------------------------------------
        |
        | Each result total is already stored in the database.
        |
        | Example:
        |
        | Mathematics = 75
        | English     = 65
        | Biology     = 80
        |
        | Average:
        |
        | (75 + 65 + 80) / 3
        |
        | We do NOT recalculate CA + Exam here because your Result model
        | already stores the final total.
        |
        */

        $overallAverage = round(
            (float) (
                $studentResults->avg('total') ?? 0
            ),
            1
        );


        /*
        |--------------------------------------------------------------------------
        | 13. OVERALL PERFORMANCE PERCENTAGE
        |--------------------------------------------------------------------------
        |
        | Your result total is already out of 100.
        |
        | Therefore:
        |
        | Average = Percentage
        |
        | Example:
        |
        | Average = 68.5
        |
        | Performance = 68.5%
        |
        */

        $overallPercentage = $overallAverage;


        /*
        |--------------------------------------------------------------------------
        | 14. PASSED SUBJECTS
        |--------------------------------------------------------------------------
        */

        $passedSubjects = $studentResults
            ->filter(function ($result) use ($passMark) {

                return (float) $result->total >= $passMark;

            })
            ->count();


        /*
        |--------------------------------------------------------------------------
        | 15. FAILED SUBJECTS
        |--------------------------------------------------------------------------
        */

        $failedSubjects = $studentResults
            ->filter(function ($result) use ($passMark) {

                return (float) $result->total < $passMark;

            })
            ->count();


        /*
        |--------------------------------------------------------------------------
        | 16. PASS RATE
        |--------------------------------------------------------------------------
        */

        $passRate = $studentResults->count() > 0

            ? round(
                (
                    $passedSubjects /
                    $studentResults->count()
                ) * 100,
                1
            )

            : 0;


        /*
        |--------------------------------------------------------------------------
        | 17. HIGHEST SUBJECT SCORE
        |--------------------------------------------------------------------------
        */

        $highestResult = $studentResults
            ->sortByDesc('total')
            ->first();


        /*
        |--------------------------------------------------------------------------
        | 18. LOWEST SUBJECT SCORE
        |--------------------------------------------------------------------------
        */

        $lowestResult = $studentResults
            ->sortBy('total')
            ->first();


        /*
        |--------------------------------------------------------------------------
        | 19. SUBJECT PERFORMANCE
        |--------------------------------------------------------------------------
        |
        | Since each student normally has one result per subject for a
        | selected term/session, this gives the subject score.
        |
        */

        $subjectPerformance = $studentResults
            ->groupBy('subject_id')
            ->map(function ($rows) {

                $first = $rows->first();

                return (object) [

                    'subject_id' => $first->subject_id,

                    'subject_name' =>
                        optional($first->subject)->subject_name
                        ?? 'Unknown Subject',

                    'average' =>
                        round(
                            (float) $rows->avg('total'),
                            1
                        ),

                    'highest' =>
                        round(
                            (float) $rows->max('total'),
                            1
                        ),

                    'lowest' =>
                        round(
                            (float) $rows->min('total'),
                            1
                        ),

                ];

            })
            ->sortByDesc('average')
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 20. BEST SUBJECT
        |--------------------------------------------------------------------------
        */

        $bestSubject = $subjectPerformance
            ->sortByDesc('average')
            ->first();


        /*
        |--------------------------------------------------------------------------
        | 21. WEAKEST SUBJECT
        |--------------------------------------------------------------------------
        */

        $weakestSubject = $subjectPerformance
            ->sortBy('average')
            ->first();


        /*
        |--------------------------------------------------------------------------
        | 22. CLASS PERFORMANCE
        |--------------------------------------------------------------------------
        |
        | If the student has more than one assigned class, we calculate
        | the student's performance separately for each class.
        |
        */

        $classPerformance = $studentResults
            ->groupBy('student_classes_id')
            ->map(function ($rows, $classId) use ($passMark) {

                $first = $rows->first();

                $average = (float) $rows->avg('total');

                $passed = $rows
                    ->where('total', '>=', $passMark)
                    ->count();

                $subjectCount = $rows
                    ->pluck('subject_id')
                    ->unique()
                    ->count();

                $passRate = $rows->count() > 0

                    ? round(
                        (
                            $passed /
                            $rows->count()
                        ) * 100,
                        1
                    )

                    : 0;

                return (object) [

                    'class_id' => $classId,

                    'class_name' =>
                        optional($first->studentClass)->class_name
                        ?? 'Unknown Class',

                    'average' =>
                        round($average, 1),

                    'subjects' =>
                        $subjectCount,

                    'passed' =>
                        $passed,

                    'failed' =>
                        $rows->count() - $passed,

                    'pass_rate' =>
                        $passRate,

                ];

            })
            ->sortByDesc('average')
            ->values();


        /*
        |--------------------------------------------------------------------------
        | 23. STUDENT'S POSITION-STYLE INFORMATION
        |--------------------------------------------------------------------------
        |
        | We compare the student's average with other students in the
        | SAME selected class/session/term.
        |
        | This is NOT a stored school position.
        |
        | It is simply an analytical position calculated from the same
        | result records.
        |
        */

        /*
        |--------------------------------------------------------------------------
        | DETERMINE THE CLASS USED FOR POSITION
        |--------------------------------------------------------------------------
        |
        | If the student selected a particular class, use that class.
        | If "all" is selected, use the student's actual class from the
        | currently filtered result records.
        |
        | This is important because position must NEVER compare students
        | from different classes.
        |
        */

        $positionClassId = null;

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

            $positionClassId = $selectedClass;

        } elseif ($studentResults->count() > 0) {

            $positionClassId =
                $studentResults
                    ->pluck('student_classes_id')
                    ->filter()
                    ->first();

        }


        /*
        |--------------------------------------------------------------------------
        | GET STUDENTS FROM THE SAME CLASS ONLY
        |--------------------------------------------------------------------------
        */

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


        if ($positionClassId) {

            $comparisonResultsQuery->where(
                'student_classes_id',
                $positionClassId
            );

        } else {

            $comparisonResultsQuery->whereRaw('1 = 0');

        }


        /*
        |--------------------------------------------------------------------------
        | GET CLASS COMPARISON RESULTS
        |--------------------------------------------------------------------------
        */

        $comparisonResults =
            $comparisonResultsQuery->get();


        /*
        |--------------------------------------------------------------------------
        | CALCULATE EVERY STUDENT'S AVERAGE IN THIS CLASS
        |--------------------------------------------------------------------------
        |
        | Each student is grouped separately and their result totals are
        | averaged. Because the query above is already restricted to one
        | class, students from another class cannot affect the position.
        |
        */

        $classStudentAverages =
            $comparisonResults
                ->groupBy('student_id')
                ->map(function ($rows) {

                    return round(
                        (float) $rows->avg('total'),
                        2
                    );

                })
                ->sortDesc()
                ->values();


        /*
        |--------------------------------------------------------------------------
        | CALCULATE THIS STUDENT'S AVERAGE FOR THE SAME CLASS ONLY
        |--------------------------------------------------------------------------
        */

        $positionStudentResults =
            $studentResults
                ->filter(function ($result) use ($positionClassId) {

                    return (string) $result->student_classes_id
                        === (string) $positionClassId;

                })
                ->values();


        $positionStudentAverage =
            $positionStudentResults->count() > 0
                ? round(
                    (float) $positionStudentResults->avg('total'),
                    2
                )
                : null;


        /*
        |--------------------------------------------------------------------------
        | STUDENT ANALYTICAL POSITION
        |--------------------------------------------------------------------------
        |
        | Position is calculated by counting only students whose average
        | is HIGHER than this student's average.
        |
        | Example:
        | Student A = 80.80%
        | Student B = 67.34%
        |
        | Student A = 1st
        | Student B = 2nd
        |
        | Students with the same average receive the same position.
        |
        */

        $studentPosition = null;

        if (
            $positionStudentAverage !== null
            && $classStudentAverages->count() > 0
        ) {

            $studentsAboveThisStudent =
                $classStudentAverages
                    ->filter(function ($otherAverage) use (
                        $positionStudentAverage
                    ) {

                        return $otherAverage >
                            $positionStudentAverage;

                    })
                    ->count();


            $studentPosition =
                $studentsAboveThisStudent + 1;

        }


        /*
        |--------------------------------------------------------------------------
        | NUMBER OF STUDENTS USED FOR COMPARISON
        |--------------------------------------------------------------------------
        */

        $studentsCompared =
            $classStudentAverages->count();


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

        $comparisonAverage = round(
            (float) (
                $classStudentAverages->avg() ?? 0
            ),
            1
        );


        /*
        |--------------------------------------------------------------------------
        | ABOVE / BELOW CLASS AVERAGE
        |--------------------------------------------------------------------------
        */

        $aboveClassAverage =
            $positionStudentAverage !== null
            && $positionStudentAverage > $comparisonAverage;

        $belowClassAverage =
            $positionStudentAverage !== null
            && $positionStudentAverage < $comparisonAverage;


        /*
        |--------------------------------------------------------------------------
        | SCORE BAND ANALYSIS
        |--------------------------------------------------------------------------
        |
        | This tells the student how many subjects fall inside each
        | performance band.
        |
        */

        $scoreBands = [

            '80 - 100' => 0,

            '70 - 79' => 0,

            '60 - 69' => 0,

            '50 - 59' => 0,

            '40 - 49' => 0,

            'Below 40' => 0,

        ];


        foreach ($studentResults as $result) {

            $score = (float) $result->total;


            if ($score >= 80) {

                $scoreBands['80 - 100']++;

            } elseif ($score >= 70) {

                $scoreBands['70 - 79']++;

            } elseif ($score >= 60) {

                $scoreBands['60 - 69']++;

            } elseif ($score >= 50) {

                $scoreBands['50 - 59']++;

            } elseif ($score >= 40) {

                $scoreBands['40 - 49']++;

            } else {

                $scoreBands['Below 40']++;

            }

        }


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

        $gradeDistribution = $studentResults
            ->groupBy(function ($result) {

                return $result->grade
                    ?: 'Not Graded';

            })
            ->map(function ($rows) {

                return $rows->count();

            })
            ->sortKeys()
            ->toArray();


        /*
        |--------------------------------------------------------------------------
        | FULL PUBLICATION STATUS
        |--------------------------------------------------------------------------
        |
        | Your Result model has the legacy "publish" field.
        |
        | We count fully published result rows here.
        |
        */

        $publishedResults = $studentResults
            ->filter(function ($result) {

                return (int) $result->publish === 1;

            })
            ->count();


        /*
        |--------------------------------------------------------------------------
        | PUBLICATION RATE
        |--------------------------------------------------------------------------
        */

        $publicationRate = $studentResults->count() > 0

            ? round(
                (
                    $publishedResults /
                    $studentResults->count()
                ) * 100,
                1
            )

            : 0;


        /*
        |--------------------------------------------------------------------------
        | ==============================================================
        | CBT ANALYSIS
        | ==============================================================
        |--------------------------------------------------------------------------
        |
        | We keep CBT analysis on the same student dashboard.
        |
        */


        /*
        |--------------------------------------------------------------------------
        | CBT TESTS FOR CURRENT FILTER
        |--------------------------------------------------------------------------
        */

        $cbtTests = CbtTest::query()
            ->where('session', $selectedSession)
            ->where('term', $selectedTerm)
            ->get();


        /*
        |--------------------------------------------------------------------------
        | CBT ATTEMPTS BELONGING TO THIS STUDENT
        |--------------------------------------------------------------------------
        */

        $cbtAttempts = CbtAttempt::query()
            ->where(
                'student_id',
                $loggedInStudent->id
            )
            ->whereIn(
                'cbt_test_id',
                $cbtTests->pluck('id')
            )
            ->get();


        /*
        |--------------------------------------------------------------------------
        | CBT TESTS TAKEN
        |--------------------------------------------------------------------------
        */

        $cbtTestsTaken =
            $cbtAttempts
                ->pluck('cbt_test_id')
                ->unique()
                ->count();


        /*
        |--------------------------------------------------------------------------
        | CBT AVERAGE
        |--------------------------------------------------------------------------
        */

        $cbtAverage = round(
            (float) (
                $cbtAttempts->avg('score') ?? 0
            ),
            1
        );


        /*
        |--------------------------------------------------------------------------
        | CBT HIGHEST SCORE
        |--------------------------------------------------------------------------
        */

        $cbtHighest = round(
            (float) (
                $cbtAttempts->max('score') ?? 0
            ),
            1
        );


        /*
        |--------------------------------------------------------------------------
        | CBT LOWEST SCORE
        |--------------------------------------------------------------------------
        */

        $cbtLowest = round(
            (float) (
                $cbtAttempts->min('score') ?? 0
            ),
            1
        );


        /*
        |--------------------------------------------------------------------------
        | CBT PASS COUNT
        |--------------------------------------------------------------------------
        */

        $cbtPassCount = $cbtAttempts
            ->filter(function ($attempt) {

                return (float) $attempt->score >= 40;

            })
            ->count();


        /*
        |--------------------------------------------------------------------------
        | CBT PASS RATE
        |--------------------------------------------------------------------------
        */

        $cbtPassRate = $cbtAttempts->count() > 0

            ? round(
                (
                    $cbtPassCount /
                    $cbtAttempts->count()
                ) * 100,
                1
            )

            : 0;

    }


    /*
    |--------------------------------------------------------------------------
    | FALLBACK EMPTY VARIABLES
    |--------------------------------------------------------------------------
    |
    | These make the dashboard safe if no student profile exists.
    |--------------------------------------------------------------------------
    */

    $currentTerm = $currentTerm ?? null;

    $currentSession = $currentSession ?? null;

    $availableTerms = $availableTerms ?? collect();

    $availableSessions = $availableSessions ?? collect();

    $filteredAssignments =
        $filteredAssignments ?? collect();

    $assignedClassIds =
        $assignedClassIds ?? collect();

    $assignedSubjectIds =
        $assignedSubjectIds ?? collect();

    $studentResults =
        $studentResults ?? collect();

    $studentPerformance =
        $studentPerformance ?? collect();

    $subjectPerformance =
        $subjectPerformance ?? collect();

    $classPerformance =
        $classPerformance ?? collect();

    $scoreBands =
        $scoreBands ?? [];

    $gradeDistribution =
        $gradeDistribution ?? [];

    $totalSubjects =
        $totalSubjects ?? 0;

    $overallAverage =
        $overallAverage ?? 0;

    $overallPercentage =
        $overallPercentage ?? 0;

    $passedSubjects =
        $passedSubjects ?? 0;

    $failedSubjects =
        $failedSubjects ?? 0;

    $passRate =
        $passRate ?? 0;

    $publishedResults =
        $publishedResults ?? 0;

    $publicationRate =
        $publicationRate ?? 0;

    $comparisonAverage =
        $comparisonAverage ?? 0;

    $studentPosition =
        $studentPosition ?? null;

    $studentsCompared =
        $studentsCompared ?? 0;

    $cbtTestsTaken =
        $cbtTestsTaken ?? 0;

    $cbtAverage =
        $cbtAverage ?? 0;

    $cbtHighest =
        $cbtHighest ?? 0;

    $cbtLowest =
        $cbtLowest ?? 0;

    $cbtPassRate =
        $cbtPassRate ?? 0;

    $cbtAttempts =
        $cbtAttempts ?? collect();

    $cbtTests =
        $cbtTests ?? collect();

@endphp

















@php
use Illuminate\Support\Facades\Auth;
use App\Models\StudentBill;
use App\Models\StudentPayment;

// ============================================================
// 1. LOGGED-IN STUDENT
// ============================================================

$student = \App\Models\Student::where(
'user_id',
Auth::id()
)->first();

// ============================================================
// 2. CURRENT TERM & CURRENT SESSION
// ============================================================

$currentTerm = DB::table('terms')
->where('is_current', 1)
->value('name');

$currentSession = DB::table('academic_sessions')
->where('is_current', 1)
->value('name');

// ============================================================
// STUDENT BILLING INFORMATION
// IMPORTANT:
// EVERYTHING BELOW IS FOR CURRENT TERM + CURRENT SESSION ONLY.
// NO PREVIOUS TERM OR PREVIOUS SESSION IS INCLUDED.
// ============================================================

$totalBill = 0;
$totalPaid = 0;
$totalOutstanding = 0;

// ============================================================
// 3. GET CURRENT STUDENT BILL
// ============================================================

$currentBill = StudentBill::where(
'student_id',
$student->id
)
->where(
'term',
$currentTerm
)
->where(
'session',
$currentSession
)
->first();

// ============================================================
// 4. CURRENT TERM & CURRENT SESSION BILL
// ============================================================

if ($currentBill) {

$totalBill = (float) (
    $currentBill->total_bill ?? 0
);


}

// ============================================================
// 5. CURRENT TERM & CURRENT SESSION PAYMENTS
// ============================================================

if ($currentBill) {


$totalPaid = StudentPayment::where(
        'student_bill_id',
        $currentBill->id
    )
    ->sum('amount');


}

$totalPaid = (float) $totalPaid;

// ============================================================
// 6. CURRENT TERM & CURRENT SESSION OUTSTANDING
//
// Outstanding = Current Term Bill - Current Term Payment
//
// NO PREVIOUS OUTSTANDING IS INCLUDED.
// ============================================================

$totalOutstanding = max(
0,
$totalBill - $totalPaid
);

// ============================================================
// 7. TOTAL SUBJECTS
// CURRENT TERM + CURRENT SESSION ONLY
// ============================================================

$totalSubjects = AssignClassSubjectStudent::where(
'student_id',
$student->id
)
->where(
'term',
$currentTerm
)
->where(
'session',
$currentSession
)
->distinct('subject_id')
->count('subject_id');

// ============================================================
// 8. GET STUDENT CLASS
// CURRENT TERM + CURRENT SESSION ONLY
// ============================================================

$studentClassId = AssignClassSubjectStudent::where(
'student_id',
$student->id
)
->where(
'term',
$currentTerm
)
->where(
'session',
$currentSession
)
->value('student_classes_id');




// ============================================================
//  8  STUDENT DEBT LIMIT
//     LIMIT IS SET BY THE BURSAR
//     CURRENT CLASS + CURRENT TERM + CURRENT SESSION
//============================================================

$debtLimit = \App\Models\DebtLimit::where(
    'class_id',
    $studentClassId
)
->where(
    'term',
    $currentTerm
)
->where(
    'session',
    $currentSession
)
->value('debt_limit');


$debtLimit = $debtLimit !== null
    ? (float) $debtLimit
    : null;


/* ============================================================
   PERFORMANCE ACCESS

   Student can access performance when:

   Outstanding <= Debt Limit

   Student is restricted when:

   Outstanding > Debt Limit
============================================================ */

$performanceRestricted = false;


if ($debtLimit !== null) {

    $performanceRestricted =
        $totalOutstanding > $debtLimit;

}


/* ============================================================
   AMOUNT REQUIRED TO MEET DEBT LIMIT
============================================================ */

$amountRequiredToMeetDebtLimit = 0;


if (
    $performanceRestricted
    &&
    $debtLimit !== null
) {

    $amountRequiredToMeetDebtLimit =
        max(
            0,
            $totalOutstanding - $debtLimit
        );

}




// ============================================================
// 9. TOTAL CBT TESTS
// CURRENT TERM + CURRENT SESSION ONLY
// ============================================================

$totalCBTTests = CbtTest::where(
'student_classes_id',
$studentClassId
)
->where(
'term',
$currentTerm
)
->where(
'session',
$currentSession
)
->count();

// ============================================================
// 10. RECENT CBT TESTS
// CURRENT TERM + CURRENT SESSION ONLY
// ============================================================

$recentCBT = CbtTest::where(
'student_classes_id',
$studentClassId
)
->where(
'term',
$currentTerm
)
->where(
'session',
$currentSession
)
->latest()
->take(5)
->get();

// ============================================================
// 11. GREETING
// ============================================================

$hour = now()->format('H');

if ($hour < 12) {


$greeting = "Good Morning";


} elseif ($hour < 17) {


$greeting = "Good Afternoon";


} else {


$greeting = "Good Evening";


}

// ============================================================
// 12. GET CLASS NAME
// ============================================================

$studentClassName = \App\Models\StudentClasses::where(
'id',
$studentClassId
)->value('class_name');



// ============================================================
// . GET PROMOTION STATUS
// ============================================================

$studentPromotion = AssignClassSubjectStudent::where(
    'student_id',
    $student->id
)
->where(
    'term',
    $currentTerm
)
->where(
    'session',
    $currentSession
)
->whereNotNull(
    'promoted'
)
->where(
    'promoted',
    '!=',
    ''
)
->value('promoted');




// ============================================================
// 13. CBT PERFORMANCE DATA
// CURRENT TERM + CURRENT SESSION ONLY
// ============================================================

$attemptsQuery = CbtAttempt::where(
'student_id',
$student->id
)
->where(
'status',
'completed'
)
->whereHas(
'test',
function ($query) use (
$currentTerm,
$currentSession
) {


        $query->where(
            'term',
            $currentTerm
        )
        ->where(
            'session',
            $currentSession
        );

    }
);


// ============================================================
// TOTAL ATTEMPTS
// ============================================================

$totalAttempts = $attemptsQuery->count();

// ============================================================
// PASS COUNT
// ============================================================

$passCount = (clone $attemptsQuery)
->where(
'score',
'>=',
50
)
->count();

// ============================================================
// FAIL COUNT
// ============================================================

$failCount = (clone $attemptsQuery)
->where(
'score',
'<',
50
)
->count();

// ============================================================
// AVERAGE SCORE
// ============================================================

$averageScore = round(
$attemptsQuery->avg('score') ?? 0,
1
);

// ============================================================
// HIGHEST SCORE
// ============================================================

$highestScore = $attemptsQuery->max('score') ?? 0;

// ============================================================
// SCORE TREND - LAST 6 TESTS
// ============================================================

$scoreTrend = (clone $attemptsQuery)
->latest()
->take(6)
->get()
->reverse();

$trendLabels = [];
$trendScores = [];

foreach ($scoreTrend as $attempt) {


$trendLabels[] =
    $attempt->created_at->format('d M');

$trendScores[] =
    $attempt->score;


}

@endphp

{{-- =========================================================
CSS EFFECTS
========================================================== --}}

<style>

.dashboard-card {
    min-height: 160px;
    min-width: 160px;
}

.dashboard-card .card-body {
    padding: 1.8rem;
}

.dashboard-card h3 {
    font-size: 1.9rem;
}

.zoom-card {
    transition:
        transform 0.3s ease,
        box-shadow 0.3s ease;
}

.zoom-card:hover {
    transform: scale(1.05);
    box-shadow: 0 10px 25px rgba(0,0,0,0.2);
}


/* Animation Styles */

.animate-card {
    opacity: 0;
    transform: translateY(30px);
    animation: popUp 0.8s ease forwards;
    animation-delay: var(--delay, 0s);
}

@keyframes popUp {

    to {

        opacity: 1;
        transform: translateY(0);

    }

}


/* Header Badge Animation */

.animate-badges span {

    opacity: 0;
    transform: translateY(10px);
    animation: fadeUp 0.6s ease forwards;

}

.animate-badges span:nth-child(1) {
    animation-delay: 0.2s;
}

.animate-badges span:nth-child(2) {
    animation-delay: 0.4s;
}

.animate-badges span:nth-child(3) {
    animation-delay: 0.6s;
}

@keyframes fadeUp {

    to {

        opacity: 1;
        transform: translateY(0);

    }

}

</style>

{{-- =========================================================
STUDENT DASHBOARD
========================================================== --}}

<div class="container-fluid">

{{-- =====================================================
     1. WELCOME 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"
        >

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


            <div class="page-title-right">

                <ol class="breadcrumb m-0">

                    <li class="breadcrumb-item">

                        <a href="javascript:void(0);">

                            <p
                                style="
                                    font-size:16px;
                                    color:green;
                                "
                            >

                                <b>
                                    Academic Session :
                                </b>

                                {{ $currentSession }}

                                <br>

                                <b>
                                    Term :
                                </b>

                                {{ $currentTerm }}

                                <font color="red">

                                    |

                                    <b>
                                        Class:
                                    </b>

                                    {{ strtoupper(
                                        $studentClassName
                                        ?? 'Not Assigned'
                                    ) }}


                                    {{-- ==================================================
                                         PROMOTED STATUS
                                         ONLY SHOW IF AVAILABLE
                                    =================================================== --}}

                                    @if(
                                        !empty(
                                            $studentPromotion
                                        )
                                    )

                                        |

                                        <b>
                                            {{ strtoupper(
                                                $studentPromotion
                                            ) }}
                                        </b>

                                    @endif

                                </font>

                            </p>

                        </a>

                    </li>

                </ol>

            </div>

        </div>

    </div>  

</div>


   



  <div class="d-flex flex-wrap justify-content-between align-items-center mb-4">

        <div>

            <h2 class="fw-bold mb-1">
                Student Academic Dashboard
            </h2>

            <p class="text-muted mb-0">
                Result performance, academic analysis and CBT overview
            </p>

        </div>


        <div class="text-end">

            <span class="badge bg-primary px-3 py-2">

                {{ $selectedTerm ?: 'No Term' }}

                |

                {{ $selectedSession ?: 'No Session' }}

            </span>

        </div>

    </div>


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

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

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

            <h5 class="mb-0">

                <i class="fas fa-filter me-2"></i>

                Analysis Filter

            </h5>

        </div>


        <div class="card-body">

            <form
                method="GET"
                action="{{ url()->current() }}"
            >

                <div class="row g-3">


                    {{-- SESSION --}}

                    <div class="col-md-4">

                        <label class="form-label fw-semibold">

                            Academic Session

                        </label>

                        <select
                            name="analysis_session"
                            class="form-select"
                        >

                            @forelse(
                                $availableSessions
                                as $session
                            )

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

                                    {{ $session }}

                                </option>

                            @empty

                                <option
                                    value="{{ $currentSession }}"
                                >

                                    {{ $currentSession ?: 'No Session' }}

                                </option>

                            @endforelse

                        </select>

                    </div>


                    {{-- TERM --}}

                    <div class="col-md-4">

                        <label class="form-label fw-semibold">

                            Term

                        </label>

                        <select
                            name="analysis_term"
                            class="form-select"
                        >

                            @forelse(
                                $availableTerms
                                as $term
                            )

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

                                    {{ $term }}

                                </option>

                            @empty

                                <option
                                    value="{{ $currentTerm }}"
                                >

                                    {{ $currentTerm ?: 'No Term' }}

                                </option>

                            @endforelse

                        </select>

                    </div>


                    {{-- CLASS --}}

                    <div class="col-md-4">

                        <label class="form-label fw-semibold">

                            Assigned Class

                        </label>

                        <select
                            name="analysis_class"
                            class="form-select"
                        >

                            <option value="all">

                                All My Assigned Classes

                            </option>


                            @foreach(
                                $assignedRecords
                                    ->filter(function ($assignment) use (
                                        $selectedTerm,
                                        $selectedSession
                                    ) {

                                        return
                                            $assignment->term == $selectedTerm
                                            &&
                                            $assignment->session == $selectedSession;

                                    })
                                    ->unique('student_classes_id')
                                as $assignment
                            )

                                <option
                                    value="{{ $assignment->student_classes_id }}"
                                    {{ (string)$selectedClass === (string)$assignment->student_classes_id ? 'selected' : '' }}
                                >

                                    {{ optional($assignment->class)->class_name ?? 'Unknown Class' }}

                                </option>

                            @endforeach

                        </select>

                    </div>


                    <div class="col-12">

                        <button
                            type="submit"
                            class="btn btn-primary px-4"
                        >

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

                            Analyze My Results

                        </button>

                    </div>

                </div>

            </form>

        </div>

    </div>



    
{{-- =========================================================
     STUDENT FINANCIAL SUMMARY
========================================================== --}}

<div class="row">


    {{-- =====================================================
         TOTAL BILLS
    ====================================================== --}}

    <div
        class="col-xl-4 col-md-0 animate-card"
        style="--delay:0.1s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        Total Bills

                    </p>


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

                        ₦{{ number_format(
                            $totalBill,
                            2
                        ) }}

                    </h3>


                    <small>

                        Current term bill

                    </small>

                </div>


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

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

                </div>

            </div>

        </div>

    </div>


    {{-- =====================================================
         PAYMENT MADE
    ====================================================== --}}

    <div
        class="col-xl-4 col-md-6 animate-card"
        style="--delay:0.2s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        Payment Made

                    </p>


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

                        ₦{{ number_format(
                            $totalPaid,
                            2
                        ) }}

                    </h3>


                    <small>

                        Current term payment

                    </small>

                </div>


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

                    <i
                        class="
                            ri-money-dollar-circle-line
                            fs-3
                        "
                    ></i>

                </div>

            </div>

        </div>

    </div>


    {{-- =====================================================
         OUTSTANDING
    ====================================================== --}}

    <div
        class="col-xl-4 col-md-6 animate-card"
        style="--delay:0.3s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        Outstanding

                    </p>


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

                        ₦{{ number_format(
                            $totalOutstanding,
                            2
                        ) }}

                    </h3>


                    <small>

                        Current term outstanding

                    </small>

                </div>


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

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

                </div>

            </div>

        </div>

    </div>

</div>


{{-- =========================================================
     2. QUICK STATS CARDS
========================================================== --}}

<div class="row">


    {{-- TOTAL SUBJECTS --}}

    <div
        class="col-xl-4 col-md-6 animate-card"
        style="--delay:0.2s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        My Subjects

                    </p>


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

                        {{ $totalSubjects }}

                    </h3>

                </div>


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

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

                </div>

            </div>

        </div>

    </div>


    {{-- TOTAL CBT TESTS --}}

    <div
        class="col-xl-4 col-md-6 animate-card"
        style="--delay:0.4s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        Test Available

                    </p>


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

                        {{ $totalCBTTests }}

                    </h3>

                </div>


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

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

                </div>

            </div>

        </div>

    </div>


    {{-- TESTS TAKEN --}}

    <div
        class="col-xl-4 col-md-6 animate-card"
        style="--delay:0.6s;"
    >

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

            <div
                class="
                    card-body
                    d-flex
                    justify-content-between
                    align-items-center
                "
            >

                <div>

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

                        Tests Taken

                    </p>


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

                        {{ $totalAttempts }}

                    </h3>

                </div>


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

            </div>

        </div>

    </div>

</div>


{{-- =========================================================
     3. RECENT CBT & RESULTS
========================================================== --}}

<div class="row">


    <div
        class="col-lg-6 animate-card"
        style="--delay:0.8s;"
    >

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

            <div
                class="
                    card-header
                    bg-gradient
                    text-white
                    rounded-top-4
                "
                style="
                    background:
                    linear-gradient(
                        135deg,
                        #36d1dc,
                        #5b86e5
                    );
                "
            >

                <h6 class="mb-0 fw-bold">

                    Recent CBT Tests

                </h6>

            </div>


            <div class="card-body">

                @if($recentCBT->isEmpty())

                    <p class="text-muted">

                        No CBT tests available.

                    </p>

                @else

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

                        Attempt CBT

                    </p>


                    <a
                        href="{{ route('student.index') }}"
                        class="btn btn-sm btn-primary"
                    >

                        Take Test

                    </a>

                @endif

            </div>

        </div>
        

    </div>

</div>


</div>

















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

<div class="container-fluid">

  



    {{-- ============================================================
         STUDENT INFORMATION
    ============================================================= --}}

    @if($loggedInStudent)

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

            <div class="card-body">

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

                    <div class="col-md-2 text-center">

                        @if($loggedInStudent->photo)

                            <img
                                src="{{ asset('uploads/student_photos/' . $loggedInStudent->photo) }}"
                                class="rounded-circle img-thumbnail"
                                width="100"
                                height="100"
                                style="object-fit:cover;"
                                alt="Student Photo"
                            >

                        @else

                            <div
                                class="rounded-circle bg-light d-flex align-items-center justify-content-center mx-auto"
                                style="width:100px;height:100px;"
                            >

                                <i
                                    class="fas fa-user fa-3x text-muted"
                                ></i>

                            </div>

                        @endif

                    </div>


                    <div class="col-md-10">

                        <h4 class="fw-bold mb-1">

                            {{ $loggedInStudent->name }}

                        </h4>

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

                            Student ID:
                            <strong>
                                {{ $loggedInStudent->user->user_name }}
                            </strong>

                        </p>


                        <div class="d-flex flex-wrap gap-2">

                            <span class="badge bg-primary" style="font-size:14px;">

                                {{ $totalSubjects }}
                                Subjects Assessed

                            </span>

                            <span class="badge bg-success" style="font-size:14px;">

                                {{ $passedSubjects }}
                                Passed

                            </span>

                            <span class="badge bg-danger" style="font-size:14px;">

                                {{ $failedSubjects }}
                                Failed

                            </span>

                        </div>

                    </div>

                </div>

            </div>

        </div>

    @endif


    {{-- ============================================================
         RESULT SUMMARY CARDS
    ============================================================= --}}

    <div class="row g-4 mb-4">


        {{-- OVERALL AVERAGE --}}

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

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

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

                        <div>

                            <p class="text-muted mb-1">
                                Overall Average
                            </p>

                            <h2 class="fw-bold mb-0">

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

                            </h2>

                        </div>

                        <div class="text-primary fs-2">

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

                        </div>

                    </div>

                    <small class="text-muted">

                        Based on all assessed subjects

                    </small>

                </div>

            </div>

        </div>


        {{-- PASS RATE --}}

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

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

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

                        <div>

                            <p class="text-muted mb-1">
                                Pass Rate
                            </p>

                            <h2 class="fw-bold text-success mb-0">

                                {{ number_format($passRate, 1) }}%

                            </h2>

                        </div>

                        <div class="text-success fs-2">

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

                        </div>

                    </div>

                    <small class="text-muted">

                        Pass mark: {{ $passMark }}%

                    </small>

                </div>

            </div>

        </div>


        {{-- PASSED --}}

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

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

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

                        <div>

                            <p class="text-muted mb-1">
                                Subjects Passed
                            </p>

                            <h2 class="fw-bold text-success mb-0">

                                {{ $passedSubjects }}

                            </h2>

                        </div>

                        <div class="text-success fs-2">

                            <i class="fas fa-graduation-cap"></i>

                        </div>

                    </div>

                    <small class="text-muted">

                        Out of {{ $totalSubjects }} subjects

                    </small>

                </div>

            </div>

        </div>


        {{-- FAILED --}}

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

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

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

                        <div>

                            <p class="text-muted mb-1">
                                Subjects Below Pass
                            </p>

                            <h2 class="fw-bold text-danger mb-0">

                                {{ $failedSubjects }}

                            </h2>

                        </div>

                        <div class="text-danger fs-2">

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

                        </div>

                    </div>

                    <small class="text-muted">

                        Subjects requiring attention

                    </small>

                </div>

            </div>

        </div>

    </div>


    {{-- ============================================================
         SECONDARY ANALYTICS
    ============================================================= --}}

    <div class="row g-4 mb-4">


        {{-- BEST SUBJECT --}}

        <div class="col-lg-3 col-md-6">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

                    <h6 class="text-muted">
                        Best Subject
                    </h6>

                    @if($bestSubject)

                        <h5 class="fw-bold">

                            {{ $bestSubject->subject_name }}

                        </h5>

                        <h3 class="text-success">

                            {{ number_format($bestSubject->average, 1) }}%

                        </h3>

                    @else

                        <p class="text-muted mb-0">
                            No result available
                        </p>

                    @endif

                </div>

            </div>

        </div>


        {{-- WEAKEST SUBJECT --}}

        <div class="col-lg-3 col-md-6">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

                    <h6 class="text-muted">
                        Subject Requiring Attention
                    </h6>

                    @if($weakestSubject)

                        <h5 class="fw-bold">

                            {{ $weakestSubject->subject_name }}

                        </h5>

                        <h3 class="text-danger">

                            {{ number_format($weakestSubject->average, 1) }}%

                        </h3>

                    @else

                        <p class="text-muted mb-0">
                            No result available
                        </p>

                    @endif

                </div>

            </div>

        </div>


        {{-- CLASS COMPARISON --}}

        <div class="col-lg-3 col-md-6">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

                    <h6 class="text-muted">
                        Selected Class Average
                    </h6>

                    <h3 class="fw-bold">

                        {{ number_format($comparisonAverage, 1) }}%

                    </h3>


                    @if($aboveClassAverage)

                        <span class="badge bg-success">

                            Above Class Average

                        </span>

                    @elseif($belowClassAverage)

                        <span class="badge bg-danger">

                            Below Class Average

                        </span>

                    @else

                        <span class="badge bg-secondary">

                            Equal to Class Average

                        </span>

                    @endif

                </div>

            </div>

        </div>


        {{-- POSITION ANALYSIS --}}

        <div class="col-lg-3 col-md-6">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-body">

                    <h6 class="text-muted">
                        Analytical Position
                    </h6>

                    @if($studentPosition)

                        <h3 class="fw-bold">

                            #{{ $studentPosition }}

                        </h3>

                        <small class="text-muted">

                            Among {{ $studentsCompared }}
                            students compared

                        </small>

                    @else

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

                            Not enough data

                        </p>

                    @endif

                </div>

            </div>

        </div>

    </div>


    {{-- ============================================================
         PERFORMANCE CHARTS
    ============================================================= --}}

    <div class="row g-4 mb-4">


        {{-- SUBJECT PERFORMANCE --}}

        <div class="col-lg-8">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-header bg-white border-0">

                    <h5 class="fw-bold mb-0">

                        <i class="fas fa-chart-bar text-primary me-2"></i>

                        Subject Performance

                    </h5>

                    <small class="text-muted">

                        Your performance in each assigned subject

                    </small>

                </div>

                <div class="card-body">

                    <div style="height:350px;">

                        <canvas id="studentSubjectChart"></canvas>

                    </div>

                </div>

            </div>

        </div>


        {{-- PERFORMANCE DONUT --}}

        <div class="col-lg-4">

            <div class="card border-0 shadow-sm h-100">

                <div class="card-header bg-white border-0">

                    <h5 class="fw-bold mb-0">

                        Overall Performance

                    </h5>

                </div>

                <div class="card-body">

                    <div style="height:280px;">

                        <canvas id="studentPerformanceChart"></canvas>

                    </div>

                    <div class="text-center mt-3">

                        <h3 class="fw-bold">

                            {{ number_format($overallPercentage, 1) }}%

                        </h3>

                        <small class="text-muted">

                            Overall Performance

                        </small>

                    </div>

                </div>

            </div>

        </div>

    </div>


    {{-- ============================================================
         SCORE BAND + GRADE DISTRIBUTION
    ============================================================= --}}

    <div class="row g-4 mb-4">


        <div class="col-lg-6">

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

                <div class="card-header bg-white border-0">

                    <h5 class="fw-bold mb-0">

                        Score Distribution

                    </h5>

                </div>

                <div class="card-body">

                    <div style="height:300px;">

                        <canvas id="studentScoreBandChart"></canvas>

                    </div>

                </div>

            </div>

        </div>


        <div class="col-lg-6">

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

                <div class="card-header bg-white border-0">

                    <h5 class="fw-bold mb-0">

                        Grade Distribution

                    </h5>

                </div>

                <div class="card-body">

                    <div style="height:300px;">

                        <canvas id="studentGradeChart"></canvas>

                    </div>

                </div>

            </div>

        </div>

    </div>


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

    @if($classPerformance->count() > 0)

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

            <div class="card-header bg-white border-0">

                <h5 class="fw-bold mb-1">

                    <i class="fas fa-school text-primary me-2"></i>

                    My Assigned Class Performance

                </h5>

                <small class="text-muted">

                    This section is useful when a student belongs to
                    more than one class.

                </small>

            </div>


            <div class="card-body">

                <div class="table-responsive">

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

                        <thead class="table-light">

                            <tr>

                                <th>S/N</th>

                                <th>Class</th>

                                <th>Subjects</th>

                                <th>Average</th>

                                <th>Pass Rate</th>

                                <th>Status</th>

                            </tr>

                        </thead>


                        <tbody>

                            @foreach(
                                $classPerformance
                                as $index => $class
                            )

                                <tr>

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


                                    <td class="fw-semibold">

                                        {{ $class->class_name }}

                                    </td>


                                    <td>

                                        {{ $class->subjects }}

                                    </td>


                                    <td>

                                        <strong>

                                            {{ number_format($class->average, 1) }}%

                                        </strong>

                                    </td>


                                    <td>

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

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

                                        </div>

                                        <small>

                                            {{ number_format($class->pass_rate, 1) }}%

                                        </small>

                                    </td>


                                    <td>

                                        @if($class->average >= 70)

                                            <span class="badge bg-success">
                                                Excellent
                                            </span>

                                        @elseif($class->average >= 60)

                                            <span class="badge bg-primary">
                                                Good
                                            </span>

                                        @elseif($class->average >= 50)

                                            <span class="badge bg-warning text-dark">
                                                Fair
                                            </span>

                                        @else

                                            <span class="badge bg-danger">
                                                Needs Attention
                                            </span>

                                        @endif

                                    </td>

                                </tr>

                            @endforeach

                        </tbody>

                    </table>

                </div>

            </div>

        </div>

    @endif


    {{-- ============================================================
         COMPLETE RESULT TABLE
    ============================================================= --}}


    @if(!$performanceRestricted)
    <div class="card border-0 shadow-sm mb-4">

        <div class="card-header bg-white border-0">

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

                <div>

                    <h5 class="fw-bold mb-1">

                        <i class="fas fa-file-alt text-primary me-2"></i>

                        My Result Analysis

                    </h5>

                    <small class="text-muted">

                        {{ $selectedTerm }}
                        |
                        {{ $selectedSession }}

                    </small>

                </div>


                <div>

                    <span class="badge bg-primary">

                        {{ $studentResults->count() }}
                        Result Records

                    </span>

                </div>

            </div>

        </div>


        <div class="card-body">

            @if($studentResults->count() > 0)

                <div class="table-responsive">

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

                        <thead class="table-dark">

                            <tr>

                                <th>S/N</th>

                                <th>Class</th>

                                <th>Subject</th>

                                <th>CA1</th>

                                <th>CA2</th>

                                <th>CA3</th>

                                <th>Exam</th>

                                <th>Total</th>

                                <th>Grade</th>

                                <th>Remark</th>

                                <th>Status</th>

                            </tr>

                        </thead>


                        <tbody>

                            @foreach(
                                $studentResults
                                as $index => $result
                            )

                                <tr>

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


                                    <td>

                                        {{ optional($result->studentClass)->class_name
                                            ?? 'N/A'
                                        }}

                                    </td>


                                    <td class="fw-semibold">

                                        {{ optional($result->subject)->subject_name
                                            ?? 'Unknown Subject'
                                        }}

                                    </td>


                                    <td>
                                        {{ number_format((float)$result->ca1, 1) }}
                                    </td>


                                    <td>
                                        {{ number_format((float)$result->ca2, 1) }}
                                    </td>


                                    <td>
                                        {{ number_format((float)$result->ca3, 1) }}
                                    </td>


                                    <td>
                                        {{ number_format((float)$result->exam, 1) }}
                                    </td>


                                    <td>

                                        <strong>

                                            {{ number_format((float)$result->total, 1) }}

                                        </strong>

                                    </td>


                                    <td>

                                        <span class="badge bg-primary">

                                            {{ $result->grade ?: 'N/A' }}

                                        </span>

                                    </td>


                                    <td>

                                        {{ $result->remark ?: 'N/A' }}

                                    </td>


                                    <td>

                                        @if((float)$result->total >= $passMark)

                                            <span class="badge bg-success">

                                                Passed

                                            </span>

                                        @else

                                            <span class="badge bg-danger">

                                                Attention

                                            </span>

                                        @endif

                                    </td>

                                </tr>

                            @endforeach

                        </tbody>


                        <tfoot class="table-light">

                            <tr>

                                <th colspan="7"
                                    class="text-end">

                                    Overall Average

                                </th>

                                <th>

                                    {{ number_format($overallAverage, 1) }}

                                </th>

                                <th colspan="3">

                                    {{ number_format($overallPercentage, 1) }}%

                                </th>

                            </tr>

                        </tfoot>

                    </table>

                </div>

            @else

                <div class="text-center py-5">

                    <i
                        class="fas fa-folder-open fa-3x text-muted mb-3"
                    ></i>

                    <h5>

                        No Result Available

                    </h5>

                    <p class="text-muted">

                        No result has been recorded for the selected
                        session, term and assigned class/subjects.

                    </p>

                </div>

            @endif

        </div>

    </div>

    @else

    {{-- ============================================================
         PERFORMANCE RESTRICTED BY BURSAR DEBT LIMIT
    ============================================================= --}}

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

        <div class="card-body text-center py-5">

            <div
                class="mx-auto mb-4 d-flex align-items-center justify-content-center rounded-circle bg-danger bg-opacity-10"
                style="width:80px;height:80px;"
            >

                <i class="fas fa-lock fa-2x text-danger"></i>

            </div>


            <h4 class="fw-bold text-danger mb-3">

                Academic Performance Restricted

            </h4>


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

                Your academic performance is currently unavailable
                because your outstanding balance is above the
                allowed debt limit set by the school bursary.

            </p>


            <div class="mt-4">

                <p class="mb-2">

                    <strong>
                        Current Outstanding:
                    </strong>

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

                        ₦{{ number_format($totalOutstanding, 2) }}

                    </span>

                </p>


                <p class="mb-2">

                    <strong>
                        Allowed Debt Limit:
                    </strong>

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

                        ₦{{ number_format($debtLimit, 2) }}

                    </span>

                </p>


                <p class="mb-0">

                    <strong>
                        Amount Required:
                    </strong>

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

                        ₦{{ number_format($amountRequiredToMeetDebtLimit, 2) }}

                    </span>

                </p>

            </div>


            <div class="alert alert-warning mt-4 mb-0">

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

                Please balance your account by at least

                <strong>
                    ₦{{ number_format($amountRequiredToMeetDebtLimit, 2) }}
                </strong>

                to bring your outstanding balance within the
                allowed debt limit and access your academic performance.

            </div>

        </div>

    </div>

@endif





    {{-- ============================================================
         PERFORMANCE INSIGHT
    ============================================================= --}}

    <div class="row g-4 mb-4">


        {{-- STRONG PERFORMANCE --}}

        <div class="col-lg-6">

            <div class="card border-0 shadow-sm h-100">

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

                    <h5 class="mb-0">

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

                        Strong Performance

                    </h5>

                </div>

                <div class="card-body">

                    @if($bestSubject)

                        <p>

                            Your highest-performing subject is

                            <strong>

                                {{ $bestSubject->subject_name }}

                            </strong>

                            with a score of

                            <strong>

                                {{ number_format($bestSubject->average, 1) }}%

                            </strong>.

                        </p>

                    @else

                        <p class="text-muted">

                            There is not enough result data for
                            performance analysis.

                        </p>

                    @endif

                </div>

            </div>

        </div>


        {{-- IMPROVEMENT AREA --}}

        <div class="col-lg-6">

            <div class="card border-0 shadow-sm h-100">

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

                    <h5 class="mb-0">

                        <i class="fas fa-lightbulb me-2"></i>

                        Area Requiring Attention

                    </h5>

                </div>

                <div class="card-body">

                    @if($weakestSubject)

                        <p>

                            The subject requiring the most attention
                            based on this analysis is

                            <strong>

                                {{ $weakestSubject->subject_name }}

                            </strong>

                            with

                            <strong>

                                {{ number_format($weakestSubject->average, 1) }}%

                            </strong>.

                        </p>

                    @else

                        <p class="text-muted">

                            There is not enough result data for
                            performance analysis.

                        </p>

                    @endif

                </div>

            </div>

        </div>

    </div>


    {{-- ============================================================
         CBT SECTION
    ============================================================= --}}

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

        <div>

            <h4 class="fw-bold mb-1">

                <i class="fas fa-laptop-code text-primary me-2"></i>

                CBT Performance

            </h4>

            <small class="text-muted">

                Computer Based Test performance for the selected
                term and session

            </small>

        </div>

    </div>


    <div class="row g-4 mb-4">


        {{-- CBT TAKEN --}}

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

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

                <div class="card-body">

                    <small class="text-muted">

                        CBT Tests Taken

                    </small>

                    <h2 class="fw-bold">

                        {{ $cbtTestsTaken }}

                    </h2>

                </div>

            </div>

        </div>


        {{-- CBT AVERAGE --}}

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

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

                <div class="card-body">

                    <small class="text-muted">

                        CBT Average

                    </small>

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

                        {{ number_format($cbtAverage, 1) }}%

                    </h2>

                </div>

            </div>

        </div>


        {{-- CBT HIGHEST --}}

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

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

                <div class="card-body">

                    <small class="text-muted">

                        Highest CBT Score

                    </small>

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

                        {{ number_format($cbtHighest, 1) }}%

                    </h2>

                </div>

            </div>

        </div>


        {{-- CBT PASS RATE --}}

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

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

                <div class="card-body">

                    <small class="text-muted">

                        CBT Pass Rate

                    </small>

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

                        {{ number_format($cbtPassRate, 1) }}%

                    </h2>

                </div>

            </div>

        </div>

    </div>


    {{-- ============================================================
         CBT ATTEMPT TABLE
    ============================================================= --}}

    <div class="card border-0 shadow-sm mb-5">

        <div class="card-header bg-white border-0">

            <h5 class="fw-bold mb-0">

                CBT Attempt History

            </h5>

        </div>


        <div class="card-body">

            @if($cbtAttempts->count() > 0)

                <div class="table-responsive">

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

                        <thead class="table-light">

                            <tr>

                                <th>S/N</th>

                                <th>Test</th>

                                <th>Score</th>

                                <th>Status</th>

                            </tr>

                        </thead>


                        <tbody>

                            @foreach(
                                $cbtAttempts
                                as $index => $attempt
                            )

                                @php

                                    $test = $cbtTests
                                        ->firstWhere(
                                            'id',
                                            $attempt->cbt_test_id
                                        );

                                    $score =
                                        (float)
                                        $attempt->score;

                                @endphp


                                <tr>

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


                                    <td>

                                        {{ optional($test)->subject->subject_name
                                            ?? 'CBT Test'
                                        }}

                                    </td>


                                    <td>

                                        <strong>

                                            {{ number_format($score, 1) }}%

                                        </strong>

                                    </td>


                                    <td>

                                        @if($score >= 40)

                                            <span class="badge bg-success">

                                                Passed

                                            </span>

                                        @else

                                            <span class="badge bg-danger">

                                                Below Pass Mark

                                            </span>

                                        @endif

                                    </td>

                                </tr>

                            @endforeach

                        </tbody>

                    </table>

                </div>

            @else

                <div class="text-center py-4">

                    <i class="fas fa-laptop fa-2x text-muted mb-2"></i>

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

                        No CBT attempt has been recorded for this
                        term/session.

                    </p>

                </div>

            @endif

        </div>

    </div>

</div>


{{-- ================================================================
     CHART.JS
================================================================ --}}


<script>

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


        /*
        |--------------------------------------------------------------------------
        | SUBJECT PERFORMANCE CHART
        |--------------------------------------------------------------------------
        |
        | Each bar represents the student's average score in an assigned
        | subject.
        |
        */

        const subjectLabels = @json(
            $subjectPerformance
                ->pluck('subject_name')
                ->values()
        );

        const subjectScores = @json(
            $subjectPerformance
                ->pluck('average')
                ->values()
        );


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


        if (
            subjectChartElement &&
            typeof Chart !== 'undefined'
        ) {

            new Chart(
                subjectChartElement,
                {

                    type: 'bar',

                    data: {

                        labels: subjectLabels,

                        datasets: [

                            {

                                label:
                                    'Score (%)',

                                data:
                                    subjectScores,

                                borderWidth:
                                    1

                            }

                        ]

                    },

                    options: {

                        responsive: true,

                        maintainAspectRatio: false,

                        scales: {

                            y: {

                                beginAtZero: true,

                                max: 100,

                                title: {

                                    display: true,

                                    text:
                                        'Percentage (%)'

                                }

                            }

                        },

                        plugins: {

                            legend: {

                                display: false

                            }

                        }

                    }

                }
            );

        }


        /*
        |--------------------------------------------------------------------------
        | OVERALL PERFORMANCE DOUGHNUT
        |--------------------------------------------------------------------------
        |
        | Example:
        |
        | Student average = 75%
        |
        | Chart shows:
        |
        | 75% achieved
        | 25% remaining
        |
        */

        const performanceElement =
            document.getElementById(
                'studentPerformanceChart'
            );


        if (
            performanceElement &&
            typeof Chart !== 'undefined'
        ) {

            new Chart(
                performanceElement,
                {

                    type: 'doughnut',

                    data: {

                        labels: [
                            'Performance',
                            'Remaining'
                        ],

                        datasets: [

                            {

                                data: [

                                    {{ $overallPercentage }},

                                    {{ max(100 - $overallPercentage, 0) }}

                                ],

                                borderWidth: 1

                            }

                        ]

                    },

                    options: {

                        responsive: true,

                        maintainAspectRatio: false,

                        cutout: '70%',

                        plugins: {

                            legend: {

                                position: 'bottom'

                            }

                        }

                    }

                }
            );

        }


        /*
        |--------------------------------------------------------------------------
        | SCORE BAND CHART
        |--------------------------------------------------------------------------
        */

        const scoreBandElement =
            document.getElementById(
                'studentScoreBandChart'
            );


        if (
            scoreBandElement &&
            typeof Chart !== 'undefined'
        ) {

            new Chart(
                scoreBandElement,
                {

                    type: 'bar',

                    data: {

                        labels:
                            @json(array_keys($scoreBands)),

                        datasets: [

                            {

                                label:
                                    'Number of Subjects',

                                data:
                                    @json(array_values($scoreBands)),

                                borderWidth: 1

                            }

                        ]

                    },

                    options: {

                        responsive: true,

                        maintainAspectRatio: false,

                        scales: {

                            y: {

                                beginAtZero: true,

                                ticks: {

                                    precision: 0

                                }

                            }

                        },

                        plugins: {

                            legend: {

                                display: false

                            }

                        }

                    }

                }
            );

        }


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

        const gradeElement =
            document.getElementById(
                'studentGradeChart'
            );


        if (
            gradeElement &&
            typeof Chart !== 'undefined'
        ) {

            new Chart(
                gradeElement,
                {

                    type: 'doughnut',

                    data: {

                        labels:
                            @json(array_keys($gradeDistribution)),

                        datasets: [

                            {

                                label:
                                    'Subjects',

                                data:
                                    @json(array_values($gradeDistribution)),

                                borderWidth: 1

                            }

                        ]

                    },

                    options: {

                        responsive: true,

                        maintainAspectRatio: false,

                        plugins: {

                            legend: {

                                position: 'bottom'

                            }

                        }

                    }

                }
            );

        }

    }
);

</script>


@endsection