protected function getSumbangan($bulan_tahun) { $tarikh = explode('-', $bulan_tahun); $tarikh = $tarikh[1] . '-' . $tarikh[0]; $sumbangan = Yurantambahan::where('created_at', 'like', $tarikh . '%')->sum('jumlah'); return $sumbangan; }
public function noAnggota() { $profiles = Profile::where('no_gaji', Request::get('no_gaji'))->get(); if ($profiles->isEmpty()) { Session::flash('error', 'Gagal. No Gaji * ' . Request::get('no_gaji') . ' * tidak berdaftar sebagai ahli KOMADA.'); return Redirect::route('members.index'); } $yurans = Yuran::where('no_gaji', Request::get('no_gaji'))->where('bulan_tahun', 'like', '%' . Carbon::now()->format('Y'))->orderBy('bulan_tahun', 'asc')->get(); $yuranTambahan = []; for ($i = 1; $i <= 12; $i++) { if ($i < 10) { $bulan = '0' . $i; } else { $bulan = $i; } $yuranTambahans = Yurantambahan::where('created_at', 'like', Carbon::now()->format('Y') . '-' . $bulan . '%')->orderBy('created_at', 'asc')->get(); if ($yuranTambahans->isEmpty()) { $yuranTambahan = 0.0; } else { foreach ($yuranTambahans as $tambahan) { array_push($yuranTambahan, ['bulan' => $bulan, 'no_gaji' => $tambahan->no_gaji, 'nama' => $tambahan->profileName($tambahan->no_gaji), 'catatan' => $tambahan->sumbangan->nama, 'penerima' => $tambahan->penerima, 'tarikh' => $tambahan->tarikh, 'jumlah' => $tambahan->jumlah]); } } if ($i == Carbon::now()->format('m')) { $i = 13; } } $bil = 1; $biasas = AkaunPotongan::where('no_gaji', Request::get('no_gaji'))->get(); return View('members.profile', compact('bil', 'profiles', 'yurans', 'yuranTambahan', 'biasas')); }
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')); }