moe-lk / bulk-upload

app/Console/Commands/UpdateClassEntriyWithZeroId.php

Indentation +3 added lines, -3 removed lines

@@ -74,7 +74,7 @@ 
 
     public function process($student)
     {
-       try{
+        try{
         $wrongStudentsClass = Institution_class_student::where('institution_id', $student['institution_id'])
             ->whereRaw('institution_class_id not in (select id from institution_classes where institution_id ='.$student['institution_id'].' )')
             ->orWhere('institution_class_id', 0)
@@ -143,8 +143,8 @@ 
                 $this->output->writeln("student record  :".$student['student_id'] );
             }
         }
-       }catch(\Exception $e){
+        }catch(\Exception $e){
             dd($e);
-       }
+        }
     }
 }

Spacing +11 added lines, -11 removed lines

@@ -51,10 +51,10 @@ 
 
         if ($this->argument('code') !== 'All') {
             $institutions = Institution::where('code', $this->argument('code'))->get()->toArray();
-            processParallel(array($this,'processInstitution'),$institutions,$this->argument('max'));
-        } else {
+            processParallel(array($this, 'processInstitution'), $institutions, $this->argument('max'));
+        }else {
             $institutions = Institution::where('institution_status_id', 1)->get()->toArray();
-            processParallel(array($this,'processInstitution'),$institutions,$this->argument('max'));
+            processParallel(array($this, 'processInstitution'), $institutions, $this->argument('max'));
         }
     }
 
@@ -65,16 +65,16 @@ 
             ->where('institutions.id', $institution['id'])
             ->get()->toArray();
         if (count($students) > 0) {
-            array_walk($students,array($this, 'process'));
-            $this->output->writeln("institution :" .$institution['code']. ' cleaned');
-        } else {
-            $this->output->writeln("all records are cleaned at  :".$institution['code'] );
+            array_walk($students, array($this, 'process'));
+            $this->output->writeln("institution :".$institution['code'].' cleaned');
+        }else {
+            $this->output->writeln("all records are cleaned at  :".$institution['code']);
         }
     }
 
     public function process($student)
     {
-       try{
+       try {
         $wrongStudentsClass = Institution_class_student::where('institution_id', $student['institution_id'])
             ->whereRaw('institution_class_id not in (select id from institution_classes where institution_id ='.$student['institution_id'].' )')
             ->orWhere('institution_class_id', 0)
@@ -88,7 +88,7 @@ 
 
             array_walk($wrongStudentsClass, array($this->class, 'updateClassCount'));
 
-            $institutionClass =  Institution_class::getGradeClasses($student['education_grade_id'], $student['institution_id']);
+            $institutionClass = Institution_class::getGradeClasses($student['education_grade_id'], $student['institution_id']);
 
             if (count($institutionClass) == 1) {
                 $start_date = new Carbon($student['start_date']);
@@ -140,10 +140,10 @@ 
                 ]);
                 $institutionClassStudent = [$institutionClassStudent];
                 array_walk($institutionClassStudent, array($this->class, 'updateClassCount'));
-                $this->output->writeln("student record  :".$student['student_id'] );
+                $this->output->writeln("student record  :".$student['student_id']);
             }
         }
-       }catch(\Exception $e){
+       }catch (\Exception $e) {
             dd($e);
        }
     }

Braces +1 added lines, -1 removed lines

@@ -143,7 +143,7 @@
                 $this->output->writeln("student record  :".$student['student_id'] );
             }
         }
-       }catch(\Exception $e){
+       } catch(\Exception $e){
             dd($e);
        }
     }

app/Models/Institution_grade.php

Spacing +13 added lines, -13 removed lines

