App\Src\UseCases\Infra\Sql\InteractionPageRepositorySql

Complexity

Total Complexity

17

Size/Duplication

Total Lines	174
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	transfer()	0	8	1
A	save()	0	17	2
A	getByInteractUser()	0	17	3
A	getDoneByUser()	0	16	2
A	getCountInteractionsOnPage()	0	23	1
A	getFollowersPage()	0	45	3
A	getInteractionsByUser()	0	22	5

<?php


namespace App\Src\UseCases\Infra\Sql;


use App\Src\UseCases\Domain\Context\Dto\FollowerDto;
use App\Src\UseCases\Domain\Context\Dto\PractiseVo;
use App\Src\UseCases\Domain\Context\Model\CanInteract;
use App\Src\UseCases\Domain\Context\Model\Interaction;
use App\Src\UseCases\Domain\Ports\InteractionRepository;
use App\Src\UseCases\Infra\Sql\Model\CharacteristicsModel;
use App\Src\UseCases\Infra\Sql\Model\InteractionModel;
use App\Src\UseCases\Infra\Sql\Model\PageModel;
use App\User;
use Illuminate\Contracts\Pagination\Paginator;

class InteractionPageRepositorySql implements InteractionRepository
{
    public function save(CanInteract $canInteract, Interaction $interaction)
    {
        $user = User::query()->where('uuid', $canInteract->identifier())->first();

        $interactionModel = InteractionModel::query()
            ->where($canInteract->key(), $user->id ?? $canInteract->identifier())
            ->where('page_id', $interaction->pageId())
            ->first();

        if($interactionModel === null) {
            $interactionModel = new InteractionModel();
            $interactionModel->{$canInteract->key()} = $user->id ?? $canInteract->identifier();
        }

        $interactionModel->fill($interaction->toArray());
        $interactionModel->start_done_at = $interaction->toArray()['value']['start_at'] ?? null;
        $interactionModel->save();
    }

    public function getByInteractUser(CanInteract $canInteract, int $pageId): ?Interaction
    {
        if($canInteract->key() == 'user_id') {
            $user = User::query()->where('uuid', $canInteract->identifier())->first();
        }

        $interactionModel = InteractionModel::query()
            ->where($canInteract->key(), $user->id ?? $canInteract->identifier())

The variable $user does not seem to be defined for all execution paths leading up to this point.

            ->where('page_id', $pageId)
            ->first();

        if(!isset($interactionModel)){
            return null;
        }

        $value = $interactionModel->value ?? [];
        return new Interaction($pageId, $interactionModel->follow, $interactionModel->applause, $interactionModel->done, $value);
    }

    public function transfer(CanInteract $anonymous, CanInteract $registered)
    {
        $user = User::query()->where('uuid', $registered->identifier())->first();

        InteractionModel::query()->where($anonymous->key(), $anonymous->identifier())
            ->update([
                $anonymous->key() => null,
                $registered->key() => $user->id
            ]);
    }

    public function getCountInteractionsOnPage(int $pageId):array
    {
        $applause = InteractionModel::query()
            ->where('page_id', $pageId)
            ->where('applause', true)
            ->count();

        // For follows and done, don't include Neayi people - we tend to spoil the results with our faces
        $follow = InteractionModel::query()
            ->where('page_id', $pageId)
            ->where('follow', true)
            ->join('users', 'users.id', 'interactions.user_id')
            ->where('users.email', 'NOT LIKE', '%@neayi.com')
            ->count();

        $done = InteractionModel::query()
            ->where('page_id', $pageId)
            ->where('done', true)
            ->join('users', 'users.id', 'interactions.user_id')
            ->where('users.email', 'NOT LIKE', '%@neayi.com')
            ->count();

        return ['follow' => $follow, 'done' => $done, 'applause' => $applause];
    }

    public function getInteractionsByUser(string $userId): array
    {
        $user = User::query()->where('uuid', $userId)->first();
        $interactionsModel = InteractionModel::query()
            ->where('user_id', $user->id)
            ->orderBy('updated_at', 'desc')
            ->get();

        foreach($interactionsModel as $interaction) {
            $page = PageModel::query()->where('page_id', $interaction->page_id)->first();
            if(!isset($page)){
                continue;
            }
            $applause = InteractionModel::query()->where('page_id', $interaction->page_id)->where('applause', true)->count();
            if ($interaction->follow) {
                $interactions['follow'][] = array_merge($page->toArray(), ['applause' => $applause]);
            }
            if ($interaction->applause) {
                $interactions['applause'][] = array_merge($page->toArray(), ['applause' => $applause]);
            }
        }
        return $interactions ?? [];
    }


    public function getDoneByUser(string $userId): array
    {
        $user = User::query()->where('uuid', $userId)->first();
        $records = InteractionModel::query()
            ->with('page')
            ->where('user_id', $user->id)
            ->where('done', true)
            ->get();
        foreach ($records as $record){
            $practises[] = new PractiseVo(
                $record->page_id,
                $record->page->title ?? '',
                $record->start_done_at ?? null

It seems like $record->start_done_at ?? null can also be of type string; however, parameter $doneAt of App\Src\UseCases\Domain\Context\Dto\PractiseVo::__construct() does only seem to accept DateTime|null, maybe add an additional type check?

            );
        }
        return $practises ?? [];
    }


    /**
     * @param int $pageId
     * @param string $type
     * @param string|null $cp
     * @param string|null $characteristicId
     * @param string|null $characteristicIdCroppingSystem
     * @return Paginator
     *
    */
    public function getFollowersPage(int $pageId, string $type = 'follow', ?string $departmentNumber = null, ?string $characteristicId = null, ?string $characteristicIdCroppingSystem = null): Paginator
    {
        return  InteractionModel::query()
            ->with('user.context')
            ->where(function ($query) use ($type){
                $query->when($type === 'follow', function ($query) {
                    $query->where('follow', true);
                    $query->orWhere('done', true);
                })
                ->when($type === 'do', function ($query) {
                    $query->where('done', true);
                });
            })
            ->when($characteristicId !== null, function ($query) use($characteristicId) {
                $characteristic = CharacteristicsModel::query()->where('uuid', $characteristicId)->first();
                if(!isset($characteristic)){
                    return;
                }
                $query->whereRaw(
                    'exists(SELECT * FROM user_characteristics where characteristic_id = ? AND user_characteristics.user_id = interactions.user_id)',
                    $characteristic->id
                );
            })
            ->when($characteristicIdCroppingSystem !== null, function ($query) use($characteristicIdCroppingSystem) {
                $characteristic = CharacteristicsModel::query()->where('uuid', $characteristicIdCroppingSystem)->first();
                if(!isset($characteristic)){
                    return;
                }
                $query->whereRaw(
                    'exists(SELECT * FROM user_characteristics where characteristic_id = ? AND user_characteristics.user_id = interactions.user_id)',
                    $characteristic->id
                );
            })
            ->when($departmentNumber !== null, function ($query) use($departmentNumber) {
                $query
                    ->join('users', 'users.id', 'interactions.user_id')
                    ->join('contexts', 'users.context_id', 'contexts.id')
                    ->where('contexts.department_number', $departmentNumber);
            })
            ->where('page_id', $pageId)
            ->whereNotNull('interactions.user_id')
            ->orderBy('interactions.updated_at', 'desc')
            ->paginate()
            ->through(function ($item){
                return new FollowerDto($item->user->toDto(), $item->user->context->toDto(), $item->toDto());
            })
        ;
    }
}