@extends('layouts.app', ['class' => 'g-sidenav-show bg-gray-100']) {{-- section content --}} @section('content') @include('layouts.navbars.auth.topnav', ['title' => ''])

Result {{ $title_menu }}
{{--
Bulan : {{ $month }}| Tahun : {{ $year }}
--}}

@foreach ($reportK as $d) @endforeach {{-- ✅ Pastikan total poin ada dalam baris yang sesuai --}}
No IT Name Date Keterangan Pengerjaan Kategori User Departement Dampak Urgency Start Finish Status Poin
{{ $vcount++ }} {{ $d->it_name }} {{ $d->date }} {{ $d->ket }} {{ $d->pengerjaan }} {{ $d->kat_name }} {{ $d->user_name }} {{ $d->dept_name }} {{ $d->dampak_name }} {{ $d->urgency_name }} {{ $d->start }} {{ $d->finish }} {{ $d->status_name }} {{ $d->poin }}
{{-- Tabel Sum Of Point --}}
Sum of Poin
{{--
Bulan : {{ $month }}| Tahun : {{ $year }}
--}}

@foreach ($kategori as $k) @endforeach @php $rowspanCounts = []; $totalPerKategori = []; $groupedRows = []; // Kelompokkan data berdasarkan tahun untuk rowspan foreach ($sop_kategori 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 @foreach ($groupedRows as $year => $rows) @php $rowspan = count($rows) + 1; // +1 untuk baris total $yearGrandTotal = 0; // hitung total poin per tahun foreach ($rows as $r) { foreach ($kategori as $k) { $yearGrandTotal += $r['items'][$k->value] ?? 0; } } @endphp @foreach ($rows as $index => $row) @if ($index === 0) @endif @foreach ($kategori as $k) @php $val = $row['items'][$k->value] ?? 0; $totalPerKategori[$k->value] = ($totalPerKategori[$k->value] ?? 0) + $val; @endphp @endforeach @if ($index === 0) @endif @endforeach @foreach ($kategori as $k) @php $totalTahunPerKategori = 0; foreach ($rows as $r) { $totalTahunPerKategori += $r['items'][$k->value] ?? 0; } @endphp @endforeach @endforeach @foreach ($kategori as $k) @endforeach
Tahun Bulan Kategori Grand Total
{{ $k->name }}
{{ $year }}
{{ \Carbon\Carbon::create()->month($row['month'])->translatedFormat('F') }} {{ number_format($val, 1) }} {{ number_format($yearGrandTotal, 1) }}
Total {{ $year }} : {{ number_format($totalTahunPerKategori, 1) }}
Grand Total {{ number_format($totalPerKategori[$k->value] ?? 0, 1) }} {{ number_format(array_sum($totalPerKategori), 1) }}
{{-- Tabel Planning --}}
Chart Kategori per Bulan





Chart Kategori per Tahun




@endsection