moe-lk / bulk-upload

app/Http/Controllers/ExaminationStudentsController.php

Indentation +4 added lines, -4 removed lines

@@ -192,7 +192,7 @@ 
                 break;
             case 'empty';
                 $students = Examination_student::
-                     whereNull('nsid')
+                        whereNull('nsid')
                     ->where('grade', $this->grade)
                     ->where('year', $this->year)
                     ->offset($offset)
@@ -323,13 +323,13 @@ 
                 $sis_student['student_id'] =  $student['id' ];
 
                 $student = $this->setIsTakingExam($student);
-                 if (count($institutionClass) == 1) {
+                    if (count($institutionClass) == 1) {
                     $admissionInfo['instituion_class'] = $institutionClass[0];
-                     Institution_student::createExaminationData($student, $admissionInfo);
+                        Institution_student::createExaminationData($student, $admissionInfo);
                     Institution_student_admission::createExaminationData($student, $admissionInfo);
                     Institution_class_student::createExaminationData($student, $admissionInfo);
                 } else {
-                     Institution_student_admission::createExaminationData($student, $admissionInfo);
+                        Institution_student_admission::createExaminationData($student, $admissionInfo);
                     Institution_student::createExaminationData($student, $admissionInfo);
                 }
                 

Spacing +39 added lines, -39 removed lines

@@ -30,7 +30,7 @@ 
         $this->grade = $grade;
         $this->student = new Security_user();
         $this->examination_student = new Examination_student();
-        $this->academic_period =  Academic_period::where('code', '=', $this->year)->first();
+        $this->academic_period = Academic_period::where('code', '=', $this->year)->first();
         $this->education_grade = Education_grade::where('code', '=', $this->grade)->first();
         $this->output = new \Symfony\Component\Console\Output\ConsoleOutput();
     }
@@ -71,10 +71,10 @@ 
                     );
                     Session::flash('message', 'File upload successfully!');
                     // Redirect to index
-                } else {
+                }else {
                     Session::flash('message', 'File too large. File must be less than 20MB.');
                 }
-            } else {
+            }else {
                 Session::flash('message', 'Invalid File Extension.');
             }
         }
@@ -96,7 +96,7 @@ 
             $import->import($excelFile, 'local', \Maatwebsite\Excel\Excel::CSV);
             if ($import->failures()->count() > 0) {
                 $errors = $import->failures();
-                $columns =  [
+                $columns = [
                     'remarks',
                     'st_no',
                     'stu_no',
@@ -117,10 +117,10 @@ 
                 Storage::put($file, implode(',', $columns));
 
                 foreach ($errors as $error) {
-                    Storage::append($file, implode(':', $error->errors()) . ',' . implode(',', $error->values()));
+                    Storage::append($file, implode(':', $error->errors()).','.implode(',', $error->values()));
                 }
             }
-        } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
+        }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
         }
     }
 
@@ -143,7 +143,7 @@ 
                 $Institution = $Institution[0];
                 if (count($student) == 1) {
                     $student = $student[0];
-                    if (((int)$Institution['id']) !=  ((int)$student['institution_id'])) {
+                    if (((int) $Institution['id']) != ((int) $student['institution_id'])) {
                         $studentClass = Institution_class_student::where('student_id', $student['student_id'])
                             ->first();
                         Institution_class_student::where('student_id', $student['student_id'])->delete();
@@ -153,12 +153,12 @@ 
                         if (!is_null($studentClass)) {
                             $class->updateClassCount($studentClass->toArray());
                         }
-                        $output->writeln('updated student info:' . $data['nsid']);
+                        $output->writeln('updated student info:'.$data['nsid']);
                     }
-                } else {
+                }else {
                     Institution_student::where('institution_id', '<>', $Institution['id'])->where('student_id', $student[0]['student_id'])
                         ->delete();
-                    $output->writeln('updated student info:' . $Institution['id'] . '==' . $Institution['id']);
+                    $output->writeln('updated student info:'.$Institution['id'].'=='.$Institution['id']);
                 }
             }
         }
