moe-lk / bulk-upload

app/Imports/ExaminationStudentsImport.php

Spacing +7 added lines, -7 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'],

app/Exports/ExaminationStudentsExport.php

Spacing +4 added lines, -4 removed lines

@@ -10,12 +10,12 @@ 
 use Maatwebsite\Excel\Concerns\WithHeadings;
 use Carbon\Carbon;
 
-class ExaminationStudentsExport implements FromQuery , WithHeadings 
+class ExaminationStudentsExport implements FromQuery, WithHeadings 
 {
 
     use Exportable;
 
-    public function __construct($year,$grade)
+    public function __construct($year, $grade)
     {
         $this->year = $year;
         $this->grade = $grade;
@@ -50,7 +50,7 @@ 
     {
         return Examination_student::query()->whereNotNull('nsid')
         ->distinct('nsid')
-        ->where('year',$this->year)
-        ->where('grade',$this->grade);
+        ->where('year', $this->year)
+        ->where('grade', $this->grade);
     }
 }

app/Http/Controllers/ExaminationStudentsController.php

Spacing +36 added lines, -36 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');
         }
@@ -275,7 +275,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);
@@ -310,7 +310,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) {
@@ -318,13 +318,13 @@ 
                     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);
@@ -332,9 +332,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']);
         }
     }
 
@@ -351,20 +351,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;
@@ -414,7 +414,7 @@ 
         }
 
         if (count($matches) > 1) {
-            $highest =  $this->searchSimilarName($student, $sis_students, false);
+            $highest = $this->searchSimilarName($student, $sis_students, false);
         }
 
         return $highest;
@@ -430,18 +430,18 @@ 
     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']);
             unset($student['taking_al_exam']);
             unset($student['taking_ol_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) {
             dd($th);
             $this->output->writeln('error');
             Log::error($th);
@@ -457,9 +457,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;
             dd($th);
         }
@@ -469,13 +469,13 @@ 
     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.csv';
+        $file_path = storage_path().'/app/examination/student_data_with_nsid.csv';
         return Response::download($file_path);
     }
 }

app/Models/Institution_class_student.php

Spacing +9 added lines, -9 removed lines

@@ -58,7 +58,7 @@ 
     public static function boot()
     {
         parent::boot();
-        self::creating(function ($model) {
+        self::creating(function($model) {
             $model->id = (string) Uuid::generate(4);
             $model->created = now();
         });
@@ -71,15 +71,15 @@ 
 
     public  static function getStudentsCount($institution_class_id)
     {
-        $total_male_students = self::with(['student' => function ($query) {
+        $total_male_students = self::with(['student' => function($query) {
             $query->where('student.gender_id', '=', 1);
-        }])->whereHas('student', function ($query) {
+        }])->whereHas('student', function($query) {
             $query->where('gender_id', '=', 1);
         })->where('institution_class_id', '=', $institution_class_id)->count();
 
-        $total_female_students = self::with(['student' => function ($query) {
+        $total_female_students = self::with(['student' => function($query) {
             $query->where('student.gender_id', '=', 2);
-        }])->whereHas('student', function ($query) {
+        }])->whereHas('student', function($query) {
             $query->where('gender_id', '=', 2);
         })->where('institution_class_id', '=', $institution_class_id)->count();
 
@@ -109,8 +109,8 @@ 
             ->where('student_id', $student['student_id'])
             ->join('institution_classes', 'institution_class_students.institution_class_id', '=', 'institution_classes.id')
             ->where('institution_class_students.student_id', $student['student_id'])
-            ->where('institution_class_students.academic_period_id',$student['academic_period_id'])
-            ->where('institution_class_students.institution_id',$student['institution_id'])
+            ->where('institution_class_students.academic_period_id', $student['academic_period_id'])
+            ->where('institution_class_students.institution_id', $student['institution_id'])
             ->whereNull('institution_class_students.deleted_at')
             ->get()->first();
     }
@@ -135,12 +135,12 @@ 
                 'student_status_id' => 1,
                 'created_user_id' => 1
             ]);
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             Log::error($th);
         }
     }
 
-    public static function createOrUpdate($studentId,$params,$file){
+    public static function createOrUpdate($studentId, $params, $file) {
        return  self::create([
             'student_id' => $studentId,
             'institution_class_id' => $params['institution_class']->id,