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

    <form id="card-search" class="card mt-3" method="POST" action="/score/ukk/bulk" autocomplete="off" enctype="multipart/form-data">
        {{ csrf_field() }}
        <div class="card-body">
            <div class="row"> 
                <div class="form-group col-md-6">
                    <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-6">
                    <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-4">
                    <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-4">
                    <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->id }}" @if(session('s_lesson') == $rows->id) selected @endif>{{ $rows->name }}</option>
                                @endforeach
                            @endif
                        </select>
                    </div>
                </div> -->

                <div class="form-group col-md-9">
                    <label for="file">File Excel</label>
                    <div class="custom-file">
                        <input type="file" class="custom-file-input" name="csv" accept=".xlsx">
                        <label class="custom-file-label">Pilih file...</label>
                    </div>
                    <small>Contoh file bisa di download <a href="/score/ukk/excel" target="_blank">disini</a></small>
                </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"> Proses</button>
                </div>
            </div>
        </div>
    </form>
    
@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/transcript/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/transcript/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