@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])
{{-- section content --}}
@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="row">
                            <div class="card-header col-md-auto">
                                <h5 class="mb-0">List {{ $title_menu }}</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="col-lg">
                                <div class="nav-wrapper">
                                    {{-- check authorize add --}}
                                    @if ($authorize->add == '1')
                                        {{-- button add --}}
                                        <button class="btn btn-primary mb-0"
                                            onclick="window.location='{{ URL::to($url_menu . '/add') }}'"><i
                                                class="fas fa-plus me-1"> </i><span class="font-weight-bold">Tambah</button>

                                        <button class="btn btn-info mb-0"
                                            onclick="window.location='{{ URL::to('trmmat' . '/add') }}'"><i
                                                class="fas fa-copy me-1"> </i><span class="font-weight-bold">Tambah
                                                Multiple</button>
                                    @endif
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}" data-order='[[ 20, "desc" ]]'>
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th>Action</th>
                                            {{-- <th>No</th> --}}
                                            {{-- retrieve table header --}}
                                            {{-- @foreach ($table_header as $header)
                                                <th>{{ $header->alias }}</th>
                                            @endforeach --}}
                                            <th>Kode Baru FG</th>
                                            <th>ID Material Grup</th>
                                            <th>Customer</th>
                                            <th>Product Name</th>
                                            <th>Division</th>
                                            <th>Mat G1</th>
                                            <th>Mat G2</th>
                                            <th>Mat G3</th>
                                            <th>Length</th>
                                            <th>Keterangan</th>
                                            <th>Alt UOM</th>
                                            <th>Top Load</th>
                                            <th>Width</th>
                                            <th>Weight</th>

                                            <th>Status</th>
                                            <th style="display:none;">Status Value</th>
                                            <th style="display:none;">Download Type</th>
                                            <th style="display:none;">Download Subtype</th>
                                            <th>Created By</th>
                                            <th>Created At</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {{-- retrieve table detail --}}
                                        @foreach ($table_detail as $detail)
                                            @php
                                                $primary = '';
                                                foreach ($table_primary as $p) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$p->field})
                                                        : ($primary = $primary . ':' . $detail->{$p->field});
                                                }
                                                $vcount = $loop->iteration;
                                                $isAdmin = in_array(session('user')->idroles ?? '', ['admins']);
                                                $isCreator = session('username') == $detail->user_create;
                                                $currentRole = strtolower(session('user')->idroles ?? '');
                                                $canDuplicateAny = in_array($currentRole, ['admins', 'userss']);
                                                $canEditDelete = $isAdmin || $isCreator;

                                                $rowClass = '';
                                                if ($detail->isactive == '0') {
                                                    $rowClass = 'row-inactive';
                                                } elseif ($detail->status == '3') {
                                                    $rowClass = 'row-status-3';
                                                }
                                            @endphp
                                            <tr class="{{ $rowClass }}">
                                                <td class="text-sm font-weight-normal">
                                                    <div class="btn-group dropright">
                                                        <button type="button" class="btn btn-primary btn-sm px-4"
                                                            onclick="window.location='{{ url($url_menu . '/show/' . encrypt($detail->id)) }}'">
                                                            <i class="fas fa-eye"></i> View
                                                        </button>
                                                        @php
                                                            $showEdit =
                                                                $authorize->edit == '1' &&
                                                                $canEditDelete &&
                                                                ($detail->status_value == '0' ||
                                                                    ($isAdmin && $detail->status_value == '1'));
                                                            $showHapus =
                                                                $authorize->delete == '1' &&
                                                                $canEditDelete &&
                                                                $detail->status_value == '0';
                                                            $showDuplikat =
                                                                $authorize->add == '1' &&
                                                                ($canEditDelete || $canDuplicateAny);
                                                            $showDropdown = $showEdit || $showHapus || $showDuplikat;
                                                        @endphp

                                                        @if ($showDropdown)
                                                            <button type="button"
                                                                class="btn btn-primary btn-sm dropdown-toggle dropdown-toggle-split px-3"
                                                                data-bs-toggle="dropdown" aria-expanded="false">
                                                                <span class="sr-only">Toggle Dropdown</span>
                                                            </button>
                                                            <div class="dropdown-menu">
                                                                @if ($showEdit)
                                                                    <a class="dropdown-item"
                                                                        onclick="window.location='{{ url($url_menu . '/edit/' . encrypt($detail->id)) }}'"
                                                                        style="cursor: pointer;">
                                                                        <i class="fas fa-edit"></i> <span>Edit</span>
                                                                    </a>
                                                                @endif

                                                                @if ($showDuplikat)
                                                                    <a class="dropdown-item"
                                                                        onclick="window.location='{{ url($url_menu . '/copy/' . encrypt($detail->id)) }}'"
                                                                        style="cursor: pointer;">
                                                                        <i class="fas fa-copy"></i> <span>Duplikat</span>
                                                                    </a>
                                                                @endif

                                                                @if ($showHapus)
                                                                    <form
                                                                        onsubmit="return deleteData(event,'{{ $primary }}','Hapus', '{{ $detail->kode_baru_fg }}', '{{ $detail->length }}')"
                                                                        action="{{ url($url_menu . '/' . encrypt($primary)) }}"
                                                                        method="POST" style="display: inline">
                                                                        @csrf
                                                                        @method('DELETE')
                                                                        <button type="submit"
                                                                            class="dropdown-item text-danger"
                                                                            style="cursor: pointer;">
                                                                            <i class="fas fa-trash"></i>
                                                                            <span>Hapus</span>
                                                                        </button>
                                                                    </form>
                                                                @endif
                                                            </div>
                                                        @endif
                                                    </div>
                                                </td>
                            </div>
                            </td>
                            {{-- <td>{{ $vcount }}</td> --}}
                            <td> {{ $detail->kode_baru_fg }}</td>
                            <td> {{ $detail->id_mat_group }}</td>
                            <td> {{ $detail->customer }}</td>
                            <td> {{ $detail->product_name }}</td>
                            <td> {{ $detail->division }}</td>
                            <td> {{ $detail->mat_g1 }}</td>
                            <td> {{ $detail->mat_g2 }}</td>
                            <td> {{ $detail->mat_g3 }}</td>
                            <td> {{ $detail->length }}</td>
                            <td> {{ $detail->keterangan }}</td>
                            <td> {{ $detail->alt_uom }}</td>
                            <td> {{ $detail->top_load }}</td>
                            <td> {{ $detail->width }}</td>
                            <td> {{ $detail->weight }}</td>

                            <td> {{ $detail->status_name }}</td>
                            <td style="display:none;">{{ $detail->status_value }}</td>
                            <td style="display:none;">{{ $detail->download_type ?? '3' }}</td>
                            <td style="display:none;">{{ $detail->download_subtype ?? '' }}</td>
                            <td> {{ $detail->user_create }}</td>
                            <td> {{ $detail->created_at }}</td>

                            </tr>
                            @endforeach
                            </tbody>
                            </table>
                        </div>
                    </div>
                    <div class="row px-4 py-2">
                        <div class="col-lg">
                            <div class="nav-wrapper">
                                <code>
                                    Note :
                                    <i aria-hidden="true" style="color:#ffc2cd;" class="fas fa-circle"></i>
                                    Data not active
                                </code>
                            </div>

                            <div class="nav-wrapper">
                                <code>
                                    <span style="color: transparent;">Note :</span>
                                    <i aria-hidden="true" style="color:#FFF9C4;" class="fas fa-circle"></i>
                                    Data Sedang di Proses
                                </code>
                            </div>
                        </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 src="https://cdn.jsdelivr.net/npm/exceljs@4.0.0/dist/exceljs.min.js"></script>

    <script>
        function decodeHTMLEntities(text) {
            const textarea = document.createElement('textarea');
            textarea.innerHTML = text;
            return textarea.value;
        }

        function copyAndRedirect(data) {
            // Simpan data ke sessionStorage

            console.log('data', data);

            sessionStorage.setItem('copiedData', JSON.stringify(data));

            // Redirect ke halaman add
            window.location.href = '/trmmat/add';
        }

        let columnAbjad = '';
        var idroles = <br />
