moe-lk / bulk-upload

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/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 +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/Console/Commands/ExaminationCheck.php

Spacing +8 added lines, -8 removed lines

@@ -44,21 +44,21 @@
         $this->start_time = microtime(TRUE);
         $count = DB::table('examination_students')->select('nsid')->distinct()->count();
         $this->examinationController = new ExaminationStudentsController($this->argument('year'), $this->argument('grade'));
-        $studentsIdsWithDuplication =   DB::table('examination_students as es')
-        ->select(DB::raw('count(*) as total'),'es.*')
+        $studentsIdsWithDuplication = DB::table('examination_students as es')
+        ->select(DB::raw('count(*) as total'), 'es.*')
         ->whereNotNull('es.nsid')
-        ->having('total','>',1)
+        ->having('total', '>', 1)
         ->groupBy('es.nsid')
         ->orderBy('es.nsid')
-        ->chunk($this->argument('limit'),function($Students){
+        ->chunk($this->argument('limit'), function($Students) {
             foreach ($Students as $Student) {
-                $count = Examination_student::where('nsid',$Student->nsid)->count();
-                if($count> 1){
-                    Examination_student::where('nsid',$Student->nsid)->update(['nsid'=>'']);
+                $count = Examination_student::where('nsid', $Student->nsid)->count();
+                if ($count > 1) {
+                    Examination_student::where('nsid', $Student->nsid)->update(['nsid'=>'']);
                     $students = (array) json_decode(json_encode($Students), true);
                     array_walk($students, array($this->examinationController, 'clone'));
                 }
-                $this->output->writeln($Student->nsid .'same ID' . $count . ' records removed');
+                $this->output->writeln($Student->nsid.'same ID'.$count.' records removed');
             }
         });  
     }

app/Console/Commands/StudentsIdGen.php

Spacing +9 added lines, -9 removed lines

@@ -36,7 +36,7 @@ 
         $this->output = new \Symfony\Component\Console\Output\ConsoleOutput();
         $this->students = new Security_user();
         $this->uniqueUId = new UniqueUid();
-        $this->max  = 0;
+        $this->max = 0;
         $this->child = 0;
         parent::__construct();
     }
@@ -60,19 +60,19 @@ 
     public function processParallel(array $arr, $procs = 4)
     {
         // Break array up into $procs chunks.
-        $chunks   = array_chunk($arr, ceil((count($arr) / $procs)));
+        $chunks   = array_chunk($arr, ceil((count($arr)/$procs)));
         $pid      = -1;
         $children = array();
         foreach ($chunks as $items) {
             $pid = pcntl_fork();
             if ($pid === -1) {
                 die('could not fork');
-            } else if ($pid === 0) {
-                $this->output->writeln('started processes: ' . count($children));
+            }else if ($pid === 0) {
+                $this->output->writeln('started processes: '.count($children));
                 // We are the child process. Pass a chunk of items to process.
                 array_walk($items, array($this, 'process'));
                 exit(0);
-            } else {
+            }else {
                 // We are the parent.
                 $children[] = $pid;
             }
@@ -104,17 +104,17 @@ 
 
                 $newId = $this->uniqueUId::getUniqueAlphanumeric();
                 $student['openemis_no'] = $newId;
-                $student =  $this->uniqueUserId->updateOrInsertRecord($student);
+                $student = $this->uniqueUserId->updateOrInsertRecord($student);
                 // $this->output->writeln('New NSID generated for :' . $student['id']);
                 Security_user::query()->where('id', $student['id'])
                     ->update(['openemis_no' => $newId, 'username' => str_replace('-', '', $newId)]);
-            } catch (\Exception $e) {
+            }catch (\Exception $e) {
             }
-        } else {
+        }else {
             try {
                 // $this->output->writeln('Updating student:' . $student['id']);
                 $this->uniqueUserId->updateOrInsertRecord($student);
-            } catch (\Exception $e) {
+            }catch (\Exception $e) {
                 dd($e);
             }
         }

app/Models/Institution_subject_student.php

Indentation +5 added lines, -5 removed lines

@@ -70,21 +70,21 @@
      */
     public static function  isDuplicated($inputs){
 
-       $exists = self::where('student_id','=',$inputs['student_id'])
-           ->where('institution_subject_id','=',$inputs['institution_subject_id'])
-           ->where('education_subject_id','=',$inputs['education_subject_id'])->count();
+        $exists = self::where('student_id','=',$inputs['student_id'])
+            ->where('institution_subject_id','=',$inputs['institution_subject_id'])
+            ->where('education_subject_id','=',$inputs['education_subject_id'])->count();
 
 
         return $exists ? true :false;
     }
 
     
-     public function student(){
+        public function student(){
         return $this->belongsTo('App\Models\Security_user','student_id');
     }
     
     public static function getStudentsCount($institution_subject_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) {
                     $query->where('gender_id', '=', 1);

Spacing +11 added lines, -11 removed lines

@@ -7,7 +7,7 @@ 
 use Illuminate\Database\Eloquent\Model;
 use Illuminate\Database\Eloquent\SoftDeletes;
 
-class Institution_subject_student extends Model  {
+class Institution_subject_student extends Model {
 
 
     use SoftDeletes;
@@ -56,7 +56,7 @@ 
     public static function boot()
     {
         parent::boot();
-        self::creating(function ($model) {
+        self::creating(function($model) {
             $model->id = (string) Uuid::generate(4);
         });
 
@@ -68,31 +68,31 @@ 
      *
      *
      */
-    public static function  isDuplicated($inputs){
+    public static function  isDuplicated($inputs) {
 
-       $exists = self::where('student_id','=',$inputs['student_id'])
-           ->where('institution_subject_id','=',$inputs['institution_subject_id'])
-           ->where('education_subject_id','=',$inputs['education_subject_id'])->count();
+       $exists = self::where('student_id', '=', $inputs['student_id'])
+           ->where('institution_subject_id', '=', $inputs['institution_subject_id'])
+           ->where('education_subject_id', '=', $inputs['education_subject_id'])->count();
 
 
         return $exists ? true :false;
     }
 
     
-     public function student(){
-        return $this->belongsTo('App\Models\Security_user','student_id');
+     public function student() {
+        return $this->belongsTo('App\Models\Security_user', 'student_id');
     }
     
-    public static function getStudentsCount($institution_subject_id){
+    public static function getStudentsCount($institution_subject_id) {
          $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_subject_id', '=', $institution_subject_id)->count();
 
         $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_subject_id', '=', $institution_subject_id)->count();
 

app/Models/Unique_user_id.php

Indentation +5 added lines, -5 removed lines

@@ -54,7 +54,7 @@ 
 
     public  function updateOrInsertRecord($user)
     {
-       try {
+        try {
             // regenerate unique id if it's not available
         $uniqueId =  $this->uniqueUserId::isValidUniqueId($user['openemis_no'],9) ? $this->uniqueUserId::getUniqueAlphanumeric() : $user['openemis_no'];
 
@@ -69,10 +69,10 @@ 
             ]);
         }
         return $user;
-       } catch (\Exception $th) {
+        } catch (\Exception $th) {
             Log::error($th->getMessage());
-           $user['openemis_no'] = $this->uniqueUserId::getUniqueAlphanumeric();
-           $this->updateOrInsertRecord($user);
-       }
+            $user['openemis_no'] = $this->uniqueUserId::getUniqueAlphanumeric();
+            $this->updateOrInsertRecord($user);
+        }
     }
 }

Spacing +3 added lines, -3 removed lines

@@ -56,10 +56,10 @@ 
     {
        try {
             // regenerate unique id if it's not available
-        $uniqueId =  $this->uniqueUserId::isValidUniqueId($user['openemis_no'],9) ? $this->uniqueUserId::getUniqueAlphanumeric() : $user['openemis_no'];
+        $uniqueId = $this->uniqueUserId::isValidUniqueId($user['openemis_no'], 9) ? $this->uniqueUserId::getUniqueAlphanumeric() : $user['openemis_no'];
 
         //check if the user's entry exits ?
-        $exists = Unique_user_id::where('unique_id' , $uniqueId)->exists();
+        $exists = Unique_user_id::where('unique_id', $uniqueId)->exists();
 
         if (!$exists) {
             // try to feed unique user id
@@ -69,7 +69,7 @@ 
             ]);
         }
         return $user;
-       } catch (\Exception $th) {
+       }catch (\Exception $th) {
             Log::error($th->getMessage());
            $user['openemis_no'] = $this->uniqueUserId::getUniqueAlphanumeric();
            $this->updateOrInsertRecord($user);

app/Console/Commands/CleanExamData.php

Indentation +3 added lines, -3 removed lines

@@ -86,11 +86,11 @@
     }
 
     public function process($students,$count,$type){
-       if($type === 'duplicate'){
+        if($type === 'duplicate'){
         array_walk($students,array($this,'cleanData'));
-       }elseif($type === 'lock'){
+        }elseif($type === 'lock'){
         array_walk($students,array($this,'lockData'));
-       }
+        }
     }
 
     public function lockData($Student){

Spacing +25 added lines, -25 removed lines

@@ -48,24 +48,24 @@ 
     {
         $type = $this->argument('type');
         $students = array();
-        if($type == 'invalid'){
+        if ($type == 'invalid') {
             $students = DB::table('examination_students as es')
             ->whereRaw('CHAR_LENGTH(nsid) > 11')
             ->get()
             ->toArray();
-        }elseif($type == 'duplicate'){
+        }elseif ($type == 'duplicate') {
             $students = DB::table('security_users')
             ->where('updated_from', 'doe')
             ->get()
             ->toArray();
             
-        }elseif($type == 'all'){
+        }elseif ($type == 'all') {
             $students = DB::table('examination_students')
-            ->where('nsid','<>','')
+            ->where('nsid', '<>', '')
             ->whereNotNull('nsid')
             ->get()
             ->toArray();
-        }elseif($type == 'lock'){
+        }elseif ($type == 'lock') {
             $students = DB::table('examination_students')
             ->whereNotNull('nsid')
             ->get()
@@ -73,46 +73,46 @@ 
         }
 
         $this->output->writeln('###########################################------Start cleanning exam records------###########################################');    
-        if(count($students) > 0){
-            $this->output->writeln('Total students to clean: '.  count($students));
+        if (count($students) > 0) {
+            $this->output->writeln('Total students to clean: '.count($students));
             $students = array_chunk($students, $this->argument('chunk'));
             $function = array($this, 'process');
-            processParallel($function,$students, $this->argument('max'),$type);
-        }else{
+            processParallel($function, $students, $this->argument('max'), $type);
+        }else {
             $this->output->writeln('nothing to process, all are cleaned');
         }   
         $this->output->writeln('###########################################------Finished cleaning exam records------###########################################');
     }
 
-    public function process($students,$count,$type){
-       if($type === 'duplicate'){
-        array_walk($students,array($this,'cleanData'));
-       }elseif($type === 'lock'){
-        array_walk($students,array($this,'lockData'));
+    public function process($students, $count, $type) {
+       if ($type === 'duplicate') {
+        array_walk($students, array($this, 'cleanData'));
+       }elseif ($type === 'lock') {
+        array_walk($students, array($this, 'lockData'));
        }
     }
 
-    public function lockData($Student){
-        $Student = json_decode(json_encode($Student),true);
-        $student = Security_user::where('openemis_no',(string)$Student['nsid'])->first();
-        if(!empty($student)){
+    public function lockData($Student) {
+        $Student = json_decode(json_encode($Student), true);
+        $student = Security_user::where('openemis_no', (string) $Student['nsid'])->first();
+        if (!empty($student)) {
             Institution_student::where('student_id', $student->id)->update(['updated_from' => 'doe']);
             Security_user::where('id', $student->id)->update(['updated_from' => 'doe']);
-            $this->output->writeln('Locked:'. (string)$Student['nsid'] .':' . $student['openemis_no']);
+            $this->output->writeln('Locked:'.(string) $Student['nsid'].':'.$student['openemis_no']);
         }
     }
 
 
     public function cleanData($Student)
     {
-        $exist = Examination_student::where('nsid','=',  (string)$Student->openemis_no)->count();
+        $exist = Examination_student::where('nsid', '=', (string) $Student->openemis_no)->count();
         if (!$exist) {
             Institution_student::where('student_id', $Student->id)->delete();
             Institution_class_student::where('student_id', $Student->id)->delete();
             Institution_student_admission::where('student_id', $Student->id)->delete();
             Security_user::where('id', $Student->id)->delete();
-            $this->output->writeln('cleaned:'.  (string)$Student->openemis_no);
-        }else{
+            $this->output->writeln('cleaned:'.(string) $Student->openemis_no);
+        }else {
             
             Institution_student::where('student_id', $Student->id)->update(['updated_from' => 'doe']);
             Security_user::where('id', $Student->id)->update(['updated_from' => 'doe']);
@@ -132,12 +132,12 @@ 
     public function cleanInvalidData($Student)
     {
         $Student = (array) $Student;
-        $exist = Examination_student::where('nsid',$Student['nsid'])->count();
+        $exist = Examination_student::where('nsid', $Student['nsid'])->count();
         
         $this->uniqueUId = new UniqueUid();
 
-        $nsid = ltrim(rtrim($Student['nsid'],'-'),'-');
-        if(!$this->uniqueUId::isValidUniqueId('DBY-898-3J2')){
+        $nsid = ltrim(rtrim($Student['nsid'], '-'), '-');
+        if (!$this->uniqueUId::isValidUniqueId('DBY-898-3J2')) {
         }
     }
 }

Braces +6 added lines, -6 removed lines

@@ -53,19 +53,19 @@ 
             ->whereRaw('CHAR_LENGTH(nsid) > 11')
             ->get()
             ->toArray();
-        }elseif($type == 'duplicate'){
+        } elseif($type == 'duplicate'){
             $students = DB::table('security_users')
             ->where('updated_from', 'doe')
             ->get()
             ->toArray();
             
-        }elseif($type == 'all'){
+        } elseif($type == 'all'){
             $students = DB::table('examination_students')
             ->where('nsid','<>','')
             ->whereNotNull('nsid')
             ->get()
             ->toArray();
-        }elseif($type == 'lock'){
+        } elseif($type == 'lock'){
             $students = DB::table('examination_students')
             ->whereNotNull('nsid')
             ->get()
@@ -78,7 +78,7 @@ 
             $students = array_chunk($students, $this->argument('chunk'));
             $function = array($this, 'process');
             processParallel($function,$students, $this->argument('max'),$type);
-        }else{
+        } else{
             $this->output->writeln('nothing to process, all are cleaned');
         }   
         $this->output->writeln('###########################################------Finished cleaning exam records------###########################################');
@@ -87,7 +87,7 @@ 
     public function process($students,$count,$type){
        if($type === 'duplicate'){
         array_walk($students,array($this,'cleanData'));
-       }elseif($type === 'lock'){
+       } elseif($type === 'lock'){
         array_walk($students,array($this,'lockData'));
        }
     }
@@ -112,7 +112,7 @@ 
             Institution_student_admission::where('student_id', $Student->id)->delete();
             Security_user::where('id', $Student->id)->delete();
             $this->output->writeln('cleaned:'.  (string)$Student->openemis_no);
-        }else{
+        } else{
             
             Institution_student::where('student_id', $Student->id)->update(['updated_from' => 'doe']);
             Security_user::where('id', $Student->id)->update(['updated_from' => 'doe']);