@@ -174,7 +174,7 @@ 
         $students = [];
         switch ($mode) {
             case 'duplicate':
-                $students =  DB::table('examination_students as es')
+                $students = DB::table('examination_students as es')
                     ->select(DB::raw('count(*) as total'), 'e2.*')
                     ->where('grade', $this->grade)
                     ->where('year', $this->year)
@@ -186,7 +186,7 @@ 
                     ->limit($limit)
                     ->get()->toArray();
                 $students = (array) json_decode(json_encode($students));
-                $this->output->writeln(count($students) . 'students remaining duplicate');
+                $this->output->writeln(count($students).'students remaining duplicate');
                 array_walk($students, array($this, 'clone'));
                 $this->output->writeln('All are generated');
                 break;
@@ -199,7 +199,7 @@ 
                     ->limit($limit)
                     ->get()->toArray();
                 $students = (array) json_decode(json_encode($students));
-                $this->output->writeln(count($students) . 'students remaining empty');
+                $this->output->writeln(count($students).'students remaining empty');
                 array_walk($students, array($this, 'clone'));
                 $this->output->writeln('All are generated');
                 break;
@@ -209,7 +209,7 @@ 
                     ->where('year', $this->year)
                     ->get()->toArray();
                 $students = (array) json_decode(json_encode($students));
-                $this->output->writeln(count($students) . 'students remaining with wrong NSID');
+                $this->output->writeln(count($students).'students remaining with wrong NSID');
                 array_walk($students, array($this, 'clone'));
                 $this->output->writeln('All are generated');
                 break;
@@ -220,7 +220,7 @@ 
                     ->count();
                 $all = Examination_student::select('nsid')
                     ->count();
-                $this->output->writeln($all . 'Total Unique nsid are: ' . $count);
+                $this->output->writeln($all.'Total Unique nsid are: '.$count);
                 break;
             default:
                 $students = Examination_student::offset($offset)
@@ -229,7 +229,7 @@ 
                     ->limit($limit)
                     ->get()->toArray();
                 $students = (array) json_decode(json_encode($students));
-                $this->output->writeln(count($students) . 'students remaining empty');
+                $this->output->writeln(count($students).'students remaining empty');
                 array_walk($students, array($this, 'clone'));
                 $this->output->writeln('All are generated');
         }
@@ -277,7 +277,7 @@ 
      */
     public function clone($student)
     {
-        $student = (array)json_decode(json_encode($student));
+        $student = (array) json_decode(json_encode($student));
         //get student matching with same dob and gender
 
         $matchedStudent = $this->getMatchingStudents($student);
@@ -296,13 +296,13 @@ 
                     'academic_period_id' => $this->academic_period->id
                 ]
             )
-            ->where( 'education_grade_id','in', [$this->student->education_garde_id])
+            ->where('education_grade_id', 'in', [$this->student->education_garde_id])
             ->join('institution_class_grades', 'institution_classes.id', 'institution_class_grades.institution_class_id')->get()->toArray();
 
 
-            if(!is_null($this->student->education_garde_id)){
+            if (!is_null($this->student->education_garde_id)) {
                 $this->education_grade = Education_grade::where('id', '=', $this->student->education_garde_id)->first();
-            }else{
+            }else {
                 $this->student->education_garde_id = $this->education_grade->id;
             }
             
@@ -320,7 +320,7 @@ 
 
                 //TODO implement insert student to admission table
                 $student['id'] = $sis_student['id'];
-                $sis_student['student_id'] =  $student['id' ];
+                $sis_student['student_id'] = $student['id'];
 
                 $student = $this->setIsTakingExam($student);
                  if (count($institutionClass) == 1) {
@@ -328,14 +328,14 @@ 
                      Institution_student::createExaminationData($student, $admissionInfo);
                     Institution_student_admission::createExaminationData($student, $admissionInfo);
                     Institution_class_student::createExaminationData($student, $admissionInfo);
-                } else {
+                }else {
                      Institution_student_admission::createExaminationData($student, $admissionInfo);
                     Institution_student::createExaminationData($student, $admissionInfo);
                 }
                 
                 $this->updateStudentId($student, $sis_student);
                 // update the matched student's data    
-            } else {
+            }else {
                 $student = $this->setIsTakingExam($student);
                 $studentData = $this->student->updateExaminationStudent($student, $matchedStudent);
                 $matchedStudent = array_merge((array) $student, $matchedStudent);
@@ -343,9 +343,9 @@ 
                 Institution_student::updateExaminationData($studentData, $admissionInfo);
                 $this->updateStudentId($student, $studentData);
             }
