public function saveStudentContactInformationKinDetail($is_verified)
{
$next_of_kin_title = Input::get('next_of_kin_title');
$next_of_kin_forename = Input::get('next_of_kin_forename');
$next_of_kin_surname = Input::get('next_of_kin_surname');
$next_of_kin_telephone = Input::get('next_of_kin_telephone');
$next_of_kin_email = Input::get('next_of_kin_email');
$t = Input::get('t');
$s = Input::get('s');
$se = Input::get('se');
$san = Input::get('san');
$ls_student_number = Input::get('ls_student_number');
$studentContactInformationKinDetail = new StudentContactInformationKinDetail();
$studentContactInformationKinDetail->next_of_kin_title = $next_of_kin_title;
$studentContactInformationKinDetail->next_of_kin_forename = $next_of_kin_forename;
$studentContactInformationKinDetail->next_of_kin_surname = $next_of_kin_surname;
$studentContactInformationKinDetail->next_of_kin_telephone = $next_of_kin_telephone;
$studentContactInformationKinDetail->next_of_kin_email = $next_of_kin_email;
$studentContactInformationKinDetail->is_verified = $is_verified;
$studentContactInformationKinDetail->san = $san;
$studentContactInformationKinDetail->created_by = Sentry::getUser()->id;
$studentContactInformationKinDetail->amendment = 0;
$studentContactInformationKinDetail->save();
return $studentContactInformationKinDetail->id;
}
/**
* Store a newly created resource in storage.
* POST /user
*
* @return Response
*/
public function store()
{
$skip = 0;
$take = 1;
if (Input::get('skip') > 0) {
$skip = Input::get('skip');
}
if (Input::get('take') > 0) {
$take = Input::get('take');
}
// Get old students
$students = DB::connection('mysql_old')->table('students')->join('student_bqu_data', 'student_bqu_data.student_id', '=', 'students.id')->groupBy('students.san')->skip($skip)->take($take)->get();
//return $students;
if (!is_null($students)) {
foreach ($students as $student) {
Log::info('Foreach start : ' . $student->san);
//Get specific SAN inserted
$inserted_data = DB::connection('mysql_old')->table('student_bqu_data')->orderBy('id', 'asc')->where('san', '=', $student->san)->where('status', '=', 1)->first();
if (!is_null($inserted_data)) {
$inserted_san = $inserted_data->san;
$inserted_student_id = $inserted_data->student_id;
Log::info('Inserted san : ' . $inserted_san);
//return $inserted_san;
//Student insert
$inserted_student = DB::connection('mysql_old')->table('students')->orderBy('id', 'asc')->where('id', '=', $inserted_student_id)->first();
if (!is_null($inserted_student)) {
$new_student = new Student();
$new_student->title = $inserted_student->title;
$new_student->initials_1 = $inserted_student->initials_1;
$new_student->initials_2 = $inserted_student->initials_2;
$new_student->initials_3 = $inserted_student->initials_3;
$new_student->forename_1 = $inserted_student->forename_1;
$new_student->forename_2 = $inserted_student->forename_2;
$new_student->forename_3 = $inserted_student->forename_3;
$new_student->surname = $inserted_student->surname;
$new_student->gender = $inserted_student->gender;
$new_student->date_of_birth = $inserted_student->date_of_birth;
$new_student->nationality = $inserted_student->nationality;
$new_student->passport = $inserted_student->passport;
$new_student->ls_student_number = $inserted_student->ls_student_number;
$new_student->is_verified = 1;
$new_student->amendment = 0;
$new_student->san = $inserted_san;
$new_student->created_by = $inserted_student->created_by;
$new_student->deleted_at = $inserted_student->deleted_at;
$new_student->created_at = $inserted_student->created_at;
$new_student->updated_at = $inserted_student->updated_at;
$new_student->save();
$new_student_id = $new_student->id;
Log::info('Student Saved with ID : ' . $new_student_id);
}
//student_bqu_data insert
$inserted_student_bqu_data = DB::connection('mysql_old')->table('student_bqu_data')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->first();
if (!is_null($inserted_student_bqu_data)) {
$new_student_bqu_data = new StudentBquData();
$new_student_bqu_data->application_received_date = $inserted_student_bqu_data->application_received_date;
$new_student_bqu_data->supervisor = $inserted_student_bqu_data->supervisor;
$new_student_bqu_data->notes = $inserted_student_bqu_data->notes;
$new_student_bqu_data->san = $inserted_student_bqu_data->san;
$new_student_bqu_data->amendment = 0;
$new_student_bqu_data->is_verified = 0;
$new_student_bqu_data->created_by = $inserted_student_bqu_data->created_by;
$new_student_bqu_data->deleted_at = $inserted_student_bqu_data->deleted_at;
$new_student_bqu_data->created_at = $inserted_student_bqu_data->created_at;
$new_student_bqu_data->updated_at = $inserted_student_bqu_data->updated_at;
$new_student_bqu_data->save();
$new_student_bqu_data_id = $new_student_bqu_data->id;
Log::info('Student BQu Data saved with ID : ' . $new_student_bqu_data_id);
}
//contact_information_kin_detailes insert
$inserted_contact_information_kin_detailes = DB::connection('mysql_old')->table('student_contact_information_kin_detailes')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->first();
if (!is_null($inserted_contact_information_kin_detailes)) {
$new_student_contact_information_kin_detail = new StudentContactInformationKinDetail();
$new_student_contact_information_kin_detail->next_of_kin_title = $inserted_contact_information_kin_detailes->next_of_kin_title;
$new_student_contact_information_kin_detail->next_of_kin_forename = $inserted_contact_information_kin_detailes->next_of_kin_forename;
$new_student_contact_information_kin_detail->next_of_kin_surname = $inserted_contact_information_kin_detailes->next_of_kin_surname;
$new_student_contact_information_kin_detail->next_of_kin_telephone = $inserted_contact_information_kin_detailes->next_of_kin_telephone;
$new_student_contact_information_kin_detail->next_of_kin_email = $inserted_contact_information_kin_detailes->next_of_kin_email;
$new_student_contact_information_kin_detail->san = $inserted_contact_information_kin_detailes->san;
$new_student_contact_information_kin_detail->created_by = $inserted_contact_information_kin_detailes->created_by;
$new_student_contact_information_kin_detail->deleted_at = $inserted_contact_information_kin_detailes->deleted_at;
$new_student_contact_information_kin_detail->created_at = $inserted_contact_information_kin_detailes->created_at;
$new_student_contact_information_kin_detail->updated_at = $inserted_contact_information_kin_detailes->updated_at;
$new_student_contact_information_kin_detail->amendment = 0;
$new_student_contact_information_kin_detail->is_verified = 0;
$new_student_contact_information_kin_detail->save();
$new_student_contact_information_kin_detail_id = $new_student_contact_information_kin_detail->id;
Log::info('Student Contact information kin detail with ID : ' . $new_student_contact_information_kin_detail_id);
}
//student_contact_information_onlines insert
$inserted_student_contact_information_onlines = DB::connection('mysql_old')->table('student_contact_information_onlines')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->first();
if (!is_null($inserted_student_contact_information_onlines)) {
$new_student_contact_information_onlines = new StudentContactInformationOnline();
$new_student_contact_information_onlines->email = $inserted_student_contact_information_onlines->email;
$new_student_contact_information_onlines->alternative_email = $inserted_student_contact_information_onlines->alternative_email;
$new_student_contact_information_onlines->facebook = $inserted_student_contact_information_onlines->facebook;
$new_student_contact_information_onlines->linkedin = $inserted_student_contact_information_onlines->linkedin;
$new_student_contact_information_onlines->twitter = $inserted_student_contact_information_onlines->twitter;
$new_student_contact_information_onlines->other_social = $inserted_student_contact_information_onlines->other_social;
$new_student_contact_information_onlines->san = $inserted_student_contact_information_onlines->san;
$new_student_contact_information_onlines->created_by = $inserted_student_contact_information_onlines->created_by;
$new_student_contact_information_onlines->deleted_at = $inserted_student_contact_information_onlines->deleted_at;
$new_student_contact_information_onlines->created_at = $inserted_student_contact_information_onlines->created_at;
$new_student_contact_information_onlines->updated_at = $inserted_student_contact_information_onlines->updated_at;
$new_student_contact_information_onlines->amendment = 0;
$new_student_contact_information_onlines->is_verified = 0;
$new_student_contact_information_onlines->save();
$new_student_contact_information_online_id = $new_student_contact_information_onlines->id;
Log::info('Student Contact information online with ID : ' . $new_student_contact_information_online_id);
}
//student_contact_informations insert
$inserted_student_contact_informations1 = DB::connection('mysql_old')->table('student_contact_informations')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->where('student_contact_information_type', '=', 1)->first();
$inserted_student_contact_informations2 = DB::connection('mysql_old')->table('student_contact_informations')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->where('student_contact_information_type', '=', 2)->first();
if (!is_null($inserted_student_contact_informations1)) {
$new_student_contact_informations = new StudentContactInformation();
$new_student_contact_informations->address_1 = $inserted_student_contact_informations1->address_1;
$new_student_contact_informations->address_2 = $inserted_student_contact_informations1->address_2;
$new_student_contact_informations->city = $inserted_student_contact_informations1->city;
$new_student_contact_informations->post_code = $inserted_student_contact_informations1->post_code;
$new_student_contact_informations->country = $inserted_student_contact_informations1->country;
$new_student_contact_informations->mobile = $inserted_student_contact_informations1->mobile;
$new_student_contact_informations->landline = $inserted_student_contact_informations1->landline;
$new_student_contact_informations->student_contact_information_type = 1;
$new_student_contact_informations->san = $inserted_student_contact_informations1->san;
$new_student_contact_informations->created_by = $inserted_student_contact_informations1->created_by;
$new_student_contact_informations->deleted_at = $inserted_student_contact_informations1->deleted_at;
$new_student_contact_informations->created_at = $inserted_student_contact_informations1->created_at;
$new_student_contact_informations->updated_at = $inserted_student_contact_informations1->updated_at;
$new_student_contact_informations->amendment = 0;
$new_student_contact_informations->is_verified = 0;
$new_student_contact_informations->save();
$new_student_contact_informations = new StudentContactInformation();
$new_student_contact_informations->address_1 = $inserted_student_contact_informations2->address_1;
$new_student_contact_informations->address_2 = $inserted_student_contact_informations2->address_2;
$new_student_contact_informations->city = $inserted_student_contact_informations2->city;
$new_student_contact_informations->post_code = $inserted_student_contact_informations2->post_code;
$new_student_contact_informations->country = $inserted_student_contact_informations2->country;
$new_student_contact_informations->mobile = $inserted_student_contact_informations2->mobile;
$new_student_contact_informations->landline = $inserted_student_contact_informations2->landline;
$new_student_contact_informations->student_contact_information_type = 2;
$new_student_contact_informations->san = $inserted_student_contact_informations2->san;
$new_student_contact_informations->created_by = $inserted_student_contact_informations2->created_by;
$new_student_contact_informations->deleted_at = $inserted_student_contact_informations2->deleted_at;
$new_student_contact_informations->created_at = $inserted_student_contact_informations2->created_at;
$new_student_contact_informations->updated_at = $inserted_student_contact_informations2->updated_at;
$new_student_contact_informations->amendment = 0;
$new_student_contact_informations->is_verified = 0;
$new_student_contact_informations->save();
$new_student_contact_informations_id = $new_student_contact_informations->id;
Log::info('Student Contact information with ID : ' . $new_student_contact_informations_id);
}
//student_course_enrolments insert
$inserted_student_course_enrolments = DB::connection('mysql_old')->table('student_course_enrolments')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->first();
if (!is_null($inserted_student_course_enrolments)) {
$new_student_course_enrolments = new StudentCourseEnrolment();
$new_student_course_enrolments->course_name = $inserted_student_course_enrolments->course_name;
$new_student_course_enrolments->course_level = $inserted_student_course_enrolments->course_level;
$new_student_course_enrolments->awarding_body = $inserted_student_course_enrolments->awarding_body;
$new_student_course_enrolments->intake = $inserted_student_course_enrolments->intake;
$new_student_course_enrolments->study_mode = $inserted_student_course_enrolments->study_mode;
$new_student_course_enrolments->san = $inserted_student_course_enrolments->san;
$new_student_course_enrolments->created_by = $inserted_student_course_enrolments->created_by;
$new_student_course_enrolments->deleted_at = $inserted_student_course_enrolments->deleted_at;
$new_student_course_enrolments->created_at = $inserted_student_course_enrolments->created_at;
$new_student_course_enrolments->updated_at = $inserted_student_course_enrolments->updated_at;
$new_student_course_enrolments->amendment = 0;
$new_student_course_enrolments->is_verified = 0;
$new_student_course_enrolments->save();
$new_student_course_enrolments_id = $inserted_student_course_enrolments->id;
Log::info('Student course enrollment with ID : ' . $new_student_course_enrolments_id);
}
//student_educational_qualifications insert
$inserted_student_educational_qualifications = DB::connection('mysql_old')->table('student_educational_qualifications')->orderBy('id', 'asc')->where('student_id', '=', $inserted_student_id)->get();
if (!is_null($inserted_student_educational_qualifications)) {
return $inserted_student_educational_qualifications;
$new_student_educational_qualifications = new StudentEducationalQualification();
for ($i = 1; $i < 4; $i++) {
$j = $i;
$new_student_educational_qualifications->qualification . '_' . ($i = $inserted_student_educational_qualifications[$j]->qualification);
$new_student_educational_qualifications->qualification_other_ . '_' . ($i = $inserted_student_educational_qualifications[$j]->qualification_other);
$new_student_educational_qualifications->qualification . '_' . ($i = $inserted_student_educational_qualifications[$j]->institution);
$new_student_educational_qualifications->qualification . '_' . ($i = $inserted_student_educational_qualifications[$j]->qualification_start_date);
$new_student_educational_qualifications->qualification . '_' . ($i = $inserted_student_educational_qualifications[$j]->qualification_end_date);
$new_student_educational_qualifications->qualification . '_' . ($i = $inserted_student_educational_qualifications[$j]->qualification_grade);
$new_student_educational_qualifications->san = $inserted_student_educational_qualifications[$j]->san;
$new_student_educational_qualifications->created_by = $inserted_student_educational_qualifications[$j]->created_by;
$new_student_educational_qualifications->deleted_at = $inserted_student_educational_qualifications[$j]->deleted_at;
$new_student_educational_qualifications->created_at = $inserted_student_educational_qualifications[$j]->created_at;
$new_student_educational_qualifications->updated_at = $inserted_student_educational_qualifications[$j]->updated_at;
$new_student_educational_qualifications->amendment = 0;
$new_student_educational_qualifications->is_verified = 0;
}
$new_student_educational_qualifications->save();
$new_student_educational_qualifications_id = $new_student_educational_qualifications->id;
Log::info('Student course enrollment with ID : ' . $new_student_educational_qualifications_id);
}
}
}
}
}