@extends('layouts.index')

@push('style')
    <link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.1.0/css/buttons.dataTables.min.css">
@endpush

@section('content')
    @php
        $tahunSelected = request('tahun', date('Y'));
        $bulanLabel = [
            1 => 'Jan',
            2 => 'Feb',
            3 => 'Mar',
            4 => 'Apr',
            5 => 'Mei',
            6 => 'Jun',
            7 => 'Jul',
            8 => 'Agu',
            9 => 'Sep',
            10 => 'Okt',
            11 => 'Nov',
            12 => 'Des',
        ];
    @endphp

    <div class="row mb-4">
        <div class="col-md-12">
            <div class="card">
                <div class="card-body">
                    <form style="width: 100%;" method="GET">
                        <div class="form-group">
                            <div class="row">
                                <div class="col-md-3">
                                    <label class="form-control-label">Pilih Tahun : </label>
                                    <select name="tahun" class="form-control select2" data-toggle="select">
                                        <option value="">Pilih Tahun</option>
                                        @for ($i = 2020; $i <= date('Y'); $i++)
                                            <option value="{{ $i }}"
                                                {{ (string) $i === (string) $tahunSelected ? 'selected' : '' }}>
                                                {{ $i }}
                                            </option>
                                        @endfor
                                    </select>
                                </div>
                            </div>
                        </div>
                        <div class="row mt-3">
                            <div class="col-md-12">
                                <button class="btn btn-info btn-sm" type="submit">Tampil</button>
                                <a href="{{ url()->current() }}" class="btn btn-info btn-sm">Refresh</a>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>

    @php
        // ======= TOTAL KESELURUHAN (untuk footer) =======
        $grandSP = 0;
        $grandCP = 0;
        $grandKP = 0;
        $grandTP = 0;
        $grandTotalSurvei = 0;

        foreach ($datas as $d) {
            $uid = $d->id;

            $sp = $surveiStatusTotalMap[$uid]['Sangat Puas'] ?? 0;
            $cp = $surveiStatusTotalMap[$uid]['Cukup Puas'] ?? 0;
            $kp = $surveiStatusTotalMap[$uid]['Kurang Puas'] ?? 0;
            $tp = $surveiStatusTotalMap[$uid]['Tidak Puas'] ?? 0;

            $grandSP += $sp;
            $grandCP += $cp;
            $grandKP += $kp;
            $grandTP += $tp;

            $grandTotalSurvei += $surveiTotalMap[$uid] ?? 0;
        }

        $grandAvgScore =
            $grandTotalSurvei > 0
                ? round(($grandSP * 4 + $grandCP * 3 + $grandKP * 2 + $grandTP * 1) / $grandTotalSurvei, 2)
                : 0;

        $grandKepuasan = $grandTotalSurvei > 0 ? round((($grandSP + $grandCP) / $grandTotalSurvei) * 100) : 0;
    @endphp

    <div class="row">
        <div class="col-lg-12">
            <div class="card mb-4">
                <div class="card-header py-3 d-flex flex-row align-items-center justify-content-between">
                    <h6 class="m-0 font-weight-bold text-primary">
                        Laporan Survei Admin - {{ $tahunSelected }}
                    </h6>
                </div>

                <div class="table-responsive p-3">
                    <div class="alert alert-light border mb-3" style="font-size: 13px; line-height: 1.7;">
                        <div class="font-weight-bold mb-1">Keterangan Status Survei</div>
                        <div class="mb-2">
                            <span class="badge badge-success mr-1">SP</span> Sangat Puas (Skor 4) &nbsp; | &nbsp;
                            <span class="badge badge-primary mr-1">CP</span> Cukup Puas (Skor 3) &nbsp; | &nbsp;
                            <span class="badge badge-warning mr-1">KP</span> Kurang Puas (Skor 2) &nbsp; | &nbsp;
                            <span class="badge badge-danger mr-1">TP</span> Tidak Puas (Skor 1)
                        </div>

                        <div class="font-weight-bold mb-1">Keterangan Persentase</div>
                        <ul class="mb-2" style="padding-left: 18px;">
                            <li><b>% Kepuasan</b> = (SP + CP) / Total Survei × 100%</li>
                        </ul>

                        <small class="text-muted d-block">
                            Catatan: Status dihitung dari rata-rata skor <b>bagian B</b> (7 pertanyaan), lalu dibulatkan.
                        </small>
                    </div>

                    <table class="table align-items-center table-flush table-hover dataTableLaporanSurvei">
                        <thead class="thead-light">
                            <tr>
                                <th rowspan="2" class="align-middle text-center">#</th>
                                <th rowspan="2" class="align-middle">Nama Admin</th>
                                <th rowspan="2" class="align-middle">Email</th>

                                @for ($m = 1; $m <= 12; $m++)
                                    <th colspan="4" class="text-center">{{ $bulanLabel[$m] }}</th>
                                @endfor

                                <th colspan="4" class="text-center">Total Status (Setahun)</th>
                                <th rowspan="2" class="align-middle text-center">Total Survei</th>
                                <th rowspan="2" class="align-middle text-center">% Kepuasan</th>
                            </tr>

                            <tr>
                                @for ($m = 1; $m <= 12; $m++)
                                    <th class="text-center">SP</th>
                                    <th class="text-center">CP</th>
                                    <th class="text-center">KP</th>
                                    <th class="text-center">TP</th>
                                @endfor

                                <th class="text-center">SP</th>
                                <th class="text-center">CP</th>
                                <th class="text-center">KP</th>
                                <th class="text-center">TP</th>
                            </tr>
                        </thead>

                        <tbody>
                            @foreach ($datas as $data)
                                @php
                                    $uid = $data->id;

                                    $totalSurvei = $surveiTotalMap[$uid] ?? 0;

                                    $spY = $surveiStatusTotalMap[$uid]['Sangat Puas'] ?? 0;
                                    $cpY = $surveiStatusTotalMap[$uid]['Cukup Puas'] ?? 0;
                                    $kpY = $surveiStatusTotalMap[$uid]['Kurang Puas'] ?? 0;
                                    $tpY = $surveiStatusTotalMap[$uid]['Tidak Puas'] ?? 0;

                                    $kepuasan = $totalSurvei > 0 ? round((($spY + $cpY) / $totalSurvei) * 100) : 0;
                                @endphp

                                <tr>
                                    <td class="text-center">{{ $loop->iteration }}</td>
                                    <td>{{ $data->name }}</td>
                                    <td>{{ $data->email }}</td>

                                    @for ($m = 1; $m <= 12; $m++)
                                        @php
                                            $sp = $surveiMonthStatusMap[$uid][$m]['Sangat Puas'] ?? 0;
                                            $cp = $surveiMonthStatusMap[$uid][$m]['Cukup Puas'] ?? 0;
                                            $kp = $surveiMonthStatusMap[$uid][$m]['Kurang Puas'] ?? 0;
                                            $tp = $surveiMonthStatusMap[$uid][$m]['Tidak Puas'] ?? 0;
                                        @endphp

                                        <td class="text-center"><b>{{ $sp }}</b></td>
                                        <td class="text-center"><b>{{ $cp }}</b></td>
                                        <td class="text-center"><b>{{ $kp }}</b></td>
                                        <td class="text-center"><b>{{ $tp }}</b></td>
                                    @endfor

                                    <td class="text-center"><b>{{ $spY }}</b></td>
                                    <td class="text-center"><b>{{ $cpY }}</b></td>
                                    <td class="text-center"><b>{{ $kpY }}</b></td>
                                    <td class="text-center"><b>{{ $tpY }}</b></td>

                                    <td class="text-center"><b>{{ $totalSurvei }}</b></td>

                                    <td class="text-center">
                                        <span class="badge badge-success"
                                            style="font-size: 12px;">{{ $kepuasan }}%</span>
                                    </td>
                                </tr>
                            @endforeach
                        </tbody>

                        {{-- ======= FOOTER (SKOR TOTAL KESELURUHAN) ======= --}}
                        <tfoot>
                            <tr>
                                <td colspan="57" class="text-left">
                                    <b>Skor Rata-rata Keseluruhan:</b> {{ $grandAvgScore }}
                                    &nbsp; | &nbsp;
                                    <b>Total Survei:</b> {{ $grandTotalSurvei }}
                                    &nbsp; | &nbsp;
                                    <b>SP:</b> {{ $grandSP }}
                                    <b>CP:</b> {{ $grandCP }}
                                    <b>KP:</b> {{ $grandKP }}
                                    <b>TP:</b> {{ $grandTP }}
                                    &nbsp; | &nbsp;
                                    <b>% Kepuasan:</b> {{ $grandKepuasan }}%
                                </td>
                            </tr>
                        </tfoot>
                    </table>

                    <small class="text-muted d-block mt-2">
                        SP=4, CP=3, KP=2, TP=1 (hasil dari rata-rata skor B / 7 pertanyaan).
                        % Kepuasan = (SP+CP)/Total Survei.
                    </small>
                </div>
            </div>
        </div>
    </div>