-        } else {
+        }else {
 
-            $this->output->writeln('Student ' . $student['st_no'] . ' not imorted' . $student['f_name']);
+            $this->output->writeln('Student '.$student['st_no'].' not imorted'.$student['f_name']);
         }
     }
 
@@ -362,20 +362,20 @@ 
         /**
          */
         $sis_student = $this->student->getMatches($student);
-        $doe_students =  Examination_student::where('gender', $student['gender'])
+        $doe_students = Examination_student::where('gender', $student['gender'])
             ->where('b_date', $student['b_date'])
             ->where('schoolid', $student['schoolid'])
-            ->where('year',$this->year)
-            ->where('grade',$this->grade)
+            ->where('year', $this->year)
+            ->where('grade', $this->grade)
             ->count();
         $count = $this->student->getStudentCount($student);
 
         $studentData = [];
-        $sis_users  = (array) json_decode(json_encode($sis_student), true);
+        $sis_users = (array) json_decode(json_encode($sis_student), true);
         // if the same gender same DOE has more than one 
         if (($doe_students > 1) || ($count > 1)) {
             $studentData = $this->searchSimilarName($student, $sis_users, false);
-        } else {
+        }else {
             $studentData = $this->searchSimilarName($student, $sis_users);
         }
         return $studentData;
@@ -425,7 +425,7 @@ 
         }
 
         if (count($matches) > 1) {
-            $highest =  $this->searchSimilarName($student, $sis_students, false);
+            $highest = $this->searchSimilarName($student, $sis_students, false);
         }
 
         return $highest;
@@ -441,7 +441,7 @@ 
     public function updateStudentId($student, $sis_student)
     {
         try {
-            $student['nsid'] =  $sis_student['openemis_no'];
+            $student['nsid'] = $sis_student['openemis_no'];
             // add new NSID to the examinations data set
             unset($student['id']);
             unset($student['taking_g5_exam']);
@@ -449,11 +449,11 @@ 
             unset($student['taking_ol_exam']);
             unset($student['taking_git_exam']);
             unset($student['total']);
-            $students['updated_at'] =  now();
+            $students['updated_at'] = now();
             $this->examination_student->where('st_no', $student['st_no'])->update($student);
             unset($student['st_no']);
-            $this->output->writeln('Updated  to NSID' . $sis_student['openemis_no']);
-        } catch (\Exception $th) {
+            $this->output->writeln('Updated  to NSID'.$sis_student['openemis_no']);
+        }catch (\Exception $th) {
             $this->output->writeln('error');
             Log::error($th);
         }
@@ -468,9 +468,9 @@ 
     {
         $adminUser = Security_user::where('username', 'admin')->first();
         try {
-            (new ExaminationStudentsExport($this->year,$this->grade))->store('examination/student_data_with_nsid.' . time() . '.csv');
+            (new ExaminationStudentsExport($this->year, $this->grade))->store('examination/student_data_with_nsid.'.time().'.csv');
             (new ExportReady($adminUser));
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             //throw $th;
         }
         return back()->withSuccess('Export started!');
@@ -479,14 +479,14 @@ 
     public function downloadErrors()
     {
 
-        $file_path = storage_path() . '/app/examination/errors.csv';
+        $file_path = storage_path().'/app/examination/errors.csv';
         return Response::download($file_path);
     }
 
     public function downloadProcessedFile()
     {
 
-        $file_path = storage_path() . '/app/examination/student_data_with_nsid.1628499466.csv'; //hard coded file name
+        $file_path = storage_path().'/app/examination/student_data_with_nsid.1628499466.csv'; //hard coded file name
         return Response::download($file_path);
     }
 }

Braces +1 added lines, -1 removed lines

@@ -302,7 +302,7 @@
 
             if(!is_null($this->student->education_garde_id)){
                 $this->education_grade = Education_grade::where('id', '=', $this->student->education_garde_id)->first();
-            }else{
+            } else{
                 $this->student->education_garde_id = $this->education_grade->id;
             }
             

app/Models/Security_user.php

Spacing +24 added lines, -24 removed lines

@@ -204,7 +204,7 @@ 
             $studentData['id'] = $id;
             $this->uniqueUserId->updateOrInsertRecord($studentData);
             return $studentData;
-        } catch (\Exception $th) {
+        }catch (\Exception $th) {
             Log::error($th->getMessage());
             // in case of duplication of the Unique ID this will recursive till success.
             $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
@@ -225,7 +225,7 @@ 
         $this->uniqueUserId = new Unique_user_id();
         $this->uniqueUId = new UniqueUid();
         // regenerate unique id if it's not available
-        $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ?  $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();
+        $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ? $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();
 
         $studentData = [
             'username' => str_replace('-', '', $uniqueId),
@@ -243,11 +243,11 @@ 
             $studentData['id'] = $sis_student['student_id'];
             $this->uniqueUserId->updateOrInsertRecord($studentData);
             return $studentData;
-        } catch (\Exception $th) {
+        }catch (\Exception $th) {
             Log::error($th);
             // in case of duplication of the Unique ID this will recursive.
             $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
-            $this->updateExaminationStudent($student,$sis_student);
+            $this->updateExaminationStudent($student, $sis_student);
         }
     }
 
