@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 id="s_year" 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 id="s_classroom" value="{{ $rows->id }}"
                                                @if (session('s_classroom') == $rows->id) selected @endif>{{ $rows->name }}
                                            </option>
                                        @endif
                                    @else
                                        <option id="s_classroom" 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="">Pilih</option>
                        </select>
                        </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 id="s_lesson" 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>
                    @php
                    //semester(session('s_semester'))
                    $smtr = '';
                    $pisah = explode(' ', $class->name);
                    if ($pisah[0] == 'X') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 1';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 1';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 2';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 2';
                        }
                        //'<option value="1">Mid Semester 1</option><option value="2">Semester 1</option><option value="3">Mid Semester 2</option><option value="4">Semester 2</option>';
                    } elseif ($pisah[0] == 'XI') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 3';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 3';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 4';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 4';
                        }
                        //'<option value="1">Mid Semester 3</option><option value="2">Semester 3</option><option value="3">Mid Semester 4</option><option value="4">Semester 4</option>';
                    } elseif ($pisah[0] == 'XII') {
                        if (semester(session('s_semester')) === 'Mid Semester 1') {
                            $smtr = 'Mid Semester 5';
                        } elseif (semester(session('s_semester')) === 'Semester 1') {
                            $smtr = 'Semester 5';
                        } elseif (semester(session('s_semester')) === 'Mid Semester 2') {
                            $smtr = 'Mid Semester 6';
                        } elseif (semester(session('s_semester')) === 'Semester 2') {
                            $smtr = 'Semester 6';
                        }

                        //'<option value="1">Mid Semester 5</option><option value="2">Semester 5</option><option value="3">Mid Semester 6</option><option value="4">Semester 6</option>';
                    }
                @endphp
                    <td class="text-left">{{$smtr}}</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 method="POST" id="form" action="/score/delete" enctype="multipart/form-data" class="card mt-3">
            {{ csrf_field() }}
            <!-- <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> -->
            @if (Auth::user()->getType() !== 6)
                @if (count($row))
                    <div class="card-body">
                        <a href="/score/update" class="btn btn-sm btn-light float-right">Edit</a>
                    </div>
                @endif
            @endif
            <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>
                                @if (Auth::user()->getType() == 1)
                                    <th scope="col"><input id="checkAll" type="checkbox"></th>
                                @endif
                            </tr>
                        </thead>
                        <tbody>
                            @php $i = 1; @endphp
                            @foreach ($row as $rows)
                                <tr class="no-background">
                                    <td class="bg-full-radius">{{ $i }} {{$rows->id}}</td>
                                    <td class="bg-left-radius">{{ $rows->name }}</td>
                                    <td class="bg-right-radius">{{ $rows->code }}</td>
                                    <td class="bg-left-radius">{{ $rows->average_score }}</td>
                                    <td class="bg-right-radius">{{ $rows->test_score }}</td>
                                    <td class="bg-left-radius">{{ $rows->knowledge_score }}</td>
                                    <td class="bg-right-radius">{{ $rows->knowledge_ranking }}</td>
                                    <td class="bg-left-radius">{{ $rows->skill_score }}</td>
                                    <td class="bg-right-radius">{{ $rows->skill_ranking }}</td>
                                    <td class="bg-left-radius">{{ $rows->attitude_score }}</td>
                                    <td class="bg-right-radius">{{ $rows->attitude_ranking }}</td>
                                    @if (Auth::user()->getType() == 1)
                                        <td><input type="checkbox" value="{{ $rows->id }}" name="checked[]"></td>
                                    @endif
                                </tr>
                                @php $i++; @endphp
                            @endforeach
                        </tbody>
                    </table>
                    @if (Auth::user()->getType() == 1)
                        <button type="submit" class="btn btn-primary float-right"
                            style="padding-top:3px;padding-bottom:3px;"><i class="fe fe-trash"></i> Hapus</button>
                    @endif
                @else
                    <p>Belum ada data nilai</p>
                    @if (Auth::user()->getType() !== 6)
                        <a href="/score/create" class="btn btn-primary"><i class="fe fe-plus"></i> Input Nilai</a>
                        <a href="/score/export" class="btn btn-primary">Dwonload Template Excel {{ $class->name }}</a>
                        <a href="/score/bulk" data-toggle="modal" data-target="#modalImport"
                            class="btn btn-primary">Import
                            Template Excel</a>
                        <a href="/score/bulk" class="btn btn-primary"><i class="fe fe-upload"></i> Upload CSV</a>
                    @endif
                @endif
            </div>
        </form>
    @endif

    <!-- Modal Import Data Siswa -->
    <div class="modal fade" id="modalImport" tabindex="-1" role="dialog" aria-hidden="true">
        <div class="modal-dialog modal-lg">
            <div class="modal-content">
                <div class="modal-header">
                    <h5 class="modal-title" id="exampleModalLabel">Import Nilai Umum</h5>
                </div>
                <div class="modal-body">
                    <div class="card card-menu">
                        <div class="card-body">
                            <h2>Input Excel</h2>
                            <p>*Input dengan format .xlsx</p>
                            <form action="/score/import" method="post" enctype="multipart/form-data">
                                @csrf
                                <div class="custom-file">
                                    <input type="file" class="custom-file-input" name="import">
                                    <label class="custom-file-label">Pilih file...</label>
                                </div>
                                @if ($errors->has('import'))
                                    <p class="invalid-feedback">{{ $errors->first('import') }}</p>
                                @endif
                                <button class="btn btn-primary mt-3">Lanjut</button>
                            </form>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-light" data-dismiss="modal">Kembali</button>
                </div>
            </div>
        </div>
    </div>

@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());
        });

        $('#classroom').on('change', function(e) {
            $.fn.loadSemester($(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);
                }
            });
        }

        $.fn.loadSemester = function(id = null) {
            $.ajax({
                type: "POST",
                trigger: 'manual',
                cache: false,
                url: "/lesson/semester/ajax",
                data: {
                    id: id
                },
                dataType: "html",
                beforeSend: function() {
                    $('#semester').html('<option value="">Loading...</option>');
                },
                complete: function() {},
                success: function(html) {
                    $('#semester').html('<option value="">Pilih</option>');
                    $('#semester').append(html);
                }
            });
        }
        $("#checkAll").click(function() {
            $('input:checkbox').not(this).prop('checked', this.checked);
        });
    </script>
@endpush