QuestionRepository::retrieveFirstByCategorySlug() - Code Metrics - Inspection of "Update migrations from 1.11.x add skill rel item a..." - chamilo/chamilo-lms - Measure and Improve Code Quality continuously with Scrutinizer

Test Failed

Push — master ( 482637...7bef58 )

by Julito

created 2018-03-27 09:33 UTC

QuestionRepository::retrieveFirstByCategorySlug() A

↳ Parent: QuestionRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	9
nc	1
nop	1
dl	0
loc	13
rs	9.4285
c	0
b	0
f	0

<?php
/* For licensing terms, see /license.txt */

namespace Chamilo\FaqBundle\Entity;

use Doctrine\ORM\EntityRepository;

/**
 * Class QuestionRepository
 *
 * @package Genj\FaqBundle\Entity
 */
class QuestionRepository extends EntityRepository
{
    /**
     * @param string $categorySlug
     *
     * @return Question|null
     */
    public function retrieveFirstByCategorySlug($categorySlug)
    {
        $query = $this->createQueryBuilder('q')
            ->join('q.category', 'c')
            ->join('c.translations', 't')
            ->where('t.slug = :categorySlug')
            ->orderBy('q.rank', 'ASC')
            ->setMaxResults(1)
            ->getQuery();

        $query->setParameter('categorySlug', $categorySlug);

        return $query->getOneOrNullResult();
    }

    /**
     * @param string $slug
     *
     * @return Question|null
     */
    public function getQuestionBySlug($slug)
    {
        $query = $this->createQueryBuilder('q')
            ->join('q.translations', 't')
            ->where('t.slug = :slug')
            ->orderBy('q.rank', 'ASC')
            ->setMaxResults(1)
            ->getQuery();

        $query->setParameter('slug', $slug);

        return $query->getOneOrNullResult();
    }
}


1			<?php
2			/* For licensing terms, see /license.txt */
3
4			namespace Chamilo\FaqBundle\Entity;
5
6			use Doctrine\ORM\EntityRepository;
7
8			/**
9			* Class QuestionRepository
10			*
11			* @package Genj\FaqBundle\Entity
12			*/
13			class QuestionRepository extends EntityRepository
14			{
15			/**
16			* @param string $categorySlug
17			*
18			* @return Question\|null
19			*/
20			public function retrieveFirstByCategorySlug($categorySlug)
21			{
22			$query = $this->createQueryBuilder('q')
23			->join('q.category', 'c')
24			->join('c.translations', 't')
25			->where('t.slug = :categorySlug')
26			->orderBy('q.rank', 'ASC')
27			->setMaxResults(1)
28			->getQuery();
29
30			$query->setParameter('categorySlug', $categorySlug);
31
32			return $query->getOneOrNullResult();
33			}
34
35			/**
36			* @param string $slug
37			*
38			* @return Question\|null
39			*/
40			public function getQuestionBySlug($slug)
41			{
42			$query = $this->createQueryBuilder('q')
43			->join('q.translations', 't')
44			->where('t.slug = :slug')
45			->orderBy('q.rank', 'ASC')
46			->setMaxResults(1)
47			->getQuery();
48
49			$query->setParameter('slug', $slug);
50
51			return $query->getOneOrNullResult();
52			}
53			}
54

chamilo / chamilo-lms

Push — master ( 482637...7bef58 )

QuestionRepository::retrieveFirstByCategorySlug() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like