@@ -255,9 +255,9 @@ 
     {
         try {
             $uniqueUid = new UniqueUid();
-            $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first();
-            $nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first();
-            $identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first();
+            $BirthArea = Area_administrative::where('name', 'like', '%'.$row['birth_registrar_office_as_in_birth_certificate'].'%')->first();
+            $nationalityId = Nationality::where('name', 'like', '%'.$row['nationality'].'%')->first();
+            $identityType = Identity_type::where('national_code', 'like', '%'.$row['identity_type'].'%')->first();
             
             $date = $row['date_of_birth_yyyy_mm_dd'];
             $identityType = $identityType !== null ? $identityType->id : null;
@@ -289,7 +289,7 @@ 
                     ]);
                 case 'update':
                     if (!is_null($row['student_id'])) {
-                        $studentInfo =  Security_user::where('openemis_no',trim($row['student_id']))->first();
+                        $studentInfo = Security_user::where('openemis_no', trim($row['student_id']))->first();
                         self::query()->where('openemis_no', $row['student_id'])
                             ->update([
                                 'first_name' => $row['full_name'] ? $row['full_name'] : $studentInfo['first_name'], // here we save full name in the column of first name. re reduce breaks of the system.
@@ -310,7 +310,7 @@ 
                     }
                     break;
             }
-        } catch (\Exception $e) {
+        }catch (\Exception $e) {
             dd($e);
         }
     }
