@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header">
                            <h5 class="mb-0">Result {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper row">
                                    <div class="col">
                                        {{-- button back --}}
                                        <button class="btn btn-secondary mb-0" onclick="history.back()"><i
                                                class="fas fa-circle-left me-1"> </i><span
                                                class="font-weight-bold">Kembali</button>
                                    </div>
                                    <div class="col-md-3 md-auto justify-content-end row">
                                        <div class="col">
                                            {{-- set value filter --}}
                                            
                                        </div>
                                        <div class="col">
                                            {{-- display label alias on class filter --}}
                                            Filter {{ @$table_class->alias }} :
                                            <select class="form-select" id="{{ @$table_class->field }}"
                                                style="width: 150px;">
                                                @if (@$table_class->query != '')
                                                    @if ($check_filter != '')
                                                        @php
                                                            $data_query = DB::select(@$table_class->query);
                                                        @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>40</b><br />
                                                            @if ($check_filter == $sAsArray[0])
                                                                <option value="{{ $sAsArray[0] }}">
                                                                    {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                                </option>
                                                            @endif
                                                        @endforeach
                                                    @else
                                                        <option value="" selected>% - All</option>
                                                        @php
                                                            $data_query = DB::select(@$table_class->query);
                                                        @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>53</b><br />
                                                            <option value="{{ $sAsArray[0] }}">
                                                                {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                            </option>
                                                        @endforeach
                                                    @endif
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div>
                                <table class="table table-bordered display" id="list_{{ $dmenu }}">
                                    {{-- check result data --}}
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th rowspan="2" class="align-middle text-center">No</th>
                                                <th rowspan="2" class="align-middle text-center">NIK</th>
                                                <th rowspan="2" class="align-middle text-center">Nama</th>
                                                <th rowspan="2" class="align-middle text-center">Department</th>
                                                <th rowspan="2" class="align-middle text-center">Position</th>
                                                <th rowspan="2" class="align-middle text-center">Gender</th>
                                                <th rowspan="2" class="align-middle text-center">Status</th>
                                                <th rowspan="2" class="align-middle text-center">Kategori</th>
                                                <th rowspan="2" class="align-middle text-center">Hijab/Non</th>
                                                <th colspan="{{ count($atasan) }}" class="text-center">Atasan</th>
                                                <th colspan="{{ count($bawahan) }}" class="text-center">Bawahan</th>
                                                {{-- set table header --}}
                                            </tr>
                                            <tr>
                                                @foreach ($atasan as $atsn)
                                                    <th>{{ $atsn->tipe_seragam }}</th>
                                                @endforeach

                                                @foreach ($bawahan as $bwhn)
                                                    <th>{{ $bwhn->tipe_seragam }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>

                                        <tbody>
                                            @foreach ($table_result as $i => $row)
                                                <tr>
                                                    <td>{{ $i + 1 }}</td>
                                                    <td>{{ $row->nik_karyawan }}</td>
                                                    <td>{{ $row->nama_karyawan }}</td>
                                                    <td>{{ $row->nama_departemen }}</td>
                                                    <td>{{ $row->nama_posisi }}</td>
                                                    <td>{{ $row->id_gender }}</td>
                                                    <td>{{ $row->nama_status }}</td>
                                                    <td>{{ $row->nama_kategori ?? '-' }}</td>
                                                    <td>{{ $row->hijab == 'Y' ? 'Hijab' : 'Non Hijab' }}</td>


                                                    {{-- Kolom seragam bagian Atasan --}}
                                                    @foreach ($atasan as $atsn)
                                                        @php
                                                            $field =
                                                                'jum_' .
                                                                \Illuminate\Support\Str::slug($atsn->tipe_seragam, '_');
                                                        @endphp
                                                        <td class="text-center">{{ $row->$field ?? '' }}</td>
                                                    @endforeach

                                                    {{-- Kolom seragam bagian Bawahan --}}
                                                    @foreach ($bawahan as $bwhn)
                                                        @php
                                                            $field =
                                                                'jum_' .
                                                                \Illuminate\Support\Str::slug($bwhn->tipe_seragam, '_');
                                                        @endphp
                                                        <td class="text-center">{{ $row->$field ?? '' }}</td>
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result)
                                    <div class="nav-wrapper" id="noted"><code>Note : <i aria-hidden="true"
                                                style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active</code>
                                    </div>
                                @else
                                    <div class="nav-wrapper"><code> Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                {{-- file js in folder (resources/views/js) --}}
                @include('js.' . $dmenu);
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection
@push('js')
    <script>
        let columnAbjad = '';
        $(document).ready(function() {
            let table = $('#list_{{ $dmenu }}').DataTable();
            let indexStatus = 0;
            let numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let columnNames = '';
            let filter = '{{ @$table_class->alias }}'.toLowerCase();

        });
        //set table into datatables
        $('#list_{{ $dmenu }}').DataTable({
            "language": {
                "search": "Cari :",
                "lengthMenu": "Tampilkan _MENU_ baris",
                "zeroRecords": "Maaf - Data tidak ada",
                "info": "Data _START_ - _END_ dari _TOTAL_",
                "infoEmpty": "Tidak ada data",
                "infoFiltered": "(pencarian dari _MAX_ data)"
            },
            responsive: true,
            dom: 'Bfrtip',
            buttons: [{
                    extend: 'excelHtml5',
                    text: '<i class="fas fa-file-excel me-1 text-lg text-success"> </i><span class="font-weight-bold"> Excel',
                    autoFilter: true,
                    sheetName: 'Exported data',
                    // title: 'Nama File Excel',
                    customize: function(xlsx) {
                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        // Loop over the cells in column
                        sheet.querySelectorAll('row c[r^="' + columnAbjad + '"]').forEach((row) => {
                            // Get the value
                            let cell = row.querySelector('is t');
                            if (cell && cell.textContent === 'Not Active') {
                                row.setAttribute('s', '10'); //red background
                            }
                        });
                    },
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
                {
                    extend: 'pdfHtml5',
                    text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"> </i><span class="font-weight-bold"> PDF',
                    orientation: 'landscape',
                    pageSize: 'A4',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
                {
                    extend: 'print',
                    text: '<i class="fas fa-print me-1 text-lg text-info"> </i><span class="font-weight-bold"> Print',
                    orientation: 'landscape',
                    pageSize: 'A4',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
            ],
            // columnDefs: [{
            //     targets: [3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
            //         15
            //     ], // Specify the column indexes you want to align
            //     className: 'text-end' // Use 'text-end' for right alignment (Bootstrap 5)
            // }]
        });

        //set color button datatables
        $('.dt-button').addClass('btn btn-secondary');
        $('.dt-button').removeClass('dt-button');
        //check authorize button datatables
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>249</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>249</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>250</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>250</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>251</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjuniform/resources/views/report/rptseragam/result.blade.php</b> on line <b>251</b><br />
        //function delete
    </script>

    <style>
        table.table-bordered {
            border-collapse: collapse !important;
            width: 100%;
        }

        .table-bordered th,
        .table-bordered td {
            border: 1px solid #4d4d4d !important;
            padding: 6px 8px;
            vertical-align: middle;
        }

        

        /* Tambahan jika pakai DataTables scrollX */
        div.dataTables_wrapper {
            overflow-x: auto;
        }

        table.dataTable tbody td {
            white-space: nowrap;
        }

        .dataTables_wrapper {
            overflow-x: auto;
        }

        .table-responsive {
            overflow-x: auto;
            -webkit-overflow-scrolling: touch;
        }

        table.dataTable {
            width: 100% !important;
            white-space: nowrap;
        }

        th,
        td {
            white-space: nowrap;
        }
    </style>
@endpush