moe-lk / bulk-upload

app/Console/Commands/CallPromotionCommand.php

Spacing +3 added lines, -3 removed lines

@@ -41,10 +41,10 @@
     {
         $year = $this->argument('year');
         $institutions = $this->instituion_grade->getInstitutionGradeList($year);
-        array_walk($institutions,array($this,'callPromotion'),$year);
+        array_walk($institutions, array($this, 'callPromotion'), $year);
     }
 
-    protected function callPromotion($institution,$count,$year){
-        $this->call('promote:students',['year' => $year,'institution' => $institution['code']]);
+    protected function callPromotion($institution, $count, $year) {
+        $this->call('promote:students', ['year' => $year, 'institution' => $institution['code']]);
     }
 }

app/Console/Commands/PromoteStudents.php

Spacing +2 added lines, -2 removed lines

@@ -61,7 +61,7 @@
     {
         $year = $this->argument('year');
         $institution = $this->argument('institution');
-        $institutionGrade = $this->instituion_grade->getInstitutionGradeToPromoted($year,$institution);
-        (new BulkPromotion())->callback($institutionGrade,$year);
+        $institutionGrade = $this->instituion_grade->getInstitutionGradeToPromoted($year, $institution);
+        (new BulkPromotion())->callback($institutionGrade, $year);
     }
 }

app/Console/Commands/UpdateStudentsCount.php

Indentation +5 added lines, -5 removed lines

@@ -27,11 +27,11 @@
      */
     protected $description = 'Update the students count male/female';
 