@@ -319,48 +319,48 @@ 
     {
         try {
             $uniqueUid = new UniqueUid();
-            $AddressArea = Area_administrative::where('name', 'like', '%' . $row[$prefix . 's_address_area'] . '%')->first();
-            $nationalityId = Nationality::where('name', 'like', '%' . $row[$prefix . 's_nationality'] . '%')->first();
-            $identityType = Identity_type::where('national_code', 'like', '%' . $row[$prefix . 's_identity_type'] . '%')->first();
+            $AddressArea = Area_administrative::where('name', 'like', '%'.$row[$prefix.'s_address_area'].'%')->first();
+            $nationalityId = Nationality::where('name', 'like', '%'.$row[$prefix.'s_nationality'].'%')->first();
+            $identityType = Identity_type::where('national_code', 'like', '%'.$row[$prefix.'s_identity_type'].'%')->first();
             $openemisNo = $uniqueUid::getUniqueAlphanumeric();
 
             $identityType = ($identityType !== null) ? $identityType->id : null;
             $nationalityId = $nationalityId !== null ? $nationalityId->id : null;
 
             $guardian = null;
-            if (!empty($row[$prefix . 's_identity_number'])) {
+            if (!empty($row[$prefix.'s_identity_number'])) {
                 $guardian = Security_user::where('identity_type_id', '=', $nationalityId)
-                    ->where('identity_number', '=', $row[$prefix . 's_identity_number'])->first();
+                    ->where('identity_number', '=', $row[$prefix.'s_identity_number'])->first();
             }
 
             if (is_null($guardian)) {
                 $guardian = self::create([
                     'username' => str_replace('-', '', $openemisNo),
                     'openemis_no' => $openemisNo,
-                    'first_name' => $row[$prefix . 's_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
-                    'last_name' => genNameWithInitials($row[$prefix . 's_full_name']),
+                    'first_name' => $row[$prefix.'s_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
+                    'last_name' => genNameWithInitials($row[$prefix.'s_full_name']),
                     'gender_id' => 1,
-                    'date_of_birth' => $row[$prefix . 's_date_of_birth_yyyy_mm_dd'],
-                    'address' => $row[$prefix . 's_address'],
+                    'date_of_birth' => $row[$prefix.'s_date_of_birth_yyyy_mm_dd'],
+                    'address' => $row[$prefix.'s_address'],
                     'address_area_id' => $AddressArea ? $AddressArea->id : null,
                     'nationality_id' => $nationalityId,
                     'identity_type_id' => $identityType,
-                    'identity_number' => $row[$prefix . 's_identity_number'],
+                    'identity_number' => $row[$prefix.'s_identity_number'],
                     'is_guardian' => 1,
                     'created_user_id' => $file['security_user_id']
                 ]);
 
 
                 $guardian['guardian_relation_id'] = 1;
-                if (array_key_exists($prefix . 's_phone', $row)) {
-                    $father['contact'] = $row[$prefix . 's_phone'];
+                if (array_key_exists($prefix.'s_phone', $row)) {
+                    $father['contact'] = $row[$prefix.'s_phone'];
                     User_contact::createOrUpdate($father, $file['security_user_id']);
                 }
-            } else {
-                Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null,]);
+            }else {
+                Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null, ]);
             }
             return $guardian;
-        } catch (\Exception $e) {
+        }catch (\Exception $e) {
             Log::error($e->getMessage(), [$e]);
         }
     }

app/Imports/ExaminationStudentsImport.php

Indentation +3 added lines, -3 removed lines

@@ -83,7 +83,7 @@ 
      */
     public function model(array $row)
     {
-       try {
+        try {
         $insertData = array(
             'st_no' => $row['st_no'],
             'stu_no' => $row['stu_no'],
@@ -102,9 +102,9 @@ 
             "sp_center" => $row['sp_center']
         );
         Examination_student::insertData($insertData);
-       } catch (\Throwable $th) {
+        } catch (\Throwable $th) {
         //    dd($row);
-       }
+        }
     }
 
     public function rules(): array

Spacing +8 added lines, -8 removed lines

@@ -18,11 +18,11 @@ 
 use Maatwebsite\Excel\Concerns\WithBatchInserts;
 use Maatwebsite\Excel\Concerns\WithChunkReading;
 
