moe-lk / bulk-upload

app/Providers/AppServiceProvider.php

Spacing +1 added lines, -1 removed lines

@@ -28,7 +28,7 @@
      public function boot()
      {
          //
-         if(!(\App::environment('local'))) {
+         if (!(\App::environment('local'))) {
              URL::forceScheme('https');
          }
      }

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/Http/Controllers/FileController.php

Spacing +14 added lines, -14 removed lines

@@ -33,7 +33,7 @@ 
      * @param Request $request
      * @return \Illuminate\Http\JsonResponse
      */
-    public function upload(Request $request){
+    public function upload(Request $request) {
 
 
 
@@ -75,7 +75,7 @@ 
         $institution = auth()->user()->permissions->isEmpty() ? auth()->user()->principal[0]->institution_group[0]->institution->code : auth()->user()->permissions[0]->institution_staff->institution->code;
 
 
-        $fileName = time().'_'.$institution.'_'.str_replace(' ','_', clean($class->name)).'_'.auth()->user()->openemis_no.'_student_bulk_data.xlsx';
+        $fileName = time().'_'.$institution.'_'.str_replace(' ', '_', clean($class->name)).'_'.auth()->user()->openemis_no.'_student_bulk_data.xlsx';
         Storage::disk('local')->putFileAs(
             'sis-bulk-data-files/',
             $uploadFile,
@@ -83,7 +83,7 @@ 
         );
 
         $upload = new Upload;
-        $upload->fileName =$fileName;
+        $upload->fileName = $fileName;
         $upload->model = 'Student';
         $upload->node = 'None';
         $upload->institution_class_id = $class->id;
@@ -94,8 +94,8 @@ 
         return redirect('/')->withSuccess('The file is uploaded, we will process and let you know by your email');
     }
 
-    public function updateQueueWithUnprocessedFiles($id, $action){
-        if($action == 100){
+    public function updateQueueWithUnprocessedFiles($id, $action) {
+        if ($action == 100) {
             DB::table('uploads')
                 ->where('id', $id)
                 ->update(['is_processed' => 0]);
@@ -107,14 +107,14 @@ 
     }
 
 
-    public function downloadTemplate(){
+    public function downloadTemplate() {
         $filename = 'censusNo_className_sis_students_bulk_upload';
         $version = '2007_V2.0.2_20201211.xlsx';
-        $file_path = storage_path() .'/app/public/'. $filename.'_'.$version;;
+        $file_path = storage_path().'/app/public/'.$filename.'_'.$version; ;
         if (file_exists($file_path))
         {
             return Response::download($file_path, Auth::user()->openemis_no.'_'.$filename.$version, [
-                'Content-Length: '. filesize($file_path)
+                'Content-Length: '.filesize($file_path)
             ]);
         }
         else
@@ -128,13 +128,13 @@ 
      * @param $filename
      * @return Processed excel file with error
      */
-    public function downloadErrorFile($filename){
+    public function downloadErrorFile($filename) {
 
-        $file_path = storage_path().'/app/sis-bulk-data-files/processed/'. $filename;
+        $file_path = storage_path().'/app/sis-bulk-data-files/processed/'.$filename;
         if (file_exists($file_path))
         {
             return Response::download($file_path, $filename, [
-                'Content-Length: '. filesize($file_path)
+                'Content-Length: '.filesize($file_path)
             ]);
         }
         else
@@ -144,12 +144,12 @@ 
     }
 
 
-    public function downloadFile($filename){
-        $file_path = storage_path().'/app/sis-bulk-data-files/'. $filename;
+    public function downloadFile($filename) {
+        $file_path = storage_path().'/app/sis-bulk-data-files/'.$filename;
         if (file_exists($file_path))
         {
             return Response::download($file_path, $filename, [
-                'Content-Length: '. filesize($file_path)
+                'Content-Length: '.filesize($file_path)
             ]);
         }
         else

app/Models/Security_user.php

Spacing +23 added lines, -23 removed lines

@@ -204,7 +204,7 @@ 
             $studentData['id'] = $id;
             $this->uniqueUserId->updateOrInsertRecord($studentData);
             return $studentData;
-        } catch (\Exception $th) {
+        }catch (\Exception $th) {
             Log::error($th->getMessage());
             // in case of duplication of the Unique ID this will recursive.
             $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
@@ -225,7 +225,7 @@ 
         $this->uniqueUserId = new Unique_user_id();
         $this->uniqueUId = new UniqueUid();
         // regenerate unique id if it's not available
-        $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ?  $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();
+        $uniqueId = ($this->uniqueUId::isValidUniqueId($sis_student['openemis_no'], 9)) ? $sis_student['openemis_no'] : $this->uniqueUId::getUniqueAlphanumeric();
 
         $studentData = [
             'username' => str_replace('-', '', $uniqueId),
@@ -243,7 +243,7 @@ 
             $studentData['id'] = $sis_student['student_id'];
             $this->uniqueUserId->updateOrInsertRecord($studentData);
             return $studentData;
-        } catch (\Exception $th) {
+        }catch (\Exception $th) {
             Log::error($th);
             // in case of duplication of the Unique ID this will recursive.
             $sis_student['openemis_no'] = $this->uniqueUId::getUniqueAlphanumeric();
@@ -255,9 +255,9 @@ 
     {
         try {
             $uniqueUid = new UniqueUid();
-            $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first();
-            $nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first();
-            $identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first();
+            $BirthArea = Area_administrative::where('name', 'like', '%'.$row['birth_registrar_office_as_in_birth_certificate'].'%')->first();
+            $nationalityId = Nationality::where('name', 'like', '%'.$row['nationality'].'%')->first();
+            $identityType = Identity_type::where('national_code', 'like', '%'.$row['identity_type'].'%')->first();
             
             $date = $row['date_of_birth_yyyy_mm_dd'];
             $identityType = $identityType !== null ? $identityType->id : null;
@@ -289,7 +289,7 @@ 
                     ]);
                 case 'update':
                     if (!is_null($row['student_id'])) {
-                        $studentInfo =  Security_user::where('openemis_no',trim($row['student_id']))->first();
+                        $studentInfo = Security_user::where('openemis_no', trim($row['student_id']))->first();
                         self::query()->where('openemis_no', $row['student_id'])
                             ->update([
                                 'first_name' => $row['full_name'] ? $row['full_name'] : $studentInfo['first_name'], // here we save full name in the column of first name. re reduce breaks of the system.
@@ -310,7 +310,7 @@ 
                     }
                     break;
             }
-        } catch (\Exception $e) {
+        }catch (\Exception $e) {
             dd($e);
         }
     }
@@ -319,48 +319,48 @@ 
     {
         try {
             $uniqueUid = new UniqueUid();
-            $AddressArea = Area_administrative::where('name', 'like', '%' . $row[$prefix . 's_address_area'] . '%')->first();
-            $nationalityId = Nationality::where('name', 'like', '%' . $row[$prefix . 's_nationality'] . '%')->first();
-            $identityType = Identity_type::where('national_code', 'like', '%' . $row[$prefix . 's_identity_type'] . '%')->first();
+            $AddressArea = Area_administrative::where('name', 'like', '%'.$row[$prefix.'s_address_area'].'%')->first();
+            $nationalityId = Nationality::where('name', 'like', '%'.$row[$prefix.'s_nationality'].'%')->first();
+            $identityType = Identity_type::where('national_code', 'like', '%'.$row[$prefix.'s_identity_type'].'%')->first();
             $openemisNo = $uniqueUid::getUniqueAlphanumeric();
 
             $identityType = ($identityType !== null) ? $identityType->id : null;
             $nationalityId = $nationalityId !== null ? $nationalityId->id : null;
 
             $guardian = null;
-            if (!empty($row[$prefix . 's_identity_number'])) {
+            if (!empty($row[$prefix.'s_identity_number'])) {
                 $guardian = Security_user::where('identity_type_id', '=', $nationalityId)
-                    ->where('identity_number', '=', $row[$prefix . 's_identity_number'])->first();
+                    ->where('identity_number', '=', $row[$prefix.'s_identity_number'])->first();
             }
 
             if (is_null($guardian)) {
                 $guardian = self::create([
                     'username' => str_replace('-', '', $openemisNo),
                     'openemis_no' => $openemisNo,
-                    'first_name' => $row[$prefix . 's_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
-                    'last_name' => genNameWithInitials($row[$prefix . 's_full_name']),
+                    'first_name' => $row[$prefix.'s_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
+                    'last_name' => genNameWithInitials($row[$prefix.'s_full_name']),
                     'gender_id' => 1,
-                    'date_of_birth' => $row[$prefix . 's_date_of_birth_yyyy_mm_dd'],
-                    'address' => $row[$prefix . 's_address'],
+                    'date_of_birth' => $row[$prefix.'s_date_of_birth_yyyy_mm_dd'],
+                    'address' => $row[$prefix.'s_address'],
                     'address_area_id' => $AddressArea ? $AddressArea->id : null,
                     'nationality_id' => $nationalityId,
                     'identity_type_id' => $identityType,
-                    'identity_number' => $row[$prefix . 's_identity_number'],
+                    'identity_number' => $row[$prefix.'s_identity_number'],
                     'is_guardian' => 1,
                     'created_user_id' => $file['security_user_id']
                 ]);
 
 
                 $guardian['guardian_relation_id'] = 1;
-                if (array_key_exists($prefix . 's_phone', $row)) {
-                    $father['contact'] = $row[$prefix . 's_phone'];
+                if (array_key_exists($prefix.'s_phone', $row)) {
+                    $father['contact'] = $row[$prefix.'s_phone'];
                     User_contact::createOrUpdate($father, $file['security_user_id']);
                 }
-            } else {
-                Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null,]);
+            }else {
+                Security_user::where('id', $guardian->id)->update(['address_area_id' => $AddressArea ? $AddressArea->id : null, ]);
             }
             return $guardian;
-        } catch (\Exception $e) {
+        }catch (\Exception $e) {
             Log::error($e->getMessage(), [$e]);
         }
     }

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