@extends('backpack::layout')

@section('header')
    <section class="content-header">
        <h1>{{ __('base.marks.title') }}</h1>
        <ol class="breadcrumb">
            <li><a href="{{ backpack_url() }}">{{ config('backpack.base.project_name') }}</a></li>
            <li class="active">{{ __('base.marks.title') }}</li>
        </ol>
    </section>
@endsection


@section('content')
    <section class="content">
        @php

                //$status = \App\Models\Student::find(\Auth::id());
                if(!empty($status)){
                    $status_slug = $status->student_status_slug;
                } else {
                    $status_slug = 'active';
                }
        @endphp
        @if(!in_array($status_slug, ['suspend', 'deduct']))

            <div class="row m-t-20">
                <div class="col-md-12">
                    <div class="box box-solid">
                        <div class="box-body">
                            <span>{{ __('main.semesters') }}:</span>
                            <a href="{{ request()->url() }}" class="btn btn-default">{{ __('main.all_semesters') }}</a>
                            @if(!empty($semesters))
                                @foreach ($semesters as $key => $semester)
                                    <a class="btn btn-default" href="?semester={{ $key }}">{{ $semester }}</a>
                                @endforeach
                            @endif
                        </div>
                    </div>
                </div>

                @if(!empty($statements))
                    <div class="col-md-12">
                        <div class="box box-solid">
                            <div class="table-responsive">
                                <style>
                                    .table > thead:first-child > tr:first-child > th {
                                        border-top: 1px solid #777;
                                    }

                                    .rating > thead > tr > th {
                                        vertical-align: top;
                                    }

                                    .rating > thead > tr > th {
                                        background-color: #555;
                                        color: white;
                                        font-weight: bold;
                                        padding: 10px;
                                        font-size: 16px;
                                        font-weight: 300;
                                    }

                                    .rating > thead > tr > th {
                                        border: 1px solid #777;
                                    }

                                    .rating > tbody > tr > th {
                                        border: 1px solid #777;
                                    }

                                    .rating input {
                                        width: 100%;
                                        text-align: center;
                                    }
                                </style>
                                <table class="table table-striped table-hover table-bordered rating"
                                       style="margin-bottom: 0;">
                                    <thead>
                                   <tr>
                                        <th rowspan="2">{{ __('base.statement.students') }}</th>
                                        <th colspan="8">{{ __('base.midterm_assessment') }}</th>
                                        <th rowspan="3">{{ __('base.statement.summary_intermediate_marks') }}</th>
                                        <th rowspan="1">{{ __('base.statement.final_exam') }}</th>
                                        <th rowspan="3">{{ __('base.statement.additional_exam') }}</th>
                                        <th rowspan="3">{{ __('base.statement.summary_mark') }}</th>
                                        <th rowspan="3">{{ __('base.statement.final_mark') }}</th>
                                    </tr>
                                    <tr>
                                        <th colspan="7">I</th>
                                        <th>II</th>
                                        <th rowspan="2">III</th>
                                    </tr>
                                    <tr>
                                        <th></th>
                                        <th>{{ __('base.activity') }}</th>
                                        <th>{{ __('base.practical_skills') }}</th>
                                        <th>{{ __('base.duty') }}</th>
                                        <th>{{ __('base.presentation') }}</th>
                                        <th>{{ __('base.situational_task') }}</th>
                                        <th>{{ __('base.review_of_clinics_result') }}</th>
                                        <th>{{ __('base.other') }}</th>
                                        <th>{{ __('base.interim_exam') }}</th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    @foreach($statements as $statement)
                                        @php

                                            $student = $statement->students->where('id', auth()->user()->id)->first();
                                            
                                             $supervision = \Illuminate\Support\Facades\DB::table('supervisions')
                                            ->where('statement_id', $statement->id)
                                            ->where('student_id', $student->id)
                                            ->first();

                                            # $marsk = $marsk->pluck('value', 'mark_group.slug')->toArray();
                                            $marsk = $student->marks->where('statement_id', $statement->id)->pluck('value', 'mark_group.slug');

                                        @endphp
                                        @php
                                            $marsk = $student->marks->where('statement_id', $statement->id);
                                            $marsk = $marsk->pluck('value', 'mark_group.slug')->toArray();
                                            $intermediate_sum = $student->marks
                                                ->where('statement_id', $statement->id)
                                                ->where('mark_group_id','>=', 11)
                                                ->where('mark_group_id','<=', 25)
                                                ->pluck('value', 'mark_group.slug')
                                                ->sum();
                                            $disabled = function() use ($student){
                                                if( $student->student_status_slug != 'active' ){
                                                    echo 'disabled';
                                                }
                                            };
                                            $readonly = function() use ($student){
                                                if( $student->student_status_slug == 'suspend' ){
                                                    echo 'readonly ';
                                                    echo 'style="border-color: #ffc107; cursor: not-allowed;"';
                                                }
                                                if( $student->student_status_slug == 'deduct'){
                                                    echo 'readonly ';
                                                    echo 'style="border-color: #dc3545; cursor: not-allowed;"';
                                                }
                                            };
                                            $isSuspend = false;
                                            if($student->student_status_slug == 'suspend'){
                                                $isSuspend = true;
                                            }
                                            
                                            
                                            
                                            $grade = $marsk['total'] ?? 0;

                    $exam = $marsk['additional-exam'] ?? 0;
                    $final = $marsk['final-exam-iii'] ?? 0;
                    if($grade >= 91)
                        $grade = 'A';
                    elseif($grade <= 90 and $grade >= 81)
                        $grade = 'B';
                    elseif($grade <= 80 and $grade >= 71)
                        $grade = 'C';
                    elseif($grade <= 70 and $grade >= 61)
                        $grade = 'D';
                    elseif($grade <= 60 and $grade >= 51)
                        $grade = 'E';
                    elseif($grade == 0)
                        $grade = 'F';
                    elseif($grade < 51)
                        $grade = 'F';
                    if($final == 0 and $exam == 0)
                        $grade = 'F';
                    $final = intval($final);
                    $exam = intval($exam);
                    if(is_int($grade) and $grade < 51){
                        if($final > 0) $grade = 'FX';
                    }
                    $bool = false;
                    if($final < 20 && $final < $exam){
                        $final = $exam;
                        $bool = true;
                    }
                    
                    if($final < 20 and $final > 0){
                        $grade = 'FX';
                        if($bool){
                            $grade = 'F';
                        }
                    }
                    if($final < 20)
                        $final = $exam;
                    $ch = $marsk['total'] ?? '';
                    $bool = $final >= 20 && $ch >= 51;

                                        @endphp
                                        <tr data-semester="{{ $statement->semester }}">
                                            <td style="text-align: left; width: 15%;">{{ $statement->subject->name }}</td>
                                        <td class="student_list_td student_list_mark_td" style="text-align: center;">
                        {{ ($marsk['i'] ?? 0) + ($marsk['ii'] ?? 0) + ($marsk['iii'] ?? 0) + ($marsk['iv'] ?? 0) + ($marsk['v'] ?? 0) + ($marsk['vi'] ?? 0) + ($marsk['vii'] ?? 0) + ($marsk['viii'] ?? 0) + ($marsk['ix'] ?? 0) + ($marsk['x'] ?? 0) + ($marsk['xi'] ?? 0) + ($marsk['xii'] ?? 0) + ($marsk['xiii'] ?? 0) + ($marsk['xiv'] ?? 0) + ($marsk['xv'] ?? 0) }}
                    </td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->practical_skills ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->duty ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->presentation ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->situational_task ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->review_of_clinics_result ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $supervision->other ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $marsk['midterm-exam'] ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $marsk['midterm-assessment'] ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $marsk['final-exam-iii'] ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $marsk['additional-exam'] ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $marsk['total'] ?? '' }}</td>
                    <td class="student_list_td student_list_mark_td"
                        style="text-align: center;">{{ $grade ?? '' }}</td>
                                    @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                    @if(!empty($statements))
                        <div class="col-md-12">
                            <div class="box box-solid">
                                <div class="box-body justify-content-center">
                                    @if(!empty($statements->previousPageUrl()))
                                        <a class="btn btn-default" href="{{ $statements->previousPageUrl() }}">
                                            <i class="fa fa-angle-left"></i>
                                        </a>
                                    @endif
                                    @if($statements->currentPage() > 3)
                                        <a class="btn btn-default" href="{{ $statements->url(1) }}">1</a>
                                    @endif

                                    @if($statements->currentPage() > 4)
                                        <a>...</a>
                                    @endif

                                    @if($statements->currentPage() > 2)
                                        <a class="btn btn-default" href="{{ $statements->url($statements->currentPage() - 2) }}">
                                            {{ $statements->currentPage() - 2 }}
                                        </a>
                                    @endif

                                    @if(!empty($statements->previousPageUrl()))
                                        <a class="btn btn-default" href="{{ $statements->previousPageUrl() }}">
                                            {{ $statements->currentPage() - 1 }}
                                        </a>
                                    @endif
                                    <a class="btn btn-default" href="#" class="active">{{ $statements->currentPage() }}</a>
                                    @if($statements->hasMorePages())
                                        <a class="btn btn-default" href="{{ $statements->nextPageUrl() }}">
                                            {{ $statements->currentPage() + 1 }}
                                        </a>
                                    @endif

                                    @if(($statements->lastPage() - $statements->currentPage()) > 2)
                                        <a class="btn btn-default" href="{{ $statements->url($statements->currentPage() + 2) }}">
                                            {{ $statements->currentPage() + 2 }}
                                        </a>
                                    @endif
                                    @if(($statements->lastPage() - $statements->currentPage()) > 3)
                                        <a>...</a>
                                    @endif
                                    @if(!($statements->lastPage() == $statements->currentPage()) and ($statements->lastPage() - $statements->currentPage()) > 1)
                                        <a class="btn btn-default" href="{{ $statements->url($statements->lastPage()) }}">
                                            {{ $statements->lastPage() }}
                                        </a>
                                    @endif
                                    @if($statements->hasMorePages())
                                        <a class="btn btn-default" href="{{ $statements->nextPageUrl() }}">
                                            <i class="fa fa-angle-right"></i>
                                        </a>
                                    @endif
                                </div>
                            </div>
                        </div>
                    @endif

                    <div class="col-md-12">
                        <div class="box box-solid">
                            <div class="box-body">
                                <strong class="pull-right">GPA = <span>{{ $gpa }}</span></strong>
                            </div>
                        </div>
                    </div>
                @endif

            </div>
        @else
            <div class="row m-t-20">
                <div class="col-md-12">
                    <div class="box-body">
                        <div class="alert alert-danger alert-dismissible">
                            <button type="button" class="close" data-dismiss="alert" aria-hidden="true">×</button>
                            <h4><i class="icon fa fa-ban"></i> {{ __('student.title') }}!</h4>
                            {{ __('student.text') }}
                        </div>
                    </div>
                </div>
        @endif
    </section>
@endsection