HomeController.php

public function regis(){
     $id_check = Input::get('id') ;
     $sks_check = Input::get('sks');
     $kode_mk = Input::get('kode_mk');
     $jumlah_mhs = DB::table('tbmk_ajuan')
                    ->join('tbtranskip','tbmk_ajuan.id_transkip','=','tbtranskip.id')
                    ->select('kode_mk','jumlah_mhs')
                    ->wherein('kode_mk',$kode_mk)
                    ->lists('jumlah_mhs');
     $id_tbmk = DB::table('tbmk_ajuan')
                 ->wherein('id_transkip',$id_check)
                 ->select('id_transkip')
                 ->get();
    $sks_maks = DB::table('tbmk_ajuan')
                   ->join('tbtranskip','tbmk_ajuan.id_transkip','=','tbtranskip.id')
                   ->where('nim',Auth::user()->nim)
                   ->lists('sks');
    $sks_maks2 = DB::table('tbtranskip')
                   ->wherein('id',$id_check)
                   ->lists('sks');

      foreach($jumlah_mhs as $jumlah_maha){
        $jumlah_maha;
         }


     if(is_array($id_check)){
       if(array_sum($sks_check) > 10){
         Session::flash('message-error','Maksimal Hanya 10 SKS yang bisa di ambil');
         return redirect('/registrasi');
       }elseif (is_array($id_check) == $id_tbmk) {
         Session::flash('message-error','Tidak Bisa mengambil mata kuliah yang sama');
         return redirect('/registrasi');
       } else if((array_sum($sks_maks)+array_sum($sks_maks2)) > 10) {
         Session::flash('message-error','Maksimal 10 SKS yang bisa di ambil');
         return redirect('/registrasi');
       }else {
         foreach ($id_check as $id_check) {
          DB::insert('INSERT INTO tbmk_ajuan (id_transkip,nim_mhs,jumlah_mhs,keterangan) VALUES (?,?,?,?)', array($id_check,Auth::user()->nim,'1','Belum aktif'));
          DB::insert('INSERT INTO tbtagihan (id_transkip,nim_mhs,keterangan) values (?,?,?)',array($id_check,Auth::user()->nim,'Belum Lunas'));

        }
          Session::flash('message-success','Data Berhasil di Simpan.');
          return redirect('/registrasi');
      }
    }else {
        DB::rollback();
        Session::flash('message-error','Jangan di biarkan kosong.');
        return redirect('/registrasi');
    }
     $nilai = DB::table('tbtranskip')
                ->join('tbnilai','nilai', '=','tbnilai.nilai_mk')
                ->select('id','mk','nilai','status','kode_mk','mk','sks')
                ->where('nim',Auth::user()->nim)
                ->get();
     $pengumuman = DB::table('pengumuman')->get();
     return view('registrasi',compact('pengumuman'),compact('nilai'));
   }