@extends('index')
@section('content')

    <form id="card-search" class="card mt-3" method="POST" action="/score/search" autocomplete="off">
        {{ csrf_field() }}
        <div class="card-body">
            <div class="row"> 
                <div class="form-group col-md-3">
                    <label>Tahun Ajaran</label>
                    <div class="input-group mb-2">
                        <select class="form-control" name="year" id="year" required>
                            <option value="">Pilih</option>
                            @foreach($year as $rows)
                                <option value="{{ $rows->id }}"  @if(session('s_year') == $rows->id) selected @endif>{{ $rows->name }}</option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="form-group col-md-3">
                    <label>Kelas</label>
                    <div class="input-group mb-3">
                        <select class="form-control" name="classroom" id="classroom" required>
                            <option value="">Pilih</option>
                            @if(session('s_search_status'))
                                @foreach($classroom as $rows)
                                    @if(Auth::user()->type == 2)
                                    @if(App\LessonDetail::where('active',1)->where('classroom_id',$rows->id)->where('user_id',Auth::id())->count())
                                    <option value="{{ $rows->id }}" @if(session('s_classroom') == $rows->id) selected @endif>{{ $rows->name }}</option>
                                    @endif
                                @else
                                    <option value="{{ $rows->id }}" @if(session('s_classroom') == $rows->id) selected @endif>{{ $rows->name }}</option>
                                @endif
                                @endforeach
                            @endif
                        </select>
                    </div>
                </div>

                <div class="form-group col-md-3">
                    <label>Semester</label>
                    <div class="input-group mb-2">
                        <select class="form-control" name="semester" id="semester">
                            <option value="1" @if(session('s_semester') == 1) selected @endif>Mid Semester 1</option>
                            <option value="2" @if(session('s_semester') == 2) selected @endif>Semester 1</option>
                            <option value="3" @if(session('s_semester') == 3) selected @endif>Mid Semester 2</option>
                            <option value="4" @if(session('s_semester') == 4) selected @endif>Semester 2</option>
                        </select>
                    </div>
                </div>

                <div class="form-group col-md-3">
                    <label>Mata Pelajaran</label>
                    <div class="input-group mb-2">
                        <select class="form-control" name="lesson" id="lesson" required>
                            <option value="">Pilih</option>
                            @if(session('s_search_status'))
                                @foreach($lesson as $rows)
                                    <option value="{{ $rows->lesson->id }}" @if(session('s_lesson') == $rows->lesson->id) selected @endif>{{ $rows->lesson->name }}</option>
                                @endforeach
                            @endif
                        </select>
                    </div>
                </div>

                <div class="form-group col-md-9">
                    <label for="search">Nama Siswa/NISN</label>
                    <input type="text" class="form-control" name="search" placeholder="Nama Siswa/NISN" value="{{ session('s_search') }}">
                </div>

                <div class="form-group col-md-3">
                    <label></label>
                    <button type="submit" class="btn btn-primary float-right" style="padding-top:3px;padding-bottom:3px;margin-top:30px"><i class="fe fe-search"></i> Cari</button>
                </div>
            </div>
        </div>
    </form>

    @if(session('s_search_status'))
    <div class="card mt-3 font-purple">
        <table class="table card-table table-title pt-3">
            <tr class="no-background">
                <td width="150px" class="text-left">Kelas</td>
                <td width="10px">:</td>
                <td class="text-left"><strong>{{ $class->name }}</strong> <small>{{ $class->year }}</small></td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Semester</td>
                <td width="10px">:</td>
                <td class="text-left">{{ semester(session('s_semester')) }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Wali Kelas</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $class->wali->getName() }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Guru Pengajar</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $lessonselect->user->getName() }}</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">Tatap Muka</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $presence }} Kali</td>
            </tr>
            <tr class="no-background">
                <td width="150px" class="text-left">KKM</td>
                <td width="10px">:</td>
                <td class="text-left">{{ $lessonselect->kkm }}</td>
            </tr>
        </table>
    </div>

    <form class="card mt-3" method="POST" action="/score/update" autocomplete="off">
        {{ csrf_field() }}
        <input name="_method" type="hidden" value="PUT">
        <!-- <div class="card-body font-purple">
            <h2 class="card-title pb-3"><strong>{{ $class->name }}</strong> <small>{{ $class->year }}</small></h2>
            <h5 class="card-subtitle">Guru Pengajar: {{ $class->wali->name }}</h5>
            <h5 class="card-subtitle mt-2">KKM: {{ $lessonselect->kkm }}</h5>
        </div> -->
        <div class="tb-major card-body text-center" style="overflow:scroll;">
            @if(count($row))
                <table class="table card-table" style="width:1150px;">
                    <thead>
                        <tr>
                        <th scope="col">No</th>
                        <th scope="col">Nama Siswa</th>
                        <th scope="col">NIS</th>
                        <th scope="col" class="font-10" width="80px">Nilai Rata-Rata Harian</th>
                        <th scope="col" class="font-10" width="80px">Nilai Ujian</th>
                        <th scope="col" class="font-10" width="80px">Nilai Pengetahuan (KI 3)</th>
                        <th scope="col" class="font-10" width="80px">Predikat Pengetahuan (KI 3)</th>
                        <th scope="col" class="font-10" width="80px">Nilai Keterampilan (KI 2)</th>
                        <th scope="col" class="font-10" width="80px">Predikat Keterampilan (KI 2)</th>
                        <th scope="col" class="font-10" width="80px">Nilai Sikap (KI 1 & KI 2)</th>
                        <th scope="col" class="font-10" width="80px">Predikat Sikap (KI 2)</th>
                        </tr>
                    </thead>
                    <tbody>
                        @php $i = 1; @endphp
                        @foreach($row as $rows)
                        @php 
                        if(session('s_semester') == 1 OR session('s_semester') == 3) {
                            $minkkm = 0;
                        } else {
                            /* $minkkm = $lessonselect->kkm; */
                            $minkkm = 0;
                        }
                        @endphp
                        <tr class="no-background">
                            <td class="bg-full-radius">
                                {{ $i }}
                            </td>
                            <td class="bg-left-radius">
                                {{ $rows->name }}
                            </td>
                            <td class="bg-right-radius">
                                {{ $rows->code }}
                            </td>
                            <td class="bg-left-radius">
                                <input type="number" min="{{ $minkkm }}" max="100" style="width:70px;" class="form-control text-center" name="average_score{{ $rows->id }}" onchange="countKnowledgeScore({{ $rows->id }})" onkeyup="countKnowledgeScore({{ $rows->id }})" value="{{ $rows->average_score }}">
                            </td>
                            <td class="bg-right-radius">
                                <input type="number" min="{{ $minkkm }}" max="100" style="width:70px;" class="form-control text-center" name="test_score{{ $rows->id }}" onchange="countKnowledgeScore({{ $rows->id }})" onkeyup="countKnowledgeScore({{ $rows->id }})" value="{{ $rows->test_score }}">
                            </td>
                            <td class="bg-left-radius font-weight-bold" id="knowledge_score{{ $rows->id }}">
                                {{ $rows->knowledge_score }}
                            </td>
                            <td class="bg-right-radius font-weight-bold" id="knowledge_ranking{{ $rows->id }}">
                                {{ $rows->knowledge_ranking }}
                            </td>
                            <td class="bg-left-radius">
                                <input type="number" min="{{ $minkkm }}" max="100" style="width:70px;" class="form-control text-center" name="skill_score{{ $rows->id }}" onchange="checkSkill({{ $rows->id }})" onkeyup="checkSkill({{ $rows->id }})" value="{{ $rows->skill_score }}">
                            </td>
                            <td class="bg-right-radius font-weight-bold" id="skill_ranking{{ $rows->id }}">
                                {{ $rows->skill_ranking }}
                            </td>
                            <td class="bg-left-radius">
                                <input type="number" min="{{ $minkkm }}" max="100" style="width:70px;" class="form-control text-center" name="attitude_score{{ $rows->id }}" onchange="checkAttitude({{ $rows->id }})" onkeyup="checkAttitude({{ $rows->id }})" value="{{ $rows->attitude_score }}">
                            </td>
                            <td  class="bg-right-radius font-weight-bold" id="attitude_ranking{{ $rows->id }}">
                                {{ $rows->attitude_ranking }}
                            </td>
                            <input type="hidden" min="1" max="100" style="width:70px;" class="form-control text-center" name="knowledge_score{{ $rows->id }}" value="{{ $rows->knowledge_score }}">
                            <input type="hidden" maxlength="2" style="width:70px;text-transform: uppercase;" class="form-control text-center" name="knowledge_ranking{{ $rows->id }}" value="{{ $rows->knowledge_ranking }}">
                            <input type="hidden" maxlength="2" style="width:70px;text-transform: uppercase;" class="form-control text-center" name="skill_ranking{{ $rows->id }}" value="{{ $rows->skill_ranking }}">
                            <input type="hidden" maxlength="2" style="width:70px;text-transform: uppercase;" class="form-control text-center" name="attitude_ranking{{ $rows->id }}" value="{{ $rows->attitude_ranking }}">
                        </tr>
                        @php $i++; @endphp
                        @endforeach
                    </tbody>
                </table>
            @else 
            <p>Tidak ada data siswa untuk kelas {{ $class->name }} tahun ajaran {{ $class->year }}</a>
            @endif
        </div>
        @if(count($row))
        <div class="card-footer">
            <button type="submit" class="btn btn-primary float-right"><i class="fe fe-save"></i> Proses</button>
            <a href="/score/search" class="btn btn-light float-right mr-2">Kembali</a>
        </div>
        @endif
    </form>
    @endif
    
