Kaduna State Schools Quality Assurance Authority
{{ $title }}
KSSQAA Admin Copy
School Name: {{ $school ? $school->name : 'Fake result spreadsheet' }}
School Zone: {{ $school->zone ? $school->zone->zone : 'Fake result spreadsheet' }}
School Type: {{ $school ? ($school->schooltype_id == 1 ? 'Public' : 'Private') : 'Not Defined' }}
No. of Student(s) Registered: {{ $students ? $students->count() : 0 }}
No. of Male Student(s) Registered: {{ $students ? $students->where('gender', 'Male')->count() : 0 }}
No. of Female Student(s) Registered: {{ $students ? $students->where('gender', 'Female')->count() : 0 }}
@if ($students != null) @foreach ($students as $index => $student) @php $enggrade = $student->studentgrades->where('subject_id', 1)->first(); $mathgrade = $student->studentgrades->where('subject_id', 2)->first(); $irsgrade = $student->studentgrades->where('subject_id', 3)->first(); $crsgrade = $student->studentgrades->where('subject_id', 4)->first(); $hausagrade = $student->studentgrades->where('subject_id', 5)->first(); $yorubagrade = $student->studentgrades->where('subject_id', 6)->first(); $arabicgrade = $student->studentgrades->where('subject_id', 8)->first(); $historygrade = $student->studentgrades->where('subject_id', 14)->first(); $basicsciencegrade = $student->studentgrades->where('subject_id', 50)->first(); $pvcgrade = $student->studentgrades->where('subject_id', 51)->first(); $natgrade = $student->studentgrades->where('subject_id', 52)->first(); $busgrade = $student->studentgrades->where('subject_id', 53)->first(); $ccagrade = $student->studentgrades->where('subject_id', 54)->first(); $frenchgrade = $student->studentgrades->where('subject_id', 55)->first(); @endphp @endforeach @endif
s/n Exam number Student Name Gender Eng Math IRS CRS Hausa Yrb Arabic Hist B&Tech PVC NAT Bus CCA French
{{ $index + 1 }} {{ $student['examnumber'] }} {{ $student['lastname'] }} {{ $student['firstname'] }} {{ $student['middlename'] }} {{ $student['gender'] == 'Male' ? 'M' : 'F' }} {{ $enggrade ? ($enggrade->grade == 'withheld' ? 'pending' : $enggrade->grade) : '*' }} {{ $mathgrade ? ($mathgrade->grade == 'withheld' ? 'pending' : $mathgrade->grade) : '*' }} {{ $irsgrade ? ($irsgrade->grade == 'withheld' ? 'pending' : $irsgrade->grade) : '*' }} {{ $crsgrade ? ($crsgrade->grade == 'withheld' ? 'pending' : $crsgrade->grade) : '*' }} {{ $hausagrade ? ($hausagrade->grade == 'withheld' ? 'pending' : $hausagrade->grade) : '*' }} {{ $yorubagrade ? ($yorubagrade->grade == 'withheld' ? 'pending' : $yorubagrade->grade) : '*' }} {{ $arabicgrade ? ($arabicgrade->grade == 'withheld' ? 'pending' : $arabicgrade->grade) : '*' }} {{ $historygrade ? ($historygrade->grade == 'withheld' ? 'pending' : $historygrade->grade) : '*' }} {{ $basicsciencegrade ? ($basicsciencegrade->grade == 'withheld' ? 'pending' : $basicsciencegrade->grade) : '*' }} {{ $pvcgrade ? ($pvcgrade->grade == 'withheld' ? 'pending' : $pvcgrade->grade) : '*' }} {{ $natgrade ? ($natgrade->grade == 'withheld' ? 'pending' : $natgrade->grade) : '*' }} {{ $busgrade ? ($busgrade->grade == 'withheld' ? 'pending' : $busgrade->grade) : '*' }} {{ $ccagrade ? ($ccagrade->grade == 'withheld' ? 'pending' : $ccagrade->grade) : '*' }} {{ $frenchgrade ? ($frenchgrade->grade == 'withheld' ? 'pnd' : $frenchgrade->grade) : '*' }}
Pending Student has no C.A for the subject
abs Student was absent
* Subject not registered for student
*************{{ $title }},{{ $school ? $school->name : '' }},{{ $school->zone ? $school->zone->zone : '' }}*************
*************Kaduna State Schools Quality Assurance Authority (KSSQAA) Admin Copy*************