| {{ count($uniqueStudents) }} |
{{ $result->student->surname }}
{{ $result->student->firstname }}
{{ $result->student->middlename }}
|
{{ $result->student->dob }}
|
@foreach ($subjects as $subj)
@if ($subj)
@php
$resultsForSubject = $results
->where('subject_id', $subj->id)
->where('student_id', $result->student_id)
->where('term', $term);
$ca1Score = $resultsForSubject->sum('ca_score');
$ca2Score = $resultsForSubject->sum('ca2_score');
$examScore = $resultsForSubject->sum('exam_score');
$weightedAverage = $ca1Score + $ca2Score + $examScore;
@endphp
{{ $weightedAverage }} |
@else
|
@endif
@endforeach
@php
$studentResults = $results
->where('student_id', $result->student_id)
->where('term', $term);
$passesCount = $studentResults->filter(function ($studentResult) {
$weightedAverage = $studentResult->ca_score + $studentResult->ca2_score + $studentResult->exam_score;
return $weightedAverage >= 45;
})->count();
if (!function_exists('calculateGrade')) {
function calculateGrade($marks_to_obtain)
{
$grades = [
[
'score_from' => 70,
'score_to' => 100,
'grade' => 'A',
'remark' => 'DISTINCTION',
],
[
'score_from' => 60,
'score_to' => 69,
'grade' => 'B',
'remark' => 'VERY GOOD',
],
[
'score_from' => 50,
'score_to' => 59,
'grade' => 'C',
'remark' => 'AVERAGE',
],
[
'score_from' => 40,
'score_to' => 49,
'grade' => 'D',
'remark' => 'POOR',
],
[
'score_from' => 0,
'score_to' => 39,
'grade' => 'E',
'remark' => 'FAIL',
],
];
foreach ($grades as $grade) {
if (
$marks_to_obtain >= $grade['score_from'] &&
$marks_to_obtain <= $grade['score_to']
) {
return $grade['grade'];
}
}
return null;
}
}
$resultsForStudentSumall = $results->where('student_id', $result->student_id);
$sumallWeightedAverage = 0;
$studentSubjectCount = 0;
foreach ($subjects as $subj) {
$resultsForSubject = $resultsForStudentSumall
->where('subject_id', $subj->id)
->where('term', $term);
$ca1Score = $resultsForSubject->sum('ca_score');
$ca2Score = $resultsForSubject->sum('ca2_score');
$examScore = $resultsForSubject->sum('exam_score');
$sumallWeightedAverage += ($ca1Score + $ca2Score + $examScore);
if ($resultsForSubject->isNotEmpty()) {
$studentSubjectCount++;
}
}
$marks_to_obtain = $sumallWeightedAverage;
$average = $studentSubjectCount > 0 ? number_format($marks_to_obtain / $studentSubjectCount, 0) : 0;
$grade = calculateGrade($average);
@endphp
{{ $average }}
|
{{ $passesCount }} |
{{ $grade }} |
@endif
@endforeach
 }})