Exemple #1
0
 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'));
 }
Exemple #2
0
 protected function getPinjaman($no_gaji, $bulan_tahun, $perkhidmatan_id)
 {
     $tarikh = explode('-', $bulan_tahun);
     $tarikh = $tarikh[1] . '-' . $tarikh[0];
     $bayaran = [];
     $yuran = Yuran::where('no_gaji', $no_gaji)->where('created_at', 'like', $tarikh . '%')->first();
     $tarikhYuran = $yuran->created_at;
     $akaun = AkaunPotongan::where('no_gaji', $no_gaji)->where('perkhidmatan_id', $perkhidmatan_id)->where('status', 1)->where('created_at', '<=', $tarikhYuran)->first();
     if ($akaun != null) {
         $bayaran = ['jumlah' => $akaun->bulanan, 'cp' => $akaun->caj_perkhidmatan, 'ins' => $akaun->insurans];
     } else {
         $bayaran = ['jumlah' => 0.0, 'cp' => 0.0, 'ins' => 0.0];
     }
     return $bayaran;
 }
 protected function getJumlahLayak($no_gaji)
 {
     $jumlah = Yuran::where('no_gaji', $no_gaji)->sum('yuran');
     // missing => $jumlah = $jumlah + jumlah_caruman_lama
     if ($jumlah < 10000) {
         $layak = 2 * $jumlah;
     } else {
         $layak = 0.8 * $jumlah;
     }
     return $layak;
 }
 protected function getJumlahPertaruhan($no_gaji)
 {
     $jumlah = Yuran::where('no_gaji', $no_gaji)->sum('pertaruhan');
     return $jumlah;
 }
Exemple #5
0
 protected function checkPotongan($no_gaji)
 {
     $bulan = Carbon::now()->format('m');
     $tahun = Carbon::now()->format('Y');
     if ($bulan < 10) {
         $bulan = '0' . $bulan;
     }
     $yuran = Yuran::where('bulan_tahun', $bulan . '-' . $tahun)->where('no_gaji', $no_gaji)->get();
     if ($yuran->isEmpty()) {
         return false;
     } else {
         return true;
     }
 }
Exemple #6
0
 protected function getJumlahLangsai($id)
 {
     // LANGSAI
     // Formula :-
     // Langsai = (baki - lebihan kadar) + 6 bulan kadar
     $account = AkaunPotongan::find($id);
     $tempoh = $account->tempoh;
     $bilBayaran = Yuran::where('no_gaji', $account->no_gaji)->where('created_at', '>=', $account->created_at)->count('id');
     $kadarSebulan = $account->kadar * $account->jumlah / 100 / 12;
     $kadar6Bulan = 6 * $kadarSebulan;
     $jumlahLebihanKadar = ($account->tempoh - $bilBayaran) * $kadarSebulan;
     $langsai = $account->baki - $jumlahLebihanKadar + $kadar6Bulan;
     return $langsai;
 }