@extends('backEnd.master')
@section('title')
@lang('reports.result_archive')
@endsection
@section('mainContent')
    <style type="text/css">
        .single-report-admit table tr th {
            border: 1px solid #a2a8c5 !important;
            vertical-align: middle;
            text-align: center !important;
        }

        .single-report-admit table tr td {
            border: 1px solid #a2a8c5 !important;
            text-align: center !important;
        }

        .transcript-heading {
            border: 1px solid #a2a8c5;
            padding: 5px;
        }
    </style>
    <section class="sms-breadcrumb mb-20">
        <div class="container-fluid">
            <div class="row justify-content-between">
                <h1>@lang('reports.result_archive') </h1>
                <div class="bc-pages">
                    <a href="{{route('dashboard')}}">@lang('common.dashboard')</a>
                    <a href="#">@lang('reports.reports')</a>
                    <a href="{{route('results-archive')}}">@lang('reports.result_archive')</a>
                </div>
            </div>
        </div>
    </section>
    <section class="admin-visitor-area">
        <div class="container-fluid p-0">
            <div class="row">
                <div class="col-lg-4 col-md-6">
                    <div class="main-title">
                        <h3 class="mb-30">@lang('common.select_criteria') </h3>
                    </div>
                </div>
            </div>
        </div>
        <div class="row">
            <div class="col-lg-12"> 
                <div class="white-box">
                    {{ Form::open(['class' => 'form-horizontal', 'files' => true, 'route' => 'previous-class-results-view', 'method' => 'POST', 'enctype' => 'multipart/form-data', 'id' => 'search_student']) }}
                        <div class="row"> 
                            <input type="hidden" name="url" id="url" value="{{URL::to('/')}}"> 
                            <div class="col-lg-9 col-xl-10 col-md-8 col-sm-8"> 
                                <div class="primary_input">
                                    <input class="primary_input_field {{ $errors->has('admission_number') ? ' is-invalid' : '' }}" type="text" name="admission_number" value="{{ isset($admission_number)? $admission_number: old('admission_number')}}" >
                                    <label class="primary_input_label" for="">@lang('student.admission_number')</label>
                                    

                                        @if($errors->has('admission_number'))
                                            <span class="text-danger validate-textarea-checkbox" role="alert">
                                                {{ $errors->first('admission_number') }}
                                            </span>
                                        @endif 
                                        @if(session()->has('message-danger'))
                                            <span class="text-danger validate-textarea-checkbox" role="alert">
                                                <strong>{{ session()->get('message-danger') }}
                                            </span>
                                        @endif

                                </div>
                            </div> 
                            <div class="col-lg-3 col-xl-2 text-right col-md-4 col-sm-4">
                                <button type="submit" class="primary-btn small fix-gr-bg">
                                    <span class="ti-search pr-2"></span>
                                    @lang('common.search') 
                                </button>
                            </div>
                        </div>
                    {{ Form::close() }}


                    
                </div>
            </div>
        </div>
        {{-- after search data  --}}
        @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_print',$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>
                                                    <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> 
                                                <img class="report-admit-img" src="{{asset($studentDetails->student_photo)}}" width="100" height="100" alt="">
                                            </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_none')
                                                                :</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>smleave

                                                        <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 class="col-lg-4">
                                                        <strong>@lang('reports.transcript_none'):</strong> {{ $studentDetails->admission_number }}<br>
                                                        <strong>@lang('common.academic_year'): </strong> {{ App\YearCheck::getYear() }}<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>

                                                        @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>
                                            
                                    @endif
                                    </div>
                    @endforeach
                                </div>
            </div>
        </div>
    </div>
        @endif
</section> 

@endsection('mainContent')