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