NOTRE DAME COLLEGE
MYMENSINGH
ACADEMIC RECORD
|
HSC
|
| Subject & Class |
|
@foreach ($exams as $exam)
{{ $exam->name }} |
@endforeach
1stTerm Marks-100 |
Promotion Marks-100 (i) |
Sent-Up Marks-100 (ii) |
|
Attendance |
Theory Marks 100/75/60 Lab. Marks 25/40 |
| Delivered |
Attended |
@php
$total = 0;
$total_subject = 0;
$total_marks_store = 0;
$total_marks_store_two = 0;
$total_marks_store_three = 0;
$total_count_subject_one = 0;
$total_count_subject_two = 0;
$total_count_subject_three = 0;
@endphp
@if ($stOnline->group_id == 2)
@foreach ($subjects->slice(0, 6) as $subject)
@php
$total = 0;
$total_subject = 0;
$row_total = 0;
$point = 0;
@endphp
| {{ $subject->subject_name }} |
i |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
@php
$quizzes = $subject->quizzesForStudent($student_id)->get();
@endphp
@if ($quizzes && count($quizzes) > 0 && isset($quizzes[0]))
@php
$total_marks_store += (int) $quizzes[0]->total_marks;
$total_count_subject_one++;
@endphp
{{ $quizzes[0]->exam_id == 8 ? round($quizzes[0]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 1 && isset($quizzes[1]))
@php
$total_marks_store_two += (int) $quizzes[0]->total_marks;
$total_count_subject_two++;
@endphp
{{ $quizzes[1]->exam_id == 9 ? round($quizzes[1]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 2 && isset($quizzes[1]))
@php
$total_marks_store_three += (int) $quizzes[0]->total_marks;
$total_count_subject_three++;
@endphp
{{ $quizzes[2]->exam_id == 11 ? round($quizzes[2]->total_marks) ?? 0 : 0 }}
@endif
|
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('subject_id', $subject->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('attendance', 1)
->where('subject_id', $subject->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@if ($loop->index + 1 == 1)
{{ $stOnline->bangla ?? '--' }}
@endif
@if ($loop->index + 1 == 2)
{{ $stOnline->english ?? '--' }}
@endif
@if ($loop->index + 1 == 3)
{{ $stOnline->ict ?? '--' }}
@endif
@if ($loop->index + 1 == 4)
@if ($stOnline->ssc_group == 1)
{{-- Science --}}
{{ $stOnline->physics ?? '--' }}
@elseif ($stOnline->ssc_group == 2)
{{-- Business studies --}}
{{ $stOnline->financeBanking ?? '--' }}
@elseif ($stOnline->ssc_group == 3)
{{-- Humanities --}}
{{ $stOnline->geography ?? '--' }}
@endif
@endif
@if ($loop->index + 1 == 5)
@if ($stOnline->ssc_group == 1)
{{-- Science --}}
{{ $stOnline->chemistry ?? '--' }}
@elseif ($stOnline->ssc_group == 2)
{{-- Business studies --}}
{{ $stOnline->financeBanking ?? '--' }}
@elseif ($stOnline->ssc_group == 3)
{{-- Humanities --}}
{{ $stOnline->geography ?? '--' }}
@endif
@endif
|
| ii |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
{{-- {{ $quizzes[0]->exam_id == 8 ? $quizzes[0]->total_marks ?? 0 : 0 }} --}}
|
{{-- {{ $quizzes[1]->exam_id == 2 ? $quizzes[1]->total_marks ?? 0 : 0 }} --}}
|
|
|
|
{{-- | --}}
@php $total = $total + $row_total; @endphp
@endforeach
@else
@foreach ($subjects->slice(0, 5) as $subject)
@php
$total = 0;
$total_subject = 0;
$row_total = 0;
$point = 0;
@endphp
| {{ $subject->subject_name }} |
i |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
@php
$quizzes = $subject->quizzesForStudent($student_id)->get();
@endphp
@if ($quizzes && count($quizzes) > 0 && isset($quizzes[0]))
@php
$total_marks_store += (int) $quizzes[0]->total_marks;
$total_count_subject_one++;
@endphp
{{ $quizzes[0]->exam_id == 8 ? round((int) $quizzes[0]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 1 && isset($quizzes[1]))
@php
$total_marks_store_two += (int) $quizzes[0]->total_marks;
$total_count_subject_two++;
@endphp
{{ $quizzes[1]->exam_id == 9 ? round((int) $quizzes[1]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 2 && isset($quizzes[1]))
@php
$total_marks_store_three += (int) $quizzes[0]->total_marks;
$total_count_subject_three++;
@endphp
{{ $quizzes[2]->exam_id == 11 ? round((int) $quizzes[2]->total_marks) ?? 0 : 0 }}
@endif
|
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('subject_id', $subject->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('attendance', 1)
->where('subject_id', $subject->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@if ($loop->index + 1 == 1)
{{ $stOnline->bangla ?? '--' }}
@endif
@if ($loop->index + 1 == 2)
{{ $stOnline->english ?? '--' }}
@endif
@if ($loop->index + 1 == 3)
{{ $stOnline->ict ?? '--' }}
@endif
@if ($loop->index + 1 == 4)
@if ($stOnline->ssc_group == 1)
{{-- Science --}}
{{ $stOnline->physics ?? '--' }}
@elseif ($stOnline->ssc_group == 2)
{{-- Business studies --}}
{{ $stOnline->financeBanking ?? '--' }}
@elseif ($stOnline->ssc_group == 3)
{{-- Humanities --}}
{{ $stOnline->geography ?? '--' }}
@endif
@endif
@if ($loop->index + 1 == 5)
@if ($stOnline->ssc_group == 1)
{{-- Science --}}
{{ $stOnline->chemistry ?? '--' }}
@elseif ($stOnline->ssc_group == 2)
{{-- Business studies --}}
{{ $stOnline->financeBanking ?? '--' }}
@elseif ($stOnline->ssc_group == 3)
{{-- Humanities --}}
{{ $stOnline->geography ?? '--' }}
@endif
@endif
|
| ii |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
{{-- {{ $quizzes[0]->exam_id == 8 ? $quizzes[0]->total_marks ?? 0 : 0 }} --}}
|
{{-- {{ $quizzes[1]->exam_id == 2 ? $quizzes[1]->total_marks ?? 0 : 0 }} --}}
|
|
|
|
{{-- | --}}
@php $total = $total + $row_total; @endphp
@endforeach
@endif
@if (isset($stOnline->elective_subject) && $stOnline->elective_subject)
|
@php
$subject1 = App\Subject::where(
'id',
$stOnline->elective_subject,
)->first();
@endphp
{{ $subject1->subject_name ?? null }}
|
i |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject1->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
@php
$quizzes = $subject1->quizzesForStudent($student_id)->get();
@endphp
@if ($quizzes && count($quizzes) > 0 && isset($quizzes[0]))
@php
$total_marks_store += (int) $quizzes[0]->total_marks;
$total_count_subject_one++;
@endphp
{{ $quizzes[0]->exam_id == 8 ? round($quizzes[0]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 1 && isset($quizzes[1]))
@php
$total_marks_store_two += (int) $quizzes[0]->total_marks;
$total_count_subject_two++;
@endphp
{{ $quizzes[1]->exam_id == 9 ? round($quizzes[1]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 2 && isset($quizzes[1]))
@php
$total_marks_store_three += (int) $quizzes[0]->total_marks;
$total_count_subject_three++;
@endphp
{{ $quizzes[2]->exam_id == 11 ? round($quizzes[2]->total_marks) ?? 0 : 0 }}
@endif
|
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('subject_id', $subject1->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('attendance', 1)
->where('subject_id', $subject1->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@if ($stOnline->ssc_group == 1)
{{-- Science --}}
{{ $stOnline->biology ?? '--' }}
@elseif ($stOnline->ssc_group == 2)
{{-- Business studies --}}
{{ $stOnline->accounting ?? '--' }}
@elseif ($stOnline->ssc_group == 3)
{{-- Humanities --}}
{{ $stOnline->historyBangladesh ?? '--' }}
@endif
|
| ii |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
{{-- {{ $quizzes[0]->exam_id == 8 ? $quizzes[0]->total_marks ?? 0 : 0 }} --}}
|
{{-- {{ $quizzes[1]->exam_id == 2 ? $quizzes[1]->total_marks ?? 0 : 0 }} --}}
|
|
|
|
{{-- | --}}
@endif
@if (isset($stOnline->optional_subject) && $stOnline->optional_subject)
|
@php
$subject2 = App\Subject::where(
'id',
$stOnline->optional_subject,
)->first();
@endphp
{{ $subject2->subject_name ?? null }}
|
i |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject2->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
@php
$quizzes = $subject2->quizzesForStudent($student_id)->get();
@endphp
@if ($quizzes && count($quizzes) > 0 && isset($quizzes[0]))
@php
$total_marks_store += (int) $quizzes[0]->total_marks;
$total_count_subject_one++;
@endphp
{{ $quizzes[0]->exam_id == 8 ? round((int) $quizzes[0]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 1 && isset($quizzes[1]))
@php
$total_marks_store_two += (int) $quizzes[0]->total_marks;
$total_count_subject_two++;
@endphp
{{ $quizzes[1]->exam_id == 9 ? round((int) $quizzes[1]->total_marks) ?? 0 : 0 }}
@endif
|
@if ($quizzes && count($quizzes) > 2 && isset($quizzes[1]))
@php
$total_marks_store_three += (int) $quizzes[0]->total_marks;
$total_count_subject_three++;
@endphp
{{ $quizzes[2]->exam_id == 11 ? round((int) $quizzes[2]->total_marks) ?? 0 : 0 }}
@endif
|
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('subject_id', $subject2->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
@php
$studentAttendanceCount = App\StudentAttendance::where(
'student_id',
$student_id,
)
->where('attendance', 1)
->where('subject_id', $subject2->id)
->count();
@endphp
{{ $studentAttendanceCount ?? 0 }}
|
{{ $stOnline->grade_4th_sub }}
|
| ii |
@foreach ($exams as $exam)
@foreach ($mark_details[$subject2->id][$exam->exam_id] ?? [] as $md)
@php
$row_total = $row_total + $md->mark_value;
$point = get_point($row_total);
$grade = get_grade($row_total);
@endphp
{{ $md->mark_value }} |
@endforeach
@php $total_subject = count($exams) @endphp
@endforeach
{{-- {{ $quizzes[0]->exam_id == 8 ? $quizzes[0]->total_marks ?? 0 : 0 }} --}}
|
{{-- {{ $quizzes[1]->exam_id == 2 ? $quizzes[1]->total_marks ?? 0 : 0 }} --}}
|
|
|
|
{{-- | --}}
@endif
| Aggregate |
|
{{ number_format($total_marks_store, 2) ?? 0 }}
|
{{ number_format($total_marks_store_two, 2) ?? 0 }}
|
{{ number_format($total_marks_store_three, 2) ?? 0 }}
|
2yr. Aggr Marks |
i |
Ex: |
GPA: {{ $stOnline->hsc_gpa }} |
| Percentage |
|
{{ $total_count_subject_one != 0 ? number_format($total_marks_store / $total_count_subject_one, 2) : '0.00' }}
|
{{ $total_count_subject_two != 0 ? number_format($total_marks_store / $total_count_subject_two, 2) : '0.00' }}
|
{{ $total_count_subject_three != 0 ? number_format($total_marks_store / $total_count_subject_three, 2) : '0.00' }}
|
2yr % Marks |
i |
|
|
| ii |
|
| Place of Merit |
|
@php
$query1 = App\Quiz::where('class', $studentSession->class_id)
->where('section', $studentSession->section_id)
->where('exam_id', 8)
->with('student');
$query1
->select(
'student_id',
Illuminate\Support\Facades\DB::raw(
'SUM(total_marks) as total_marks',
),
)
->groupBy('student_id');
$students1 = $query1->orderBy('total_marks', 'DESC')->get();
$position = 1;
$prevTotalMarks = null;
$studentPosition = null;
foreach ($students1 as $student) {
if (
$prevTotalMarks !== null &&
$prevTotalMarks != $student->total_marks
) {
$position++;
}
$student->position = $position;
if ($student->student_id == $stOnline->student_id) {
$studentPosition = $position;
}
$prevTotalMarks = $student->total_marks;
}
@endphp
{{ $studentPosition ?? null }}
|
@php
$query2 = App\Quiz::where('class', $studentSession->class_id)
->where('section', $studentSession->section_id)
->where('exam_id', 9)
->with('student');
$query2
->select(
'student_id',
Illuminate\Support\Facades\DB::raw(
'SUM(total_marks) as total_marks',
),
)
->groupBy('student_id');
$students2 = $query2->orderBy('total_marks', 'DESC')->get();
$position2 = 1;
$prevTotalMarks2 = null;
$studentPosition2 = null;
foreach ($students2 as $student2) {
if (
$prevTotalMarks2 !== null &&
$prevTotalMarks2 != $student2->total_marks
) {
$position2++;
}
$student2->position2 = $position2;
if ($student2->student_id == $stOnline->student_id) {
$studentPosition2 = $position2;
}
$prevTotalMarks2 = $student2->total_marks;
}
@endphp
{{ $studentPosition2 ?? null }}
|
@php
$query3 = App\Quiz::where('class', $studentSession->class_id)
->where('section', $studentSession->section_id)
->where('exam_id', 11)
->with('student');
$query3
->select(
'student_id',
Illuminate\Support\Facades\DB::raw(
'SUM(total_marks) as total_marks',
),
)
->groupBy('student_id');
$students3 = $query3->orderBy('total_marks', 'DESC')->get();
$position3 = 1;
$prevTotalMarks3 = null;
$studentPosition3 = null;
foreach ($students3 as $student3) {
if (
$prevTotalMarks3 !== null &&
$prevTotalMarks3 != $student3->total_marks
) {
$position3++;
}
$student3->position3 = $position3;
if ($student3->student_id == $stOnline->student_id) {
$studentPosition3 = $position3;
}
$prevTotalMarks3 = $student3->total_marks;
}
@endphp
{{ $studentPosition3 ?? null }}
|
|
Promoted to Class XII:
Sent-up HSC Exams:
@php
$tcData = App\TransferCertificate::where(
'student_id',
$stOnline->student_id,
)->first();
@endphp
TC Date: {{ $tcData->left_date ?? null }}
|
| Total Students |
|
{{ $total_students }}
|
{{ $total_students }}
|
{{ $total_students }}
|
|