@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100'])

<style>
    #list_{{ $dmenu }} tbody tr.not td {
        background-color: #ffc2cd !important;
    }

    #list_{{ $dmenu }} th:nth-child(n),
    #list_{{ $dmenu }} td:nth-child(n) {
        white-space: normal;
    }
</style>

@section('content')
    @include('layouts.navbars.auth.topnav', ['title' => ''])
    
    {{-- Alert untuk error --}}
    @if(session('error'))
        <div class="container-fluid">
            <div class="alert alert-danger alert-dismissible fade show" role="alert">
                <strong>Error!</strong> {{ session('error') }}
                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
            </div>
        </div>
    @endif

    <div class="container-fluid">
        {{-- Section Table --}}
        <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</span>
                                        </button>
                                    </div>
                                    <div class="col-md-3 md-auto justify-content-end row">
                                        <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 class="col">
                                            {{-- display label alias on class filter --}}
                                            Filter {{ @$table_class->alias }} :
                                            <select class="form-select" id="{{ @$table_class->field }}" style="width: 150px;">
                                                @if (@$table_class->query != '')
                                                    @if ($check_filter != '')
                                                        @php
                                                            $data_query = DB::select(@$table_class->query);
                                                        @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>73</b><br />
                                                            @if ($check_filter == $sAsArray[0])
                                                                <option value="{{ $sAsArray[0] }}">
                                                                    {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                                </option>
                                                            @endif
                                                        @endforeach
                                                    @else
                                                        <option value="" selected>% - All</option>
                                                        @php
                                                            $data_query = DB::select(@$table_class->query);
                                                        @endphp
                                                        @foreach ($data_query as $q)
                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>86</b><br />
                                                            <option value="{{ $sAsArray[0] }}">
                                                                {{ $sAsArray[0] }} - {{ $sAsArray[1] }}
                                                            </option>
                                                        @endforeach
                                                    @endif
                                                @endif
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu }}">
                                    @if ($table_result)
                                        <thead class="thead-light" style="background-color: #00b7bd4f;">
                                            <tr>
                                                <th>No</th>
                                                @foreach ($table_result as $result)
                                                    @php
                                                        $sAsArray = array_keys((array) $result);
                                                        $i = 0;
                                                    @endphp
                                                @endforeach
                                                @foreach ($sAsArray as $header)
                                                    @if (substr($header, 0, 3) == 'IMG')
                                                        <th>{{ substr($header, 4) }}</th>
                                                    @elseif (substr($header, 0, 3) == 'CDT')
                                                        <th>{{ substr($header, 6) . '-' . substr($header, 3, 2) }}</th>
                                                    @elseif (substr($header, 0, 3) == 'CST')
                                                        <th>{{ substr($header, 4) }}</th>
                                                    @elseif (substr($header, 0, 3) == 'HTM')
                                                        <th>{{ substr($header, 4) }}</th>
                                                    @else
                                                        <th>{{ $header }}</th>
                                                    @endif
                                                    @php
                                                        $i++;
                                                    @endphp
                                                @endforeach
                                            </tr>
                                        </thead>
                                        <tbody>
                                            @foreach ($table_result as $detail)
                                                <tr {{ @$detail->isactive == '0' ? 'class="not" style="background-color:#ffe9ed !important;"' : '' }}>
                                                    <td>{{ $loop->iteration }}</td>
                                                    @foreach ($table_result as $result)
                                                        @php
                                                            $field = array_keys((array) $result);
                                                            $i = 0;
                                                        @endphp
                                                    @endforeach
                                                    @foreach ($field as $header)
                                                        @php
                                                            $string = $header;
                                                            $img_id = '';
                                                            $characters = 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ';
                                                            for ($i = 0; $i < 10; $i++) {
                                                                $img_id .= $characters[mt_rand(0, strlen($characters) - 1)];
                                                            }
                                                        @endphp
                                                        @if (substr($string, 0, 3) == 'IMG')
                                                            <td class="text-sm font-weight-normal">
                                                                <span class="my-2 text-xs">
                                                                    <img src="{{ asset('/storage' . '/' . $detail->$string) }}"
                                                                        alt="image" style="height: 40px;"
                                                                        data-bs-toggle="modal"
                                                                        data-bs-target="#{{ $img_id }}">
                                                                </span>
                                                                <span style="display: none;">{{ asset('/storage' . '/' . $detail->$string) }}</span>
                                                                <!-- Modal -->
                                                                <div class="modal fade" id="{{ $img_id }}" tabindex="-1" role="dialog" aria-labelledby="imageModalLabel" aria-hidden="true">
                                                                    <div class="modal-dialog modal-dialog-centered" role="document">
                                                                        <div class="modal-content">
                                                                            <div class="modal-header">
                                                                                <h5 class="modal-title" id="imageModalLabel">Preview Image</h5>
                                                                                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close">
                                                                                    <span aria-hidden="true">&times;</span>
                                                                                </button>
                                                                            </div>
                                                                            <div class="modal-body">
                                                                                <img src="{{ asset('/storage' . '/' . $detail->$string) }}" id="preview" alt="image" class="w-100 border-radius-lg shadow-sm">
                                                                            </div>
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </td>
                                                        @elseif (substr($string, 0, 3) == 'CDT')
                                                            <td class="text-sm font-weight-normal {{ $detail->$string }}">
                                                                {{ $detail->$string }}
                                                            </td>
                                                            <script>
                                                                var inputDate = new Date('{{ $detail->$string }}');
                                                                var currentDate = new Date();
                                                                var futureDate = new Date(currentDate.setDate(currentDate.getDate() + parseInt('{{ substr($string, 3, 2) }}')));

                                                                if (inputDate <= futureDate) {
                                                                    $('.{{ $detail->$string }}').parents('tr').addClass('exp');
                                                                    $('.{{ $detail->$string }}').parents('tr').css('background-color', '#ffe768');
                                                                }
                                                            </script>
                                                        @elseif (substr($string, 0, 3) == 'CST')
                                                            <td class="text-sm font-weight-normal {{ $detail->$string }}">
                                                                {{ $detail->$string }}
                                                            </td>
                                                            <script>
                                                                if ('{{ $detail->$string }}' == 'FALSE') {
                                                                    $('.FALSE').parents('tr').addClass('stock');
                                                                    $('.FALSE').parents('tr').css('background-color', '#f93c3c');
                                                                    $('.FALSE').parents('tr').css('color', '#000');
                                                                }
                                                            </script>
                                                        @elseif (substr($string, 0, 3) == 'HTM')
                                                            <td class="text-sm font-weight-normal" style="min-width:220px; white-space: normal; vertical-align: top; line-height: 1.6;">
                                                                {!! trim($detail->$string) !!}
                                                            </td>
                                                        @else
                                                            <td class="text-sm font-weight-normal">{{ $detail->$string }}</td>
                                                        @endif
                                                        @php
                                                            $i++;
                                                        @endphp
                                                    @endforeach
                                                </tr>
                                            @endforeach
                                        </tbody>
                                    @endif
                                </table>
                            </div>
                        </div>
                        <!-- <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')
                @include('js.' . $dmenu)
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection

