@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>
                                    @endif
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>

                                            <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>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;

                                                $rowClass = '';
                                                if ($detail->isactive == '0') {
                                                    $rowClass = 'row-inactive';
                                                } elseif ($detail->status == '3') {
                                                    $rowClass = 'row-status-3';
                                                }
                                            @endphp
                                            <tr class="{{ $rowClass }}">

                                                {{-- <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> {{ $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 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/trmmat/list.blade.php</b> on line <b>167</b><br />
<br />
<b>Warning</b>:  Attempt to read property "idroles" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>167</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 = ((length * width * gramature) / 1000); // tanpa .toFixed

            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 weight1 = ((length * width * gramature) / 1000).toFixed(2);
            weightparse = parseFloat(weight1); // pastikan jadi number



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

            let checkDenum = 1; // default

            if (!Number.isInteger(weightparse)) {
                if (weightparse < 100) {
                    checkDenum = 1000;
                } else if (weightparse < 1000) {
                    checkDenum = 100;
                } else if (weightparse < 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);
        }
        //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 = Math.round((length * width * gramature / 1000) * 100) / 100;
            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) {

            let weight1 = ((length * width * gramature) / 1000).toFixed(2);
            weight1 = parseFloat(weight1); // konversi ke number
            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 = [];

        function updateStatusAndSubmit(value) {
            const table = $('#list_{{ $dmenu }}').DataTable();
            table.rows().every(function() {
                // Menentukan nama status berdasarkan value
                const statusName = (parseInt(value) - 1).toString() === "0" ? "Belum Upload" :
                    (parseInt(value) - 1).toString() === "1" ? "Sudah Upload" :
                    "Sudah Inspect";
                const row = this.data();
                console.log(value);
                // Periksa apakah status pada row sesuai
                // if (row[13] === statusName) {
                const updatedData = [];
                // Memperbarui status
                row[15] = value;

                console.log(row[14]);

                updatedData.push({
                    kode_baru_fg: row[1],
                    id_mat_group: row[2],
                    customer: row[3],
                    product_name: row[4],
                    division: row[5],
                    mat_g1: row[6],
                    mat_g2: row[7],
                    mat_g3: row[8],
                    length: row[9],
                    keterangan: row[10],
                    alt_uom: row[11],
                    top_load: row[12],
                    width: row[13],
                    weight: row[14],
                    status: value,
                });
                // Membuat form dengan struktur yang sama
                const form = document.createElement("form");
                form.method = "POST";
                form.action =
                    `{{ URL::to($url_menu) }}` + '/' + value;
                form.enctype = "multipart/form-data";
                form.id = "tr_mtr-edit-form";

                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);
                // HTTP Method (jika diperlukan)
                const methodInput = document.createElement("input");
                methodInput.type = "hidden";
                methodInput.name = "_method";
                methodInput.value = "PUT";
                form.appendChild(methodInput);


                // Data yang diperbarui
                updatedData.forEach((data, index) => {
                    for (const key in data) {
                        if (data.hasOwnProperty(key)) {
                            const dataInput = document.createElement("input");
                            dataInput.type = "hidden";
                            dataInput.name = key;
                            dataInput.value = data[key];
                            form.appendChild(dataInput);
                        }
                    }
                });
                // Tambahkan form ke body dan submit
                document.body.appendChild(form);
                form.submit();
                // }
            });
        }

        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 rowData = $('#list_{{ $dmenu }}').DataTable().rows().data().toArray();
                    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') }}";
                    const tableDetail = JSON.parse(`{!! json_encode($table_detail) !!}`);
                    let unmatchedColors = `{!! json_encode($unmatched_colors) !!}` || 0;

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

                    if (unmatchedColors !== 0) {
                        Swal.fire({
                            icon: 'warning',
                            title: 'Export Gagal!',
                            text: 'Masih ada warna yang belum terdaftar. Harap lengkapi data sebelum melanjutkan.',
                            confirmButtonText: 'OK'
                        });
                        return;
                    }

                    handleExport(rowData, tableDetail, url1, url2, url3);
                }
            }];

        } 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();

                    const workbook = new ExcelJS.Workbook();

                    // Create the first worksheet
                    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',
                    // title: 'Nama File Excel',
                    customize: function(xlsx) {
                        var sheet = xlsx.xl.worksheets['sheet1.xml'];
                        // Loop over the cells in column
                        sheet.querySelectorAll('row c[r^="' + columnAbjad + '"]').forEach((row) => {
                            // Get the value
                            let cell = row.querySelector('is t');
                            if (cell && cell.textContent === 'Not Active') {
                                row.setAttribute('s', '10');
                                //red background
                            }
                        });
                    },
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
                {
                    extend: 'pdfHtml5',
                    text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"> </i><span class="font-weight-bold"> PDF',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
                {
                    extend: 'print',
                    text: '<i class="fas fa-print me-1 text-lg text-info"> </i><span class="font-weight-bold"> Print',
                    exportOptions: {
                        columns: ':visible:not(:last-child)'
                    },
                },
            ];
        }

        async function handleExport(rowData, tableDetail, url1, url2, url3) {
            try {
                const data1 = await fetch(url1).then(res => res.arrayBuffer());
                await processWorkbook1(data1, rowData, tableDetail);

                const data2 = await fetch(url2).then(res => res.arrayBuffer());
                await processWorkbook2(data2, rowData, tableDetail);

                const data3 = await fetch(url3).then(res => res.arrayBuffer());
                await processWorkbook3(data3, rowData, tableDetail);

                updateStatusAndSubmit("1");
                for (let i = 0; i < rowData.length; i++) {
                    const kodeBaruFG = rowData[i][1];
                    const length = rowData[i][9];
                    const alt_uom = rowData[i][11];

                    let width = '';
                    if (['BOX', 'BAL', 'BL1', 'BL2', 'BL3', 'BL4', 'BL5'].includes(alt_uom)) {
                        width = parseFloat(rowData[i][13]).toFixed(3);
                    } else {
                        width = (parseInt(kodeBaruFG.substring(kodeBaruFG.length - 7, kodeBaruFG.length - 1)) / 1000)
                            .toFixed(3);
                    }

                    let weightbl = '';
                    if (['BOX', 'BAL', 'BL1', 'BL2', 'BL3', 'BL4', 'BL5'].includes(alt_uom)) {
                        weightbl = parseFloat(rowData[i][14]).toFixed(2);
                    }

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

                    // // 🔍 DEBUG
                    // console.log(`[${i}]`, {
                    //     length,
                    //     width,
                    //     gramature,
                    //     alt_uom,
                    //     kodeBaruFG,
                    //     weightbl
                    // });

                    // ✅ panggil fungsi per baris
                    // await checkDenums(length, width, gramature);
                    // await calculateWeightRoll(length, width, gramature, alt_uom, weightbl);
                    // await calculateRoll(length, width, gramature, alt_uom, weightbl)
                }
            } 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);

                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 (kode === "PT0T") 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 uom ROL = ambil dari kode, jika uom BAL/BOX ambil dari inputan user

                    let width = '';
                    if (alt_uom === 'BOX' || alt_uom === 'BAL') {
                        width = parseFloat(rowData[i][13]).toFixed(3);
                    } else {
                        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";

                    worksheet.getCell((i * 7) + 7, 5).value = customer.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 width = ['BOX', 'BAL', 'BL1', 'BL2', 'BL3', 'BL4', 'BL5'].includes(alt_uom) ?
                    parseFloat(rowData[i][13]).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, 5) === "PT0T" ? "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 = 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 = 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 = calculateRoll(length, width, gramature, alt_uom, weightbl)
                    .toString().replace('.', ',');
                worksheet.getCell(rowCounter, 4).value = alt_uom;
                worksheet.getCell(rowCounter, 5).value = 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/trmmat/list.blade.php</b> on line <b>1041</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>1041</b><br />
 <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>1041</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>1041</b><br />
 <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>1041</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmaterial/resources/views/transc/trmmat/list.blade.php</b> on line <b>1041</b><br />

        //function delete
        function deleteData(event, name, msg) {
            event.preventDefault(); // Prevent default form submission
            Swal.fire({
                title: 'Konfirmasi',
                text: `Apakah Anda Yakin ${msg} ${name} ini?`,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: `Ya, ${msg}`,
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284'
            }).then((result) => {
                if (result.isConfirmed) {
                    // Find the closest form element and submit it manually
                    event.target.closest('form').submit();
                }
            });
        }
    </script>
@endpush