Test Setup Failed
Pull Request — master (#651)
by Mohamed
08:18
created
app/Console/Commands/ImportStudents.php 2 patches
Spacing   +54 added lines, -54 removed lines patch added patch discarded remove patch
@@ -47,7 +47,7 @@  discard block
 block discarded – undo
47 47
      */
48 48
     public function __construct()
49 49
     {
50
-        $this->output =  new \Symfony\Component\Console\Output\ConsoleOutput();
50
+        $this->output = new \Symfony\Component\Console\Output\ConsoleOutput();
51 51
         parent::__construct();
52 52
     }
53 53
 
@@ -69,18 +69,18 @@  discard block
 block discarded – undo
69 69
                         $this->process($files);
70 70
                         unset($files);
71 71
                         exit();
72
-                    } else {
72
+                    }else {
73 73
                         $output = new \Symfony\Component\Console\Output\ConsoleOutput();
74 74
                         $this->output->writeln('No files found,Waiting for files');
75 75
                         exit();
76 76
                     }
77
-                } catch (Exception $e) {
77
+                }catch (Exception $e) {
78 78
                     $output = new \Symfony\Component\Console\Output\ConsoleOutput();
79 79
                     $this->output->writeln($e);
80 80
                     sleep(300);
81 81
                     $this->handle();
82 82
                 }
83
-            } else {
83
+            }else {
84 84
                 exit();
85 85
             }
86 86
         }
@@ -95,7 +95,7 @@  discard block
 block discarded – undo
95 95
         $files[0]['node'] = $node;
96 96
         $this->processSheet($files[0]);
97 97
         $now = Carbon::now()->tz('Asia/Colombo');
98
-        $this->output->writeln('=============== Time taken to batch ' . $now->diffInMinutes($time));
98
+        $this->output->writeln('=============== Time taken to batch '.$now->diffInMinutes($time));
99 99
     }
100 100
 
101 101
     protected function getTerminatedFiles()
@@ -138,10 +138,10 @@  discard block
 block discarded – undo
138 138
             ->join('contact_types', 'user_contacts.contact_type_id', '=', 'contact_types.id')
139 139
        
140 140
             ;
141
-            if(env('APP_ENV') == 'stage'){
141
+            if (env('APP_ENV') == 'stage') {
142 142
                 $query->where('contact_types.contact_option_id', '=', 5)
143 143
                 ->where('contact_types.name', '=', 'TestEmail');
144
-            }else{
144
+            }else {
145 145
                 $query->where('contact_types.contact_option_id', '!=', 5);
146 146
             }
147 147
             
@@ -171,13 +171,13 @@  discard block
 block discarded – undo
171 171
     public function processSuccessEmail($file, $user, $subject)
172 172
     {
173 173
         $file['subject'] = $subject;
174
-        $this->output->writeln('Processing the file: ' . $file['filename']);
174
+        $this->output->writeln('Processing the file: '.$file['filename']);
175 175
         try {
176 176
             Mail::to($user->email)->send(new StudentImportSuccess($file));
177 177
             DB::table('uploads')
178 178
                 ->where('id', $file['id'])
179 179
                 ->update(['is_processed' => 1, 'is_email_sent' => 1, 'updated_at' => now()]);
180
-        } catch (\Exception $ex) {
180
+        }catch (\Exception $ex) {
181 181
             $this->output->writeln($ex->getMessage());
182 182
             DB::table('uploads')
183 183
                 ->where('id', $file['id'])
@@ -193,7 +193,7 @@  discard block
 block discarded – undo
193 193
             DB::table('uploads')
194 194
                 ->where('id', $file['id'])
195 195
                 ->update(['is_processed' => 2, 'is_email_sent' => 1, 'updated_at' => now()]);
196
-        } catch (\Exception $ex) {
196
+        }catch (\Exception $ex) {
197 197
             $this->output->writeln($ex->getMessage());
198 198
             DB::table('uploads')
199 199
                 ->where('id', $file['id'])
@@ -209,7 +209,7 @@  discard block
 block discarded – undo
209 209
             DB::table('uploads')
210 210
                 ->where('id', $file['id'])
211 211
                 ->update(['is_processed' => 2, 'is_email_sent' => 1, 'updated_at' => now()]);
212
-        } catch (\Exception $ex) {
212
+        }catch (\Exception $ex) {
213 213
             $this->output->writeln($ex->getMessage());
214 214
             DB::table('uploads')
215 215
                 ->where('id', $file['id'])
@@ -222,9 +222,9 @@  discard block
 block discarded – undo
222 222
         $node = $this->argument('node');
223 223
         if ($node == $file['node']) {
224 224
             $output = new \Symfony\Component\Console\Output\ConsoleOutput();
225
-            $this->output->writeln('Processing from:' . $node);
225
+            $this->output->writeln('Processing from:'.$node);
226 226
             return true;
227
-        } else {
227
+        }else {
228 228
             exit;
229 229
             return false;
230 230
         }
@@ -236,20 +236,20 @@  discard block
 block discarded – undo
236 236
         $user = User::find($file['security_user_id']);
237 237
         $this->checkNode($file);
238 238
         $this->output->writeln('##########################################################################################################################');
239
-        $this->output->writeln('Processing the file: ' . $file['filename']);
239
+        $this->output->writeln('Processing the file: '.$file['filename']);
240 240
         if ($this->checkTime()) {
241 241
             try {
242 242
                 $this->import($file, 1, 'C');
243 243
                 sleep(10);
244 244
                 $this->import($file, 2, 'B');
245
-            } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
245
+            }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
246 246
                 $this->output->writeln($e->getMessage());
247 247
                 try {
248 248
                     Mail::to($user->email)->send(new IncorrectTemplate($file));
249 249
                     DB::table('uploads')
250 250
                         ->where('id', $file['id'])
251 251
                         ->update(['is_processed' => 2, 'is_email_sent' => 1, 'updated_at' => now()]);
252
-                } catch (\Exception $ex) {
252
+                }catch (\Exception $ex) {
253 253
                     $this->output->writeln($e->getMessage());
254 254
                     $this->handle();
255 255
                     DB::table('uploads')
@@ -257,15 +257,15 @@  discard block
 block discarded – undo
257 257
                         ->update(['is_processed' => 2, 'is_email_sent' => 2, 'updated_at' => now()]);
258 258
                 }
259 259
             }
260
-        } else {
260
+        }else {
261 261
             exit();
262 262
         }
263 263
     }
264 264
 
265 265
     protected function getType($file)
266 266
     {
267
-        $file =  storage_path() . '/app/sis-bulk-data-files/' . $file;
268
-        $inputFileType =  \PhpOffice\PhpSpreadsheet\IOFactory::identify($file);
267
+        $file = storage_path().'/app/sis-bulk-data-files/'.$file;
268
+        $inputFileType = \PhpOffice\PhpSpreadsheet\IOFactory::identify($file);
269 269
         return $inputFileType;
270 270
     }
271 271
 
@@ -323,7 +323,7 @@  discard block
 block discarded – undo
323 323
             ini_set('memory_limit', '2048M');
324 324
             $this->getFileSize($file);
325 325
             $user = User::find($file['security_user_id']);
326
-            $excelFile = '/sis-bulk-data-files/' . $file['filename'];
326
+            $excelFile = '/sis-bulk-data-files/'.$file['filename'];
327 327
             $this->higestRow = $this->getHigestRow($file, $sheet, $column);
328 328
             switch ($sheet) {
329 329
                 case 1;
@@ -342,14 +342,14 @@  discard block
 block discarded – undo
342 342
                                 ->update(['insert' => 3, 'updated_at' => now()]);
343 343
                             $this->processFailedEmail($file, $user, 'Fresh Student Data Upload:Partial Success ');
344 344
                             $this->stdOut('Insert Students', $this->higestRow);
345
-                        } else {
345
+                        }else {
346 346
                             DB::table('uploads')
347 347
                             ->where('id', $file['id'])
348 348
                             ->update(['insert' => 1, 'updated_at' => now()]);
349 349
                             $this->processSuccessEmail($file, $user, 'Fresh Student Data Upload:Success ');
350 350
                             $this->stdOut('Insert Students', $this->higestRow);
351 351
                         }
