public function register_new_student(NewStudentRegRequest $request)
{
DB::transaction(function () {
$party = new Party();
$party->firstname = $request->firstname;
$party->lastname = $request->lastname;
$party->middlename = $request->middlename;
$party->sex = $request->gender;
$party->placeofbirth = $request->pob;
$party->dateofbirth = $request->dob;
$party->mobilenumber = $request->contact;
$party->religion = $request->religion;
$party->emailaddress = $request->emailadd;
$party->civilstatus = $request->maritalstatus;
$party->legacyid = $this->system->laststudentid;
$party->address1 = $request->mailing_add;
// insert into party
$party->save();
// get the inserted id
$party_id = $party->id;
// set the laststudentid
$this->setLastStudentId();
$curriculum = Curriculum::getCurrentCurriculum($request->course, $request->major, $this->system);
$coursemajor = DB::table('coursemajor')->where('course', $request->course)->where('major', $request->major)->first();
$registration = new ModelRegistration();
$registration->curriculum = $curriculum;
$registration->student = $party_id;
$registration->academicterm = $this->system->currentacademicterm;
$registration->status = 'P';
$registration->date = date('Y-m-d');
$registration->coursemajor = $coursemajor->id;
// insert into registration
$registration->save();
DB::table('tbl_student')->insert(['id' => $party_id, 'fathername' => $request->father_name, 'fatherproffession' => $request->father_occupation, 'mothername' => $request->mother_name, 'motherproffession' => $request->mother_occupation]);
DB::table('tbl_useraccess')->insert(['id' => $party_id, 'username' => $request->username, 'password' => password_hash($request->password, PASSWORD_BCRYPT)]);
// TODO: insert into tbl_useroption
});
Session::put('message', htmlAlert('Successfully Registered', 'success'));
return back();
}