public function show($id) { $party = Party::find($id); $registration = Registration::student($id)->latest()->first(); $coursemajor = DB::table('tbl_coursemajor')->where('id', $registration->coursemajor)->first(); $data['courses'] = Course::all(); $data['majors'] = DB::table('tbl_major')->get(); $data['religions'] = DB::table('tbl_religion')->get(); $data['firstname'] = $party->firstname; $data['lastname'] = $party->lastname; $data['middlename'] = $party->middlename; $data['course_student'] = $coursemajor->course; $data['major_student'] = $coursemajor->major; $data['shift'] = $data['update'] = 'yes it is'; return view('registrar.shift_registration', $data); }
public function show($id) { $common = $this->commonQuery(); $data['courses'] = $common['course']; $data['majors'] = $common['majors']; $data['religions'] = $common['religions']; $party = Party::find($id); //$student = DB::table('tbl_student')->where('id', $id)->get(); // get the latest registration $registration = Registration::student($id)->latest()->first(); $coursemajor = DB::table('tbl_coursemajor')->where('id', $registration->coursemajor)->first(); $data['id'] = $id; $data['firstname'] = $party->firstname; $data['lastname'] = $party->lastname; $data['middlename'] = $party->middlename; $data['gender'] = $party->sex; $data['maritalstatus'] = $party->civilstatus; $data['religion_student'] = $party->religion; $data['mail_add'] = $party->address1; $data['contact'] = $party->mobilenumber; $data['emailadd'] = $party->emailaddress; $data['update'] = 'yes this is a update'; return view('registrar.update_student_reg', $data); }