<b>Warning</b>:  Undefined variable $user_login in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>259</b><br />
<br />
<b>Warning</b>:  Attempt to read property "idroles" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>259</b><br />
null;

        //asli
        // function countM(length, width, gramature) {
        //     let result = length * calculateRoll(length, width, gramature);
        //     let scale = Math.pow(10, Math.max(0, result.toString().length - 5));
        //     let roundedResult = Math.round(result / scale);
        //     return roundedResult;
        // }

        function countM(length, width, gramature) {
            let result = length * calculateRoll(length, width, gramature);
            let len = result.toFixed(0).toString().length;
            let bagipangkat = Math.max(0, len - 5); // maksimal kalau 6 digit → bagi 10
            let hasilbagi = result / Math.pow(10, bagipangkat);

            return Math.round(hasilbagi);
        }


        // function countWeightM(length, width, gramature) {
        //     m = countM(length, width, gramature);
        //     weight1 = ((length * width * gramature) / 1000).toFixed(2);
        //     if (weight1 < 0.01) {
        //         weight1 = 0.01;
        //     }
        //     return Math.round(((m / length) * weight1), 0);
        // }

        function countWeightM(length, width, gramature) {
            let m = countM(length, width, gramature); // Asumsi: total meter
            let weight1 = roundWeightToTwoDecimals(length * width * gramature / 1000);

            if (weight1 < 0.01) {
                weight1 = 0.01;
            }

            // Gunakan Math.round langsung ke hasil akhir
            return Math.round((m / length) * weight1);
        }


        function countM2(length, width, gramature) {
            let rawResult = length * width * calculateRoll(length, width, gramature);
            let result = Number.isInteger(rawResult) ? rawResult :
                (rawResult.toFixed(2).slice(-1) === '0' ?
                    (rawResult.toFixed(1).slice(-1) === '0') ? rawResult.toFixed(0) : rawResult.toFixed(1) :
                    rawResult.toFixed(2)
                );


            let scale = Math.pow(10, Math.max(0, result.toString().length - 5));
            let roundedResult = Math.round(result / scale);
            return roundedResult;
        }

        // asli
        // function checkDenums(length, width, gramature) {
        //     weight1 = ((length * width * gramature) / 1000).toFixed(2);
        //     if (weight1 < 0.01) {
        //         weight1 = 0.01;
        //     }
        //     checkDenum = 0;
        //     if (!Number.isInteger(weight1)) {
        //         if (weight1 < 100) {
        //             checkDenum = 1000
        //         } else if (weight1 < 1000) {
        //             checkDenum = 100
        //         } else if (weight < 10000) {
        //             checkDenum = 10
        //         } else {
        //             checkDenum = 1
        //         }
        //     } else {
        //         checkDenum = 1
        //     }

        //     return checkDenum;
        // }


        function checkDenums(length, width, gramature) {
            let weight = roundWeightToTwoDecimals(length * width * gramature / 1000);

            if (weight < 0.01) {
                weight = 0.01;
            }

            let checkDenum = 1; // default

            if (!Number.isInteger(weight)) {
                if (weight < 100) {
                    checkDenum = 1000;
                } else if (weight < 1000) {
                    checkDenum = 100;
                } else if (weight < 10000) {
                    checkDenum = 10;
                } else {
                    checkDenum = 1;
                }
            }

            // console.log('weight1', checkDenum, weightparse, weight1);
            return checkDenum;
        }
        //ini last asli
        // function calculateWeightRoll(length, width, gramature, uom, weightbl) {

        //     weight1 = ((length * width * gramature) / 1000).toFixed(2);
        //     if (weight1 < 0.01) {
        //         weight1 = 0.01;
        //     }
        //     if (
        //         uom === 'BAL' ||
        //         uom === 'BOX' ||
        //         uom === 'BL1' ||
        //         uom === 'BL2' ||
        //         uom === 'BL3' ||
        //         uom === 'BL4' ||
        //         uom === 'BL5'
        //     ) {
        //         weight1 = weightbl;
        //     }

        //     checkDenum = checkDenums(length, width, gramature);
        //     let result = checkDenum * weight1;
        //     let resultText = result.toString();
        //     let lastChar = resultText.charAt(resultText.length - 1);
        //     if (!Number.isInteger(weight1)) {
        //         if (lastChar === '0') {
        //             const innerValue = result / 10;
        //             const innerValueText = innerValue.toString();
        //             const innerLastChar = innerValueText.slice(-1);

        //             if (innerLastChar === "0") {
        //                 return innerValue / 10;
        //             } else {
        //                 return Math.round(innerValue);
        //             }
        //         } else {
        //             return Math.round(resultText);
        //         }
        //     } else {
        //         if (lastChar === "0") {
        //             return result / 10;
        //         } else {
        //             return Math.round(resultText);
        //         }
        //     }
        // }
        function multiplyAndFix(a, b, precision = 0) {
            return Math.round((a * b + Number.EPSILON) * Math.pow(10, precision)) / Math.pow(10, precision);
        }

        function roundWeightToTwoDecimals(value) {
            return Math.floor((Number(value) * 100) + 0.5 + 1e-9) / 100;
        }

        //update 
        function calculateWeightRoll(length, width, gramature, uom, weightbl) {

            // weight1 = parseFloat(((length * width * gramature) / 1000).toFixed(2));
            // weight1 = Math.round((length * width * gramature / 1000) * 100) / 100;
            // weight1 = Math.ceil((length * width * gramature / 1000) * 100) / 100;
            // let weight1 = ((length * width * gramature) / 1000).toFixed(2);
            let weight1 = roundWeightToTwoDecimals(length * width * gramature / 1000);
            weightparse = parseFloat(weight1);

            if (weight1 < 0.01) {
                weight1 = 0.01;
            }
            if (uom === 'BAL' || uom === 'BOX' || uom === 'BL1' || uom === 'BL2' || uom === 'BL3' || uom === 'BL4' ||
                uom === 'BL5'
            ) {
                weight1 = weightbl;
            }

            checkDenum = checkDenums(length, width, gramature);

            roll = calculateRoll(length, width, gramature, uom, weightbl)

            let result = checkDenum * weight1; // 60
            let resultfix = multiplyAndFix(checkDenum, weight1);
            let resultText = result.toString();
            // let lastChar = resultText.charAt(resultText.length - 1); // 6"0"
            let lastChar = String(resultfix).slice(-1);

            // console.log('weightroll', weight1, roll, result, resultfix, lastChar);
            if (!Number.isInteger(weight1)) { // 60.00
                if (lastChar === '0') {

                    var innerValue = 0;
                    if (checkDenum === 1) {
                        innerValue = resultfix;
                    } else {
                        innerValue = resultfix / 10;
                        const innerValueText = innerValue.toString(); // "60"
                        const innerLastChar = innerValueText.slice(-1); // 6"0"
                        if (innerLastChar === "0") {
                            innerValue = innerValue / 10;
                        }
                    }
                    return Math.round(innerValue); // 6



                    console.log('integer', weight1, roll, innerValue, lastChar);
                    // return result;
                } else {


                    return result;

                }
            } else {
                if (lastChar === "0" && roll != "1") {
                    return result / 10;
                } else {
                    return Math.round(resultText);
                }
            }
            // console.log('weightroll', checkDenum, weight1, result, resultfix);

            // console.log('weightroll', );

        }





        //asli
        // function calculateRoll(length, width, gramature) {

        //     weight1 = ((length * width * gramature) / 1000).toFixed(2);
        //     if (weight1 < 0.01) {
        //         weight1 = 0.01;
        //     }
        //     checkDenum = checkDenums(length, width, gramature);

        //     if (!Number.isInteger(weight1)) {
        //         let resultText = (checkDenum * weight1).toFixed(0);
        //         let lastChar = resultText.charAt(resultText.length - 1);
        //         let result = (checkDenum * weight1).toFixed(0);
        //         if (lastChar === '0') {
        //             const adjustedValue = result / 10;
        //             const adjustedValueText = adjustedValue.toString();
        //             const adjustedLastChar = adjustedValueText.slice(-1);

        //             if (adjustedLastChar === "0") {
        //                 return checkDenum / 10 / 10;
        //             } else {
        //                 return checkDenum / 10;
        //             }
        //         } else {
        //             return checkDenum;
        //         }
        //     } else {
        //         return checkDenum;
        //     }
        // }


        // kolom ROLL
        function calculateRoll(length, width, gramature, uom, weightbl) {

            const rawWeight = (length * width * gramature) / 1000;
            let weight1 = roundWeightToTwoDecimals(rawWeight);
            if (uom === 'BAL' || uom === 'BOX' || uom === 'BL1' || uom === 'BL2' || uom === 'BL3' || uom === 'BL4' ||
                uom === 'BL5') {
                weight1 = weightbl;
            }

            if (weight1 < 0.01) {
                weight1 = 0.01;
            }

            let checkDenum = checkDenums(length, width, gramature);
            console.log('denum', checkDenum, weight1);


            if (!Number.isInteger(weight1)) {
                let resultText = (checkDenum * weight1).toFixed(0); // jadi string
                let lastCharfixed = resultText.charAt(resultText.length);
                let lastChar = resultText.charAt(resultText.length - 1);


                if (lastChar === '0') {
                    const adjustedValue = parseInt(resultText) / 10;
                    const adjustedValueText = adjustedValue.toString();
                    const adjustedLastChar = adjustedValueText.slice(-1);

                    if (adjustedLastChar === "0") {
                        checkDenum = checkDenum / 100;
                        // return checkDenum / 100; // dua kali bagi 10
                    } else {
                        checkDenum = checkDenum / 10;
                        // return checkDenum / 10;
                    }
                    // console.log('denum', checkDenum, weight1, resultText, lastChar);

                } else {
                    checkDenum = checkDenum;
                    // return checkDenum;
                }
            } else {
                // console.log('not integer', checkDenum, weight1);

                checkDenum = checkDenum;
            }
            return checkDenum;

        }



        // $(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);
        //         }
        //     }
        //     var tableDetail = JSON.parse(
        //         `{!! json_encode($table_detail) !!}`);
        //     console.log('tabeldetail', tableDetail);
        //     //check note
        //     if ($('*').hasClass('exp')) {
        //         $('#noted').html(`<code>Note :( <i aria-hidden="true" style="color: #ffc2cd;"
    //         class="fas fa-circle"></i> Data not active ), ( <i aria-hidden="true"
    //         style="color: #ffe768;" class="fas fa-circle"></i> ` + $('#datenote').text() + ` )</code>`)
        //     }
        //     if ($('*').hasClass('stock')) {
        //         $('#noted').html(`<code>Note :( <i aria-hidden="true" style="color: #ffc2cd;"
    //         class="fas fa-circle"></i> Data not active ), ( <i aria-hidden="true"
    //         style="color: #f93c3c;" class="fas fa-circle"></i> ` + $('#stocknote').text() + ` )</code>`)
        //     }
        //     if ($('*').hasClass('exp') && $('*').hasClass('stock')) {
        //         $('#noted').html(`<code>Note :( <i aria-hidden="true" style="color: #ffc2cd;"
    //         class="fas fa-circle"></i> Data not active ), ( <i aria-hidden="true"
    //         style="color: #ffe768;" class="fas fa-circle"></i> ` + $('#datenote').text() + ` ), ( <i aria-hidden="true"
    //         style="color: #f93c3c;" class="fas fa-circle"></i> ` + $('#stocknote').text() + ` )</code>`)
        //     }
        // });

        // let buttons = [];

        $(document).ready(function() {
            initValidationButton();
        });

        function initValidationButton() {
            setTimeout(function() {
                let btn = $('#btnSudahUpload');

                if (btn.length === 0) {
                    btn = $('.btn-success').filter(function() {
                        return $(this).text().includes('Sudah Upload');
                    });
                }

                if (btn.length > 0) {
                    btn.off('click').on('click', function(e) {
                        e.preventDefault();
                        e.stopPropagation();
                        handleSudahUploadClick();
                        return false;
                    });
                }
            }, 1000);
        }

        async function handleSudahUploadClick() {
            try {
                const tableSelector = '#list_{{ $dmenu }}';

                if (!$.fn.DataTable.isDataTable(tableSelector)) {
                    Swal.fire({
                        title: 'Error',
                        text: 'Tabel tidak ditemukan',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                const table = $(tableSelector).DataTable();
                let materialsToCheck = [];

                table.rows().every(function() {
                    const row = this.data();
                    const statusValue = row[16];

                    if (statusValue === '3') {
                        materialsToCheck.push({
                            kode_baru_fg: row[1],
                            length: row[9],
                            alt_uom: row[11]
                        });
                    }
                });

                if (materialsToCheck.length === 0) {
                    Swal.fire({
                        title: 'Tidak Ada Data',
                        text: 'Tidak ada material yang bisa di upload',
                        icon: 'info',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                const selection = await confirmDifferentDownloader(materialsToCheck);
                if (!selection) {
                    return;
                }

                materialsToCheck = selection.materials;

                if (materialsToCheck.length === 0) {
                    Swal.fire({
                        title: 'Tidak Ada Material Dipilih',
                        text: 'Semua material diabaikan dan tidak ada data yang diupdate.',
                        icon: 'info',
                        confirmButtonColor: '#028284'
                    });
                    return;
                }

                Swal.fire({
                    title: 'Memvalidasi Material',
                    html: `
                <p style="margin-bottom: 20px;">Sedang mengecek ${materialsToCheck.length} material di SAP</p>
                <div style="background: #f5f5f5; padding: 15px; border-radius: 5px;">
                    <div style="background: #fff; height: 30px; border-radius: 3px; overflow: hidden; margin-bottom: 10px;">
                        <div id="progress-bar" style="width: 0%; height: 100%; background: #028284; display: flex; align-items: center; justify-content: center; color: white; font-size: 14px; transition: width 0.3s;">0%</div>
                    </div>
                    <p style="margin: 5px 0; font-size: 14px; color: #666;" id="progress-text">Memulai validasi...</p>
                    <p style="margin: 5px 0; font-size: 13px; color: #999;" id="progress-count">0 dari ${materialsToCheck.length}</p>
                </div>
            `,
                    allowOutsideClick: false,
                    allowEscapeKey: false,
                    showConfirmButton: false,
                    didOpen: () => {
                        setTimeout(() => {
                            checkMaterialsInSAP(materialsToCheck);
                        }, 150);
                    }
                });

            } catch (error) {
                Swal.fire({
                    title: 'Error',
                    text: 'Terjadi kesalahan: ' + error.message,
                    icon: 'error',
                    confirmButtonColor: '#028284'
                });
            }
        }

        async function confirmDifferentDownloader(materials) {
            try {
                const response = await fetch(`{{ route('tr_mtr.check-upload-downloader') }}`, {
                    method: 'POST',
                    headers: {
                        'Accept': 'application/json',
                        'Content-Type': 'application/json',
                        'X-CSRF-TOKEN': document.querySelector('meta[name="csrf-token"]').getAttribute(
                            'content')
                    },
                    body: JSON.stringify({
                        materials
                    })
                });

                if (!response.ok) {
                    throw new Error('Pemeriksaan pengguna download gagal.');
                }

                const result = await response.json();
                const escapeHtml = value => $('<div>').text(value ?? '').html();
                const groupMap = new Map();
                result.materials.forEach((material, index) => {
                    const key = material.log_id ?? `legacy-${index}`;
                    if (!groupMap.has(key)) {
                        groupMap.set(key, {
                            logId: material.log_id,
                            downloader: material.it_download || '-',
                            ownedByCurrentUser: material.owned_by_current_user,
                            materials: []
                        });
                    }
                    groupMap.get(key).materials.push(material);
                });
                const logGroups = Array.from(groupMap.values());
                const rows = logGroups.map((group, groupIndex) => {
                    const header = `<tr class="log-group-header ${group.ownedByCurrentUser ? 'log-owned' : 'log-other'}" data-group-index="${groupIndex}">
                        <td class="text-center"><input type="checkbox" class="upload-log-check" ${group.ownedByCurrentUser ? 'checked' : ''}></td>
                        <td colspan="6"><strong>${group.logId ? `Log ${escapeHtml(group.logId)}` : 'Log Lama'}</strong><span class="log-divider">|</span> IT Download: <strong>${escapeHtml(group.downloader)}</strong><span class="log-divider">|</span> Status: <strong>Sedang di Proses</strong><span class="log-count">${group.materials.length} material</span></td>
                    </tr>`;
                    const details = group.materials.map(material => `<tr class="log-material-row ${group.ownedByCurrentUser ? 'material-owned' : 'material-other'}">
                        <td></td><td><span class="material-code">${escapeHtml(material.kode_baru_fg)}</span></td>
                        <td>${escapeHtml(material.customer || '-')}</td><td class="text-end">${escapeHtml(material.length)}</td>
                        <td class="text-center"><span class="uom-badge">${escapeHtml(material.alt_uom)}</span></td>
                        <td class="material-note">${escapeHtml(material.keterangan || '-')}</td><td><span class="status-badge">Sedang di Proses</span></td>
                    </tr>`).join('');
                    return header + details;
                }).join('');

                const ownedCount = logGroups.filter(group => group.ownedByCurrentUser).length;
                const otherCount = logGroups.length - ownedCount;

                const confirmation = await Swal.fire({
                    title: 'Konfirmasi Sudah Upload',
                    html: `<style>
                        .upload-summary{display:flex;gap:10px;flex-wrap:wrap;margin-bottom:14px;text-align:left}.upload-summary-item{display:flex;align-items:center;gap:8px;padding:8px 12px;border:1px solid #e5e7eb;border-radius:10px;background:#fff;font-size:13px;color:#475569}.upload-summary-item strong{font-size:14px;color:#0f172a}.upload-summary-item.login{margin-left:auto;background:#f0fdfa;border-color:#99f6e4;color:#0f766e}
                        .upload-table-wrap{max-height:440px;overflow:auto;border:1px solid #dbe3ea;border-radius:12px;box-shadow:0 2px 8px rgba(15,23,42,.06)}.upload-table{font-size:12px;vertical-align:middle}.upload-table thead th{position:sticky;top:0;z-index:2;padding:11px 9px!important;background:#0f766e!important;color:#fff!important;border-color:#0d9488!important;white-space:nowrap;text-transform:uppercase;font-size:10px;letter-spacing:.04em}.upload-table tbody td{padding:10px 9px!important;border-color:#e5e7eb!important}.upload-table tbody tr:hover td{background:#f8fafc}.upload-table .material-other td{background:#fffbeb}.upload-table .material-other:hover td{background:#fef3c7}
                        .material-code{display:inline-block;padding:4px 7px;border-radius:6px;background:#ecfeff;color:#155e75;font-family:monospace;font-weight:700;white-space:nowrap}.uom-badge{display:inline-block;min-width:34px;padding:3px 7px;border-radius:999px;background:#eef2ff;color:#4338ca;font-weight:700}.status-badge{display:inline-block;padding:4px 8px;border-radius:999px;background:#fff7ed;color:#c2410c;white-space:nowrap;font-weight:600}.it-badge{display:inline-block;padding:4px 8px;border-radius:999px;white-space:nowrap;font-weight:600}.it-badge.is-current{background:#dcfce7;color:#166534}.it-badge.is-other{background:#fee2e2;color:#991b1b}.material-note{min-width:130px;max-width:220px;white-space:normal}.upload-check-wrap{display:inline-flex;align-items:center;gap:7px;padding:6px 10px;border-radius:8px;background:#f1f5f9;color:#475569;font-size:11px;font-weight:700;cursor:pointer;white-space:nowrap}.upload-check-wrap:has(input:checked){background:#dcfce7;color:#166534}.upload-check-wrap input,.check-all-wrap input{width:16px;height:16px;accent-color:#16a34a}.check-all-wrap{display:inline-flex;align-items:center;gap:7px;cursor:pointer;margin:0;white-space:nowrap;font-weight:700}
                        .log-group-header td{padding:9px!important;background:#e2e8f0!important;color:#334155;border-top:2px solid #94a3b8!important}.log-group-header.log-owned td{background:#d1fae5!important;color:#065f46}.log-group-header.log-other td{background:#fef3c7!important;color:#92400e}.upload-log-check{width:18px;height:18px;accent-color:#16a34a}.log-divider{margin:0 9px;color:#94a3b8}.log-count{float:right;padding:2px 8px;border-radius:999px;background:rgba(255,255,255,.65);font-size:10px}.log-material-row td:first-child{border-right:2px solid #cbd5e1!important}
                        .upload-help{display:flex;align-items:flex-start;gap:8px;margin-top:12px;padding:10px 12px;border-radius:9px;background:#f8fafc;color:#64748b;font-size:12px;text-align:left}.upload-help i{margin-top:2px;color:#028284}.override-reason{margin-top:12px;text-align:left;padding:12px;border:1px solid #fecaca;border-radius:9px;background:#fff7f7}.override-reason label{display:block;margin-bottom:6px;font-size:13px;font-weight:700;color:#991b1b}.override-reason textarea{width:100%;min-height:80px;resize:vertical}.override-reason small{color:#64748b}@media(max-width:768px){.upload-summary-item.login{margin-left:0}.upload-table-wrap{max-height:55vh}}
                    </style>
                        <div class="upload-summary">
                            <div class="upload-summary-item"><i class="fas fa-layer-group text-info"></i><span>Total log <strong>${logGroups.length}</strong></span></div>
                            <div class="upload-summary-item"><i class="fas fa-check-circle text-success"></i><span>Log dipilih <strong>${ownedCount}</strong></span></div>
                            <div class="upload-summary-item"><i class="fas fa-user-clock text-warning"></i><span>Log user lain <strong>${otherCount}</strong></span></div>
                            <div class="upload-summary-item login"><i class="fas fa-user"></i><span>Login: <strong>${escapeHtml(result.current_user)}</strong></span></div>
                        </div>
                        <div class="upload-table-wrap">
                        <table class="table table-bordered text-start mb-0 upload-table">
                            <thead><tr><th><label class="check-all-wrap"><input type="checkbox" id="upload-check-all"></label></th><th>Material</th><th>Customer</th><th>Length</th><th>UOM</th><th>Keterangan</th><th>Status</th></tr></thead>
                            <tbody>${rows}</tbody>
                        </table></div>
                        <div class="upload-help"><i class="fas fa-info-circle"></i><span>Log yang <strong>dicentang</strong> akan dicek ke SAP dan seluruh material di dalamnya dilanjutkan. Log yang tidak dicentang akan <strong>diabaikan</strong> dan tetap pending. Untuk log user lain, IT Konfirm mengikuti IT Download.</span></div>
                        <div id="override-reason-wrap" class="override-reason" style="display:none">
                            <label for="override-reason">Alasan melanjutkan proses milik IT Download lain <span class="text-danger">*</span></label>
                            <textarea id="override-reason" class="form-control" maxlength="1000" placeholder="Tuliskan alasan Anda melanjutkan proses ini"></textarea>
                            <small>Wajib diisi karena username login berbeda dengan IT Download.</small>
                        </div>`,
                    showCancelButton: true,
                    confirmButtonText: 'Lanjutkan Update',
                    cancelButtonText: 'Batal',
                    confirmButtonColor: '#028284',
                    cancelButtonColor: '#6c757d',
                    allowOutsideClick: false,
                    width: '1200px',
                    didOpen: () => {
                        const container = $(Swal.getHtmlContainer());
                        const checkAll = container.find('#upload-check-all');
                        const rowChecks = container.find('.upload-log-check');
                        const reasonWrap = container.find('#override-reason-wrap');

                        const syncCheckAll = () => {
                            const checkedCount = rowChecks.filter(':checked').length;
                            checkAll.prop('checked', checkedCount === rowChecks.length);
                            checkAll.prop('indeterminate', checkedCount > 0 && checkedCount < rowChecks
                                .length);
                            const hasOtherLog = rowChecks.filter(':checked').toArray().some(check =>
                                !logGroups[Number($(check).closest('tr').attr('data-group-index'))]
                                    .ownedByCurrentUser
                            );
                            reasonWrap.toggle(hasOtherLog);
                        };

                        checkAll.on('change', function() {
                            rowChecks.prop('checked', this.checked);
                            syncCheckAll();
                        });
                        rowChecks.on('change', syncCheckAll);
                        syncCheckAll();
                    },
                    preConfirm: () => {
                        const container = $(Swal.getHtmlContainer());
                        const selectedChecks = container.find('.upload-log-check:checked');
                        const hasOtherLog = selectedChecks.toArray().some(check =>
                            !logGroups[Number($(check).closest('tr').attr('data-group-index'))]
                                .ownedByCurrentUser
                        );
                        const overrideReason = container.find('#override-reason').val().trim();

                        if (hasOtherLog && !overrideReason) {
                            Swal.showValidationMessage('Alasan wajib diisi untuk melanjutkan proses milik IT Download lain.');
                            return false;
                        }

                        const selected = selectedChecks.map(function() {
                            const group = logGroups[Number($(this).closest('tr').attr(
                                'data-group-index'))];
                            return group.materials.map(material => ({
                                kode_baru_fg: material.kode_baru_fg,
                                length: material.length,
                                alt_uom: material.alt_uom,
                                log_detail_id: material.log_detail_id,
                                confirm_as_downloader: !group.ownedByCurrentUser,
                                override_reason: !group.ownedByCurrentUser ? overrideReason : null
                            }));
                        }).get().flat();
                        return {
                            materials: selected
                        };
                    }
                });

                return confirmation.isConfirmed ? confirmation.value : null;
            } catch (error) {
                await Swal.fire({
                    title: 'Pemeriksaan Gagal',
                    text: error.message,
                    icon: 'error',
                    confirmButtonColor: '#028284'
                });
                return null;
            }
        }

        async function checkMaterialsInSAP(materials) {
            try {
                const apiUrl = @json(env('API_ALT_UOM'));

                let foundInSAP = [];
                let notFoundInSAP = [];
                let errorMaterials = [];

                const total = materials.length;

                for (let i = 0; i < materials.length; i++) {
                    const material = materials[i];

                    try {
                        const progressText = document.getElementById('progress-text');
                        if (progressText) {
                            progressText.textContent = `Mengecek: ${material.kode_baru_fg}`;
                        }

                        const response = await fetch(apiUrl + material.kode_baru_fg);

                        if (!response.ok) {
                            throw new Error(`HTTP ${response.status}`);
                        }

                        const data = await response.json();

                        const existingMaterial = data.ET_MARD.find(item =>
                            item.MATNR === material.kode_baru_fg &&
                            item.MEINH === material.alt_uom &&
                            item.LAENG == material.length
                        );

                        if (existingMaterial) {
                            foundInSAP.push({
                                ...material,
                                sapData: existingMaterial
                            });

                            if (progressText) {
                                progressText.textContent = `✓ ${material.kode_baru_fg} - Ditemukan di SAP`;
                            }
                        } else {
                            notFoundInSAP.push(material);

                            if (progressText) {
                                progressText.textContent = `✗ ${material.kode_baru_fg} - Tidak ditemukan di SAP`;
                            }
                        }

                    } catch (error) {
                        errorMaterials.push({
                            ...material,
                            error: error.message
                        });

                        const progressText = document.getElementById('progress-text');
                        if (progressText) {
                            progressText.textContent = `! ${material.kode_baru_fg} - Error`;
                        }
                    }

                    // Update progress bar
                    const processed = i + 1;
                    const percentage = Math.round((processed / total) * 100);

                    const progressBar = document.getElementById('progress-bar');
                    const progressCount = document.getElementById('progress-count');

                    if (progressBar) {
                        progressBar.style.width = percentage + '%';
                        progressBar.textContent = percentage + '%';
                    }

                    if (progressCount) {
                        progressCount.textContent = `${processed} dari ${total}`;
                    }

                    await new Promise(resolve => setTimeout(resolve, 300));
                }

                await new Promise(resolve => setTimeout(resolve, 500));

                showValidationResult(foundInSAP, notFoundInSAP, errorMaterials);

            } catch (error) {
                Swal.fire({
                    title: 'Error',
                    text: 'Terjadi kesalahan saat validasi: ' + error.message,
                    icon: 'error',
                    confirmButtonColor: '#028284'
                });
            }
        }

        function showValidationResult(foundInSAP, notFoundInSAP, errorMaterials) {
            const totalFound = foundInSAP.length;
            const totalNotFound = notFoundInSAP.length;
            const totalError = errorMaterials.length;
            const totalAll = totalFound + totalNotFound + totalError;

            if (totalNotFound > 0 || totalError > 0) {
                const materialsToUpdate = foundInSAP.concat(notFoundInSAP).concat(errorMaterials);

                Swal.fire({
                    title: 'Validasi Selesai',
                    html: `
                <div style="margin-bottom: 15px;">
                    <p style="color: #28a745; margin: 5px 0;">
                        <strong>✓ ${totalFound}</strong> material berhasil diverifikasi di SAP
                    </p>
                    ${totalNotFound > 0 ? `
                                                                                                                            <p style="color: #dc3545; margin: 5px 0;">
                                                                                                                                <strong>✗ ${totalNotFound}</strong> material tidak ditemukan di SAP
                                                                                                                            </p>
                                                                                                                        ` : ''}
                </div>
                
                ${totalFound > 0 ? `
                                                                                                                        <div style="max-height: 150px; overflow-y: auto; background: #f8f9fa; padding: 10px; border-radius: 5px; text-align: left; margin: 10px 0;">
                                                                                                                            <strong>Ditemukan di SAP:</strong>
                                                                                                                            <ul style="margin: 5px 0; padding-left: 0; list-style: none;">
                                                                                                                                ${foundInSAP.map(m => `
                                <li style="padding: 5px; margin: 3px 0; background: white; border: 1px solid #28a745; padding-left: 8px;">
                                    <strong>${m.kode_baru_fg}</strong>
                                    <small style="color: #666; display: block;">Length: ${m.length}M | UOM: ${m.alt_uom}</small>
                                </li>
                            `).join('')}
                                                                                                                            </ul>
                                                                                                                        </div>
                                                                                                                    ` : ''}
                
                ${totalNotFound > 0 ? `
                                                                                                                        <div style="max-height: 150px; overflow-y: auto; background: #fff5f5; padding: 10px; border-radius: 5px; text-align: left; margin: 10px 0;">
                                                                                                                            <strong>Tidak ditemukan di SAP:</strong>
                                                                                                                            <ul style="margin: 5px 0; padding-left: 0; list-style: none;">
                                                                                                                                ${notFoundInSAP.map(m => `
                                <li style="padding: 5px; margin: 3px 0; background: white; border: 1px solid #dc3545; padding-left: 8px;">
                                    <strong>${m.kode_baru_fg}</strong>
                                    <small style="color: #666; display: block;">Length: ${m.length}M | UOM: ${m.alt_uom}</small>
                                </li>
                            `).join('')}
                                                                                                                            </ul>
                                                                                                                        </div>
                                                                                                                    ` : ''}
                
                <div style="margin-top: 15px; padding: 15px; background: #e7f3ff; border-radius: 5px; text-align: left;">
                    <strong>Proses Update Status:</strong>
                    <ul style="margin: 5px 0; padding-left: 20px;">
                        ${totalFound > 0 ? `<li style="color: #28a745;">${totalFound} material → Status "Sudah Upload"</li>` : ''}
                        ${(totalNotFound + totalError) > 0 ? `<li style="color: #dc3545;">${totalNotFound + totalError} material → Upload Ulang</li>` : ''}
                    </ul>
                </div>
            `,
                    icon: totalFound > 0 ? 'warning' : 'error',
                    showCancelButton: true,
                    confirmButtonText: `Update Material`,
                    cancelButtonText: 'Batal',
                    confirmButtonColor: '#028284',
                    cancelButtonColor: '#6c757d',
                    width: '700px'
                }).then((result) => {
                    if (result.isConfirmed) {
                        updateStatusWithValidation(foundInSAP, notFoundInSAP, errorMaterials);
                    }
                });
                return;
            }

            if (totalFound > 0 && totalNotFound === 0 && totalError === 0) {
                Swal.fire({
                    title: 'Validasi Berhasil',
                    html: `
                <p style="margin-bottom: 15px;">
                    <strong>✓ ${totalFound} material</strong> sudah terverifikasi di SAP
                </p>
                
                <div style="max-height: 300px; overflow-y: auto; background: #f8f9fa; padding: 15px; border-radius: 5px; text-align: left;">
                    <strong>Daftar Material:</strong>
                    <ul style="margin: 10px 0; padding-left: 0; list-style: none;">
                        ${foundInSAP.map(m => `
                                                                                                                                <li style="padding: 8px; margin: 5px 0; background: white; border: 1px solid #28a745; border-radius: 3px;">
                                                                                                                                    <strong>${m.kode_baru_fg}</strong><br>
                                                                                                                                    <small style="color: #666;">Length: ${m.length}M | UOM: ${m.alt_uom}</small>
                                                                                                                                </li>
                                                                                                                            `).join('')}
                    </ul>
                </div>
                
                <div style="margin-top: 15px; padding: 10px; background: #e7f3ff; border-radius: 5px;">
                    <p style="margin: 5px 0;">Semua material akan diubah ke status <strong>"Sudah Upload"</strong></p>
                </div>
            `,
                    icon: 'success',
                    showCancelButton: true,
                    confirmButtonText: `Update ${totalFound} Material`,
                    cancelButtonText: 'Batal',
                    confirmButtonColor: '#028284',
                    cancelButtonColor: '#6c757d',
                    width: '600px'
                }).then((result) => {
                    if (result.isConfirmed) {
                        updateStatusWithValidation(foundInSAP, [], []);
                    }
                });
                return;
            }
        }

        function updateStatusWithValidation(foundInSAP, notFoundInSAP, errorMaterials) {
            Swal.fire({
                title: 'Memproses...',
                text: 'Sedang mengubah status material',
                allowOutsideClick: false,
                allowEscapeKey: false,
                didOpen: () => {
                    Swal.showLoading();
                }
            });

            const form = document.createElement("form");
            form.method = "POST";
            form.action = `{{ URL::to($url_menu) }}/3_to_1`;
            form.enctype = "multipart/form-data";

            const csrfToken = document.querySelector('meta[name="csrf-token"]').getAttribute('content');
            const csrfInput = document.createElement("input");
            csrfInput.type = "hidden";
            csrfInput.name = "_token";
            csrfInput.value = csrfToken;
            form.appendChild(csrfInput);

            const methodInput = document.createElement("input");
            methodInput.type = "hidden";
            methodInput.name = "_method";
            methodInput.value = "PUT";
            form.appendChild(methodInput);

            // Kirim data material yang berhasil (status 1)
            const successInput = document.createElement("input");
            successInput.type = "hidden";
            successInput.name = "success_materials";
            successInput.value = JSON.stringify(foundInSAP.map(m => ({
                kode_baru_fg: m.kode_baru_fg,
                length: m.length,
                alt_uom: m.alt_uom,
                log_detail_id: m.log_detail_id,
                confirm_as_downloader: !!m.confirm_as_downloader,
                override_reason: m.override_reason || null
            })));
            form.appendChild(successInput);

            // Kirim data material yang gagal (status 0)
            const failedMaterials = notFoundInSAP.concat(errorMaterials);
            const failedInput = document.createElement("input");
            failedInput.type = "hidden";
            failedInput.name = "failed_materials";
            failedInput.value = JSON.stringify(failedMaterials.map(m => ({
                kode_baru_fg: m.kode_baru_fg,
                length: m.length,
                alt_uom: m.alt_uom,
                log_detail_id: m.log_detail_id,
                confirm_as_downloader: !!m.confirm_as_downloader,
                override_reason: m.override_reason || null
            })));
            form.appendChild(failedInput);

            document.body.appendChild(form);
            form.submit();
        }

        function updateStatusToDownloadExcel(downloadedMaterials) {
            // Tampilkan loading
            Swal.fire({
                title: 'Memproses...',
                text: 'Sedang mengubah status dan men-download file',
                allowOutsideClick: false,
                allowEscapeKey: false,
                didOpen: () => {
                    Swal.showLoading();
                }
            });

            const form = document.createElement("form");
            form.method = "POST";
            form.action = `{{ URL::to($url_menu) }}/0_to_3`;
            form.enctype = "multipart/form-data";

            const csrfToken = document.querySelector('meta[name="csrf-token"]').getAttribute('content');
            const csrfInput = document.createElement("input");
            csrfInput.type = "hidden";
            csrfInput.name = "_token";
            csrfInput.value = csrfToken;
            form.appendChild(csrfInput);

            const methodInput = document.createElement("input");
            methodInput.type = "hidden";
            methodInput.name = "_method";
            methodInput.value = "PUT";
            form.appendChild(methodInput);

            const materialsInput = document.createElement("input");
            materialsInput.type = "hidden";
            materialsInput.name = "download_materials";
            materialsInput.value = JSON.stringify(downloadedMaterials || []);
            form.appendChild(materialsInput);

            document.body.appendChild(form);
            form.submit();
        }

        function updateStatusAndSubmit(newStatus) {
            // Tampilkan loading
            Swal.fire({
                title: 'Memproses...',
                text: 'Sedang mengubah status material',
                allowOutsideClick: false,
                allowEscapeKey: false,
                didOpen: () => {
                    Swal.showLoading();
                }
            });

            // Buat form untuk submit
            const form = document.createElement("form");
            form.method = "POST";
            form.action = `{{ URL::to($url_menu) }}/1_to_${newStatus}`;
            form.enctype = "multipart/form-data";

            // CSRF Token
            const csrfToken = document.querySelector('meta[name="csrf-token"]').getAttribute('content');
            const csrfInput = document.createElement("input");
            csrfInput.type = "hidden";
            csrfInput.name = "_token";
            csrfInput.value = csrfToken;
            form.appendChild(csrfInput);

            // Method PUT
            const methodInput = document.createElement("input");
            methodInput.type = "hidden";
            methodInput.name = "_method";
            methodInput.value = "PUT";
            form.appendChild(methodInput);

            // Submit form
            document.body.appendChild(form);
            form.submit();
        }
        // Rest of the JavaScript code remains the same...
        var idroles = <br />
<b>Warning</b>:  Undefined variable $user_login in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1225</b><br />
<br />
<b>Warning</b>:  Attempt to read property "idroles" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1225</b><br />
null;

        let buttons = [];

        if (idroles == "msjits") {
            buttons = [{
                    text: '<i class="fas fa-file-excel me-1 text-lg text-success"></i><span class="font-weight-bold"> Excel</span>',
                    action: function() {
                        const table = $('#list_{{ $dmenu }}').DataTable();

                        let status0Count = 0;
                        let rowDataStatus0 = [];
                        let tableDetailStatus0 = [];
                        let materialBaruCount = 0;
                        let tambahLengthCount = 0;
                        let tambahLengthList = [];
                        let dt2ACount = 0;
                        let dt2BCount = 0;

                        const tableDetail = JSON.parse(`{!! json_encode($table_detail) !!}`);

                        table.rows().every(function() {
                            const row = this.data();
                            const statusValue = row[16];

                            if (statusValue === '0') {
                                status0Count++;
                                rowDataStatus0.push(row);

                                const downloadType = row[17] ?? '3';
                                const downloadSubtype = row[18] ?? '';

                                if (downloadType === '1') {
                                    tambahLengthCount++;
                                    tambahLengthList.push({
                                        kode: row[1],
                                        length: row[9],
                                        uom: row[11]
                                    });
                                } else if (downloadType === '2' && downloadSubtype === 'A') {
                                    dt2ACount++;
                                    materialBaruCount++;
                                } else if (downloadType === '2' && downloadSubtype === 'B') {
                                    dt2BCount++;
                                    materialBaruCount++;
                                } else {
                                    materialBaruCount++;
                                }
                            }
                        });

                        tableDetailStatus0 = tableDetail.filter(item => item.status === '0');

                        if (status0Count === 0) {
                            Swal.fire({
                                icon: 'warning',
                                title: 'Tidak Ada Data',
                                text: 'Tidak ada material yang bisa didownload.',
                                confirmButtonText: 'OK',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }

                        const url1 = "{{ asset('storage/mst_material/Upload Material.xlsx') }}";
                        const url2 = "{{ asset('storage/mst_material/Characteristic.xlsx') }}";
                        const url3 = "{{ asset('storage/mst_material/Al UoM.xlsx') }}";
                        let unmatchedColors = `{!! json_encode($unmatched_colors) !!}` || 0;

                        try {
                            unmatchedColors = JSON.parse(unmatchedColors);
                        } catch (e) {
                            unmatchedColors = 0;
                        }

                        const unmatchedStatus0 = tableDetailStatus0.filter(item => !item.color_code).length;

                        if (unmatchedStatus0 > 0) {
                            Swal.fire({
                                icon: 'warning',
                                title: 'Export Gagal!',
                                html: `Masih ada <strong>${unmatchedStatus0}</strong> material dengan status "Belum Upload" yang warnanya belum terdaftar.<br>Harap lengkapi data sebelum melanjutkan.`,
                                confirmButtonText: 'OK',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }

                        let dt3Count = 0;
                        rowDataStatus0.forEach(function(row) {
                            const downloadType = row[17] ?? '3';
                            if (downloadType === '3') {
                                dt3Count++;
                            }
                        });

                        // Build file rows untuk tabel ringkas
                        let fileRows = '';
                        const uploadMatCount = dt3Count + dt2BCount;
                        const characteristicCount = dt3Count + dt2ACount;

                        if (uploadMatCount > 0) {
                            const tags = [dt3Count > 0 ? `${dt3Count} baru` : '', dt2BCount > 0 ?
                                `${dt2BCount} master` : ''
                            ].filter(Boolean).join(', ');
                            fileRows +=
                                `<tr><td style="padding:5px 8px;">📄 Upload Material.xlsx</td><td style="padding:5px 8px;"><span style="background:#d4edda;color:#155724;padding:2px 7px;border-radius:10px;font-size:11px;">${tags}</span></td></tr>`;
                        }
                        if (characteristicCount > 0) {
                            const tags = [dt3Count > 0 ? `${dt3Count} baru` : '', dt2ACount > 0 ?
                                `${dt2ACount} prod/cust` : ''
                            ].filter(Boolean).join(', ');
                            fileRows +=
                                `<tr><td style="padding:5px 8px;">📄 Characteristic.xlsx</td><td style="padding:5px 8px;"><span style="background:#d4edda;color:#155724;padding:2px 7px;border-radius:10px;font-size:11px;">${tags}</span></td></tr>`;
                        }
                        fileRows +=
                            `<tr><td style="padding:5px 8px;">📄 Alt UoM.xlsx</td><td style="padding:5px 8px;"><span style="background:#d4edda;color:#155724;padding:2px 7px;border-radius:10px;font-size:11px;">${status0Count} material</span></td></tr>`;

                        let summaryParts = [];
                        if (materialBaruCount > 0) summaryParts.push(
                            `<strong>${materialBaruCount}</strong> Material Baru`);
                        if (tambahLengthCount > 0) summaryParts.push(
                            `<strong>${tambahLengthCount}</strong> Penambahan Panjang`);

                        let catatanItems = [];
                        if (dt2ACount > 0) catatanItems.push(
                            `${dt2ACount} material perubahan product/customer → hanya <strong>Characteristic.xlsx</strong>`
                        );
                        if (dt2BCount > 0) catatanItems.push(
                            `${dt2BCount} material perubahan data master → hanya <strong>Upload Material.xlsx</strong>`
                        );
                        if (tambahLengthCount > 0 && materialBaruCount === 0) catatanItems.push(
                            `Penambahan panjang → hanya <strong>Alt UoM.xlsx</strong>`);
                        const catatanHTML = catatanItems.length > 0 ? `
                            <div style="margin-top:10px;padding:8px 10px;background:#fff3cd;border-left:3px solid #ffc107;font-size:11px;color:#856404;">
                                <strong>⚠ Catatan:</strong>
                                <ul style="margin:4px 0 0 0;padding-left:16px;">${catatanItems.map(c => `<li>${c}</li>`).join('')}</ul>
                            </div>` : '';

                        let infoHTML = `
                            <div style="text-align:left;font-size:13px;">
                                <p style="margin:0 0 10px 0;">${summaryParts.join(' dan ')}</p>
                                <table style="width:100%;border-collapse:collapse;">
                                    <thead><tr style="background:#f0f0f0;font-size:12px;color:#555;">
                                        <th style="padding:6px 8px;font-weight:600;">File</th>
                                        <th style="padding:6px 8px;font-weight:600;">Keterangan</th>
                                    </tr></thead>
                                    <tbody>${fileRows}</tbody>
                                </table>
                                ${catatanHTML}
                            </div>
                        `;

                        Swal.fire({
                            icon: 'question',
                            title: 'Konfirmasi Download',
                            html: infoHTML,
                            showCancelButton: true,
                            confirmButtonText: 'Download',
                            cancelButtonText: 'Batal',
                            confirmButtonColor: '#028284',
                            cancelButtonColor: '#6c757d',
                            width: '550px'
                        }).then((result) => {
                            if (result.isConfirmed) {
                                handleExport(rowDataStatus0, tableDetailStatus0, url1, url2, url3);
                            }
                        });
                    }
                },
                {
                    text: '<i class="fas fa-check-circle me-1 text-lg"></i><span class="font-weight-bold"> Sudah Upload</span>',
                    className: 'btn-success',
                    attr: {
                        id: 'btnSudahUpload'
                    },
                    action: function() {
                        const table = $('#list_{{ $dmenu }}').DataTable();
                        let countStatus3 = 0;

                        table.rows().every(function() {
                            const row = this.data();
                            const statusValue = row[16];
                            if (statusValue === '3') {
                                countStatus3++;
                            }
                        });

                        if (countStatus3 === 0) {
                            Swal.fire({
                                title: 'Tidak Ada Data',
                                text: 'Tidak ada material yang perlu diupload.',
                                icon: 'info',
                                confirmButtonColor: '#028284'
                            });
                            return;
                        }
                    }
                }
            ];
        } else if (idroles == "qcntrl") {
            buttons = [{
                text: '<i class="fas fa-file-excel me-1 text-lg text-success"></i><span class="font-weight-bold"> Excel</span>',
                action: function() {
                    var rowData = $('#list_{{ $dmenu }}').DataTable().rows().data().toArray();
                    var filteredData = rowData.filter(row => row[16] === '1');

                    if (filteredData.length === 0) {
                        Swal.fire({
                            icon: 'info',
                            title: 'Tidak Ada Data',
                            text: 'Tidak ada material untuk di-inspect.',
                            confirmButtonColor: '#028284'
                        });
                        return;
                    }
                    const workbook = new ExcelJS.Workbook();
                    const worksheet = workbook.addWorksheet('Sheet1');
                    worksheet.getCell('A1').value = "Material";

                    let rowIndex = 2;
                    for (let i = 0; i < rowData.length; i++) {
                        worksheet.getCell(`A${rowIndex}`).value = rowData[i][1];
                        worksheet.getCell(`A${rowIndex + 1}`).value = rowData[i][1].substring(1, 20);
                        rowIndex += 2;
                    }

                    workbook.xlsx.writeBuffer().then(function(buffer) {
                        var blob = new Blob([buffer], {
                            type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
                        });
                        saveAs(blob, 'AUTOQC Uipath.xlsx');
                    }).then(data => {
                        updateStatusAndSubmit("2");
                    }).catch(error => console.error('Error creating Excel file:', error));
                }
            }];
        } else {
            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(: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)'
                    },
                },
            ];
        }

        async function handleExport(rowData, tableDetail, url1, url2, url3) {
            try {
                let materialBaru3Data = []; // download_type=3 → Upload Material + Characteristic
                let materialBaru3Detail = [];
                let material2AData = []; // download_type=2A → Characteristic only
                let material2ADetail = [];
                let material2BData = []; // download_type=2B → Upload Material only
                let material2BDetail = [];
                let allData = rowData;
                let allDetail = tableDetail;

                for (let i = 0; i < rowData.length; i++) {
                    const downloadType = rowData[i][17] ?? '3';
                    const downloadSubtype = rowData[i][18] ?? '';

                    const kodeRow = (rowData[i][1] ?? '').trim();
                    const lengthRow = rowData[i][9];
                    const matchedDetail = tableDetail.find(function(d) {
                        return (d.kode_baru_fg ?? '').trim() === kodeRow &&
                            String(d.length) === String(lengthRow);
                    }) || tableDetail[i];

                    if (downloadType === '3') {
                        materialBaru3Data.push(rowData[i]);
                        materialBaru3Detail.push(matchedDetail);
                    } else if (downloadType === '2' && downloadSubtype === 'A') {
                        material2AData.push(rowData[i]);
                        material2ADetail.push(matchedDetail);
                    } else if (downloadType === '2' && downloadSubtype === 'B') {
                        material2BData.push(rowData[i]);
                        material2BDetail.push(matchedDetail);
                    }
                    // download_type=1 → hanya Alt UoM, tidak perlu dipisah
                }

                // Upload Material: dt=3 (baru murni) + dt=2B (master berubah)
                const uploadMaterialData = [...materialBaru3Data, ...material2BData];
                const uploadMaterialDetail = [...materialBaru3Detail, ...material2BDetail];

                // Characteristic: dt=3 (baru murni) + dt=2A (product/customer berubah)
                const characteristicData = [...materialBaru3Data, ...material2AData];
                const characteristicDetail = [...materialBaru3Detail, ...material2ADetail];

                if (uploadMaterialData.length === 0 && characteristicData.length === 0) {
                    Swal.fire({
                        icon: 'info',
                        title: 'Informasi',
                        text: 'Semua data adalah penambahan length. Hanya file Alt UoM yang akan di-download.',
                        confirmButtonColor: '#028284'
                    });
                }

                // Download Upload Material.xlsx jika ada
                if (uploadMaterialData.length > 0) {
                    const data1 = await fetch(url1).then(res => res.arrayBuffer());
                    await processWorkbook1(data1, uploadMaterialData, uploadMaterialDetail);
                }

                // Download Characteristic.xlsx jika ada
                if (characteristicData.length > 0) {
                    const data2 = await fetch(url2).then(res => res.arrayBuffer());
                    await processWorkbook2(data2, characteristicData, characteristicDetail);
                }

                // Alt UoM selalu di-download untuk semua
                const data3 = await fetch(url3).then(res => res.arrayBuffer());
                await processWorkbook3(data3, allData, allDetail);

                const downloadedMaterials = allData.map(row => ({
                    kode_baru_fg: row[1],
                    length: row[9],
                    alt_uom: row[11]
                }));
                updateStatusToDownloadExcel(downloadedMaterials);

            } catch (error) {
                console.error("Export error:", error);
            }
        }

        async function processWorkbook1(data, rowData, tableDetail) {
            const workbook = new ExcelJS.Workbook();
            await workbook.xlsx.load(data);
            const worksheet = workbook.getWorksheet(1);
            let rowCounter = 7;

            for (let i = 0; i < rowData.length; i++) {
                const [, , matGroup, customer, product, division, matG1, matG2, matG3, length, , alt_uom] =
                rowData[i];
                const kodeBaruFG = rowData[i][1];
                const {
                    color,
                    fg_mrp_controller,
                    sfg_mrp_controller
                } = tableDetail[i];
                const isHead9 = kodeBaruFG.charAt(0) === '9';
                const kode = kodeBaruFG.substring(1, 5);
                const kode3 = kodeBaruFG.substring(1, 4);


                for (let j = 0; j < 2; j++) {
                    if (j === 1 && isHead9) continue;
                    const row = worksheet.getRow(rowCounter);

                    row.getCell(1).value = "Z";
                    row.getCell(2).value = j === 0 ? (isHead9 ? "ZNOV" : "ZFGD") : "ZSFG";
                    row.getCell(3).value = "1001";
                    row.getCell(4).value = "101";
                    row.getCell(6).value = j === 0 ? kodeBaruFG : kodeBaruFG.substring(1, 20);

                    let label = "";
                    if (kode3 === "PT0") {
                        label = "SAP Sheet ";
                    } else if (j === 0 && ["TE0R", "TEDR"].includes(kode)) {
                        label = "Nonwoven Airthrough ";
                    } else if (j === 0 && kode === "TE0Y") {
                        label = "Nonwoven Fluffy ";
                    } else if (j === 0) {
                        label = "Nonwoven Spunbond ";
                    } else {
                        label = "Nonwovens Jumbo ";
                    }

                    row.getCell(7).value = label + kodeBaruFG.substring(1, 20);
                    row.getCell(8).value = "KG";
                    row.getCell(12).value = matGroup;
                    row.getCell(15).value = j === 0 ? "M0" : "PD";
                    row.getCell(16).value = j === 0 ? fg_mrp_controller : sfg_mrp_controller;
                    row.getCell(18).value = "EX";
                    row.getCell(23).value = "E";
                    row.getCell(28).value = "Z1";
                    row.getCell(29).value = j === 0 ? "1" : "2";
                    row.getCell(30).value = "20";
                    row.getCell(31).value = j === 0 ? (isHead9 ? "" : "102") : "101";
                    row.getCell(34).value = "X";
                    row.getCell(35).value = "1001";
                    row.getCell(40).value = j === 0 ? "V300" : "V200";

                    if (j === 0) {
                        row.getCell(44).value = "MSJ1";
                        row.getCell(45).value = "10";
                        row.getCell(46).value = division;
                        row.getCell(47).value = "1";
                        row.getCell(48).value = division === "10" ? "01" : "02";
                        row.getCell(49).value = "Z001";
                        row.getCell(51).value = "0001";
                        row.getCell(52).value = "0001";
                        row.getCell(55).value = matG1;
                        row.getCell(56).value = matG2;
                        row.getCell(57).value = matG3;
                    }
                    rowCounter++;
                }
            }

            const buffer = await workbook.xlsx.writeBuffer();
            saveAs(new Blob([buffer], {
                type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
            }), 'Upload Material.xlsx');
        }

        async function processWorkbook2(data, rowData, tableDetail) {
            const workbook = new ExcelJS.Workbook();
            workbook.xlsx.load(data).then(() => {
                const worksheet = workbook
                    .getWorksheet(2);
                if (!worksheet) {
                    console.error(
                        "Worksheet tidak ditemukan!"
                    );
                    return;
                }
                for (let i = 0; i < rowData
                    .length; i++) {
                    var kodeBaruFG = rowData[i][1];
                    var matGroup = rowData[i][2];
                    var customer = rowData[i][3];
                    var product = rowData[i][4];
                    var division = rowData[i][5];
                    var matG1 = rowData[i][6];
                    var matG2 = rowData[i][7];
                    var matG3 = rowData[i][8];
                    var length = rowData[i][9];
                    var alt_uom = rowData[i][11];
                    var color = tableDetail[i]['color'];
                    var fg_mrp_controller = tableDetail[i]['fg_mrp_controller'];
                    var sfg_mrp_controller = tableDetail[i]['sfg_mrp_controller'];
                    //jika user input width = ambil dari width, jika tidak = ambil dari kode FG

                    let width = '';
                    const inputWidth = rowData[i][13] ? rowData[i][13].toString().trim() : '';
                    if (inputWidth !== '' && !isNaN(parseFloat(inputWidth))) {
                        // Ada input width dari user, pakai nilai inputan
                        width = parseFloat(inputWidth).toFixed(3);
                    } else {
                        // Tidak ada input width, ambil dari kode FG
                        width = (parseInt(kodeBaruFG.substring(kodeBaruFG.length - 7, kodeBaruFG
                                .length - 1)) /
                            1000).toFixed(3);
                    }

                    let gramature = parseInt(kodeBaruFG.substring(16, 20));

                    // worksheet 2
                    for (let j = i * 7; j < (i * 7) + 7; j++) {
                        worksheet.getCell(j + 7, 1).value = kodeBaruFG;
                        worksheet.getCell(j + 7, 2).value = "001";
                        worksheet.getCell(j + 7, 3).value = "FG_CLASS";
                    }
                    worksheet.getCell((i * 7) + 7, 4).value = "CUSTOMER";
                    worksheet.getCell((i * 7) + 8, 4).value = "LENGTH";
                    worksheet.getCell((i * 7) + 9, 4).value = "WIDTH";
                    worksheet.getCell((i * 7) + 10, 4).value = "GRAMATURE";
                    worksheet.getCell((i * 7) + 11, 4).value = "COLOR";
                    worksheet.getCell((i * 7) + 12, 4).value = "ROLL";
                    worksheet.getCell((i * 7) + 13, 4).value = "PRODUCT";

                    const customerDecoded = decodeHTMLEntities(customer);
                    worksheet.getCell((i * 7) + 7, 5).value = customerDecoded.toUpperCase();
                    worksheet.getCell((i * 7) + 8, 5).value = length.toString().replace('.', ',');
                    worksheet.getCell((i * 7) + 9, 5).value = width.toString().replace('.', ',');
                    worksheet.getCell((i * 7) + 10, 5).value = gramature.toString().replace('.', ',');
                    worksheet.getCell((i * 7) + 11, 5).value = color;
                    // worksheet.getCell((i * 7) + 12, 5).value = (calculateRoll(length,
                    //     width, gramature)).toString().replace('.', ',');
                    worksheet.getCell((i * 7) + 12, 5).value = '1';
                    worksheet.getCell((i * 7) + 13, 5).value = product;
                }
                workbook.xlsx.writeBuffer().then(buffer => {
                    var blob = new Blob([buffer], {
                        type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
                    });
                    saveAs(blob,
                        'Characteristic.xlsx'
                    );
                })
            });
        }

        function shouldSkipDenominator(uom) {
            return /^(RL[1-9A-Z]|CS[1-9]|BL[1-9]|BX[1-9])$/.test(uom);
        }

        async function processWorkbook3(data, rowData, tableDetail) {
            const workbook = new ExcelJS.Workbook();
            await workbook.xlsx.load(data);
            const worksheet = workbook.getWorksheet(3);
            let rowCounter = 7; // mulai dari baris 7

            for (let i = 0; i < rowData.length; i++) {
                const kodeBaruFG = rowData[i][1];
                const customer = rowData[i][3];
                const product = rowData[i][4];
                const length = rowData[i][9];
                const alt_uom = rowData[i][11];
                const color = tableDetail[i]['color'];

                const inputWidthVal = rowData[i][13] ? rowData[i][13].toString().trim() : '';
                const width = (inputWidthVal !== '' && !isNaN(parseFloat(inputWidthVal))) ?
                    parseFloat(inputWidthVal).toFixed(3) :
                    (parseInt(kodeBaruFG.slice(-7, -1)) / 1000).toFixed(3);

                const weightbl = ['BOX', 'BAL', 'BL1', 'BL2', 'BL3', 'BL4', 'BL5'].includes(alt_uom) ?
                    parseFloat(rowData[i][14]).toFixed(2) : '';

                const gramature = parseInt(kodeBaruFG.substring(16, 20));
                const skipDenum = shouldSkipDenominator(alt_uom);

                const deskripsi =
                    (kodeBaruFG.substring(1, 4) === "PT0" ? "SAP Sheet " :
                        (["TE0R", "TEDR"].includes(kodeBaruFG.substring(1, 5)) ? "Nonwovens Airthrough " :
                            (kodeBaruFG.substring(1, 5) === "TE0Y" ? "Nonwovens Fluffy " : "Nonwovens Spunbond "))) +
                    kodeBaruFG.substring(1, 20);

                // ✅ Tulis M dan M2 jika tidak skip
                if (!skipDenum) {
                    // M
                    worksheet.getCell(rowCounter, 1).value = kodeBaruFG;
                    worksheet.getCell(rowCounter, 2).value = deskripsi;
                    worksheet.getCell(rowCounter, 3).value = countM(length, width, gramature).toString().replace('.',
                        ',');
                    worksheet.getCell(rowCounter, 4).value = "M";
                    worksheet.getCell(rowCounter, 5).value = Math.round(countWeightM(length, width, gramature))
                        .toString().replace('.', ',');

                    worksheet.getCell(rowCounter, 6).value = length.toString().replace('.', ',');
                    worksheet.getCell(rowCounter, 7).value = width.toString().replace('.', ',');
                    worksheet.getCell(rowCounter, 8).value = gramature.toString().replace('.', ',');
                    rowCounter++;

                    // M2
                    worksheet.getCell(rowCounter, 1).value = kodeBaruFG;
                    worksheet.getCell(rowCounter, 2).value = deskripsi;
                    worksheet.getCell(rowCounter, 3).value = countM2(length, width, gramature).toString().replace('.',
                        ',');
                    worksheet.getCell(rowCounter, 4).value = "M2";
                    worksheet.getCell(rowCounter, 5).value = Math.round(countWeightM(length, width, gramature))
                        .toString().replace('.', ',');
                    worksheet.getCell(rowCounter, 6).value = length.toString().replace('.', ',');
                    worksheet.getCell(rowCounter, 7).value = width.toString().replace('.', ',');
                    worksheet.getCell(rowCounter, 8).value = gramature.toString().replace('.', ',');
                    rowCounter++;
                }

                // Baris terakhir: UOM as is
                worksheet.getCell(rowCounter, 1).value = kodeBaruFG;
                worksheet.getCell(rowCounter, 2).value = deskripsi;

                worksheet.getCell(rowCounter, 3).value = Math.round(calculateRoll(length, width, gramature, alt_uom,
                    weightbl)).toString().replace('.', ',');
                worksheet.getCell(rowCounter, 4).value = alt_uom;
                worksheet.getCell(rowCounter, 5).value = Math.round(calculateWeightRoll(length, width, gramature,
                    alt_uom, weightbl)).toString().replace('.', ',');

                worksheet.getCell(rowCounter, 6).value = length.toString().replace('.', ',');
                worksheet.getCell(rowCounter, 7).value = width.toString().replace('.', ',');
                worksheet.getCell(rowCounter, 8).value = gramature.toString().replace('.', ',');

                if (["BAL", "BOX"].includes(alt_uom) || alt_uom.startsWith("BL") || alt_uom.startsWith("BX")) {
                    worksheet.getCell(rowCounter, 10).value = rowData[i][12];
                    worksheet.getCell(rowCounter, 11).value = "PCS";
                }

                rowCounter++; // akhir setiap i
            }

            const buffer = await workbook.xlsx.writeBuffer();
            saveAs(new Blob([buffer], {
                type: "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
            }), 'Al UoM.xlsx');
        }

        $('#list_{{ $dmenu }}').DataTable({
            "language": {
                "search": "Cari :",
                "lengthMenu": "Tampilkan _MENU_ baris",
                "zeroRecords": "Maaf - Data tidak ada",
                "info": "Data _START_ - _END_ dari _TOTAL_",
                "infoEmpty": "Tidak ada data",
                "infoFiltered": "(pencarian dari _MAX_ data)"
            },
            responsive: true,
            dom: 'Bfrtip',
            buttons: buttons
        });

        $('<style>')
            .prop('type', 'text/css')
            .html(`
            table.dataTable tbody tr.row-inactive,
            table.dataTable tbody tr.row-inactive:hover,
            table.dataTable tbody tr.row-inactive td {
                background-color: #ffe9ed !important;
            }
            table.dataTable tbody tr.row-status-3,
            table.dataTable tbody tr.row-status-3:hover,
            table.dataTable tbody tr.row-status-3 td {
                background-color: #FFF9C4 !important;
            }
        `)
            .appendTo('head');

        $('#list_{{ $dmenu }}').on('draw.dt', function() {
            $('tr.row-inactive').each(function() {
                $(this).find('td').css('background-color', '#ffe9ed');
            });
            $('tr.row-status-3').each(function() {
                $(this).find('td').css('background-color', '#FFF9C4');
            });
        });

        setTimeout(function() {
            $('tr.row-inactive td').css('background-color', '#ffe9ed');
            $('tr.row-status-3 td').css('background-color', '#FFF9C4');
        }, 100);

        document.addEventListener('click', function(event) {
            if (event.target.closest('button') && event.target.closest('button').innerHTML.includes(
                    'Excel')) {

            }
        });
        //set color button datatables
        $('.dt-button').addClass('btn btn-secondary');
        $('.dt-button').removeClass('dt-button');
        //check authorize button datatables
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />
 <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />
 <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/tr_mtr/list.blade.php</b> on line <b>1875</b><br />

        //function delete
        function deleteData(event, name, msg, mat, length) {
            event.preventDefault(); // Prevent default form submission
            Swal.fire({
                title: 'Konfirmasi',
                text: `Apakah Anda Yakin ${msg} ${mat} (Length = ${length}M) 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();
                }
            });
        }
    </script>
@endpush