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 yuranTambahan()
{
$tarikh = explode('-', Request::get('bulan_tahun'));
$created_at = $tarikh[1] . '-' . $tarikh[0] . '-' . Carbon::now()->format('d') . ' 00:00:00';
Yurantambahan::create(['jumlah' => Request::get('jumlah'), 'sumbangan_id' => Request::get('sumbangan_id'), 'no_gaji' => Request::get('no_gaji'), 'tarikh' => Request::get('tarikh'), 'penerima' => strtoupper(Request::get('penerima')), 'created_at' => $created_at]);
$profile = Profile::where('no_gaji', Request::get('no_gaji'))->first();
$profile->status = 0;
$profile->save();
$accounts = AkaunPotongan::where('no_gaji', Request::get('no_gaji'))->get();
if (!$accounts->isEmpty()) {
foreach ($accounts as $account) {
$account->status = 0;
$account->save();
}
}
Session::flash('success', 'Berjaya. Yuran Tambahan berjaya didaftarkan dan Anggota telah di nyah-aktifkan.');
return redirect()->route('members.yuran.index');
}