-class ExaminationStudentsImport implements ToModel, WithStartRow, WithHeadingRow, WithChunkReading, WithBatchInserts , WithValidation ,WithMapping, SkipsOnFailure, SkipsOnError
+class ExaminationStudentsImport implements ToModel, WithStartRow, WithHeadingRow, WithChunkReading, WithBatchInserts, WithValidation, WithMapping, SkipsOnFailure, SkipsOnError
 {
-    use Importable , SkipsFailures, SkipsErrors;
+    use Importable, SkipsFailures, SkipsErrors;
 
-    public function __construct($year,$grade)
+    public function __construct($year, $grade)
     {
         $this->year = $year;
         $this->grade = $grade;
@@ -62,14 +62,14 @@ 
 
     private function transformDateTime(string $value, string $format = 'm/d/Y')
     {
-        try{
+        try {
             $date = date_create_from_format('m/d/Y', $value);
-            if(gettype($date)=='boolean'){
+            if (gettype($date) == 'boolean') {
                 $date = date_create_from_format('Y-m-d', $value);
             }
             $date = date_format($date, 'Y-m-d');
             return  $date;
-        }catch(\Exception $e){
+        }catch (\Exception $e) {
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
             $failure = new Failure(2, 'remark', [0 => 'The given date is wrong']);
             $failures = [0 => $failure];
@@ -91,7 +91,7 @@ 
             "medium" => $row['medium'],
             "gender" => $row['gender'],
             "b_date" =>  $row['b_date'],
-            "a_income" => $row['a_income'] ? $row['a_income'] : 0 ,
+            "a_income" => $row['a_income'] ? $row['a_income'] : 0,
             "grade" => $this->grade,
             'year' => $this->year,
             "schoolid" => $row['schoolid'],
@@ -102,7 +102,7 @@ 
             "sp_center" => $row['sp_center']
         );
         Examination_student::insertData($insertData);
-       } catch (\Throwable $th) {
+       }catch (\Throwable $th) {
         //    dd($row);
        }
     }

app/Console/Commands/RollbackStudentFromInstitutes.php

Spacing +4 added lines, -4 removed lines

@@ -65,21 +65,21 @@
             */
             if (!empty($institution_grades)) {
 
-                $this->info('Fetched ' . count($institution_grades) . ' records');
+                $this->info('Fetched '.count($institution_grades).' records');
 
                 foreach ($institution_grades as $institute_grade) {
                     if ($institute_grade->promoted == "2019") {
                         $this->info('Promoted year have already set to 2019');
-                    } else {
+                    }else {
                         $this->info('Updating record =======================================');
                         DB::update("update institution_grades set promoted ='2019' where institution_id = ?", [$this->argument('institution')]);
                         $this->info('Record updated ========================================');
                     }
                 }
-            } else {
+            }else {
                 $this->info('No results!');
             }
-        } catch (\Exception $e) {
+        }catch (\Exception $e) {
             return $e->getMessage();
         }
     }

app/Console/Commands/RunAddStudentsToInstitutions.php

Indentation +26 added lines, -26 removed lines

@@ -84,32 +84,32 @@
             try{
                 $output->writeln($approvedstudent['student_id']."Updated");
                 Institution_student::create([
-                   'student_status_id' => 1,
-                   'student_id' => $approvedstudent['student_id'],
-                   'education_grade_id' => $approvedstudent['education_grade_id'],
-                   'academic_period_id' => $approvedstudent['academic_period_id'],
-                   'start_date' => $approvedstudent['start_date'],
-                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['start_date'])->year , // $approvedstudent['start_date']->format('Y'),
-                   'end_date' => $approvedstudent['end_date'],
-                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['end_date'])->year , //$approvedstudent['end_date']->format('Y'),
-                   'institution_id' => $approvedstudent['institution_id'],
-                   'admission_id' => $approvedstudent['admission_id'],
-                   'created_user_id' => $approvedstudent['created_user_id'],
-               ]);
-               if(!is_null($approvedstudent['institution_class_id'])){
-                   Institution_class_student::create([
-                       'student_id' => $approvedstudent['student_id'],
-                       'institution_class_id' => $approvedstudent['institution_class_id'],
-                       'education_grade_id' =>  $approvedstudent['education_grade_id'],
-                       'academic_period_id' => $approvedstudent['academic_period_id'],
-                       'institution_id' =>$approvedstudent['institution_id'],
-                       'student_status_id' => 1,
-                       'created_user_id' => $approvedstudent['created_user_id'],
-                   ]);
-               }
-           }catch (\Exception $e){
-              echo $e->getMessage();
-           }
+                    'student_status_id' => 1,
+                    'student_id' => $approvedstudent['student_id'],
+                    'education_grade_id' => $approvedstudent['education_grade_id'],
+                    'academic_period_id' => $approvedstudent['academic_period_id'],
+                    'start_date' => $approvedstudent['start_date'],
+                    'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['start_date'])->year , // $approvedstudent['start_date']->format('Y'),
+                    'end_date' => $approvedstudent['end_date'],
+                    'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['end_date'])->year , //$approvedstudent['end_date']->format('Y'),
+                    'institution_id' => $approvedstudent['institution_id'],
+                    'admission_id' => $approvedstudent['admission_id'],
+                    'created_user_id' => $approvedstudent['created_user_id'],
+                ]);
+                if(!is_null($approvedstudent['institution_class_id'])){
+                    Institution_class_student::create([
+                        'student_id' => $approvedstudent['student_id'],
+                        'institution_class_id' => $approvedstudent['institution_class_id'],
+                        'education_grade_id' =>  $approvedstudent['education_grade_id'],
+                        'academic_period_id' => $approvedstudent['academic_period_id'],
+                        'institution_id' =>$approvedstudent['institution_id'],
+                        'student_status_id' => 1,
+                        'created_user_id' => $approvedstudent['created_user_id'],
+                    ]);
+                }
+            }catch (\Exception $e){
+                echo $e->getMessage();
+            }
         }
         $output->writeln('
         ####################################################

Spacing +14 added lines, -14 removed lines

@@ -50,14 +50,14 @@ 
             'id' => $this->argument('institution')
         ])->first();
 
