@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">
                                @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 d-flex justify-content-between align-items-center">
                                    {{-- 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
                                    <form action="{{ url($url_menu) }}" method="GET" class="d-flex align-items-center">
                                        @csrf
                                        <select id="category" name="category" class="form-select form-select-sm me-2">
                                            <option value="">-- Select Category --</option>
                                             @if (isset($categories))
                                                @foreach($categories as $category)
                                                    <option value="{{ $category->id }}"
                                                        {{ request()->category == $category->id ? 'selected' : '' }}>
                                                        {{ $category->nama }}
                                                    </option>
                                                @endforeach
                                            @endif
                                        </select>
                                        <select id="dateType" name="dateType" class="form-select form-select-sm me-2">
                                            <option value="">-- Date Type --</option>
                                            <option value="1">Tanggal Terbit</option>
                                            <option value="2">Tanggal Mulai</option>
                                            <option value="3">Tanggal Expired</option>
                                        </select>
                                        <select id="isactive" name="isactive" class="form-select form-select-sm me-2">
                                            <option value="">-- Select Status --</option>
                                            <option value="1">Active</option>
                                            <option value="0">Non Active</option>
                                        </select>
                                        <input type="date" id="minDate" name="minDate"
                                            class="form-control form-control-sm me-2" />
                                        <input type="date" id="maxDate" name="maxDate"
                                            class="form-control form-control-sm me-2" />
                                        <button type="submit" class="btn btn-primary btn-sm">Filter</button>
                                        <a href="#" onclick="exportExcel(event, 'skaint')" class="btn btn-success btn-sm ms-2" style="white-space:nowrap;"><span class="font-weight-bold">Report</span> <i class="fas fa-file-excel ms-1"></i></a>
                                    </form>
                                </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: #dceafc;">
                                        <tr>
                                            <th>No</th>
                                            <th>File</th>

                                            {{-- retrieve table header --}}
                                            @foreach ($table_header as $header)
                                                <th>{{ $header->alias }}</th>
                                            @endforeach
                                            @if ($authorize->idroles == 'admins')
                                                <th>Created</th>
                                                <th>Updated</th>
                                            @endif
                                            <th>Action</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {{-- retrieve table detail --}}
                                        @foreach ($table_detail as $detail)
                                            @php
                                                $currentdate = \Carbon\Carbon::now();
                                                $tanggalexpired = \Carbon\Carbon::parse($detail->tanggal_expired);
                                                $reminderWeeks = (int) ($detail->reminder ?? 0);
                                                if ($reminderWeeks > 0 && $reminderWeeks % 52 === 0) {
                                                    $temp = $tanggalexpired->copy()->subYears(intdiv($reminderWeeks, 52));
                                                } elseif ($reminderWeeks > 0 && $reminderWeeks % 4 === 0) {
                                                    $temp = $tanggalexpired->copy()->subMonths(intdiv($reminderWeeks, 4));
                                                } else {
                                                    $temp = $tanggalexpired->copy()->subWeeks($reminderWeeks);
                                                }
                                                $booldate = $temp <= $currentdate ? true : false;
                                                // $booldateremind = ($detail->reminder != '' && $detail->reminder != null) ? true : false;
                                            @endphp

                                            @php
                                                $primary = '';
                                                foreach ($table_primary as $p) {
                                                    $primary == ''
                                                        ? ($primary = $detail->{$p->field})
                                                        : ($primary = $primary . ':' . $detail->{$p->field});
                                                }
                                                $vcount = $loop->iteration;
                                            @endphp

                                            <tr data-isactive="{{ $detail->isactive }}"
                                                @if ($booldate && strtolower($detail->status) != 'done') style="background-color:#ffc421;"
                                                @elseif ($booldate && strtolower($detail->status) != 'done')
                                                    style="background-color:#E9967A;"
                                                @else
                                                    {{ $detail->isactive == '0' ? 'class=not style=background-color:#ffe9ed;' : '' }} @endif>
                                                <td>{{ $vcount }}</td>

                                                <td>
                                                    @php
                                                        $boolfile = false;
                                                        foreach ($file as $f) {
                                                            if ($f->id_sk_aturan == $detail->id) {
                                                                $boolfile = true;
                                                            }
                                                        }
                                                    @endphp
                                                    @if ($boolfile)
                                                        <i class="fas fa-regular fa-file"></i>
                                                    @endif
                                                </td>
                                                @foreach ($table_header as $field)
                                                    @php

                                                        $string = $field->field;

                                                    @endphp
                                                    {{-- field type enum --}}
                                                    @if ($field->type == 'enum')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($field->field == 'status')
                                                                {{ $detail->$string }}
                                                            @else
                                                                {{ $detail->nama }}
                                                                @if ($field->link != '')
                                                                    <a target="_blank"
                                                                        href="{{ url($field->link . '/?id=' . encrypt($detail->$string)) }}">
                                                                        @if ($field->query != '')
                                                                            @php
                                                                                $data_query = DB::select($field->query);
                                                                            @endphp
                                                                            @foreach ($data_query as $q)
                                                                                <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>154</b><br />
                                                                                {{ $detail->$string == $sAsArray[0] ? $sAsArray[1] : '' }}
                                                                            @endforeach
                                                                        @endif
                                                                        &nbsp;&nbsp;
                                                                        <i aria-hidden="true" class="fas fa-external-link-alt">
                                                                        </i>
                                                                    </a>
                                                                @else
                                                                    @if ($field->query != '')
                                                                        @php
                                                                            $data_query = DB::select($field->query);
                                                                        @endphp
                                                                        @foreach ($data_query as $q)
                                                                            <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>168</b><br />
                                                                            {{ $detail->$string == $sAsArray[0] ? $sAsArray[1] : '' }}
                                                                        @endforeach
                                                                    @endif
                                                                @endif
                                                            @endif
                                                        </td>
                                                        {{-- field type file --}}
                                                    @elseif ($field->type == 'file')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($detail->$string)
                                                                <a target="_blank"
                                                                    class="btn btn-sm btn-outline-success mb-0 py-1 px-2"
                                                                    href="{{ asset('/storage' . '/' . $detail->$string) }}">
                                                                    <i aria-hidden="true" class="fas fa-file-lines text-lg">
                                                                    </i>
                                                                    {{ $field->alias }}</a>
                                                            @endif
                                                        </td>
                                                        {{-- field type image --}}
                                                    @elseif($field->type == 'image')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            <span class="my-2 text-xs">
                                                                <img src="{{ asset('/storage' . '/' . $detail->$string) }}"
                                                                    alt="image" style="height: 35px;"
                                                                    data-bs-toggle="modal"
                                                                    data-bs-target="#imageModal{{ $field->field }}{{ $vcount }}">
                                                            </span>
                                                            <span
                                                                style="display: none;">{{ asset('/storage' . '/' . $detail->$string) }}
                                                            </span>
                                                            <!-- Modal -->
                                                            <div class="modal fade"
                                                                id="imageModal{{ $field->field }}{{ $vcount }}"
                                                                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 class="modal-footer">
                                                                        </div>
                                                                    </div>
                                                                </div>
                                                            </div>
                                                        </td>
                                                        {{-- field type join --}}
                                                    @elseif($field->type == 'join')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            @if ($field->query != '')
                                                                @php
                                                                    $query =
                                                                        $field->query . "'" . $detail->$string . "'";
                                                                    $data_query = DB::select($query);
                                                                @endphp
                                                                @foreach ($data_query as $q)
                                                                    <br />
<b>Warning</b>:  Undefined variable $q in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>240</b><br />
                                                                    @if ($field->default != 'image')
                                                                        {{ $sAsArray[0] != '' ? $sAsArray[0] : '' }}
                                                                    @else
                                                                        <span class="my-2 text-xs">
                                                                            <img src="{{ asset('/storage' . '/' . $sAsArray[0]) }}"
                                                                                alt="image" style="height: 40px;"
                                                                                data-bs-toggle="modal"
                                                                                data-bs-target="#imageModalJoin{{ $field->field }}{{ $vcount }}">
                                                                        </span>
                                                                        <span
                                                                            style="display: none;">{{ asset('/storage' . '/' . $sAsArray[0]) }}
                                                                        </span>
                                                                        <!-- Modal -->
                                                                        <div class="modal fade"
                                                                            id="imageModalJoin{{ $field->field }}{{ $vcount }}"
                                                                            tabindex="-1" role="dialog"
                                                                            aria-labelledby="imageModalJoinLabel"
                                                                            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="imageModalJoinLabel">
                                                                                            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' . '/' . $sAsArray[0]) }}"
                                                                                            id="preview" alt="image"
                                                                                            class="w-100 border-radius-lg shadow-sm">
                                                                                    </div>
                                                                                    <div class="modal-footer">
                                                                                    </div>
                                                                                </div>
                                                                            </div>
                                                                        </div>
                                                                    @endif
                                                                @endforeach
                                                            @endif
                                                        </td>
                                                        {{-- field type currency --}}
                                                    @elseif ($field->type == 'currency')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            {{ $format->CurrencyFormat($detail->$string, $field->decimals, $field->sub) }}
                                                        </td>
                                                        {{-- field type date --}}
                                                    @elseif ($field->type == 'date')
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }} {{ $field->class == 'check-date' ? $detail->$string : '' }}">
                                                            {{ $detail->$string ? \Carbon\Carbon::parse($detail->$string)->translatedFormat('j M Y') : '' }}
                                                        </td>
                                                        @if ($field->note != '')
                                                            <p id="datenote" style="display: none">
                                                                {{ $field->note }}
                                                            </p>
                                                        @else
                                                            <p id="datenote" style="display: none">Date Expired <=
                                                                    {{ $field->length }} Day </p>
                                                        @endif
                                                        @if ($field->class == 'check-date')
                                                            <script>
                                                                var inputDate = new Date('{{ $detail->$string }}');
                                                                var currentDate = new Date();
                                                                var futureDate = new Date(currentDate.setDate(currentDate.getDate() + parseInt('{{ $field->length }}')));

                                                                if (inputDate <= futureDate) {
                                                                    $('.{{ $detail->$string }}').parents('tr').addClass('exp');
                                                                    $('.{{ $detail->$string }}').parents('tr').css('background-color', '#ffe768');
                                                                }
                                                            </script>
                                                        @endif
                                                    @else
                                                        <td
                                                            class="text-sm font-weight-{{ $field->primary == '1' ? 'bold text-dark' : 'normal' }}">
                                                            {{-- @dd($field) --}}
                                                            @if ($field->link != '')
                                                                <a target="_blank"
                                                                    href="{{ url($field->link . '/?id=' . encrypt($detail->$string)) }}">
                                                                    {{ $detail->$string }}&nbsp;&nbsp;
                                                                    <i aria-hidden="true"
                                                                        class="fas fa-external-link-alt">
                                                                    </i>
                                                                </a>
                                                            @elseif ($field->field == 'reminder' || $field->field == 'extend')
                                                                @if (!empty($detail->$string))
                                                                    {{ $detail->$string }} Minggu
                                                                @else
                                                                    {{ $detail->$string }}
                                                                @endif
                                                            @else
                                                                {{ $detail->$string }}
                                                            @endif
                                                        </td>
                                                    @endif
                                                @endforeach

                                                @if ($authorize->idroles == 'admins')
                                                    <td class="text-sm font-weight-normal">
                                                        {{ $detail->user_create }} -
                                                        {{ $detail->created_at != '0000-00-00' ? \Carbon\Carbon::parse($detail->created_at)->format('d/m/Y') : '' }}
                                                    </td>
                                                    <td class="text-sm font-weight-normal">
                                                        {{ $detail->user_update }} -
                                                        {{ $detail->updated_at != '0000-00-00' ? \Carbon\Carbon::parse($detail->updated_at)->format('d/m/Y') : '' }}
                                                    </td>
                                                @endif

                                                <td class="text-sm font-weight-normal">
                                                    {{-- button view --}}
                                                    <button type="button" class="btn btn-sm btn-primary mb-0"
                                                        title="View Data"
                                                        onclick="redirectToShow('{{ url($url_menu . '/show/' . encrypt($primary)) }}')">
                                                        <i class="fas fa-eye"> </i><span class="font-weight-bold">
                                                            View</span>
                                                    </button>
                                                    {{-- check authorize edit --}}
                                                    @if ($authorize->edit == '1')
                                                        {{-- check status active --}}
                                                        @if ($detail->isactive == 1)
                                                            {{-- button edit --}}
                                                            <button type="button" class="btn btn-sm btn-warning mb-0"
                                                                title="Edit Data"
                                                                onclick="redirectToEdit('{{ url($url_menu . '/edit/' . encrypt($primary)) }}')">
                                                                <i class="fas fa-edit"></i><span class="font-weight-bold">
                                                                    Edit</span>
                                                            </button>
                                                        @endif
                                                    @endif
                                                    {{-- check authorize delete and data primary key not "msjit" --}}
                                                    @if ($authorize->delete == '1' && $primary != 'msjit')
                                                        <form action="{{ url($url_menu . '/' . encrypt($primary)) }}"
                                                            method="POST" style="display: inline">
                                                            @csrf
                                                            @method('DELETE')
                                                            {{-- button delete --}}
                                                            <button type="submit"
                                                                class="btn btn-sm btn-{{ $detail->isactive == '0' ? 'success' : 'danger' }} mb-0"
                                                                title="Hapus Data"
                                                                onclick="return deleteData(event, '{{ $primary }}','{{ $detail->isactive == '0' ? 'Aktifkan' : 'Non Aktifkan' }}')">
                                                                <i class="fas fa-random"></i><span
                                                                    class="font-weight-bold">
                                                                    {{ $detail->isactive == '0' ? 'Aktifkan' : 'Non Aktifkan' }}</span>
                                                            </button>
                                                        </form>
                                                    @endif
                                                </td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                            </div>
                        </div>
                        <div class="row px-4 py-2">
                            <div class="col-lg">
                                <div class="d-flex flex-wrap align-items-center">
                                    <span class="text-sm font-weight-bold me-3 mb-2">Note:</span>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #BFEEB7; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data Perlu Diurus</span>
                                    </div>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #ffc421; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data Akan Expired</span>
                                    </div>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #E9967A; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data Sudah Expired</span>
                                    </div>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #BEC3EB; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data Berlaku Selamanya</span>
                                    </div>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #D5D8DC; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data No Need</span>
                                    </div>
                                    <div class="d-flex align-items-center me-3 mb-2">
                                        <i class="fas fa-square me-1" style="color: #ffe9ed; font-size: 1.1em;"></i>
                                        <span class="text-xs text-secondary font-weight-bold">Data Not Active</span>
                                    </div>
                                </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')
    <style>
        :root {
            --state-expired: #f6c4b6;
            --state-remind: #ffe08a;
            --state-notdone: #cfeec6;
            --state-notactive: #f4d7df;
            --state-noneed: #d8e0ea;
            --state-lifetime: #d8d0ff;
            --state-border: #c7d3e2;
            --text-soft: #3f4f64;
            --row-shadow: rgba(33, 52, 76, 0.04);
        }

        #list_{{ $dmenu }} {
            border-collapse: separate;
            border-spacing: 0;
        }

        #list_{{ $dmenu }} tbody tr td {
            border-bottom: 1px solid var(--state-border);
            color: var(--text-soft);
            font-weight: 500;
        }

        #list_{{ $dmenu }} tbody tr {
            transition: background-color 0.2s ease, transform 0.18s ease, box-shadow 0.18s ease;
        }

        #list_{{ $dmenu }} tbody tr:hover td {
            filter: brightness(0.97);
        }

        #list_{{ $dmenu }} tbody tr:hover {
            transform: translateY(-1px);
            box-shadow: 0 2px 8px var(--row-shadow);
        }

        .warna-exp td {
            background-color: var(--state-expired) !important;
        }

        .warna-remind td {
            background-color: var(--state-remind) !important;
        }

        .warna-hijau td {
            background-color: var(--state-notdone) !important;
        }

        .warna-naktif td {
            background-color: var(--state-notactive) !important;
        }

        .warna-noneed td {
            background-color: var(--state-noneed) !important;
        }

        .warna-berlakudone td {
            background-color: var(--state-lifetime) !important;
        }

        .noted code {
            display: inline-flex;
            align-items: center;
            gap: 6px;
            padding: 5px 11px;
            border-radius: 999px;
            background: #f1f5fb;
            border: 1px solid #d8e2ef;
            color: #42556d;
            font-size: 0.92rem;
            margin: 2px 4px 2px 0;
            font-family: inherit;
            font-weight: 600;
        }

        .pdf-btn {
            background-color: #8392ab !important;
            color: white !important;
            font-weight: bold;
            border: none;
            border-radius: 5px !important;
            padding: 8px 15px;
            align-items: center;
            justify-content: center;
            font-size: 1rem;
        }

        .pdf-btn:hover {

            transform: scale(1.05);
            box-shadow: #f5365c;
            ;
        }

        .pdf-btn i {

            font-size: 1.4em;
            margin-right: 10px;
        }

        .pdf-btn:focus {

            outline: none;
            box-shadow: 0 0 0 3px rgba(255, 193, 7, 0.5);
        }

        .print-btn {
            background-color: #8392ab !important;
            color: white !important;
            font-weight: bold;
            border: none;
            border-radius: 5px !important;
            padding: 8px 15px;
            align-items: center;
            justify-content: center;
            font-size: 1rem;
        }

        .print-btn:hover {

            transform: scale(1.05);
            box-shadow: #f5365c;
            ;
        }

        .print-btn i {

            font-size: 1.4em;
            margin-right: 10px;
        }

        .print-btn:focus {

            outline: none;
            box-shadow: 0 0 0 3px rgba(255, 193, 7, 0.5);
        }

        .excel-btn {
            background-color: #8392ab !important;
            color: white !important;
            font-weight: bold;
            border: none;
            border-radius: 5px !important;
            padding: 8px 15px;
            align-items: center;
            justify-content: center;
            font-size: 1rem;
        }

        .excel-btn:hover {

            transform: scale(1.05);
            box-shadow: #f5365c;
            ;
        }

        .excel-btn i {

            font-size: 1.4em;
            margin-right: 10px;
        }

        .excel-btn:focus {

            outline: none;
            box-shadow: 0 0 0 3px rgba(255, 193, 7, 0.5);
        }
    </style>
    <style>
        .warna-berlaku td {
            background-color: #e8f2f7 !important;
        }
    </style>
    <script>
        function redirectToEdit(baseUrl) {
            const table = $('#list_{{ $dmenu }}').DataTable();
            const currentPage = table.page() + 1;
            const finalUrl = baseUrl + '?page=' + currentPage;
            window.location.href = finalUrl;
        }

        function redirectToShow(baseUrl) {
            const table = $('#list_{{ $dmenu }}').DataTable();
            const currentPage = table.page() + 1;
            const finalUrl = baseUrl + '?page=' + currentPage;
            window.location.href = finalUrl;
        }
        document.addEventListener('DOMContentLoaded', function() {
            const rows = document.querySelectorAll('#list_skaint tbody tr');
            const headers = document.querySelectorAll('#list_skaint thead tr');

            rows.forEach(row => {
                if (row.cells[9]) row.cells[9].style.display = 'none';
                if (row.cells[12]) row.cells[12].style.display = 'none';
                if (row.cells[13]) row.cells[13].style.display = 'none';
            });

            headers.forEach(headerRow => {
                if (headerRow.cells[9]) headerRow.cells[9].style.display = 'none';
                if (headerRow.cells[12]) headerRow.cells[12].style.display = 'none';
                if (headerRow.cells[13]) headerRow.cells[13].style.display = 'none';
            });
        });
    </script>
    <script>
        let columnAbjad = '';

        // Custom sort for status column: DONE -> NOT DONE -> NO NEED
        $.fn.dataTable.ext.type.order['status-custom-pre'] = function(d) {
            var s = (d || '').toString().toLowerCase().trim();
            if (s === 'not done') return 1;
            if (s === 'done') return 2;
            if (s === 'no need') return 3;
            return 4;
        };

        $.fn.dataTable.ext.type.order['date-dd-mmm-yyyy-pre'] = function(d) {
            if (!d) return 0;
            const [day, month, year] = d.split(/[\/\-\s]/);
            const months = {
                Jan: 0,
                Feb: 1,
                Mar: 2,
                Apr: 3,
                May: 4,
                Jun: 5,
                Jul: 6,
                Aug: 7,
                Sep: 8,
                Oct: 9,
                Nov: 10,
                Dec: 11
            };
            return new Date(year, months[month] || month - 1, day).getTime();
        };

        $(document).ready(function() {
            const tableId = '#list_{{ $dmenu }}';

            let pageFromUrl = new URLSearchParams(window.location.search).get("page");
            let rowsPerPage = 10;
            let displayStart = 0;

            if (pageFromUrl && !isNaN(pageFromUrl)) {
                displayStart = (parseInt(pageFromUrl) - 1) * rowsPerPage;
            }

            // Jika sudah ada DataTable, hancurkan dulu
            if ($.fn.DataTable.isDataTable(tableId)) {
                $(tableId).DataTable().destroy();
            }

            // Cari index kolom berdasarkan nama header
            const headers = $(tableId + ' thead th').map(function() {
                return $(this).text().trim().toLowerCase();
            }).get();

            const statusIdx = headers.findIndex(h => h === 'status');
            const kategoriIdx = headers.findIndex(h => h === 'kategori');
            const tanggalTerbitIdx = headers.findIndex(h => h.includes('tanggal terbit'));
            const tanggalExpiredIdx = headers.findIndex(h => h.includes('tanggal expired') || h.includes('expired'));
            const masaBerlakuIdx = headers.findIndex(h => h.includes('berlaku selamanya') || h.includes('masa berlaku'));
            const reminderIdx = headers.findIndex(h => h === 'reminder');

            console.log('Column indexes - Status:', statusIdx, 'TglExpired:', tanggalExpiredIdx, 'MasaBerlaku:', masaBerlakuIdx, 'Reminder:', reminderIdx);

            const table = $(tableId).DataTable({
                createdRow: function(row, data, dataIndex) {
                    const status = (data[statusIdx >= 0 ? statusIdx : 2] || '').toString().toLowerCase();
                    const tanggalStr = data[tanggalExpiredIdx >= 0 ? tanggalExpiredIdx : 10] || '';
                    const masaberlaku = data[masaBerlakuIdx >= 0 ? masaBerlakuIdx : 9];
                    const aktif = row.getAttribute('data-isactive');

                    const reminderStr = data[reminderIdx >= 0 ? reminderIdx : -1] || '';
                    const reminderWeeks = parseInt(reminderStr) || 0;

                    const now = new Date();
                    const today = new Date(now.getFullYear(), now.getMonth(), now.getDate());

                    function parseTanggal(str) {
                        if (!str) return null;
                        const months = {
                            'jan': 0, 'feb': 1, 'mar': 2, 'apr': 3, 'may': 4, 'jun': 5,
                            'jul': 6, 'aug': 7, 'sep': 8, 'oct': 9, 'nov': 10, 'dec': 11,
                            'mei': 4, 'agu': 7, 'okt': 9, 'des': 11
                        };
                        const parts = str.toString().trim().split(/[\s\/\-]+/);
                        if (parts.length >= 3) {
                            const day = parseInt(parts[0]);
                            const monthStr = parts[1].toLowerCase().substring(0, 3);
                            const year = parseInt(parts[2]);
                            if (!isNaN(day) && !isNaN(year) && months.hasOwnProperty(monthStr)) {
                                return new Date(year, months[monthStr], day);
                            }
                            const mm = parseInt(parts[1]);
                            if (!isNaN(mm)) {
                                return new Date(year, mm - 1, day);
                            }
                        }
                        return new Date(str);
                    }

                    const tanggal = parseTanggal(tanggalStr);
                    const tanggalOnly = tanggal ? new Date(tanggal.getFullYear(), tanggal.getMonth(), tanggal.getDate()) : null;
                    let reminderStart = null;
                    if (tanggalOnly && reminderWeeks > 0) {
                        reminderStart = new Date(tanggalOnly);
                        if (reminderWeeks % 52 === 0) {
                            reminderStart.setFullYear(reminderStart.getFullYear() - Math.floor(reminderWeeks / 52));
                        } else if (reminderWeeks % 4 === 0) {
                            reminderStart.setMonth(reminderStart.getMonth() - Math.floor(reminderWeeks / 4));
                        } else {
                            reminderStart.setDate(reminderStart.getDate() - (reminderWeeks * 7));
                        }
                    }

                    const hasFile = (data[1] || '').toString().includes('fa-file');

                    $(row).removeClass(
                        'warna-exp warna-remind warna-nonactive warna-army warna-hijau warna-naktif warna-berlaku warna-berlakudone warna-noneed'
                    );

                    if (aktif == 0 || aktif === '0') {
                        $(row).addClass('warna-naktif');
                    } else if (status === 'done') {
                        if (tanggalOnly && tanggalOnly < today) {
                            $(row).addClass('warna-exp');
                        }

                        if (tanggalOnly && tanggalOnly >= today && reminderStart && today >= reminderStart) {
                            $(row).addClass('warna-remind');
                        }

                        if (masaberlaku === "1" || masaberlaku === 1 || masaberlaku === "Ya" || masaberlaku === "ya") {
                            $(row).addClass('warna-berlakudone');
                        }

                        if (!hasFile) {
                            $(row).addClass('warna-army');
                        }
                    } else if (status === 'not done') {
                        $(row).addClass('warna-hijau');
                    } else if (status === 'no need') {
                        $(row).addClass('warna-noneed');
                    }

                    // Set sort priority: active rows first (1-3), inactive last (5)
                    var sortPriority = 4;
                    if (status === 'not done') sortPriority = 1;
                    else if (status === 'done') sortPriority = 2;
                    else if (status === 'no need') sortPriority = 3;
                    if (aktif == 0 || aktif === '0') sortPriority = 5;
                    if (statusIdx >= 0) $('td', row).eq(statusIdx).attr('data-order', sortPriority);
                },
                drawCallback: function(settings) {
                    var api = this.api();
                    var start = api.page.info().start;
                    api.column(0, { page: 'current' }).nodes().each(function(cell, i) {
                        cell.innerHTML = start + i + 1;
                    });
                },
                destroy: true,
                displayStart: displayStart,
                pageLength: rowsPerPage,
                responsive: true,
                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)",
                    paginate: {
                        previous: "<i class='fas fa-chevron-left'></i> Sebelumnya",
                        next: "Selanjutnya <i class='fas fa-chevron-right'></i>"
                    }
                },
                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)',
                            rows: function(idx, data, node) {
                                return $(node).attr('data-isactive') !== '0';
                            }
                        },
                        className: 'btn btn-sm excel-btn'
                    },
                    {
                        extend: 'pdfHtml5',
                        text: '<i class="fas fa-file-pdf me-2 text-lg text-danger"></i><span class="font-weight-bold"> PDF</span>',
                        exportOptions: {
                            columns: ':visible:not(:last-child)',
                            rows: function(idx, data, node) {
                                return $(node).attr('data-isactive') !== '0';
                            }
                        },
                        className: 'btn btn-sm pdf-btn'
                    },
                    {
                        extend: 'print',
                        text: '<i class="fas fa-print me-1 text-lg text-info"> </i><span class="font-weight-bold"> Print</span>',
                        exportOptions: {
                            columns: ':visible:not(:last-child)',
                            rows: function(idx, data, node) {
                                return $(node).attr('data-isactive') !== '0';
                            }
                        },
                        className: 'btn btn-sm print-btn'
                    },
                ],
                order: [[statusIdx, 'asc'], [kategoriIdx >= 0 ? kategoriIdx : 2, 'asc'], [tanggalTerbitIdx >= 0 ? tanggalTerbitIdx : 3, 'asc']],
                columnDefs: [
                    {
                        targets: statusIdx,
                        type: 'num',
                        render: function(data, type, fullRow, meta) {
                            if (type === 'sort' || type === 'type') {
                                var tr = meta.settings.aoData[meta.row].nTr;
                                var isactive = tr ? tr.getAttribute('data-isactive') : '1';
                                if (isactive == '0') return 5;
                                var s = (data || '').toString().toLowerCase().trim();
                                if (s === 'not done') return 1;
                                if (s === 'done') return 2;
                                if (s === 'no need') return 3;
                                return 4;
                            }
                            return data;
                        }
                    },
                    {
                        targets: tanggalTerbitIdx >= 0 ? tanggalTerbitIdx : [],
                        type: 'num',
                        render: function(data, type, fullRow, meta) {
                            if (type === 'sort' || type === 'type') {
                                if (!data) return 0;
                                var months = {jan:0,feb:1,mar:2,apr:3,may:4,jun:5,jul:6,aug:7,sep:8,oct:9,nov:10,dec:11,mei:4,agu:7,okt:9,des:11};
                                var parts = data.toString().trim().split(/[\s\/\-]+/);
                                if (parts.length >= 3) {
                                    var d = parseInt(parts[0]), m = months[parts[1].toLowerCase().substring(0,3)], y = parseInt(parts[2]);
                                    if (!isNaN(d) && !isNaN(y) && m !== undefined) return new Date(y, m, d).getTime();
                                }
                                return new Date(data).getTime() || 0;
                            }
                            return data;
                        }
                    },
                    { targets: 'date-column', type: 'date-dd-mmm/yyyy' }
                ]
            });

            table.on('page', function() {
                const pageInfo = table.page.info(); // Mendapatkan info halaman yang sedang aktif
                const pageNumber = pageInfo.page +
                    1; // Menambah 1 karena DataTables menghitung halaman mulai dari 0
                const newUrl = `{{ URL::to('/') }}/skaint?page=${pageNumber}`;

                // Memperbarui URL tanpa me-refresh halaman
                window.history.pushState({
                    page: pageNumber
                }, `Page ${pageNumber}`, newUrl);
            });

            function updateLegendNote() {
                const hasExp = $('.exp').length > 0;

                // Mendapatkan elemen #noted
                const noted = $('#noted');

                if (hasExp) {
                    // Jika ada elemen dengan class "exp", tambahkan status baru tanpa mengganti yang lama
                    noted.html(`
                    <code>Note Status Not Done: 
                        <i aria-hidden="true" style="color: #BFEEB7;" class="fas fa-circle"></i> Data Perlu Diururs
                    </code>
                    <code>
                        <i aria-hidden="true" style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active
                    </code>
                    <code>Note Status Done:
                        <i aria-hidden="true" style="color: #ffc421;" class="fas fa-circle"></i> Data Akan Expired
                    </code>
                    <code>
                        <i aria-hidden="true" style="color: #F08080;" class="fas fa-circle"></i> Data Sudah Expired
                    </code>
                    <code>
                        <i aria-hidden="true" style="color: #ffc2cd;" class="fas fa-circle"></i> Data not active
                    </code>
                    `);
                } else {
                    // Jika tidak ada elemen dengan class "exp", kosongkan #noted atau tampilkan pesan alternatif
                    noted.html(`
                <code>Note: Tidak ada data expired</code>
                    `);
                }
            }

            let columnAbjad = '';
            let numColumns = table.columns().count();
            for (let i = 0; i < numColumns; i++) {
                let columnName = table.column(i).header().textContent.trim();
                if (columnName.toLowerCase() === 'status') {
                    columnAbjad = String.fromCharCode(65 + i);
                    break;
                }
            }
        });

        //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/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>988</b><br />
