moe-lk / bulk-upload

app/Http/Controllers/ExaminationStudentsController.php

Spacing +35 added lines, -35 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();
     }
@@ -72,10 +72,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.');
             }
         }
@@ -97,7 +97,7 @@ 
             $import->import($excelFile, 'local', \Maatwebsite\Excel\Excel::CSV);
             if ($import->failures()->count() > 0) {
                 $errors = $import->failures();
-                $columns =  [
+                $columns = [
                     'remarks',
                     'st_no',
                     'stu_no',
@@ -118,10 +118,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) {
         }
     }
 
@@ -144,7 +144,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();
@@ -154,12 +154,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']);
                 }
             }
         }
@@ -175,7 +175,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)
@@ -187,7 +187,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;
@@ -200,7 +200,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;
@@ -210,7 +210,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;
@@ -221,7 +221,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)
@@ -230,7 +230,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');
         }
@@ -276,13 +276,13 @@ 
      */
     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);
 
         // if the first match missing do complete insertion
-        $institution = Institution::where('code', '=', (int)$student['schoolid'])->first();
+        $institution = Institution::where('code', '=', (int) $student['schoolid'])->first();
 
         if (!is_null($institution)) {
 
@@ -309,7 +309,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) {
@@ -317,13 +317,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);
@@ -331,9 +331,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']);
         }
     }
 
@@ -350,18 +350,18 @@ 
         /**
          */
         $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'])
             ->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;
@@ -411,7 +411,7 @@ 
         }
 
         if (count($matches) > 1) {
-            $highest =  $this->searchSimilarName($student, $sis_students, false);
+            $highest = $this->searchSimilarName($student, $sis_students, false);
         }
 
         return $highest;
@@ -427,18 +427,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);
@@ -454,9 +454,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);
         }
@@ -466,13 +466,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/Console/Commands/ExaminationStudentSeed.php

Spacing +1 added lines, -1 removed lines

@@ -41,7 +41,7 @@
         $output = new \Symfony\Component\Console\Output\ConsoleOutput();
         $output->writeln('###########################################------Inserting file records------###########################################');
        
-        ExaminationStudentsController::callOnClick($this->argument('year'),$this->argument('grade'));
+        ExaminationStudentsController::callOnClick($this->argument('year'), $this->argument('grade'));
         $output->writeln('###########################################------Finished inserting file records------###########################################');
     }
 }

app/Console/Commands/ExaminationsUpdateCensusNo.php

Spacing +2 added lines, -2 removed lines

@@ -42,9 +42,9 @@
         $output = new \Symfony\Component\Console\Output\ConsoleOutput();
         $output->writeln('###########################################------Inserting file records------###########################################');
         $this->examinationController = new ExaminationStudentsController(2019, 'G4');
-        $students =  Examination_student::all()->toArray();
+        $students = Examination_student::all()->toArray();
         $func = $this->examinationController;
-        array_walk($students,array($func,'updateCensusNo'));
+        array_walk($students, array($func, 'updateCensusNo'));
 
                 
     }

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);
     }
 }