moe-lk / bulk-upload

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

Spacing +34 added lines, -34 removed lines

@@ -71,7 +71,7 @@ 
     public static function boot()
     {
         parent::boot();
-        self::creating(function ($model) {
+        self::creating(function($model) {
             $model->id = (string) Uuid::generate(4);
             $model->created = now();
         });
@@ -129,9 +129,9 @@ 
                 'institution_students.admission_id'
             )
             ->where('institution_students.institution_id', $institutionGrade['institution_id'])
-            ->where('institution_students.student_status_id',1)
+            ->where('institution_students.student_status_id', 1)
             ->where('institution_students.education_grade_id', $institutionGrade['education_grade_id'])
-            ->where('institution_students.deleted_at',null)
+            ->where('institution_students.deleted_at', null)
             ->where('institution_students.academic_period_id', $academicPeriod->id)->get()->toArray();
     }
 
@@ -144,7 +144,7 @@ 
      */
     public static function createExaminationData($student, $admissionInfo)
     {
-        $student['sp_center'] = gettype((int)$student['sp_center']) == 'integer' ?  $student['sp_center'] : 0;
+        $student['sp_center'] = gettype((int) $student['sp_center']) == 'integer' ? $student['sp_center'] : 0;
         try {
             self::create([
                 'id' => (string) Uuid::generate(4),
@@ -169,7 +169,7 @@ 
                 'created' => now(),
                 'created_user_id' => 1
             ]);
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             Log::error($th);
         }
     }
@@ -183,7 +183,7 @@ 
      */
     public static function updateExaminationData($student, $admissionInfo)
     {
-        $student['sp_center'] = gettype((int)$student['sp_center']) == 'integer' ?  $student['sp_center'] : 0;
+        $student['sp_center'] = gettype((int) $student['sp_center']) == 'integer' ? $student['sp_center'] : 0;
         try {
             self::where([
                 'student_id' => $student['student_id'],
@@ -204,56 +204,56 @@ 
                     'modified_user_id' => 1
                 ]
             );
-        } catch (\Throwable $th) {
+        }catch (\Throwable $th) {
             Log::error($th);
         }
     }
 
-    public static function updateStudentArea(array $student){
-        $father = Student_guardian::where('student_id',$student['student_id'])
-        ->join('security_users as sg','guardian_id', 'sg.id')
-        ->where('guardian_relation_id',1)
+    public static function updateStudentArea(array $student) {
+        $father = Student_guardian::where('student_id', $student['student_id'])
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
+        ->where('guardian_relation_id', 1)
         ->get()->first();
 
-        $mother = Student_guardian::where('student_id',$student['student_id'])
-        ->join('security_users as sg','guardian_id', 'sg.id')
-        ->where('guardian_relation_id',2)
+        $mother = Student_guardian::where('student_id', $student['student_id'])
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
+        ->where('guardian_relation_id', 2)
         ->get()->first();
 
-        $guardian = Student_guardian::where('student_id',$student['student_id'])
-        ->join('security_users as sg','guardian_id', 'sg.id')
-        ->where('guardian_relation_id',3)
+        $guardian = Student_guardian::where('student_id', $student['student_id'])
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
+        ->where('guardian_relation_id', 3)
         ->get()->first();
     
-        if(!is_null($father) && is_null($mother) && is_null($guardian)){
-            Security_user::where('id',$student['student_id'])
+        if (!is_null($father) && is_null($mother) && is_null($guardian)) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $father->address_area_id]);
-        }elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($mother) && (is_null($father) && is_null($guardian))) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($guardian) && is_null($father) && is_null($mother)) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
+        }elseif (!is_null($mother) && !is_null($father) && ($father->address_area_id == $mother->address_area_id)) {
             // dd($father->address_area_id,$mother->address_area_id,$student['student_id']);
-            $d = Security_user::where('id',$student['student_id'])
+            $d = Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($mother) && !is_null($father) && ($father->address_area_id !== $mother->address_area_id) && !is_null($guardian)) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($father) && $father->address == $student['address']){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($father) && $father->address == $student['address']) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($mother) && $mother->address == $student['address']){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($mother) && $mother->address == $student['address']) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($guardian) && $guardian->address == $student['address']){
-            Security_user::where('id',$student['student_id'])
+        }elseif (!is_null($guardian) && $guardian->address == $student['address']) {
+            Security_user::where('id', $student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
         }
     }
 
-    public static function createOrUpdate($studentId,$row,$params,$file){
+    public static function createOrUpdate($studentId, $row, $params, $file) {
         self::create([
             'student_status_id' => 1,
             'student_id' => $studentId,

Braces +7 added lines, -7 removed lines

@@ -228,26 +228,26 @@
         if(!is_null($father) && is_null($mother) && is_null($guardian)){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $father->address_area_id]);
-        }elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
+        } elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
+        } elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
+        } elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
             // dd($father->address_area_id,$mother->address_area_id,$student['student_id']);
             $d = Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
+        } elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($father) && $father->address == $student['address']){
+        } elseif(!is_null($father) && $father->address == $student['address']){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
-        }elseif(!is_null($mother) && $mother->address == $student['address']){
+        } elseif(!is_null($mother) && $mother->address == $student['address']){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $mother->address_area_id]);
-        }elseif(!is_null($guardian) && $guardian->address == $student['address']){
+        } elseif(!is_null($guardian) && $guardian->address == $student['address']){
             Security_user::where('id',$student['student_id'])
             ->update(['address_area_id' => $guardian->address_area_id]);
         }

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();
     }
@@ -134,12 +134,12 @@ 
                 'institution_id' => $admissionInfo['instituion']->id,
                 'student_status_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,