@extends('layouts.app')

@section('content')
<div class="page-title">
    <div class="row">
        <div class="col-12 col-md-6 order-md-1 order-last">
            <h3>Data Raport Karyawan</h3>
            
        </div>
        <div class="col-12 col-md-6 order-md-2 order-first">
            <nav aria-label="breadcrumb" class="breadcrumb-header float-start float-lg-end">
                <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="index.html">Dashboard</a></li>
                    <li class="breadcrumb-item active" aria-current="page">Data Raport Karyawan</li>
                </ol>
            </nav>
        </div>
    </div>
</div>
<section class="section">
    <div class="card">
        <div class="card-header">
            Data Raport
            <div class="float-end">
            <button class="btn btn-success" onclick="exportQuiz()"><span class="bi bi-file">Eksport Data Quiz</span></button>
            <button class="btn btn-success" onclick="exportRaport()"><span class="bi bi-file">Eksport Data Raport</span></button>
            </div>
            <div class="clearfix"></div>
        </div>
        <div class="card-body" >
            <form>
            <div class="form-group row">
                <div class="col-md-3">
                    <label>Manager Area</label>
                    <select class="form-select" id="area" name="area" onchange="onAreaChange(this.value)">
                        <option value="">-- All Area --</option>
                        @foreach($area as $row)
                        <option value="{{ $row->id }}" @if(request()->area == $row->id) selected @endif>{{ $row->nama }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-3">
                    <label>Cabang</label>
                    <select class="form-select" id="lokasi" name="lokasi">
                        <option value="">-- All Cabang --</option>
                        
                    </select>
                </div>
                <div class="col-md-3">
                    <label>Divisi</label>
                    <select class="form-select" id="divisi" onchange="divisiChange(this.value)" name="divisi">
                        <option value="">-- All Divisi --</option>
                        @foreach($divisi as $div)
                        <option value="{{ $div->id }}" @if(request()->divisi == $div->id) selected @endif>{{ $div->nama }}</option>
                        @endforeach
                        </template>
                    </select>
                </div>
            
                <div class="col-2">
                    <label class="d-block">&nbsp;</label>
                    <button class="btn btn-primary">FILTER</button>
                </div>
            </div>

            <div class="form-group row">
                <div class="col-md-3">
                    <label>Jabatan</label>
                    <select class="form-select" id="jabatan" name="jabatan">
                        <option value="">-- All Jabatan --</option>
                        @foreach($jabatan as $jab)
                        <option value="{{ $jab->id }}"  @if(request()->jabatan == $jab->id) selected @endif>{{ $jab->nama }}</option>
                        @endforeach
                    </select>
                </div>
                <!-- <div class="col-md-3">
                    <label>Status Karyawan</label>
                    <select class="form-select" id="status" name="status">
                        <option value="">-- All Status --</option>
                        @foreach(['NON AKTIF','AKTIF'] as $key=>$stat)
                        <option value="{{ $key }}">{{ $stat }}</option>
                        @endforeach
                    </select>
                </div>
            -->
            </div>
            </form>
            <div class="col-lg-12 col-12">
                
                <table class="table table-striped table-bordered" id="datatables" style="width:100%">
                    <thead>
                        <tr id="thead">
                            <th>Aksi</th>
                            <th>Nik</th>
                            <th>Karyawan</th>
                            <th>Knowledge</th>
                            <th>Attitude</th>
                            <th>Skill</th>
                            @foreach($points as $point)
                            <th>{{ $point->name}}</th>
                            @endforeach
                            
                        </tr>
                    </thead>
                    <tbody>
                    @foreach($rows as $row)
                        <tr>
                            <td>
                                <div class="dropdown ">
                                    <button class="btn btn-primary btn-sm dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false">
                                    AKSI
                                    </button>
                                    <ul class="dropdown-menu dropdown-menu-dark"  aria-labelledby="dropdownMenuButton1">
                                        <li><a class="dropdown-item" href="#" onclick="editData('{{ $row->nik }}')">EDIT DATA</a></li>
                                        <li><a class="dropdown-item" href="#" onclick="komentarData('{{ $row->nik }}')">KOMENTAR</a></li>
                                    </ul>
                                </div>
                            </td>
                            
                            <td>{{ $row->nik }}</td>
                            <td>{{ $row->nama }}</td>
                            <td align="center">
                                @php
                                    $quiz   = App\Models\DataQuiz::selectRaw('MAX(nilai) as nilai')->where('nik',$row->nik)->groupBy('quiz_id','nik')->pluck('nilai')->toArray();
                                    /* $mQuiz  = App\Models\Quiz::whereHas('quizDivisi',function($q) use($row){
                                        $q->where('divisi_id',$row->divisi_id);
                                    })->count(); */
                                    $mQuiz = App\Models\DataQuiz::distinct()->where("nik",$row->nik)->count('quiz_id');
                                    if ($mQuiz > 0) {
                                        echo "<a href='#' class='btn btn-info' onclick='getDetail(this)' data-nik='".$row->nik."'>".round(array_sum($quiz)/$mQuiz,1)."</a>";
                                    } else {
                                        echo 0;
                                    }
                                @endphp
                            </td>
                            <td> {{ @$row->raport->attitude }}</td>
                            <td> {{ @$row->raport->skill }}</td>
                            @php $raports = [] @endphp
                            @foreach(App\Models\MasterKesimpulanDivisi::with(['data' => function($q) use($row) {
                                $q->whereHas('parentData',function($q) use($row) {
                                    $q->where('nik',$row->nik);
                                });
                            }])->where('divisi_id',$row->divisi_id)->orderBy('name')->get() as $dPoint)
                                @php $raports[$dPoint->name] = @$dPoint->data->name @endphp
                            @endforeach
                            @foreach($points as $point)
                                    <td>{{ @$raports[$point->name] }}</td>               
                            @endforeach
                        </tr>
                    @endforeach
                    </tbody>
                </table>
            </div>
            
        </div>
    </div>
</section>
@endsection

@push("modals")
    @include('pages.quiz.raport.form')
    @include('pages.quiz.raport.detail')
    @include('pages.quiz.raport.komentar')
@endpush

@push('scripts')
<script>
    var table;
    @if(request()->area != "")
        onAreaChange("{{ request()->area }}");
    @endif
    $(function(){
        $('#datatables').DataTable();
        /* table = $('#datatables').DataTable({
            serverSide:true,
            processing:true,
            responsive: true,
            ajax:{
                method:"POST",
                url:"{{ url('quiz/raport/data') }}",
                data:(d) => {
                    d.area = $('#area').val();
                    d.lokasi = $('#lokasi').val();
                    d.divisi = $('#divisi').val();
                    d.jabatan = $('#jabatan').val();
                    d.status = $('#status').val();
                }
            },
            columns:[
                {data:"aksi",render:(data,type,row) => {
                    var button = "";
                    button += `<li><a class="dropdown-item" href="#" onclick="editData('${row.nik}')">EDIT DATA</a></li>`;
                    return `<div class="dropdown ">
                            <button class="btn btn-primary btn-sm dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false">
                            AKSI
                            </button>
                            <ul class="dropdown-menu dropdown-menu-dark"  aria-labelledby="dropdownMenuButton1">
                            ${button}
                            </ul>
                        </div>`
                },orderable:false,searchable:false},
                {data:"nama",render:(data) => {
                    return data == null ? "" : data
                }},
                {data:"knowledge",render:(data) => {
                    return data == null ? "" : data
                },className:"text-center"},
                {data:"raport.attitude",render:(data) => {
                    return data == null ? "" : data
                }},
                {data:"raport.skill",render:(data) => {
                    return data == null ? "" : data
                }},
                {data:"divisi.point_raport",render:(data) => {
                    var $return = "<ol>";
                    if(data.length > 0) {
                        $.each(data,function(k,v){
                            $return += `<li>${v.name} : ${v.data == null ? "" : v.data.name}</li>`;
                        });
                    }
                    $return += "</ol>";
                    return $return;
                },'searchable':false,orderable:false},
                
            ],
            order:[[1,'asc']]
        });
        */
    })

    function getDetail(that)
    {
        
        $.get("{{ url('quiz/raport/detail') }}",{nik:$(that).data('nik')}).done(resp => {
            $('#items-quiz').empty();
            if(resp.length > 0) {
                $.each(resp,function(k,v) {
                    if(v.quiz) {
                        $('#items-quiz').append(`<tr><td>${v.quiz ? v.quiz.name : ""}</td><td>${v.tanggal}</td><td>${v.nilai}</td><td>${ (v.quiz ? v.quiz.min_value : 0) <= v.nilai ? 'LULUS' : 'TIDAK LULUS'}</td></tr>`)
                    }
                    
                })
            }
            $('#modal-detail').modal('show');
        });
    }
                
    
    
    function onAreaChange(value) {
        $.get("{{ url('payroll/list-lokasi') }}",{area_id:value}).done(resp => {
            $('#lokasi').empty();
            $('#lokasi').append('<option value="">-Pilih Cabang-</option>');
            if(resp.length > 0) {
                $.each(resp,function(k,v){
                    var selected = ""
                    if(v.id == "{{ request()->lokasi }}") {
                        selected = "selected";
                    }

                    $('#lokasi').append(`<option value="${v.id}" ${selected} >${v.nama}</option>`)
                });
            }
        });
    }

    function exportQuiz()
    {
        /* if($('#divisi').val() == "" && $('#area').val() == "") {
            alert("Divisi/Area Belum dipilih");
            return;
        } */
        window.open("{{ url('quiz/raport/export-quiz') }}?"+new URLSearchParams(params()).toString());
    }

    function exportRaport()
    {
        /* if($('#divisi').val() == "" || $('#area').val() == "") {
            alert("Divisi/Area Belum dipilih");
            return;
        } */
        window.open("{{ url('quiz/raport/export-raport') }}?"+new URLSearchParams(params()).toString());
    }

    function params() {
        var d = {};
        d.area = $('#area').val();
        d.lokasi = $('#lokasi').val();
        d.divisi = $('#divisi').val();
        d.jabatan = $('#jabatan').val();
       
        return d;
    }

    
</script>
@endpush