@endsection
@push('script')
<script type="text/javascript">

    $('#year').on('change', function(e) {
        $.fn.loadClass($(this).val());
    });

    $('#classroom').on('change', function(e) {
        $.fn.loadLesson($(this).val());
    });

    $.fn.loadClass = function(id = null) {
        $.ajax({
            type: "POST",
            trigger: 'manual',
            cache: false,
            url: "/classroom/select/ajax",
            data: {
                id: id
            },
            dataType: "html",
            beforeSend: function() {
                $('#classroom').html('<option value="">Loading...</option>');
            },
            complete: function() {},
            success: function(html) {
                $('#lesson').html('<option value="">Pilih</option>');
                $('#classroom').html('<option value="">Pilih</option>');
                $('#classroom').append(html);
            }
        });
    }

    $.fn.loadLesson = function(id = null) {
        $.ajax({
            type: "POST",
            trigger: 'manual',
            cache: false,
            url: "/lesson/select/ajax",
            data: {
                id: id
            },
            dataType: "html",
            beforeSend: function() {
                $('#lesson').html('<option value="">Loading...</option>');
            },
            complete: function() {},
            success: function(html) {
                $('#lesson').html('<option value="">Pilih</option>');
                $('#lesson').append(html);
            }
        });
    }

    function countKnowledgeScore(id){
        var average = $("input[name*='average_score"+id+"']").val();
        var test = $("input[name*='test_score"+id+"']").val();

        //if(average && test) {
            var knowledge = Math.ceil((average * 0.7) + (test * 0.3));
            var ranking = this.checkRanking(knowledge);
            $("input[name*='knowledge_score"+id+"']").val(knowledge);
            $("input[name*='knowledge_ranking"+id+"']").val(ranking);
            $("#knowledge_score"+id).html(knowledge);
            $("#knowledge_ranking"+id).html(ranking);
        //}
    }

    function checkSkill(id){
        var score = $("input[name*='skill_score"+id+"']").val();
        var ranking = this.checkRanking(score);
        $("input[name*='skill_ranking"+id+"']").val(ranking);
        $("#skill_ranking"+id).html(ranking);
    }

    function checkAttitude(id){
        var score = $("input[name*='attitude_score"+id+"']").val();
        var ranking = this.checkAttitudeRanking(score);
        $("input[name*='attitude_ranking"+id+"']").val(ranking);
        $("#attitude_ranking"+id).html(ranking);
    }

    function checkRanking(score){
        //if(score) {
            if(score >= 95 && score <= 100) {
                return 'A';
            } else if(score >= 90 && score <= 94) {
                return 'A-';
            } else if(score >= 85 && score <= 89) {
                return 'B+';
            } else if(score >= 80 && score <= 84) {
                return 'B';
            } else if(score >= 75 && score <= 79) {
                return 'B-';
            } else if(score >= 70 && score <= 74) {
                return 'C+';
            } else if(score >= 65 && score <= 69) {
                return 'C';
            } else if(score >= 60 && score <= 64) {
                return 'C-';
            } else if(score >= 55 && score <= 59) {
                return 'D+';
            } else if(score >= 0 && score <= 54) {
                return 'D';
            } else {
                return '-';
            }
        //}
    }

    function checkAttitudeRanking(score){
        //if(score) {
            if(score >= 95 && score <= 100) {
                return 'SB';
            } else if(score >= 90 && score <= 94) {
                return 'SB';
            } else if(score >= 85 && score <= 89) {
                return 'B';
            } else if(score >= 80 && score <= 84) {
                return 'B';
            } else if(score >= 75 && score <= 79) {
                return 'B';
            } else if(score >= 70 && score <= 74) {
                return 'C';
            } else if(score >= 65 && score <= 69) {
                return 'C';
            } else if(score >= 60 && score <= 64) {
                return 'C';
            } else if(score >= 55 && score <= 59) {
                return 'K';
            } else if(score >= 0 && score <= 54) {
                return 'K';
            } else {
                return '-';
            }
        //}
    }
</script>
@endpush