UserRepositorySql::getByProvider() - Code Metrics - Inspection of "Merge pull request #15 from neayi/29-connexion-je-..." - neayi/insights - Measure and Improve Code Quality continuously with Scrutinizer

Test Setup Failed

Push — master ( dcfdf2...6863da )

by guillaume

created 2020-07-09 07:50 UTC

UserRepositorySql::getByProvider() A

↳ Parent: UserRepositorySql

Complexity

Conditions	2
Paths	2

Size

Total Lines	8
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	2
eloc	5
nc	2
nop	2
dl	0
loc	8
rs	10
c	0
b	0
f	0

<?php


namespace App\Src\UseCases\Infra\Sql;

use App\Src\UseCases\Domain\Ports\UserRepository;
use App\Src\UseCases\Domain\User;
use Illuminate\Support\Facades\DB;

class UserRepositorySql implements UserRepository
{
    public function getByEmail(string $email): ?User
    {
        $record = \App\User::where('email', $email)->first();
        if(!isset($record)){
            return null;
        }
        $roles = $record->roles()->pluck('name')->toArray();
        return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);

    }

    public function getById(string $id): ?User
    {
        $record = \App\User::where('uuid', $id)->first();
        if(!isset($record)){
            return null;
        }
        $roles = $record->roles()->pluck('name')->toArray();
        return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);

    }

    public function add(User $u, string $password = null)
    {
        $userModel = new \App\User();
        $data = $u->toArray();
        unset($data['url_picture']);
        unset($data['roles']);
        $userModel->fill($data);
        $userModel->password = $password;

        $userModel->save();
    }

    public function update(User $u)
    {
        $userModel = \App\User::where('uuid', $u->id())->first();
        $data = $u->toArray();
        $roles = $data['roles'];
        unset($data['url_picture']);
        unset($data['roles']);
        $userModel->fill($data);
        $userModel->save();

        $userModel->syncRoles($roles);
    }

    public function search(string $organizationId, int $page, int $perPage = 10): array
    {
        $records = DB::table('users')
            ->select()
            ->where('organization_id', $organizationId)
        ;
        $count = $records->count();

        $records = DB::table('users')
            ->select()
            ->where('organization_id', $organizationId)
            ->offset(($page-1)*$perPage)
            ->limit($perPage)
            ->get();
        if(empty($records)){
            return [];
        }
        $users = [];
        foreach($records as $record){
            $roles = \App\User::find($record->id)->roles()->pluck('name')->toArray();
            $users[] = new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);
        }
        return [
            'list' => $users,
            'total' => $count
        ];
    }

    public function delete(string $userId)
    {
        $userModel = \App\User::where('uuid', $userId)->first();
        $userModel->delete();
    }

    public function getAdminOfOrganization(string $organizationId): array
    {
        $records = \App\User::role(['admin'])->where('organization_id', $organizationId)->get();
        if(empty($records)){
            return [];
        }
        $users = [];
        foreach($records as $record){
            $roles = \App\User::find($record->id)->roles()->pluck('name')->toArray();
            $users[] = new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);

        }
        return $users;
    }

    public function getByProvider(string $provider, string $providerId): ?User
    {
        $record = \App\User::where('providers->'.$provider, $providerId)->first();
        if(!isset($record)){
            return null;
        }
        $roles = $record->roles()->pluck('name')->toArray();
        return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles, $record->providers);

    }


}


1			<?php
2
3
4			namespace App\Src\UseCases\Infra\Sql;
5
6			use App\Src\UseCases\Domain\Ports\UserRepository;
7			use App\Src\UseCases\Domain\User;
8			use Illuminate\Support\Facades\DB;
9
10			class UserRepositorySql implements UserRepository
11			{
12			public function getByEmail(string $email): ?User
13			{
14			$record = \App\User::where('email', $email)->first();
15			if(!isset($record)){
16			return null;
17			}
18			$roles = $record->roles()->pluck('name')->toArray();
19			return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);
			0 ignored issues – show Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `email` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `organization_id` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `lastname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `firstname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `path_picture` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `uuid` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history...
20			}
21
22			public function getById(string $id): ?User
23			{
24			$record = \App\User::where('uuid', $id)->first();
25			if(!isset($record)){
26			return null;
27			}
28			$roles = $record->roles()->pluck('name')->toArray();
29			return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);
			0 ignored issues – show Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `path_picture` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `lastname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `firstname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `organization_id` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `uuid` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `email` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history...
30			}
31
32			public function add(User $u, string $password = null)
33			{
34			$userModel = new \App\User();
35			$data = $u->toArray();
36			unset($data['url_picture']);
37			unset($data['roles']);
38			$userModel->fill($data);
39			$userModel->password = $password;
			0 ignored issues – show Bug Best Practice introduced 2020-06-23 12:14 UTC by Report Bug Copy Issue Report The property `password` does not exist on `App\User`. Since you implemented `__set`, consider adding a @property annotation. Loading history...
40			$userModel->save();
41			}
42
43			public function update(User $u)
44			{
45			$userModel = \App\User::where('uuid', $u->id())->first();
46			$data = $u->toArray();
47			$roles = $data['roles'];
48			unset($data['url_picture']);
49			unset($data['roles']);
50			$userModel->fill($data);
51			$userModel->save();
52
53			$userModel->syncRoles($roles);
54			}
55
56			public function search(string $organizationId, int $page, int $perPage = 10): array
57			{
58			$records = DB::table('users')
59			->select()
60			->where('organization_id', $organizationId)
61			;
62			$count = $records->count();
63
64			$records = DB::table('users')
65			->select()
66			->where('organization_id', $organizationId)
67			->offset(($page-1)*$perPage)
68			->limit($perPage)
69			->get();
70			if(empty($records)){
71			return [];
72			}
73			$users = [];
74			foreach($records as $record){
75			$roles = \App\User::find($record->id)->roles()->pluck('name')->toArray();
76			$users[] = new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);
77			}
78			return [
79			'list' => $users,
80			'total' => $count
81			];
82			}
83
84			public function delete(string $userId)
85			{
86			$userModel = \App\User::where('uuid', $userId)->first();
87			$userModel->delete();
88			}
89
90			public function getAdminOfOrganization(string $organizationId): array
91			{
92			$records = \App\User::role(['admin'])->where('organization_id', $organizationId)->get();
93			if(empty($records)){
94			return [];
95			}
96			$users = [];
97			foreach($records as $record){
98			$roles = \App\User::find($record->id)->roles()->pluck('name')->toArray();
99			$users[] = new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles);
			0 ignored issues – show Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `path_picture` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `firstname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `organization_id` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `email` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `uuid` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-06-25 12:09 UTC by Report Bug Copy Issue Report The property `lastname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history...
100			}
101			return $users;
102			}
103
104			public function getByProvider(string $provider, string $providerId): ?User
105			{
106			$record = \App\User::where('providers->'.$provider, $providerId)->first();
107			if(!isset($record)){
108			return null;
109			}
110			$roles = $record->roles()->pluck('name')->toArray();
111			return new User($record->uuid, $record->email, $record->firstname, $record->lastname, $record->organization_id, $record->path_picture, $roles, $record->providers);
			0 ignored issues – show Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `path_picture` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `lastname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `firstname` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `providers` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `uuid` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `organization_id` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history... Bug Best Practice introduced 2020-07-09 08:00 UTC by Report Bug Copy Issue Report The property `email` does not exist on `App\User`. Since you implemented `__get`, consider adding a @property annotation. Loading history...
112			}
113
114
115			}
116

neayi / insights

Push — master ( dcfdf2...6863da )

UserRepositorySql::getByProvider() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like