moe-lk / bulk-upload

app/Console/Commands/RunAddApprovedStudents.php

Indentation +28 added lines, -28 removed lines

@@ -78,41 +78,41 @@
             $this->count += 1;
             $this->student = $student ;
             try{
-               Institution_student::create([
-                   'student_status_id' => 1,
-                   'student_id' => $student['student_id'],
-                   'education_grade_id' => $student['education_grade_id'],
-                   'academic_period_id' => $student['academic_period_id'],
-                   'start_date' => $student['start_date'],
-                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['start_date'])->year , // $student['start_date']->format('Y'),
-                   'end_date' => $student['end_date'],
-                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['end_date'])->year , //$student['end_date']->format('Y'),
-                   'institution_id' => $student['institution_id'],
-                   'admission_id' => $student['admission_id'],
-                   'created_user_id' => $student['created_user_id'],
-               ]);
-
-               if(!is_null($student['institution_class_id'])){
-                   Institution_class_student::create([
-                       'student_id' => $student['student_id'],
-                       'institution_class_id' => $student['institution_class_id'],
-                       'education_grade_id' =>  $student['education_grade_id'],
-                       'academic_period_id' => $student['academic_period_id'],
-                       'institution_id' =>$student['institution_id'],
-                       'student_status_id' => 1,
-                       'created_user_id' => $student['created_user_id'],
-                   ]);
-               }
+                Institution_student::create([
+                    'student_status_id' => 1,
+                    'student_id' => $student['student_id'],
+                    'education_grade_id' => $student['education_grade_id'],
+                    'academic_period_id' => $student['academic_period_id'],
+                    'start_date' => $student['start_date'],
+                    'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['start_date'])->year , // $student['start_date']->format('Y'),
+                    'end_date' => $student['end_date'],
+                    'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['end_date'])->year , //$student['end_date']->format('Y'),
+                    'institution_id' => $student['institution_id'],
+                    'admission_id' => $student['admission_id'],
+                    'created_user_id' => $student['created_user_id'],
+                ]);
+
+                if(!is_null($student['institution_class_id'])){
+                    Institution_class_student::create([
+                        'student_id' => $student['student_id'],
+                        'institution_class_id' => $student['institution_class_id'],
+                        'education_grade_id' =>  $student['education_grade_id'],
+                        'academic_period_id' => $student['academic_period_id'],
+                        'institution_id' =>$student['institution_id'],
+                        'student_status_id' => 1,
+                        'created_user_id' => $student['created_user_id'],
+                    ]);
+                }
                 $output->writeln('
         ####################################################
            Total number of students updated : '.$this->count.'
         #                                                  #
         ####################################################' );
 //        $output->writeln();
-           }catch (\Exception $e){
+            }catch (\Exception $e){
 //               echo $e->getMessage();
-               $output->writeln( $e->getMessage());
-           }
+                $output->writeln( $e->getMessage());
+            }
         }
     }
 

Spacing +20 added lines, -20 removed lines

@@ -51,48 +51,48 @@ 
             'id' => $this->argument('institution')
         ])->first();
 
-        if(!is_null($institution)){
+        if (!is_null($institution)) {
             try {
-                $this->info('adding missing students to the admission ' . $institution->name);
+                $this->info('adding missing students to the admission '.$institution->name);
                 $allApprovedStudents = Institution_student_admission::where([
                     'status_id' => 124,
                     'institution_id' => $institution->id
                 ])->get()->toArray();
                 $allApprovedStudents = array_chunk($allApprovedStudents, 50);
                 array_walk($allApprovedStudents, array($this, 'addStudents'));
-            } catch (\Exception $e) {
+            }catch (\Exception $e) {
                 Log::error($e);
             }
         }
     }
 
