public function getData($id, $title, $kodeKelas, $kodeGrup) { $dateNow = Carbon::now(); $kelasDosen = Perkuliahan::select('kodekelas')->where('nip', '=', $id)->get()->toArray(); $kelasMhs = Mhskelas::select('kodekelas')->where('nim', '=', $id)->get()->toArray(); $data = array('mahasiswaProfile' => Mahasiswa::with('dosenWali')->where('nim', '=', Request::segment(3))->first(), 'mahasiswa' => Mahasiswa::where('nim', '=', $id)->first(), 'dosenwali' => ['' => '-- Pilih dosen --'] + Dosen::lists('nama', 'nip'), 'kelas' => Mhskelas::with(array('mhs', 'perkuliahan', 'mk'))->where('nim', '=', $id)->get(), 'title' => $title, 'listPerkuliahan' => ['' => '-- Pilih kelas --'] + Mhskelas::select('matakuliah.namamk', 'mhskelas.kodekelas')->join('matakuliah', 'mhskelas.kodemk', '=', 'matakuliah.kodemk')->join('mahasiswa', 'mhskelas.nim', '=', 'mahasiswa.nim')->where('mahasiswa.nim', '=', $id)->lists('matakuliah.namamk', 'mhskelas.kodekelas'), 'grup' => AnggotaGrup::select('grup.nama', 'grup.kodekelas', 'grup.id')->join('grup', 'grup.id', '=', 'anggota_grup.id_grup')->where('anggota_grup.nim', '=', $id)->get(), 'kelasMember' => Mhskelas::with('mhs')->where('kodekelas', '=', $kodeKelas)->get(), 'infokelas' => Perkuliahan::with('mk', 'dosen')->where('kodekelas', '=', $kodeKelas)->first(), 'infoGrup' => Grup::with('mk', 'mhs')->where('id', '=', $kodeGrup)->first(), 'grupMember' => AnggotaGrup::with('mhs')->where('id_grup', '=', $kodeGrup)->get(), 'inviteNotifCount' => Notifikasi::with('mhs')->where('recepient', '=', $id)->get(), 'tugasDosen' => Tugas::where('pengumpulan', '>=', $dateNow)->whereIn('kelas', $kelasDosen)->get(), 'tugasMhs' => Tugas::where('pengumpulan', '>=', $dateNow)->whereIn('kelas', $kelasMhs)->get(), 'pengumumanDosen' => Pengumuman::where('waktuaktif', '>=', $dateNow)->whereIn('kodekelas', $kelasDosen)->get(), 'pengumumanMhs' => Pengumuman::where('waktuaktif', '>=', $dateNow)->whereIn('kodekelas', $kelasMhs)->get()); return $data; }
} }); Route::get('relasi-4', function () { $ganin = Mahasiswa::where('nama', '=', 'Ganine Vinanda')->first(); foreach ($ganin->hobi as $temp) { echo '<li>' . $temp->hobi . '</li>'; } }); Route::get('relasi-5', function () { $ngoding = Hobi::where('hobi', '=', 'Ngoding')->first(); foreach ($ngoding->mahasiswa as $temp) { echo '<li> Nama : ' . $temp->nama . ' <strong>' . $temp->nim . '</strong></li>'; } }); Route::get('eloquent', function () { $mahasiswa = Mahasiswa::with('wali', 'dosen', 'hobi')->get(); return View::make('eloquent', compact('mahasiswa')); }); //DUMMY DATA-FAKER LIBRARY get('blog', 'BlogController@index'); get('blog/{slug}', 'BlogController@showPost'); //FORM DAN VIEW Route::get('article/create', 'ArticleController@add'); Route::get('article', 'ArticleController@index'); //Route::get('article/{id}','ArticleController@baca'); Route::post('article', 'ArticleController@simpan'); //MIDDLEWARE Route::get('admin/profile', ['middleware' => 'auth', function () { // }]); Route::get('/', ['middleware' => ['first', 'second'], function () {