Summary Berita

Dashboard |

Filter Bulan:

Filter Tahun:

@push('after-styles') @endpush @php $selectedMonth = request()->input('month'); // Ambil bulan dari request $selectedYear = request()->input('year', date('Y')); // Default tahun saat ini $usersPerMonth = \Modules\Berita\Models\Berita::selectRaw('MONTH(created_at) as month, COUNT(*) as count') ->whereYear('created_at', $selectedYear) ->when($selectedMonth, function ($query, $selectedMonth) { return $query->whereMonth('created_at', $selectedMonth); }) ->groupBy('month') ->orderBy('month') ->get(); $chartData = array_fill(0, 12, 0); foreach ($usersPerMonth as $data) { $chartData[$data->month - 1] = $data->count; } @endphp @push('after-scripts') @endpush