moe-lk / bulk-upload

app/Models/Security_group_institution.php

Spacing +10 added lines, -10 removed lines

@@ -4,7 +4,7 @@ 
 
 use Illuminate\Database\Eloquent\Model;
 
-class Security_group_institution extends Model  {
+class Security_group_institution extends Model {
 
 
     /**
@@ -44,21 +44,21 @@ 
 
 
 
-    public function institution(){
-        return $this->belongsTo('App\Models\Institution','institution_id');
+    public function institution() {
+        return $this->belongsTo('App\Models\Institution', 'institution_id');
     }
 
-    public function institution_classes(){
-        return $this->hasMany('App\Models\Institution_class','institution_id','institution_id')
+    public function institution_classes() {
+        return $this->hasMany('App\Models\Institution_class', 'institution_id', 'institution_id')
         ->select('institution_classes.*')
-        ->join('academic_periods', function($query){
-            $query->on('institution_classes.academic_period_id','academic_periods.id');
-            $query->whereIn('academic_periods.code',['2020','2019/2020']);
+        ->join('academic_periods', function($query) {
+            $query->on('institution_classes.academic_period_id', 'academic_periods.id');
+            $query->whereIn('academic_periods.code', ['2020', '2019/2020']);
         });
     }
 
-    public function security_group(){
-        return $this->belongsTo('App\Models\Security_group','security_group_id');
+    public function security_group() {
+        return $this->belongsTo('App\Models\Security_group', 'security_group_id');
     }
 
 }
\ No newline at end of file

app/Models/Security_group_user.php

Spacing +19 added lines, -19 removed lines

@@ -4,7 +4,7 @@ 
 
 use Illuminate\Database\Eloquent\Model;
 
-class Security_group_user extends Model  {
+class Security_group_user extends Model {
 
     public const CREATED_AT = 'created';
     public const UPDATED_AT = 'modified';
@@ -45,39 +45,39 @@ 
     protected $dates = ['modified', 'created', 'created'];
 
 
-    public function security_user(){
-        return $this->belongsToMany('App\Models\User','security_users');
+    public function security_user() {
+        return $this->belongsToMany('App\Models\User', 'security_users');
     }
 
-    public function security_group(){
-        return $this->hasMany('App\Models\Security_group' , 'id','security_group_id');
+    public function security_group() {
+        return $this->hasMany('App\Models\Security_group', 'id', 'security_group_id');
     }
 
-    public function security_group_institution(){
-        return $this->belongsTo('App\Models\Security_group_institution','security_group_id','security_group_id');
+    public function security_group_institution() {
+        return $this->belongsTo('App\Models\Security_group_institution', 'security_group_id', 'security_group_id');
     }
 
-    public function staff_class(){
-        return $this->hasMany('App\Models\Institution_class','staff_id','security_user_id')
+    public function staff_class() {
+        return $this->hasMany('App\Models\Institution_class', 'staff_id', 'security_user_id')
         ->select('institution_classes.*')
-        ->join('academic_periods',function($query){
-            $query->on('institution_classes.academic_period_id','academic_periods.id');
-            $query->whereIn('academic_periods.code',['2020','2019/2020']);
+        ->join('academic_periods', function($query) {
+            $query->on('institution_classes.academic_period_id', 'academic_periods.id');
+            $query->whereIn('academic_periods.code', ['2020', '2019/2020']);
         });
     }
 
-    public function institution_staff(){
-        return $this->belongsTo('App\Models\Institution_staff','security_user_id','staff_id');
+    public function institution_staff() {
+        return $this->belongsTo('App\Models\Institution_staff', 'security_user_id', 'staff_id');
     }
 
-    public function institution_group(){
-        return $this->hasMany('App\Models\Security_group_institution','security_group_id','security_group_id')
-            ->with(['institution','institution_classes']);
+    public function institution_group() {
+        return $this->hasMany('App\Models\Security_group_institution', 'security_group_id', 'security_group_id')
+            ->with(['institution', 'institution_classes']);
     }
 
 
-    public function roles(){
-        return $this->belongsTo('App\Models\Security_role','security_role_id','id');
+    public function roles() {
+        return $this->belongsTo('App\Models\Security_role', 'security_role_id', 'id');
     }
 
 

app/Models/Institution_staff.php

Spacing +7 added lines, -7 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,13 +42,13 @@ 
     protected $dates = ['start_date', 'end_date', 'modified', 'created'];
 
 
-    public function staff_class(){
-        return $this->hasMany('App\Models\Institution_class','staff_id','staff_id')
-        ->innerJoin('academic_periods','institution_classes.academic_period_id','academic_periods.id')
-        ->where('academic_periods.current',1);
+    public function staff_class() {
+        return $this->hasMany('App\Models\Institution_class', 'staff_id', 'staff_id')
+        ->innerJoin('academic_periods', 'institution_classes.academic_period_id', 'academic_periods.id')
+        ->where('academic_periods.current', 1);
     }
 
-    public function institution(){
-        return $this->belongsTo('App\Models\Institution','institution_id');
+    public function institution() {
+        return $this->belongsTo('App\Models\Institution', 'institution_id');
     }
 }
\ No newline at end of file

app/Models/Institution_student_admission.php

Spacing +3 added lines, -3 removed lines

@@ -72,18 +72,18 @@
                 'institution_id' => $admissionInfo['instituion']->id,
                 'academic_period_id' => $admissionInfo['academic_period']->id,
                 'education_grade_id' => $admissionInfo['education_grade']->id,
-                'institution_class_id' => (($admissionInfo['instituion_class']  != []) && (count($admissionInfo['instituion_class'])==1)) ? $admissionInfo['instituion_class']['id'] : null,
+                'institution_class_id' => (($admissionInfo['instituion_class'] != []) && (count($admissionInfo['instituion_class']) == 1)) ? $admissionInfo['instituion_class']['id'] : null,
                 'comment' => 'Imported From Examination Data',
                 'updated_from' => 'doe',
                 'created_user_id' => 1
             ];
             self::create($data);
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             Log::error($th);
         }
     }
 
-    public static function createAdmission($studentId,$row,$params,$file){
+    public static function createAdmission($studentId, $row, $params, $file) {
         self::create([
             'start_date' => $row['start_date_yyyy_mm_dd'],
             'start_year' => $row['start_date_yyyy_mm_dd']->format('Y'),

app/Models/Security_group.php

Spacing +5 added lines, -5 removed lines

@@ -4,7 +4,7 @@ 
 
 use Illuminate\Database\Eloquent\Model;
 
-class Security_group extends Model  {
+class Security_group extends Model {
 
     /**
      * The database table used by the model.
@@ -41,13 +41,13 @@ 
      */
     protected $dates = ['modified', 'created', 'created', 'created', 'modified', 'created'];
 
-    public function security_users(){
-        return $this->belongsTo('App\Models\Security_group_user','security_group_id');
+    public function security_users() {
+        return $this->belongsTo('App\Models\Security_group_user', 'security_group_id');
     }
 
 
-    public function security_group_institution(){
-        return $this->hasMany('App\Models\Security_group_institution','security_group_id');
+    public function security_group_institution() {
+        return $this->hasMany('App\Models\Security_group_institution', 'security_group_id');
     }
 
 }
\ No newline at end of file

app/Models/Student_guardian.php

Spacing +9 added lines, -9 removed lines

@@ -7,7 +7,7 @@ 
 use Illuminate\Database\Eloquent\SoftDeletes;
 use Webpatser\Uuid\Uuid;
 
-class Student_guardian extends Base_Model  {
+class Student_guardian extends Base_Model {
 
     use SoftDeletes;
 
@@ -59,21 +59,21 @@ 
     public static function boot()
     {
         parent::boot();
-        self::creating(function ($model) {
+        self::creating(function($model) {
             $model->id = (string) Uuid::generate(4);
             $model->created_user_id = 1;
         });
     }
 
-    public static function createStudentGuardian($student,$guardian,$user){
+    public static function createStudentGuardian($student, $guardian, $user) {
      
         $exist = true;
-        if(!is_null($guardian))
+        if (!is_null($guardian))
             $exist = self::where('student_id', $student->student_id)
             ->where('guardian_relation_id', $guardian->guardian_relation_id)
             ->exists();
 
-        $totalGuardians = self::where('student_id',$student->student_id)->count();
+        $totalGuardians = self::where('student_id', $student->student_id)->count();
 
         $data = [
             'student_id' => $student->student_id,
@@ -81,13 +81,13 @@ 
             'guardian_relation_id' => $guardian->guardian_relation_id,
             'created_user_id' => $user
         ];
-        if(!$exist){
+        if (!$exist) {
             $data['created'] = now();
             self::create($data);
-        }else{
+        }else {
             $data['modified'] = now();
-            self::where('student_id' , $student->student_id)
-            ->where('guardian_relation_id',$guardian->guardian_relation_id)
+            self::where('student_id', $student->student_id)
+            ->where('guardian_relation_id', $guardian->guardian_relation_id)
             ->update($data);
         }
     }

Braces +4 added lines, -3 removed lines

@@ -68,10 +68,11 @@ 
     public static function createStudentGuardian($student,$guardian,$user){
      
         $exist = true;
-        if(!is_null($guardian))
-            $exist = self::where('student_id', $student->student_id)
+        if(!is_null($guardian)) {
+                    $exist = self::where('student_id', $student->student_id)
             ->where('guardian_relation_id', $guardian->guardian_relation_id)
             ->exists();
+        }
 
         $totalGuardians = self::where('student_id',$student->student_id)->count();
 
@@ -84,7 +85,7 @@ 
         if(!$exist){
             $data['created'] = now();
             self::create($data);
-        }else{
+        } else{
             $data['modified'] = now();
             self::where('student_id' , $student->student_id)
             ->where('guardian_relation_id',$guardian->guardian_relation_id)

app/Models/User_body_mass.php

Spacing +11 added lines, -11 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.
@@ -48,17 +48,17 @@ 
     protected $dates = ['date', 'modified', 'created'];
 
 
-    public static function createOrUpdate($studentId,$row,$file){
+    public static function createOrUpdate($studentId, $row, $file) {
         if (!empty($row['bmi_weight']) && !empty($row['bmi_weight']) && !empty($row['bmi_date_yyyy_mm_dd'])) {
             try {
                 // convert Meeter to CM
-                $hight = $row['bmi_height'] / 100;
+                $hight = $row['bmi_height']/100;
                 //calculate BMI
-                $bodyMass = ($row['bmi_weight']) / pow($hight, 2);
+                $bodyMass = ($row['bmi_weight'])/pow($hight, 2);
                 $bmiAcademic = Academic_period::where('name', '=', $row['bmi_academic_period'])->first();
                 
-                $count = User_body_mass::where('academic_period_id' ,'=',$bmiAcademic->id)
-                            ->where('security_user_id',$studentId)->count();
+                $count = User_body_mass::where('academic_period_id', '=', $bmiAcademic->id)
+                            ->where('security_user_id', $studentId)->count();
                 $data = [
                     'height' => $row['bmi_height'],
                     'weight' => $row['bmi_weight'],
@@ -69,14 +69,14 @@ 
                     'created_user_id' => $file['security_user_id']
                 ];
                 // dd($data);
-                if($count == 0){
+                if ($count == 0) {
                     self::create($data);
-                }else{
-                    self::where('security_user_id',$studentId)
+                }else {
+                    self::where('security_user_id', $studentId)
                     ->update($data);
                 }         
-            } catch (\Throwable $th) {
-                \Log::error('User_body_mass:' . $th->getMessage());
+            }catch (\Throwable $th) {
+                \Log::error('User_body_mass:'.$th->getMessage());
             }
         }
     }

Braces +1 added lines, -1 removed lines

@@ -71,7 +71,7 @@
                 // dd($data);
                 if($count == 0){
                     self::create($data);
-                }else{
+                } else{
                     self::where('security_user_id',$studentId)
                     ->update($data);
                 }         

app/Models/Institution_class_student.php

Indentation +1 added lines, -1 removed lines

@@ -140,7 +140,7 @@
     }
 
     public static function createOrUpdate($studentId,$params,$file){
-       return  self::create([
+        return  self::create([
             'student_id' => $studentId,
             'institution_class_id' => $params['institution_class']->id,
             'education_grade_id' => $params['institution_grade']->education_grade_id,

Spacing +9 added lines, -9 removed lines

@@ -58,7 +58,7 @@ 
     public static function boot()
     {
         parent::boot();
-        self::creating(function ($model) {
+        self::creating(function($model) {
             $model->id = (string) Uuid::generate(4);
             $model->created = now();
         });
@@ -71,15 +71,15 @@ 
 
     public  static function getStudentsCount($institution_class_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) {
+        }])->whereHas('student', function($query) {
             $query->where('gender_id', '=', 1);
         })->where('institution_class_id', '=', $institution_class_id)->count();
 
-        $total_female_students = self::with(['student' => function ($query) {
+        $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_class_id', '=', $institution_class_id)->count();
 
@@ -109,8 +109,8 @@ 
             ->where('student_id', $student['student_id'])
             ->join('institution_classes', 'institution_class_students.institution_class_id', '=', 'institution_classes.id')
             ->where('institution_class_students.student_id', $student['student_id'])
-            ->where('institution_class_students.academic_period_id',$student['academic_period_id'])
-            ->where('institution_class_students.institution_id',$student['institution_id'])
+            ->where('institution_class_students.academic_period_id', $student['academic_period_id'])
+            ->where('institution_class_students.institution_id', $student['institution_id'])
             ->whereNull('institution_class_students.deleted_at')
             ->get()->first();
     }
@@ -135,12 +135,12 @@ 
                 'student_status_id' => 1,
                 'created_user_id' => 1
             ]);
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             Log::error($th);
         }
     }
 
-    public static function createOrUpdate($studentId,$params,$file){
+    public static function createOrUpdate($studentId, $params, $file) {
        return  self::create([
             'student_id' => $studentId,
             'institution_class_id' => $params['institution_class']->id,

app/Imports/StudentUpdate.php

Spacing +12 added lines, -12 removed lines

@@ -55,7 +55,7 @@ 
 use Maatwebsite\Excel\Concerns\WithMultipleSheets;
 use Maatwebsite\Excel\Concerns\RegistersEventListeners;
 
-class StudentUpdate extends Import implements  ToModel, WithStartRow, WithHeadingRow, WithMultipleSheets, WithEvents, WithMapping, WithLimit, WithBatchInserts, WithValidation , SkipsOnFailure , SkipsOnError{
+class StudentUpdate extends Import implements  ToModel, WithStartRow, WithHeadingRow, WithMultipleSheets, WithEvents, WithMapping, WithLimit, WithBatchInserts, WithValidation, SkipsOnFailure, SkipsOnError{
 
     use Importable,
         RegistersEventListeners,
@@ -89,30 +89,30 @@ 
             $institution = $institutionClass->institution_id;
             if (!empty($institutionClass)) {
                 $this->setGender($row);
-                $studentInfo = Security_user::createOrUpdateStudentProfile($row,'update',$this->file);
+                $studentInfo = Security_user::createOrUpdateStudentProfile($row, 'update', $this->file);
                 $student = Institution_class_student::where('student_id', '=', $studentInfo->id)->first();
-                if(!empty($row['admission_no'])){
-                    Institution_student::where('student_id','=',$studentInfo->id)
-                    ->where('institution_id','=', $institution)
+                if (!empty($row['admission_no'])) {
+                    Institution_student::where('student_id', '=', $studentInfo->id)
+                    ->where('institution_id', '=', $institution)
                     ->update(['admission_id'=> $row['admission_no']]);
                 }
-                User_special_need::createOrUpdate($studentInfo->id,$row,$this->file);
-                User_body_mass::createOrUpdate($studentInfo->id,$row,$this->file);
+                User_special_need::createOrUpdate($studentInfo->id, $row, $this->file);
+                User_body_mass::createOrUpdate($studentInfo->id, $row, $this->file);
 
-                $this->createOrUpdateGuardian($row,$student,'father');
-                $this->createOrUpdateGuardian($row,$student,'mother');
-                $this->createOrUpdateGuardian($row,$student,'guardian');
+                $this->createOrUpdateGuardian($row, $student, 'father');
+                $this->createOrUpdateGuardian($row, $student, 'mother');
+                $this->createOrUpdateGuardian($row, $student, 'guardian');
 
                 $studentInfo['student_id'] = $studentInfo->id;
                 Institution_student::updateStudentArea($studentInfo->toArray());
-                $this->insertOrUpdateSubjects($row,$student,$institution);
+                $this->insertOrUpdateSubjects($row, $student, $institution);
                 $totalStudents = Institution_class_student::getStudentsCount($this->file['institution_class_id']);
                 Institution_class::where('id', '=', $institutionClass->id)
                         ->update([
                             'total_male_students' => $totalStudents['total_male_students'],
                             'total_female_students' => $totalStudents['total_female_students']]);
             }
-        } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
+        }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
             $failures = $e->failures();
             throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures);