@@ -41,23 +41,23 @@ |
||
41 | 41 | */ |
42 | 42 | public function handle() |
43 | 43 | { |
44 | - $students = Institution_class_student::where('institution_class_id',0)->get()->toArray(); |
|
45 | - if(count($students)>0){ |
|
46 | - processParallel(array($this,'process'),$students,15); |
|
47 | - }else{ |
|
44 | + $students = Institution_class_student::where('institution_class_id', 0)->get()->toArray(); |
|
45 | + if (count($students) > 0) { |
|
46 | + processParallel(array($this, 'process'), $students, 15); |
|
47 | + }else { |
|
48 | 48 | echo "all are updated \r\n"; |
49 | 49 | } |
50 | 50 | } |
51 | 51 | |
52 | - public function process($student){ |
|
53 | - $institutionClass = Institution_class::getGradeClasses($student['education_grade_id'],$student['institution_id']); |
|
52 | + public function process($student) { |
|
53 | + $institutionClass = Institution_class::getGradeClasses($student['education_grade_id'], $student['institution_id']); |
|
54 | 54 | |
55 | - if(count($institutionClass) == 1){ |
|
56 | - Institution_class_student::where('student_id',$student['student_id']) |
|
57 | - ->update(['institution_class_id' => $institutionClass->id,'education_grade_id' => $student['education_grade_id']]); |
|
58 | - echo "updated:" .$student['student_id']; |
|
59 | - }else{ |
|
60 | - Institution_class_student::where('student_id',$student['student_id'])->delete(); |
|
55 | + if (count($institutionClass) == 1) { |
|
56 | + Institution_class_student::where('student_id', $student['student_id']) |
|
57 | + ->update(['institution_class_id' => $institutionClass->id, 'education_grade_id' => $student['education_grade_id']]); |
|
58 | + echo "updated:".$student['student_id']; |
|
59 | + }else { |
|
60 | + Institution_class_student::where('student_id', $student['student_id'])->delete(); |
|
61 | 61 | } |
62 | 62 | } |
63 | 63 | } |
@@ -44,7 +44,7 @@ discard block |
||
44 | 44 | $students = Institution_class_student::where('institution_class_id',0)->get()->toArray(); |
45 | 45 | if(count($students)>0){ |
46 | 46 | processParallel(array($this,'process'),$students,15); |
47 | - }else{ |
|
47 | + } else{ |
|
48 | 48 | echo "all are updated \r\n"; |
49 | 49 | } |
50 | 50 | } |
@@ -56,7 +56,7 @@ discard block |
||
56 | 56 | Institution_class_student::where('student_id',$student['student_id']) |
57 | 57 | ->update(['institution_class_id' => $institutionClass->id,'education_grade_id' => $student['education_grade_id']]); |
58 | 58 | echo "updated:" .$student['student_id']; |
59 | - }else{ |
|
59 | + } else{ |
|
60 | 60 | Institution_class_student::where('student_id',$student['student_id'])->delete(); |
61 | 61 | } |
62 | 62 | } |
@@ -4,7 +4,7 @@ discard block |
||
4 | 4 | |
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | |
7 | -class Institution_class extends Base_Model { |
|
7 | +class Institution_class extends Base_Model { |
|
8 | 8 | |
9 | 9 | public const CREATED_AT = 'created'; |
10 | 10 | public const UPDATED_AT = 'modified'; |
@@ -48,33 +48,33 @@ discard block |
||
48 | 48 | */ |
49 | 49 | protected $dates = ['modified', 'created']; |
50 | 50 | |
51 | - public function class_teacher(){ |
|
52 | - return $this->belongsTo('App\Models\Security_group_user','staff_id','security_user_id'); |
|
51 | + public function class_teacher() { |
|
52 | + return $this->belongsTo('App\Models\Security_group_user', 'staff_id', 'security_user_id'); |
|
53 | 53 | } |
54 | 54 | |
55 | - public function institution(){ |
|
56 | - return $this->belongsTo('App\Models\Institution','institution_id'); |
|
55 | + public function institution() { |
|
56 | + return $this->belongsTo('App\Models\Institution', 'institution_id'); |
|
57 | 57 | } |
58 | 58 | |
59 | 59 | |
60 | - public function getShiftClasses($shift){ |
|
60 | + public function getShiftClasses($shift) { |
|
61 | 61 | return self::query() |
62 | - ->select('institution_classes.id','institution_classes.institution_id','institution_classes.institution_shift_id', |
|
63 | - 'institution_classes.name','institution_classes.no_of_students','institution_classes.class_number','institution_class_grades.education_grade_id') |
|
64 | - ->where('institution_shift_id',$shift) |
|
62 | + ->select('institution_classes.id', 'institution_classes.institution_id', 'institution_classes.institution_shift_id', |
|
63 | + 'institution_classes.name', 'institution_classes.no_of_students', 'institution_classes.class_number', 'institution_class_grades.education_grade_id') |
|
64 | + ->where('institution_shift_id', $shift) |
|
65 | 65 | // ->where('academic_period_id',$academicPeriod) |
66 | - ->join('institution_class_grades','institution_classes.id','institution_class_grades.institution_class_id') |
|
66 | + ->join('institution_class_grades', 'institution_classes.id', 'institution_class_grades.institution_class_id') |
|
67 | 67 | ->groupBy('institution_classes.id') |
68 | 68 | ->get()->toArray(); |
69 | 69 | } |
70 | 70 | |
71 | - public static function getGradeClasses($education_grade_id,$institution_id){ |
|
71 | + public static function getGradeClasses($education_grade_id, $institution_id) { |
|
72 | 72 | return self::query() |
73 | - ->select('institution_classes.id','institution_classes.institution_id','institution_classes.institution_shift_id', |
|
74 | - 'institution_classes.name','institution_classes.no_of_students','institution_classes.class_number','institution_class_grades.education_grade_id') |
|
75 | - ->where('institution_class_grades.education_grade_id',$education_grade_id) |
|
76 | - ->where('institution_class_grades.institution_id',$institution_id) |
|
77 | - ->join('institution_class_grades','institution_classes.id','institution_class_grades.institution_class_id') |
|
73 | + ->select('institution_classes.id', 'institution_classes.institution_id', 'institution_classes.institution_shift_id', |
|
74 | + 'institution_classes.name', 'institution_classes.no_of_students', 'institution_classes.class_number', 'institution_class_grades.education_grade_id') |
|
75 | + ->where('institution_class_grades.education_grade_id', $education_grade_id) |
|
76 | + ->where('institution_class_grades.institution_id', $institution_id) |
|
77 | + ->join('institution_class_grades', 'institution_classes.id', 'institution_class_grades.institution_class_id') |
|
78 | 78 | ->groupBy('institution_classes.id') |
79 | 79 | ->get()->toArray(); |
80 | 80 | } |