LogRepository::findSnapshots() - Code Metrics - Inspection of "Plugin: Exercise monitoring and mouse focus tracki..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — 1.11.x ( 3e2582...775a54 )

by Angel Fernando Quiroz

created 2024-10-28 22:34 UTC

LogRepository::findSnapshots() A

↳ Parent: LogRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines	20
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	12
dl	0
loc	20
rs	9.8666
c	1
b	0
f	0
cc	2
nc	2
nop	2

<?php

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

namespace Chamilo\PluginBundle\ExerciseMonitoring\Repository;

use Chamilo\CoreBundle\Entity\TrackEExercises;
use Chamilo\CourseBundle\Entity\CQuizQuestion;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\Query\Expr\Join;
use Exercise;

class LogRepository extends EntityRepository
{
    public function findByLevelAndExe(int $level, TrackEExercises $exe): array
    {
        return $this->findBy(
            [
                'level' => $level,
                'exe' => $exe,
            ],
            ['createdAt' => 'ASC']
        );
    }

    public function findSnapshots(Exercise $objExercise, TrackEExercises $trackExe)
    {
        $qb = $this->createQueryBuilder('l');

        $qb->select(['l.imageFilename', 'l.createdAt']);

        if (ONE_PER_PAGE == $objExercise->selectType()) {
            $qb
                ->addSelect(['qq.question AS log_level'])
                ->leftJoin(CQuizQuestion::class, 'qq', Join::WITH, 'l.level = qq.iid');
        }

        $query = $qb
            ->andWhere(
                $qb->expr()->eq('l.exe', $trackExe->getExeId())
            )
            ->addOrderBy('l.createdAt')
            ->getQuery();

        return $query->getResult();
    }
}


1			<?php
2
3			/* For licensing terms, see /license.txt */
4
5			namespace Chamilo\PluginBundle\ExerciseMonitoring\Repository;
6
7			use Chamilo\CoreBundle\Entity\TrackEExercises;
8			use Chamilo\CourseBundle\Entity\CQuizQuestion;
9			use Doctrine\ORM\EntityRepository;
10			use Doctrine\ORM\Query\Expr\Join;
11			use Exercise;
12
13			class LogRepository extends EntityRepository
14			{
15			public function findByLevelAndExe(int $level, TrackEExercises $exe): array
16			{
17			return $this->findBy(
18			[
19			'level' => $level,
20			'exe' => $exe,
21			],
22			['createdAt' => 'ASC']
23			);
24			}
25
26			public function findSnapshots(Exercise $objExercise, TrackEExercises $trackExe)
27			{
28			$qb = $this->createQueryBuilder('l');
29
30			$qb->select(['l.imageFilename', 'l.createdAt']);
31
32			if (ONE_PER_PAGE == $objExercise->selectType()) {
33			$qb
34			->addSelect(['qq.question AS log_level'])
35			->leftJoin(CQuizQuestion::class, 'qq', Join::WITH, 'l.level = qq.iid');
36			}
37
38			$query = $qb
39			->andWhere(
40			$qb->expr()->eq('l.exe', $trackExe->getExeId())
41			)
42			->addOrderBy('l.createdAt')
43			->getQuery();
44
45			return $query->getResult();
46			}
47			}
48

chamilo / chamilo-lms

Push — 1.11.x ( 3e2582...775a54 )

LogRepository::findSnapshots() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like