@extends('layouts.app')

@section('title', 'Realisasi Jam Kerja')

@push('style')
    <!-- CSS Libraries -->
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <!-- CSS Libraries -->
    <link
        href="https://cdn.datatables.net/v/bs4/jszip-2.5.0/dt-1.13.4/af-2.5.3/b-2.3.6/b-colvis-2.3.6/b-html5-2.3.6/b-print-2.3.6/cr-1.6.2/date-1.4.1/fc-4.2.2/fh-3.3.2/kt-2.9.0/r-2.4.1/rg-1.3.1/rr-1.3.3/sc-2.1.1/sb-1.4.2/sp-2.1.2/sl-1.6.2/sr-1.2.2/datatables.min.css"
        rel="stylesheet" />
    <link rel="stylesheet" href="{{ asset('library') }}/sweetalert2/dist/sweetalert2.min.css">
@endpush

@section('main')
    @include('components.analis-sdm-header')
    @include('components.analis-sdm-sidebar')
    <div class="main-content">
        <section class="section">
            <div class="section-header">
                <h1>Rekap Realisasi Jam Kerja</h1>
                <div class="section-header-breadcrumb">
                    <div class="breadcrumb-item active"><a href="/analis-sdm">Dashboard</a></div>
                    <div class="breadcrumb-item">Rekap Realisasi Jam Kerja</div>
                </div>
            </div>

            <div class="section-body">
                <div class="row">
                    <div class="col-md-12">
                        <div class="card">
                            <div class="card-body">
                                <div class="row">
                                    <form id="yearForm" action="" method="GET" class="col-4">
                                        @csrf
                                        <div class="form-group">
                                            <label for="yearSelect">Tahun</label>
                                            <select name="year" id="yearSelect" class="form-control select2">
                                                @php
                                                $currentYear = date('Y');
                                                $lastThreeYears = range($currentYear, $currentYear - 3);
                                                @endphp
                            
                                                @foreach ($lastThreeYears as $year)
                                                <option value="{{ $year }}" {{ request()->query('year') == $year ? 'selected' : '' }}>{{ $year }}
                                                </option>
                                                @endforeach
                                            </select>
                                            <input type="hidden" name="unit" id="unitYear">
                                        </div>
                                    </form>
                                    <form id="unitForm" action="" method="GET" class="col-4">
                                        @csrf
                                        <div class="form-group">
                                            <label for="unitSelect">Unit Kerja</label>
                                            <select name="unit" id="unitSelect" class="form-control select2" {{ $unituser != '8000' && $unituser != '8010' ? 'disabled' : '' }}>
                                                <option value="8000" {{ request()->query('unit') == '8000' ? 'selected' : '' }}>Semua</option>
                                                <option value="8010" {{ request()->query('unit') == '8010' ? 'selected' : '' }}>Bagian Umum Inspektorat Utama</option>
                                                <option value="8100" {{ request()->query('unit') == '8100' || $unituser == '8100' ? 'selected' : '' }}>Inspektorat Wilayah I</option>
                                                <option value="8200" {{ request()->query('unit') == '8200' || $unituser == '8200' ? 'selected' : '' }}>Inspektorat Wilayah II</option>
                                                <option value="8300" {{ request()->query('unit') == '8300' || $unituser == '8300' ? 'selected' : '' }}>Inspektorat Wilayah III</option>
                                            </select>
                                            <input type="hidden" name="year" id="yearUnit">
                                        </div>
                                    </form>
                                </div>
                                <div>
                                    <table class="table table-bordered table-striped display responsive" id="table-inspektur-kinerja">
                                        <thead>
                                            <tr>
                                                <th rowspan="2" class="align-middle">No.</th>
                                                <th rowspan="2" class="align-middle">Pegawai</th>
                                                <th rowspan="2" class="align-middle">Detail</th>
                                                <th colspan="13" class="text-center" id="title">Realisasi Jam Kerja</th>
                                            </tr>
                                            <tr>
                                                <th>Jan</th>
                                                <th>Feb</th>
                                                <th>Mar</th>
                                                <th>Apr</th>
                                                <th>Mei</th>
                                                <th>Jun</th>
                                                <th>Jul</th>
                                                <th>Agu</th>
                                                <th>Sep</th>
                                                <th>Okt</th>
                                                <th>Nov</th>
                                                <th>Des</th>
                                                <th>Total</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($jam_kerja as $key => $jam) 
                                                @isset($jam[0]->name)
                                                    <tr>
                                                        <td></td>
                                                        <td>{{ $jam[0]->name }}</td>
                                                        <td>
                                                            <a class="btn btn-primary detail"
                                                                href="/analis-sdm/realisasi-jam-kerja/pool/{{ $key }}/{{ date('Y') }}"
                                                                style="width: 42px">
                                                                <i class="fas fa-eye"></i>
                                                            </a>
                                                        </td>
                                                        @isset($jam[1]) 
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['01'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['02'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['03'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['04'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['05'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['06'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['07'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['08'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['09'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['10'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['11'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['realisasi_jam']['12'] ?? 0 }}</td>
                                                            <td class="convert">{{ $jam[1]['total'] }}</td>
                                                        @else
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                            <td>0</td>
                                                        @endisset
                                                    </tr>
                                                @endisset
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </section>
    </div>
@endsection

@push('scripts')
    <!-- JS Libraies -->
    {{-- <script src="https://cdn.datatables.net/1.13.4/js/jquery.dataTables.js"></script> --}}
    <script src="https://cdn.datatables.net/v/dt/dt-1.13.4/b-2.3.6/b-colvis-2.3.6/datatables.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-bs4/js/dataTables.bootstrap4.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-responsive/js/dataTables.responsive.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-responsive/js/responsive.bootstrap4.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-buttons/js/dataTables.buttons.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-buttons/js/buttons.bootstrap4.min.js"></script>
    <script src="{{ asset('js') }}/plugins/jszip/jszip.min.js"></script>
    <script src="{{ asset('js') }}/plugins/pdfmake/pdfmake.min.js"></script>
    <script src="{{ asset('js') }}/plugins/pdfmake/vfs_fonts.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-buttons/js/buttons.html5.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-buttons/js/buttons.print.min.js"></script>
    <script src="{{ asset('js') }}/plugins/datatables-buttons/js/buttons.colVis.min.js"></script>
    <script src="{{ asset('library') }}/sweetalert2/dist/sweetalert2.min.js"></script>
    
    <!-- Page Specific JS File -->
    {{-- <script src="{{ asset('js') }}/page/inspektur-st-kinerja.js"></script> --}}
    <script>
        $('#table-inspektur-kinerja').find("td.convert").each(function() {
            $(this).attr('value', $(this).text());
        });
        
        var datatable = $('#table-inspektur-kinerja').dataTable({
            dom: "Bfrtip",
            responsive: false,
            lengthChange: false,
            autoWidth: false,
            scrollX: true,
            buttons: [
                {
                    className: "btn-success unduh",
                    text: '<i class="fas fa-file-excel"></i> Excel',
                },
                {
                    text: 'Jam Kerja',
                    className: 'btn btn-primary disabled ml-2 jam-kerja toggle',
                },
                {
                    text: 'Hari Kerja',
                    className: 'btn btn-primary hari-kerja toggle',
                }
            ],
            columnDefs: [{
                "targets": 0,
                "createdCell": function (td, cellData, rowData, row, col) {
                $(td).text(row + 1);
                }
            }]
        }).api();

        //update ukuran tabel saat ukuran sidebar berubah
        $('.nav-link').on("click", function () {
            setTimeout( function () {
                datatable.columns.adjust();
            }, 500);
        });

        let mode = 'jam';
        $('#table-inspektur-kinerja_wrapper .dt-buttons').removeClass('btn-group');
        $('.toggle').wrapAll('<div class="btn-group"></div>');
        $('.hari-kerja').on('click', function() {
            $(this).addClass('disabled');
            $(this).attr('disabled', true);
            $(".jam-kerja").removeClass('disabled');
            $(".jam-kerja").attr('disabled', false);
            datatable.cells('.convert').every(function () {
                if (this.data() != '0') this.data(($(this.node()).attr('value') / 7.5).toFixed(2))
            });
            $('#title').text('Realisasi Hari Kerja');
            mode = 'hari';
        })
        $('.jam-kerja').on('click', function() {
            $(this).addClass('disabled');
            $(this).attr('disabled', true);
            $(".hari-kerja").removeClass('disabled');
            $(".hari-kerja").attr('disabled', false);
            datatable.cells('.convert').every(function () {
                if (this.data() != '0') this.data($(this.node()).attr('value'))
            });
            $('#title').text('Realisasi Jam Kerja');
            mode = 'jam';
        })
        
        $('#yearSelect').on('change', function() {
            let year = $(this).val();
            let unit = $('#unitSelect').val();
            $('#unitYear').val(unit);
            $('#yearForm').find('[name="_token"]').remove();
            $('#yearForm').submit();
        });

        $('#unitSelect').on('change', function() {
            let unit = $(this).val();
            let year = $('#yearSelect').val();
            $('#yearUnit').val(year);
            $('#unitForm').find('[name="_token"]').remove();
            $('#unitForm').submit();
        });

        $(".detail").attr('href', function(_, el){
            return el.replace(/\/[^\/]*$/, '/' + $('#yearSelect').val());
        });

        $('.unduh').on('click', function() {
            window.location.href = `/analis-sdm/realisasi-jam-kerja/export/${mode}/${$('#yearSelect').val()}/${$('#unitSelect').val()}`;
        })

        $('#table-inspektur-kinerja').on('draw.dt', function() {
            $(".detail").attr('href', function(_, el){
                return el.replace(/\/[^\/]*$/, '/' + $('#yearSelect').val());
            });
        });
    </script>
@endpush