@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 Penilaian Univ</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">
                                        {{-- Back Button --}}
                                        <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>
                                    {{-- Filter Tahun for DataTables --}}
                                    <div class="col-md-3 ms-auto d-flex justify-content-end">
                                        <div class="col-auto">
                                            <label for="filter_tahun" class="me-2">Filter Tahun:</label>
                                            <select class="form-select" id="filter_tahun" name="filter_tahun"
                                                style="width: 150px;">
                                                <option value="">All</option>
                                                @php
                                                    $years = collect($table_result)->pluck('start_period')->map(function ($date) {
                                                        return \Carbon\Carbon::parse($date)->format('Y');
                                                    })->unique()->sort();
                                                @endphp
                                                @foreach($years as $year)
                                                    <option value="{{ $year }}">{{ $year }}</option>
                                                @endforeach
                                            </select>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <table class="table display" id="list_{{ $dmenu ?? 'result' }}">

                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th>No</th>

                                            <th>Nama</th>
                                            <th>Periode Magang</th>
                                            <th>Posisi</th>
                                            <th>Dokumen Penilaian</th>
                                            <th>Created At</th>
                                            <th>Updated At</th>
                                        </tr>
                                    </thead>
                                    <tbody>

                                        @foreach ($table_result as $index => $item)
                                            <tr>
                                                <td>{{ $loop->iteration }}</td>
                                                <td>{{ $item->nama }}</td>
                                                <td>{{ $item->start_period }} - {{ $item->end_period }}</td>
                                                <td>{{ $item->posisi }}</td>

                                                <td>
                                                    @if($item->dokumen)
                                                        @php
                                                            // Determine correct URL for document
                                                            if (str_starts_with($item->dokumen, 'storage/')) {
                                                                $documentUrl = asset($item->dokumen);
                                                            } elseif (str_starts_with($item->dokumen, 'http')) {
                                                                $documentUrl = $item->dokumen;
                                                            } else {
                                                                // Try storage first, then public
                                                                $documentUrl = asset('storage/' . $item->dokumen);
                                                            }
                                                        @endphp
                                                        <div class="d-flex align-items-center justify-content-center">
                                                            <a href="{{ $documentUrl }}" class="btn btn-sm btn-primary me-2" target="_blank" title="Lihat Dokumen">
                                                                <i class="fas fa-file-alt me-1"></i> Lihat
                                                            </a>
                                                        </div>
                                                    @else
                                                        <span class="text-muted fst-italic">
                                                            <i class="fas fa-file-slash me-1"></i>Tidak ada dokumen
                                                        </span>
                                                    @endif
                                                </td>

                                                <td>{{ $item->created_at }}</td>
                                                <td>{{ $item->updated_at }}</td>
                                            </tr>
                                        @endforeach

                                    </tbody>



                                </table>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                @if (!empty($table_result))
                                    <!-- Data exists, no additional message -->
                                @else
                                    <div class="nav-wrapper"><code>Data not found!</code></div>
                                @endif
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tambahkan script DataTables jika belum --}}
    @push('scripts')
        <script>
            $(document).ready(function () {
                $('#list_{{ $dmenu ?? 'result' }}').DataTable();
            });
        </script>
    @endpush

    {{-- check flag js on dmenu --}}
    @if ($jsmenu == '1')
        @if (view()->exists("js.{$dmenu}"))
            @push('addjs')
                {{-- file js in folder (resources/views/js) --}}
                @include('js.' . $dmenu);
            @endpush
        @else
            @push('addjs')
                <script>
                    Swal.fire({
                        title: 'JS Not Found!!',
                        text: 'Please Create File JS',
                        icon: 'error',
                        confirmButtonColor: '#028284'
                    });
                </script>
            @endpush
        @endif
    @endif
@endsection
@push('js')
    <script>
        let columnAbjad = '';
        $(document).ready(function () {
            let table = $('#list_{{ $dmenu }}').DataTable();
            let indexStatus = 0;
            let numColumns = $('#list_{{ $dmenu }}').DataTable().columns().count();
            let columnNames = '';
            let filter = '{{ @$table_class->alias }}'.toLowerCase();
            for (let index = 0; index < numColumns; index++) {
                columnNames = $('#list_{{ $dmenu }}').DataTable().columns(index).header()[0].textContent;
                filtercolom = columnNames.toLowerCase();
                if (columnNames == 'Status' || columnNames == 'Tipe Penilaian') {
                    indexStatus = index;
                }
                if (filtercolom == filter) {
                    indexStatus = index;
                }
            }
            //redraw table where filter
            $('#filter_status').change(function () {
                table.column(indexStatus).search($(this).val()).draw();
            });
            //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 table into datatables
        $('#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: [{
                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',
                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)'
                },
            },
            ]
        });
        //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/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>250</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>250</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>251</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>251</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>252</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/msjmagang/resources/views/report/rptpnun/result.blade.php</b> on line <b>252</b><br />
        //function delete
        function deleteData(name, msg) {
            pesan = confirm('Apakah Anda Yakin ' + msg + ' Data ' + name + ' ini ?');
            if (pesan) return true
            else return false
        }
    </script>
@endpush