352
-                    } else if (($this->getSheetName($file, 'Insert Students')) && $this->higestRow > 0) {
352
+                    }else if (($this->getSheetName($file, 'Insert Students')) && $this->higestRow > 0) {
353 353
                         DB::table('uploads')
354 354
                             ->where('id', $file['id'])
355 355
                             ->update(['is_processed' => 2]);
@@ -368,14 +368,14 @@  discard block
 block discarded – undo
368 368
                                 ->update(['update' => 3, 'is_processed' => 1, 'updated_at' => now()]);
369 369
                             $this->processFailedEmail($file, $user, 'Existing Student Data Update:Partial Success ');
370 370
                             $this->stdOut('Update Students', $this->higestRow);
371
-                        } else {
371
+                        }else {
372 372
                             DB::table('uploads')
373 373
                             ->where('id', $file['id'])
374 374
                             ->update(['update' => 1, 'is_processed' => 1, 'updated_at' => now()]);
375 375
                             $this->processSuccessEmail($file, $user, 'Existing Student Data Update:Success ');
376 376
                             $this->stdOut('Update Students', $this->higestRow);
377 377
                         }
378
-                    } else if (($this->getSheetName($file, 'Update Students')) && $this->higestRow == 0) {
378
+                    }else if (($this->getSheetName($file, 'Update Students')) && $this->higestRow == 0) {
379 379
                         DB::table('uploads')
380 380
                             ->where('id', $file['id'])
381 381
                             ->update(['is_processed' => 2, 'updated_at' => now()]);
@@ -383,7 +383,7 @@  discard block
 block discarded – undo
383 383
                     }
384 384
                     break;
385 385
             }
386
-        } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
386
+        }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
387 387
             $this->output->writeln($e->getMessage());
388 388
             if ($sheet == 1) {
389 389
                 self::writeErrors($e, $file, 'Insert Students');
@@ -391,7 +391,7 @@  discard block
 block discarded – undo
391 391
                     ->where('id', $file['id'])
392 392
                     ->update(['insert' => 2, 'updated_at' => now()]);
393 393
                 $this->processFailedEmail($file, $user, 'Fresh Student Data Upload:Failed');
394
-            } else if ($sheet == 2) {
394
+            }else if ($sheet == 2) {
395 395
                 self::writeErrors($e, $file, 'Update Students');
396 396
                 DB::table('uploads')
397 397
                     ->where('id', $file['id'])
@@ -399,7 +399,7 @@  discard block
 block discarded – undo
399 399
                 $this->processFailedEmail($file, $user, 'Existing Student Data Update:Failed');
400 400
             }
401 401
             DB::table('uploads')
402
-                ->where('id',  $file['id'])
402
+                ->where('id', $file['id'])
403 403
                 ->update(['is_processed' => 2, 'updated_at' => now()]);
404 404
         }
405 405
     }
@@ -417,14 +417,14 @@  discard block
 block discarded – undo
417 417
 
418 418
     protected function  getFileSize($file)
