public function index() { $yuranTambahans = Yurantambahan::where('created_at', 'like', Carbon::now()->format('Y') . '%')->orderBy('created_at', 'asc')->get(); $yuranBulanans = Yuran::where('bulan_tahun', 'like', Carbon::now()->format('m-Y') . '%')->get(); $sumbangan = Sumbangan::lists('nama', 'id'); $totalAnggota = Profile::all()->count(); $totalAnggotaAktif = Profile::where('status', 1)->count(); $totalAnggotaXAktif = Profile::where('status', 0)->count(); $totalAnggotaBaru = Profile::where('status', 1)->where('tarikh_ahli', 'like', Carbon::now()->format('Y-m') . '%')->count(); $totalYuran = Yuran::where('bulan_tahun', 'like', Carbon::now()->format('m-Y') . '%')->count(); $count = ['totalAnggota' => $totalAnggota, 'totalAnggotaAktif' => $totalAnggotaAktif, 'totalAnggotaXAktif' => $totalAnggotaXAktif, 'totalAnggotaBaru' => $totalAnggotaBaru, 'totalYuran' => $totalYuran]; $totalTambahan = 0.0; return View('members.yuran', compact('yuranTambahans', 'yuranBulanans', 'count', 'totalTambahan', 'sumbangan')); }