-      /**
-     * Create a new command instance.
-     *
-     * @return void
-     */
+        /**
+         * Create a new command instance.
+         *
+         * @return void
+         */
     public function __construct()
     {
         parent::__construct();

Spacing +22 added lines, -22 removed lines

@@ -48,36 +48,36 @@ 
     public function handle()
     {
         $this->output->writeln('#########################################');
-        if($this->argument('entity') == 'class'){
+        if ($this->argument('entity') == 'class') {
             $classes = Institution_class::get()->toArray();
-            $func = array($this,'updateCount');
-            array_walk($subjects,array($this,'process'));
-            $this->output->writeln('start updating:'. count($classes));
-        }elseif($this->argument('entity') == 'subject'){
+            $func = array($this, 'updateCount');
+            array_walk($subjects, array($this, 'process'));
+            $this->output->writeln('start updating:'.count($classes));
+        }elseif ($this->argument('entity') == 'subject') {
             $subjects = Institution_subject::get()->toArray(); 
-            $subjects = array_chunk($subjects,10000);
-            $this->output->writeln('start updating:'. count($subjects));
-            array_walk($subjects,array($this,'process'));
+            $subjects = array_chunk($subjects, 10000);
+            $this->output->writeln('start updating:'.count($subjects));
+            array_walk($subjects, array($this, 'process'));
             $this->output->writeln('#########################################');
         }
        
     }
 
-    public function process($data){
-        if($this->argument('entity') == 'class'){
-            $func = array($this,'updateCount');
-            processParallel($func,$data,$this->argument('max'));
-            $this->output->writeln('start updating calss count:'. count($data));
-        }elseif($this->argument('entity') == 'subject'){
-            $this->output->writeln('start updating subject count:'. count($data));
-            $func_subject = array($this,'updateSubjectCount');
-            processParallel($func_subject,$data,$this->argument('max'));
+    public function process($data) {
+        if ($this->argument('entity') == 'class') {
+            $func = array($this, 'updateCount');
+            processParallel($func, $data, $this->argument('max'));
+            $this->output->writeln('start updating calss count:'.count($data));
+        }elseif ($this->argument('entity') == 'subject') {
+            $this->output->writeln('start updating subject count:'.count($data));
+            $func_subject = array($this, 'updateSubjectCount');
+            processParallel($func_subject, $data, $this->argument('max'));
         }
     }
 
-    public function updateCount($class){
-        $this->output->writeln('updating class:'. $class['id']);
-        $totalStudents =  Institution_class_student::getStudentsCount($class['id']);
+    public function updateCount($class) {
+        $this->output->writeln('updating class:'.$class['id']);
+        $totalStudents = Institution_class_student::getStudentsCount($class['id']);
         Institution_class::where('id', '=', $class['id'])
         ->update([
             'total_male_students' => $totalStudents['total_male_students'],
@@ -85,8 +85,8 @@ 
         ]);
     }
 
-    public function updateSubjectCount($subject){
-        $this->output->writeln('updating subject:'. $subject['id']);
+    public function updateSubjectCount($subject) {
+        $this->output->writeln('updating subject:'.$subject['id']);
         $totalStudents = Institution_subject_student::getStudentsCount($subject['id']);
         Institution_subject::where(['id' => $subject['id']])
             ->update([

Braces +2 added lines, -2 removed lines

@@ -53,7 +53,7 @@ 
             $func = array($this,'updateCount');
             array_walk($subjects,array($this,'process'));
             $this->output->writeln('start updating:'. count($classes));
-        }elseif($this->argument('entity') == 'subject'){
+        } elseif($this->argument('entity') == 'subject'){
             $subjects = Institution_subject::get()->toArray(); 
             $subjects = array_chunk($subjects,10000);
             $this->output->writeln('start updating:'. count($subjects));
@@ -68,7 +68,7 @@ 
             $func = array($this,'updateCount');
             processParallel($func,$data,$this->argument('max'));
             $this->output->writeln('start updating calss count:'. count($data));
-        }elseif($this->argument('entity') == 'subject'){
+        } elseif($this->argument('entity') == 'subject'){
             $this->output->writeln('start updating subject count:'. count($data));
             $func_subject = array($this,'updateSubjectCount');
             processParallel($func_subject,$data,$this->argument('max'));

app/Console/Commands/UpdateViews.php

Indentation +2 added lines, -2 removed lines

@@ -39,7 +39,7 @@
      */
     public function handle()
     {
-       $views = new DashboardViewsController();
-       $views->callback();
+        $views = new DashboardViewsController();
+        $views->callback();
     }
 }

app/Console/Commands/cleanConfig.php

Spacing +2 added lines, -2 removed lines

@@ -52,9 +52,9 @@
             'academic_period' => $academicPeriod
         ];
 
-        if($year <= 2019){
+        if ($year <= 2019) {
             die('Academic Year 2019 or earlier can`t be deleted');
-        }else{
+        }else {
             $this->clone->cleanConfig($params);
         }
     }

Braces +1 added lines, -1 removed lines

@@ -54,7 +54,7 @@
 
         if($year <= 2019){
             die('Academic Year 2019 or earlier can`t be deleted');
-        }else{
+        } else{
             $this->clone->cleanConfig($params);
         }
     }

app/Models/Security_user.php

Indentation +6 added lines, -6 removed lines

@@ -152,12 +152,12 @@
             ->get()->toArray();
     }
 
-     /**
-     * First level search for students
-     *
-     * @param array $student
-     * @return array
-     */
+        /**
+         * First level search for students
+         *
+         * @param array $student
+         * @return array
+         */
     public function getStudentCount($student)
     {
         return $this

Spacing +10 added lines, -10 removed lines

@@ -149,9 +149,9 @@ 
     public function getMatches($student)
     {
         return $this
-        ->where('gender_id',$student['gender'] + 1)
-        ->where('institutions.code',$student['schoolid'])
-        ->where('date_of_birth',$student['b_date'])
+        ->where('gender_id', $student['gender'] + 1)
+        ->where('institutions.code', $student['schoolid'])
+        ->where('date_of_birth', $student['b_date'])
             ->join('institution_students', 'security_users.id', 'institution_students.student_id')
             ->join('institutions', 'institution_students.institution_id', 'institutions.id')
             ->get()->toArray();
@@ -166,9 +166,9 @@ 
     public function getStudentCount($student)
     {
         return $this
-        ->where('gender_id',$student['gender'] + 1)
-        ->where('institutions.code',$student['schoolid'])
-        ->where('date_of_birth',$student['b_date'])
+        ->where('gender_id', $student['gender'] + 1)
+        ->where('institutions.code', $student['schoolid'])
+        ->where('date_of_birth', $student['b_date'])
             ->join('institution_students', 'security_users.id', 'institution_students.student_id')
             ->join('institutions', 'institution_students.institution_id', 'institutions.id')
             ->count();
@@ -202,7 +202,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.
             $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
@@ -223,7 +223,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),
@@ -237,11 +237,11 @@ 
         ];
 
         try {
-            self::where( 'id'  , $sis_student['student_id'])->update($studentData);
+            self::where('id', $sis_student['student_id'])->update($studentData);
             $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();

app/Console/Commands/ExaminationStudentMigrate.php

Spacing +1 added lines, -1 removed lines

@@ -47,7 +47,7 @@
             $output->writeln('###########################################------starting export------###########################################');
             $this->examinationController->export();
             $output->writeln('###########################################------Finished inserting file records------###########################################');
-        } else {
+        }else {
             $this->examinationController->doMatch($this->argument('offset'), $this->argument('limit'), $this->argument(('mode')));
             $this->examinationController->export();
         }

app/Exports/ExaminationStudentsExport.php

Indentation +2 added lines, -2 removed lines

@@ -37,8 +37,8 @@
     }
     
     /**
-    * @return \Illuminate\Support\Collection
-    */
+     * @return \Illuminate\Support\Collection
+     */
     public function query()
     {
         return Examination_student::query()->whereNotNull('nsid')

Spacing +2 added lines, -2 removed lines

@@ -10,7 +10,7 @@ 
 use Maatwebsite\Excel\Concerns\WithHeadings;
 use Carbon\Carbon;
 
-class ExaminationStudentsExport implements FromQuery , WithHeadings 
+class ExaminationStudentsExport implements FromQuery, WithHeadings 
 {
 
     use Exportable;
@@ -44,6 +44,6 @@ 
     {
         return Examination_student::query()->whereNotNull('nsid')
         ->distinct('nsid')
-        ->whereDate('updated_at','>=',Carbon::today());
+        ->whereDate('updated_at', '>=', Carbon::today());
     }
 }

app/Http/Controllers/ExaminationStudentsController.php

Braces +1 added lines, -1 removed lines

@@ -306,7 +306,7 @@
         // 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;

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();
     }
@@ -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) {
         }
     }
 
@@ -135,9 +135,9 @@ 
         $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.*')
-                    ->join('examination_students as e2', 'es.nsid','e2.nsid')
+                    ->join('examination_students as e2', 'es.nsid', 'e2.nsid')
                     ->having('total', '>', 1)
                     ->groupBy('e2.st_no')
                     ->orderBy('e2.st_no')
@@ -145,18 +145,18 @@ 
                     ->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;
             case 'empty';
                 $students = Examination_student::whereNull('nsid')
-                    ->orWhere('nsid','<>','')
+                    ->orWhere('nsid', '<>', '')
                     ->offset($offset)
                     ->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;
@@ -165,7 +165,7 @@ 
                     whereRaw('CHAR_LENGTH(nsid) > 11')
                     ->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;
@@ -174,14 +174,14 @@ 
                 ->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)
                     ->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');
         }
@@ -227,13 +227,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)) {
 
@@ -260,7 +260,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) {
@@ -268,13 +268,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);
@@ -282,9 +282,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']);
         }
     }
 
