@@ -41,10 +41,10 @@ |
||
41 | 41 | { |
42 | 42 | $year = $this->argument('year'); |
43 | 43 | $institutions = $this->instituion_grade->getInstitutionGradeList($year); |
44 | - array_walk($institutions,array($this,'callPromotion'),$year); |
|
44 | + array_walk($institutions, array($this, 'callPromotion'), $year); |
|
45 | 45 | } |
46 | 46 | |
47 | - protected function callPromotion($institution,$count,$year){ |
|
48 | - $this->call('promote:students',['year' => $year,'institution' => $institution['code']]); |
|
47 | + protected function callPromotion($institution, $count, $year) { |
|
48 | + $this->call('promote:students', ['year' => $year, 'institution' => $institution['code']]); |
|
49 | 49 | } |
50 | 50 | } |
@@ -43,29 +43,29 @@ |
||
43 | 43 | $this->start_time = microtime(TRUE); |
44 | 44 | $this->output = new \Symfony\Component\Console\Output\ConsoleOutput(); |
45 | 45 | $this->output->writeln('############### Starting delete Duplication ################'); |
46 | - $studentsIdsWithDuplication = DB::table('institution_students as ins') |
|
47 | - ->select(DB::raw('count(*) as total'),'student_id','id','academic_period_id','education_grade_id') |
|
48 | - ->having('total','>',1) |
|
46 | + $studentsIdsWithDuplication = DB::table('institution_students as ins') |
|
47 | + ->select(DB::raw('count(*) as total'), 'student_id', 'id', 'academic_period_id', 'education_grade_id') |
|
48 | + ->having('total', '>', 1) |
|
49 | 49 | ->groupBy('ins.student_id') |
50 | 50 | ->orderBy('ins.student_id') |
51 | - ->chunk(100,function($Students){ |
|
51 | + ->chunk(100, function($Students) { |
|
52 | 52 | foreach ($Students as $Student) { |
53 | - Institution_student::where('institution_students.id','>',$Student->id) |
|
54 | - ->where('institution_students.student_id',$Student->student_id) |
|
55 | - ->where('institution_students.academic_period_id',$Student->academic_period_id) |
|
56 | - ->where('institution_students.education_grade_id',$Student->education_grade_id) |
|
53 | + Institution_student::where('institution_students.id', '>', $Student->id) |
|
54 | + ->where('institution_students.student_id', $Student->student_id) |
|
55 | + ->where('institution_students.academic_period_id', $Student->academic_period_id) |
|
56 | + ->where('institution_students.education_grade_id', $Student->education_grade_id) |
|
57 | 57 | ->delete(); |
58 | 58 | } |
59 | 59 | $this->end_time = microtime(TRUE); |
60 | - $this->output->writeln('Deleted 100 starting with' .$Students[0]->id); |
|
61 | - $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete'); |
|
60 | + $this->output->writeln('Deleted 100 starting with'.$Students[0]->id); |
|
61 | + $this->output->writeln('The cook took '.($this->end_time - $this->start_time).' seconds to complete'); |
|
62 | 62 | }); |
63 | 63 | $this->end_time = microtime(TRUE); |
64 | 64 | $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'); |
65 | - $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete'); |
|
65 | + $this->output->writeln('The cook took '.($this->end_time - $this->start_time).' seconds to complete'); |
|
66 | 66 | $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'); |
67 | 67 | |
68 | - } catch (\Throwable $th) { |
|
68 | + }catch (\Throwable $th) { |
|
69 | 69 | dd($th); |
70 | 70 | } |
71 | 71 | } |
@@ -61,7 +61,7 @@ |
||
61 | 61 | { |
62 | 62 | $year = $this->argument('year'); |
63 | 63 | $institution = $this->argument('institution'); |
64 | - $institutionGrade = $this->instituion_grade->getInstitutionGradeToPromoted($year,$institution); |
|
65 | - (new BulkPromotion())->callback($institutionGrade,$year); |
|
64 | + $institutionGrade = $this->instituion_grade->getInstitutionGradeToPromoted($year, $institution); |
|
65 | + (new BulkPromotion())->callback($institutionGrade, $year); |
|
66 | 66 | } |
67 | 67 | } |
@@ -27,11 +27,11 @@ |
||
27 | 27 | */ |
28 | 28 | protected $description = 'Update the students count male/female'; |
29 | 29 | |
30 | - /** |
|
31 | - * Create a new command instance. |
|
32 | - * |
|
33 | - * @return void |
|
34 | - */ |
|
30 | + /** |
|
31 | + * Create a new command instance. |
|
32 | + * |
|
33 | + * @return void |
|
34 | + */ |
|
35 | 35 | public function __construct() |
36 | 36 | { |
37 | 37 | parent::__construct(); |
@@ -48,36 +48,36 @@ discard block |
||
48 | 48 | public function handle() |
49 | 49 | { |
50 | 50 | $this->output->writeln('#########################################'); |
51 | - if($this->argument('entity') == 'class'){ |
|
51 | + if ($this->argument('entity') == 'class') { |
|
52 | 52 | $classes = Institution_class::get()->toArray(); |
53 | - $func = array($this,'updateCount'); |
|
54 | - array_walk($subjects,array($this,'process')); |
|
55 | - $this->output->writeln('start updating:'. count($classes)); |
|
56 | - }elseif($this->argument('entity') == 'subject'){ |
|
53 | + $func = array($this, 'updateCount'); |
|
54 | + array_walk($subjects, array($this, 'process')); |
|
55 | + $this->output->writeln('start updating:'.count($classes)); |
|
56 | + }elseif ($this->argument('entity') == 'subject') { |
|
57 | 57 | $subjects = Institution_subject::get()->toArray(); |
58 | - $subjects = array_chunk($subjects,10000); |
|
59 | - $this->output->writeln('start updating:'. count($subjects)); |
|
60 | - array_walk($subjects,array($this,'process')); |
|
58 | + $subjects = array_chunk($subjects, 10000); |
|
59 | + $this->output->writeln('start updating:'.count($subjects)); |
|
60 | + array_walk($subjects, array($this, 'process')); |
|
61 | 61 | $this->output->writeln('#########################################'); |
62 | 62 | } |
63 | 63 | |
64 | 64 | } |
65 | 65 | |
66 | - public function process($data){ |
|
67 | - if($this->argument('entity') == 'class'){ |
|
68 | - $func = array($this,'updateCount'); |
|
69 | - processParallel($func,$data,$this->argument('max')); |
|
70 | - $this->output->writeln('start updating calss count:'. count($data)); |
|
71 | - }elseif($this->argument('entity') == 'subject'){ |
|
72 | - $this->output->writeln('start updating subject count:'. count($data)); |
|
73 | - $func_subject = array($this,'updateSubjectCount'); |
|
74 | - processParallel($func_subject,$data,$this->argument('max')); |
|
66 | + public function process($data) { |
|
67 | + if ($this->argument('entity') == 'class') { |
|
68 | + $func = array($this, 'updateCount'); |
|
69 | + processParallel($func, $data, $this->argument('max')); |
|
70 | + $this->output->writeln('start updating calss count:'.count($data)); |
|
71 | + }elseif ($this->argument('entity') == 'subject') { |
|
72 | + $this->output->writeln('start updating subject count:'.count($data)); |
|
73 | + $func_subject = array($this, 'updateSubjectCount'); |
|
74 | + processParallel($func_subject, $data, $this->argument('max')); |
|
75 | 75 | } |
76 | 76 | } |
77 | 77 | |
78 | - public function updateCount($class){ |
|
79 | - $this->output->writeln('updating class:'. $class['id']); |
|
80 | - $totalStudents = Institution_class_student::getStudentsCount($class['id']); |
|
78 | + public function updateCount($class) { |
|
79 | + $this->output->writeln('updating class:'.$class['id']); |
|
80 | + $totalStudents = Institution_class_student::getStudentsCount($class['id']); |
|
81 | 81 | Institution_class::where('id', '=', $class['id']) |
82 | 82 | ->update([ |
83 | 83 | 'total_male_students' => $totalStudents['total_male_students'], |
@@ -85,8 +85,8 @@ discard block |
||
85 | 85 | ]); |
86 | 86 | } |
87 | 87 | |
88 | - public function updateSubjectCount($subject){ |
|
89 | - $this->output->writeln('updating subject:'. $subject['id']); |
|
88 | + public function updateSubjectCount($subject) { |
|
89 | + $this->output->writeln('updating subject:'.$subject['id']); |
|
90 | 90 | $totalStudents = Institution_subject_student::getStudentsCount($subject['id']); |
91 | 91 | Institution_subject::where(['id' => $subject['id']]) |
92 | 92 | ->update([ |
@@ -53,7 +53,7 @@ discard block |
||
53 | 53 | $func = array($this,'updateCount'); |
54 | 54 | array_walk($subjects,array($this,'process')); |
55 | 55 | $this->output->writeln('start updating:'. count($classes)); |
56 | - }elseif($this->argument('entity') == 'subject'){ |
|
56 | + } elseif($this->argument('entity') == 'subject'){ |
|
57 | 57 | $subjects = Institution_subject::get()->toArray(); |
58 | 58 | $subjects = array_chunk($subjects,10000); |
59 | 59 | $this->output->writeln('start updating:'. count($subjects)); |
@@ -68,7 +68,7 @@ discard block |
||
68 | 68 | $func = array($this,'updateCount'); |
69 | 69 | processParallel($func,$data,$this->argument('max')); |
70 | 70 | $this->output->writeln('start updating calss count:'. count($data)); |
71 | - }elseif($this->argument('entity') == 'subject'){ |
|
71 | + } elseif($this->argument('entity') == 'subject'){ |
|
72 | 72 | $this->output->writeln('start updating subject count:'. count($data)); |
73 | 73 | $func_subject = array($this,'updateSubjectCount'); |
74 | 74 | processParallel($func_subject,$data,$this->argument('max')); |
@@ -39,7 +39,7 @@ |
||
39 | 39 | */ |
40 | 40 | public function handle() |
41 | 41 | { |
42 | - $views = new DashboardViewsController(); |
|
43 | - $views->callback(); |
|
42 | + $views = new DashboardViewsController(); |
|
43 | + $views->callback(); |
|
44 | 44 | } |
45 | 45 | } |
@@ -52,9 +52,9 @@ |
||
52 | 52 | 'academic_period' => $academicPeriod |
53 | 53 | ]; |
54 | 54 | |
55 | - if($year <= 2019){ |
|
55 | + if ($year <= 2019) { |
|
56 | 56 | die('Academic Year 2019 or earlier can`t be deleted'); |
57 | - }else{ |
|
57 | + }else { |
|
58 | 58 | $this->clone->cleanConfig($params); |
59 | 59 | } |
60 | 60 | } |
@@ -54,7 +54,7 @@ |
||
54 | 54 | |
55 | 55 | if($year <= 2019){ |
56 | 56 | die('Academic Year 2019 or earlier can`t be deleted'); |
57 | - }else{ |
|
57 | + } else{ |
|
58 | 58 | $this->clone->cleanConfig($params); |
59 | 59 | } |
60 | 60 | } |
@@ -152,12 +152,12 @@ |
||
152 | 152 | ->get()->toArray(); |
153 | 153 | } |
154 | 154 | |
155 | - /** |
|
156 | - * First level search for students |
|
157 | - * |
|
158 | - * @param array $student |
|
159 | - * @return array |
|
160 | - */ |
|
155 | + /** |
|
156 | + * First level search for students |
|
157 | + * |
|
158 | + * @param array $student |
|
159 | + * @return array |
|
160 | + */ |
|
161 | 161 | public function getStudentCount($student) |
162 | 162 | { |
163 | 163 | return $this |
@@ -149,9 +149,9 @@ discard block |
||
149 | 149 | public function getMatches($student) |
150 | 150 | { |
151 | 151 | return $this |
152 | - ->where('gender_id',$student['gender'] + 1) |
|
153 | - ->where('institutions.code',$student['schoolid']) |
|
154 | - ->where('date_of_birth',$student['b_date']) |
|
152 | + ->where('gender_id', $student['gender'] + 1) |
|
153 | + ->where('institutions.code', $student['schoolid']) |
|
154 | + ->where('date_of_birth', $student['b_date']) |
|
155 | 155 | ->join('institution_students', 'security_users.id', 'institution_students.student_id') |
156 | 156 | ->join('institutions', 'institution_students.institution_id', 'institutions.id') |
157 | 157 | ->get()->toArray(); |
@@ -166,9 +166,9 @@ discard block |
||
166 | 166 | public function getStudentCount($student) |
167 | 167 | { |
168 | 168 | return $this |
169 | - ->where('gender_id',$student['gender'] + 1) |
|
170 | - ->where('institutions.code',$student['schoolid']) |
|
171 | - ->where('date_of_birth',$student['b_date']) |
|
169 | + ->where('gender_id', $student['gender'] + 1) |
|
170 | + ->where('institutions.code', $student['schoolid']) |
|
171 | + ->where('date_of_birth', $student['b_date']) |
|
172 | 172 | ->join('institution_students', 'security_users.id', 'institution_students.student_id') |
173 | 173 | ->join('institutions', 'institution_students.institution_id', 'institutions.id') |
174 | 174 | ->count(); |
@@ -202,7 +202,7 @@ discard block |
||
202 | 202 | $studentData['id'] = $id; |
203 | 203 | $this->uniqueUserId->updateOrInsertRecord($studentData); |
204 | 204 | return $studentData; |
205 | - } catch (\Exception $th) { |
|
205 | + }catch (\Exception $th) { |
|
206 | 206 | Log::error($th->getMessage()); |
207 | 207 | // in case of duplication of the Unique ID this will recursive. |
208 | 208 | $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric(); |
@@ -223,7 +223,7 @@ discard block |
||
223 | 223 | $this->uniqueUserId = new Unique_user_id(); |
224 | 224 | $this->uniqueUId = new UniqueUid(); |
225 | 225 | // regenerate unique id if it's not available |
226 | - $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'],9)) ? $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric(); |
|
226 | + $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ? $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric(); |
|
227 | 227 | |
228 | 228 | $studentData = [ |
229 | 229 | 'username' => str_replace('-', '', $uniqueId), |
@@ -237,11 +237,11 @@ discard block |
||
237 | 237 | ]; |
238 | 238 | |
239 | 239 | try { |
240 | - self::where( 'id' , $sis_student['student_id'])->update($studentData); |
|
240 | + self::where('id', $sis_student['student_id'])->update($studentData); |
|
241 | 241 | $studentData['id'] = $sis_student['student_id']; |
242 | 242 | $this->uniqueUserId->updateOrInsertRecord($studentData); |
243 | 243 | return $studentData; |
244 | - } catch (\Exception $th) { |
|
244 | + }catch (\Exception $th) { |
|
245 | 245 | Log::error($th); |
246 | 246 | // in case of duplication of the Unique ID this will recursive. |
247 | 247 | $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric(); |
@@ -47,7 +47,7 @@ |
||
47 | 47 | $output->writeln('###########################################------starting export------###########################################'); |
48 | 48 | $this->examinationController->export(); |
49 | 49 | $output->writeln('###########################################------Finished inserting file records------###########################################'); |
50 | - } else { |
|
50 | + }else { |
|
51 | 51 | $this->examinationController->doMatch($this->argument('offset'), $this->argument('limit'), $this->argument(('mode'))); |
52 | 52 | $this->examinationController->export(); |
53 | 53 | } |
@@ -37,8 +37,8 @@ |
||
37 | 37 | } |
38 | 38 | |
39 | 39 | /** |
40 | - * @return \Illuminate\Support\Collection |
|
41 | - */ |
|
40 | + * @return \Illuminate\Support\Collection |
|
41 | + */ |
|
42 | 42 | public function query() |
43 | 43 | { |
44 | 44 | return Examination_student::query()->whereNotNull('nsid') |
@@ -10,7 +10,7 @@ discard block |
||
10 | 10 | use Maatwebsite\Excel\Concerns\WithHeadings; |
11 | 11 | use Carbon\Carbon; |
12 | 12 | |
13 | -class ExaminationStudentsExport implements FromQuery , WithHeadings |
|
13 | +class ExaminationStudentsExport implements FromQuery, WithHeadings |
|
14 | 14 | { |
15 | 15 | |
16 | 16 | use Exportable; |
@@ -44,6 +44,6 @@ discard block |
||
44 | 44 | { |
45 | 45 | return Examination_student::query()->whereNotNull('nsid') |
46 | 46 | ->distinct('nsid') |
47 | - ->whereDate('updated_at','>=',Carbon::today()); |
|
47 | + ->whereDate('updated_at', '>=', Carbon::today()); |
|
48 | 48 | } |
49 | 49 | } |