@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="card-header">
                            <h5 class="mb-0">Result {{ $title_menu }}</h5>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="nav-wrapper row">
                                    <div class="col">
                                        {{-- button back --}}
                                        <button class="btn btn-secondary mb-0" onclick="history.back()"><i
                                                class="fas fa-circle-left me-1"> </i><span
                                                class="font-weight-bold">Kembali</button>
                                        {{-- button Excel export --}}
                                        @if (isset($grouped_result) && count($grouped_result) > 0)
                                            @if ($authorize->excel == '1')
                                                <button class="btn btn-secondary mb-0 ms-2" id="btn-export-excel" onclick="exportToExcel()">
                                                    <i class="fas fa-file-excel me-1 text-success"> </i><span class="font-weight-bold"> Excel</span>
                                                </button>
                                            @endif
                                        @endif
                                    </div>
                                    <div class="col-md-auto md-auto justify-content-end row">
                                        {{-- Filter Request No (search modal like extmem) --}}
                                        @if (isset($grouped_result) && count($grouped_result) > 0)
                                            <div class="col-auto me-3">
                                                <label class="form-label mb-0 text-xs">Filter Request No :</label>
                                                <div class="input-group input-group-sm" style="width: 240px;">
                                                    <input type="text" class="form-control" id="filter_request_no"
                                                        placeholder="Pilih Request No" readonly>
                                                    <span class="input-group-text bg-primary text-light"
                                                        data-bs-toggle="modal" data-bs-target="#searchModalRequestNo"
                                                        style="border-color:#d2d6da;border-left:3px solid #d2d6da;cursor: pointer;">
                                                        <i class="fas fa-search"></i>
                                                    </span>
                                                    <button class="btn btn-outline-secondary" type="button"
                                                        id="clear_filter_request_no">All</button>
                                                </div>
                                            </div>
                                        @endif

                                        {{-- Filter yang sudah ada (table_class filter) --}}
                                        <div class="col">
                                            {{-- set value filter --}}
                                                                                        @foreach ($filter as $key => $value)
                                                <input type="hidden" name="f{{ $key }}"
                                                    value="{{ $value }}" />
                                                @php
                                                    if (
                                                        preg_replace('/\s+/', '', strtolower(@$table_class->alias)) ==
                                                        preg_replace('/\s+/', '', strtolower($key))
                                                    ) {
                                                        $check_filter = $value == '%' ? '' : $value;
                                                    }
                                                @endphp
                                            @endforeach
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            {{-- RPTLAB TABLE (single table for all request_no) --}}
                            @if (isset($grouped_result) && count($grouped_result) > 0)
                                <div class="table-responsive">
                                    <table class="table table-bordered align-items-center mb-0" id="list_{{ $dmenu }}">
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>Request No</th>
                                                <th>Supplier</th>
                                                <th>Kode</th>
                                                <th>Dosis</th>
                                                <th><span style="text-transform: none !important;">L*</span></th>
                                                <th><span style="text-transform: none !important;">a*</span></th>
                                                <th><span style="text-transform: none !important;">b*</span></th>
                                                <th><span style="text-transform: none !important;">C*</span></th>
                                                <th><span style="text-transform: none !important;">h</span></th>
                                                <th><span style="text-transform: none !important;">ΔL*</span></th>
                                                <th><span style="text-transform: none !important;">Δa*</span></th>
                                                <th><span style="text-transform: none !important;">Δb*</span></th>
                                                <th><span style="text-transform: none !important;">ΔE*</span></th>
                                                <th>Ket</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @php
                                                $isFirstGroup = true;
                                            @endphp
                                            @foreach ($grouped_result as $requestNo => $group)
                                                @php
                                                    $target = $group['target'] ?? null;
                                                    $req = $group['request'] ?? null;
                                                    // Total rows for rowspan request_no:
                                                    // per supplier: 1 target row + N sample rows
                                                    $totalRows = 0;
                                                    foreach ($group['suppliers'] as $sName => $sRows) {
                                                        $totalRows += 1 + count($sRows);
                                                    }
                                                    $printedRequestNo = false;
                                                    // Add border-top for separator between different request_no groups (except first)
                                                    // Use same color as table border for consistency
                                                    $borderTopStyle = !$isFirstGroup ? 'border-top: 2px solid #dee2e6;' : '';
                                                    $isFirstGroup = false;
                                                @endphp
                                                {{-- Supplier blocks: each supplier starts with target row --}}
                                                @php
                                                    $isFirstSupplier = true;
                                                    $shouldShowBorder = !$isFirstGroup; // Store before isFirstGroup changes
                                                @endphp
                                                @foreach ($group['suppliers'] as $supplierName => $rows)
                                                    {{-- Target row (repeat per supplier) --}}
                                                    @php
                                                        // Only add border on first supplier row of each request_no group (except first group)
                                                        $rowBorderStyle = ($shouldShowBorder && $isFirstSupplier) ? $borderTopStyle : '';
                                                        $isFirstSupplier = false;
                                                    @endphp
                                                    <tr class="filter-request-row" data-request-no="{{ $requestNo }}" style="background-color:#fff8cc;font-weight:bold;">
                                                        @if (!$printedRequestNo)
                                                            <td rowspan="{{ $totalRows }}" style="vertical-align: top; background-color:#ffffff;{{ $rowBorderStyle }}">{{ $requestNo }}</td>
                                                            @php $printedRequestNo = true; @endphp
                                                        @endif
                                                        <td style="{{ $rowBorderStyle }}">SAMPLE TARGET</td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}">{{ $target?->L }}</td>
                                                        <td style="{{ $rowBorderStyle }}">{{ $target?->a }}</td>
                                                        <td style="{{ $rowBorderStyle }}">{{ $target?->b }}</td>
                                                        <td style="{{ $rowBorderStyle }}">{{ $target?->C }}</td>
                                                        <td style="{{ $rowBorderStyle }}">{{ $target?->h }}</td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                        <td style="{{ $rowBorderStyle }}"></td>
                                                    </tr>

                                                    {{-- Sample rows grouped by supplier with rowspan --}}
                                                    @foreach ($rows as $idx => $r)
                                                        <tr class="filter-request-row" data-request-no="{{ $requestNo }}">
                                                            @if ($idx === 0)
                                                                <td rowspan="{{ count($rows) }}">{{ $supplierName }}</td>
                                                            @endif
                                                            <td>{{ $r->code ?? '' }}</td>
                                                            <td>{{ $r->dosage !== null ? number_format($r->dosage, 2) . '%' : '' }}</td>
                                                            <td>{{ $r->tl_L ?? '' }}</td>
                                                            <td>{{ $r->tl_a ?? '' }}</td>
                                                            <td>{{ $r->tl_b ?? '' }}</td>
                                                            <td>{{ $r->tl_C ?? '' }}</td>
                                                            <td>{{ $r->tl_h ?? '' }}</td>
                                                            <td>{{ $r->delta_L ?? '' }}</td>
                                                            <td>{{ $r->delta_a ?? '' }}</td>
                                                            <td>{{ $r->delta_b ?? '' }}</td>
                                                            <td class="{{ isset($r->delta_E) && (float)$r->delta_E > 1 ? 'text-danger fw-bold' : 'text-success fw-bold' }}">{{ $r->delta_E !== null ? number_format((float)$r->delta_E, 2) : '' }}</td>
                                                            <td>{{ $r->ket ?? '' }}</td>
                                                        </tr>
                                                    @endforeach
                                                @endforeach
                                            @endforeach
                                        </tbody>
                                    </table>
                                </div>
                            @else
                                <div class="nav-wrapper"><code> Data not found!</code></div>
                            @endif
                        </div>

                        {{-- Modal Search Request No (from grouped_result) --}}
                        @if (isset($grouped_result) && count($grouped_result) > 0)
                            <div class="modal fade" id="searchModalRequestNo" tabindex="-1" role="dialog"
                                aria-labelledby="searchModalRequestNoLabel" aria-hidden="true">
                                <div class="modal-dialog modal-dialog-centered modal-lg" role="document">
                                    <div class="modal-content">
                                        <div class="modal-header">
                                            <h5 class="modal-title" id="searchModalRequestNoLabel">List Request No</h5>
                                            <button type="button" class="btn-close" data-bs-dismiss="modal"
                                                aria-label="Close">
                                                <span aria-hidden="true">&times;</span>
                                            </button>
                                        </div>
                                        <div class="modal-body table-responsive">
                                            <table class="table display" id="list_request_no_rptlab">
                                                <thead class="thead-light" style="background-color: #00b7bd4f;">
                                                    <tr>
                                                        <th width="20px">Action</th>
                                                        <th>Request No</th>
                                                    </tr>
                                                </thead>
                                                <tbody>
                                                    @foreach ($grouped_result as $request_no => $group)
                                                        <tr>
                                                            <td width="20px">
                                                                <span class="btn badge bg-primary badge-lg"
                                                                    onclick="selectRequestNoRptlab('{{ $request_no }}')">
                                                                    <i class="bi bi-check-circle me-1"></i> Select
                                                                </span>
                                                            </td>
                                                            <td>{{ $request_no }}</td>
                                                        </tr>
                                                    @endforeach
                                                </tbody>
                                            </table>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        @endif
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if ($table_result)
                                    <div class="nav-wrapper" id="noted"><code>Note : <i aria-hidden="true"
                                                style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active</code>
                                    </div>
                                @else
                                    <div class="nav-wrapper"><code> Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                {{-- file js in folder (resources/views/js) --}}
                @include('js.' . $dmenu);
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection
@push('js')
    <script>
        let columnAbjad = '';
        
        // Function to export to Excel
        function exportToExcel() {
            Swal.fire({
                title: 'Export Excel?',
                text: 'File Excel akan dibuat dan didownload.',
                icon: 'question',
                showCancelButton: true,
                confirmButtonColor: '#028284',
                cancelButtonColor: '#d33',
                confirmButtonText: 'Ya, Export',
                cancelButtonText: 'Batal'
            }).then((result) => {
                if (!result.isConfirmed) return;

                Swal.fire({
                    title: 'Sedang membuat file...',
                    text: 'Mohon tunggu sebentar',
                    allowOutsideClick: false,
                    allowEscapeKey: false,
                    didOpen: () => {
                        Swal.showLoading();
                    }
                });

                // Trigger download without leaving the page (avoid stuck modal)
                const url = '{{ URL::to("rptlab") }}?export=excel';
                const iframeId = 'rptlab-export-excel-iframe';
                let iframe = document.getElementById(iframeId);
                if (!iframe) {
                    iframe = document.createElement('iframe');
                    iframe.id = iframeId;
                    iframe.style.display = 'none';
                    document.body.appendChild(iframe);
                }
                // Add cache buster to ensure request fires
                const downloadUrl = url + '&_t=' + Date.now();
                iframe.onload = function() {
                    // Some browsers fire load after download response is handled
                    Swal.close();
                    iframe.onload = null;
                };
                iframe.src = downloadUrl;

                // Fallback: close modal shortly after download starts
                setTimeout(() => {
                    Swal.close();
                }, 1200);
            });
        }
        
        // Suppress DataTables warnings/errors globally - hide notifications only
        $.fn.dataTable.ext.errMode = 'none';
        // Override console.warn to suppress DataTables warnings
        var originalWarn = console.warn;
        console.warn = function() {
            // Suppress DataTables warnings
            if (arguments[0] && typeof arguments[0] === 'string' && arguments[0].includes('DataTables')) {
                return;
            }
            originalWarn.apply(console, arguments);
        };
        
        $(document).ready(function() {
            // Filter Request No (Show/Hide Rows) - hanya jika ada grouped_result
            @if (isset($grouped_result) && count($grouped_result) > 0)
            window.selectRequestNoRptlab = function(requestNo) {
                $('#filter_request_no').val(requestNo);
                const modalEl = document.getElementById('searchModalRequestNo');
                const modal = modalEl ? bootstrap.Modal.getInstance(modalEl) : null;
                if (modal) modal.hide();
                applyRequestNoFilter(requestNo);
            }

            function applyRequestNoFilter(selectedRequestNo) {
                if (!selectedRequestNo) {
                    $('.filter-request-row').show();
                } else {
                    $('.filter-request-row').hide();
                    $('.filter-request-row[data-request-no="' + selectedRequestNo + '"]').show();
                }
                // Redraw DataTable after filter to update pagination and info
                if ($.fn.DataTable.isDataTable('#list_{{ $dmenu }}')) {
                    try {
                        $('#list_{{ $dmenu }}').DataTable().draw(false);
                    } catch (e) {
                        console.log('DataTable redraw error (suppressed):', e);
                    }
                }
            }

            $('#clear_filter_request_no').click(function() {
                $('#filter_request_no').val('');
                applyRequestNoFilter('');
            });

            // init datatable for modal list
            if ($('#list_request_no_rptlab').length && $('#list_request_no_rptlab tbody tr').length > 0) {
                try {
                    $('#list_request_no_rptlab').DataTable({
                        paging: true,
                        searching: true,
                        ordering: true,
                        info: true,
                        pageLength: 10,
                        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)"
                        },
                        error: function(xhr, error, thrown) {
                            console.log('Modal DataTables error:', error);
                            return false;
                        }
                    });
                } catch (e) {
                    console.error('Modal DataTables initialization error:', e);
                }
            }
            @endif

            // Initialize DataTable first - only if table exists and has data
            let table = null;
            if ($('#list_{{ $dmenu }}').length && $('#list_{{ $dmenu }} tbody tr').length > 0) {
                try {
                    table = $('#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',
                        paging: true,
                        searching: true,
                        ordering: true,
                        info: true,
                        autoWidth: false,
                        // Handle rowspan properly
                        columnDefs: [
                            { orderable: false, targets: [0, 1] }, // Disable sorting on Request No and Supplier columns (have rowspan)
                            { targets: '_all', defaultContent: '' } // Set default content for empty cells
                        ],
                        // Prevent DataTables errors with rowspan
                        drawCallback: function(settings) {
                            // Ensure table is properly rendered
                            if (settings.api) {
                                settings.api.columns.adjust();
                            }
                        },
                        error: function(xhr, error, thrown) {
                            // Suppress error notifications completely - don't show to user
                            return false;
                        },
                        buttons: [{
                                text: '<i class="fas fa-file-excel me-1 text-lg text-success"> </i><span class="font-weight-bold"> Excel</span>',
                                action: function() {
                                    exportToExcel();
                                }
                            },
                            {
                                extend: 'pdfHtml5',
                                text: '<i class="fas fa-file-pdf me-1 text-lg text-danger"> </i><span class="font-weight-bold"> PDF',
                                orientation: 'landscape',
                                pageSize: 'A4',
                                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',
                                orientation: 'landscape',
                                pageSize: 'A4',
                                exportOptions: {
                                    columns: ':visible:not(:last-child)'
                                },
                            },
                        ]
                    });
                } catch (e) {
                    console.error('DataTables initialization error:', e);
                    // Suppress error notification to user
                }
            }

            // Setup column filter and other configurations after DataTable initialization
            if (table) {
                try {
                    let indexStatus = 0;
                    let numColumns = table.columns().count();
                    let columnNames = '';
                    let filter = '{{ @$table_class->alias }}'.toLowerCase();
                    for (let index = 0; index < numColumns; index++) {
                        columnNames = table.columns(index).header()[0].textContent;
                        filtercolom = columnNames.toLowerCase();
                        if (columnNames == 'Status' || columnNames == 'status' || columnNames == 'STATUS') {
                            columnAbjad = String.fromCharCode(65 + index);
                        }
                        if (filtercolom == filter) {
                            indexStatus = index;
                        }
                    }
                    //redraw table where filter
                    if ($('#{{ @$table_class->field }}').length) {
                        $('#{{ @$table_class->field }}').change(function() {
                            try {
                                table.column(indexStatus).search($(this).val()).draw();
                            } catch (e) {
                                console.log('Column filter error (suppressed):', e);
                            }
                        });
                    }
                } catch (e) {
                    console.log('Column setup error (suppressed):', e);
                }
            }
            //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> Data Expired )</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> Stock < Min Stock )</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> Data Expired ), ( <i aria-hidden="true"
                style="color: #f93c3c;" class="fas fa-circle"></i> Stock < Min Stock )</code>`)
            }
        });
        
        //set color button datatables - only if table exists
        if (table) {
            setTimeout(function() {
                $('.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/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>504</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>504</b><br />
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>505</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>505</b><br />
                <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>506</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmatchingcolor/resources/views/pages/rptlab/add.blade.php</b> on line <b>506</b><br />
            }, 100);
        }
        //function delete
        function deleteData(name, msg) {
            pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true
            else return false
        }
    </script>
@endpush