Chamilo\CourseBundle\Entity\Repository\CQuizQuestionRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	countQuestionsInExercise()	0	11	1
A	countEmbeddableQuestionsInExercise()	0	16	1

<?php

/* For licensing terms, see /license.txt */

namespace Chamilo\CourseBundle\Entity\Repository;

use Chamilo\CourseBundle\Entity\CQuizRelQuestion;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;
use Doctrine\ORM\Query\Expr\Join;

class CQuizQuestionRepository extends EntityRepository
{
    /**
     * @throws NonUniqueResultException
     * @throws NoResultException
     */
    public function countQuestionsInExercise(int $exerciseId): int
    {
        $query = $this->createQueryBuilder('qq')
            ->select('COUNT(qq)')
            ->innerJoin(CQuizRelQuestion::class, 'qrq', Join::WITH, 'qq.iid = qrq.questionId')
            ->where('qrq.exerciceId = :id')
            ->setParameters(['id' => $exerciseId])
            ->getQuery()
        ;

        return (int) $query->getSingleScalarResult();
    }

    /**
     * @throws NonUniqueResultException
     * @throws NoResultException
     */
    public function countEmbeddableQuestionsInExercise(int $exerciseId): int
    {
        $query = $this->createQueryBuilder('qq')
            ->select('COUNT(qq)')
            ->innerJoin(CQuizRelQuestion::class, 'qrq', Join::WITH, 'qq.iid = qrq.questionId')
            ->where('qrq.exerciceId = :id AND qq.type IN (:types)')
            ->setParameters(
                [
                    'id' => $exerciseId,
                    'types' => \ExerciseLib::getEmbeddableTypes(),
                ]
            )
            ->getQuery()
        ;

        return (int) $query->getSingleScalarResult();
    }
}