@@ -301,18 +301,18 @@ 
         /**
          */
         $sis_student = $this->student->getMatches($student);
-        $doe_students =  Examination_student::where('gender',$student['gender'])
-            ->where('b_date',$student['b_date'])
-            ->where('schoolid',$student['schoolid'])
+        $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{
+        if (($doe_students > 1) || ($count > 1)) {
+            $studentData = $this->searchSimilarName($student, $sis_users, false);
+        }else {
             $studentData = $this->searchSimilarName($student, $sis_users);
         }   
         return $studentData;
@@ -325,7 +325,7 @@ 
      * @param array $sis_students
      * @return array
      */
-    public function searchSimilarName($student, $sis_students,$surname_search = true)
+    public function searchSimilarName($student, $sis_students, $surname_search = true)
     {
         $highest = [];
         $minDistance = 0;
@@ -345,7 +345,7 @@ 
             }
         }
 
-        if($surname_search){
+        if ($surname_search) {
             if (empty($highest)) {
                 foreach ($sis_students as $key => $value) {
                     //search name with last name
@@ -361,8 +361,8 @@ 
             }
         }
 
-        if(count($matches)>1){
-            $highest =  $this->searchSimilarName($student, $sis_students,false);
+        if (count($matches) > 1) {
+            $highest = $this->searchSimilarName($student, $sis_students, false);
         }
 
         return $highest;
@@ -378,18 +378,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);
@@ -407,7 +407,7 @@ 
         try {
             (new ExaminationStudentsExport)->store('examination/student_data_with_nsid.'.time().'.csv');
             (new ExportReady($adminUser));
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             //throw $th;
             dd($th);
         }
@@ -417,13 +417,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);
     }
 }