/**
* Store a newly created resource in storage.
* @param Request $request
* @return Response
*/
public function store(Request $request)
{
$old_department_id = $request->input('department_id');
$term_id = $request->input('term_id');
$specialty_id = $request->input('specialty');
$student_id = $request->input('student_id');
$new_department_id = Department::select('id')->where('term_id', $term_id)->where('spec_id', $specialty_id)->get()->first()->id;
$hasOrder = OrderChangeDepartment::select('id')->where('student_id', $student_id)->count();
if ($hasOrder < 1) {
$OrderChangeDepartment = new OrderChangeDepartment();
$OrderChangeDepartment->added_by = User()->id;
$OrderChangeDepartment->student_id = $student_id;
$OrderChangeDepartment->from = $old_department_id;
$OrderChangeDepartment->to = $new_department_id;
$OrderChangeDepartment->save();
$msg = 'تم تقديم طلب لهذا الطالب ';
return redirect()->route('students.students.index')->with('success', $msg);
} else {
$msg = 'موجود طلب سابق';
return redirect()->route('students.students.index')->with('danger', $msg);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
echo 'start';
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
if (Student::count()) {
// return;
}
Student::where('id', '!=', 10000)->delete();
// DB::table('students')->where('id', '!=',10000)->delete();
// StudentHistory::truncate();
// StudentClassroomHistory::truncate();
// StudentClassroomSession::truncate();
StudentHistory::where('student_id', '!=', 10000)->delete();
$demo_students = [1268, 1276, 1284, 45, 2772, 2803, 2827];
$active_semester = 9;
$summer_semesters = [5, 8];
$quran_subjects = [8, 6, 21, 28, 39, 52];
$student_status = ['-3', '-4', '-5', '-6'];
$student_study_states = [1 => 'active', 2 => 'success', 3 => 'fail', 4 => 'stop', 5 => 'repeat', 6 => 'success'];
$student_states = [1 => 'active', 2 => 'delayed', 3 => 'withdrawn', 4 => 'fired', 5 => 'discontinuous', 6 => 'graduate'];
// $all_registrations = DB::connection('old')->table('registration')
// ->select('reg_specialist', 'reg_nationalid')
// ->orderBy('reg_id', 'DESC')
// ->get();
$all_user_subjects = DB::connection('old')->table('user_subject')->select('us_userid', 'us_subid', 'us_semid', 'us_state', 'us_result', 'us_status')->get();
$new_departments = $new_department = Department::select('ad.id', 'ad.parent_id', 'ay.id AS ay_id', 'as.code')->join('academystructure_terms as at', 'at.id', '=', 'ad.term_id')->join('academystructure_years as ay', function ($j) {
$j->on('at.year_id', '=', 'ay.id');
// ->where('ay.id', '=',$academy['academy_year']);
})->join('academystructure_specialties as as', function ($j) {
$j->on('as.id', '=', 'ad.spec_id');
// ->where('as.code', '=', $dep_sepcialty_code);
})->from('academystructure_departments as ad')->get()->toArray();
$all_old_academies = $academy = DB::connection('old')->table('sub_academy')->select('academy.*', 'sub_academy.sub_acad_subid')->join('academy', 'sub_acad_academyid', '=', 'academy_id')->get();
$all_old_academies = array_map(function ($a) {
return (array) $a;
}, $all_old_academies);
$students = DB::connection('old')->table('users')->select('users.*', 'r.reg_id')->where('user_groupid', 3)->where('user_edu_state', '>=', 1)->where('user_study_state', '>=', 1)->where('user_code', '!=', 'student')->leftJoin('registration as r', 'r.reg_nationalid', '=', 'users.user_nationalid')->groupBy('users.user_id')->get();
$new_students = [];
$new_histories = [];
echo 'will loop' . "\n";
foreach ($students as $student) {
$gender = substr($student->user_code, 5, 1) == '1' ? 'm' : 'f';
$new_student = [];
$new_student['id'] = $student->user_id;
$new_student['name'] = $student->user_fullname;
$new_student['email'] = $student->user_email;
$new_student['mobile'] = $student->user_phone;
$new_student['national_id'] = $student->user_nationalid;
$new_student['gender'] = $gender;
$new_student['state'] = 'active';
$new_student['study_state'] = 'first';
$new_student['academystructure_department_id'] = NULL;
$new_student['registration_id'] = $student->reg_id ? $student->reg_id : NULL;
$new_student['username'] = $student->user_code;
$new_student['password'] = bcrypt($student->user_phone);
// $new_student['created_at'] = new DateTime;
// $new_student['updated_at'] = new DateTime;
$success = false;
$semesters = array_unique(array_pluck(array_filter($all_user_subjects, function ($user_subject) use($student) {
return $user_subject->us_userid == $student->user_id;
}), 'us_semid'));
asort($semesters);
$i = 0;
foreach ($semesters as $semester) {
// exit(var_dump($semesters));
$history = ['student_id' => $student->user_id, 'state' => 'active', 'study_state' => 'stop', 'academycycle_semester_id' => $semester];
$subjects = array_filter($all_user_subjects, function ($user_subject) use($semester, $student) {
return $user_subject->us_semid == $semester && $user_subject->us_userid == $student->user_id;
});
$subjects = array_map(function ($item) {
return (array) $item;
}, $subjects);
$subjects = array_map(function ($item) {
return array_only($item, ['us_userid', 'us_state', 'us_result', 'us_status', 'us_subid']);
}, $subjects);
if (empty($subjects)) {
continue;
}
$one_subject = [];
foreach ($subjects as $subject) {
if (isset($one_subject['us_subid']) and $subject['us_subid'] > $one_subject['us_subid']) {
$one_subject = $subject;
} elseif (empty($one_subject)) {
$one_subject = $subject;
}
}
// exit(var_dump($one_subject));
// $one_subject = end($subjects);
$academy_where = ['sub_acad_subid' => $one_subject['us_subid']];
// if($student->user_yearid==3 && $semester>5) {
// if($i>4 && $semester>5) {
switch ($student->user_department) {
case 1:
$academy_department = 'اصول الفقة';
break;
case 2:
$academy_department = 'الدرسات الاسلامية';
break;
case 3:
$academy_department = 'عام';
break;
}
$academy_where['academy_department'] = $academy_department;
// }
if ($semester == $active_semester) {
$academy = array_filter($all_old_academies, function ($a) use($student) {
return $student->user_academyid == $a['academy_id'];
});
} else {
$academy = array_filter($all_old_academies, function ($a) use($one_subject, $academy_where) {
return empty($academy_where['academy_department']) or $a['academy_department'] == $academy_where['academy_department'];
});
}
// var_dump($academy_department);
$academy = current($academy);
if (empty($academy)) {
continue;
}
// $dep_sepcialty_code = 'G';
// new specialty code
switch ($student->user_department) {
case 1:
$dep_sepcialty_code = 'O';
break;
case 2:
$dep_sepcialty_code = 'I';
break;
case 3:
$dep_sepcialty_code = 'G';
break;
}
// var_dump($dep_sepcialty_code). "\n";
// if($student->user_de)
//
// $dep_sepcialty_code = 'G';
// if($academy['academy_department']=='اصول الفقة') {
// $dep_sepcialty_code = 'O';
// } elseif($academy['academy_department']=='الدرسات الاسلامية') {
// $dep_sepcialty_code = 'I';
// }
// if($academy['academy_id']<=4) {
// $student_nationalid = $student->user_nationalid;
// $registration = array_filter($all_registrations, function($reg) use ($student_nationalid){
// return $reg->reg_nationalid == $student_nationalid;
// });
// $registration = (array)array_shift($registration);
// if(!empty($registration)) {
// switch ($registration['reg_specialist']) {
// case 'islam':
// $dep_sepcialty_code = 'I';
// break;
// case 'feqh':
// $dep_sepcialty_code = 'O';
// break;
// default:
// $dep_sepcialty_code = 'G';
// break;
// }
// }
// }
$new_departments_filtered = array_filter($new_departments, function ($d) use($academy, $dep_sepcialty_code) {
return $d['ay_id'] == $academy['academy_year'] && $d['code'] == $dep_sepcialty_code;
});
if ($academy['academy_term'] == 2) {
$new_department = array_pop($new_departments_filtered);
} else {
$new_department = array_shift($new_departments_filtered);
}
$history['academystructure_department_id'] = $new_department['id'];
if (in_array($one_subject['us_result'], $student_status)) {
switch ($one_subject['us_result']) {
case "-3":
$history['state'] = 'withdrawn';
break;
case "-4":
$history['state'] = 'discontinuous';
break;
case "-5":
$history['state'] = 'fired';
break;
case "-6":
$history['state'] = 'delayed';
break;
}
}
$success_total = count(array_filter($subjects, function ($user_subject) {
return $user_subject['us_state'] == 'sucess';
}));
$failed_total = count(array_filter($subjects, function ($user_subject) {
return $user_subject['us_state'] == 'fail';
}));
if (!in_array($semester, array_merge($summer_semesters, [$active_semester]))) {
if ($failed_total >= 4) {
$history['study_state'] = 'fail';
} else {
$history['study_state'] = 'success';
}
} elseif (in_array($semester, $summer_semesters) && $failed_total > 0) {
$history['study_state'] = 'fail';
} elseif (in_array($semester, $summer_semesters) && $failed_total == 0) {
$history['study_state'] = 'success';
} elseif ($semester == $active_semester) {
$history['study_state'] = 'active';
}
if ($one_subject['us_status'] == '-1') {
$history['study_state'] = 'repeat';
}
if ($one_subject['us_result'] == '-6') {
$history['study_state'] = 'stop';
}
if ($i == count($semesters) - 1) {
$history['study_state'] = $student_study_states[$student->user_study_state];
$history['state'] = $student_states[$student->user_edu_state];
}
// var_dump($history);
$new_histories[] = $history;
$i++;
// end foreach $semesters as $semester
}
if (empty($semesters)) {
$new_department = array_filter($new_departments, function ($d) {
return $d['id'] == 3;
});
if (!empty($new_department)) {
$new_student['academystructure_department_id'] = current($new_department)['id'];
}
} else {
if (isset($new_department['id'])) {
$new_student['academystructure_department_id'] = $new_department['id'];
}
}
$new_student['study_state'] = $student_study_states[$student->user_edu_state];
$new_student['state'] = $student_states[$student->user_study_state];
$new_students[] = $new_student;
}
// var_dump($new_histories);
foreach (array_chunk($new_students, 1000) as $chunk) {
DB::table('students')->insert($chunk);
}
foreach (array_chunk($new_histories, 1000) as $chunk) {
DB::table('student_histories')->insert($chunk);
}
}
/**
* Run the database seeds.
*
* @return void
*/
public function run()
{
Model::unguard();
// echo 'in';
if (StudentSubject::count()) {
// return;
}
// $user_subjects = DB::connection('old')
// ->table('user_subject')
// // ->where('us_userid', 148)
// ->get();
// echo DB::connection('old')->table('user_subject')->count();
// exit;
// $this->call("OthersTableSeeder");
DB::statement('SET FOREIGN_KEY_CHECKS=0;');
StudentSubject::where('student_id', '!=', 10000)->delete();
// StudentSubject::truncate();
StudentGrade::where('student_id', '!=', 10000)->delete();
// StudentGrade::truncate();
$all_user_subjects = DB::connection('old')->table('user_subject')->leftJoin('users', 'users.user_id', '=', 'user_subject.us_userid')->select('users.user_academyid', 'us_state', 'us_subid', 'us_userid', 'us_semid', 'us_result')->get();
// echo 'got it';
$new_departments = $new_department = Department::select('ad.id', 'ay.id AS ay_id', 'as.code')->join('academystructure_terms as at', 'at.id', '=', 'ad.term_id')->join('academystructure_years as ay', function ($j) {
$j->on('at.year_id', '=', 'ay.id');
// ->where('ay.id', '=',$academy['academy_year']);
})->join('academystructure_specialties as as', function ($j) {
$j->on('as.id', '=', 'ad.spec_id');
// ->where('as.code', '=', $dep_sepcialty_code);
})->from('academystructure_departments as ad')->get()->toArray();
$all_old_academies = $academy = DB::connection('old')->table('sub_academy')->select('academy_department', 'academy_year', 'academy_term')->select('academy.*', 'sub_academy.sub_acad_subid')->join('academy', 'sub_acad_academyid', '=', 'academy_id')->get();
$all_old_academies = array_map(function ($a) {
return (array) $a;
}, $all_old_academies);
$student_subjects = [];
$student_grades = [];
// var_dump(count($all_user_subjects));
foreach ($all_user_subjects as $user_subject) {
$student_subject = [];
$student_grade = [];
$state = $user_subject->us_state == 'sucess' ? 'success' : $user_subject->us_state;
$state = $state == 'edu' ? 'study' : $state;
$state = $state == 'equ' ? 'equal' : $state;
if ($user_subject->us_semid == 9) {
$academy = array_filter($all_old_academies, function ($a) use($user_subject) {
return $user_subject->user_academyid == $a['academy_id'];
});
} else {
$academy = array_filter($all_old_academies, function ($a) use($user_subject) {
return $user_subject->us_subid == $a['sub_acad_subid'];
});
}
$academy = current($academy);
if (empty($academy)) {
continue;
}
$dep_sepcialty_code = 'D';
if ($academy['academy_department'] == 'اصول الفقة') {
$dep_sepcialty_code = 'O';
} elseif ($academy['academy_department'] == 'الدرسات الاسلامية') {
$dep_sepcialty_code = 'I';
}
$new_departments_filtered = array_filter($new_departments, function ($d) use($academy, $dep_sepcialty_code) {
$exist = $d['ay_id'] == $academy['academy_year'] && $d['code'] == $dep_sepcialty_code;
if ($exist) {
// var_dump($d);
}
return $exist;
});
if ($academy['academy_term'] == 2) {
$new_department = array_pop($new_departments_filtered);
} else {
$new_department = array_shift($new_departments_filtered);
}
$student_subject['student_id'] = $user_subject->us_userid;
$student_subject['subject_id'] = $user_subject->us_subid;
$student_subject['semester_id'] = $user_subject->us_semid;
$student_subject['state'] = $state;
$student_subject['academystructure_department_id'] = $new_department['id'];
$student_grade['student_id'] = $user_subject->us_userid;
$student_grade['subject_id'] = $user_subject->us_subid;
$student_grade['semester_id'] = $user_subject->us_semid;
$student_grade['notes'] = "تم جلبها من النظام القديم";
$student_grade['value'] = $user_subject->us_result;
$student_grade['created_at'] = new DateTime();
$student_grade['updated_at'] = new DateTime();
if ($user_subject->us_result >= 0) {
$student_grades[] = $student_grade;
}
$student_subjects[] = $student_subject;
}
foreach (array_chunk($student_subjects, 1000) as $chunk) {
DB::table('student_subjects')->insert($chunk);
}
foreach (array_chunk($student_grades, 1000) as $chunk) {
DB::table('student_grades')->insert($chunk);
}
}
public function show($student_id)
{
$student = Student::with(['classrooms', 'registration', 'registration.type', 'department', 'subjects'])->select('students.*')->joinTermName()->findOrFail($student_id);
$grades = StudentGrade::with('semester', 'subject')->inCurrentSemester()->where('student_id', $student->id)->get();
$registration = $student->registration;
//$study_plan = getspecialtystruct(1);
if ($student->department->spec_id) {
$study_plan = getspecialtystruct($student->department->spec_id);
} else {
$study_plan = getspecialtystruct(2);
}
//dd($study_plan);
$departments = Department::select(\DB::raw('GROUP_CONCAT(subject_ids) as sid , id as name'))->where('spec_id', 1)->get()->toArray();
$departments_subjects;
foreach ($departments as $key => &$aa) {
$a = implode(',', array_unique(array_merge(json_decode(str_replace('],[', ',', $aa['sid']), TRUE))));
$departments_subjects = explode(',', $a);
}
$student_subjects = StudentSubject::select(\DB::raw('GROUP_CONCAT(subject_id) as sid'))->where('student_id', $student_id)->where('state', 'success')->get()->toArray();
$student_subject_ids = explode(',', $student_subjects[0]['sid']);
$result = array_diff($departments_subjects, $student_subject_ids);
$complete_deplome_subjects = empty($result);
return view('students::students.show', compact('student', 'registration', 'grades', 'study_plan', 'study_subject', 'state_complite_sub', 'complete_deplome_subjects'));
}
public function index()
{
$demo_students = [1268, 1276, 1284, 45, 2772, 2803, 2827];
$active_semester = 7;
$summer_semester = 5;
$quran_subjects = [8, 6, 21, 28, 39, 52];
$student_status = ['-3', '-4', '-5', '-6'];
$students = DB::connection('old')->table('users')->take(1)->where('user_groupid', 3)->where('user_id', 45)->get();
foreach ($students as $student) {
Eloquent::unguard();
// var_dump($student->user_code);
$semesters = DB::connection('old')->table('user_subject')->groupBy('us_semid')->where('us_userid', $student->user_id)->pluck('us_semid');
$success = false;
foreach ($semesters as $semester) {
$history = ['student_id' => $student->user_id, 'state' => 'active', 'study_state' => 'stop', 'academycycle_semester_id' => $semester];
$subjects = DB::connection('old')->table('user_subject')->select('us_state', 'us_result', 'us_status', 'us_academyid', 'us_subid')->whereNotIn('us_subid', $quran_subjects)->where('us_userid', $student->user_id)->where('us_semid', $semester)->get();
if (empty($subjects)) {
continue;
}
$one_subject = $subjects[0];
$academy_where = ['sub_acad_subid' => $one_subject->us_subid];
if ($student->user_yearid == 3 && $semester > 5) {
switch ($student->user_department) {
case 1:
$academy_department = 'اصول الفقة';
break;
case 2:
$academy_department = 'الدرسات الاسلامية';
break;
case 3:
$academy_department = 'عام';
break;
}
$academy_where['academy_department'] = $academy_department;
}
$academy = DB::connection('old')->table('sub_academy')->select('academy.*')->join('academy', 'sub_acad_academyid', '=', 'academy_id')->where($academy_where)->first();
// var_dump($academy);
// continue;
$dep_sepcialty_code = 'G';
if ($academy->academy_department == 'اصول الفقة') {
$dep_sepcialty_code = 'FQH';
} elseif ($academy->academy_department == 'الدرسات الاسلامية') {
$dep_sepcialty_code = 'IST';
}
$term_order = 'ASC';
if ($academy->academy_term == 2) {
$term_order = 'DESC';
}
$new_department = Department::select('ad.id')->join('academystructure_terms as at', 'at.id', '=', 'ad.term_id')->join('academystructure_years as ay', function ($j) use($academy) {
$j->on('at.year_id', '=', 'ay.id')->where('ay.id', '=', $academy->academy_year);
})->join('academystructure_specialties as as', function ($j) use($dep_sepcialty_code) {
$j->on('as.id', '=', 'ad.spec_id')->where('as.code', '=', $dep_sepcialty_code);
})->from('academystructure_departments as ad')->orderBy('ad.id', $term_order)->first();
$history['academystructure_department_id'] = $new_department->id;
if (in_array($one_subject->us_result, $student_status)) {
switch ($one_subject->us_result) {
case "-3":
$history['state'] = 'withdrawn';
break;
case "-4":
$history['state'] = 'discontinuous';
break;
case "-5":
$history['state'] = 'fired';
break;
case "-6":
$history['state'] = 'delayed';
break;
}
}
$success_total = count(array_filter($subjects, function ($element) {
return $element->us_state == 'sucess';
}));
$failed_total = count(array_filter($subjects, function ($element) {
return $element->us_state == 'fail';
}));
if (!in_array($semester, [$summer_semester, $active_semester])) {
if ($failed_total >= 4) {
$history['study_state'] = 'fail';
} else {
$history['study_state'] = 'success';
}
} elseif ($semester == $summer_semester && $failed_total > 0) {
$history['study_state'] = 'fail';
} elseif ($semester == $summer_semester && $failed_total == 0) {
$history['study_state'] = 'success';
}
if ($one_subject->us_status == '-1') {
$history['study_state'] = 'repeat';
}
var_dump($history);
// end foreach $semesters as $semester
}
}
//return view('students::index');
}
