| {{ $loop->iteration }} |
{{ strtoupper($student->user->user_name) }} |
{{ strtoupper($student->name) }} |
@foreach($subjects as $subject)
@php
$first = $sheet[$student->id][$subject->id]['First Term'] ?? null;
$second = $sheet[$student->id][$subject->id]['Second Term'] ?? null;
$third = $sheet[$student->id][$subject->id]['Third Term'] ?? null;
$firstMark = in_array('First Term',$selectedTerms) ? ($first->total ?? '-') : '-';
$secondMark = in_array('Second Term',$selectedTerms) ? ($second->total ?? '-') : '-';
$thirdMark = in_array('Third Term',$selectedTerms) ? ($third->total ?? '-') : '-';
$total = 0;
$used = 0;
if($first && in_array('First Term',$selectedTerms)){
$total += $first->total;
$used++;
}
if($second && in_array('Second Term',$selectedTerms)){
$total += $second->total;
$used++;
}
if($third && in_array('Third Term',$selectedTerms)){
$total += $third->total;
$used++;
}
$percentage = $used ? round($total/$used,2) : 0;
if($used){
$grandTotal += $percentage;
$subjectCount++;
}
if($percentage>=70){
$grade="A";
}elseif($percentage>=60){
$grade="B";
}elseif($percentage>=50){
$grade="C";
}elseif($percentage>=45){
$grade="D";
}elseif($percentage>=40){
$grade="E";
}else{
$grade="F";
}
@endphp
{{ $firstMark }} |
{{ $secondMark }} |
{{ $thirdMark }} |
{{ $used ? round($total,2) : '-' }} |
{{ $used ? round($percentage,2) : '-' }} |
{{ $used ? $grade : '-' }} |
@endforeach
@php
$average = $subjectCount ? round($grandTotal/$subjectCount,2) : 0;
$position = $studentPositions[$student->id] ?? '-';
@endphp
{{ round($grandTotal,2) }} |
{{ $average }} |
{{ $position }} |
@endforeach