<br />
<b>Warning</b>:  Attempt to read property "excel" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>988</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>989</b><br />
<br />
<b>Warning</b>:  Attempt to read property "pdf" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>989</b><br />
        <br />
<b>Warning</b>:  Undefined variable $authorize in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>990</b><br />
<br />
<b>Warning</b>:  Attempt to read property "print" on null in <b>/opt/lampp/htdocs/tsidocmanagement/resources/views/manual/skaint/list.blade.php</b> on line <b>990</b><br />
        //function delete
        function deleteData(event, name, msg, baseUrl) {
            event.preventDefault();
            Swal.fire({
                title: 'Konfirmasi',
                text: `Apakah Anda Yakin ${msg} Data ${name} ini?`,
                icon: 'warning',
                showCancelButton: true,
                confirmButtonText: `Ya, ${msg}`,
                cancelButtonText: 'Batal',
                confirmButtonColor: '#028284'
            }).then((result) => {
                if (result.isConfirmed) {
                    const table = $('#list_{{ $dmenu }}').DataTable();
                    const currentPage = table.page() + 1;
                    const finalUrl = baseUrl + '?page=' + currentPage;
                    window.location.href = finalUrl;
                    event.target.closest('form').submit();
                }
            });
        }

        $(function() {
            $('#dateRange').daterangepicker({
                opens: 'left',
                locale: {
                    format: 'DD/MM/YYYY' // Adjust the format to match your date format
                }
            }, function(start, end, label) {
                console.log("A new date selection was made: " + start.format('YYYY-MM-DD') + ' to ' + end
                    .format('YYYY-MM-DD'));
                filterByDate(start, end);
            });
        });

        function filterByDate(start, end) {
            $('#list_{{ $dmenu }} tbody tr').each(function() {
                var dateText = $(this).find('td.date-column')
                    .text(); // Adjust the selector to match your date column
                var date = moment(dateText, 'DD/MM/YYYY'); // Adjust the format to match your date format

                if (date.isBetween(start, end, null, '[]')) {
                    $(this).show();
                } else {
                    $(this).hide();
                }
            });
        }
        $(function() {
            $('#minDate, #maxDate').datepicker({
                dateFormat: 'dd/mm/yy' // Adjust the format to match your date format
            });
        });

        function exportExcel(e, menu) {
            e.preventDefault();
            var params = new URLSearchParams();
            var category = document.getElementById('category').value;
            var dateType = document.getElementById('dateType').value;
            var isactive = document.getElementById('isactive').value;
            var minDate = document.getElementById('minDate').value;
            var maxDate = document.getElementById('maxDate').value;
            if (category) params.append('category', category);
            if (dateType) params.append('dateType', dateType);
            if (isactive !== '') params.append('isactive', isactive);
            if (minDate) params.append('minDate', minDate);
            if (maxDate) params.append('maxDate', maxDate);
            var url = '{{ url("export") }}/' + menu;
            if (params.toString()) url += '?' + params.toString();
            window.location.href = url;
        }
    </script>
@endpush