@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">Laporan Akhir Magang</h5>
                    </div>
                    <hr class="horizontal dark mt-0">
                    <div class="row px-4 py-2">
                        <div class="col">
                            {{-- alert --}}
                            @include('components.alert')
                            
                            {{-- form upload jika belum pernah upload --}}
                            @if (!$laporan)
                                <form action="{{ url($url_menu . '/upload') }}" method="POST">
                                    @csrf
                                    <div class="mb-3">
                                        <label for="dokumen" class="form-label">Link Google Docs Laporan Akhir</label>
                                        <input type="url" class="form-control" name="dokumen" id="dokumen" required>
                                    </div>
                                    <button type="submit" class="btn btn-primary">Upload</button>
                                </form>
                            @else
                                {{-- tampilkan status dan tombol berdasarkan progress terakhir --}}
                                <div class="card mb-3">
                                    <div class="card-body pb-3">
                                        @php
                                            $latestStatus = $history->first();
                                        @endphp

                                       
                                            <form action="{{ url($url_menu . '/update-link') }}" method="POST">
                                                @csrf
                                                <div class="mb-3">
                                                    <label for="dokumen" class="form-label">Link Google Docs Laporan Akhir</label>
                                                    <input type="url" class="form-control" name="dokumen" id="dokumen" value="{{ $laporan->dokumen }}" disabled required>
                                                </div>
                                                @if ($latestStatus && $latestStatus->status == 'Tolak')
                                                <button type="button" class="btn btn-warning" id="edit-link">Edit</button>
                                                <button type="submit" class="btn btn-primary d-none" id="save-link">Save</button>
                                                @endif
                                            </form>
                                        

                                            <div class="mt-3">
                                                <div class="d-flex mb-2">
                                                    <strong class="me-2" style="width: 200px;">Tanggal Upload</strong> 
                                                    <span>: {{ \Carbon\Carbon::parse($laporan->created_at)->format('d-m-Y H:i') }}</span>
                                                </div>
                                            
                                                <div class="d-flex mb-2">
                                                    <strong class="me-2" style="width: 200px;">Terakhir Diperbarui</strong> 
                                                    <span>: {{ \Carbon\Carbon::parse($laporan->updated_at)->format('d-m-Y H:i') }}</span>
                                                </div>
                                            
                                                <div class="d-flex mb-2">
                                                    <strong class="me-2" style="width: 200px;">Status</strong> 
                                                    <span>:
                                                        @if ($latestStatus && $latestStatus->status == 'Pending')
                                                            <span class="badge bg-secondary">Proses Review</span>
                                                        @elseif ($latestStatus && $latestStatus->status == 'Tolak')
                                                            <span class="badge bg-danger">Revisi</span>
                                                        @elseif ($latestStatus && $latestStatus->status == 'Setuju')
                                                            <span class="badge bg-success">Upload File Final</span>
                                                        @elseif ($latestStatus && $latestStatus->status == 'Final')
                                                            <span class="badge bg-primary">Selesai</span>
                                                        @endif
                                                    </span>
                                                </div>
                                            
                                                @if ($latestStatus && $latestStatus->keterangan)
                                                    <div class="d-flex mb-2">
                                                        <strong class="me-2" style="width: 200px;">Keterangan</strong> 
                                                        <span>: {{ $latestStatus->keterangan }}</span>
                                                    </div>
                                                @endif
                                            </div>
                                            

                                        {{-- Jika status Tolak, tampilkan tombol konfirmasi sudah revisi --}}
                                        @if ($latestStatus && $latestStatus->status == 'Tolak')
                                        
                                            <form action="{{ url($url_menu . '/update-status') }}" method="POST" id="revisi-form" class="mt-3">
                                                @csrf
                                                <button type="submit" class="btn btn-info" id="revisi-button">Saya sudah revisi</button>
                                            </form>
                                        @endif

                                        {{-- Jika status Setuju, tampilkan upload file final --}}
                                        @if ($latestStatus && $latestStatus->status == 'Setuju')
                                            
                                                <form action="{{ url($url_menu . '/upload-final') }}" method="POST" enctype="multipart/form-data" class="mt-3 mb-0">
                                                    @csrf
                                                    <div class="mb-3">
                                                        <label for="dokumen_final" class="form-label">Upload File Final (PDF)</label>
                                                        <input type="file" class="form-control" name="dokumen" id="dokumen_final" accept="application/pdf" required>
                                                        <small class="form-text text-muted">
                                                            <i class="fas fa-info-circle"></i> Format: PDF | Ukuran maksimal: <strong class="text-danger">5 MB</strong>
                                                        </small>
                                                    </div>
                                                    <button type="submit" class="btn btn-primary">Upload Final</button>
                                                </form>
                                
                                        @endif

                                        {{-- Jika status Final, tampilkan tombol download --}}
                                        @if ($latestStatus && $latestStatus->status == 'Final')
                                            <p class="mb-2"><strong>File Final:</strong></p>
                                            <div class="d-flex gap-2">
                                                <a href="{{ asset('storage/' . $laporan->dokumen_final) }}" target="_blank" class="btn btn-primary">
                                                    Download File Final
                                                </a>
                                            </div>
                                        @endif
                                    </div>
                                </div>
                            @endif

                            {{-- History Status --}}
                            @if ($history && count($history) > 0)
                                <div class="card mt-3">
                                    <div class="card-header pb-2">
                                        <h6>Riwayat Perubahan Status</h6>
                                    </div>
                                    <div class="card-body pt-2">
                                        <ul class="list-group">
                                            @foreach ($history as $item)
                                                <li class="list-group-item d-flex justify-content-between align-items-center">
                                                    <span>
                                                        @if ($item->status == 'Pending')
                                                            <span class="badge bg-secondary">Proses Review</span>
                                                        @elseif ($item->status == 'Tolak')
                                                            <span class="badge bg-danger">Revisi</span>
                                                        @elseif ($item->status == 'Setuju')
                                                            <span class="badge bg-success">Upload File Final</span>
                                                        @elseif ($item->status == 'Final')
                                                            <span class="badge bg-primary">Selesai</span>
                                                        @endif

                                                        @if ($item->keterangan)
                                                            <span class="ms-2"><strong>Keterangan:</strong> {{ $item->keterangan }}</span>
                                                        @endif
                                                    </span>
                                                    <span>
                                                        <span class="badge 
                                                            @if ($item->status == 'Tolak') bg-danger
                                                            @elseif ($item->status == 'Setuju') bg-success
                                                            @elseif ($item->status == 'Final') bg-primary
                                                            @else bg-secondary
                                                            @endif
                                                        ">
                                                            {{ \Carbon\Carbon::parse($item->created_at)->format('d-m-Y H:i') }}
                                                        </span>
                                                    
                                                        @if ($item->status == 'Tolak' && $item->updated_at != $item->created_at)
                                                            <span class="badge bg-info">
                                                                {{ \Carbon\Carbon::parse($item->updated_at)->format('d-m-Y H:i') }}
                                                            </span>
                                                        @endif
                                                    </span>
                                                    
                                                </li>
                                            @endforeach
                                        </ul>

                                        

                                    </div>
                                    
                                </div>

                                <div class="card mt-3">
                                    <div class="card-header pb-2">
                                        <h6>Keterangan Warna Waktu</h6>
                                    </div>
                                    <div class="card-body pt-2">
                                        <ul style="list-style: none; padding-left: 0;" >
                                            <li class="mb-2"><span class="badge bg-secondary" style="width: 100px;">Abu-abu</span> Waktu dalam proses review</li>
                                            <li class="mb-2"><span class="badge bg-danger" style="width: 100px;">Merah</span> Waktu revisi atau status ditolak</li>
                                            <li class="mb-2"><span class="badge bg-info" style="width: 100px;">Biru Muda</span> Waktu pembaruan status revisi</li>
                                            <li class="mb-2"><span class="badge bg-success" style="width: 100px;">Hijau</span> Waktu status disetujui dan upload file final</li>
                                            <li class="mb-2"><span class="badge bg-primary" style="width: 100px;">Hijau Tua</span> Waktu status final atau selesai</li>
                                        </ul>
                                    </div>
                                </div>
                                
                            @endif

                            

                            <script>
                                document.getElementById('edit-link')?.addEventListener('click', function() {
                                    document.getElementById('dokumen').disabled = false;
                                    document.getElementById('edit-link').classList.add('d-none');
                                    document.getElementById('save-link').classList.remove('d-none');
                                });

                                document.getElementById('revisi-button')?.addEventListener('click', function(event) {
                                    event.preventDefault();
                                    document.getElementById('revisi-form').submit();
                                });

                                // Validasi ukuran file saat memilih file - Pop-up muncul langsung
                                const fileInput = document.getElementById('dokumen_final');
                                const maxSize = 5 * 1024 * 1024; // 5 MB dalam bytes
                                const uploadButton = document.querySelector('button[type="submit"]');

                                if (fileInput) {
                                    // Disable tombol upload saat belum pilih file
                                    if (uploadButton) {
                                        uploadButton.disabled = true;
                                    }

                                    // Event saat memilih file - Pop-up langsung muncul jika melebihi 5 MB
                                    fileInput.addEventListener('change', function(e) {
                                        const file = this.files[0];
                                        
                                        if (file) {
                                            const fileSizeMB = (file.size / 1024 / 1024).toFixed(2);
                                            
                                            // Jika file melebihi 5 MB - Tampilkan pop-up error
                                            if (file.size > maxSize) {
                                                Swal.fire({
                                                    icon: 'error',
                                                    title: 'File Terlalu Besar!',
                                                    html: `
                                                        <div class="text-start">
                                                            <p class="mb-2"><i class="fas fa-file-pdf text-danger"></i> <strong>${file.name}</strong></p>
                                                            <p class="mb-2">Ukuran file: <span class="badge bg-danger">${fileSizeMB} MB</span></p>
                                                            <p class="mb-2">Maksimal: <span class="badge bg-success">5 MB</span></p>
                                                            <hr>
                                                            <p class="text-danger mb-0">
                                                                <i class="fas fa-exclamation-triangle"></i> 
                                                                Silakan pilih file dengan ukuran maksimal 5 MB atau kompres file PDF Anda terlebih dahulu.
                                                            </p>
                                                        </div>
                                                    `,
                                                    confirmButtonColor: '#d33',
                                                    confirmButtonText: 'Pilih File Lain',
                                                    width: '500px'
                                                });
                                                
                                                // Reset input file dan disable tombol upload
                                                this.value = '';
                                                if (uploadButton) {
                                                    uploadButton.disabled = true;
                                                }
                                            } else {
                                                // Jika ukuran valid - Enable tombol upload dan tampilkan info
                                                if (uploadButton) {
                                                    uploadButton.disabled = false;
                                                }
                                                
                                                // Optional: Tampilkan toast sukses
                                                Swal.fire({
                                                    toast: true,
                                                    position: 'top-end',
                                                    icon: 'success',
                                                    title: `File dipilih: ${file.name} (${fileSizeMB} MB)`,
                                                    showConfirmButton: false,
                                                    timer: 3000,
                                                    timerProgressBar: true
                                                });
                                            }
                                        } else {
                                            // Tidak ada file dipilih
                                            if (uploadButton) {
                                                uploadButton.disabled = true;
                                            }
                                        }
                                    });
                                }
                            </script>
                        </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 = $('#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/trlpak/list.blade.php</b> on line <b>406</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>406</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>407</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>407</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>408</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>408</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>409</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>409</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/trlpak/list.blade.php</b> on line <b>660</b><br />
<br />
<b>Warning</b>:  Attempt to read property "add" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>660</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>661</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>661</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>662</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>662</b><br />
                    <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>663</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/transc/trlpak/list.blade.php</b> on line <b>663</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