-        if(!is_null($institution)){
+        if (!is_null($institution)) {
             DB::enableQueryLog();
             try {
-                $this->info('adding missing students to the institution ' . $institution->name);
+                $this->info('adding missing students to the institution '.$institution->name);
                 $approvedstudent = Institution_student_admission::select('institution_student_admission.*')
                                     ->leftJoin('institution_students', 'institution_student_admission.student_id', '=', 'institution_students.student_id')
-                                    ->whereIn('status_id',[121,122,123,124])
-                                    ->where('institution_student_admission.institution_id',$institution->id)->get()->toArray();
+                                    ->whereIn('status_id', [121, 122, 123, 124])
+                                    ->where('institution_student_admission.institution_id', $institution->id)->get()->toArray();
     
                 $approvedstudent = array_chunk($approvedstudent, 50);
                 
@@ -69,19 +69,19 @@ 
         }
     }
 
-    protected function addStudents($approvedstudent){
-        array_walk($approvedstudent,array($this,'addStudent')); 
+    protected function addStudents($approvedstudent) {
+        array_walk($approvedstudent, array($this, 'addStudent')); 
     }
 
-    protected function addStudent($approvedstudent){
+    protected function addStudent($approvedstudent) {
         $output = new \Symfony\Component\Console\Output\ConsoleOutput();
         Log::info($approvedstudent);
 //         sleep(1);
-        if((Institution_student::isDuplicated($approvedstudent) == 0)){
+        if ((Institution_student::isDuplicated($approvedstudent) == 0)) {
             dd($approvedstudent);
             $this->count += 1;
-            $this->student = $approvedstudent ;
-            try{
+            $this->student = $approvedstudent;
+            try {
                 $output->writeln($approvedstudent['student_id']."Updated");
                 Institution_student::create([
                    'student_status_id' => 1,
@@ -89,14 +89,14 @@ 
                    'education_grade_id' => $approvedstudent['education_grade_id'],
                    'academic_period_id' => $approvedstudent['academic_period_id'],
                    'start_date' => $approvedstudent['start_date'],
-                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['start_date'])->year , // $approvedstudent['start_date']->format('Y'),
+                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['start_date'])->year, // $approvedstudent['start_date']->format('Y'),
                    'end_date' => $approvedstudent['end_date'],
-                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['end_date'])->year , //$approvedstudent['end_date']->format('Y'),
+                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $approvedstudent['end_date'])->year, //$approvedstudent['end_date']->format('Y'),
                    'institution_id' => $approvedstudent['institution_id'],
                    'admission_id' => $approvedstudent['admission_id'],
                    'created_user_id' => $approvedstudent['created_user_id'],
                ]);
-               if(!is_null($approvedstudent['institution_class_id'])){
+               if (!is_null($approvedstudent['institution_class_id'])) {
                    Institution_class_student::create([
                        'student_id' => $approvedstudent['student_id'],
                        'institution_class_id' => $approvedstudent['institution_class_id'],
@@ -107,7 +107,7 @@ 
                        'created_user_id' => $approvedstudent['created_user_id'],
                    ]);
                }
-           }catch (\Exception $e){
+           }catch (\Exception $e) {
               echo $e->getMessage();
            }
         }

Braces +2 added lines, -2 removed lines

@@ -63,7 +63,7 @@ 
                 
                 array_walk($approvedstudent, array($this, 'addStudents'));
 
-            }catch (\Exception $e) {
+            } catch (\Exception $e) {
                 Log::error($e);
             }       
         }
@@ -107,7 +107,7 @@ 
                        'created_user_id' => $approvedstudent['created_user_id'],
                    ]);
                }
-           }catch (\Exception $e){
+           } catch (\Exception $e){
               echo $e->getMessage();
            }
         }