public function lapBayaranIndividuPost()
{
$profile = Profile::where('no_gaji', Request::get('no_gaji'))->first();
if ($profile == null) {
Session::flash('error', 'Gagal. Tiada ahli yang berdaftar dengan no gaji *' . Request::get('no_gaji') . '*.');
return Redirect::back();
}
$nama = $profile->nama;
$no_gaji = Request::get('no_gaji');
$fees = Yuran::where('no_gaji', Request::get('no_gaji'))->where('bulan_tahun', 'like', '%' . date('Y'))->get();
if ($fees->isEmpty()) {
Session::flash('error', 'Gagal. Tiada maklumat bayaran pada tahun ini.');
return Redirect::back();
}
$bayaran = [];
foreach ($fees as $fee) {
$profile = Profile::where('no_gaji', Request::get('no_gaji'))->first();
$bulan = explode('-', $fee->bulan_tahun);
$bulan = (int) $bulan[0];
if ($bulan < 10) {
$bulan = '0' . $bulan;
}
// Yuran Bulanan
$jumlah = $fee->yuran + $fee->pertaruhan + $fee->tka + $fee->takaful + $fee->potongan;
array_push($bayaran, ['bulan' => $bulan, 'perkara' => 'Yuran Bulanan', 'catatan' => $profile->zon_gaji->nama, 'jumlah' => $jumlah]);
// Bayaran pwt
if ($fee->pwt != 0) {
array_push($bayaran, ['bulan' => $bulan, 'perkara' => 'PWT', 'catatan' => $profile->zon_gaji->nama, 'jumlah' => $fee->pwt]);
}
// Bayaran Tunai
$bulan = explode('-', $fee->bulan_tahun);
$bulan = $bulan[0];
$tunai = Bayaran::where('no_gaji', Request::get('no_gaji'))->where('created_at', 'like', date('Y') . '-' . $bulan . '%')->get();
if (!$tunai->isEmpty()) {
$bulan = explode('-', $fee->bulan_tahun);
foreach ($tunai as $cash) {
$catatan = Perkhidmatan::where('id', $cash->akaunpotongan_id)->first();
$catatan = $catatan->nama;
$jumlah = $cash->jumlah;
array_push($bayaran, ['bulan' => $bulan[0], 'perkara' => 'Bayaran Tunai/Cek', 'catatan' => $catatan, 'jumlah' => $jumlah]);
}
}
// end if tunai is not empty
}
//end foreach
return View('members.laporan.janaan.lapBayaranIndividu', compact('nama', 'no_gaji', 'bayaran'));
}
public function langsaiPost()
{
$profile = Profile::where('no_gaji', Request::get('no_gaji'))->get();
if ($profile->isEmpty()) {
Session::flash('error', 'Gagal. No Gaji *' . Request::get('no_gaji') . '* tidak berdafatar dengan KOMADA');
return Redirect::back();
}
$profile = Profile::where('no_gaji', Request::get('no_gaji'))->first();
$akauns = AkaunPotongan::where('no_gaji', Request::get('no_gaji'))->where('status', 1)->get();
if ($akauns->isEmpty()) {
Session::flash('error', 'Gagal. No Gaji *' . Request::get('no_gaji') . '* tiada rekod pinjaman/tertunggak');
return Redirect::back();
}
$accounts = [];
foreach ($akauns as $akaun) {
$perkhidmatan = Perkhidmatan::where('id', $akaun->perkhidmatan_id)->first();
// $baki = $akaun->baki;
$baki = $this->getJumlahLangsai($akaun->id);
array_push($accounts, ['id' => $akaun->perkhidmatan_id, 'nama' => $perkhidmatan->nama, 'baki' => $baki]);
}
return View('members.bayaran.langsaiPost', compact('profile', 'accounts'));
}
