public function tkaPost() { $tka = Tka::where('jumlah', Request::get('jumlah'))->where('status', 1)->get(); if (!$tka->isEmpty()) { Session::flash('error', 'Gagal. Jumlah yang sama dengan Jumlah TKA semasa .'); return Redirect::back()->withInput(); } $validation = Validator::make(Request::all(), ['jumlah' => 'required|numeric']); if ($validation->fails()) { Session::flash('error', 'Gagal. Masukkan nilai jumlah dengan format yang betul.'); return Redirect::back()->withInput()->withErrors($validation); } $tka = new Tka(); $tka->jumlah = Request::get('jumlah'); $tka->status = 1; if ($tka->save()) { $tka = Tka::where('jumlah', '!=', Request::get('jumlah'))->update(['status' => 0]); Session::flash('success', 'Berjaya. Nilai baru bagi TKA telah disimpan.'); return Redirect::route('members.settings.tka'); } else { Session::flash('error', 'Gagal. Masukkan nilai jumlah dengan format yang betul.'); return Redirect::back()->withInput(); } }
public function yuranProcess() { // Session::flash('error', 'Sistem dalam Pengemaskinian. Proses Yuran tergendala. Harap Maaf.'); // return Redirect::back(); // check for repeated payment for the selected month $doneMonth = Yuran::where('bulan_tahun', Request::get('bulan_tahun'))->first(); $currentMonth = date('m'); $currentYear = date('Y'); $postedDate = explode('-', Request::get('bulan_tahun')); $postedMonth = $postedDate[0]; $postedYear = $postedDate[1]; if ($postedYear > $currentYear || $postedYear < $currentYear) { Session::flash('error', 'Gagal. Potongan hendaklah pada tahun semasa.'); return Redirect::back(); } if ($postedYear == $currentYear) { if ($postedMonth > $currentMonth) { Session::flash('error', 'Gagal. Potongan hendaklah pada bulan semasa atau sebelum.'); return Redirect::back(); } } if (!empty($doneMonth)) { Session::flash('error', 'Gagal. Bulan yang dipilih telah dibuat potongan.'); return Redirect::back(); } $profiles = Profile::where('status', 1)->where('zon_gaji_id', '!=', 20)->where('tarikh_ahli', 'not like', Carbon::now()->format('Y-m') . '%')->get(); foreach ($profiles as $profile) { $jumlahPotongan = '0.00'; $tka = Tka::where('status', 1)->first(); $takaful = Takaful::where('status', 1)->first(); $dates = explode('-', Request::get('bulan_tahun')); $tarikh = $dates[1] . '-' . $dates[0] . '01 00:00:00'; $potongan = AkaunPotongan::where('no_gaji', $profile->no_gaji)->where('status', 1)->first(); // check bayaran yuran sudah dibuat atau belum // jika belum proses bayaran // jika sudah, skip proses bayaran if (!$this->checkPotongan($profile->no_gaji)) { $yuran = $profile->jumlah_yuran_bulanan; $pertaruhan = $profile->jumlah_pertaruhan; $tka = Tka::where('status', 1)->first()->jumlah; $takaful = Takaful::where('status', 1)->first()->jumlah; // kod = 1 $pwt = $this->getJumlah($profile->no_gaji, 1, 'bulanan'); $pwtcp = $this->getJumlah($profile->no_gaji, 1, 'caj_proses'); $pwtins = $this->getJumlah($profile->no_gaji, 1, 'insurans'); // Kod = 2 $bs = $this->getJumlah($profile->no_gaji, 2, 'bulanan'); // Kod = 3; $rt = $this->getJumlah($profile->no_gaji, 3, 'bulanan'); // Kod = 5 $tb = $this->getJumlah($profile->no_gaji, 5, 'bulanan'); $tbcp = $this->getJumlah($profile->no_gaji, 5, 'caj_proses'); $tbins = $this->getJumlah($profile->no_gaji, 5, 'insurans'); // kod = 6 $kc = $this->getJumlah($profile->no_gaji, 6, 'bulanan'); $kccp = $this->getJumlah($profile->no_gaji, 6, 'caj_proses'); $kcins = $this->getJumlah($profile->no_gaji, 6, 'insurans'); // if($profile->no_gaji == 3374) // return $pwt; Yuran::create(['no_gaji' => $profile->no_gaji, 'bulan_tahun' => Request::get('bulan_tahun'), 'yuran' => $yuran, 'pertaruhan' => $pertaruhan, 'tka' => $tka, 'takaful' => $takaful, 'pwt' => $pwt, 'pwtcp' => $pwtcp, 'pwtins' => $pwtins, 'bs' => $bs, 'rt' => $rt, 'tb' => $tb, 'tbcp' => $tbcp, 'tbins' => $tbins, 'kc' => $kc, 'kccp' => $kccp, 'kcins' => $kcins, 'zon_gaji_id' => $profile->zon_gaji_id]); } } return Redirect::route('members.yuran.index'); }