@if (!empty($promotes))
    <div class="row">
        <div class="offset-lg-10 col-lg-2 pull-right text-right mt-20 ">
            <a target="_blank" href="{{ route('session_student', $admission_number) }}"
                class="primary-btn small fix-gr-bg "><span class="ti-printer pr-2"></span> @lang('common.print') </a>
        </div>
    </div>
    <div class="row mt-20">
        <div class="col-lg-12">
            <div class="white-box">
                <div class="row justify-content-center">
                    <div class="col-lg-12">
                        <div class="single-report-admit">
                            <div class="card">
                                <div class="card-header">
                                    <div class="d-flex">
                                        <div>
                                            <img class="logo-img" src="{{ generalSetting()->logo }}" alt="">
                                        </div>
                                        <div class="ml-30">
                                            <h3 class="text-white">
                                                {{ isset(generalSetting()->school_name) ? generalSetting()->school_name : 'Infix School Management ERP' }}
                                            </h3>
                                            <p class="text-white mb-0">
                                                {{ isset(generalSetting()->address) ? generalSetting()->address : 'Infix School Address' }}
                                            </p>
                                        </div>
                                    </div>
                                </div>
                                <div>
                                    <img class="report-admit-img" 
                                    src="{{ $studentDetails->student_photo ? asset($studentDetails->student_photo) : asset('/backEnd/assets/img/avatar.png') }}" 
                                    width="50" height="50" alt="Student Photo">                               
                                </div>
                            </div>
                            <div class="card-body">
                                <div class="white-box p-5">

                                    <div class="row  mt-40 ">
                                        <div class="col-lg-12 transcript-heading">
                                            <h2 class="text-center text-uppercase"> @lang('reports.official_transcript') </h2>
                                        </div>
                                        <div class="row mt-20 transcript-heading">
                                            <div class="col-lg-4">
                                                <strong>@lang('student.student_name')
                                                    :</strong> {{ $studentDetails->full_name }} <br>

                                                <strong>@lang('student.mother_name')
                                                    :</strong> {{ @$studentDetails->student->parents->mothers_name }}
                                                <br>
                                                <strong>@lang('common.school_name')
                                                    :</strong> {{ generalSetting()->school_name }}<br>
                                            </div>
                                            <div class="col-lg-4">
                                                <strong>@lang('reports.transcript_no')
                                                    :</strong> {{ $studentDetails->admission_number }}<br>
                                                <strong>@lang('common.academic_year')
                                                    : </strong> {{ generalSetting()->academic_Year->year }}
                                                <br>
                                                <strong>@lang('student.admission_no')
                                                    :</strong> {{ $studentDetails->admission_number }}<br>
                                            </div>

                                            <div class="col-lg-4">
                                                <strong>@lang('common.class')
                                                    :</strong> {{ @$current_class->class_name }}<br>
                                                <strong>@lang('common.section')
                                                    :</strong> {{ @$current_section->section_name }}<br>
                                                <strong>@lang('common.date_of_birth')
                                                    :</strong>
                                                {{ $studentDetails->date_of_birth != '' ? dateConvert($studentDetails->date_of_birth) : '' }}
                                            </div>
                                        </div>
                                    </div>

                                    @foreach ($promotes as $studentDetails)
                                        @php
                                            $student_id = $studentDetails->student_id;
                                            $class_id = $studentDetails->previous_class_id;
                                            $section_id = $studentDetails->previous_section_id;
                                            $year = $studentDetails->year;

                                            @$current_class = App\SmStudent::where('sm_students.id', $student_id)
                                                ->join('sm_classes', 'sm_classes.id', '=', 'sm_students.class_id')
                                                ->first();
                                            @$current_section = App\SmStudent::where('sm_students.id', $student_id)
                                                ->join('sm_sections', 'sm_sections.id', '=', 'sm_students.section_id')
                                                ->first();
                                            $current_session = App\SmStudent::where('sm_students.id', $student_id)
                                                ->join(
                                                    'sm_academic_years',
                                                    'sm_academic_years.id',
                                                    '=',
                                                    'sm_students.session_id',
                                                )
                                                ->first();

                                            $exams = App\SmExam::where('active_status', 1)
                                                ->where('class_id', $class_id)
                                                ->where('section_id', $section_id)
                                                ->get();
                                            $exam_types = App\SmExamType::where('active_status', 1)
                                                ->where('academic_id', getAcademicId())
                                                ->get();
                                            $classes = App\SmClass::where('active_status', 1)
                                                ->where('academic_id', getAcademicId())
                                                ->get();
                                            $exam_setup = App\SmExamSetup::where([
                                                ['class_id', $class_id],
                                                ['section_id', $section_id],
                                            ])->get();

                                            $subjects = App\SmAssignSubject::where([
                                                ['class_id', $class_id],
                                                ['section_id', $section_id],
                                            ])->get();

                                            $assinged_exam_types = [];
                                            foreach ($exams as $exam) {
                                                $assinged_exam_types[] = $exam->exam_type_id;
                                            }

                                            $assinged_exam_types = array_unique($assinged_exam_types);

                                            foreach ($assinged_exam_types as $assinged_exam_type) {
                                                foreach ($subjects as $subject) {
                                                    $is_mark_available = App\SmResultStore::where([
                                                        ['class_id', $class_id],
                                                        ['section_id', $section_id],
                                                        ['student_id', $student_id],
                                                        ['subject_id', $subject->subject_id],
                                                        ['exam_type_id', $assinged_exam_type],
                                                    ])->first();

                                                    // return $is_mark_available;
                                                    if ($is_mark_available == '') {
                                                        return redirect('session-student')->with(
                                                            'message-danger',
                                                            'Ops! Your result is not found! Please check mark register.',
                                                        );
                                                    }
                                                }
                                            }

                                            $is_result_available = App\SmResultStore::where([
                                                ['class_id', $class_id],
                                                ['section_id', $section_id],
                                                ['student_id', $student_id],
                                            ])->get();

                                        @endphp

                                        @if ($is_result_available->count() > 0)
                                            <div class="row  mt-40 ">
                                                <div class="col-lg-3">
                                                    <strong>@lang('reports.exam_terms'):</strong>
                                                    @php
                                                        $exam = App\SmExamType::where(
                                                            'id',
                                                            $is_mark_available->exam_type_id,
                                                        )->first();
                                                    @endphp
                                                    {{ $exam->title }}
                                                </div>
                                                <div class="col-lg-3">
                                                    <strong>@lang('student.roll'):</strong>
                                                    {{ $studentDetails->previous_roll_number }}
                                                </div>
                                                <div class="col-lg-3">
                                                    <strong>@lang('common.class'):</strong>
                                                    @php
                                                        $class = App\SmClass::where(
                                                            'id',
                                                            $is_mark_available->class_id,
                                                        )->first();
                                                    @endphp
                                                    {{ $class->class_name }}
                                                </div>
                                                <div class="col-lg-3">
                                                    <strong>@lang('common.date'):</strong>
                                                    {{ $is_mark_available->created_at != '' ? dateConvert($is_mark_available->created_at) : '' }}

                                                </div>

                                                <table class="w-100  mt-10 mb-20 table table-bordered">
                                                    <thead>
                                                        <tr style="text-align: center;">
                                                            <th rowspan="2">@lang('common.subjects')</th>
                                                            @foreach ($assinged_exam_types as $assinged_exam_type)
                                                                @php
                                                                    $exam_type = App\SmExamType::examType(
                                                                        $assinged_exam_type,
                                                                    );
                                                                @endphp
                                                                <th colspan="2" style="text-align: center;">
                                                                    {{ $exam_type->title }}</th>
                                                            @endforeach
                                                            <th rowspan="2">@lang('exam.result')</th>
                                                            <th rowspan="2">@lang('exam.grade')</th>
                                                            <th rowspan="2">@lang('exam.gpa')</th>
                                                        </tr>
                                                        <tr style="text-align: center;">
                                                            @foreach ($assinged_exam_types as $assinged_exam_type)
                                                                <th>@lang('exam.marks')</th>
                                                                <th>@lang('exam.grade')</th>
                                                            @endforeach
                                                        </tr>
                                                    </thead>
                                                    <tbody>
                                                        @php
                                                            $total_fail = 0;
                                                            $total_marks = 0;
                                                            $sumation = 0;
                                                        @endphp
                                                        @foreach ($subjects as $data)
                                                            <tr style="text-align: center">
                                                                <td>{{ $data->subject != '' ? $data->subject->subject_name : '' }}</td>
                                                                
                                                                                                                                <td>{{ $totalSumSub }}</td>

                                                                <td>
                                                                    @php
                                                                        if ($totalSubjectFail > 0) {
                                                                            echo 'F';
                                                                        } else {
                                                                            $totalSumSub =
                                                                                $totalSumSub /
                                                                                count($assinged_exam_types);
                                                                            $mark_grade = App\SmMarksGrade::where([
                                                                                ['percent_from', '<=', $totalSumSub],
                                                                                ['percent_upto', '>=', $totalSumSub],
                                                                            ])
                                                                                ->where('academic_id', getAcademicId())
                                                                                ->first();
                                                                            echo @$mark_grade->grade_name;
                                                                        }
                                                                    @endphp
                                                                </td>
                                                                <td>
                                                                    @php
                                                                        if ($totalSubjectFail > 0) {
                                                                            echo 'F';
                                                                        } else {
                                                                            $mark_grade = App\SmMarksGrade::where([
                                                                                ['percent_from', '<=', $totalSumSub],
                                                                                ['percent_upto', '>=', $totalSumSub],
                                                                            ])
                                                                                ->where('academic_id', getAcademicId())
                                                                                ->first();
                                                                            echo @$mark_grade->gpa;
                                                                            $sumation = $sumation + $mark_grade->gpa;
                                                                        }
                                                                    @endphp
                                                                </td>
                                                            </tr>
                                                        @endforeach
                                                        @php
                                                            $colspan = 4 + count($assinged_exam_types) * 2;
                                                        @endphp
                                                        <tr>
                                                            <td colspan="{{ $colspan / 2 - 1 }}" class="text-center">
                                                                @lang('exam.total_marks')</td>
                                                            <td colspan="{{ $colspan / 2 + 1 }}" class="text-center">
                                                                {{ $total_marks }}</td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="{{ $colspan / 2 - 1 }}" class="text-center">
                                                                @lang('exam.total_grade')</td>
                                                            <td colspan="{{ $colspan / 2 + 1 }}" class="text-center">
                                                                @php
                                                                    $grade_point_final = '0.00';
                                                                    if ($total_fail != 0) {
                                                                        echo 'F';
                                                                    } else {
                                                                        if ($total_fail != 0) {
                                                                            $grade_point_final = '0.00';
                                                                        } else {
                                                                            if ($sumation != 0) {
                                                                                if ($subjects->count() != 0) {
                                                                                    $grade_point_final =
                                                                                        $sumation / $subjects->count();
                                                                                }
                                                                            } else {
                                                                                $grade_point_final = '0.00';
                                                                            }
                                                                            $sumation = 0;
                                                                        }
                                                                        if ($grade_point_final != '0.00') {
                                                                            $average_grade = App\SmMarksGrade::where([
                                                                                ['from', '<=', $grade_point_final],
                                                                                ['up', '>=', $grade_point_final],
                                                                            ])
                                                                                ->where('academic_id', getAcademicId())
                                                                                ->first();
                                                                            echo @$average_grade->grade_name;
                                                                        } else {
                                                                            echo 'F';
                                                                        }
                                                                    }
                                                                @endphp
                                                            </td>
                                                        </tr>
                                                        <tr>
                                                            <td colspan="{{ $colspan / 2 - 1 }}" class="text-center">
                                                                @lang('reports.total_gpa')</td>
                                                            <td colspan="{{ $colspan / 2 + 1 }}" class="text-center">
                                                                {{ number_format($grade_point_final, 2, ',', '') }}
                                                            </td>
                                                        </tr>
                                                    </tbody>
                                                </table>
                                            </div>
                                        @endif
                                    @endforeach
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
@endif