Stu\Orm\Repository\TutorialStepRepository::findByUserAndViewContext()

Complexity

Conditions	2
Paths	2

Size

Total Lines	37
Code Lines	27

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function findByUserAndViewContext(UserInterface $user, ViewContext $viewContext): array
    {
        $subquery = $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT ts.id
             FROM %s ts
             JOIN %s ut WITH ts.id = ut.tutorial_step_id
             WHERE ut.user = :user
             AND ts.module = :module
             AND ts.view = :view',
                TutorialStep::class,
                UserTutorial::class
            )
        )->setParameters([
            'user' => $user,
            'module' => $viewContext->getModule()->value,
            'view' => $viewContext->getViewIdentifier(),
        ]);

        $result = $subquery->getOneOrNullResult();

        if (!$result) {
            return [];
        }


        return $this->getEntityManager()->createQuery(
            sprintf(
                'SELECT ts FROM %s ts
             WHERE ts.module = :module
             AND ts.view = :view',
                TutorialStep::class
            )
        )->setParameters([
            'module' => $viewContext->getModule()->value,
            'view' => $viewContext->getViewIdentifier(),
        ])->getResult();
    }