@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 d-flex align-items-center justify-content-between">
                            <!-- Tombol Kembali di Kiri -->
                            <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 style="width: 100px;"></div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tabel Upload --}}
    <br>
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header d-flex align-items-center justify-content-between">
                            <h5 class="mb-0">Summary Upload Material by IT</h5>
                            {{-- <h5 class="mb-0">Bulan : {{ $month }}| Tahun : {{ $year }}</h5> --}}
                            <a class="btn btn-primary ms-auto" data-bs-toggle="collapse" href="#collapseSOP" role="button"
                                aria-expanded="false" aria-controls="collapseSOP">
                                <i class="fa fa-angle-down me-1"></i>
                            </a>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="collapse show" id="collapseSOP">
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <div class="table-responsive">
                                        <table class="table display table-hover table-bordered" id="tabel-sop">
                                            <thead style="background-color: #00b7bd4f;">
                                                <tr>
                                                    <th rowspan="2" class="align-middle text-center">Tahun</th>
                                                    <th rowspan="2" class="align-middle text-center">Bulan</th>
                                                    <th colspan="{{ count($itname) }}" class="text-center">IT Name</th>
                                                    <th colspan="2" class="align-middle text-center">Grand Total</th>
                                                </tr>
                                                <tr>
                                                    @foreach ($itname as $it)
                                                        <th class="text-center">{{ $it->name }}</th>
                                                    @endforeach
                                                    <th>Total</th>
                                                    <th>Grand Total</th>
                                                </tr>
                                            </thead>
                                            @php
                                                // Guard & hitung total kolom untuk colspan pesan kosong
                                                $hasData = !empty($sumit) && count($sumit) > 0;
                                                $totalCols = 2 + count($itname) + 2; // Tahun + Bulan + IT Name(s) + Total + Grand Total
                                            @endphp

                                            @if (!$hasData)
                                                <tbody>
                                                    <tr>
                                                        <td colspan="{{ $totalCols }}"
                                                            class="text-center text-muted py-4">
                                                            No data available in table
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            @else
                                                @php
                                                    $rowspanCounts = [];
                                                    $totalPerIT = [];
                                                    $groupedRows = [];
                                                    $totalPerKategori = [];

                                                    // Kelompokkan data berdasarkan tahun untuk rowspan
                                                    foreach ($sumit as $row) {
                                                        $year = $row['year'];
                                                        $rowspanCounts[$year] = ($rowspanCounts[$year] ?? 0) + 1;
                                                        $groupedRows[$year][] = $row;
                                                    }

                                                    $currentYear = now()->year;

                                                    $yearColors = [
                                                        '#f0f9ff', // biru muda
                                                        '#fff7e6', // oranye muda
                                                        '#ffe9e6', // peach pastel
                                                        '#fef6ff', // ungu pastel
                                                        '#fff0f6', // pink pastel
                                                    ];

                                                    $colorMap = [];
                                                    $i = 0;

                                                    foreach ($groupedRows as $year => $rows) {
                                                        $colorMap[$year] =
                                                            $year == $currentYear
                                                                ? '#d1fae5' // hijau muda untuk tahun sekarang
                                                                : $yearColors[$i++ % count($yearColors)];
                                                    }

                                                @endphp

                                                {{-- Style untuk pewarnaan background per tahun --}}
                                                @php
                                                    $dynamicStyle = '';
                                                    foreach ($colorMap as $year => $color) {
                                                        $dynamicStyle .= ".bg-tahun-{$year} td { background-color: {$color} !important; }\n";
                                                    }
                                                @endphp

                                                <style>
                                                    {!! $dynamicStyle !!}
                                                </style>

                                                @foreach ($groupedRows as $year => $rows)
                                                    <tbody id="group-{{ $year }}"
                                                        class="bg-tahun-{{ $year }}">

                                                        @php
                                                            $rowspan = count($rows) + 1; // +1 untuk baris total
                                                            $yearGrandTotal = 0;

                                                            // hitung total poin per tahun
                                                            foreach ($rows as $r) {
                                                                foreach ($itname as $it) {
                                                                    $yearGrandTotal += $r['items'][$it->value] ?? 0;
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($rows as $index => $row)
                                                            <tr class="{{ $index !== 0 ? 'row-detail-' . $year : '' }}">
                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        <div
                                                                            class="d-flex align-items-center justify-content-center gap-2">
                                                                            <i class="fas fa-minus-circle text-secondary"
                                                                                style="cursor: pointer; font-size: 14px;"
                                                                                onclick="toggleYear({{ $year }}, this)"
                                                                                title="Minimize/Maximize"></i>
                                                                            <span
                                                                                style="font-size: 14px;">{{ $year }}</span>
                                                                        </div>
                                                                    </td>
                                                                @endif

                                                                <td class="text-center">
                                                                    {{ \Carbon\Carbon::create()->month($row['month'])->translatedFormat('F') }}
                                                                </td>

                                                                @foreach ($itname as $it)
                                                                    @php
                                                                        $val = $row['items'][$it->value] ?? 0;
                                                                        $totalPerKategori[$it->value] =
                                                                            ($totalPerKategori[$it->value] ?? 0) + $val;
                                                                    @endphp
                                                                    <td class="text-end">{{ number_format($val, 1) }}</td>
                                                                @endforeach
                                                                @php
                                                                    $rowTotal = 0;
                                                                    foreach ($itname as $it) {
                                                                        $rowTotal += $row['items'][$it->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="align-middle text-center">
                                                                    {{ number_format($rowTotal, 1) }}
                                                                </td>
                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        {{ number_format($yearGrandTotal, 1) }}
                                                                    </td>
                                                                @endif
                                                            </tr>
                                                        @endforeach


                                                        <tr
                                                            class="bg-light fw-bold border-top border-2 border-secondary-subtle">

                                                            <td class="text-end" style="border: 1px solid #dadada;">
                                                                Total {{ $year }}
                                                                :
                                                            </td>
                                                            @foreach ($itname as $it)
                                                                @php
                                                                    $totalTahunPerKategori = 0;
                                                                    foreach ($rows as $r) {
                                                                        $totalTahunPerKategori +=
                                                                            $r['items'][$it->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="text-end" style="border: 1px solid #dadada;">
                                                                    {{ number_format($totalTahunPerKategori, 1) }}</td>
                                                            @endforeach
                                                            <td class="text-center fw-bold"
                                                                style="border: 1px solid #dadada;">
                                                                {{ number_format($yearGrandTotal, 1) }}
                                                            </td>
                                                        </tr>

                                                    </tbody>
                                                @endforeach



                                                <tfoot>
                                                    <tr>
                                                        <td colspan="2" class="text-end fw-bold">Grand Total</td>
                                                        @foreach ($itname as $it)
                                                            <td class="text-end fw-bold">
                                                                {{ number_format($totalPerKategori[$it->value] ?? 0, 1) }}
                                                            </td>
                                                        @endforeach
                                                        <td class="text-center fw-bold">
                                                            {{ number_format(array_sum($totalPerKategori), 1) }}</td>
                                                    </tr>
                                                </tfoot>
                                            @endif
                                        </table>
                                    </div>

                                </div>


                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tabel Create --}}
    <br>
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header d-flex align-items-center justify-content-between">
                            <h5 class="mb-0">Summary Create Material by User</h5>
                            {{-- <h5 class="mb-0">Bulan : {{ $month }}| Tahun : {{ $year }}</h5> --}}
                            <a class="btn btn-primary ms-auto" data-bs-toggle="collapse" href="#collapseC" role="button"
                                aria-expanded="false" aria-controls="collapseC">
                                <i class="fa fa-angle-down me-1"></i>
                            </a>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="collapse show" id="collapseC">
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <div class="table-responsive">
                                        <table class="table display table-hover table-bordered" id="tabel-create">
                                            <thead style="background-color: #00b7bd4f;">
                                                <tr>
                                                    <th rowspan="2" class="align-middle text-center">Tahun</th>
                                                    <th rowspan="2" class="align-middle text-center">Bulan</th>
                                                    <th colspan="{{ count($users) }}" class="text-center">User</th>
                                                    <th colspan="2" class="align-middle text-center">Grand Total</th>
                                                </tr>
                                                <tr>
                                                    @foreach ($users as $u)
                                                        <th class="text-center">{{ $u->name }}</th>
                                                    @endforeach
                                                    <th>Total</th>
                                                    <th>Grand Total</th>
                                                </tr>
                                            </thead>
                                            @php
                                                // Guard & hitung total kolom untuk colspan pesan kosong
                                                $hasDataU = !empty($sumusers) && count($sumusers) > 0;
                                                $totalColsU = 2 + count($users) + 2; // Tahun + Bulan + IT Name(s) + Total + Grand Total
                                            @endphp

                                            @if (!$hasDataU)
                                                <tbody>
                                                    <tr>
                                                        <td colspan="{{ $totalCols }}"
                                                            class="text-center text-muted py-4">
                                                            No data available in table
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            @else
                                                @php
                                                    $rowspanCountsU = [];
                                                    $totalPerIT = [];
                                                    $groupedRowsU = [];

                                                    // Kelompokkan data berdasarkan tahun untuk rowspan
                                                    foreach ($sumusers as $rowu) {
                                                        $year = $rowu['year'];
                                                        $rowspanCountsU[$year] = ($rowspanCountsU[$year] ?? 0) + 1;
                                                        $groupedRowsU[$year][] = $rowu;
                                                    }

                                                    $currentYear = now()->year;

                                                    $yearColors = [
                                                        '#f0f9ff', // biru muda
                                                        '#fff7e6', // oranye muda
                                                        '#ffe9e6', // peach pastel
                                                        '#fef6ff', // ungu pastel
                                                        '#fff0f6', // pink pastel
                                                    ];

                                                    $colorMap = [];
                                                    $i = 0;

                                                    foreach ($groupedRowsU as $year => $rowsu) {
                                                        $colorMap[$year] =
                                                            $year == $currentYear
                                                                ? '#d1fae5' // hijau muda untuk tahun sekarang
                                                                : $yearColors[$i++ % count($yearColors)];
                                                    }

                                                @endphp

                                                {{-- Style untuk pewarnaan background per tahun --}}
                                                @php
                                                    $dynamicStyle = '';
                                                    foreach ($colorMap as $year => $color) {
                                                        $dynamicStyle .= ".bg-tahun-{$year} td { background-color: {$color} !important; }\n";
                                                    }
                                                @endphp

                                                <style>
                                                    {!! $dynamicStyle !!}
                                                </style>

                                                @foreach ($groupedRowsU as $year => $rowsu)
                                                    <tbody id="group-{{ $year }}"
                                                        class="bg-tahun-{{ $year }}">

                                                        @php
                                                            $rowspan = count($rowsu) + 1; // +1 untuk baris total
                                                            $yearGrandTotal = 0;

                                                            // hitung total poin per tahun
                                                            foreach ($rowsu as $ru) {
                                                                foreach ($users as $u) {
                                                                    $yearGrandTotal += $ru['items'][$u->value] ?? 0;
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($rowsu as $index => $rowu)
                                                            <tr class="{{ $index !== 0 ? 'row-detailC-' . $year : '' }}">
                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        <div
                                                                            class="d-flex align-items-center justify-content-center gap-2">
                                                                            <i class="fas fa-minus-circle text-secondary"
                                                                                style="cursor: pointer; font-size: 14px;"
                                                                                onclick="toggleYearC({{ $year }}, this)"
                                                                                title="Minimize/Maximize"></i>
                                                                            <span
                                                                                style="font-size: 14px;">{{ $year }}</span>
                                                                        </div>
                                                                    </td>
                                                                @endif

                                                                <td class="text-center">
                                                                    {{ \Carbon\Carbon::create()->month($rowu['month'])->translatedFormat('F') }}
                                                                </td>

                                                                @foreach ($users as $u)
                                                                    @php
                                                                        $val = $rowu['items'][$u->value] ?? 0;
                                                                        $totalPerUser[$u->value] =
                                                                            ($totalPerUser[$u->value] ?? 0) + $val;
                                                                    @endphp
                                                                    <td class="text-end">{{ number_format($val, 1) }}</td>
                                                                @endforeach

                                                                @php
                                                                    $rowTotal = 0;
                                                                    foreach ($users as $u) {
                                                                        $rowTotal += $rowu['items'][$u->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="align-middle text-center">
                                                                    {{ number_format($rowTotal, 1) }}
                                                                </td>

                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        {{ number_format($yearGrandTotal, 1) }}
                                                                    </td>
                                                                @endif
                                                            </tr>
                                                        @endforeach


                                                        <tr
                                                            class="bg-light fw-bold border-top border-2 border-secondary-subtle">

                                                            <td class="text-end" style="border: 1px solid #dadada;">
                                                                Total {{ $year }}
                                                                :
                                                            </td>
                                                            @foreach ($users as $u)
                                                                @php
                                                                    $totalTahunPerUser = 0;
                                                                    foreach ($rowsu as $ru) {
                                                                        $totalTahunPerUser +=
                                                                            $ru['items'][$u->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="text-end" style="border: 1px solid #dadada;">
                                                                    {{ number_format($totalTahunPerUser, 1) }}</td>
                                                            @endforeach
                                                            <td class="text-center fw-bold"
                                                                style="border: 1px solid #dadada;">
                                                                {{ number_format($yearGrandTotal, 1) }}
                                                            </td>

                                                        </tr>

                                                    </tbody>
                                                @endforeach
                                                <tfoot>
                                                    <tr>
                                                        <td colspan="2" class="text-end fw-bold">Grand Total</td>
                                                        @foreach ($users as $u)
                                                            <td class="text-end fw-bold">
                                                                {{ number_format($totalPerUser[$u->value] ?? 0, 1) }}
                                                            </td>
                                                        @endforeach
                                                        <td class="text-center fw-bold">
                                                            {{ number_format(array_sum($totalPerUser), 1) }}</td>
                                                    </tr>
                                                </tfoot>
                                            @endif
                                        </table>


                                    </div>

                                </div>


                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tabel JAM Create --}}
    <br>
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header d-flex align-items-center justify-content-between">
                            <h5 class="mb-0">Summary Create Material by Time</h5>
                            {{-- <h5 class="mb-0">Bulan : {{ $month }}| Tahun : {{ $year }}</h5> --}}
                            <a class="btn btn-primary ms-auto" data-bs-toggle="collapse" href="#collapseT"
                                role="button" aria-expanded="false" aria-controls="collapseT">
                                <i class="fa fa-angle-down me-1"></i>
                            </a>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="collapse show" id="collapseT">
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <div class="table-responsive">
                                        <table class="table display table-hover table-bordered" id="tabel-time">
                                            <thead style="background-color: #00b7bd4f;">
                                                <tr>
                                                    <th rowspan="2" class="align-middle text-center">Tahun</th>
                                                    <th rowspan="2" class="align-middle text-center">Bulan</th>
                                                    <th colspan="{{ count($time) }}" class="text-center">Time</th>
                                                    <th colspan="2" class="align-middle text-center">Grand Total</th>
                                                </tr>
                                                <tr>
                                                    @foreach ($time as $t)
                                                        <th class="text-center">{{ $t->name }}</th>
                                                    @endforeach
                                                    <th>Total</th>
                                                    <th>Grand Total</th>
                                                </tr>
                                            </thead>
                                            @php
                                                // Guard & hitung total kolom untuk colspan pesan kosong
                                                $hasDataT = !empty($sumtime) && count($sumtime) > 0;
                                                $totalColsT = 2 + count($time) + 2; // Tahun + Bulan + IT Name(s) + Total + Grand Total
                                            @endphp

                                            @if (!$hasDataT)
                                                <tbody>
                                                    <tr>
                                                        <td colspan="{{ $totalCols }}"
                                                            class="text-center text-muted py-4">
                                                            No data available in table
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            @else
                                                @php
                                                    $rowspanCountsT = [];
                                                    $totalPerIT = [];
                                                    $groupedRowsT = [];

                                                    // Kelompokkan data berdasarkan tahun untuk rowspan
                                                    foreach ($sumtime as $rowt) {
                                                        $year = $rowt['year'];
                                                        $rowspanCountsT[$year] = ($rowspanCountsT[$year] ?? 0) + 1;
                                                        $groupedRowsT[$year][] = $rowt;
                                                    }

                                                    $currentYear = now()->year;

                                                    $yearColors = [
                                                        '#f0f9ff', // biru muda
                                                        '#fff7e6', // oranye muda
                                                        '#ffe9e6', // peach pastel
                                                        '#fef6ff', // ungu pastel
                                                        '#fff0f6', // pink pastel
                                                    ];

                                                    $colorMap = [];
                                                    $i = 0;

                                                    foreach ($groupedRowsT as $year => $rowst) {
                                                        $colorMap[$year] =
                                                            $year == $currentYear
                                                                ? '#d1fae5' // hijau muda untuk tahun sekarang
                                                                : $yearColors[$i++ % count($yearColors)];
                                                    }

                                                @endphp

                                                {{-- Style untuk pewarnaan background per tahun --}}
                                                @php
                                                    $dynamicStyle = '';
                                                    foreach ($colorMap as $year => $color) {
                                                        $dynamicStyle .= ".bg-tahun-{$year} td { background-color: {$color} !important; }\n";
                                                    }
                                                @endphp

                                                <style>
                                                    {!! $dynamicStyle !!}
                                                </style>

                                                @foreach ($groupedRowsT as $year => $rowst)
                                                    <tbody id="group-{{ $year }}"
                                                        class="bg-tahun-{{ $year }}">

                                                        @php
                                                            $rowspan = count($rowst) + 1; // +1 untuk baris total
                                                            $yearGrandTotal = 0;

                                                            // hitung total poin per tahun
                                                            foreach ($rowst as $rt) {
                                                                foreach ($time as $t) {
                                                                    $yearGrandTotal += $rt['items'][$t->value] ?? 0;
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($rowst as $index => $rowt)
                                                            <tr class="{{ $index !== 0 ? 'row-detailT-' . $year : '' }}">
                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        <div
                                                                            class="d-flex align-items-center justify-content-center gap-2">
                                                                            <i class="fas fa-minus-circle text-secondary"
                                                                                style="cursor: pointer; font-size: 14px;"
                                                                                onclick="toggleYearT({{ $year }}, this)"
                                                                                title="Minimize/Maximize"></i>
                                                                            <span
                                                                                style="font-size: 14px;">{{ $year }}</span>
                                                                        </div>
                                                                    </td>
                                                                @endif

                                                                <td class="text-center">
                                                                    {{ \Carbon\Carbon::create()->month($rowt['month'])->translatedFormat('F') }}
                                                                </td>

                                                                @foreach ($time as $t)
                                                                    @php
                                                                        $val = $rowt['items'][$t->value] ?? 0;
                                                                        $totalPerTime[$t->value] =
                                                                            ($totalPerTime[$t->value] ?? 0) + $val;
                                                                    @endphp
                                                                    <td class="text-end">{{ number_format($val, 1) }}</td>
                                                                @endforeach

                                                                @php
                                                                    $rowTotal = 0;
                                                                    foreach ($time as $t) {
                                                                        $rowTotal += $rowt['items'][$t->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="align-middle text-center">
                                                                    {{ number_format($rowTotal, 1) }}
                                                                </td>

                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        {{ number_format($yearGrandTotal, 1) }}
                                                                    </td>
                                                                @endif
                                                            </tr>
                                                        @endforeach


                                                        <tr
                                                            class="bg-light fw-bold border-top border-2 border-secondary-subtle">

                                                            <td class="text-end" style="border: 1px solid #dadada;">
                                                                Total {{ $year }}
                                                                :
                                                            </td>
                                                            @foreach ($time as $t)
                                                                @php
                                                                    $totalTahunPerTime = 0;
                                                                    foreach ($rowst as $rt) {
                                                                        $totalTahunPerTime +=
                                                                            $rt['items'][$t->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="text-end" style="border: 1px solid #dadada;">
                                                                    {{ number_format($totalTahunPerTime, 1) }}</td>
                                                            @endforeach
                                                            <td class="text-center fw-bold"
                                                                style="border: 1px solid #dadada;">
                                                                {{ number_format($yearGrandTotal, 1) }}
                                                            </td>

                                                        </tr>

                                                    </tbody>
                                                @endforeach
                                                <tfoot>
                                                    <tr>
                                                        <td colspan="2" class="text-end fw-bold">Grand Total</td>
                                                        @foreach ($time as $t)
                                                            <td class="text-end fw-bold">
                                                                {{ number_format($totalPerTime[$t->value] ?? 0, 1) }}
                                                            </td>
                                                        @endforeach
                                                        <td class="text-center fw-bold">
                                                            {{ number_format(array_sum($totalPerTime), 1) }}</td>
                                                    </tr>
                                                </tfoot>
                                            @endif
                                        </table>


                                    </div>

                                </div>


                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Tabel ID MAt Group --}}
    <br>
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="card-header d-flex align-items-center justify-content-between">
                            <h5 class="mb-0">Summary Material by ID Mat Group</h5>
                            {{-- <h5 class="mb-0">Bulan : {{ $month }}| Tahun : {{ $year }}</h5> --}}
                            <a class="btn btn-primary ms-auto" data-bs-toggle="collapse" href="#collapseM"
                                role="button" aria-expanded="false" aria-controls="collapseM">
                                <i class="fa fa-angle-down me-1"></i>
                            </a>
                        </div>
                        <hr class="horizontal dark mt-0">
                        <div class="collapse show" id="collapseM">
                            <div class="row px-4 py-2">
                                <div class="table-responsive">
                                    <div class="table-responsive">
                                        <table class="table display table-hover table-bordered" id="tabel-sop">
                                            <thead style="background-color: #00b7bd4f;">
                                                <tr>
                                                    <th rowspan="2" class="align-middle text-center">Tahun</th>
                                                    <th rowspan="2" class="align-middle text-center">Bulan</th>
                                                    <th colspan="{{ count($matgroup) }}" class="text-center">Material
                                                        Group</th>
                                                    <th colspan="2" class="align-middle text-center">Grand Total</th>
                                                </tr>
                                                <tr>
                                                    @foreach ($matgroup as $mg)
                                                        <th class="text-center">{{ $mg->value }} ({{ $mg->name }})
                                                        </th>
                                                    @endforeach
                                                    <th>Total</th>
                                                    <th>Grand Total</th>
                                                </tr>
                                            </thead>

                                            @php
                                                // Guard & hitung total kolom untuk colspan pesan kosong
                                                $hasDataMG = !empty($summatgroup) && count($summatgroup) > 0;
                                                $totalColsMG = 2 + count($matgroup) + 2; // Tahun + Bulan + IT Name(s) + Total + Grand Total
                                            @endphp

                                            @if (!$hasDataMG)
                                                <tbody>
                                                    <tr>
                                                        <td colspan="{{ $totalCols }}"
                                                            class="text-center text-muted py-4">
                                                            No data available in table
                                                        </td>
                                                    </tr>
                                                </tbody>
                                            @else
                                                @php
                                                    $rowspanCountsMG = [];
                                                    $totalPerIT = [];
                                                    $groupedRowsMG = [];

                                                    // Kelompokkan data berdasarkan tahun untuk rowspan
                                                    foreach ($summatgroup as $rowmg) {
                                                        $year = $rowmg['year'];
                                                        $rowspanCountsMG[$year] = ($rowspanCountsMG[$year] ?? 0) + 1;
                                                        $groupedRowsMG[$year][] = $rowmg;
                                                    }

                                                    $currentYear = now()->year;

                                                    $yearColors = [
                                                        '#f0f9ff', // biru muda
                                                        '#fff7e6', // oranye muda
                                                        '#ffe9e6', // peach pastel
                                                        '#fef6ff', // ungu pastel
                                                        '#fff0f6', // pink pastel
                                                    ];

                                                    $colorMap = [];
                                                    $i = 0;

                                                    foreach ($groupedRowsMG as $year => $rowsmg) {
                                                        $colorMap[$year] =
                                                            $year == $currentYear
                                                                ? '#d1fae5' // hijau muda untuk tahun sekarang
                                                                : $yearColors[$i++ % count($yearColors)];
                                                    }

                                                @endphp

                                                {{-- Style untuk pewarnaan background per tahun --}}
                                                @php
                                                    $dynamicStyle = '';
                                                    foreach ($colorMap as $year => $color) {
                                                        $dynamicStyle .= ".bg-tahun-{$year} td { background-color: {$color} !important; }\n";
                                                    }
                                                @endphp

                                                <style>
                                                    {!! $dynamicStyle !!}
                                                </style>

                                                @foreach ($groupedRowsMG as $year => $rowsmg)
                                                    <tbody id="group-{{ $year }}"
                                                        class="bg-tahun-{{ $year }}">

                                                        @php
                                                            $rowspan = count($rowsmg) + 1; // +1 untuk baris total
                                                            $yearGrandTotal = 0;

                                                            // hitung total poin per tahun
                                                            foreach ($rowsmg as $rmg) {
                                                                foreach ($matgroup as $mg) {
                                                                    $yearGrandTotal += $rmg['items'][$mg->value] ?? 0;
                                                                }
                                                            }
                                                        @endphp

                                                        @foreach ($rowsmg as $index => $rowmg)
                                                            <tr class="{{ $index !== 0 ? 'row-detailM-' . $year : '' }}">
                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        <div
                                                                            class="d-flex align-items-center justify-content-center gap-2">
                                                                            <i class="fas fa-minus-circle text-secondary"
                                                                                style="cursor: pointer; font-size: 14px;"
                                                                                onclick="toggleYearM({{ $year }}, this)"
                                                                                title="Minimize/Maximize"></i>
                                                                            <span
                                                                                style="font-size: 14px;">{{ $year }}</span>
                                                                        </div>
                                                                    </td>
                                                                @endif

                                                                <td class="text-center">
                                                                    {{ \Carbon\Carbon::create()->month($rowmg['month'])->translatedFormat('F') }}
                                                                </td>

                                                                @foreach ($matgroup as $mg)
                                                                    @php
                                                                        $val = $rowmg['items'][$mg->value] ?? 0;
                                                                        $totalPerMG[$mg->value] =
                                                                            ($totalPerMG[$mg->value] ?? 0) + $val;
                                                                    @endphp
                                                                    <td class="text-end">{{ number_format($val, 1) }}</td>
                                                                @endforeach

                                                                @php
                                                                    $rowTotal = 0;
                                                                    foreach ($matgroup as $mg) {
                                                                        $rowTotal += $rowmg['items'][$mg->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="align-middle text-center">
                                                                    {{ number_format($rowTotal, 1) }}
                                                                </td>

                                                                @if ($index === 0)
                                                                    <td rowspan="{{ $rowspan }}"
                                                                        class="align-middle text-center">
                                                                        {{ number_format($yearGrandTotal, 1) }}
                                                                    </td>
                                                                @endif
                                                            </tr>
                                                        @endforeach


                                                        <tr
                                                            class="bg-light fw-bold border-top border-2 border-secondary-subtle">

                                                            <td class="text-end" style="border: 1px solid #dadada;">
                                                                Total {{ $year }}
                                                                :
                                                            </td>
                                                            @foreach ($matgroup as $mg)
                                                                @php
                                                                    $totalTahunPerMG = 0;
                                                                    foreach ($rowsmg as $rmg) {
                                                                        $totalTahunPerMG +=
                                                                            $rmg['items'][$mg->value] ?? 0;
                                                                    }
                                                                @endphp
                                                                <td class="text-end" style="border: 1px solid #dadada;">
                                                                    {{ number_format($totalTahunPerMG, 1) }}</td>
                                                            @endforeach
                                                            <td class="text-center fw-bold"
                                                                style="border: 1px solid #dadada;">
                                                                {{ number_format($yearGrandTotal, 1) }}
                                                            </td>

                                                        </tr>

                                                    </tbody>
                                                @endforeach
                                                <tfoot>
                                                    <tr>
                                                        <td colspan="2" class="text-end fw-bold">Grand Total</td>
                                                        @foreach ($matgroup as $mg)
                                                            <td class="text-end fw-bold">
                                                                {{ number_format($totalPerMG[$mg->value] ?? 0, 1) }}
                                                            </td>
                                                        @endforeach
                                                        <td class="text-center fw-bold">
                                                            {{ number_format(array_sum($totalPerMG), 1) }}</td>
                                                    </tr>
                                                </tfoot>
                                            @endif
                                        </table>


                                    </div>

                                </div>


                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>


    <br>
    <div class="container-fluid">
        <div class="row">
            <div class="col-md-12">
                <div class="row mx-1">
                    <div class="card">
                        <div class="row px-4 py-2">
                            <div class="table-responsive">
                                <br>
                                                                <table class="table display" id="list_{{ $dmenu }}">
                                    <thead class="thead-light" style="background-color: #00b7bd4f;">
                                        <tr>
                                            <th>No</th>
                                            <th>Kode Baru FG</th>
                                            <th>ID Material Grup</th>
                                            <th>Customer</th>
                                            <th>Product Name</th>
                                            <th>Division</th>
                                            <th>Keterangan</th>
                                            <th>Alt UOM</th>
                                            <th>Status</th>
                                            <th>Created By</th>
                                            <th>Upload By</th>
                                            <th>Created At</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        {{-- retrieve table list --}}
                                        @foreach ($list_material as $list)
                                            <tr>
                                                <td>1</td>
                                                <td> {{ $list->kode_baru_fg }}</td>
                                                <td> {{ $list->id_mat_group }}</td>
                                                <td> {{ $list->customer }}</td>
                                                <td> {{ $list->product_name }}</td>
                                                <td> {{ $list->division }}</td>
                                                <td> {{ $list->keterangan }}</td>
                                                <td> {{ $list->alt_uom }}</td>
                                                <td> {{ $list->status }}</td>
                                                <td> {{ $list->user_create }}</td>
                                                <td> {{ $list->it_update }}</td>
                                                <td> {{ $list->created_at }}</td>
                                            </tr>
                                        @endforeach
                                    </tbody>
                                </table>
                                <br>
                            </div>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>


    <script>
        function toggleYear(year, icon) {
            const rows = document.querySelectorAll(`.row-detail-${year}`);
            rows.forEach(row => row.classList.toggle('d-none'));
            let isHidden = false;

            rows.forEach(row => {
                const currentlyHidden = row.style.display === 'none';
                row.style.display = currentlyHidden ? '' : 'none';
                if (!currentlyHidden) isHidden = true;
            });

            // Ganti ikon: + saat di minimize, − saat normal
            if (icon) {
                icon.classList.remove('fa-minus-circle', 'fa-plus-circle');
                icon.classList.add(isHidden ? 'fa-plus-circle' : 'fa-minus-circle');
            }
        }

        function toggleYearC(year, icon) {
            const rows = document.querySelectorAll(`.row-detailC-${year}`);
            rows.forEach(row => row.classList.toggle('d-none'));
            let isHidden = false;

            rows.forEach(row => {
                const currentlyHidden = row.style.display === 'none';
                row.style.display = currentlyHidden ? '' : 'none';
                if (!currentlyHidden) isHidden = true;
            });

            // Ganti ikon: + saat di minimize, − saat normal
            if (icon) {
                icon.classList.remove('fa-minus-circle', 'fa-plus-circle');
                icon.classList.add(isHidden ? 'fa-plus-circle' : 'fa-minus-circle');
            }
        }

        function toggleYearT(year, icon) {
            const rows = document.querySelectorAll(`.row-detailT-${year}`);
            rows.forEach(row => row.classList.toggle('d-none'));
            let isHidden = false;

            rows.forEach(row => {
                const currentlyHidden = row.style.display === 'none';
                row.style.display = currentlyHidden ? '' : 'none';
                if (!currentlyHidden) isHidden = true;
            });

            // Ganti ikon: + saat di minimize, − saat normal
            if (icon) {
                icon.classList.remove('fa-minus-circle', 'fa-plus-circle');
                icon.classList.add(isHidden ? 'fa-plus-circle' : 'fa-minus-circle');
            }
        }

        function toggleYearM(year, icon) {
            const rows = document.querySelectorAll(`.row-detailM-${year}`);
            rows.forEach(row => row.classList.toggle('d-none'));
            let isHidden = false;

            rows.forEach(row => {
                const currentlyHidden = row.style.display === 'none';
                row.style.display = currentlyHidden ? '' : 'none';
                if (!currentlyHidden) isHidden = true;
            });

            // Ganti ikon: + saat di minimize, − saat normal
            if (icon) {
                icon.classList.remove('fa-minus-circle', 'fa-plus-circle');
                icon.classList.add(isHidden ? 'fa-plus-circle' : 'fa-minus-circle');
            }
        }
    </script>
@endsection