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);
}