@endsection

@push('script')
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.3.1/js/dataTables.buttons.min.js"></script>
    <script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.3.1/js/buttons.html5.min.js"></script>
    <script type="text/javascript" src="https://cdn.datatables.net/buttons/1.2.2/js/buttons.print.min.js"></script>

    <script>
        document.addEventListener('DOMContentLoaded', function() {
            if (typeof $ === 'undefined' || !$.fn.DataTable) return;

            if ($.fn.DataTable.isDataTable('.dataTableLaporanSurvei')) {
                $('.dataTableLaporanSurvei').DataTable().destroy();
            }

            $('.dataTableLaporanSurvei').DataTable({
                scrollX: true,
                scrollCollapse: true,
                autoWidth: false,
                responsive: false,
                paging: true,
                pageLength: 10,
                lengthMenu: [
                    [10, 25, 50, 100, -1],
                    [10, 25, 50, 100, 'Semua']
                ],
                ordering: true,
                order: [],
                orderCellsTop: true,
                fixedHeader: true,
                dom: "<'row mb-2'<'col-md-6'l><'col-md-6 text-right'B>>" +
                    "<'row'<'col-12'tr>>" +
                    "<'row mt-2'<'col-md-5'i><'col-md-7'p>>",
                buttons: [{
                        extend: 'copyHtml5',
                        text: 'Copy',
                        className: 'btn btn-sm btn-secondary'
                    },
                    {
                        extend: 'excelHtml5',
                        text: 'Excel',
                        className: 'btn btn-sm btn-success',
                        title: 'Laporan Survei Admin (B)'
                    },
                    {
                        extend: 'print',
                        text: 'Print',
                        className: 'btn btn-sm btn-primary',
                        title: 'Laporan Survei Admin (B)'
                    }
                ],
                language: {
                    search: "Cari:",
                    lengthMenu: "Tampil _MENU_ data",
                    info: "Menampilkan _START_ - _END_ dari _TOTAL_ data",
                    infoEmpty: "Tidak ada data",
                    zeroRecords: "Data tidak ditemukan",
                    paginate: {
                        first: "Awal",
                        last: "Akhir",
                        next: "›",
                        previous: "‹"
                    }
                }
            });
        });
    </script>
@endpush