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')); }