@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
@section('head-link')
    <link href="{{ asset('assets/summernote-0.9.0-dist/summernote-bs5.css') }}" rel="stylesheet">
    <script src="{{ asset('assets/summernote-0.9.0-dist/summernote-bs5.js') }}"></script>
@endsection
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid">
        <div class="row">
            <div class="col-12">
                <div class="row mb-2 mx-1">
                    <div class="card" style="min-height: 650px; width: 100%;">
                        <div class="card-header">
                            <h5 class="mb-0">Peserta Tes</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col">
                                {{-- alert --}}
                                @include('components.alert')
                            </div>
                            <div class="d-flex justify-content-end align-items-center px-3 py-2">
                                <div class="d-flex align-items-center gap-2">
                                    <p id="selectedCount" class="fw-semibold text-primary small mb-3">0 Peserta Tes dipilih
                                    </p>
                                    <button type="button" class="btn btn-secondary btn-sm d-flex align-items-center"
                                        onclick="uncheckAll()" title="Batalkan semua pilihan">
                                        <i class="bi bi-x-lg me-1"></i> Batal
                                    </button>
                                    <button type="button" class="btn btn-danger btn-sm d-flex align-items-center"
                                        onclick="bulkAction('reject')">
                                        <i class="bi bi-x-circle me-1"></i> Tolak
                                    </button>
                                    <button type="button" class="btn btn-success btn-sm d-flex align-items-center"
                                        onclick="bulkAction('accept')">
                                        <i class="bi bi-check-circle me-1"></i> Terima
                                    </button>
                                </div>
                            </div>
                            <div class="table-responsive">
                                <table class="table display w-100" id="editable_table">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th>
                                                <div class="form-check">
                                                    <input class="form-check-input" type="checkbox" id="selectAll">
                                                </div>
                                            </th>
                                            <th>No</th>
                                            <th>Action</th>
                                            <th>Nama</th>
                                            <th>Lowongan</th>
                                            <th>Universitas</th>
                                            <th>Jadwal Tes</th>
                                            <th>Konfirmasi</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        @foreach ($peserta_tes as $key => $pt)
                                            <tr>
                                                <td>
                                                    <div class="form-check">
                                                        <input class="form-check-input rowCheckbox" type="checkbox"
                                                            value="{{ encrypt($pt->id) }}" data-nama="{{ $pt->nama }}"
                                                            data-lowongan="{{ $pt->lowongan_id }}">

                                                    </div>
                                                </td>
                                                <td>{{ $key + 1 }}</td>
                                                <td class="text-sm font-weight-normal">
                                                    <div class="btn-group">
                                                        <button class="btn btn-primary btn-sm mb-0 px-3" type="button"
                                                            title="View Data"
                                                            onclick="window.location='{{ url($url_menu . '/show/') }}/{{ encrypt($pt->id) }}'">
                                                            <i class="fas fa-eye" aria-hidden="true"> </i><span
                                                                class="font-weight-bold"> View
                                                            </span></button>
                                                        <button type="button"
                                                            class="btn btn-sm btn-primary mb-0 px-3 dropdown-toggle dropdown-toggle-split"
                                                            data-bs-toggle="dropdown" aria-expanded="false">
                                                            <span class="visually-hidden">Toggle Dropdown</span>
                                                        </button>
                                                        <ul class="dropdown-menu">
                                                            <li>
                                                                <hr class="dropdown-divider">
                                                            </li>
                                                            @php
                                                                $phone = $pt->no_telp;
                                                                if (str_starts_with($phone, '0')) {
                                                                    $phone = '62' . substr($phone, 1); // ganti 0 di awal jadi 62
                                                                }
                                                            @endphp
                                                            <button type="button"
                                                                class="btn btn-sm btn-info mx-2 mb-0 w-90" title="WhatsApp"
                                                                onclick="window.open('https://wa.me/{{ $phone }}')">
                                                                <span class="font-weight-bold">WhatsApp</span>
                                                            </button>
                                                            <li>
                                                                <hr class="dropdown-divider">
                                                            </li>
                                                            <button type="button"
                                                                class="btn btn-sm btn-danger mx-2 mb-0 w-90"
                                                                title="Edit Data"
                                                                onclick="openModal('reject','{{ encrypt($pt->id) }}', '{{ $pt->nama }}')">
                                                                <span class="font-weight-bold">Tolak</span>
                                                            </button>
                                                            <li>
                                                                <hr class="dropdown-divider">
                                                            </li>
                                                            <button type="button"
                                                                class="btn btn-sm btn-success mx-2 mb-0 w-90"
                                                                title="Edit Data"
                                                                onclick="openModal('accept', '{{ encrypt($pt->id) }}', '{{ $pt->nama }}', '{{ $pt->lowongan_id }}')">
                                                                <span class="font-weight-bold">Terima</span>
                                                            </button>
                                                            <li>
                                                                <hr class="dropdown-divider">
                                                            </li>
                                                        </ul>
                                                    </div>
                                                </td>
                                                <td>{{ $pt->nama }}</td>
                                                <td>
                                                    {{ $pt->posisi }}
                                                    @if (isset($kuota_info[$pt->lowongan_id]))
                                                        @php
                                                            $kuota = $kuota_info[$pt->lowongan_id];
                                                        @endphp
                                                        <br>
                                                        <small
                                                            class="badge {{ $kuota['penuh'] ? 'bg-danger' : ($kuota['sisa'] <= 2 ? 'bg-warning' : 'bg-info') }}">
                                                            Kuota: {{ $kuota['terisi'] }}/{{ $kuota['quota'] }}
                                                            @if ($kuota['penuh'])
                                                                (PENUH)
                                                            @else
                                                                (Sisa: {{ $kuota['sisa'] }})
                                                            @endif
                                                        </small>
                                                    @endif
                                                </td>
                                                <td>{{ $pt->universitas_id == '0' ? $pt->universitas_lain : $pt->universitas }}
                                                </td>
                                                <td>{{ \Carbon\Carbon::parse($pt->tanggal_waktu_tes)->format('d-m-Y H:i') }}
                                                </td>
                                                <td>{{ ucwords(strtolower($pt->keterangan)) }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- Modal Terima -->
            <div class="modal fade" id="acceptModal" tabindex="-1">
                <div class="modal-dialog modal-xl">
                    <form id="acceptForm" method="POST">
                        @csrf
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Kirim Email Penerimaan</h5>
                            </div>

                            <div class="modal-body">
                                <div class="mb-2">
                                    <strong>Nama Peserta Tes:</strong>
                                    <ol id="acceptApplicantName" class="mb-0"></ol>
                                </div>
                                <div class="mb-3">
                                    <label for="acceptLowongan">Lowongan</label>
                                    <br>
                                    <select id="acceptLowongan" name="lowongan_id" class="form-select select2" required>
                                        <option></option> <!-- wajib -->
                                        @foreach ($lowongans as $l)
                                            <option value="{{ $l->id }}">
                                                {{ $l->posisi }}
                                                ({{ \Carbon\Carbon::parse($l->start_period)->format('d-m-Y') }} -
                                                {{ \Carbon\Carbon::parse($l->end_period)->format('d-m-Y') }})
                                            </option>
                                        @endforeach
                                    </select>
                                </div>
                                <div class="mb-3">
                                    <label for="templateSelect">Template Email</label>
                                    <select id="acceptTemplateSelect" class="form-select">
                                        <option value="">-- Pilih Template --</option>
                                        @foreach ($template_email_terima as $template)
                                            <option value="{{ encrypt($template->id) }}">{{ $template->nama }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <input type="text" name="email_subject" id="acceptEmailSubject"
                                    class="form-control mb-2" placeholder="Subject" required>

                                <textarea name="email_body" id="acceptEmailContent" class="form-control mb-2" rows="5"
                                    placeholder="Isi email" required></textarea>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Tutup</button>
                                <button type="submit" class="btn btn-success" id="acceptSubmitBtn">
                                    Terima
                                </button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <!-- Modal Tolak -->
            <div class="modal fade" id="rejectModal" tabindex="-1">
                <div class="modal-dialog modal-xl">
                    <form id="rejectForm" method="POST">
                        @csrf
                        <div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Kirim Email Penolakan</h5>
                            </div>

                            <div class="modal-body">
                                <div class="mb-2">
                                    <strong>Nama Peserta Tes:</strong>
                                    <ol id="rejectApplicantName" class="mb-0"></ol>
                                </div>

                                <div class="mb-3">
                                    <label for="templateSelect">Template Email</label>
                                    <select id="rejectTemplateSelect" class="form-select">
                                        <option value="">-- Pilih Template --</option>
                                        @foreach ($template_email_tolak as $template)
                                            <option value="{{ encrypt($template->id) }}">{{ $template->nama }}</option>
                                        @endforeach
                                    </select>
                                </div>

                                <input type="text" name="email_subject" id="rejectEmailSubject"
                                    class="form-control mb-2" placeholder="Subject" required>

                                <textarea name="email_body" id="rejectEmailContent" class="form-control mb-2" rows="5"
                                    placeholder="Isi email" required></textarea>
                            </div>
                            <div class="modal-footer">
                                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Tutup</button>
                                <button type="submit" class="btn btn-danger" id="rejectSubmitBtn">Tolak</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>

            <script>
                // Fungsi umum untuk handle perubahan template
                function handleTemplateChange(type) {
                    const selectEl = document.getElementById(`${type}TemplateSelect`);
                    selectEl.addEventListener('change', function() {
                        const templateId = this.value;
                        if (!templateId) return;

                        fetch('{{ \Illuminate\Support\Facades\URL::to('/') }}' + '/mstmpe/' + templateId + '/ajax')
                            .then(res => res.json())
                            .then(data => {
                                if (data.status === 'success') {
                                    document.getElementById(`${type}EmailSubject`).value = data.data.email_subject;
                                    $(`#${type}EmailContent`).summernote('code', data.data.email_body);
                                }
                            })
                            .catch(error => {
                                console.error(`Error loading email template (${type}):`, error);
                            });
                    });
                }
                // Hitung checkbox terpilih
                function updateSelectedCount() {
                    const count = document.querySelectorAll('.rowCheckbox:checked').length;
                    document.getElementById('selectedCount').innerText = `${count} peserta tes dipilih`;
                }

                // Event untuk checkbox individu
                document.querySelectorAll('.rowCheckbox').forEach(cb => {
                    cb.addEventListener('change', updateSelectedCount);
                });
                document.getElementById('selectAll').addEventListener('change', function() {
                    const checkboxes = document.querySelectorAll('.rowCheckbox');
                    checkboxes.forEach(cb => {
                        cb.checked = this.checked;
                    });
                    updateSelectedCount();
                });

                function uncheckAll() {
                    document.getElementById('selectAll').checked = false;
                    document.querySelectorAll('.rowCheckbox').forEach(cb => cb.checked = false);
                    updateSelectedCount();
                }
                // Fungsi umum untuk membuka modal (Terima / Tolak)
                function openModal(type, applicantId, applicantName, applicantLowonganId) {
                    const form = document.getElementById(`${type}Form`);
                    // Reset form target
                    form.action = (type === 'accept') ?
                        '{{ \Illuminate\Support\Facades\URL::to('/') }}/trpsts/terima' :
                        '{{ \Illuminate\Support\Facades\URL::to('/') }}/trpsts/tolak';
                    // Set nama peserta tes (untuk tampilan di modal)
                    // Set nama kandidat (untuk tampilan di modal)
                    const nameList = applicantName.split(',').map(name => `<li>${name.trim()}</li>`).join('');
                    document.getElementById(`${type}ApplicantName`).innerHTML = nameList;

                    // Reset field email & isi lainnya
                    document.getElementById(`${type}TemplateSelect`).value = "";
                    document.getElementById(`${type}EmailSubject`).value = "";
                    $(`#${type}EmailContent`).summernote('code', '');

                    if (type === 'accept') {
                        $('#acceptLowongan').val(String(applicantLowonganId)).trigger('change');
                    }

                    // Hapus semua input bulk_ids sebelumnya
                    form.querySelectorAll('input[name="peserta_tes_id[]"]').forEach(el => el.remove());

                    // Tambahkan input baru bulk_ids[]
                    const input = document.createElement('input');
                    input.type = 'hidden';
                    input.name = 'peserta_tes_id[]';
                    input.value = applicantId;
                    form.appendChild(input);

                    // Tampilkan modal
                    $(`#${type}Modal`).modal('show');
                }


                // Panggil saat bulk action dipicu
                function bulkAction(type) {
                    const selected = [...document.querySelectorAll('.rowCheckbox:checked')];
                    if (selected.length === 0) {
                        alert("Pilih minimal satu peserta tes.");
                        return;
                    }

                    const ids = selected.map(cb => cb.value);
                    const names = selected.map(cb => cb.dataset.nama).join(', ');
                    const lowonganId = selected[0].dataset.lowongan ?? ''; // ambil dari data attribute

                    openModal(type, ids[0], names, lowonganId);

                    const form = document.getElementById(`${type}Form`);
                    form.querySelectorAll('input[name="bulk_ids[]"]').forEach(el => el.remove());

                    ids.forEach(id => {
                        const input = document.createElement('input');
                        input.type = 'hidden';
                        input.name = 'peserta_tes_id[]';
                        input.value = id;
                        form.appendChild(input);
                    });
                }

                // Inisialisasi jumlah awal saat dokumen siap
                document.addEventListener('DOMContentLoaded', updateSelectedCount);

                document.getElementById('acceptForm').addEventListener('submit', function() {
                    const submitButton = document.getElementById('acceptSubmitBtn');

                    submitButton.disabled = true;
                    submitButton.innerHTML = `
                        <span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>
                        Memproses...
                    `;
                });

                document.getElementById('rejectForm').addEventListener('submit', function() {
                    const submitButton = document.getElementById('rejectSubmitBtn');

                    submitButton.disabled = true;
                    submitButton.innerHTML = `
                        <span class="spinner-border spinner-border-sm me-1" role="status" aria-hidden="true"></span>
                        Memproses...
                    `;
                });

                // Inisialisasi
                $(document).ready(function() {
                    function customMatcher(params, data) {
                        if ($.trim(params.term) === '') {
                            return data;
                        }

                        // Konversi ke huruf kecil untuk pencarian case-insensitive
                        let searchTerm = params.term.toLowerCase();
                        let text = data.text.toLowerCase();

                        // Mencari di mana saja dalam teks
                        if (text.includes(searchTerm)) {
                            return data;
                        }

                        return null;
                    }
                    $('#acceptLowongan').select2({
                        placeholder: "Pilih Lowongan...",
                        allowClear: true,
                        width: '100%',
                        matcher: customMatcher,
                        dropdownParent: $('#acceptModal') // Menggunakan fungsi pencarian kustom
                    });
                    ['accept', 'reject'].forEach(type => {
                        $(`#${type}EmailContent`).summernote({
                            placeholder: 'Email Body',
                            tabsize: 2,
                            height: 400,
                        });

                        handleTemplateChange(type);
                    });
                });
            </script>
        </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 numColumns = $('#editable_table').DataTable().columns().count();
            let columnNames = '';

            for (let index = 0; index < numColumns; index++) {
                columnNames = $('#editable_table').DataTable().columns(index).header()[0].textContent;
                if (columnNames == 'Status' || columnNames == 'status') {
                    columnAbjad = String.fromCharCode(65 + index);
                }
            }
        });
        //set table header into datatables
        $('#list_header').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)"
            },
            "pageLength": 15,
            responsive: true,
            dom: 'frtip'
        });
        //set table detail into datatables
        $('#list_detail').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)"
            },
            "pageLength": 15,
            responsive: true,
            dom: 'Bfrtip',
            buttons: [{
                    text: '<i class="fas fa-plus me-1 text-lg btn-add"> </i><span class="font-weight-bold"> Tambah'
                },
                {
                    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',
                    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',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
            ]
        });
        //set color button datatables
        $('.dt-button').addClass('btn btn-secondary');
        $('.dt-button').removeClass('dt-button');
        //setting button add
        var id = "{{ Session::has('idtrans') ? encrypt(Session::get('idtrans')) : '' }}";
        var btnadd = $('.btn-add').parents('.btn-secondary');
        btnadd.removeClass('btn-secondary');
        btnadd.addClass('btn btn-primary');
        btnadd.attr('onclick', "window.location='{{ URL::to($url_menu . '/add/') }}" + "/" + id +
            "'");
        //check authorize button datatables
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>534</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>534</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>535</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>535</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>536</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>536</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>537</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>537</b><br />
        // function detail ajax
        function detail(id, gmenu, dmenu) {
            $.ajax({
                url: "{{ url($url_menu) . '/ajax' }}",
                type: "GET",
                dataType: "JSON",
                headers: {
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
                },
                data: {
                    id: id,
                    gmenu: gmenu,
                    dmenu: dmenu
                },
                success: function(data) {
                    // set title detail
                    $('#label_detail').text('List Detail -> ' + data['ajaxid']);
                    // reset datatables
                    $('#list_detail').DataTable().destroy();
                    $('#list_detail tbody').remove();
                    // retrieve data into tabel
                    $('#list_detail').append('<tbody></tbody>');
                    var i = 1;
                    var result = eval(data['table_detail_d_ajax']);
                    //looping data detail
                    for (var index in result) {
                        var result1 = eval(data['table_primary_d_ajax']);
                        var result2 = eval(data['table_header_d_ajax']);
                        var primary = '';
                        for (var index1 in result1) {
                            // initialized primary key
                            primary == '' ? (primary = result[index][result1[index1].field]) : (primary =
                                primary + ':' + result[index][result1[index1].field]);
                        }
                        // set variable columns
                        var vtd = `
                                    <td class="text-sm font-weight-normal">
                                        <button type="submit" class="btn btn-primary mb-0 py-1 px-2"
                                            title="View Data"
                                            onclick="window.location='{{ url($url_menu . '/show/') }}` + '/' + data[
                                'encrypt_primary'][
                                index
                            ] + `'">
                                            <i class="fas fa-eye"></i>
                                        </button>
                                        {{-- check authorize edit --}}
                                        @if ($authorize->edit == '1')
                                            {{-- button edit --}}
                                            <button type="button" class="btn btn-warning mb-0 py-1 px-2"
                                                title="Edit Data"
                                                onclick="window.location='{{ url($url_menu . '/edit/') }}` + '/' +
                            data[
                                'encrypt_primary'][
                                index
                            ] + `'">
                                                <i class="fas fa-edit"></i>
                                            </button>
                                        @endif
                                        {{-- check authorize delete --}}
                                        @if ($authorize->delete == '1')
                                            <form onsubmit="return deleteData(event,'` + primary + `','Hapus')"
                                                action="{{ url($url_menu . '/') }}` + '/' + data['encrypt_primary'][
                                index
                            ] + `"
                                                method="POST" style="display: inline">
                                                @csrf
                                                @method('DELETE')
                                                <button type="submit" class="btn btn-danger mb-0 py-1 px-2"
                                                    title="Hapus Data">
                                                    <i class="fas fa-trash"></i>
                                                </button>
                                            </form>
                                        @endif
                                    </td>
                                    `;
                        for (var index2 in result2) {
                            var primary_color = result2[index2].primary == '1' ? 'bold text-dark' : 'normal';
                            var vtex = result[index][result2[index2].field];
                            if (result2[index2].type == 'enum') {
                                if (result2[index2].query != '') {
                                    var query = result2[index2].query;
                                    var v_enum = eval(data[result2[index2].field]);
                                    $.each(v_enum, function(index, q) {
                                        var sAsArray = $.map(q, function(value,
                                            key) {
                                            return value;
                                        });
                                        if (vtex == sAsArray[0]) {
                                            vtd +=
                                                `<td class="text-sm font-weight-` +
                                                primary_color + `">` + sAsArray[1] +
                                                `</td>`;
                                        }
                                        return vtd;
                                    });
                                } else {
                                    vtd +=
                                        `<td class="text-sm font-weight-` + primary_color + `">` +
                                        result[index][result2[index2].field] + `</td>`;
                                }
                            } else if (result2[index2].type == 'join') {
                                if (result2[index2].query != '') {
                                    var query = result2[index2].query + "'" + result2[index2].field + "'";
                                    var v_enum = eval(data['data_join'][index]);
                                    $.each(v_enum, function(index, q) {
                                        var sAsArray = $.map(q, function(value,
                                            key) {
                                            return value;
                                        });
                                        vtd +=
                                            `<td class="text-sm font-weight-` +
                                            primary_color + `">` + sAsArray[0] +
                                            `</td>`;
                                        return vtd;
                                    });
                                } else {
                                    vtd +=
                                        `<td class="text-sm font-weight-` + primary_color + `">` +
                                        result[index][result2[index2].field] + `</td>`;
                                }
                            } else if (result2[index2].type == 'currency') {
                                vtd +=
                                    `<td class="text-sm font-weight-` + primary_color +
                                    `">` + currencyFormat(result[index][result2[index2].field], result2[index2]
                                        .decimals, result2[index2].sub) + `</td>`;


                            } else {
                                vtd +=
                                    `<td class="text-sm font-weight-` + primary_color + `">` +
                                    result[index][result2[index2].field] + `</td>`;
                            }
                        }
                        i++;
                        // add rows into table
                        $('#list_detail tbody').append(`<tr>` + vtd + `</tr>`);
                    }
                    // initialized datatbles
                    let columnAbjad = '';
                    $(document).ready(function() {
                        let numColumns = $('#editable_table').DataTable().columns()
                            .count();
                        let columnNames = '';
                        // set color datatables
                        for (let index = 0; index < numColumns; index++) {
                            columnNames = $('#editable_table').DataTable().columns(index)
                                .header()[0].textContent;
                            if (columnNames == 'Status' || columnNames == 'status') {
                                columnAbjad = String.fromCharCode(65 + index);
                            }
                        }
                        // function set color row DataTable
                        $('.odd').click(function() {
                            $('.odd').css('background-color', '');
                            $('.even').css('background-color', '');
                            $('.not').css('background-color', '#ffe9ed');
                            $(this).css('background-color', '#f9f4ea');
                        });
                        $('.even').click(function() {
                            $('.odd').css('background-color', '');
                            $('.even').css('background-color', '');
                            $('.not').css('background-color', '#ffe9ed');
                            $(this).css('background-color', '#f9f4ea');
                        });
                        var table = $('#list_{{ @$dmenu }}').DataTable();
                        // Add the click event to all rows on all pages
                        table.on('draw', function() {
                            $('.odd').click(function() {
                                $('.odd').css('background-color', '');
                                $('.even').css('background-color', '');
                                $('.not').css('background-color', '#ffe9ed');
                                $(this).css('background-color', '#f9f4ea');
                            });
                            $('.even').click(function() {
                                $('.odd').css('background-color', '');
                                $('.even').css('background-color', '');
                                $('.not').css('background-color', '#ffe9ed');
                                $(this).css('background-color', '#f9f4ea');
                            });
                        });
                        // end function set color row DataTable
                    });
                    //redraw table into datatables
                    $('#list_detail').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)"
                        },
                        "pageLength": 15,
                        responsive: true,
                        dom: 'Bfrtip',
                        buttons: [{
                                text: '<i class="fas fa-plus me-1 text-lg btn-add"> </i><span class="font-weight-bold"> Tambah'
                            },
                            {
                                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',
                                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',
                                exportOptions: {
                                    columns: ':visible:not(:last-child)'
                                },
                            },
                        ]
                    }).draw();
                    //set color button datatables
                    $('.dt-button').addClass('btn btn-secondary');
                    $('.dt-button').removeClass('dt-button');
                    //setting button add
                    var btnadd = $('.btn-add').parents('.btn-secondary');
                    btnadd.removeClass('btn-secondary');
                    btnadd.addClass('btn btn-primary');
                    btnadd.attr('onclick', "window.location='{{ URL::to($url_menu . '/add/') }}" + "/" +
                        id +
                        "'");
                    //check authorize button datatables
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>788</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>788</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>789</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>789</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>790</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>790</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>791</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trpsts/list.blade.php</b> on line <b>791</b><br />
                },
                error: function(jqXHR, textStatus, errorThrown) {
                    Swal.fire({
                        title: 'Sorry!',
                        text: 'Error Get data!',
                        icon: 'error',
                        confirmButtonColor: '#3085d6'
                    });
                }
            });
        }
        //function delete
        function deleteData(event, name, msg) {
            event.preventDefault(); // Prevent default form submission
            Swal.fire({
                title: 'Konfirmasi',
                text: `Apakah Anda Yakin ${msg} Data ${name} ini?`,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: `Ya, ${msg}`,
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284'
            }).then((result) => {
                if (result.isConfirmed) {
                    // Find the closest form element and submit it manually
                    event.target.closest('form').submit();
                }
            });
        }
        // function currency
        function currencyFormat(nominal, decimal = 0, prefix = 'Rp.') {
            return prefix + ' ' + parseFloat(nominal).toFixed(decimal).replace(/\d(?=(\d{3})+\.)/g, '$&,');
        }
    </script>
@endpush