@@ -70,10 +70,10 @@ 
     public function getParallelClasses($id, $institutionId, $educationGradeId, $academicPeriodId)
     {
         $data = self::find($id)->select('institution_grades.id as insGrade', 'institution_classes.id', 'institution_classes.name', 'institution_grades.education_grade_id')
-            ->join('institution_classes', function ($join) use ($educationGradeId, $academicPeriodId) {
+            ->join('institution_classes', function($join) use ($educationGradeId, $academicPeriodId) {
                 $join->on('institution_classes.institution_id', '=', 'institution_grades.institution_id')
                     ->where('institution_classes.academic_period_id', $academicPeriodId)
-                    ->join('institution_class_grades', function ($join) use ($educationGradeId) {
+                    ->join('institution_class_grades', function($join) use ($educationGradeId) {
                         $join->on('institution_class_grades.institution_class_id', '=', 'institution_classes.id')
                             ->where('institution_class_grades.education_grade_id', $educationGradeId);
                     })
@@ -123,7 +123,7 @@ 
             ->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id')
             ->where('promoted', '=', $year)
             ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id')
-            ->join('institutions', function ($join) use ($year, $institution) {
+            ->join('institutions', function($join) use ($year, $institution) {
                 $join->on('institutions.id', '=', 'institution_grades.institution_id')
                     ->where('institutions.code', '=', $institution);
             })
@@ -134,7 +134,7 @@ 
                 break;
             case '6-11':
                 $query->whereIn('education_programmes.education_cycle_id', [2, 3]);
-                $query->whereNotIn('education_grades.id',[29,34]);
+                $query->whereNotIn('education_grades.id', [29, 34]);
                 break;
             case 'AL':
                 $query->where('education_programmes.education_cycle_id', 4);
@@ -152,21 +152,21 @@ 
      * @param $year
      * @return mixed
      */
-    public function getInstitutionGradeList($year, $limit,$mode)
+    public function getInstitutionGradeList($year, $limit, $mode)
     {
         $query = $this->select('education_grades.name', 'institutions.code', 'institutions.name as institution_name', 'institution_grades.id', 'institution_grades.institution_id', 'institution_grades.education_grade_id')
             ->where('promoted', '=', $year)
             ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id')
-            ->join('institutions', function ($join) use ($year) {
+            ->join('institutions', function($join) use ($year) {
                 $join->on('institutions.id', '=', 'institution_grades.institution_id');
             })
             ->join('education_programmes', 'education_grades.education_programme_id', 'education_programmes.id');
             switch ($mode) {
                 case '1-5':
-                    $query->whereIn('education_programmes.education_cycle_id', [1,2]);
+                    $query->whereIn('education_programmes.education_cycle_id', [1, 2]);
                     break;
                 case '6-11':
-                    $query->whereIn('education_programmes.education_cycle_id', [2,3,4]);
+                    $query->whereIn('education_programmes.education_cycle_id', [2, 3, 4]);
                     break;
                 case 'AL':
                     $query->where('education_programmes.education_cycle_id', 4);
@@ -181,13 +181,13 @@ 
             return $data;
     }
 
-    public function getGradeSubjects($institutionId){
+    public function getGradeSubjects($institutionId) {
         return self::query()
-        ->select('institution_grades.institution_id','education_grades_subjects.education_grade_id','education_grades_subjects.education_subject_id','education_subjects.name')
-        ->where('institution_grades.institution_id',$institutionId)
+        ->select('institution_grades.institution_id', 'education_grades_subjects.education_grade_id', 'education_grades_subjects.education_subject_id', 'education_subjects.name')
+        ->where('institution_grades.institution_id', $institutionId)
         ->join('education_grades', 'institution_grades.education_grade_id', 'education_grades.id')
-        ->join('education_grades_subjects','education_grades.id','education_grades_subjects.education_grade_id')
-        ->join('education_subjects','education_grades_subjects.education_subject_id','education_subjects.id')
+        ->join('education_grades_subjects', 'education_grades.id', 'education_grades_subjects.education_grade_id')
+        ->join('education_subjects', 'education_grades_subjects.education_subject_id', 'education_subjects.id')
         ->groupBy('education_grades_subjects.id')
         ->get()
         ->toArray();