moe-lk / bulk-upload

app/Mail/EmptyFile.php

Spacing +5 added lines, -5 removed lines

@@ -25,16 +25,16 @@ 
 
 
         $this->user = User::find($file['security_user_id']);
-        $this->subject = 'SIS Bulk Upload: ' .$file['subject'].' Empty ' . $institution->institution->code.': '. $institution->name.' '. date('Y:m:d H:i:s');
+        $this->subject = 'SIS Bulk Upload: '.$file['subject'].' Empty '.$institution->institution->code.': '.$institution->name.' '.date('Y:m:d H:i:s');
         $this->from_address = env('MAIL_FROM_ADDRESS');
         $this->from_name = 'SIS Bulk Uploader';
         $this->with = [
             'name' => $this->user->first_name,
-            'link' => \App::environment('local') || \App::environment('stage')   ?  env('APP_URL') : env('APP_URL').'/bulk-upload/'
+            'link' => \App::environment('local') || \App::environment('stage') ?  env('APP_URL') : env('APP_URL').'/bulk-upload/'
         ];
         $this->viewData = [
-            'name'=>$this->user->first_name, "body" => "No data Found in ". $file['filename']. ' Please re-upload the file with data',
-            'link' =>  \App::environment('local') || \App::environment('stage')   ?  env('APP_URL') : env('APP_URL').'/bulk-upload/'
+            'name'=>$this->user->first_name, "body" => "No data Found in ".$file['filename'].' Please re-upload the file with data',
+            'link' =>  \App::environment('local') || \App::environment('stage') ?  env('APP_URL') : env('APP_URL').'/bulk-upload/'
         ];
     }
 
@@ -46,7 +46,7 @@ 
     public function build()
     {
         return $this->view('emails.mail')
-            ->from($this->from_address,$this->from_name)
+            ->from($this->from_address, $this->from_name)
             ->to($this->user->email)
             ->subject($this->subject)
             ->with($this->with);

app/Models/DashboardViews.php

Spacing +18 added lines, -18 removed lines

@@ -36,7 +36,7 @@ 
             DbSchema::dropIfExists('students_count_view_table');
             DB::statement('CREATE TABLE students_count_view_table AS  (select * from students_count_view)');
             $output->writeln('creat : students_count_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -103,17 +103,17 @@ 
                 ->leftJoin("education_grades as eg", "eg.id", "i.id")
                 ->leftJoin("institution_class_students as ics", "ist.student_id", "ics.student_id")
                 ->leftJoin("institution_classes  as ic", "ic.id", "ics.institution_class_id")
-                ->leftJoin("student_guardians  as sgf", function ($join) {
+                ->leftJoin("student_guardians  as sgf", function($join) {
                     $join->on("sgf.student_id", "stu.id");
                     $join->where("sgf.guardian_relation_id", 1);
                 })
                 ->leftJoin("security_users  as sufu", "sgf.guardian_id", "sufu.id")
-                ->leftJoin("student_guardians  as sgm", function ($join) {
+                ->leftJoin("student_guardians  as sgm", function($join) {
                     $join->on("sgm.student_id", "stu.id");
                     $join->where("sgm.guardian_relation_id", 2);
                 })
                 ->leftJoin("security_users  as sumu", "sgm.guardian_id", "sumu.id")
-                ->leftJoin("student_guardians  as sg", function ($join) {
+                ->leftJoin("student_guardians  as sg", function($join) {
                     $join->on("sg.student_id", "stu.id");
                     $join->where("sg.guardian_relation_id", 3);
                 })
@@ -132,27 +132,27 @@ 
                 ->leftJoin("academic_periods as acps", "acps.id", "ist.academic_period_id")
                 ->leftJoin("institution_subject_students as iss", "stu.id", "iss.student_id")
                 ->leftJoin("education_subjects as edus", "edus.id", "iss.education_subject_id")
-                ->leftJoin("nationalities as natif", function ($join) {
+                ->leftJoin("nationalities as natif", function($join) {
                     $join->on("sufu.nationality_id", "natif.id");
                     $join->where("sgf.guardian_relation_id", 1);
                 })
-                ->leftJoin("nationalities as natim", function ($join) {
+                ->leftJoin("nationalities as natim", function($join) {
                     $join->on("sumu.nationality_id", "natim.id");
                     $join->where("sgm.guardian_relation_id", 2);
                 })
-                ->leftJoin("nationalities as natig", function ($join) {
+                ->leftJoin("nationalities as natig", function($join) {
                     $join->on("sugu.nationality_id", "natig.id");
                     $join->where("sg.guardian_relation_id", 3);
                 })
-                ->leftJoin("identity_types as idtf", function ($join) {
+                ->leftJoin("identity_types as idtf", function($join) {
                     $join->on("sufu.nationality_id", "idtf.id");
                     $join->where("sgf.guardian_relation_id", 1);
                 })
-                ->leftJoin("identity_types as idtm", function ($join) {
+                ->leftJoin("identity_types as idtm", function($join) {
                     $join->on("sumu.nationality_id", "idtm.id");
                     $join->where("sgm.guardian_relation_id", 2);
                 })
-                ->leftJoin("identity_types as idtg", function ($join) {
+                ->leftJoin("identity_types as idtg", function($join) {
                     $join->on("sugu.nationality_id", "idtg.id");
                     $join->where("sg.guardian_relation_id", 3);
                 })
@@ -166,7 +166,7 @@ 
             DB::statement('CREATE INDEX user_institution ON students_list_view_table (institution_id);');
             $output->writeln('created : students_list_view_table');
             $output->writeln('created : students_list_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -226,7 +226,7 @@ 
             Schema::createOrReplaceView('upload_list_view', $query);
             Schema::disableForeignKeyConstraints('upload_list_view');
             $output->writeln('created : upload_list_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -261,7 +261,7 @@ 
             Schema::dropIfExists("upload_count_view");
             Schema::createOrReplaceView("upload_count_view", $query);
             $output->writeln('created : upload_count_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -288,7 +288,7 @@ 
             Schema::dropIfExists("institution_info_view");
             Schema::createOrReplaceView("institution_info_view", $query);
             $output->writeln('created : institution_info_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -326,7 +326,7 @@ 
             Schema::dropIfExists("students_count_by_grade_view");
             Schema::createOrReplaceView('students_count_by_grade_view', $query);
             $output->writeln('created : students_count_by_grade_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -351,7 +351,7 @@ 
                     "ist.created"
                 )
                 ->join("institutions as i", "i.id", "ist.institution_id")
-                ->join('user_body_masses as ubm', function ($join) {
+                ->join('user_body_masses as ubm', function($join) {
                     $join->on('ubm.security_user_id', 'ist.student_id');
                     $join->where('ubm.academic_period_id', 'ist.academic_period_id');
                 })
@@ -359,7 +359,7 @@ 
             Schema::dropIfExists("students_count_by_bmi_view");
             Schema::createOrReplaceView("students_count_by_bmi_view", $query);
             $output->writeln('created : students_count_by_bmi_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }
@@ -392,7 +392,7 @@ 
             Schema::dropIfExists("student_count_by_class_view");
             Schema::createOrReplaceView('student_count_by_class_view', $query);
             $output->writeln('created : student_count_by_class_view');
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             $output->writeln($th->getMessage());
         }
     }

app/Notifications/ExportReady.php

Spacing +1 added lines, -1 removed lines

@@ -20,7 +20,7 @@
      */
     public function __construct($user)
     {
-        $this->user  = $user;
+        $this->user = $user;
     }
 
     /**

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/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/UpdateStudentsCount.php

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([

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

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

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