-    protected function addStudents($students){
-        array_walk($students,array($this,'addStudent'));
+    protected function addStudents($students) {
+        array_walk($students, array($this, 'addStudent'));
     }
 
-    protected function addStudent($student){
+    protected function addStudent($student) {
 //        dd(Institution_class_student::isDuplicated($student));
         $output = new \Symfony\Component\Console\Output\ConsoleOutput();
         sleep(1);
-        if(!(Institution_class_student::isDuplicated($student) > 0)){
+        if (!(Institution_class_student::isDuplicated($student) > 0)) {
             $this->count += 1;
-            $this->student = $student ;
-            try{
+            $this->student = $student;
+            try {
                Institution_student::create([
                    'student_status_id' => 1,
                    'student_id' => $student['student_id'],
                    'education_grade_id' => $student['education_grade_id'],
                    'academic_period_id' => $student['academic_period_id'],
                    'start_date' => $student['start_date'],
-                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['start_date'])->year , // $student['start_date']->format('Y'),
+                   'start_year' => \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['start_date'])->year, // $student['start_date']->format('Y'),
                    'end_date' => $student['end_date'],
-                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['end_date'])->year , //$student['end_date']->format('Y'),
+                   'end_year' =>  \Carbon\Carbon::createFromFormat('Y-m-d H:i:s', $student['end_date'])->year, //$student['end_date']->format('Y'),
                    'institution_id' => $student['institution_id'],
                    'admission_id' => $student['admission_id'],
                    'created_user_id' => $student['created_user_id'],
                ]);
 
-               if(!is_null($student['institution_class_id'])){
+               if (!is_null($student['institution_class_id'])) {
                    Institution_class_student::create([
                        'student_id' => $student['student_id'],
                        'institution_class_id' => $student['institution_class_id'],
@@ -109,23 +109,23 @@ 
         #                                                  #
         ####################################################' );
 //        $output->writeln();
-           }catch (\Exception $e){
+           }catch (\Exception $e) {
 //               echo $e->getMessage();
-               $output->writeln( $e->getMessage());
+               $output->writeln($e->getMessage());
            }
         }
     }
 
 
-    protected  function  setSubjects($student){
+    protected  function  setSubjects($student) {
         $allSubjects = Institution_class_subject::getMandetorySubjects($student['institution_class_id']);
 
         if (!empty($allSubjects)) {
             $allSubjects = unique_multidim_array($allSubjects, 'institution_subject_id');
             $this->student = $student;
-            $allSubjects = array_map(array($this,'setStudentSubjects'),$allSubjects);
+            $allSubjects = array_map(array($this, 'setStudentSubjects'), $allSubjects);
             $allSubjects = unique_multidim_array($allSubjects, 'education_subject_id');
-            array_walk($allSubjects,array($this,'insertSubject'));
+            array_walk($allSubjects, array($this, 'insertSubject'));
         }
 
         unset($allSubjects);
@@ -133,7 +133,7 @@ 
     }
 
 
-    protected function setStudentSubjects($subject){
+    protected function setStudentSubjects($subject) {
         return [
             'id' => (string) Uuid::generate(4),
             'student_id' => $this->student->student_id,
@@ -149,8 +149,8 @@ 
         ];
     }
 
-    protected function insertSubject($subject){
-        if(!Institution_subject_student::isDuplicated($subject)){
+    protected function insertSubject($subject) {
+        if (!Institution_subject_student::isDuplicated($subject)) {
             Institution_subject_student::updateOrInsert($subject);
         }
     }

Braces +1 added lines, -1 removed lines

@@ -109,7 +109,7 @@
         #                                                  #
         ####################################################' );
 //        $output->writeln();
-           }catch (\Exception $e){
+           } catch (\Exception $e){
 //               echo $e->getMessage();
                $output->writeln( $e->getMessage());
            }

app/Console/Commands/callAddApprovedStudents.php

Spacing +6 added lines, -6 removed lines

@@ -39,17 +39,17 @@
      */
     public function handle()
     {
-        ini_set('memory_limit','2048');
+        ini_set('memory_limit', '2048');
         $institutions = $this->instituions->all()->chunk(50)->toArray();
-        array_walk($institutions,array($this,'addInstitutionStudents'));
+        array_walk($institutions, array($this, 'addInstitutionStudents'));
     }
 
-    protected function addInstitutionStudents($chunk){
-        array_walk($chunk,array($this,'callFunction'));
+    protected function addInstitutionStudents($chunk) {
+        array_walk($chunk, array($this, 'callFunction'));
 
     }
 
-    protected function callFunction($institution){
-        $this->call('admission:students',['institution' => $institution['code']]);
+    protected function callFunction($institution) {
+        $this->call('admission:students', ['institution' => $institution['code']]);
     }
 }

app/Console/Kernel.php

Indentation +2 added lines, -2 removed lines

@@ -25,8 +25,8 @@
      */
     protected function schedule(Schedule $schedule)
     {
-         $schedule->command('import:students')
-                  ->cron('* * * * * ');
+            $schedule->command('import:students')
+                    ->cron('* * * * * ');
     }
 
     /**

app/Exports/UsersExport.php

Spacing +3 added lines, -3 removed lines

@@ -31,12 +31,12 @@ 
     public function __construct($class) {
 
         $this->class = $class;
-        $this->_file_name = time() . '_' . Auth::user()->id . '_' . 'student_upload.xls';
+        $this->_file_name = time().'_'.Auth::user()->id.'_'.'student_upload.xls';
     }
 
     public function registerEvents(): array {
         return [
-        BeforeSheet::class => function(BeforeSheet $event){
+        BeforeSheet::class => function(BeforeSheet $event) {
 //          dd($event->crea)  
         },
             BeforeWriting::class => function(BeforeWriting $event) {
@@ -63,7 +63,7 @@ 
         $class = $this->class;
         return Security_user::select('openemis_no', 'first_name', 'gender_id', 'date_of_birth', 'address', 'birthplace_area_id')
                         ->with(['class', 'special_needs'])
-                        ->whereHas('class', function ($query) use ($class) {
+                        ->whereHas('class', function($query) use ($class) {
                             $query->where('institution_class_id', '=', $class);
                         })
                         ->get();

app/Models/User_body_mass.php

Spacing +1 added lines, -1 removed lines

@@ -4,7 +4,7 @@
 
 use Illuminate\Database\Eloquent\Model;
 
-class User_body_mass extends Base_Model  {
+class User_body_mass extends Base_Model {
 
     /**
      * The database table used by the model.

app/Models/Institution_staff.php

Spacing +5 added lines, -5 removed lines

@@ -4,7 +4,7 @@ 
 
 use Illuminate\Database\Eloquent\Model;
 
-class Institution_staff extends Model  {
+class Institution_staff extends Model {
 
     /**
      * The database table used by the model.
@@ -42,12 +42,12 @@ 
     protected $dates = ['start_date', 'end_date', 'modified', 'created'];
 
 
-    public function staff_class(){
-        return $this->hasMany('App\Models\Institution_class','staff_id','staff_id');
+    public function staff_class() {
+        return $this->hasMany('App\Models\Institution_class', 'staff_id', 'staff_id');
     }
 
-    public function institution(){
-        return $this->belongsTo('App\Models\Institution','institution_id');
+    public function institution() {
+        return $this->belongsTo('App\Models\Institution', 'institution_id');
     }
 
 

app/Models/Nationality.php

Spacing +1 added lines, -1 removed lines

@@ -4,7 +4,7 @@
 
 use Illuminate\Database\Eloquent\Model;
 
-class Nationality extends Model  {
+class Nationality extends Model {
 
     /**
      * The database table used by the model.

app/Models/Workflow_transition.php

Spacing +1 added lines, -1 removed lines

@@ -4,7 +4,7 @@
 
 use Illuminate\Database\Eloquent\Model;
 
-class Workflow_transition extends Model  {
+class Workflow_transition extends Model {
 
     public const CREATED_AT = 'created';
     public const UPDATED_AT = 'modified';

app/Models/Institution_grade.php

Indentation +2 added lines, -2 removed lines

@@ -107,8 +107,8 @@
      * @return mixed
      */
     public function getInstitutionGrade($institutionId, $gradeId){
-         return self::where('education_grade_id',$gradeId)
-             ->where('institution_id',$institutionId)->get()->first();
+            return self::where('education_grade_id',$gradeId)
+                ->where('institution_id',$institutionId)->get()->first();
     }
 
     /**

Braces +1 added lines, -1 removed lines

@@ -83,7 +83,7 @@
                 ->where('institution_grades.education_grade_id', $educationGradeId)
                 ->where('institution_grades.institution_id', $institutionId)
                 ->get();
-        }else{
+        } else{
             return null;
         }
     }

Spacing +21 added lines, -21 removed lines

@@ -71,11 +71,11 @@ 
     {
         if (!is_null($id)) {
             return 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) {
+                ->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->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);
                         });
@@ -83,7 +83,7 @@ 
                 ->where('institution_grades.education_grade_id', $educationGradeId)
                 ->where('institution_grades.institution_id', $institutionId)
                 ->get();
-        }else{
+        }else {
             return null;
         }
     }
@@ -95,8 +95,8 @@ 
      * @param $year
      * @param $id
      */
-    public function updatePromoted($year, $id){
-        self::where('id',$id)->update(['promoted'=>$year]);
+    public function updatePromoted($year, $id) {
+        self::where('id', $id)->update(['promoted'=>$year]);
     }
 
     /**
@@ -106,9 +106,9 @@ 
      * @param $gradeId
      * @return mixed
      */
-    public function getInstitutionGrade($institutionId, $gradeId){
-         return self::where('education_grade_id',$gradeId)
-             ->where('institution_id',$institutionId)->get()->first();
+    public function getInstitutionGrade($institutionId, $gradeId) {
+         return self::where('education_grade_id', $gradeId)
+             ->where('institution_id', $institutionId)->get()->first();
     }
 
     /**
@@ -116,14 +116,14 @@ 
      * @param null $institution
      * @return mixed
      */
-    public function getInstitutionGradeToPromoted($year, $institution = null){
+    public function getInstitutionGradeToPromoted($year, $institution = null) {
         return self::query()
-            ->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-1)
-            ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id')
-            ->join('institutions', function($join) use ($year,$institution){
-                $join->on('institutions.id','=','institution_grades.institution_id')
-                    ->where('institutions.code','=',$institution);
+            ->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 - 1)
+            ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id')
+            ->join('institutions', function($join) use ($year, $institution){
+                $join->on('institutions.id', '=', 'institution_grades.institution_id')
+                    ->where('institutions.code', '=', $institution);
             })
                 ->orderBy('institution_id')
             ->get()->toArray();
@@ -133,13 +133,13 @@ 
      * @param $year
      * @return mixed
      */
-    public function getInstitutionGradeList($year){
+    public function getInstitutionGradeList($year) {
         return self::query()
-            ->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-1)
-            ->join('education_grades','institution_grades.education_grade_id','=','education_grades.id')
+            ->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 - 1)
+            ->join('education_grades', 'institution_grades.education_grade_id', '=', 'education_grades.id')
             ->join('institutions', function($join) use ($year){
-                $join->on('institutions.id','=','institution_grades.institution_id');
+                $join->on('institutions.id', '=', 'institution_grades.institution_id');
             })
             ->orderBy('institution_id')
             ->get()