@@ -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 | } |
@@ -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 | } |
@@ -44,21 +44,21 @@ |
||
44 | 44 | $this->start_time = microtime(TRUE); |
45 | 45 | $count = DB::table('examination_students')->select('nsid')->distinct()->count(); |
46 | 46 | $this->examinationController = new ExaminationStudentsController($this->argument('year'), $this->argument('grade')); |
47 | - $studentsIdsWithDuplication = DB::table('examination_students as es') |
|
48 | - ->select(DB::raw('count(*) as total'),'es.*') |
|
47 | + $studentsIdsWithDuplication = DB::table('examination_students as es') |
|
48 | + ->select(DB::raw('count(*) as total'), 'es.*') |
|
49 | 49 | ->whereNotNull('es.nsid') |
50 | - ->having('total','>',1) |
|
50 | + ->having('total', '>', 1) |
|
51 | 51 | ->groupBy('es.nsid') |
52 | 52 | ->orderBy('es.nsid') |
53 | - ->chunk($this->argument('limit'),function($Students){ |
|
53 | + ->chunk($this->argument('limit'), function($Students) { |
|
54 | 54 | foreach ($Students as $Student) { |
55 | - $count = Examination_student::where('nsid',$Student->nsid)->count(); |
|
56 | - if($count> 1){ |
|
57 | - Examination_student::where('nsid',$Student->nsid)->update(['nsid'=>'']); |
|
55 | + $count = Examination_student::where('nsid', $Student->nsid)->count(); |
|
56 | + if ($count > 1) { |
|
57 | + Examination_student::where('nsid', $Student->nsid)->update(['nsid'=>'']); |
|
58 | 58 | $students = (array) json_decode(json_encode($Students), true); |
59 | 59 | array_walk($students, array($this->examinationController, 'clone')); |
60 | 60 | } |
61 | - $this->output->writeln($Student->nsid .'same ID' . $count . ' records removed'); |
|
61 | + $this->output->writeln($Student->nsid.'same ID'.$count.' records removed'); |
|
62 | 62 | } |
63 | 63 | }); |
64 | 64 | } |
@@ -75,7 +75,7 @@ discard block |
||
75 | 75 | public function registerEvents(): array |
76 | 76 | { |
77 | 77 | return [ |
78 | - BeforeSheet::class => function (BeforeSheet $event) { |
|
78 | + BeforeSheet::class => function(BeforeSheet $event) { |
|
79 | 79 | $this->sheetNames[] = $event->getSheet()->getTitle(); |
80 | 80 | $this->worksheet = $event->getSheet(); |
81 | 81 | $this->validateClass(); |
@@ -87,7 +87,7 @@ discard block |
||
87 | 87 | throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures); |
88 | 88 | } |
89 | 89 | }, |
90 | - BeforeImport::class => function (BeforeImport $event) { |
|
90 | + BeforeImport::class => function(BeforeImport $event) { |
|
91 | 91 | $this->highestRow = ($event->getReader()->getDelegate()->getActiveSheet()->getHighestDataRow('C')); |
92 | 92 | if ($this->highestRow < 3) { |
93 | 93 | $error = \Illuminate\Validation\ValidationException::withMessages([]); |
@@ -114,21 +114,21 @@ discard block |
||
114 | 114 | $mandatorySubject = Institution_class_subject::getMandetorySubjects($this->file['institution_class_id']); |
115 | 115 | // dd($mandatorySubject); |
116 | 116 | $subjects = getMatchingKeys($row); |
117 | - $genderId = null; |
|
117 | + $genderId = null; |
|
118 | 118 | switch ($row['gender_mf']) { |
119 | 119 | case 'M': |
120 | 120 | $genderId = $row['gender_mf'] = 1; |
121 | 121 | $this->maleStudentsCount += 1; |
122 | 122 | break; |
123 | 123 | case 'F': |
124 | - $genderId = $row['gender_mf'] = 2; |
|
124 | + $genderId = $row['gender_mf'] = 2; |
|
125 | 125 | $this->femaleStudentsCount += 1; |
126 | 126 | break; |
127 | 127 | } |
128 | 128 | |
129 | - $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first(); |
|
130 | - $nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first(); |
|
131 | - $identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first(); |
|
129 | + $BirthArea = Area_administrative::where('name', 'like', '%'.$row['birth_registrar_office_as_in_birth_certificate'].'%')->first(); |
|
130 | + $nationalityId = Nationality::where('name', 'like', '%'.$row['nationality'].'%')->first(); |
|
131 | + $identityType = Identity_type::where('national_code', 'like', '%'.$row['identity_type'].'%')->first(); |
|
132 | 132 | $academicPeriod = Academic_period::where('name', '=', $row['academic_period'])->first(); |
133 | 133 | |
134 | 134 | |
@@ -144,7 +144,7 @@ discard block |
||
144 | 144 | |
145 | 145 | $openemisStudent = $this->uniqueUid::getUniqueAlphanumeric(); |
146 | 146 | \Log::debug('Security_user'); |
147 | - $student = Security_user::create([ |
|
147 | + $student = Security_user::create([ |
|
148 | 148 | 'username' => str_replace('-', '', $openemisStudent), |
149 | 149 | 'openemis_no' => $openemisStudent, |
150 | 150 | 'first_name' => $row['full_name'], // here we save full name in the column of first name. re reduce breaks of the system. |
@@ -241,9 +241,9 @@ discard block |
||
241 | 241 | if (!empty($row['bmi_weight']) && !empty($row['bmi_weight']) && !empty($row['bmi_date_yyyy_mm_dd'])) { |
242 | 242 | try { |
243 | 243 | // convert Meeter to CM |
244 | - $hight = $row['bmi_height'] / 100; |
|
244 | + $hight = $row['bmi_height']/100; |
|
245 | 245 | //calculate BMI |
246 | - $bodyMass = ($row['bmi_weight']) / pow($hight, 2); |
|
246 | + $bodyMass = ($row['bmi_weight'])/pow($hight, 2); |
|
247 | 247 | |
248 | 248 | $bmiAcademic = Academic_period::where('name', '=', $row['bmi_academic_period'])->first(); |
249 | 249 | |
@@ -257,17 +257,17 @@ discard block |
||
257 | 257 | 'security_user_id' => $student->student_id, |
258 | 258 | 'created_user_id' => $this->file['security_user_id'] |
259 | 259 | ]); |
260 | - } catch (\Throwable $th) { |
|
261 | - \Log::error('User_body_mass:' . $th->getMessage()); |
|
260 | + }catch (\Throwable $th) { |
|
261 | + \Log::error('User_body_mass:'.$th->getMessage()); |
|
262 | 262 | } |
263 | 263 | } |
264 | 264 | |
265 | 265 | |
266 | 266 | if (!empty($row['fathers_full_name']) && ($row['fathers_date_of_birth_yyyy_mm_dd'] !== null)) { |
267 | 267 | |
268 | - $AddressArea = Area_administrative::where('name', 'like', '%' . $row['fathers_address_area'] . '%')->first(); |
|
269 | - $nationalityId = Nationality::where('name', 'like', '%' . $row['fathers_nationality'] . '%')->first(); |
|
270 | - $identityType = Identity_type::where('national_code', 'like', '%' . $row['fathers_identity_type'] . '%')->first(); |
|
268 | + $AddressArea = Area_administrative::where('name', 'like', '%'.$row['fathers_address_area'].'%')->first(); |
|
269 | + $nationalityId = Nationality::where('name', 'like', '%'.$row['fathers_nationality'].'%')->first(); |
|
270 | + $identityType = Identity_type::where('national_code', 'like', '%'.$row['fathers_identity_type'].'%')->first(); |
|
271 | 271 | $openemisFather = $this->uniqueUid::getUniqueAlphanumeric(); |
272 | 272 | |
273 | 273 | $identityType = ($identityType !== null) ? $identityType->id : null; |
@@ -305,7 +305,7 @@ discard block |
||
305 | 305 | User_contact::createOrUpdate($father, $this->file['security_user_id']); |
306 | 306 | } |
307 | 307 | Student_guardian::createStudentGuardian($student, $father, $this->file['security_user_id']); |
308 | - } else { |
|
308 | + }else { |
|
309 | 309 | Security_user::where('id', '=', $father->id) |
310 | 310 | ->update(['is_guardian' => 1]); |
311 | 311 | $father['guardian_relation_id'] = 1; |
@@ -318,9 +318,9 @@ discard block |
||
318 | 318 | } |
319 | 319 | |
320 | 320 | if (!empty($row['mothers_full_name']) && ($row['mothers_date_of_birth_yyyy_mm_dd'] !== null)) { |
321 | - $AddressArea = Area_administrative::where('name', 'like', '%' . $row['mothers_address_area'] . '%')->first(); |
|
322 | - $nationalityId = Nationality::where('name', 'like', '%' . $row['mothers_nationality'] . '%')->first(); |
|
323 | - $identityType = Identity_type::where('national_code', 'like', '%' . $row['mothers_identity_type'] . '%')->first(); |
|
321 | + $AddressArea = Area_administrative::where('name', 'like', '%'.$row['mothers_address_area'].'%')->first(); |
|
322 | + $nationalityId = Nationality::where('name', 'like', '%'.$row['mothers_nationality'].'%')->first(); |
|
323 | + $identityType = Identity_type::where('national_code', 'like', '%'.$row['mothers_identity_type'].'%')->first(); |
|
324 | 324 | $openemisMother = $this->uniqueUid::getUniqueAlphanumeric(); |
325 | 325 | |
326 | 326 | $identityType = $identityType !== null ? $identityType->id : null; |
@@ -356,7 +356,7 @@ discard block |
||
356 | 356 | User_contact::createOrUpdate($mother, $this->file['security_user_id']); |
357 | 357 | } |
358 | 358 | Student_guardian::createStudentGuardian($student, $mother, $this->file['security_user_id']); |
359 | - } else { |
|
359 | + }else { |
|
360 | 360 | Security_user::where('id', '=', $mother->id) |
361 | 361 | ->update(['is_guardian' => 1]); |
362 | 362 | $mother['guardian_relation_id'] = 2; |
@@ -371,9 +371,9 @@ discard block |
||
371 | 371 | |
372 | 372 | if (!empty($row['guardians_full_name']) && ($row['guardians_date_of_birth_yyyy_mm_dd'] !== null)) { |
373 | 373 | $genderId = $row['guardians_gender_mf'] == 'M' ? 1 : 2; |
374 | - $AddressArea = Area_administrative::where('name', 'like', '%' . $row['guardians_address_area'] . '%')->first(); |
|
375 | - $nationalityId = Nationality::where('name', 'like', '%' . $row['guardians_nationality'] . '%')->first(); |
|
376 | - $identityType = Identity_type::where('national_code', 'like', '%' . $row['guardians_identity_type'] . '%')->first(); |
|
374 | + $AddressArea = Area_administrative::where('name', 'like', '%'.$row['guardians_address_area'].'%')->first(); |
|
375 | + $nationalityId = Nationality::where('name', 'like', '%'.$row['guardians_nationality'].'%')->first(); |
|
376 | + $identityType = Identity_type::where('national_code', 'like', '%'.$row['guardians_identity_type'].'%')->first(); |
|
377 | 377 | $openemisGuardian = $this->uniqueUid::getUniqueAlphanumeric(); |
378 | 378 | |
379 | 379 | $identityType = $identityType !== null ? $identityType->id : null; |
@@ -410,7 +410,7 @@ discard block |
||
410 | 410 | User_contact::createOrUpdate($guardian, $this->file['security_user_id']); |
411 | 411 | } |
412 | 412 | Student_guardian::createStudentGuardian($student, $guardian, $this->file['security_user_id']); |
413 | - } else { |
|
413 | + }else { |
|
414 | 414 | Security_user::where('id', '=', $guardian->id) |
415 | 415 | ->update(['is_guardian' => 1]); |
416 | 416 | $guardian['guardian_relation_id'] = 3; |
@@ -440,7 +440,7 @@ discard block |
||
440 | 440 | |
441 | 441 | if ($totalStudents['total'] > $institutionClass->no_of_students) { |
442 | 442 | $error = \Illuminate\Validation\ValidationException::withMessages([]); |
443 | - $failure = new Failure(3, 'rows', [3 => 'Class student count exceeded! Max number of students is ' . $institutionClass->no_of_students], [null]); |
|
443 | + $failure = new Failure(3, 'rows', [3 => 'Class student count exceeded! Max number of students is '.$institutionClass->no_of_students], [null]); |
|
444 | 444 | $failures = [0 => $failure]; |
445 | 445 | throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures); |
446 | 446 | Log::info('email-sent', [$this->file]); |
@@ -452,7 +452,7 @@ discard block |
||
452 | 452 | 'total_female_students' => $totalStudents['total_female_students'] |
453 | 453 | ]); |
454 | 454 | } |
455 | - } catch (\Maatwebsite\Excel\Validators\ValidationException $e) { |
|
455 | + }catch (\Maatwebsite\Excel\Validators\ValidationException $e) { |
|
456 | 456 | $error = \Illuminate\Validation\ValidationException::withMessages([]); |
457 | 457 | // $failure = new Failure(3, 'remark', [3 => ], [null]); |
458 | 458 | $failures = $e->failures(); |
@@ -467,7 +467,7 @@ discard block |
||
467 | 467 | return [ |
468 | 468 | '*.full_name' => 'required|regex:/^[\pL\s\-]+$/u|max:100', |
469 | 469 | '*.gender_mf' => 'required|in:M,F', |
470 | - '*.date_of_birth_yyyy_mm_dd' => 'date|required|admission_age:' . $this->file['institution_class_id'], |
|
470 | + '*.date_of_birth_yyyy_mm_dd' => 'date|required|admission_age:'.$this->file['institution_class_id'], |
|
471 | 471 | '*.address' => 'nullable', |
472 | 472 | '*.birth_registrar_office_as_in_birth_certificate' => 'nullable|exists:area_administratives,name|required_if:identity_type,BC|birth_place', |
473 | 473 | '*.birth_divisional_secretariat' => 'nullable|exists:area_administratives,name|required_with:birth_registrar_office_as_in_birth_certificate', |
@@ -477,8 +477,8 @@ discard block |
||
477 | 477 | '*.academic_period' => 'required|exists:academic_periods,name', |
478 | 478 | '*.education_grade' => 'required', |
479 | 479 | '*.option_*' => 'nullable|exists:education_subjects,name', |
480 | - '*.bmi_height' => 'bail|required_with:*.bmi_weight|bmi:' . $this->file['institution_class_id'], |
|
481 | - '*.bmi_weight' => 'bail|required_with:*.bmi_height|bmi:' . $this->file['institution_class_id'], |
|
480 | + '*.bmi_height' => 'bail|required_with:*.bmi_weight|bmi:'.$this->file['institution_class_id'], |
|
481 | + '*.bmi_weight' => 'bail|required_with:*.bmi_height|bmi:'.$this->file['institution_class_id'], |
|
482 | 482 | '*.bmi_date_yyyy_mm_dd' => 'bail|required_with:*.bmi_height|date', //bmi:'. $this->file['institution_class_id'].' |
483 | 483 | '*.bmi_academic_period' => 'bail|required_with:*.bmi_height|exists:academic_periods,name', |
484 | 484 | '*.admission_no' => 'required|max:12|min:4|regex:/^[A-Za-z0-9\/]+$/', |
@@ -28,17 +28,17 @@ discard block |
||
28 | 28 | $this->academic_period = new Academic_period(); |
29 | 29 | $this->institution_classes = new Institution_class(); |
30 | 30 | $this->institution_class_subjects = new Institution_class_subject(); |
31 | - $this->institution_subjects = new Institution_subject(); |
|
32 | - $this->education_grade_subjects = new Education_grades_subject(); |
|
31 | + $this->institution_subjects = new Institution_subject(); |
|
32 | + $this->education_grade_subjects = new Education_grades_subject(); |
|
33 | 33 | $this->output = new \Symfony\Component\Console\Output\ConsoleOutput(); |
34 | 34 | } |
35 | 35 | |
36 | 36 | |
37 | - public function array_walk($shift,$count,$params){ |
|
38 | - array_walk($shift,array($this,'process'),$params); |
|
37 | + public function array_walk($shift, $count, $params) { |
|
38 | + array_walk($shift, array($this, 'process'), $params); |
|
39 | 39 | } |
40 | 40 | |
41 | - public function cleanConfig($params){ |
|
41 | + public function cleanConfig($params) { |
|
42 | 42 | $academicPeriod = $params['academic_period']; |
43 | 43 | $this->shifts->where(['academic_period_id' => $academicPeriod->id])->delete(); |
44 | 44 | $this->output->writeln('cleaned shifts'); |
@@ -46,32 +46,32 @@ discard block |
||
46 | 46 | $this->shifts->where(['cloned' => $academicPeriod->code])->update(['cloned' => $academicPeriod->code - 1]); |
47 | 47 | $this->output->writeln('updated shifts'); |
48 | 48 | |
49 | - $classIds = $this->institution_classes->select('id')->where(['academic_period_id' => $academicPeriod->id])->get()->toArray(); |
|
49 | + $classIds = $this->institution_classes->select('id')->where(['academic_period_id' => $academicPeriod->id])->get()->toArray(); |
|
50 | 50 | $this->institution_classes->where(['academic_period_id' => $academicPeriod->id])->delete(); |
51 | 51 | $this->output->writeln('cleaned classes'); |
52 | 52 | |
53 | - $this->institution_class_subjects->whereNotIn( 'institution_class_id' , $classIds)->delete(); |
|
53 | + $this->institution_class_subjects->whereNotIn('institution_class_id', $classIds)->delete(); |
|
54 | 54 | $this->output->writeln('cleaned subjects'); |
55 | 55 | |
56 | - do{ |
|
57 | - $deleted = $this->institution_subjects->where('academic_period_id',$academicPeriod->id)->limit(100000)->delete(); |
|
56 | + do { |
|
57 | + $deleted = $this->institution_subjects->where('academic_period_id', $academicPeriod->id)->limit(100000)->delete(); |
|
58 | 58 | $this->output->writeln('100000 institutions cleaned shifts'); |
59 | - }while($deleted > 0); |
|
59 | + } while ($deleted > 0); |
|
60 | 60 | } |
61 | 61 | |
62 | - public function process($shift,$count,$params){ |
|
63 | - echo('['.getmypid().']This Process executed at'.date("F d, Y h:i:s A")."\n") ; |
|
62 | + public function process($shift, $count, $params) { |
|
63 | + echo('['.getmypid().']This Process executed at'.date("F d, Y h:i:s A")."\n"); |
|
64 | 64 | $year = $params['year']; |
65 | 65 | $academicPeriod = $params['academic_period']; |
66 | 66 | $previousAcademicPeriod = $params['previous_academic_period']; |
67 | - try{ |
|
67 | + try { |
|
68 | 68 | $shiftId = $this->updateShifts($year, $shift); |
69 | 69 | $institutionClasses = $this->institution_classes->getShiftClasses($shift['id']); |
70 | - $institutionSubjects = $this->institution_subjects->getInstitutionSubjects($shift['institution_id'],$previousAcademicPeriod->id); |
|
71 | - array_walk($institutionSubjects , array($this,'insertInstitutionSubjects'),$academicPeriod); |
|
72 | - if (!empty($institutionClasses) && !is_null($shiftId) && !is_null($academicPeriod) ) { |
|
70 | + $institutionSubjects = $this->institution_subjects->getInstitutionSubjects($shift['institution_id'], $previousAcademicPeriod->id); |
|
71 | + array_walk($institutionSubjects, array($this, 'insertInstitutionSubjects'), $academicPeriod); |
|
72 | + if (!empty($institutionClasses) && !is_null($shiftId) && !is_null($academicPeriod)) { |
|
73 | 73 | |
74 | - $newInstitutionClasses = $this->generateNewClass($institutionClasses,$shiftId,$academicPeriod->id); |
|
74 | + $newInstitutionClasses = $this->generateNewClass($institutionClasses, $shiftId, $academicPeriod->id); |
|
75 | 75 | |
76 | 76 | $params = [ |
77 | 77 | 'previous_academic_period_id' => $previousAcademicPeriod->id, |
@@ -79,21 +79,21 @@ discard block |
||
79 | 79 | 'shift_id' =>$shiftId |
80 | 80 | ]; |
81 | 81 | |
82 | - try{ |
|
83 | - array_walk($newInstitutionClasses,array($this,'insertInstitutionClasses'),$params); |
|
82 | + try { |
|
83 | + array_walk($newInstitutionClasses, array($this, 'insertInstitutionClasses'), $params); |
|
84 | 84 | $newInstitutionClasses = $this->institution_classes->getShiftClasses($shiftId); |
85 | 85 | $this->output->writeln('##########################################################################################################################'); |
86 | - $this->output->writeln('updating from '. $shiftId); |
|
86 | + $this->output->writeln('updating from '.$shiftId); |
|
87 | 87 | |
88 | - }catch (\Exception $e){ |
|
88 | + }catch (\Exception $e) { |
|
89 | 89 | dd($e); |
90 | - Log::error($e->getMessage(),[$e]); |
|
90 | + Log::error($e->getMessage(), [$e]); |
|
91 | 91 | } |
92 | 92 | } |
93 | 93 | // DB::commit(); |
94 | - }catch (\Exception $e){ |
|
94 | + }catch (\Exception $e) { |
|
95 | 95 | // DB::rollBack(); |
96 | - Log::error($e->getMessage(),[$e]); |
|
96 | + Log::error($e->getMessage(), [$e]); |
|
97 | 97 | } |
98 | 98 | } |
99 | 99 | |
@@ -103,31 +103,31 @@ discard block |
||
103 | 103 | * @param $count |
104 | 104 | * @param $academicPeriod |
105 | 105 | */ |
106 | - public function insertInstitutionSubjects($subjects, $count,$academicPeriod){ |
|
107 | - try{ |
|
106 | + public function insertInstitutionSubjects($subjects, $count, $academicPeriod) { |
|
107 | + try { |
|
108 | 108 | $subjects['academic_period_id'] = $academicPeriod->id; |
109 | 109 | $subjects['created'] = now(); |
110 | 110 | unset($subjects['total_male_students']); |
111 | 111 | unset($subjects['total_female_students']); |
112 | 112 | unset($subjects['id']); |
113 | 113 | $this->institution_subjects->create($subjects); |
114 | - }catch (\Exception $e){ |
|
115 | - Log::error($e->getMessage(),[$e]); |
|
114 | + }catch (\Exception $e) { |
|
115 | + Log::error($e->getMessage(), [$e]); |
|
116 | 116 | } |
117 | 117 | } |
118 | 118 | |
119 | 119 | |
120 | - public function insertInstitutionClasses($class,$count,$param){ |
|
121 | - try{ |
|
120 | + public function insertInstitutionClasses($class, $count, $param) { |
|
121 | + try { |
|
122 | 122 | |
123 | 123 | $academicPeriod = $param['academic_period_id']; |
124 | 124 | $educationGrdae = $class['education_grade_id']; |
125 | 125 | |
126 | 126 | $classId = $class['id']; |
127 | 127 | unset($class['id']); |
128 | - $institutionSubjects = Institution_subject::query()->where('education_grade_id',$class['education_grade_id']) |
|
129 | - ->where('institution_id',$class['institution_id']) |
|
130 | - ->where('academic_period_id',$academicPeriod)->get()->toArray(); |
|
128 | + $institutionSubjects = Institution_subject::query()->where('education_grade_id', $class['education_grade_id']) |
|
129 | + ->where('institution_id', $class['institution_id']) |
|
130 | + ->where('academic_period_id', $academicPeriod)->get()->toArray(); |
|
131 | 131 | $params = [ |
132 | 132 | 'class'=>$class, |
133 | 133 | 'subjects'=>$institutionSubjects, |
@@ -140,39 +140,39 @@ discard block |
||
140 | 140 | $class['no_of_students'] = $noOfStudents; |
141 | 141 | $class['created'] = now(); |
142 | 142 | $class['institution_shift_id'] = $param['shift_id']; |
143 | - $this->output->writeln('Create class:'. $class['name']); |
|
143 | + $this->output->writeln('Create class:'.$class['name']); |
|
144 | 144 | $class = Institution_class::create($class); |
145 | 145 | $institutionClassGrdaeObj['institution_class_id'] = $class->id; |
146 | 146 | $institutionClassGrdaeObj['education_grade_id'] = $educationGrdae; |
147 | 147 | Institution_class_grade::create($institutionClassGrdaeObj); |
148 | - $institutionSubjects = Institution_subject::query()->where('education_grade_id',$educationGrdae) |
|
149 | - ->where('institution_id',$class->institution_id) |
|
150 | - ->where('academic_period_id',$academicPeriod) |
|
148 | + $institutionSubjects = Institution_subject::query()->where('education_grade_id', $educationGrdae) |
|
149 | + ->where('institution_id', $class->institution_id) |
|
150 | + ->where('academic_period_id', $academicPeriod) |
|
151 | 151 | ->groupBy('education_subject_id') |
152 | 152 | ->get() |
153 | 153 | ->toArray(); |
154 | 154 | $params['class'] = $class; |
155 | - $this->insertInstitutionClassSubjects($institutionSubjects,$class); |
|
155 | + $this->insertInstitutionClassSubjects($institutionSubjects, $class); |
|
156 | 156 | // array_walk($classSubjects,array($this,'insertInstitutionClassSubjects'),$params); |
157 | - }catch (\Exception $e){ |
|
158 | - Log::error($e->getMessage(),[$e]); |
|
157 | + }catch (\Exception $e) { |
|
158 | + Log::error($e->getMessage(), [$e]); |
|
159 | 159 | } |
160 | 160 | } |
161 | 161 | |
162 | - public function insertInstitutionClassSubjects($subjects,$class){ |
|
163 | - if(!empty($subjects)){ |
|
164 | - try{ |
|
165 | - array_walk($subjects,array($this,'insertClassSubjects'),$class); |
|
166 | - $this->output->writeln('updating subjects '. $class->name); |
|
167 | - }catch (\Exception $e){ |
|
168 | - Log::error($e->getMessage(),[$e]); |
|
162 | + public function insertInstitutionClassSubjects($subjects, $class) { |
|
163 | + if (!empty($subjects)) { |
|
164 | + try { |
|
165 | + array_walk($subjects, array($this, 'insertClassSubjects'), $class); |
|
166 | + $this->output->writeln('updating subjects '.$class->name); |
|
167 | + }catch (\Exception $e) { |
|
168 | + Log::error($e->getMessage(), [$e]); |
|
169 | 169 | } |
170 | 170 | }; |
171 | 171 | } |
172 | 172 | |
173 | 173 | |
174 | - public function insertClassSubjects($subject,$count,$newClassId){ |
|
175 | - try{ |
|
174 | + public function insertClassSubjects($subject, $count, $newClassId) { |
|
175 | + try { |
|
176 | 176 | $subjectobj['status'] = 1; |
177 | 177 | $subjectobj['created_user_id'] = 1; |
178 | 178 | $subjectobj['created'] = now(); |
@@ -180,11 +180,11 @@ discard block |
||
180 | 180 | $subjectobj['institution_class_id'] = $newClassId->id; |
181 | 181 | $subjectobj['institution_subject_id'] = $subject['id']; |
182 | 182 | |
183 | - if(!$this->institution_class_subjects->isDuplicated($subjectobj)){ |
|
183 | + if (!$this->institution_class_subjects->isDuplicated($subjectobj)) { |
|
184 | 184 | $this->institution_class_subjects->create($subjectobj); |
185 | 185 | } |
186 | - }catch (\Exception $e){ |
|
187 | - Log::error($e->getMessage(),[$e]); |
|
186 | + }catch (\Exception $e) { |
|
187 | + Log::error($e->getMessage(), [$e]); |
|
188 | 188 | } |
189 | 189 | } |
190 | 190 | |
@@ -196,15 +196,15 @@ discard block |
||
196 | 196 | * @param $academicPeriod |
197 | 197 | * @return array |
198 | 198 | */ |
199 | - public function generateNewClass($classes,$shiftId,$academicPeriod){ |
|
199 | + public function generateNewClass($classes, $shiftId, $academicPeriod) { |
|
200 | 200 | $newClasses = []; |
201 | - foreach ( $classes as $class) { |
|
201 | + foreach ($classes as $class) { |
|
202 | 202 | $noOfStudents = $class['no_of_students'] == 0 ? 40 : $class['no_of_students']; |
203 | 203 | $class['academic_period_id'] = $academicPeriod; |
204 | 204 | $class['no_of_students'] = $noOfStudents; |
205 | 205 | $class['created'] = now(); |
206 | 206 | $class['institution_shift_id'] = $shiftId; |
207 | - array_push($newClasses,$class); |
|
207 | + array_push($newClasses, $class); |
|
208 | 208 | } |
209 | 209 | return $newClasses; |
210 | 210 | } |
@@ -215,11 +215,11 @@ discard block |
||
215 | 215 | * @param $shift |
216 | 216 | * @return mixed |
217 | 217 | */ |
218 | - public function updateShifts($year,$shift){ |
|
218 | + public function updateShifts($year, $shift) { |
|
219 | 219 | $academicPeriod = $this->academic_period->getAcademicPeriod($year); |
220 | - $this->shifts->where('id',$shift['id'])->update(['cloned' => $year]); |
|
220 | + $this->shifts->where('id', $shift['id'])->update(['cloned' => $year]); |
|
221 | 221 | $shift['academic_period_id'] = $academicPeriod->id; |
222 | 222 | $exist = $this->shifts->shiftExists($shift); |
223 | - return $this->shifts->create((array)$shift)->id; |
|
223 | + return $this->shifts->create((array) $shift)->id; |
|
224 | 224 | } |
225 | 225 | } |
@@ -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([ |
@@ -61,12 +61,12 @@ |
||
61 | 61 | // dd($shift); |
62 | 62 | $function = array($this->clone, 'process'); |
63 | 63 | // array_walk($shift,$function,$params); |
64 | - processParallel($function,$shift, $this->argument('max'),$params); |
|
64 | + processParallel($function, $shift, $this->argument('max'), $params); |
|
65 | 65 | $this->end_time = microtime(TRUE); |
66 | 66 | |
67 | 67 | |
68 | 68 | $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'); |
69 | - $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete'); |
|
69 | + $this->output->writeln('The cook took '.($this->end_time - $this->start_time).' seconds to complete'); |
|
70 | 70 | $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$'); |
71 | 71 | } |
72 | 72 | } |
@@ -48,12 +48,12 @@ discard block |
||
48 | 48 | { |
49 | 49 | $type = $this->argument('type'); |
50 | 50 | $students = array(); |
51 | - if($type == 'invalid'){ |
|
51 | + if ($type == 'invalid') { |
|
52 | 52 | $students = DB::table('examination_students as es') |
53 | 53 | ->whereRaw('CHAR_LENGTH(nsid) > 11') |
54 | 54 | ->get() |
55 | 55 | ->toArray(); |
56 | - }elseif($type == 'duplicate'){ |
|
56 | + }elseif ($type == 'duplicate') { |
|
57 | 57 | $students = DB::table('institution_students as is') |
58 | 58 | ->join('security_users as su', 'su.id', 'is.student_id') |
59 | 59 | ->where('is.updated_from', 'doe') |
@@ -63,39 +63,39 @@ discard block |
||
63 | 63 | ->get() |
64 | 64 | ->toArray(); |
65 | 65 | |
66 | - }elseif('all'){ |
|
66 | + }elseif ('all') { |
|
67 | 67 | $students = DB::table('examination_students') |
68 | - ->where('nsid','<>','') |
|
68 | + ->where('nsid', '<>', '') |
|
69 | 69 | ->whereNotNull('nsid') |
70 | 70 | ->get() |
71 | 71 | ->toArray(); |
72 | 72 | } |
73 | 73 | |
74 | 74 | $this->output->writeln('###########################################------Start cleanning exam records------###########################################'); |
75 | - if(count($students) > 0){ |
|
76 | - $this->output->writeln('Total students to clean: '. count($students)); |
|
75 | + if (count($students) > 0) { |
|
76 | + $this->output->writeln('Total students to clean: '.count($students)); |
|
77 | 77 | $students = array_chunk($students, $this->argument('chunk')); |
78 | 78 | $function = array($this, 'process'); |
79 | - processParallel($function,$students, $this->argument('max')); |
|
80 | - }else{ |
|
79 | + processParallel($function, $students, $this->argument('max')); |
|
80 | + }else { |
|
81 | 81 | $this->output->writeln('nothing to process, all are cleaned'); |
82 | 82 | } |
83 | 83 | $this->output->writeln('###########################################------Finished cleaning exam records------###########################################'); |
84 | 84 | } |
85 | 85 | |
86 | - public function process($students){ |
|
86 | + public function process($students) { |
|
87 | 87 | $type = $this->argument('type'); |
88 | - if($type == 'duplication'){ |
|
89 | - array_walk($students,array($this,'cleanData')); |
|
90 | - }elseif($type == 'invalid' || 'all'){ |
|
91 | - array_walk($students,array($this,'cleanInvalidData')); |
|
88 | + if ($type == 'duplication') { |
|
89 | + array_walk($students, array($this, 'cleanData')); |
|
90 | + }elseif ($type == 'invalid' || 'all') { |
|
91 | + array_walk($students, array($this, 'cleanInvalidData')); |
|
92 | 92 | } |
93 | 93 | } |
94 | 94 | |
95 | 95 | |
96 | 96 | public function cleanData($Student) |
97 | 97 | { |
98 | - $exist = Examination_student::where('nsid','=', $Student->openemis_no)->count(); |
|
98 | + $exist = Examination_student::where('nsid', '=', $Student->openemis_no)->count(); |
|
99 | 99 | |
100 | 100 | if (!$exist) { |
101 | 101 | Institution_student::where('student_id', $Student->student_id)->delete(); |
@@ -108,12 +108,12 @@ discard block |
||
108 | 108 | public function cleanInvalidData($Student) |
109 | 109 | { |
110 | 110 | $Student = (array) $Student; |
111 | - $exist = Examination_student::where('nsid',$Student['nsid'])->count(); |
|
111 | + $exist = Examination_student::where('nsid', $Student['nsid'])->count(); |
|
112 | 112 | |
113 | 113 | $this->uniqueUId = new UniqueUid(); |
114 | 114 | |
115 | - $nsid = ltrim(rtrim($Student['nsid'],'-'),'-'); |
|
116 | - if(!$this->uniqueUId::isValidUniqueId('DBY-898-3J2')){ |
|
115 | + $nsid = ltrim(rtrim($Student['nsid'], '-'), '-'); |
|
116 | + if (!$this->uniqueUId::isValidUniqueId('DBY-898-3J2')) { |
|
117 | 117 | } |
118 | 118 | } |
119 | 119 | } |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | $this->output = new \Symfony\Component\Console\Output\ConsoleOutput(); |
37 | 37 | $this->students = new Security_user(); |
38 | 38 | $this->uniqueUId = new UniqueUid(); |
39 | - $this->max = 0; |
|
39 | + $this->max = 0; |
|
40 | 40 | $this->child = 0; |
41 | 41 | parent::__construct(); |
42 | 42 | } |
@@ -60,19 +60,19 @@ discard block |
||
60 | 60 | public function processParallel(array $arr, $procs = 4) |
61 | 61 | { |
62 | 62 | // Break array up into $procs chunks. |
63 | - $chunks = array_chunk($arr, ceil((count($arr) / $procs))); |
|
63 | + $chunks = array_chunk($arr, ceil((count($arr)/$procs))); |
|
64 | 64 | $pid = -1; |
65 | 65 | $children = array(); |
66 | 66 | foreach ($chunks as $items) { |
67 | 67 | $pid = pcntl_fork(); |
68 | 68 | if ($pid === -1) { |
69 | 69 | die('could not fork'); |
70 | - } else if ($pid === 0) { |
|
71 | - $this->output->writeln('started processes: ' . count($children)); |
|
70 | + }else if ($pid === 0) { |
|
71 | + $this->output->writeln('started processes: '.count($children)); |
|
72 | 72 | // We are the child process. Pass a chunk of items to process. |
73 | 73 | array_walk($items, array($this, 'process')); |
74 | 74 | exit(0); |
75 | - } else { |
|
75 | + }else { |
|
76 | 76 | // We are the parent. |
77 | 77 | $children[] = $pid; |
78 | 78 | } |
@@ -104,17 +104,17 @@ discard block |
||
104 | 104 | |
105 | 105 | $newId = $this->uniqueUId::getUniqueAlphanumeric(); |
106 | 106 | $student['openemis_no'] = $newId; |
107 | - $student = $this->uniqueUserId->updateOrInsertRecord($student); |
|
107 | + $student = $this->uniqueUserId->updateOrInsertRecord($student); |
|
108 | 108 | // $this->output->writeln('New NSID generated for :' . $student['id']); |
109 | 109 | Security_user::query()->where('id', $student['id']) |
110 | 110 | ->update(['openemis_no' => $newId, 'username' => str_replace('-', '', $newId)]); |
111 | - } catch (\Exception $e) { |
|
111 | + }catch (\Exception $e) { |
|
112 | 112 | } |
113 | - } else { |
|
113 | + }else { |
|
114 | 114 | try { |
115 | 115 | // $this->output->writeln('Updating student:' . $student['id']); |
116 | 116 | $this->uniqueUserId->updateOrInsertRecord($student); |
117 | - } catch (\Exception $e) { |
|
117 | + }catch (\Exception $e) { |
|
118 | 118 | dd($e); |
119 | 119 | } |
120 | 120 | } |