public function profil() { $user = Auth::user(); //$user_data = $request->user(); $id = $user->id; $student = Student::where('id_user', $id)->first(); //$student $name = $student->Nama_Mhs; $noreg = $student->Noreg; $prodi_model = $student->prodi; $prodi_id = $prodi_model->id; $prodi_name = $prodi_model->prodi; $semester = $student->Semester; $alamat = $student->Alamat; $telepon = $student->Telepon; $mac = $student->Mac; $prodis = Prodi::all(); $prodi_arr = Helpers::modelAsAssociativeArray($prodis, 'id', 'prodi'); return view('students.profil', ['name' => $name, 'noreg' => $noreg, 'prodi' => $prodi_name, 'semester' => $semester, 'alamat' => $alamat, 'telepon' => $telepon, 'mac' => $mac, 'prodi_opts' => $prodi_arr, 'prodi_id' => $prodi_id]); }
public function rekapDosen(Request $request) { //get list of semester $kalender = Kalender::all('id', 'semester'); $kalender_array = Helpers::modelAsAssociativeArray($kalender, 'id', 'semester'); //get list of course sections for current semester and lecturer $lecturer = Auth::user()->lecturer; $kode_dosen = $lecturer->Kode_Dosen; $semester = Kalender::getRunningSemester(); //for debugging $course_model = DB::table('courses')->where('Kode_Dosen', $kode_dosen)->where('id_semester', $semester->id); $course = $course_model->get(); $course_array = Helpers::modelAsAssociativeArray($course, 'seksi', 'Nama_Matkul'); //make default showing first course on the list $enrollment = array(); $seksi = array(); if (empty($course)) { $enrollment = array(); } else { $seksi = $course[0]->seksi; //pass along list of enrolled students $enrollment = $course_model->where('seksi', $seksi)->join('enrollments as e', 'e.kode_seksi', '=', 'courses.seksi')->join('students as s', 's.Noreg', '=', 'e.noreg')->get(); } return view('lecturers.rekap')->with('kalender_options', $kalender_array)->with('course_options', $course_array)->with('course', $course)->with('enrolls', $enrollment)->with('semester_id', $semester->id)->with('kode_seksi', $seksi); }