RemoveDuplicatedGuardians::delete() - Code Metrics - moe-lk/bulk-upload - Measure and Improve Code Quality continuously with Scrutinizer

RemoveDuplicatedGuardians::delete() A
last analyzed 2022-03-28 10:30 UTC

↳ Parent: RemoveDuplicatedGuardians

Complexity

Conditions	2
Paths	2

Size

Total Lines	11
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	1

Metric	Value
cc	2
eloc	4
nc	2
nop	0
dl	0
loc	11
rs	10
c	2
b	0
f	1

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use App\Models\Student_guardian;
use Illuminate\Support\Facades\DB;

class RemoveDuplicatedGuardians extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'clean:guardian';

    /**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Command description';

    /**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }

    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        try {
            $this->start_time = microtime(TRUE);

            $this->output = new \Symfony\Component\Console\Output\ConsoleOutput();

            $this->output->writeln('############### Starting delete Duplication ################');
            Student_guardian::withTrashed()->restore();
            $this->delete();
            $this->end_time  = microtime(TRUE);

            $this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
        } catch (\Throwable $th) {

        }
    }

    public function delete(){
       try{
           DB::statement("UPDATE  student_guardians t1
           INNER JOIN student_guardians t2 
               set t1.deleted_at=now() 
           WHERE 
               t1.id > t2.id AND
               t1.student_id = t2.student_id AND
               t1.guardian_id = t2.guardian_id");
       }catch(\Exception $e){
           dd($e);
       }
    }
}


1			<?php
2
3			namespace App\Console\Commands;
4
5			use Illuminate\Console\Command;
6			use App\Models\Student_guardian;
7			use Illuminate\Support\Facades\DB;
8
9			class RemoveDuplicatedGuardians extends Command
10			{
11			/**
12			* The name and signature of the console command.
13			*
14			* @var string
15			*/
16			protected $signature = 'clean:guardian';
17
18			/**
19			* The console command description.
20			*
21			* @var string
22			*/
23			protected $description = 'Command description';
24
25			/**
26			* Create a new command instance.
27			*
28			* @return void
29			*/
30			public function __construct()
31			{
32			parent::__construct();
33			}
34
35			/**
36			* Execute the console command.
37			*
38			* @return mixed
39			*/
40			public function handle()
41			{
42			try {
43			$this->start_time = microtime(TRUE);
			0 ignored issues – show Bug Best Practice introduced 2020-08-26 15:48 UTC by Report Bug Copy Issue Report The property `start_time` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history...
44			$this->output = new \Symfony\Component\Console\Output\ConsoleOutput();
			0 ignored issues – show Documentation Bug introduced 2020-10-21 12:45 UTC by Report Bug Copy Issue Report It seems like `new Symfony\Component\Co...\Output\ConsoleOutput()` of type `Symfony\Component\Console\Output\ConsoleOutput` is incompatible with the declared type `Illuminate\Console\OutputStyle` of property `$output`. Our type inference engine has found an assignment to a property that is incompatible with the declared type of that property. Either this assignment is in error or the assigned type should be added to the documentation/type hint for that property.. Loading history...
45			$this->output->writeln('############### Starting delete Duplication ################');
46			Student_guardian::withTrashed()->restore();
47			$this->delete();
48			$this->end_time = microtime(TRUE);
			0 ignored issues – show Bug Best Practice introduced 2020-05-27 14:51 UTC by Report Bug Copy Issue Report The property `end_time` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history...
49			$this->output->writeln('The cook took ' . ($this->end_time - $this->start_time) . ' seconds to complete');
50			} catch (\Throwable $th) {
			0 ignored issues – show Coding Style Comprehensibility introduced 2020-10-21 12:45 UTC by Report Bug Copy Issue Report Consider adding a comment why this CATCH block is empty. Loading history...
51			}
52			}
53
54			public function delete(){
55			try{
56			DB::statement("UPDATE student_guardians t1
57			INNER JOIN student_guardians t2
58			set t1.deleted_at=now()
59			WHERE
60			t1.id > t2.id AND
61			t1.student_id = t2.student_id AND
62			t1.guardian_id = t2.guardian_id");
63			}catch(\Exception $e){
64			dd($e);
65			}
66			}
67			}
68

moe-lk / bulk-upload

RemoveDuplicatedGuardians::delete() A last analyzed 2022-03-28 10:30 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

RemoveDuplicatedGuardians::delete() A
last analyzed 2022-03-28 10:30 UTC