@push('js')
    <script>
        let columnAbjad = '';
        
        $(document).ready(function() {
            // Check if DataTable already exists and destroy it
            if ($.fn.DataTable.isDataTable('#list_{{ $dmenu }}')) {
                $('#list_{{ $dmenu }}').DataTable().destroy();
            }
            
            // Initialize DataTables
            let table = $('#list_{{ $dmenu }}').DataTable({
                "language": {
                    "search": "Cari :",
                    "searchPlaceholder": "Search...",
                    "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: [{
                        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: 'Vendor Report',
                        customize: function(xlsx) {
                            var sheet = xlsx.xl.worksheets['sheet1.xml'];
                            sheet.querySelectorAll('row c[r^="' + columnAbjad + '"]').forEach((row) => {
                                let cell = row.querySelector('is t');
                                if (cell && cell.textContent === 'Not Active') {
                                    row.setAttribute('s', '10');
                                }
                            });
                        },
                        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',
                        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)'
                        },
                    },
                ],
                "rowCallback": function(row, data, index) {
                    if ($(row).hasClass('not')) {
                        $(row).css('background-color', '#ffc2cd');
                    }
                },
                "drawCallback": function() {
                    $('#list_{{ $dmenu }} tbody tr.not').css('background-color', '#ffc2cd');
                }
            });

            table.columns().every(function() {
                let header = $(this.header()).text().trim();
                if (header === 'Created Date') {
                    $(this.header()).css('min-width', '130px');
                    $(this.nodes()).css('min-width', '130px');
                }
                if (header === 'Company Scope') {
                    $(this.header()).css('min-width', '130px');
                    $(this.nodes()).css('min-width', '130px');
                }
                if (header === 'Corporation') {
                    $(this.header()).css('min-width', '160px');
                    $(this.nodes()).css('min-width', '160px');
                }
                if (header === 'Name') {
                    $(this.header()).css('min-width', '300px');
                    $(this.nodes()).css('min-width', '300px');
                }
                if (header === 'Company Spec') {
                    $(this.header()).css('min-width', '200px');
                    $(this.nodes()).css('min-width', '200px');
                }
                if (header === 'Country') {
                    $(this.header()).css('min-width', '180px');
                    $(this.nodes()).css('min-width', '180px');
                }
                if (header === 'CP Email') {
                    $(this.header()).css('min-width', '300px');
                    $(this.nodes()).css('min-width', '300px');
                }
                if (header === 'Office Email') {
                    $(this.header()).css('min-width', '300px');
                    $(this.nodes()).css('min-width', '300px');
                }
            });

            // Find status column
            let indexStatus = 0;
            let numColumns = table.columns().count();
            let filter = '{{ @$table_class->alias }}'.toLowerCase();
            
            for (let index = 0; index < numColumns; index++) {
                let columnNames = table.columns(index).header()[0].textContent;
                let filtercolom = columnNames.toLowerCase();
                
                if (columnNames == 'Status' || columnNames == 'status' || columnNames == 'STATUS') {
                    columnAbjad = String.fromCharCode(65 + index);
                }
                if (filtercolom == filter) {
                    indexStatus = index;
                }
            }

            // Filter by status
            $('#{{ @$table_class->field }}').change(function() {
                table.column(indexStatus).search($(this).val()).draw();
            });

            // Update notes
            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>`);
            }
            
            // Chart styling button - moved inside ready()
            $('.dt-button').addClass('btn btn-secondary');
            $('.dt-button').removeClass('dt-button');
            
            // Authorization checks - moved inside ready()
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>400</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>400</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>401</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>401</b><br />
            <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>402</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjvendor/resources/views/report/rpvndr/result.blade.php</b> on line <b>402</b><br />
        });

        // Delete function
        function deleteData(name, msg) {
            pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true;
            else return false;
        }
    </script>
@endpush