419 419
     {
420
-        $excelFile =  '/sis-bulk-data-files/' . $file['filename'];
420
+        $excelFile = '/sis-bulk-data-files/'.$file['filename'];
421 421
         $size = Storage::disk('local')->size($excelFile);
422 422
         $user = User::find($file['security_user_id']);
423 423
         if ($size > 0) {
424 424
             return true;
425
-        } else {
425
+        }else {
426 426
             DB::table('uploads')
427
-                ->where('id',  $file['id'])
427
+                ->where('id', $file['id'])
428 428
                 ->update(['is_processed' => 2, 'updated_at' => now()]);
429 429
             $this->stdOut('No valid data found :Please re-upload the file', 0);
430 430
             $this->processEmptyEmail($file, $user, 'No valid data found :Please re-upload the file');
@@ -434,21 +434,21 @@  discard block
 block discarded – undo
434 434
     protected function setReader($file)
435 435
     {
436 436
         try {
437
-            $excelFile =  '/sis-bulk-data-files/processed/' . $file['filename'];
437
+            $excelFile = '/sis-bulk-data-files/processed/'.$file['filename'];
438 438
             $exists = Storage::disk('local')->exists($excelFile);
439 439
             if (!$exists) {
440 440
 
441
-                $excelFile =  "/sis-bulk-data-files/" . $file['filename'];
441
+                $excelFile = "/sis-bulk-data-files/".$file['filename'];
442 442
             }
443
-            $excelFile = storage_path() . "/app" . $excelFile;
443
+            $excelFile = storage_path()."/app".$excelFile;
444 444
             $reader = \PhpOffice\PhpSpreadsheet\IOFactory::createReader($this->getType($file['filename']));
445
-            $objPHPExcel =  $reader->load($excelFile);
445
+            $objPHPExcel = $reader->load($excelFile);
446 446
             return $objPHPExcel;
447
-        } catch (Exception $e) {
447
+        }catch (Exception $e) {
448 448
             $this->output->writeln($e->getMessage());
449 449
             $user = User::find($file['security_user_id']);
450 450
             DB::table('uploads')
451
-                ->where('id',  $file['id'])
451
+                ->where('id', $file['id'])
452 452
                 ->update(['is_processed' => 2, 'updated_at' => now()]);
453 453
             $this->stdOut('No valid data found :Please re-upload the file', 0);
454 454
             $this->processEmptyEmail($file, $user, 'No valid data found :Please re-upload the file');
@@ -459,12 +459,12 @@  discard block
 block discarded – undo
459 459
     {
460 460
         try {;
461 461
             $objPHPExcel = $this->setReader($file);
462
-            return $objPHPExcel->getSheetByName($sheet)  !== null;
463
-        } catch (Exception $e) {
462
+            return $objPHPExcel->getSheetByName($sheet) !== null;
463
+        }catch (Exception $e) {
464 464
             $this->output->writeln($e->getMessage());
465 465
             $user = User::find($file['security_user_id']);
466 466
             DB::table('uploads')
467
-                ->where('id',  $file['id'])
467
+                ->where('id', $file['id'])
468 468
                 ->update(['is_processed' => 2, 'updated_at' => now()]);
469 469
             $this->stdOut('No valid data found :Please re-upload the file', 0);
470 470
             $this->processEmptyEmail($file, $user, 'No valid data found :Please re-upload the file');
@@ -477,17 +477,17 @@  discard block
 block discarded – undo
477 477
             $reader = $this->setReader($file);
478 478
             $reader->setActiveSheetIndex($sheet);
479 479
             $higestRow = 0;
480
-            $highestRow =  $reader->getActiveSheet()->getHighestRow($column);
480
+            $highestRow = $reader->getActiveSheet()->getHighestRow($column);
481 481
             for ($row = 3; $row <= $highestRow; $row++) {
482
-                $rowData = $reader->getActiveSheet()->getCell($column . $row)->getValue();
482
+                $rowData = $reader->getActiveSheet()->getCell($column.$row)->getValue();
483 483
                 if (empty($rowData) || $rowData == null) {
484 484
                     continue;
485
-                } else {
485
+                }else {
486 486
                     $higestRow += 1;
487 487
                 }
488 488
             }
489 489
             return $higestRow;
490
-        } catch (\Exception $e) {
490
+        }catch (\Exception $e) {
491 491
             $this->output->writeln($e->getMessage());
492 492
             $user = User::find($file['security_user_id']);
493 493
             DB::beginTransaction();
@@ -502,10 +502,10 @@  discard block
 block discarded – undo
502 502
 
503 503
     protected function stdOut($title, $rows)
504 504
     {
505
-        $this->output->writeln($title . ' Process completed at . ' . ' ' . now());
505
+        $this->output->writeln($title.' Process completed at . '.' '.now());
506 506
         $now = Carbon::now()->tz('Asia/Colombo');
507
-        $this->output->writeln('Total Processed lines: ' . $rows);
508
-        $this->output->writeln('Time taken to process           : ' .   $now->diffInSeconds($this->startTime) . ' Seconds');
507
+        $this->output->writeln('Total Processed lines: '.$rows);
508
+        $this->output->writeln('Time taken to process           : '.$now->diffInSeconds($this->startTime).' Seconds');
509 509
         $this->output->writeln('--------------------------------------------------------------------------------------------------------------------------');
510 510
     }
511 511
 
@@ -517,7 +517,7 @@  discard block
 block discarded – undo
517 517
         $sheet = $reader->getActiveSheet();
518 518
         if (!in_array($row, $params['rows'])) {
519 519
             $output = new \Symfony\Component\Console\Output\ConsoleOutput();
520
-            $this->output->writeln(' removing row . ' . ' ' . $row);
520
+            $this->output->writeln(' removing row . '.' '.$row);
521 521
             $reader->getActiveSheet()->getCellCollection()->removeRow($row);
522 522
         }
523 523
     }
@@ -543,7 +543,7 @@  discard block
 block discarded – undo
543 543
             if (count($failures) > 0) {
544 544
                 $rows = array_map('rows', $failures);
545 545
                 $rows = array_unique($rows);
546
-                $rowIndex =   range(3, $this->higestRow + 2);
546
+                $rowIndex = range(3, $this->higestRow + 2);
547 547
                 $params = [
548 548
                     'rows' => $rows,
549 549
                     'reader' => $reader
@@ -552,17 +552,17 @@  discard block
 block discarded – undo
552 552
                 array_walk($rowIndex, array($this, 'removeRows'), $params);
553 553
                 $objWriter = $this->getSheetWriter($file, $reader);
554 554
                 Storage::disk('local')->makeDirectory('sis-bulk-data-files/processed');
555
-                $objWriter->save(storage_path() . '/app/sis-bulk-data-files/processed/' . $file['filename']);
555
+                $objWriter->save(storage_path().'/app/sis-bulk-data-files/processed/'.$file['filename']);
556 556
                 $now = Carbon::now()->tz('Asia/Colombo');
557
-                $this->output->writeln($reader->getActiveSheet()->getTitle() . ' Process completed at . ' . ' ' . now());
558
-                $this->output->writeln('memory usage for the processes : ' . (memory_get_usage() - $baseMemory));
559
-                $this->output->writeln('Time taken to process           : ' .   $now->diffInSeconds($this->startTime) . ' Seconds');
560
-                $this->output->writeln(' errors reported               : ' . count($failures));
557
+                $this->output->writeln($reader->getActiveSheet()->getTitle().' Process completed at . '.' '.now());
558
+                $this->output->writeln('memory usage for the processes : '.(memory_get_usage() - $baseMemory));
559
+                $this->output->writeln('Time taken to process           : '.$now->diffInSeconds($this->startTime).' Seconds');
560
+                $this->output->writeln(' errors reported               : '.count($failures));
561 561
                 $this->output->writeln('--------------------------------------------------------------------------------------------------------------------------');
562 562
                 unset($objWriter);
563 563
                 unset($failures);
564 564
             }
565
-        } catch (Eception $e) {
565
+        }catch (Eception $e) {
566 566
             $this->output->writeln($e->getMessage());
567 567
             $user = User::find($file['security_user_id']);
568 568
             DB::beginTransaction();
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -141,7 +141,7 @@
 block discarded – undo
141 141
             if(env('APP_ENV') == 'stage'){
142 142
                 $query->where('contact_types.contact_option_id', '=', 5)
143 143
                 ->where('contact_types.name', '=', 'TestEmail');
144
-            }else{
144
+            } else{
145 145
                 $query->where('contact_types.contact_option_id', '!=', 5);
146 146
             }
147 147
             
Please login to merge, or discard this patch.
app/Imports/StudentUpdate.php 2 patches
Indentation   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -164,7 +164,7 @@
 block discarded – undo
164 164
                 if(!empty($row['admission_no'])){
165 165
                     Institution_student::where('student_id','=',$studentInfo->id)
166 166
                     ->where('institution_id','=', $institution)
167
-                   // ->where('academic_period_id','=',$academicPeriod->id)
167
+                    // ->where('academic_period_id','=',$academicPeriod->id)
168 168
                     ->update(['admission_id'=> $row['admission_no']]);
169 169
                 }
170 170
                 if (!empty($row['special_need'])) {
Please login to merge, or discard this patch.
Spacing   +38 added lines, -38 removed lines patch added patch discarded remove patch
@@ -55,7 +55,7 @@  discard block
 block discarded – undo
55 55
 use Maatwebsite\Excel\Concerns\WithMultipleSheets;
56 56
 use Maatwebsite\Excel\Concerns\RegistersEventListeners;
57 57
 
58
-class StudentUpdate extends Import implements  ToModel, WithStartRow, WithHeadingRow, WithMultipleSheets, WithEvents, WithMapping, WithLimit, WithBatchInserts, WithValidation , SkipsOnFailure , SkipsOnError{
58
+class StudentUpdate extends Import implements  ToModel, WithStartRow, WithHeadingRow, WithMultipleSheets, WithEvents, WithMapping, WithLimit, WithBatchInserts, WithValidation, SkipsOnFailure, SkipsOnError{
59 59
 
60 60
     use Importable,
61 61
         RegistersEventListeners,
@@ -110,9 +110,9 @@  discard block
 block discarded – undo
110 110
                         break;
111 111
                 }
112 112
 
113
-                $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')->first();
114
-                $nationalityId = Nationality::where('name', 'like', '%' . $row['nationality'] . '%')->first();
115
-                $identityType = Identity_type::where('national_code', 'like', '%' . $row['identity_type'] . '%')->first();
113
+                $BirthArea = Area_administrative::where('name', 'like', '%'.$row['birth_registrar_office_as_in_birth_certificate'].'%')->first();
114
+                $nationalityId = Nationality::where('name', 'like', '%'.$row['nationality'].'%')->first();
115
+                $identityType = Identity_type::where('national_code', 'like', '%'.$row['identity_type'].'%')->first();
116 116
                 //$academicPeriod = Academic_period::where('name', '=', $institutionClass->academic_period_id)->first();
117 117
                 //$academicPeriod = Academic_period::where('name', '=',$row['academic_period'])->first();
118 118
 
@@ -161,9 +161,9 @@  discard block
 block discarded – undo
161 161
                     ->update(['admission_id'=> $row['admission_no']]);
162 162
                 }*/
163 163
 
164
-                if(!empty($row['admission_no'])){
165
-                    Institution_student::where('student_id','=',$studentInfo->id)
166
-                    ->where('institution_id','=', $institution)
164
+                if (!empty($row['admission_no'])) {
165
+                    Institution_student::where('student_id', '=', $studentInfo->id)
166
+                    ->where('institution_id', '=', $institution)
167 167
                    // ->where('academic_period_id','=',$academicPeriod->id)
168 168
                     ->update(['admission_id'=> $row['admission_no']]);
169 169
                 }
@@ -189,17 +189,17 @@  discard block
 block discarded – undo
189 189
                 if (!empty($row['bmi_height']) && (!empty($row['bmi_weight']))) {
190 190
 
191 191
                     // convert Meeter to CM
192
-                    $hight = $row['bmi_height'] / 100;
192
+                    $hight = $row['bmi_height']/100;
193 193
 
194 194
                     //calculate BMI
195
-                    $bodyMass = ($row['bmi_weight']) / pow($hight, 2);
195
+                    $bodyMass = ($row['bmi_weight'])/pow($hight, 2);
196 196
 
197 197
                     $bmiAcademic = Academic_period::where('name', '=', $row['bmi_academic_period'])->first();
198
-                    $count = User_body_mass::where('academic_period_id' ,'=',$bmiAcademic->id )
199
-                            ->where('security_user_id','=',$student->student_id)->count();
198
+                    $count = User_body_mass::where('academic_period_id', '=', $bmiAcademic->id)
199
+                            ->where('security_user_id', '=', $student->student_id)->count();
200 200
 
201 201
                     \Log::debug('User_body_mass');
202
-                    if(!($count > 0)){
202
+                    if (!($count > 0)) {
203 203
                         User_body_mass::create([
204 204
                             'height' => $row['bmi_height'],
205 205
                             'weight' => $row['bmi_weight'],
@@ -213,10 +213,10 @@  discard block
 block discarded – undo
213 213
                 }
214 214
 
215 215
                 if (!empty($row['fathers_full_name']) && ($row['fathers_date_of_birth_yyyy_mm_dd'] !== null)) {
216
-                    $AddressArea = Area_administrative::where('name', 'like', '%' . $row['fathers_address_area'] . '%')->first();
217
-                    $nationalityId = Nationality::where('name', 'like', '%' . $row['fathers_nationality'] . '%')->first();
218
-                    $identityType = Identity_type::where('national_code', 'like', '%' . $row['fathers_identity_type'] . '%')->first();
219
-                    $openemisFather =  $this->uniqueUid::getUniqueAlphanumeric();
216
+                    $AddressArea = Area_administrative::where('name', 'like', '%'.$row['fathers_address_area'].'%')->first();
217
+                    $nationalityId = Nationality::where('name', 'like', '%'.$row['fathers_nationality'].'%')->first();
218
+                    $identityType = Identity_type::where('national_code', 'like', '%'.$row['fathers_identity_type'].'%')->first();
219
+                    $openemisFather = $this->uniqueUid::getUniqueAlphanumeric();
220 220
 
221 221
                     $identityType = ($identityType !== null) ? $identityType->id : null;
222 222
                     $nationalityId = $nationalityId !== null ? $nationalityId->id : null;
@@ -230,7 +230,7 @@  discard block
 block discarded – undo
230 230
 
231 231
                     if ($father === null) {
232 232
                         $data = [
233
-                            'username' => str_replace('-','',$openemisFather),
233
+                            'username' => str_replace('-', '', $openemisFather),
234 234
                             'openemis_no' => $openemisFather,
235 235
                             'first_name' => $row['fathers_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
236 236
                             'last_name' => genNameWithInitials($row['fathers_full_name']),
@@ -249,25 +249,25 @@  discard block
 block discarded – undo
249 249
                         $father['guardian_relation_id'] = 1;
250 250
                         if (array_key_exists('fathers_phone', $row)) {
251 251
                             $father['contact'] = $row['fathers_phone'];
252
-                            User_contact::createOrUpdate($father,$this->file['security_user_id']);
252
+                            User_contact::createOrUpdate($father, $this->file['security_user_id']);
253 253
                         }
254 254
                         Student_guardian::createStudentGuardian($student, $father, $this->file['security_user_id']);
255
-                    } else {
255
+                    }else {
256 256
                         Security_user::where('id', '=', $father->id)
257 257
                                 ->update(['is_guardian' => 1]);
258 258
                         $father['guardian_relation_id'] = 1;
259 259
                         if (array_key_exists('fathers_phone', $row)) {
260 260
                             $father['contact'] = $row['fathers_phone'];
261
-                            User_contact::createOrUpdate($father,$this->file['security_user_id']);
261
+                            User_contact::createOrUpdate($father, $this->file['security_user_id']);
262 262
                         }
263 263
                         Student_guardian::createStudentGuardian($student, $father, $this->file['security_user_id']);
264 264
                     }
265 265
                 }
266 266
 
267 267
                 if (!empty($row['mothers_full_name']) && ($row['mothers_date_of_birth_yyyy_mm_dd'] !== null)) {
268
-                    $AddressArea = Area_administrative::where('name', 'like', '%' . $row['mothers_address_area'] . '%')->first();
269
-                    $nationalityId = Nationality::where('name', 'like', '%' . $row['mothers_nationality'] . '%')->first();
270
-                    $identityType = Identity_type::where('national_code', 'like', '%' . $row['mothers_identity_type'] . '%')->first();
268
+                    $AddressArea = Area_administrative::where('name', 'like', '%'.$row['mothers_address_area'].'%')->first();
269
+                    $nationalityId = Nationality::where('name', 'like', '%'.$row['mothers_nationality'].'%')->first();
270
+                    $identityType = Identity_type::where('national_code', 'like', '%'.$row['mothers_identity_type'].'%')->first();
271 271
                     $openemisMother = $this->uniqueUid::getUniqueAlphanumeric();
272 272
 
273 273
                     $identityType = $identityType !== null ? $identityType->id : null;
@@ -282,7 +282,7 @@  discard block
 block discarded – undo
282 282
 
283 283
                     if ($mother === null) {
284 284
                         $mother = Security_user::create([
285
-                                    'username' => str_replace('-','',$openemisMother),
285
+                                    'username' => str_replace('-', '', $openemisMother),
286 286
                                     'openemis_no' => $openemisMother,
287 287
                                     'first_name' => $row['mothers_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
288 288
                                     'last_name' => genNameWithInitials($row['mothers_full_name']),
@@ -300,16 +300,16 @@  discard block
 block discarded – undo
300 300
                         $mother['guardian_relation_id'] = 2;
301 301
                         if (array_key_exists('mothers_phone', $row)) {
302 302
                             $mother['contact'] = $row['mothers_phone'];
303
-                            User_contact::createOrUpdate($mother,$this->file['security_user_id']);
303
+                            User_contact::createOrUpdate($mother, $this->file['security_user_id']);
304 304
                         }
305 305
                         Student_guardian::createStudentGuardian($student, $mother, $this->file['security_user_id']);
306
-                    } else {
306
+                    }else {
307 307
                         Security_user::where('id', '=', $mother->id)
308 308
                                 ->update(['is_guardian' => 1]);
309 309
                         $mother['guardian_relation_id'] = 2;
310 310
                         if (array_key_exists('mothers_phone', $row)) {
311 311
                             $mother['contact'] = $row['mothers_phone'];
312
-                            User_contact::createOrUpdate($mother,$this->file['security_user_id']);
312
+                            User_contact::createOrUpdate($mother, $this->file['security_user_id']);
313 313
                         }
314 314
                         Student_guardian::createStudentGuardian($student, $mother, $this->file['security_user_id']);
315 315
                     }
@@ -318,9 +318,9 @@  discard block
 block discarded – undo
318 318
 
319 319
                 if (!empty($row['guardians_full_name']) && ($row['guardians_date_of_birth_yyyy_mm_dd'] !== null)) {
320 320
                     $genderId = $row['guardians_gender_mf'] == 'M' ? 1 : 2;
321
-                    $AddressArea = Area_administrative::where('name', 'like', '%' . $row['guardians_address_area'] . '%')->first();
322
-                    $nationalityId = Nationality::where('name', 'like', '%' . $row['guardians_nationality'] . '%')->first();
323
-                    $identityType = Identity_type::where('national_code', 'like', '%' . $row['guardians_identity_type'] . '%')->first();
321
+                    $AddressArea = Area_administrative::where('name', 'like', '%'.$row['guardians_address_area'].'%')->first();
322
+                    $nationalityId = Nationality::where('name', 'like', '%'.$row['guardians_nationality'].'%')->first();
323
+                    $identityType = Identity_type::where('national_code', 'like', '%'.$row['guardians_identity_type'].'%')->first();
324 324
                     $openemisGuardian = $this->uniqueUid::getUniqueAlphanumeric();
325 325
 
326 326
                     $identityType = $identityType !== null ? $identityType->id : null;
@@ -335,7 +335,7 @@  discard block
 block discarded – undo
335 335
 
336 336
                     if ($guardian === null) {
337 337
                         $guardian = Security_user::create([
338
-                                    'username' => str_replace('-','',$openemisGuardian),
338
+                                    'username' => str_replace('-', '', $openemisGuardian),
339 339
                                     'openemis_no' => $openemisGuardian,
340 340
                                     'first_name' => $row['guardians_full_name'], // here we save full name in the column of first name. re reduce breaks of the system.
341 341
                                     'last_name' => genNameWithInitials($row['guardians_full_name']),
@@ -354,23 +354,23 @@  discard block
 block discarded – undo
354 354
                         $guardian['guardian_relation_id'] = 3;
355 355
                         if (array_key_exists('guardians_phone', $row)) {
356 356
                             $guardian['contact'] = $row['guardians_phone'];
357
-                            User_contact::createOrUpdate($guardian,$this->file['security_user_id']);
357
+                            User_contact::createOrUpdate($guardian, $this->file['security_user_id']);
358 358
                         }
359 359
                         Student_guardian::createStudentGuardian($student, $guardian, $this->file['security_user_id']);
360
-                    } else {
360
+                    }else {
361 361
                         Security_user::where('id', '=', $guardian->id)
362 362
                                 ->update(['is_guardian' => 1]);
363 363
                         $guardian['guardian_relation_id'] = 3;
364 364
                         if (array_key_exists('guardians_phone', $row)) {
365 365
                             $guardian['contact'] = $row['guardians_phone'];
366
-                            User_contact::createOrUpdate($guardian,$this->file['security_user_id']);
366
+                            User_contact::createOrUpdate($guardian, $this->file['security_user_id']);
367 367
                         }
368 368
                         Student_guardian::createStudentGuardian($student, $guardian, $this->file['security_user_id']);
369 369
                     }
370 370
                 }
371 371
                 Institution_student::updateStudentArea($student);
372 372
 
373
-                $optionalSubjects =  Institution_class_subject::getStudentOptionalSubject($subjects, $student, $row, $institution);
373
+                $optionalSubjects = Institution_class_subject::getStudentOptionalSubject($subjects, $student, $row, $institution);
374 374
 
375 375
                 $allSubjects = array_merge_recursive($optionalSubjects, $mandatorySubject);
376 376
                 // $stundetSubjects = $this->getStudentSubjects($student);
@@ -379,10 +379,10 @@  discard block
 block discarded – undo
379 379
                 if (!empty($allSubjects)) {
380 380
                     $allSubjects = unique_multidim_array($allSubjects, 'institution_subject_id');
381 381
                     $this->student = $student;
382
-                    $allSubjects = array_map(array($this,'setStudentSubjects'),$allSubjects);
382
+                    $allSubjects = array_map(array($this, 'setStudentSubjects'), $allSubjects);
383 383
                     // $allSubjects = array_unique($allSubjects,SORT_REGULAR);
384 384
                     $allSubjects = unique_multidim_array($allSubjects, 'education_subject_id');
385
-                    array_walk($allSubjects,array($this,'insertSubject'));
385
+                    array_walk($allSubjects, array($this, 'insertSubject'));
386 386
                     array_walk($allSubjects, array($this, 'updateSubjectCount'));
387 387
                 }
388 388
 
@@ -395,7 +395,7 @@  discard block
 block discarded – undo
395 395
                             'total_male_students' => $totalStudents['total_male_students'],
396 396
                             'total_female_students' => $totalStudents['total_female_students']]);
397 397
             }
398
-        } catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
398
+        }catch (\Maatwebsite\Excel\Validators\ValidationException $e) {
399 399
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
400 400
             $failures = $e->failures();
401 401
             throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures);
Please login to merge, or discard this patch.
app/Imports/Import.php 1 patch
Spacing   +21 added lines, -21 removed lines patch added patch discarded remove patch
@@ -88,10 +88,10 @@  discard block
 block discarded – undo
88 88
         $highestColumn = $this->worksheet->getHighestDataColumn(3);
89 89
         $higestRow = 0;
90 90
         for ($row = $this->startRow(); $row <= $this->highestRow; $row++) {
91
-            $rowData = $this->worksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
91
+            $rowData = $this->worksheet->rangeToArray('A'.$row.':'.$highestColumn.$row, NULL, TRUE, FALSE);
92 92
             if (isEmptyRow(reset($rowData))) {
93 93
                 continue;
94
-            } else {
94
+            }else {
95 95
                 $higestRow += 1;
96 96
             }
97 97
         }
@@ -105,7 +105,7 @@  discard block
 block discarded – undo
105 105
         $this->failures = [];
106 106
         if (($column !== "") && (!in_array($column, $columns))) {
107 107
             $this->isValidSheet = false;
108
-            $this->error[] = 'Unsupported column found ,remove:' . $column;
108
+            $this->error[] = 'Unsupported column found ,remove:'.$column;
109 109
             $this->failure = new Failure(3, 'remark', $this->error, [null]);
110 110
             $this->failures = new \Maatwebsite\Excel\Validators\ValidationException($error, [$this->failure]);
111 111
         }
@@ -118,13 +118,13 @@  discard block
 block discarded – undo
118 118
     {
119 119
         $columns = Config::get('excel.columns');
120 120
         $optional_columns = Config::get('excel.optional_columns');
121
-        $columns = array_diff ($columns,$optional_columns);
121
+        $columns = array_diff($columns, $optional_columns);
122 122
         $error = \Illuminate\Validation\ValidationException::withMessages([]);
123 123
         $this->failures = [];
124 124
         foreach ($columns as  $column) {
125 125
                 if (($column !== "") && (!in_array($column, $existingColumns))) {
126 126
                     $this->isValidSheet = false;
127
-                    $this->error[] = 'Missing Column :' . $column . ' Not found';
127
+                    $this->error[] = 'Missing Column :'.$column.' Not found';
128 128
                     $this->failure = new Failure(3, 'remark', $this->error, [null]);
129 129
                     $this->failures = new \Maatwebsite\Excel\Validators\ValidationException($error, [$this->failure]);
130 130
                 }
@@ -141,16 +141,16 @@  discard block
 block discarded – undo
141 141
         $highestColumn = $this->worksheet->getHighestDataColumn(3);
142 142
         $higestRow = 1;
143 143
         for ($row = $this->startRow(); $row <= $this->highestRow; $row++) {
144
-            $rowData = $this->worksheet->rangeToArray('A' . $row . ':' . $highestColumn . $row, NULL, TRUE, FALSE);
144
+            $rowData = $this->worksheet->rangeToArray('A'.$row.':'.$highestColumn.$row, NULL, TRUE, FALSE);
145 145
             if (isEmptyRow(reset($rowData))) {
146 146
                 continue;
147
-            } else {
147
+            }else {
148 148
                 $higestRow += 1;
149 149
             }
150 150
         }
151 151
         if ($higestRow == 0) {
152 152
             exit;
153
-        } else {
153
+        }else {
154 154
             return $higestRow;
155 155
         }
156 156
     }
@@ -175,17 +175,17 @@  discard block
 block discarded – undo
175 175
                     case 'string':
176 176
                         $row[$column] = preg_replace('/[^A-Za-z0-9\-]/', '-', $row[$column]);
177 177
                         $row[$column] = date($format, strtotime($row[$column])); //date($row[$column]);
178
-                        $row[$column] =  \Carbon\Carbon::createFromFormat($format, $row[$column]);
178
+                        $row[$column] = \Carbon\Carbon::createFromFormat($format, $row[$column]);
179 179
                         break;
180 180
                     case 'double';
181
-                        $row[$column] =  \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row[$column]);
181
+                        $row[$column] = \PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($row[$column]);
182 182
                         break;
183 183
                 }
184 184
             }
185 185
             return $row;
186
-        } catch (Exception $e) {
186
+        }catch (Exception $e) {
187 187
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
188
-            $failure = new Failure(3, 'remark', [0 => 'Template is not valid for upload, use the template given in the system ' . $row[$column] . ' Not a valid date formate'], [null]);
188
+            $failure = new Failure(3, 'remark', [0 => 'Template is not valid for upload, use the template given in the system '.$row[$column].' Not a valid date formate'], [null]);
189 189
             $failures = [0 => $failure];
190 190
             throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures);
191 191
         }
@@ -206,18 +206,18 @@  discard block
 block discarded – undo
206 206
         $row = $this->formateDate($row, 'mothers_date_of_birth_yyyy_mm_dd');
207 207
         $row = $this->formateDate($row, 'guardians_date_of_birth_yyyy_mm_dd');
208 208
 
209
-        $row['admission_no'] =  str_pad($row['admission_no'], 4, '0', STR_PAD_LEFT);
209
+        $row['admission_no'] = str_pad($row['admission_no'], 4, '0', STR_PAD_LEFT);
210 210
       
211 211
         if (array_key_exists('identity_type', $row)) {
212 212
         if ($row['identity_type'] == 'BC' && (!empty($row['birth_divisional_secretariat'])) && ($row['identity_number'] !== null) && $row['date_of_birth_yyyy_mm_dd'] !== null) {
213
-            $row['identity_number'] =  str_pad($row['identity_number'], 4, '0', STR_PAD_LEFT);
213
+            $row['identity_number'] = str_pad($row['identity_number'], 4, '0', STR_PAD_LEFT);
214 214
             // dd(($row['date_of_birth_yyyy_mm_dd']));
215
-            $BirthDivision = Area_administrative::where('name', 'like', '%' . $row['birth_divisional_secretariat'] . '%')->where('area_administrative_level_id', '=', 5)->first();
215
+            $BirthDivision = Area_administrative::where('name', 'like', '%'.$row['birth_divisional_secretariat'].'%')->where('area_administrative_level_id', '=', 5)->first();
216 216
             if ($BirthDivision !== null) {
217
-                $BirthArea = Area_administrative::where('name', 'like', '%' . $row['birth_registrar_office_as_in_birth_certificate'] . '%')
217
+                $BirthArea = Area_administrative::where('name', 'like', '%'.$row['birth_registrar_office_as_in_birth_certificate'].'%')
218 218
                     ->where('parent_id', '=', $BirthDivision->id)->first();
219 219
                 if ($BirthArea !== null) {
220
-                    $row['identity_number'] = $BirthArea->id . '' . $row['identity_number'] . '' . substr($row['date_of_birth_yyyy_mm_dd']->format("yy"), -2) . '' . $row['date_of_birth_yyyy_mm_dd']->format("m");
220
+                    $row['identity_number'] = $BirthArea->id.''.$row['identity_number'].''.substr($row['date_of_birth_yyyy_mm_dd']->format("yy"), -2).''.$row['date_of_birth_yyyy_mm_dd']->format("m");
221 221
                 }
222 222
             }
223 223
 
@@ -230,9 +230,9 @@  discard block
 block discarded – undo
230 230
     {
231 231
         if (array_key_exists($key, $row)) {
232 232
             return true;
233
-        } else {
233
+        }else {
234 234
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
235
-            $failure = new Failure($count, 'remark', [0 => 'Template is not valid for upload, use the template given in the system ' . $key, ' Is missing form the template'], [null]);
235
+            $failure = new Failure($count, 'remark', [0 => 'Template is not valid for upload, use the template given in the system '.$key, ' Is missing form the template'], [null]);
236 236
             $failures = [0 => $failure];
237 237
             new \Maatwebsite\Excel\Validators\ValidationException($error, $failures);
238 238
         };
@@ -268,11 +268,11 @@  discard block
 block discarded – undo
268 268
 
269 269
         if ($exceededStudents == true) {
270 270
             $error = \Illuminate\Validation\ValidationException::withMessages([]);
271
-            $failure = new Failure(3, 'remark', ['Class student count exceeded! Max number of students is' . $institutionClass->no_of_students], [null]);
271
+            $failure = new Failure(3, 'remark', ['Class student count exceeded! Max number of students is'.$institutionClass->no_of_students], [null]);
272 272
             $failures = [0 => $failure];
273 273
             throw new \Maatwebsite\Excel\Validators\ValidationException($error, $failures);
274 274
             Log::info('email-sent', [$this->file]);
275
-        } else {
275
+        }else {
276 276
             return true;
277 277
         }
278 278
     }
Please login to merge, or discard this patch.
app/Models/Student_guardian.php 2 patches
Spacing   +8 added lines, -8 removed lines patch added patch discarded remove patch
@@ -7,7 +7,7 @@  discard block
 block discarded – undo
7 7
 use Illuminate\Database\Eloquent\SoftDeletes;
8 8
 use Webpatser\Uuid\Uuid;
9 9
 
10
-class Student_guardian extends Base_Model  {
10
+class Student_guardian extends Base_Model {
11 11
 
12 12
     use SoftDeletes;
13 13
 
@@ -59,19 +59,19 @@  discard block
 block discarded – undo
59 59
     public static function boot()
60 60
     {
61 61
         parent::boot();
62
-        self::creating(function ($model) {
62
+        self::creating(function($model) {
63 63
             $model->id = (string) Uuid::generate(4);
64 64
             $model->created_user_id = 1;
65 65
         });
66 66
     }
67 67
 
68
-    public static function createStudentGuardian($student,$guardian,$user){
68
+    public static function createStudentGuardian($student, $guardian, $user) {
69 69
      
70 70
         $exist = self::where('student_id', $student->student_id)
71 71
         ->where('guardian_relation_id', $guardian->guardian_relation_id)
72 72
         ->exists();
73 73
 
74
-        $totalGuardians = self::where('student_id',$student->student_id)->count();
74
+        $totalGuardians = self::where('student_id', $student->student_id)->count();
75 75
 
76 76
         $data = [
77 77
             'student_id' => $student->student_id,
@@ -79,13 +79,13 @@  discard block
 block discarded – undo
79 79
             'guardian_relation_id' => $guardian->guardian_relation_id,
80 80
             'created_user_id' => $user
81 81
         ];
82
-        if(!$exist){
82
+        if (!$exist) {
83 83
             $data['created'] = now();
84 84
             self::create($data);
85
-        }else{
85
+        }else {
86 86
             $data['modified'] = now();
87
-            self::where('student_id' , $student->student_id)
88
-            ->where('guardian_relation_id',$guardian->guardian_relation_id)
87
+            self::where('student_id', $student->student_id)
88
+            ->where('guardian_relation_id', $guardian->guardian_relation_id)
89 89
             ->update($data);
90 90
         }
91 91
     }
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -82,7 +82,7 @@
 block discarded – undo
82 82
         if(!$exist){
83 83
             $data['created'] = now();
84 84
             self::create($data);
85
-        }else{
85
+        } else{
86 86
             $data['modified'] = now();
87 87
             self::where('student_id' , $student->student_id)
88 88
             ->where('guardian_relation_id',$guardian->guardian_relation_id)
Please login to merge, or discard this patch.
app/Models/Institution_student.php 2 patches
Braces   +7 added lines, -7 removed lines patch added patch discarded remove patch
@@ -226,25 +226,25 @@
 block discarded – undo
226 226
         if(!is_null($father) && is_null($mother) && is_null($guardian)){
227 227
             Security_user::where('id',$student['student_id'])
228 228
             ->update(['address_area_id' => $father->address_area_id]);
229
-        }elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
229
+        } elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
230 230
             Security_user::where('id',$student['student_id'])
231 231
             ->update(['address_area_id' => $mother->address_area_id]);
232
-        }elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
232
+        } elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
233 233
             Security_user::where('id',$student['student_id'])
234 234
             ->update(['address_area_id' => $guardian->address_area_id]);
235
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
235
+        } elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
236 236
             Security_user::where('id',$student['student_id'])
237 237
             ->update(['address_area_id' => $mother->address_area_id]);
238
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
238
+        } elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
239 239
             Security_user::where('id',$student['student_id'])
240 240
             ->update(['address_area_id' => $guardian->address_area_id]);
241
-        }elseif(!is_null($father) && $father->address == $student['address']){
241
+        } elseif(!is_null($father) && $father->address == $student['address']){
242 242
             Security_user::where('id',$student['student_id'])
243 243
             ->update(['address_area_id' => $guardian->address_area_id]);
244
-        }elseif(!is_null($mother) && $mother->address == $student['address']){
244
+        } elseif(!is_null($mother) && $mother->address == $student['address']){
245 245
             Security_user::where('id',$student['student_id'])
246 246
             ->update(['address_area_id' => $mother->address_area_id]);
247
-        }elseif(!is_null($guardian) && $guardian->address == $student['address']){
247
+        } elseif(!is_null($guardian) && $guardian->address == $student['address']){
248 248
             Security_user::where('id',$student['student_id'])
249 249
             ->update(['address_area_id' => $guardian->address_area_id]);
250 250
         }
Please login to merge, or discard this patch.
Spacing   +33 added lines, -33 removed lines patch added patch discarded remove patch
@@ -71,7 +71,7 @@  discard block
 block discarded – undo
71 71
     public static function boot()
72 72
     {
73 73
         parent::boot();
74
-        self::creating(function ($model) {
74
+        self::creating(function($model) {
75 75
             $model->id = (string) Uuid::generate(4);
76 76
             $model->created = now();
77 77
         });
@@ -129,9 +129,9 @@  discard block
 block discarded – undo
129 129
                 'institution_students.admission_id'
130 130
             )
131 131
             ->where('institution_students.institution_id', $institutionGrade['institution_id'])
132
-            ->where('institution_students.student_status_id',1)
132
+            ->where('institution_students.student_status_id', 1)
133 133
             ->where('institution_students.education_grade_id', $institutionGrade['education_grade_id'])
134
-            ->where('institution_students.deleted_at',null)
134
+            ->where('institution_students.deleted_at', null)
135 135
             ->where('institution_students.academic_period_id', $academicPeriod->id)->get()->toArray();
136 136
     }
137 137
 
@@ -144,7 +144,7 @@  discard block
 block discarded – undo
144 144
      */
145 145
     public static function createExaminationData($student, $admissionInfo)
146 146
     {
147
-        $student['sp_center'] = gettype((int)$student['sp_center']) == 'integer' ?  $student['sp_center'] : 0;
147
+        $student['sp_center'] = gettype((int) $student['sp_center']) == 'integer' ? $student['sp_center'] : 0;
148 148
         try {
149 149
             self::create([
150 150
                 'id' => (string) Uuid::generate(4),
@@ -169,7 +169,7 @@  discard block
 block discarded – undo
169 169
                 'created' => now(),
170 170
                 'created_user_id' => 1
171 171
             ]);
172
-        } catch (\Throwable $th) {
172
+        }catch (\Throwable $th) {
173 173
             Log::error($th);
174 174
         }
175 175
     }
@@ -183,7 +183,7 @@  discard block
 block discarded – undo
183 183
      */
184 184
     public static function updateExaminationData($student, $admissionInfo)
185 185
     {
186
-        $student['sp_center'] = gettype((int)$student['sp_center']) == 'integer' ?  $student['sp_center'] : 0;
186
+        $student['sp_center'] = gettype((int) $student['sp_center']) == 'integer' ? $student['sp_center'] : 0;
187 187
         try {
188 188
             self::where([
189 189
                 'student_id' => $student['student_id'],
@@ -204,50 +204,50 @@  discard block
 block discarded – undo
204 204
                     'modified_user_id' => 1
205 205
                 ]
206 206
             );
207
-        } catch (\Throwable $th) {
207
+        }catch (\Throwable $th) {
208 208
             Log::error($th);
209 209
         }
210 210
     }
211 211
 
212
-    public static function updateStudentArea(array $student){
213
-        $father = Student_guardian::where('student_id',$student['student_id'])
214
-        ->join('security_users as sg','guardian_id', 'sg.id')
215
-        ->where('guardian_relation_id',1)
212
+    public static function updateStudentArea(array $student) {
213
+        $father = Student_guardian::where('student_id', $student['student_id'])
214
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
215
+        ->where('guardian_relation_id', 1)
216 216
         ->get()->first();
217 217
 
218
-        $mother = Student_guardian::where('student_id',$student['student_id'])
219
-        ->join('security_users as sg','guardian_id', 'sg.id')
220
-        ->where('guardian_relation_id',2)
218
+        $mother = Student_guardian::where('student_id', $student['student_id'])
219
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
220
+        ->where('guardian_relation_id', 2)
221 221
         ->get()->first();
222 222
 
223
-        $guardian = Student_guardian::where('student_id',$student['student_id'])
224
-        ->join('security_users as sg','guardian_id', 'sg.id')
225
-        ->where('guardian_relation_id',3)
223
+        $guardian = Student_guardian::where('student_id', $student['student_id'])
224
+        ->join('security_users as sg', 'guardian_id', 'sg.id')
225
+        ->where('guardian_relation_id', 3)
226 226
         ->get()->first();
227 227
 
228
-        if(!is_null($father) && is_null($mother) && is_null($guardian)){
229
-            Security_user::where('id',$student['student_id'])
228
+        if (!is_null($father) && is_null($mother) && is_null($guardian)) {
229
+            Security_user::where('id', $student['student_id'])
230 230
             ->update(['address_area_id' => $father->address_area_id]);
231
-        }elseif(!is_null($mother)  && (is_null($father) && is_null($guardian))){
232
-            Security_user::where('id',$student['student_id'])
231
+        }elseif (!is_null($mother) && (is_null($father) && is_null($guardian))) {
232
+            Security_user::where('id', $student['student_id'])
233 233
             ->update(['address_area_id' => $mother->address_area_id]);
234
-        }elseif(!is_null($guardian) && is_null($father) && is_null($mother)){
235
-            Security_user::where('id',$student['student_id'])
234
+        }elseif (!is_null($guardian) && is_null($father) && is_null($mother)) {
235
+            Security_user::where('id', $student['student_id'])
236 236
             ->update(['address_area_id' => $guardian->address_area_id]);
237
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id ==  $mother->address_area_id)){
238
-            Security_user::where('id',$student['student_id'])
237
+        }elseif (!is_null($mother) && !is_null($father) && ($father->address_area_id == $mother->address_area_id)) {
238
+            Security_user::where('id', $student['student_id'])
239 239
             ->update(['address_area_id' => $mother->address_area_id]);
240
-        }elseif(!is_null($mother)  && !is_null($father) && ($father->address_area_id !==  $mother->address_area_id) && !is_null($guardian)){
241
-            Security_user::where('id',$student['student_id'])
240
+        }elseif (!is_null($mother) && !is_null($father) && ($father->address_area_id !== $mother->address_area_id) && !is_null($guardian)) {
241
+            Security_user::where('id', $student['student_id'])
242 242
             ->update(['address_area_id' => $guardian->address_area_id]);
243
-        }elseif(!is_null($father) && $father->address == $student['address']){
244
-            Security_user::where('id',$student['student_id'])
243
+        }elseif (!is_null($father) && $father->address == $student['address']) {
244
+            Security_user::where('id', $student['student_id'])
245 245
             ->update(['address_area_id' => $guardian->address_area_id]);
246
-        }elseif(!is_null($mother) && $mother->address == $student['address']){
247
-            Security_user::where('id',$student['student_id'])
246
+        }elseif (!is_null($mother) && $mother->address == $student['address']) {
247
+            Security_user::where('id', $student['student_id'])
248 248
             ->update(['address_area_id' => $mother->address_area_id]);
249
-        }elseif(!is_null($guardian) && $guardian->address == $student['address']){
250
-            Security_user::where('id',$student['student_id'])
249
+        }elseif (!is_null($guardian) && $guardian->address == $student['address']) {
250
+            Security_user::where('id', $student['student_id'])
251 251
             ->update(['address_area_id' => $guardian->address_area_id]);
252 252
         }
253 253
     }
Please login to merge, or discard this patch.
app/Console/Commands/RemoveDuplicatedGuardians.php 3 patches
Indentation   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -52,16 +52,16 @@
 block discarded – undo
52 52
     }
53 53
 
54 54
     public function delete(){
55
-       try{
56
-           DB::statement("UPDATE  student_guardians t1
55
+        try{
56
+            DB::statement("UPDATE  student_guardians t1
57 57
            INNER JOIN student_guardians t2 
58 58
                set t1.deleted_at=now() 
59 59
            WHERE 
60 60
                t1.id > t2.id AND
61 61
                t1.student_id = t2.student_id AND
62 62
                t1.guardian_id = t2.guardian_id");
63
-       }catch(\Exception $e){
64
-           dd($e);
65
-       }
63
+        }catch(\Exception $e){
64
+            dd($e);
65
+        }
66 66
     }
67 67
 }
Please login to merge, or discard this patch.
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -45,14 +45,14 @@  discard block
 block discarded – undo
45 45
             $this->output->writeln('############### Starting delete Duplication ################');
46 46
             Student_guardian::withTrashed()->restore();
47 47
             $this->delete();
48
-            $this->end_time  = microtime(TRUE);
49
-            $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
50
-        } catch (\Throwable $th) {
48
+            $this->end_time = microtime(TRUE);
49
+            $this->output->writeln('The cook took '.($this->end_time - $this->start_time).' seconds to complete');
50
+        }catch (\Throwable $th) {
51 51
         }
52 52
     }
53 53
 
54
-    public function delete(){
55
-       try{
54
+    public function delete() {
55
+       try {
56 56
            DB::statement("UPDATE  student_guardians t1
57 57
            INNER JOIN student_guardians t2 
58 58
                set t1.deleted_at=now() 
@@ -60,7 +60,7 @@  discard block
 block discarded – undo
60 60
                t1.id > t2.id AND
61 61
                t1.student_id = t2.student_id AND
62 62
                t1.guardian_id = t2.guardian_id");
63
-       }catch(\Exception $e){
63
+       }catch (\Exception $e) {
64 64
            dd($e);
65 65
        }
66 66
     }
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -60,7 +60,7 @@
 block discarded – undo
60 60
                t1.id > t2.id AND
61 61
                t1.student_id = t2.student_id AND
62 62
                t1.guardian_id = t2.guardian_id");
63
-       }catch(\Exception $e){
63
+       } catch(\Exception $e){
64 64
            dd($e);
65 65
        }
66 66
     }
Please login to merge, or discard this patch.
app/Console/Commands/CloneConfigData.php 2 patches
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -66,7 +66,7 @@
 block discarded – undo
66 66
         if(count($shift) > 0){
67 67
             // processParallel($function,$shift, $this->argument('max'),$params);
68 68
             array_walk($shift,$function,$params);
69
-        }else{
69
+        } else{
70 70
             $this->output->writeln('Nothing to clone');
71 71
         }
72 72
         $this->end_time = microtime(TRUE);
Please login to merge, or discard this patch.
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -54,8 +54,8 @@  discard block
 block discarded – undo
54 54
         $academicPeriod = $this->academic_period->getAcademicPeriod($year);
55 55
         $mode = $this->argument('mode') == 'AL' ? true : false; 
56 56
         $previousAcademicPeriodYear = $academicPeriod->order;
57
-        $previousAcademicPeriod = Academic_period::where('order',$previousAcademicPeriodYear+1)->first();
58
-        $shift = $this->shifts->getShiftsToClone($previousAcademicPeriod->code,$this->argument(('max')),$mode);
57
+        $previousAcademicPeriod = Academic_period::where('order', $previousAcademicPeriodYear + 1)->first();
58
+        $shift = $this->shifts->getShiftsToClone($previousAcademicPeriod->code, $this->argument(('max')), $mode);
59 59
         $params = [
60 60
             'year' => $year,
61 61
             'academic_period' => $academicPeriod,
@@ -64,17 +64,17 @@  discard block
 block discarded – undo
64 64
         ];
65 65
 
66 66
         $function = array($this->clone, 'process');
67
-        if(count($shift) > 0){
67
+        if (count($shift) > 0) {
68 68
             // processParallel($function,$shift, $this->argument('max'),$params);
69
-            array_walk($shift,$function,$params);
70
-        }else{
69
+            array_walk($shift, $function, $params);
70
+        }else {
71 71
             $this->output->writeln('Nothing to clone');
72 72
         }
73 73
         $this->end_time = microtime(TRUE);
74 74
 
75 75
 
76 76
         $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
77
-        $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
77
+        $this->output->writeln('The cook took '.($this->end_time - $this->start_time).' seconds to complete');
78 78
         $this->output->writeln('$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$');
79 79
     }  
80 80
 }
Please login to merge, or discard this patch.
app/Console/Commands/MapStudentArea.php 1 patch
Spacing   +5 added lines, -5 removed lines patch added patch discarded remove patch
@@ -30,7 +30,7 @@  discard block
 block discarded – undo
30 30
      */
31 31
     public function __construct()
32 32
     {
33
-        $this->output =  new \Symfony\Component\Console\Output\ConsoleOutput();
33
+        $this->output = new \Symfony\Component\Console\Output\ConsoleOutput();
34 34
         parent::__construct();
35 35
     }
36 36
 
@@ -41,13 +41,13 @@  discard block
 block discarded – undo
41 41
      */
42 42
     public function handle()
43 43
     {
44
-        $students = Security_user::where('is_student',true)->get()->toArray();
45
-        array_walk($students,array($this,'process'));
44
+        $students = Security_user::where('is_student', true)->get()->toArray();
45
+        array_walk($students, array($this, 'process'));
46 46
     }
47 47
 
48
-    public function process($student){
48
+    public function process($student) {
49 49
         $student['student_id'] = $student['id'];
50 50
         Institution_student::updateStudentArea($student);
51
-        $this->output->writeln('area updated for student:'. $student['openemis_no']) ;
51
+        $this->output->writeln('area updated for student:'.$student['openemis_no']);
52 52
     }
53 53
 }
Please login to merge, or discard this patch.
app/Console/Commands/cleanConfig.php 2 patches
Spacing   +3 added lines, -3 removed lines patch added patch discarded remove patch
@@ -48,16 +48,16 @@
 block discarded – undo
48 48
         $year = $this->argument('year');
49 49
         $academicPeriod = $this->academic_period->getAcademicPeriod($year);
50 50
         $previousAcademicPeriodYear = $academicPeriod->order;
51
-        $previousAcademicPeriod = Academic_period::where('order',$previousAcademicPeriodYear+1)->first();
51
+        $previousAcademicPeriod = Academic_period::where('order', $previousAcademicPeriodYear + 1)->first();
52 52
 
53 53
         $params = [
54 54
             'academic_period' => $academicPeriod,
55 55
             'previous_academic_period' => $previousAcademicPeriod
56 56
         ];
57 57
 
58
-        if($year == '2019' || $year == '2018/19'){
58
+        if ($year == '2019' || $year == '2018/19') {
59 59
             die('Academic Year 2019 or earlier can`t be deleted');
60
-        }else{
60
+        }else {
61 61
             $this->clone->cleanConfig($params);
62 62
         }
63 63
     }
Please login to merge, or discard this patch.
Braces   +1 added lines, -1 removed lines patch added patch discarded remove patch
@@ -57,7 +57,7 @@
 block discarded – undo
57 57
 
58 58
         if($year == '2019' || $year == '2018/19'){
59 59
             die('Academic Year 2019 or earlier can`t be deleted');
60
-        }else{
60
+        } else{
61 61
             $this->clone->cleanConfig($params);
62 62
         }
63 63
     }
Please login to merge, or discard this patch.