moe-lk / bulk-upload

app/Console/Commands/CloneConfigData.php

Indentation +17 added lines, -17 removed lines

@@ -76,9 +76,9 @@ 
         $this->end_time = microtime(TRUE);
 
 
-       $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
-       $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
-       $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
+        $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
+        $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
+        $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
 
     }
 
@@ -113,13 +113,13 @@ 
                     $this->output->writeln('updating from '. $shiftId);
 
                 }catch (\Exception $e){
-                     Log::error($e->getMessage(),[$e]);
+                        Log::error($e->getMessage(),[$e]);
                 }
             }
 //            DB::commit();
         }catch (\Exception $e){
 //            DB::rollBack();
-             Log::error($e->getMessage(),[$e]);
+                Log::error($e->getMessage(),[$e]);
         }
     }
 
@@ -130,16 +130,16 @@ 
      * @param $academicPeriod
      */
     public function insertInstitutionSubjects($subjects, $count,$academicPeriod){
-       try{
-           $subjects['academic_period_id'] = $academicPeriod->id;
-           $subjects['created'] = now();
-           unset($subjects['total_male_students']);
-           unset($subjects['total_female_students']);
-           unset($subjects['id']);
-           $classSubject = Institution_subject::create($subjects);
-       }catch (\Exception $e){
+        try{
+            $subjects['academic_period_id'] = $academicPeriod->id;
+            $subjects['created'] = now();
+            unset($subjects['total_male_students']);
+            unset($subjects['total_female_students']);
+            unset($subjects['id']);
+            $classSubject = Institution_subject::create($subjects);
+        }catch (\Exception $e){
             Log::error($e->getMessage(),[$e]);
-       }
+        }
     }
 
 
@@ -181,7 +181,7 @@ 
                 $this->insertInstitutionClassSubjects($institutionSubjects,$class);
 //                array_walk($classSubjects,array($this,'insertInstitutionClassSubjects'),$params);
             }catch (\Exception $e){
-                 Log::error($e->getMessage(),[$e]);
+                    Log::error($e->getMessage(),[$e]);
             }
     }
 
@@ -191,7 +191,7 @@ 
                 array_walk($subjects,array($this,'insertClassSubjects'),$class);
                 $this->output->writeln('updating subjects '. $class->name);
             }catch (\Exception $e){
-                 Log::error($e->getMessage(),[$e]);
+                    Log::error($e->getMessage(),[$e]);
             }
         };
     }
@@ -209,7 +209,7 @@ 
                 $this->institution_class_subjects->create($subjectobj);
             }
         }catch (\Exception $e){
-             Log::error($e->getMessage(),[$e]);
+                Log::error($e->getMessage(),[$e]);
         }
     }
 

app/Console/Commands/ImportStudents.php

Indentation +19 added lines, -19 removed lines

@@ -286,8 +286,8 @@ 
 
 
     protected function getSheetCount($file){
-       $objPHPExcel = $this->setReader($file);
-       return $objPHPExcel->getSheetCount();
+        $objPHPExcel = $this->setReader($file);
+        return $objPHPExcel->getSheetCount();
     }
 
 
