@@ -25,8 +25,8 @@ |
||
25 | 25 | */ |
26 | 26 | protected function schedule(Schedule $schedule) |
27 | 27 | { |
28 | - $schedule->command('import:students') |
|
29 | - ->cron('* * * * * '); |
|
28 | + $schedule->command('import:students') |
|
29 | + ->cron('* * * * * '); |
|
30 | 30 | } |
31 | 31 | |
32 | 32 | /** |
@@ -31,12 +31,12 @@ discard block |
||
31 | 31 | public function __construct($class) { |
32 | 32 | |
33 | 33 | $this->class = $class; |
34 | - $this->_file_name = time() . '_' . Auth::user()->id . '_' . 'student_upload.xls'; |
|
34 | + $this->_file_name = time().'_'.Auth::user()->id.'_'.'student_upload.xls'; |
|
35 | 35 | } |
36 | 36 | |
37 | 37 | public function registerEvents(): array { |
38 | 38 | return [ |
39 | - BeforeSheet::class => function(BeforeSheet $event){ |
|
39 | + BeforeSheet::class => function(BeforeSheet $event) { |
|
40 | 40 | // dd($event->crea) |
41 | 41 | }, |
42 | 42 | BeforeWriting::class => function(BeforeWriting $event) { |
@@ -63,7 +63,7 @@ discard block |
||
63 | 63 | $class = $this->class; |
64 | 64 | return Security_user::select('openemis_no', 'first_name', 'gender_id', 'date_of_birth', 'address', 'birthplace_area_id') |
65 | 65 | ->with(['class', 'special_needs']) |
66 | - ->whereHas('class', function ($query) use ($class) { |
|
66 | + ->whereHas('class', function($query) use ($class) { |
|
67 | 67 | $query->where('institution_class_id', '=', $class); |
68 | 68 | }) |
69 | 69 | ->get(); |
@@ -4,7 +4,7 @@ |
||
4 | 4 | |
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | |
7 | -class User_body_mass extends Base_Model { |
|
7 | +class User_body_mass extends Base_Model { |
|
8 | 8 | |
9 | 9 | /** |
10 | 10 | * The database table used by the model. |
@@ -4,7 +4,7 @@ discard block |
||
4 | 4 | |
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | |
7 | -class Institution_staff extends Model { |
|
7 | +class Institution_staff extends Model { |
|
8 | 8 | |
9 | 9 | /** |
10 | 10 | * The database table used by the model. |
@@ -42,12 +42,12 @@ discard block |
||
42 | 42 | protected $dates = ['start_date', 'end_date', 'modified', 'created']; |
43 | 43 | |
44 | 44 | |
45 | - public function staff_class(){ |
|
46 | - return $this->hasMany('App\Models\Institution_class','staff_id','staff_id'); |
|
45 | + public function staff_class() { |
|
46 | + return $this->hasMany('App\Models\Institution_class', 'staff_id', 'staff_id'); |
|
47 | 47 | } |
48 | 48 | |
49 | - public function institution(){ |
|
50 | - return $this->belongsTo('App\Models\Institution','institution_id'); |
|
49 | + public function institution() { |
|
50 | + return $this->belongsTo('App\Models\Institution', 'institution_id'); |
|
51 | 51 | } |
52 | 52 | |
53 | 53 |
@@ -4,7 +4,7 @@ |
||
4 | 4 | |
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | |
7 | -class Nationality extends Model { |
|
7 | +class Nationality extends Model { |
|
8 | 8 | |
9 | 9 | /** |
10 | 10 | * The database table used by the model. |
@@ -4,7 +4,7 @@ |
||
4 | 4 | |
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | |
7 | -class Workflow_transition extends Model { |
|
7 | +class Workflow_transition extends Model { |
|
8 | 8 | |
9 | 9 | public const CREATED_AT = 'created'; |
10 | 10 | public const UPDATED_AT = 'modified'; |
@@ -107,8 +107,8 @@ |
||
107 | 107 | * @return mixed |
108 | 108 | */ |
109 | 109 | public function getInstitutionGrade($institutionId, $gradeId){ |
110 | - return self::where('education_grade_id',$gradeId) |
|
111 | - ->where('institution_id',$institutionId)->get()->first(); |
|
110 | + return self::where('education_grade_id',$gradeId) |
|
111 | + ->where('institution_id',$institutionId)->get()->first(); |
|
112 | 112 | } |
113 | 113 | |
114 | 114 | /** |
@@ -83,7 +83,7 @@ |
||
83 | 83 | ->where('institution_grades.education_grade_id', $educationGradeId) |
84 | 84 | ->where('institution_grades.institution_id', $institutionId) |
85 | 85 | ->get(); |
86 | - }else{ |
|
86 | + } else{ |
|
87 | 87 | return null; |
88 | 88 | } |
89 | 89 | } |
@@ -71,11 +71,11 @@ discard block |
||
71 | 71 | { |
72 | 72 | if (!is_null($id)) { |
73 | 73 | return self::find($id) |
74 | - ->select('institution_grades.id as insGrade','institution_classes.id', 'institution_classes.name', 'institution_grades.education_grade_id') |
|
75 | - ->join('institution_classes', function ($join) use ($educationGradeId, $academicPeriodId) { |
|
74 | + ->select('institution_grades.id as insGrade', 'institution_classes.id', 'institution_classes.name', 'institution_grades.education_grade_id') |
|
75 | + ->join('institution_classes', function($join) use ($educationGradeId, $academicPeriodId) { |
|
76 | 76 | $join->on('institution_classes.institution_id', '=', 'institution_grades.institution_id') |
77 | 77 | ->where('institution_classes.academic_period_id', $academicPeriodId) |
78 | - ->join('institution_class_grades', function ($join) use ($educationGradeId) { |
|
78 | + ->join('institution_class_grades', function($join) use ($educationGradeId) { |
|
79 | 79 | $join->on('institution_class_grades.institution_class_id', '=', 'institution_classes.id') |
80 | 80 | ->where('institution_class_grades.education_grade_id', $educationGradeId); |
81 | 81 | }); |
@@ -83,7 +83,7 @@ discard block |
||
83 | 83 | ->where('institution_grades.education_grade_id', $educationGradeId) |
84 | 84 | ->where('institution_grades.institution_id', $institutionId) |
85 | 85 | ->get(); |
86 | - }else{ |
|
86 | + }else { |
|
87 | 87 | return null; |
88 | 88 | } |
89 | 89 | } |
@@ -95,8 +95,8 @@ discard block |
||
95 | 95 | * @param $year |
96 | 96 | * @param $id |
97 | 97 | */ |
98 | - public function updatePromoted($year, $id){ |
|
99 | - self::where('id',$id)->update(['promoted'=>$year]); |
|
98 | + public function updatePromoted($year, $id) { |
|
99 | + self::where('id', $id)->update(['promoted'=>$year]); |
|
100 | 100 | } |
101 | 101 | |
102 | 102 | /** |
@@ -106,9 +106,9 @@ discard block |
||
106 | 106 | * @param $gradeId |
107 | 107 | * @return mixed |
108 | 108 | */ |
109 | - public function getInstitutionGrade($institutionId, $gradeId){ |
|
110 | - return self::where('education_grade_id',$gradeId) |
|
111 | - ->where('institution_id',$institutionId)->get()->first(); |
|
109 | + public function getInstitutionGrade($institutionId, $gradeId) { |
|
110 | + return self::where('education_grade_id', $gradeId) |
|
111 | + ->where('institution_id', $institutionId)->get()->first(); |
|
112 | 112 | } |
113 | 113 | |
114 | 114 | /** |
@@ -116,14 +116,14 @@ discard block |
||
116 | 116 | * @param null $institution |
117 | 117 | * @return mixed |
118 | 118 | */ |
119 | - public function getInstitutionGradeToPromoted($year, $institution = null){ |
|
119 | + public function getInstitutionGradeToPromoted($year, $institution = null) { |
|
120 | 120 | return self::query() |
121 | - ->select('education_grades.name','institutions.code','institutions.name as institution_name','institution_grades.id','institution_grades.institution_id','institution_grades.education_grade_id') |
|
122 | - ->where('promoted','=',$year-1) |
|
123 | - ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id') |
|
124 | - ->join('institutions', function($join) use ($year,$institution){ |
|
125 | - $join->on('institutions.id','=','institution_grades.institution_id') |
|
126 | - ->where('institutions.code','=',$institution); |
|
121 | + ->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id') |
|
122 | + ->where('promoted', '=', $year - 1) |
|
123 | + ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id') |
|
124 | + ->join('institutions', function($join) use ($year, $institution){ |
|
125 | + $join->on('institutions.id', '=', 'institution_grades.institution_id') |
|
126 | + ->where('institutions.code', '=', $institution); |
|
127 | 127 | }) |
128 | 128 | ->orderBy('institution_id') |
129 | 129 | ->get()->toArray(); |
@@ -133,13 +133,13 @@ discard block |
||
133 | 133 | * @param $year |
134 | 134 | * @return mixed |
135 | 135 | */ |
136 | - public function getInstitutionGradeList($year){ |
|
136 | + public function getInstitutionGradeList($year) { |
|
137 | 137 | return self::query() |
138 | - ->select('education_grades.name','institutions.code','institutions.name as institution_name','institution_grades.id','institution_grades.institution_id','institution_grades.education_grade_id') |
|
139 | - ->where('promoted','=',$year-1) |
|
140 | - ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id') |
|
138 | + ->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id') |
|
139 | + ->where('promoted', '=', $year - 1) |
|
140 | + ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id') |
|
141 | 141 | ->join('institutions', function($join) use ($year){ |
142 | - $join->on('institutions.id','=','institution_grades.institution_id'); |
|
142 | + $join->on('institutions.id', '=', 'institution_grades.institution_id'); |
|
143 | 143 | }) |
144 | 144 | ->orderBy('institution_id') |
145 | 145 | ->get() |
@@ -5,7 +5,7 @@ discard block |
||
5 | 5 | use Illuminate\Database\Eloquent\Model; |
6 | 6 | use Webpatser\Uuid\Uuid; |
7 | 7 | |
8 | -class Institution_class_grade extends Base_Model { |
|
8 | +class Institution_class_grade extends Base_Model { |
|
9 | 9 | |
10 | 10 | /** |
11 | 11 | * The database table used by the model. |
@@ -46,9 +46,9 @@ discard block |
||
46 | 46 | * |
47 | 47 | * @return \Illuminate\Database\Eloquent\Relations\HasManyThrough |
48 | 48 | */ |
49 | - public function educationSubject(){ |
|
50 | - return $this->hasManyThrough('App\Models\Education_grades_subject','App\Models\Institution_subject', |
|
51 | - 'education_subject_id' ,'education_subject_id'); |
|
49 | + public function educationSubject() { |
|
50 | + return $this->hasManyThrough('App\Models\Education_grades_subject', 'App\Models\Institution_subject', |
|
51 | + 'education_subject_id', 'education_subject_id'); |
|
52 | 52 | } |
53 | 53 | |
54 | 54 | /** |
@@ -70,7 +70,7 @@ discard block |
||
70 | 70 | public static function boot() |
71 | 71 | { |
72 | 72 | parent::boot(); |
73 | - self::creating(function ($model) { |
|
73 | + self::creating(function($model) { |
|
74 | 74 | $model->id = (string) Uuid::generate(4); |
75 | 75 | }); |
76 | 76 | } |
@@ -79,7 +79,7 @@ discard block |
||
79 | 79 | /** |
80 | 80 | * @return \Illuminate\Database\Eloquent\Relations\BelongsTo |
81 | 81 | */ |
82 | - public function classes(){ |
|
83 | - return $this->belongsTo('App\Models\Institution_grade','institution_class_id','id'); |
|
82 | + public function classes() { |
|
83 | + return $this->belongsTo('App\Models\Institution_grade', 'institution_class_id', 'id'); |
|
84 | 84 | } |
85 | 85 | } |
@@ -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,22 +48,22 @@ 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 | } |