logo

{{ $schoolName }}

{{ $schoolAddress }}

{{ $schoolContact }} | {{ $schoolEmail }}

Detailed Marks Certificate

{{ $dmcData[0]->exam_name }} Examination {{$school_session}}

Admission Number {{ $dmcData[0]->reg_no }}
Class {{ $class_name ?? 'N/A' }}
Section {{ $section_name ?? 'N/A' }}
Student Name {{ $dmcData[0]->student_name }}
Father Name {{ $dmcData[0]->father_name }}
@foreach ($dmcData as $record) @php $subject = $subjectDetails[$record->subject_name] ?? null; $total = $subject->total_marks ?? 100; $passing = $subject->passing_marks ?? 33; @endphp @endforeach @php $totalMarks = $dmcData->sum('marks'); $grade = ''; if ($totalMarks >= 400) { $grade = 'A'; } elseif ($totalMarks >= 350) { $grade = 'B'; } elseif ($totalMarks >= 300) { $grade = 'C'; } elseif ($totalMarks >= 250) { $grade = 'D'; } elseif ($totalMarks >= 200) { $grade = 'E'; } else { $grade = 'F'; } // Optional: get subject codes from subject names (abbreviated) $remarks = $dmcData->pluck('subject_name')->map(function ($subject) { return strtoupper(substr($subject, 0, 3)); // First 3 letters in uppercase })->join('-'); @endphp @php use Illuminate\Support\Facades\DB; // Get subject names from DMC data $subjectNames = $dmcData->pluck('subject_name')->toArray(); // Get total marks for these subjects from the 'subjects' table $totalOutOf = DB::table('subjects') ->whereIn('name', $subjectNames) ->sum('total_marks'); // assuming 'total_marks' column holds full marks for the subject $obtainedMarks = $dmcData->sum('marks'); $grade = ''; if ($obtainedMarks >= 0.8 * $totalOutOf) { $grade = 'A'; } elseif ($obtainedMarks >= 0.7 * $totalOutOf) { $grade = 'B'; } elseif ($obtainedMarks >= 0.6 * $totalOutOf) { $grade = 'C'; } elseif ($obtainedMarks >= 0.5 * $totalOutOf) { $grade = 'D'; } elseif ($obtainedMarks >= 0.4 * $totalOutOf) { $grade = 'E'; } else { $grade = 'F'; } @endphp
SUBJECT MARKS MARKS OBTAINED
THEORY ORAL TOTAL REMARKS
{{ $record->subject_name }} {{ $total }} {{ $record->marks }} -- {{ $record->marks }} {{ $record->marks >= $passing ? 'PASS' : 'FAIL' }}
TOTAL MARKS: {{$totalOutOf}} {{ $obtainedMarks }}
Remarks {{ $remarks }}
Position
Out of 3
Percentage 48.6%
Teacher Name Test
Signature Parents Signature

Issue Date: {{ \Carbon\Carbon::parse($issue_date)->format('d-M-Y') }}

Note/Errors/Omissions accepted

Examination Department

signature

Controller of Examination