@@ -298,8 +298,8 @@ 
      * @param $column
      */
     protected function import($file, $sheet, $column){
-             try {
-                 ini_set('memory_limit', '2048M');
+                try {
+                    ini_set('memory_limit', '2048M');
                 $this->getFileSize($file);
                 $user = User::find($file['security_user_id']);
                 $excelFile = '/sis-bulk-data-files/' . $file['filename'];
@@ -360,23 +360,23 @@ 
                         break;
                 }
             }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
-                 $this->output->writeln( $e->getMessage());
-                 if($sheet == 1){
-                     self::writeErrors($e,$file,'Insert Students');
-                     DB::table('uploads')
-                         ->where('id', $file['id'])
-                         ->update(['insert' => 2,'updated_at' => now()]);
+                    $this->output->writeln( $e->getMessage());
+                    if($sheet == 1){
+                        self::writeErrors($e,$file,'Insert Students');
+                        DB::table('uploads')
+                            ->where('id', $file['id'])
+                            ->update(['insert' => 2,'updated_at' => now()]);
                     $this->processFailedEmail($file,$user,'Fresh Student Data Upload:Failed');
-                 }else if($sheet == 2){
-                     self::writeErrors($e,$file,'Update Students');
-                     DB::table('uploads')
-                         ->where('id', $file['id'])
-                         ->update(['update' => 2,'updated_at' => now()]);
+                    }else if($sheet == 2){
+                        self::writeErrors($e,$file,'Update Students');
+                        DB::table('uploads')
+                            ->where('id', $file['id'])
+                            ->update(['update' => 2,'updated_at' => now()]);
                     $this->processFailedEmail($file,$user, 'Existing Student Data Update:Failed');
-                 }
-                 DB::table('uploads')
-                     ->where('id',  $file['id'])
-                     ->update(['is_processed' =>2 , 'updated_at' => now()]);
+                    }
+                    DB::table('uploads')
+                        ->where('id',  $file['id'])
+                        ->update(['is_processed' =>2 , 'updated_at' => now()]);
 
             }
 

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/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();
     }
 
     /**

app/Models/Institution_subject_student.php

Indentation +5 added lines, -5 removed lines

@@ -71,21 +71,21 @@
      */
     public static function  isDuplicated($inputs){
 
-       $exists = self::where('student_id','=',$inputs['student_id'])
-           ->where('institution_subject_id','=',$inputs['institution_subject_id'])
-           ->where('education_subject_id','=',$inputs['education_subject_id'])->count();
+        $exists = self::where('student_id','=',$inputs['student_id'])
+            ->where('institution_subject_id','=',$inputs['institution_subject_id'])
+            ->where('education_subject_id','=',$inputs['education_subject_id'])->count();
 
 
         return $exists ? true :false;
     }
 
     
-     public function student(){
+        public function student(){
         return $this->belongsTo('App\Models\Security_user','student_id');
     }
     
     public static function getStudentsCount(){
-         $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) {
                     $query->where('gender_id', '=', 1);

app/Models/Security_user.php

Indentation +3 added lines, -3 removed lines

@@ -23,7 +23,7 @@ 
     protected $table = 'security_users';
 
     protected $appends = [
-      'special_need_name'
+        'special_need_name'
     ];
 
     /**
@@ -104,7 +104,7 @@ 
 
 
 
-   public function rules()
+    public function rules()
     {
         return [
                 'identity_number' => [
@@ -126,7 +126,7 @@ 
     }
 
     public function uploads(){
-       return $this->hasMany('App\Models\Upload');
+        return $this->hasMany('App\Models\Upload');
     }
 
     public function class(){

app/Models/Institution_shift.php

Indentation +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
     protected $dates = ['modified', 'created'];
 
     public function shiftExists($shift){
-       return self::query()
+        return self::query()
             ->where('institution_id',$shift['institution_id'])
             ->where('location_institution_id',$shift['location_institution_id'])
             ->where('shift_option_id',$shift['shift_option_id'])

app/Models/User_special_need.php

Indentation +4 added lines, -4 removed lines

@@ -42,11 +42,11 @@
     protected $dates = ['special_need_date', 'modified', 'created'];
     
     
-     public static function  isDuplicated($inputs){
+        public static function  isDuplicated($inputs){
 
-       $exists = self::where('security_user_id','=',$inputs['security_user_id'])
-           ->where('special_need_type_id','=',$inputs['special_need_type_id'])
-           ->where('special_need_difficulty_id','=',$inputs['special_need_difficulty_id'])->count();
+        $exists = self::where('security_user_id','=',$inputs['security_user_id'])
+            ->where('special_need_type_id','=',$inputs['special_need_type_id'])
+            ->where('special_need_difficulty_id','=',$inputs['special_need_difficulty_id'])->count();
 
 //       dd($exists);
         return $exists == 0 ? true :false;

app/Models/Institution.php

Indentation +1 added lines, -1 removed lines

@@ -42,7 +42,7 @@
     protected $dates = ['date_opened', 'date_closed', 'modified', 'created'];
 
     public function isActive($id){
-       return  self::query()->find($id)->get()->first()->institution_status_id == 1;
+        return  self::query()->find($id)->get()->first()->institution_status_id == 1;
     }
 
 }