@php
    use App\Http\Controllers\eims\enums\AcademicExamResultBehaviorStatus;use App\Http\Controllers\eims\enums\AcademicExamResultCoCurricularActivityStatus;use App\Service\EimsService;
@endphp
@extends('layouts/eims_layout')
@section('title', '| ' . $pageTitle)
@section('content')
    @include('successMsg')

    <style>
        .remarks tr > td, .table > tbody > tr > td, .table > tbody > tr > th, .table > tfoot > tr > td, .table > tfoot > tr > th, .table > thead > tr > td, .table > thead > tr > th {
            padding: 6px !important;
        }

        .student_information tr > td {
            padding: 3px !important;
        }


        .remarks, .table-bordered > tbody > tr > td, .table-bordered > tbody > tr > th, .table-bordered > tfoot > tr > td, .table-bordered > tfoot > tr > th, .table-bordered > thead > tr > td, .table-bordered > thead > tr > th {
            border: 1px solid #000 !important;
        }

        .custom_box {
            height: 15px;
            width: 15px;
            border: 1px solid black;
        }

        .value {
            font-size: 12px !important;
        }

        .s_name {
            font-size: 10px !important;
        }

        .line_height {
            line-height: 1.00;
        }

        .v_align {
            vertical-align: middle !important;
        }

        .underline {
            padding: 0px;
            display: inline-block;
            border-top: 1px solid #000000;
        }

        .fail {
            border-bottom: 2px solid red;
        }
    </style>
    <div class="row">
        <div class="col-xs-12 text-right">
            <button class="" onclick="PrintDiv()">Print</button>
        </div>
    </div>
    <div class="row add-data-form">

        <div class="col-md-10 col-md-offset-1" style="color: #0c0c0c">
            <div class="page-wrapper">
                <div class="content container-fluid">
                    <div class="row">
                        <div class="card-box">
                            <div id="print">
                                <!--start this row is for mark_sheet header -->
                                <div class="row">
                                    <div class="col-xs-2 text-right">
                                        @if(is_null($company->image))
                                            <div style="width:100px;height: 100px;"></div>
                                        @else
                                            <img src="{{ asset("images/company/$company->image") }}"
                                                 style="width:100px;height: 100px;" alt="{{ $company->name }}">
                                        @endif

                                    </div>
                                    <div class="col-xs-10">
                                        <h2 class="line_height">{{$company->name}}</h2>
                                        @if(!empty($company->address))
                                            <p class="line_height">{{$company->address}}</p>
                                        @endif
                                        <p class="line_height">
                                            {{ $company->phone ? "Phone: $company->phone" : null }}
                                            {{$company->telephone ? ', Telephone: ' . $company->telephone : null}}
                                        </p>
                                        @if(!empty($company->email))
                                            <p class="line_height">Email: {{$company->email}}</p>
                                        @endif
                                        @if(!empty($company->website))
                                            <p class="line_height">Website: {{$company->website}}</p>
                                        @endif
                                    </div>
                                </div>
                                <!--end this row is for mark_sheet header -->
                                <div class="row">
                                    <div class="col-xs-12">
                                        <h4 class="text-center font_bold">
                                            Mark Sheet - {{$student->session_name}}
                                        </h4>
                                    </div>
                                </div>

                                <div class="row">
                                    <div class="col-xs-7">
                                        <table class="table-bordered student_information value" width="100%"
                                               id="student_information">
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Student Id</td>
                                                <td class="font_bold">
                                                    {{ $student->student_id_no ?? null }}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Class Roll</td>
                                                <td class="font_bold">
                                                    {{ $student->roll_no ?? null }}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Name</td>
                                                <td class="font_bold">
                                                    {{ $student->name ?? null }}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Class</td>
                                                <td class="font_bold">
                                                    {{ $student->semester_class_name ?? null }}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Section</td>
                                                <td class="font_bold">
                                                    {{ $student->section_name ?? null }}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td class="text-left font_bold" width="20%">Group</td>
                                                <td class="font_bold">
                                                    {{ $student->semester_class_group_name ?? null }}
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                    <div class="col-xs-5">
                                        <table class="text-center table-bordered value grade_description"
                                               width="100%"
                                               id="grade_description">
                                            <tr>
                                                <td class="font_bold">Marks Interval</td>
                                                <td class="font_bold">Letter Grade</td>
                                                <td class="font_bold">Grade Point</td>
                                                <td class="font_bold">Grade Assessment</td>
                                            </tr>
                                            @foreach($grades as $grade)
                                                <tr>
                                                    <td>
                                                        {{ $grade->min_number }} - {{ $grade->max_number }}
                                                    </td>
                                                    <td>
                                                        {{ $grade->name }}
                                                    </td>
                                                    <td>
                                                        {{ $grade->grade_point }}
                                                    </td>
                                                    <td>
                                                        {{ $grade->grade_assessment }}
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </table>
                                    </div>
                                </div>

                                <div class="row" style="margin-top: 3px">
                                    <div class="col-xs-12 table-responsive">

                                        <table class="text-center table table-bordered value" width="100%">
                                            <thead>
                                            <tr>
                                                <td rowspan="3" class="font_bold v_align" style="text-align: center;">
                                                    Sl
                                                </td>
                                                <td rowspan="3" class="font_bold v_align text-nowrap">
                                                    Subject
                                                </td>
                                                @foreach($studentAcademicExamResults as $studentAcademicExamResult)
                                                    @php
                                                        $academicExam = $academicExams->where('id', $studentAcademicExamResult->academic_exam_id)->first();
                                                    @endphp
                                                    <td colspan="{{$examConfigs->count() + 7}}" class="font_bold">
                                                        {{$academicExam->name}}
                                                    </td>

                                                @endforeach
                                            </tr>
                                            <tr>
                                                @foreach($studentAcademicExamResults as $studentAcademicExamResult)
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Full Mark
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Theory
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Practical
                                                    </td>
                                                    <td colspan="{{$examConfigs->count()}}"
                                                        class="font_bold v_align">
                                                        Marks
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Total Mark
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Highest Mark
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align">
                                                        Grade
                                                    </td>
                                                    <td rowspan="2" class="font_bold v_align" style="width: 3%">
                                                        G.P
                                                    </td>
                                                @endforeach
                                            </tr>
                                            <tr>
                                                @foreach($studentAcademicExamResults as $studentAcademicExamResult)
                                                    @foreach($examConfigs as $examConfig)
                                                        <td class="font_bold">
                                                            {{ $examConfig->short_name }}
                                                        </td>
                                                    @endforeach
                                                @endforeach
                                            </tr>
                                            </thead>
                                            <tbody>
                                            @php
                                                $iteration = 1;
                                            @endphp
                                            @foreach($student->mandatory_course_subjects as $mandatoryCourseSubject)
                                                <tr>
                                                    <td width="2%">
                                                        {{ $iteration++ }}
                                                    </td>
                                                    <td style="text-align: left !important;"
                                                        class="text-left s_name text-nowrap">
                                                        {{ $mandatoryCourseSubject->course_subject_code }}
                                                        -
                                                        {{ $mandatoryCourseSubject->name }}
                                                    </td>
                                                    @foreach($studentAcademicExamResults as $studentAcademicExamResult)
                                                        @php
                                                            $academicExam = $academicExams->where('id', $studentAcademicExamResult->academic_exam_id)->first();

                                                            $studentAcademicExamMark = $studentAcademicExamMarks
                                                            ->where('course_subject_id', $mandatoryCourseSubject->id)
                                                            ->where('academic_exam_id' ,$studentAcademicExamResult->academic_exam_id)->first();

                                                            $academicExamSubjectWiseResult = $studentAcademicExamResult->eims_academic_exam_subject_wise_result->where('course_subject_id', $mandatoryCourseSubject->id)->first();
                                                        @endphp

                                                        <td>
                                                            {{$academicExam->eims_exam_subject_marks_config_details->where('course_subject_id', $mandatoryCourseSubject->id)->first()->max_mark ?? null}}
                                                        </td>
                                                        <td>
                                                            {{ isset($studentAcademicExamMark->theory_marks) && $studentAcademicExamMark->theory_marks != 0 ? round($studentAcademicExamMark->theory_marks)  : '-' }}
                                                        </td>
                                                        <td>
                                                            {{ isset($studentAcademicExamMark->practical_marks) && $studentAcademicExamMark->practical_marks != 0 ? round($studentAcademicExamMark->practical_marks) : '-' }}
                                                        </td>
                                                        @foreach($examConfigs as $examConfig)
                                                            <td>
                                                                {{isset($studentAcademicExamMark->marks[$examConfig->id]) ? round($studentAcademicExamMark->marks[$examConfig->id])  : '-' }}
                                                            </td>
                                                        @endforeach
                                                        <td>
                                                            {{isset($academicExamSubjectWiseResult->total_mark) ? round($academicExamSubjectWiseResult->total_mark): '-' }}
                                                        </td>
                                                        <td>
                                                            {{isset($academicExamSubjectWiseResult->height_mark) ? round($academicExamSubjectWiseResult->height_mark) : '-'}}
                                                        </td>
                                                        <td>
                                                            {{$academicExamSubjectWiseResult->letter_grade ?? '-'}}
                                                        </td>
                                                        <td>
                                                            {{is_numeric($academicExamSubjectWiseResult->grade_point) && ($academicExamSubjectWiseResult->grade_point != 0)  ? (fmod($academicExamSubjectWiseResult->grade_point, 1) !== 0.00 ? number_format($academicExamSubjectWiseResult->grade_point, 2) : intval($academicExamSubjectWiseResult->grade_point)) : '-' }}
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach

                                            <tr style="font-weight: bold; color: #0c0c0c !important;">
                                                <td style=" text-align: left !important;" colspan="5">
                                                    <small class="text-left">
                                                        Total Marks & Total GP Without Optional
                                                    </small>
                                                </td>
                                                @foreach($studentAcademicExamResults as $key => $studentAcademicExamResult)
                                                    @if($key == 0)
                                                        <td colspan="{{$examConfigs->count()}}"></td>
                                                    @else
                                                        <td colspan="{{$examConfigs->count()+3}}"></td>
                                                    @endif
                                                    <td>{{ isset($studentAcademicExamResult->total_mark_without_optional) ? round($studentAcademicExamResult->total_mark_without_optional) : '-' }}</td>
                                                    <td colspan="2"></td>
                                                    <td>
                                                        {{is_numeric($studentAcademicExamResult->grade_point_without_optional) && ($studentAcademicExamResult->grade_point_without_optional != 0)  ? (fmod($studentAcademicExamResult->grade_point_without_optional, 1) !== 0.00 ? number_format($studentAcademicExamResult->grade_point_without_optional, 2) : intval($studentAcademicExamResult->grade_point_without_optional)) : '-' }}
                                                    </td>

                                                @endforeach
                                            </tr>
                                            @foreach($student->optional_course_subjects as $optionalCourseSubject)
                                                <tr>
                                                    <td>
                                                        {{ $iteration++ }}
                                                    </td>
                                                    <td style="text-align: left !important;"
                                                        class="text-left s_name">
                                                        {{ $optionalCourseSubject->course_subject_code }}
                                                        -
                                                        {{ $optionalCourseSubject->name }}
                                                    </td>
                                                    @foreach($studentAcademicExamResults as $studentAcademicExamResult)
                                                        @php
                                                            $academicExam = $academicExams->where('id', $studentAcademicExamResult->academic_exam_id)->first();

                                                            $studentAcademicExamMark = $studentAcademicExamMarks
                                                            ->where('course_subject_id', $optionalCourseSubject->id)
                                                            ->where('academic_exam_id' ,$studentAcademicExamResult->academic_exam_id)->first();

                                                            $academicExamSubjectWiseResult = $studentAcademicExamResult->eims_academic_exam_subject_wise_result->where('course_subject_id', $optionalCourseSubject->id)->first();
                                                        @endphp

                                                        <td>
                                                            {{$academicExam->eims_exam_subject_marks_config_details->where('course_subject_id', $optionalCourseSubject->id)->first()->max_mark ?? null}}
                                                        </td>
                                                        <td>
                                                            {{ isset($studentAcademicExamMark->theory_marks) && $studentAcademicExamMark->theory_marks != 0 ? round($studentAcademicExamMark->theory_marks)  : '-' }}
                                                        </td>
                                                        <td>
                                                            {{ isset($studentAcademicExamMark->practical_marks) && $studentAcademicExamMark->practical_marks != 0 ? round($studentAcademicExamMark->practical_marks) : '-' }}
                                                        </td>
                                                        @foreach($examConfigs as $examConfig)
                                                            <td>
                                                                {{ $studentAcademicExamMark->marks[$examConfig->id] ?? '-' }}
                                                            </td>
                                                        @endforeach
                                                        <td>
                                                            {{isset($academicExamSubjectWiseResult->total_mark) ? round($academicExamSubjectWiseResult->total_mark): '-' }}
                                                        </td>
                                                        <td>
                                                            {{isset($academicExamSubjectWiseResult->height_mark) ? round($academicExamSubjectWiseResult->height_mark) : '-'}}
                                                        </td>
                                                        <td>
                                                            {{$academicExamSubjectWiseResult->letter_grade ?? '-'}}
                                                        </td>
                                                        <td>
                                                            {{is_numeric($academicExamSubjectWiseResult->grade_point) && ($academicExamSubjectWiseResult->grade_point != 0)  ? (fmod($academicExamSubjectWiseResult->grade_point, 1) !== 0.00 ? number_format($academicExamSubjectWiseResult->grade_point, 2) : intval($academicExamSubjectWiseResult->grade_point)) : '-' }}
                                                        </td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                            <tr style="font-weight: bold; color: #0c0c0c !important;">
                                                <td style=" text-align: left !important;" colspan="5">
                                                    <small class="">Total Marks & Total GP</small>
                                                </td>
                                                @foreach($studentAcademicExamResults as $key => $studentAcademicExamResult)
                                                    @if($key == 0)
                                                        <td colspan="{{$examConfigs->count()}}"></td>
                                                    @else
                                                        <td colspan="{{$examConfigs->count()+3}}"></td>
                                                    @endif
                                                    <td>{{ isset($studentAcademicExamResult->total_mark) ? round($studentAcademicExamResult->total_mark) : '-' }}</td>
                                                    <td colspan="2"></td>
                                                    <td>
                                                        {{is_numeric($studentAcademicExamResult->grade_point) && ($studentAcademicExamResult->grade_point != 0)  ? (fmod($studentAcademicExamResult->grade_point, 1) !== 0.00 ? number_format($studentAcademicExamResult->grade_point, 2) : intval($studentAcademicExamResult->grade_point)) : '-' }}
                                                    </td>
                                                @endforeach
                                            </tr>
                                            </tbody>
                                        </table>
                                        @php
                                            $grade = EimsService::calculateGrade($studentAcademicExamResults->avg('subjects_average_total_mark'), $grades);
                                        @endphp
                                        <table class="table table-bordered value summary"
                                               style="width: 100%; margin-top: 1px;" id="summary">
                                            <tr>
                                                <td width="15%">
                                                    <span class="font_bold">Grade Point Average</span>
                                                </td>
                                                <td class="text-center">
                                                    <span class="font_bold">
                                                    {{ is_numeric($grade->grade_point) && ($grade->grade_point != 0)  ? (fmod($grade->grade_point, 1) !== 0.00 ? number_format($grade->grade_point, 2) : intval($grade->grade_point)) : '-' }}
                                                </span>
                                                </td>
                                                <td colspan="2" class="text-center v_align">
                                                    <span class="font_bold">Position Of Merit List</span>
                                                </td>
                                                <td colspan="2" class="text-center v_align">
                                                    <span class="font_bold">Attendance</span>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Letter grade
                                                </td>
                                                <td class="text-center">
                                                    <span class="font_bold">{{$grade->name ?? '-'}}</span>
                                                </td>
                                                <td>
                                                    Section
                                                </td>
                                                <td>
                                                    {{ intval($studentAcademicExamResults->avg('section_position'))   ?? '-'}}
                                                    out of {{$student->section_students_count ?? '-'}}
                                                </td>
                                                <td>
                                                    Working Days
                                                </td>
                                                <td class="text-center">
                                                    {{ $studentAcademicExamResults->sum('working_days') != 0 ? $studentAcademicExamResults->sum('working_days') : '-'}}
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Average Total Marks
                                                </td>
                                                <td class="text-center">
                                                    <span class="font_bold">
                                                        {{ number_format($studentAcademicExamResults->avg('subjects_average_total_mark'), 2) ?? '-'}} </span>
                                                    </span>
                                                </td>
                                                <td>
                                                    Class
                                                </td>
                                                <td>
                                                    {{intval($studentAcademicExamResults->avg('class_position')) ?? '-'}}
                                                    out
                                                    of {{$student->class_semester_students_count ?? '-'}}
                                                </td>
                                                <td>
                                                    Present Days
                                                </td>
                                                <td class="text-center" width="10%">
                                                    {{ $studentAcademicExamResults->sum('present_days') != 0 ? $studentAcademicExamResults->sum('present_days') : '-'}}
                                                </td>
                                            </tr>
                                        </table>

                                        <table class="remarks value" style="width: 100%; margin-top: 2px;" id="remarks">
                                            <tr>
                                                <td>
                                                    Remarks :
                                                </td>
                                                <td colspan="4">
                                                    <span class="font_bold"></span>
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Behaviour :
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('behavior_status')) == AcademicExamResultBehaviorStatus::EXCELLENT)>
                                                    Excellent
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('behavior_status')) == AcademicExamResultBehaviorStatus::VERY_GOOD)>
                                                    Very Good
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('behavior_status')) == AcademicExamResultBehaviorStatus::GOOD)>
                                                    Good
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('behavior_status')) == AcademicExamResultBehaviorStatus::NEEDS_IMPROVEMENT)>
                                                    Need Improvement
                                                </td>
                                            </tr>
                                            <tr>
                                                <td>
                                                    Co-Curricular Activities :
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('co_curricular_activity_status')) == AcademicExamResultCoCurricularActivityStatus::EXCELLENT)>
                                                    Excellent
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('co_curricular_activity_status')) == AcademicExamResultCoCurricularActivityStatus::VERY_GOOD)>
                                                    Very Good
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('co_curricular_activity_status')) == AcademicExamResultCoCurricularActivityStatus::GOOD)>
                                                    Good
                                                </td>
                                                <td>
                                                    <input type="checkbox" class="custom_box" disabled
                                                        @checked(intval($studentAcademicExamResults->avg('co_curricular_activity_status')) == AcademicExamResultCoCurricularActivityStatus::NEEDS_IMPROVEMENT)>
                                                    Need Improvement
                                                </td>
                                            </tr>
                                        </table>
                                    </div>
                                </div>

                                <div class="row" style="margin-top: 35px; color: #0c0c0c">
                                    <div class="col-xs-4 text-center">
                                        <div class="underline">
                                            <span class="" style="margin:0 auto;">Samia Sultana</span>
                                            <p class="font_bold" style="margin:0 auto;">
                                                <small>Class Teacher Signature</small>
                                            </p>
                                        </div>
                                    </div>
                                    <div class="col-xs-4 text-center">
                                        <div class="underline">
                                            <br>
                                            <span class="" style="margin:0 auto;"></span>
                                            <p class="font_bold" style="margin:0 auto;">
                                                <small>Cord/VP/AHM</small>
                                            </p>
                                        </div>
                                    </div>
                                    <div class="col-xs-4 text-center">
                                        <div class="underline">
                                            <span class="" style="margin:0 auto;">Tanvir Hossain</span>
                                            <p class="font_bold" style="margin:0 auto;">
                                                <small>Headmaster Signature</small>
                                            </p>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


    <script !src="">
        function PrintDiv() {
            const divToPrint = document.getElementById('print');
            const popupWin = window.open('', '_blank');
            popupWin.document.open();
            popupWin.document.write('<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><link href="{{asset('css/bootstrap.css')}}" rel="stylesheet"></head><body onload="window.print()">' + divToPrint.innerHTML + '</html>');
            popupWin.document.write('<style>.remarks tr>td, .table>tbody>tr>td, .table>tbody>tr>th, .table>tfoot>tr>td, .table>tfoot>tr>th, .table>thead>tr>td, .table>thead>tr>th {\n' + ' padding: 1px !important;\n' + ' }\n' + '.remarks, .table-bordered>tbody>tr>td, .table-bordered>tbody>tr>th, .table-bordered>tfoot>tr>td, .table-bordered>tfoot>tr>th, .table-bordered>thead>tr>td, .table-bordered>thead>tr>th {\n' + ' border: 1px solid #000 !important;\n' + ' }\n' + '.remarks, #summary, #optional_subject {\n' + ' margin-top: -15px !important;\n' + ' }\n' + '.value{\n' + ' font-size: 9px !important;\n' + ' }\n' + '.s_name{\n' + ' font-size: 9px !important; white-space: nowrap !important;\n' + ' }\n' + '.custom_box{\n' + ' height: 15px;width: 15;border: 1px solid black;\n' + ' }\n' + '.student_information tr>td{\n' + ' padding: 2px !important;\n' + ' border: 1px solid #000 !important;\n' + ' }\n' + '.grade_description tr>td{\n' + ' padding: 0 !important;\n' + ' border: 1px solid #000 !important;\n' + ' }\n' + '.line_height{\n' + ' line-height: 0.60;\n' + ' }\n' + '.fail{\n' + ' border-bottom: 2px solid red !important;\n' + ' }\n' + '.underline{\n' + ' padding: 0px;display: inline-block;border-top: 1px solid #000000;\n' + ' }\n' + '#mandatory_subject {\n' + ' margin-top: 10px !important;\n' + ' }\n' + '.font_bold {\n' + ' font-weight: bold !important;\n' + ' }\n' + '.v_align{\n' + ' vertical-align: middle !important;\n' + ".text-nowrap { white-space: nowrap !important; }" + ' }</style>');
            popupWin.document.close();
        }
    </script>
@endsection