@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-{{ $colomh > 1 ? '4' : '3' }}">
                <div class="row mb-2 mx-1">
                    <div class="card" style="min-height: 650px;">
                        <div class="card-header">
                            <h5 class="mb-0">List {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_header">
                                    {{-- check result data --}}
                                    {{-- @dd($table_result) --}}
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                {{-- set table header --}}
                                                @foreach ($table_result as $result)
                                                    @php
                                                        $sAsArray = array_keys((array) $result);
                                                    @endphp
                                                @endforeach
                                                @foreach ($sAsArray as $header)
                                                    @if ($header == 'Detail')
                                                        <th style="width: 100%;">{{ $header }}</th>
                                                    @endif
                                                @endforeach
                                                <th>Action</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            {{-- retrieve table result --}}
                                            @foreach ($table_result as $detail)
                                                <tr
                                                    {{ @$detail->isactive == '0' || @$detail->ISACTIVE == '0' ? 'style=background-color:#ffe9ed;' : '' }}>
                                                    @foreach ($table_result as $result)
                                                        @php
                                                            $field = array_keys((array) $result);
                                                            $vgmenu = '';
                                                            $vdmenu = '';
                                                            $vicon = '';
                                                            $vtabel = '';
                                                        @endphp
                                                    @endforeach
                                                    @foreach ($field as $header)
                                                        @if ($header == 'Detail')
                                                            <td class="text-sm font-weight-normal">
                                                                {{ $detail->$header }}</td>
                                                        @elseif ($header == 'gmenu')
                                                            @php
                                                                $vgmenu = $detail->$header;
                                                            @endphp
                                                        @elseif ($header == 'dmenu')
                                                            @php
                                                                $vdmenu = $detail->$header;
                                                            @endphp
                                                        @elseif ($header == 'icon')
                                                            @php
                                                                $vicon = $detail->$header;
                                                            @endphp
                                                        @elseif ($header == 'tabel')
                                                            @php
                                                                $vtabel = $detail->$header;
                                                            @endphp
                                                        @endif
                                                    @endforeach
                                                    <td class="text-sm font-weight-normal">
                                                        {{-- button detail --}}
                                                        <button type="button" class="btn btn-dark mb-0 py-2 px-3"
                                                            title="View Data"
                                                            onclick="detail('{{ @$_GET['id'] }}','{{ $vgmenu }}','{{ $vdmenu }}','{{ $vtabel }}')">
                                                            <i class="ni {{ $vicon }}"></i> </i><span
                                                                class="font-weight-bold">
                                                                List</span>
                                                        </button>
                                                    </td>
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
            <div class="col-md-{{ $colomh > 1 ? '8' : '9' }}">
                <div class="row mx-1">
                    <div class="card" style="min-height: 650px;">
                        <div class="row">
                            <div class="card-header col-md-auto">
                                <h5 class="mb-0" id="label_detail">List Detail ->
                                    {{ @$_GET['id'] ? decrypt(@$_GET['id']) : '' }}</h5>
                            </div>
                            <div class="col">
                                {{-- alert --}}
                                @include('components.alert')
                            </div>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                                <div class="table-responsive">
                                <table class="table display" id="list_detail">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                            <th>Action</th>
                                            {{-- retrieve table header --}}
                                            @foreach ($table_header_d as $header_d)
                                                <th>{{ $header_d->alias }}</th>
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                        {{-- @dd($table_detail_d) --}}
                                            {{-- retrieve table detail --}}
                                        @foreach ($table_detail_d as $detail)
                                                @php
                                                $primary = '';
                                                foreach ($table_primary_h as $h) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$h->field})
                                                        : ($primary = $primary . ':' . $detail->{$h->field});
                                                }
                                                foreach ($table_primary_d as $p) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$p->field})
                                                        : ($primary = $primary . ':' . $detail->{$p->field});
                                                }
                                                @endphp
                                            <tr {{ $detail->isactive == '0' ? 'style=background-color:#ffe9ed;' : '' }}>
                                                <td class="text-sm font-weight-normal">
                                                    <button type="submit" class="btn btn-success mb-0 py-1 px-2"
                                                        title="View Data"
                                                        onclick="window.location='{{ url($url_menu . '/show' . '/' . encrypt($primary) . '?gmenu=' . @$_GET['gmenu'] . '&dmenu=' . @$_GET['dmenu'] . '&tabel=' . @$_GET['tabel']) }}'">
                                                        <i class="fas fa-eye"></i>
                                                    </button>
                                                    {{-- check authorize edit --}}
                                                    @if ($authorize->edit == '1')
                                                        {{-- check status active --}}
                                                        @if ($detail->isactive == 1)
                                                        {{-- @if ()
                                                            
                                                        @endif --}}
                                                            {{-- button edit --}}
                                                            <button type="button" class="btn btn-success mb-0 py-1 px-2"
                                                                title="Edit Data"
                                                                onclick="window.location='{{ url($url_menu . '/edit' . '/' . encrypt($primary) . '?gmenu=' . @$_GET['gmenu'] . '&dmenu=' . @$_GET['dmenu'] . '&tabel=' . @$_GET['tabel']) }}'">
                                                                <i class="fas fa-edit"></i>
                                                            </button>
                                                        @endif
                                                    @endif
                                                    <!-- {{-- check authorize delete --}}
                                                    @if ($authorize->delete == '1' && ($dmenu !== 'lstsd' && $dmenu !== 'lstsa'))
                                                        <form
                                                            onsubmit="return deleteData(event,'{{ $primary }}','{{ $detail->isactive == '0' ? 'Aktifkan' : 'Non Aktifkan' }}')"
                                                            action="{{ url($url_menu . '/' . encrypt($primary) . '?gmenu=' . @$_GET['gmenu'] . '&dmenu=' . @$_GET['dmenu'] . '&tabel=' . @$_GET['tabel']) }}"
                                                            method="POST" style="display: inline">
                                                            @csrf
                                                            @method('DELETE')
                                                            {{-- button delete --}}
                                                            <button type="submit" class="btn btn-success mb-0 py-1 px-2"
                                                                title="Hapus Data">
                                                                <i class="fas fa-{{ $detail->isactive == '0' ? 'random' : 'trash' }}"></i>
                                                            </button>
                                                        </form>
                                                    @endif -->
                                                </td>
                                                {{-- retrieve table detail --}}
                                                    @foreach ($table_header_d as $field)
                                                {{-- @dump($table_header_d); --}}
                                                        @php
                                                            $string = $field->field;
                                                        @endphp
                                                        {{-- field type enum --}}
                                                        @if ($field->type == 'enum')
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                                @if ($field->query != '')
                                                                    @php
                                                                        $data_query = DB::select($field->query);
                                                                    @endphp
                                                                @if (Str::contains($field->class, 'select-multiple'))
                                                                    <br />
