App\Src\UseCases\Infra\Sql\SqlOrganizationRepository

Complexity

Total Complexity

7

Size/Duplication

Total Lines	52
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	search()	0	22	3
A	add()	0	5	1
A	update()	0	5	1
A	get()	0	11	2

<?php


namespace App\Src\UseCases\Infra\Sql;


use App\Src\UseCases\Domain\Organizations\Model\Address;
use App\Src\UseCases\Domain\Organizations\Model\Organization;
use App\Src\UseCases\Domain\Ports\OrganizationRepository;
use Illuminate\Support\Facades\DB;

class SqlOrganizationRepository implements OrganizationRepository
{
    public function get(string $id): ?Organization
    {
        $record = DB::table('organizations')
            ->select()
            ->where('uuid', $id)
            ->first();
        if(!isset($record)){
            return null;
        }
        $address = new Address($record->city, $record->address1, $record->address2, $record->postal_code);
        return new Organization($id, $record->name, $record->path_picture, $address);
    }

    public function add(Organization $o)
    {
        $data = $o->toArray();
        unset($data['url_picture']);
        DB::table('organizations')->insert($data);
    }

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

        $records = DB::table('organizations')
            ->select()
            ->offset(($page-1)*$perPage)
            ->limit($perPage)
            ->get();
        if(empty($records)){
            return [];
        }
        $organizations = [];
        foreach($records as $record){
            $address = new Address($record->city, $record->address1, $record->address2, $record->postal_code);
            $organizations[] = new Organization($record->uuid, $record->name, $record->path_picture, $address);
        }
        return [
            'list' => $organizations,
            'total' => $count
        ];
    }

    public function update(Organization $o)
    {
        $data = $o->toArray();
        unset($data['url_picture']);
        DB::table('organizations')->where('uuid', $o->id())->update($data);
    }


}