/**
* Remove the specified resource from storage.
*
* @param int $id
* @return Response
*/
public function destroy($id)
{
$tt01 = tt01::find($id);
$idkar = $tt01->idkar;
$niltb = $tt01->niltb;
$tt01->delete();
$mk01 = mk01::find($idkar);
$mk01->tbsld = $mk01->tbsld - $niltb;
$mk01->save();
Session::flash('tt01_success', 'Data Telah DiHapus!');
return Redirect::to('inputdata/tabungan');
}
public function printgaji($id)
{
$success = Session::get('tg01_success');
$danger = Session::get('tg01_danger');
$tg01 = tg01::find($id);
$tg02 = new tg02();
$th01 = new th01();
$tt01 = new tt01();
$tz01 = new tz01();
$mk01 = new mk01();
$karyawan = mk01::find($tg01->idkar);
$data = array("karyawan" => $karyawan, "kehadiran" => $tg01->getKehadiranGaji($tg01->tglgjsblm, $tg01->idkar), "durasiBekerja" => $tg01->getDurasiBekerjaGaji($tg01->tglgjsblm, $tg01->idkar), "durasiLembur" => $tg01->getDurasiLemburGaji($tg01->tglgjsblm, $tg01->idkar), "durasiLambat" => $tg01->getKeterlambatan($tg01->tglgjsblm, $tg01->idkar), "gaji" => $tg01, "gajis" => $tg02->getDetailGajiKaryawan($id), "infogajis" => $tg01->getJamKerjaInSec($tg01->idkar, $tg01->tglgjsblm), "infohutang" => $th01->getHutangBulan($tg01->idkar, $tg01->tgltg), "infokasbon" => $th01->getKasBonBulan($tg01->idkar, $tg01->tgltg), "infotabungan" => $tt01->getTabunganGaji($tg01->idkar, $tg01->tgltg), "omzetIndividu" => $tz01->getOmzetIndividu($tg01->idkar, $tg01->tgltg), "omzetTim" => $tz01->getOmzetTim($tg01->idkar, $tg01->tgltg), "referrals" => $mk01->getReferralKar($tg01->idkar), "tg01_success" => $success, "tg01_danger" => $danger);
return View::make('transaksi.trans_print_gaji', $data);
}
/**
* Store a newly created resource in storage.
*
* @return Response
*/
public function store()
{
if (count(Input::get("idgj")) > 0) {
DB::transaction(function () {
$idgj = Input::get("idgj");
$nominalgj = Input::get("nominalgaji");
$idkar = Input::get("idkar");
$mk01 = mk01::find($idkar);
$tgltg = Input::get("tgltg");
$tg01 = new tg01();
$idtg = $tg01->getAutoIncrement();
$tg01->nortg = "GJ" . $idtg . date("m") . date("y");
$tg01->tgltg = strftime("%Y-%m-%d", strtotime($tgltg));
$tg01->tglgjsblm = $mk01->tglgj;
$tg01->status = "N";
$tg01->idkar = $idkar;
$tg01->save();
for ($i = 0; $i < count($idgj); $i++) {
$nilgj = mg02::whereRaw('mk01_id = ? and mg01_id = ?', array($idkar, $idgj[$i]))->first()->nilgj;
$tg02 = new tg02();
$tg02->tg01_id = $idtg;
$tg02->mg01_id = $idgj[$i];
$tg02->jmtgh = $nominalgj[$i];
$tg02->nmlgj = $nilgj;
$tg02->save();
$tg01->ttlgj += $nominalgj[$i] * $nilgj;
$tg01->save();
}
$mk01 = mk01::find($idkar);
$mk01->tglgj = $tg01->tgltg;
$mk01->save();
$th01 = new th01();
$tt01 = new tt01();
$tz01 = new tz01();
$infohutang = $th01->getHutangBulan($tg01->idkar, $tg01->tgltg);
$infokasbon = $th01->getKasBonBulan($tg01->idkar, $tg01->tgltg);
$infotabungan = $tt01->getTabunganGaji($tg01->idkar, $tg01->tgltg);
$omzetIndividu = $tz01->getOmzetIndividu($tg01->idkar, $tg01->tgltg);
$omzetTim = $tz01->getOmzetTim($tg01->idkar, $tg01->tgltg);
$referrals = $mk01->getReferralKar($tg01->idkar);
$tg01->ttlgj += $mk01->kmindv * $omzetIndividu / 100;
$tg01->save();
if (count($referrals) > 1) {
$bool = FALSE;
foreach ($referrals as $key => $val) {
if ($val->mk01_id_child == $mk01->idkar && $val->flglead == "Yes") {
$bool = TRUE;
break;
}
}
if ($bool == FALSE) {
$omzetTim = 0;
}
$tg01->ttlgj += $mk01->kmtim * $omzetTim / 100;
$tg01->save();
}
});
Session::flash('tg01_success', 'Slip Gaji Karyawan tersebut Telah Dibuat!');
} else {
Session::flash('tg01_danger', "There is no Available Payment! (=.=')");
}
return Redirect::to('inputdata/show_gaji_karyawan');
}