<b>Warning</b>:  Undefined variable $detail in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>189</b><br />
<br />
<b>Warning</b>:  Undefined variable $string in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>189</b><br />
<br />
<b>Warning</b>:  Attempt to read property "" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>189</b><br />
                                                                    @foreach ($data_query as $q)
                                                                        @php
                                                                            $sAsArray = array_values((array) $q);
                                                                            if (in_array($sAsArray[0], $multiple)) {
                                                                                if ($text == '') {
                                                                                    $text = $sAsArray[1];
                                                                                } else {
                                                                                    $text = $text . ',' . $sAsArray[1];
                                                                                }
                                                                            }
                                                                        @endphp
                                                                    @endforeach
                                                                    {{ $text }}
                                                                @else
                                                                    @foreach ($data_query as $q)
                                                                        <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>207</b><br />
                                                                        {{ $detail->$string == $sAsArray[0] ? $sAsArray[1] : '' }}
                                                                    @endforeach
                                                                @endif
                                                            @endif
                                                        </td>
                                                        {{-- field type file --}}
                                                    @elseif ($field->type == 'file')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($detail->$string)
                                                                <a target="_blank"
                                                                    class="btn btn-sm btn-outline-success mb-0 py-1 px-2"
                                                                    href="{{ asset('/storage' . '/' . $detail->$string) }}">
                                                                    <i aria-hidden="true" class="fas fa-file-lines text-lg">
                                                                    </i>
                                                                    {{ $field->alias }}</a>
                                                            @endif
                                                        </td>
                                                        {{-- field type image --}}
                                                    @elseif($field->type == 'image')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            <span class="my-2 text-xs">
                                                                <img src="{{ file_exists(public_path('storage/' . $detail->$string . 'tumb.png')) ? asset('/storage' . '/' . $detail->$string . 'tumb.png') : asset('storage/' . $detail->$string) }}"
                                                                    alt="image" style="height: 35px;"
                                                                    data-bs-toggle="modal"
                                                                    data-bs-target="#imageModal{{ $field->field }}">
                                                            </span>
                                                            <span
                                                                style="display: none;">{{ asset('/storage' . '/' . $detail->$string) }}
                                                            </span>
                                                            <!-- Modal -->
                                                            <div class="modal fade" id="imageModal{{ $field->field }}"
                                                                tabindex="-1" role="dialog"
                                                                aria-labelledby="imageModalLabel" aria-hidden="true">
                                                                <div class="modal-dialog modal-dialog-centered"
                                                                    role="document">
                                                                    <div class="modal-content">
                                                                        <div class="modal-header">
                                                                            <h5 class="modal-title" id="imageModalLabel">
                                                                                Preview Image
                                                                            </h5>
                                                                            <button type="button" class="btn-close"
                                                                                data-bs-dismiss="modal" aria-label="Close">
                                                                                <span aria-hidden="true">&times;</span>
                                                                            </button>
                                                                        </div>
                                                                        <div class="modal-body">
                                                                            <img src="{{ asset('/storage' . '/' . $detail->$string) }}"
                                                                                id="preview" alt="image"
                                                                                class="w-100 border-radius-lg shadow-sm">
                                                                        </div>
                                                                        <div class="modal-footer">
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                            </td>
                                                        {{-- field type join --}}
                                                    @elseif($field->type == 'join')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($field->query != '')
                                                                @php
                                                                    $query =
                                                                        $field->query . "'" . $detail->$string . "'";
                                                                    $data_query = DB::select($query);
                                                                @endphp
                                                                @foreach ($data_query as $q)
                                                                    <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>277</b><br />
                                                                    @if ($field->default != 'image')
                                                                        {{ $sAsArray[0] != '' ? $sAsArray[0] : '' }}
                                                                    @else
                                                                        <span class="my-2 text-xs">
                                                                            <img src="{{ asset('/storage' . '/' . $sAsArray[0]) }}"
                                                                                alt="image" style="height: 40px;"
                                                                                data-bs-toggle="modal"
                                                                                data-bs-target="#imageModalJoin{{ $primary }}">
                                                                        </span>
                                                                        <span
                                                                            style="display: none;">{{ asset('/storage' . '/' . $sAsArray[0]) }}
                                                                        </span>
                                                                        <!-- Modal -->
                                                                        <div class="modal fade"
                                                                            id="imageModalJoin{{ $primary }}"
                                                                            tabindex="-1" role="dialog"
                                                                            aria-labelledby="imageModalJoinLabel"
                                                                            aria-hidden="true">
                                                                            <div class="modal-dialog modal-dialog-centered"
                                                                                role="document">
                                                                                <div class="modal-content">
                                                                                    <div class="modal-header">
                                                                                        <h5 class="modal-title"
                                                                                            id="imageModalJoinLabel">
                                                                                            Preview Image
                                                                                        </h5>
                                                                                        <button type="button"
                                                                                            class="btn-close"
                                                                                            data-bs-dismiss="modal"
                                                                                            aria-label="Close">
                                                                                            <span
                                                                                                aria-hidden="true">&times;</span>
                                                                                        </button>
                                                                                    </div>
                                                                                    <div class="modal-body">
                                                                                        <img src="{{ asset('/storage' . '/' . $sAsArray[0]) }}"
                                                                                            id="preview" alt="image"
                                                                                            class="w-100 border-radius-lg shadow-sm">
                                                                                    </div>
                                                                                    <div class="modal-footer">
                                                                                    </div>
                                                                                </div>
                                                                            </div>
                                                                        </div>
                                                                    @endif
                                                                @endforeach
                                                            @endif
                                                        </td>
                                                        {{-- field type currency --}}
                                                    @elseif ($field->type == 'currency')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            {{ $format->CurrencyFormat($detail->$string, $field->decimals, $field->sub) }}
                                                            </td>
                                                        {{-- field type joinmultiple (untuk approval) --}}
                                                    @elseif ($field->type == 'joinmultiple')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($field->query != '')
                                                                @php
                                                                    // Base SELECT dari sys_table (harus berakhir "... AND ad.id_sample = ")
                                                                    $base = trim($field->query);
                                                                    // Ambil id_sample dari primary key header
                                                                    $idVal = null;
                                                                    foreach ($table_primary_h as $h) {
                                                                        if ($h->field == 'id_sample') {
                                                                            $idVal = $detail->{$h->field} ?? null;
                                                                            break;
                                                                        }
                                                                    }
                                                                    // Jika tidak ada di header, coba dari detail
                                                                    if (!$idVal) {
                                                                        $idVal = $detail->id_sample ?? null;
                                                                    }
                                                                    $sql = preg_match('/=\s*$/', $base) ? $base . ' ?' : $base . ' ?';
                                                                    $rows = $idVal !== null ? DB::select($sql, [$idVal]) : [];
                                                                    $vals = [];
                                                                    foreach ($rows as $row) {
                                                                        $arr = array_values((array) $row);
                                                                        if (isset($arr[0]) && $arr[0] !== '') {
                                                                            $vals[] = $arr[0];
                                                                        }
                                                                    }
                                                                    $approval_text = !empty($vals) ? implode(', ', $vals) : '-';
                                                                @endphp
                                                                {{ $approval_text }}
                                                            @else
                                                                {{ $detail->$string ?? '-' }}
                                                            @endif
                                                            </td>
                                                        @else
                                                            <td
                                                                class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            {{ $detail->$string }}</td>
                                                        @endif
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    </table>
                                </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 numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let columnNames = '';

            for (let index = 0; index < numColumns; index++) {
                columnNames = $('#list_{{ $dmenu }}').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: ''
        });
        //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',
            @php
            if(isset($_GET['gmenu']))
            {
                @endphp
                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',
                        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)'
                        },
                    },
                ]
                @php
            }
            else
            {
                @endphp
                buttons: []
                @php
            }
            @endphp
        });
        //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-success');
        btnadd.attr('onclick', "window.location='{{ URL::to($url_menu . '/add/') }}" + "/{{ $_GET['id'] }}" +
            "/?gmenu={{ @$_GET['gmenu'] }}&dmenu={{ @$_GET['dmenu'] }}&tabel={{ @$_GET['tabel'] }}" +
            "'");
        //check authorize button datatables
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>510</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>510</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>511</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>511</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>512</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>512</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>513</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>513</b><br />
 --}}
        // function detail ajax
        function detail(id, gmenu, dmenu, tabel) {
            $.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,
                    tabel: tabel
                },
                success: function (data) {
                // helper parse aman
                const parseArr = (x, fb = []) => Array.isArray(x) ? x : (function(){ try { return JSON.parse(x ?? '[]'); } catch { return fb; } })();

                // 1) Set judul
                $('#label_detail').text('List Detail -> ' + (data.ajaxid ?? ''));

                // 2) Reset DataTable & DOM table
                if ($.fn.DataTable.isDataTable('#list_detail')) {
                    $('#list_detail').DataTable().clear().destroy();
                }
                const $tbl = $('#list_detail');
                $tbl.empty()
                    .append('<thead class="thead-light" style="background-color:#00b7bd4f;"></thead>')
                    .append('<tbody></tbody>');

                // 3) Ambil metadata & rows (PAKAI sumber yang sama untuk header & body!)
                const metaCols   = parseArr(data.table_header_d_ajax);   // <— gunakan ini utk header & render body
                const rows       = parseArr(data.table_detail_d_ajax);
                const primaryDef = parseArr(data.table_primary_d_ajax);

                // 4) Render THEAD (kolom pertama = Action)
                const theadHtml = `<tr>
                    <th>Action</th>
                    ${metaCols.map(c => `<th>${c.alias ?? ''}</th>`).join('')}
                </tr>`;
                $tbl.find('thead').html(theadHtml);

                // 5) Render TBODY
                const bodyHtml = rows.map((row, rIdx) => {
                    // tombol Action
                    const viewUrl = `{{ url($url_menu . '/show/') }}/${data.encrypt_primary?.[rIdx] ?? ''}?gmenu=${gmenu}&dmenu=${dmenu}&tabel=${tabel}`;
                    let actionBtns = `
                    <button type="button" class="btn btn-success mb-0 py-1 px-2" title="View Data"
                            onclick="window.location='${viewUrl}'">
                        <i class="fas fa-eye"></i>
                    </button>
                    `;
                    @if ($authorize->edit == '1')
                    if ((data.status?.status ?? '') !== 'Pending') {
                        const editUrl = `{{ url($url_menu . '/edit/') }}/${data.encrypt_primary?.[rIdx] ?? ''}?gmenu=${gmenu}&dmenu=${dmenu}&tabel=${tabel}`;
                        actionBtns += `
                        <button type="button" class="btn btn-success mb-0 py-1 px-2" title="Edit Data"
                                onclick="window.location='${editUrl}'">
                            <i class="fas fa-edit"></i>
                        </button>
                        `;
                    }
                    @endif

                    // selanjutnya kolom data mengikuti urutan metaCols
                    const dataTds = metaCols.map(col => {
                    const val   = row[col.field];
                    const klass = (col.primary == '1') ? 'bold text-dark' : 'normal';

                    if (col.type === 'enum') {
                        const dict = parseArr(data[col.field]); // array mapping [value,label] (atau objek)
                        let shown = val;
                        if (Array.isArray(dict)) {
                        const found = dict.find(d => Object.values(d)[0] == val);
                        if (found) shown = Object.values(found)[1];
                        }
                        return `<td class="text-sm font-weight-${klass}">${shown ?? ''}</td>`;

                    } else if (col.type === 'join') {
                        const joinRows = parseArr(data.data_join?.[rIdx]);
                        if (col.default === 'image') {
                        const file = Array.isArray(joinRows) && joinRows[0] ? Object.values(joinRows[0])[0] : '';
                        const mid  = (col.field || '').replace(/:/g,'') + rIdx;
                        return `<td class="text-sm font-weight-${klass}">
                            <span class="my-2 text-xs">
                            <img src="{{ asset('/storage') }}/${file}" alt="image" style="height:35px;"
                                data-bs-toggle="modal" data-bs-target="#imageModal${mid}">
                            </span>
                            <div class="modal fade" id="imageModal${mid}" tabindex="-1" aria-hidden="true">
                            <div class="modal-dialog modal-dialog-centered"><div class="modal-content">
                                <div class="modal-header">
                                <h5 class="modal-title">Preview Image</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">
                                    <span aria-hidden="true">&times;</span>
                                </button>
                                </div>
                                <div class="modal-body">
                                <img src="{{ asset('/storage') }}/${file}" class="w-100 border-radius-lg shadow-sm" alt="image">
                                </div>
                            </div></div>
                            </div>
                        </td>`;
                        } else {
                        const shown = Array.isArray(joinRows) && joinRows[0] ? Object.values(joinRows[0])[0] : (val ?? '');
                        return `<td class="text-sm font-weight-${klass}">${shown ?? ''}</td>`;
                        }

                    } else if (col.type === 'image') {
                        const mid = (col.field || '').replace(/:/g,'') + rIdx;
                        return `<td class="text-sm font-weight-${klass}">
                        <span class="my-2 text-xs">
                            <img src="{{ asset('/storage') }}/${val}" alt="image" style="height:35px;"
                                data-bs-toggle="modal" data-bs-target="#imageModal${mid}">
                        </span>
                        <div class="modal fade" id="imageModal${mid}" tabindex="-1" aria-hidden="true">
                            <div class="modal-dialog modal-dialog-centered"><div class="modal-content">
                            <div class="modal-header">
                                <h5 class="modal-title">Preview Image</h5>
                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                                </button>
                            </div>
                            <div class="modal-body">
                                <img src="{{ asset('/storage') }}/${val}" class="w-100 border-radius-lg shadow-sm" alt="image">
                            </div>
                            </div></div>
                        </div>
                        </td>`;

                    } else if (col.type === 'currency') {
                        return `<td class="text-sm font-weight-${klass}">${currencyFormat(val, col.decimals, col.sub)}</td>`;

                    } else {
                        return `<td class="text-sm font-weight-${klass}">${val ?? ''}</td>`;
                    }
                    }).join('');

                    const trFlag = (row.isactive == '0') ? 'class="not" style="background-color:#ffe9ed;"' : '';
                    return `<tr ${trFlag}>
                    <td class="text-sm font-weight-normal">${actionBtns}</td>
                    ${dataTds}
                    </tr>`;
                }).join('');

                $tbl.find('tbody').html(bodyHtml);

                // 6) Init DataTable (pakai selector YANG BENAR)
                const dt = $tbl.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',
                    // exclude kolom Action (pertama) dari export:
                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',
                        exportOptions: { columns: ':visible:not(:first-child)' },
                        customize: function (xlsx) {
                        // cari index kolom "Status" di DT
                        let idxStatus = -1;
                        dt.columns().every(function(i){
                            const title = $(this.header()).text().trim();
                            if (/^status$/i.test(title)) idxStatus = i;
                        });
                        // hitung index di file Excel (karena kolom pertama "Action" TIDAK diexport)
                        const excelIdx = (idxStatus >= 0) ? (idxStatus - 1) : -1;
                        if (excelIdx < 0) return; // tidak ada "Status" → skip

                        // konversi index → huruf kolom Excel (A..Z, AA..)
                        const toXl = (n)=>{ let s='',x=n+1; while(x){ let m=(x-1)%26; s=String.fromCharCode(65+m)+s; x=Math.floor((x-1)/26);} return s; };
                        const colLetter = toXl(excelIdx);

                        const sheet = xlsx.xl.worksheets['sheet1.xml'];
                        // Cari sel di kolom "Status" dan style jika isinya "Not Active"
                        sheet.querySelectorAll(`row c[r^="${colLetter}"]`).forEach((c)=>{
                            const t = c.querySelector('is t, v');
                            const text = t?.textContent ?? '';
                            if (text === 'Not Active') c.setAttribute('s','10');
                        });
                        }
                    },
                    { 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(:first-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(:first-child)' } },
                ]
            });

                // 7) Styling tombol DT
                $('.dt-button').addClass('btn btn-secondary').removeClass('dt-button');

                // 8) Highlight baris saat klik
                $tbl.on('click', 'tbody tr', function(){
                    $tbl.find('tbody tr').css('background-color','');
                    $tbl.find('tbody tr.not').css('background-color','#ffe9ed');
                    $(this).css('background-color','#f9f4ea');
                });

                // 9) Debug cepat mismatch kolom (kalau tn/18 muncul)
                const exp = $tbl.find('thead th').length;
                $tbl.find('tbody tr').each(function(i){
                    const n = $(this).children('td').length;
                    if (n !== exp) console.warn('Row', i, 'td=', n, 'expected=', exp);
                });

                // 10) Tombol Add/Delete (kalau ada)
                const btndel = $('.btn-delete');
                const btnadd = $('.btn-add').parents('.btn-secondary');
                btnadd.removeClass('btn-secondary').addClass('btn btn-success');
                btnadd.attr('onclick', "window.location='{{ URL::to($url_menu . '/add/') }}/" + id + "?gmenu=" + gmenu + "&dmenu=" + dmenu + "&tabel=" + tabel + "'");
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>731</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>731</b><br />
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>732</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>732</b><br />
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>733</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>733</b><br />
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>734</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjsample/resources/views/sample/sblst/list.blade.php</b> on line <b>734</b><br />

                if (dmenu == 'lstsa' || dmenu == 'lstsd') {
                    btnadd.hide(); btndel.hide();
                } else {
                    btnadd.show(); btndel.show();
                }
                },
                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