App\Src\UseCases\Infra\Sql\UserRepositorySql

Complexity

Total Complexity

13

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	getById()	0	8	2
A	update()	0	11	1
A	add()	0	9	1
A	search()	0	25	3
A	getByEmail()	0	8	2
A	getAdminOfOrganization()	0	12	3
A	delete()	0	4	1

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

The property email does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property organization_id does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property lastname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property firstname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property path_picture does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property uuid does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

    }

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

The property path_picture does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property lastname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property firstname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property organization_id does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property uuid does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property email does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

    }

    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;

The property password does not exist on App\User. Since you implemented __set, consider adding a @property annotation.

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

The property path_picture does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property firstname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property organization_id does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property email does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property uuid does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

The property lastname does not exist on App\User. Since you implemented __get, consider adding a @property annotation.

        }
        return $users;
    }
}