BasePostRepository::countCommentsQuery() - Code Metrics - sonata-project/SonataNewsBundle - Measure and Improve Code Quality continuously with Scrutinizer

BasePostRepository::countCommentsQuery() A
last analyzed 2020-08-28 02:03 UTC

↳ Parent: BasePostRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	13
rs	9.8333
c	0
b	0
f	0
cc	1
nc	1
nop	1

<?php

declare(strict_types=1);

/*
 * This file is part of the Sonata Project package.
 *
 * (c) Thomas Rabaix <[email protected]>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Sonata\NewsBundle\Entity;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;
use Sonata\NewsBundle\Model\CommentInterface;

class BasePostRepository extends EntityRepository
{
    /**
     * return last post query builder.
     *
     * @param int $limit
     *
     * @return \Doctrine\ORM\QueryBuilder
     */
    public function findLastPostQueryBuilder($limit)

    {
        return $this->createQueryBuilder('p')
            ->where('p.enabled = true')
            ->orderBy('p.createdAt', 'DESC');
    }

    /**
     * return count comments QueryBuilder.
     *
     * @param PostInterface $post
     *
     * @return QueryBuilder
     */
    public function countCommentsQuery($post)
    {
        $qb = $this->createQueryBuilder('c');

        return $qb
            ->select('COUNT(c.id)')
            ->where($qb->expr()->eq('c.status', ':status'))
            ->andWhere($qb->expr()->eq('c.post', ':post'))
            ->setParameters([
                'status' => CommentInterface::STATUS_VALID,
                'post' => $post,
            ]);
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			/*
6			* This file is part of the Sonata Project package.
7			*
8			* (c) Thomas Rabaix <[email protected]>
9			*
10			* For the full copyright and license information, please view the LICENSE
11			* file that was distributed with this source code.
12			*/
13
14			namespace Sonata\NewsBundle\Entity;
15
16			use Doctrine\ORM\EntityRepository;
17			use Doctrine\ORM\QueryBuilder;
18			use Sonata\NewsBundle\Model\CommentInterface;
19
20			class BasePostRepository extends EntityRepository
21			{
22			/**
23			* return last post query builder.
24			*
25			* @param int $limit
26			*
27			* @return \Doctrine\ORM\QueryBuilder
28			*/
29			public function findLastPostQueryBuilder($limit)
			0 ignored issues – show Unused Code introduced 2017-08-02 00:29 UTC by Report Bug Copy Issue Report The parameter `$limit` is not used and could be removed. This check looks from parameters that have been defined for a function or method, but which are not used in the method body. Loading history...
30			{
31			return $this->createQueryBuilder('p')
32			->where('p.enabled = true')
33			->orderBy('p.createdAt', 'DESC');
34			}
35
36			/**
37			* return count comments QueryBuilder.
38			*
39			* @param PostInterface $post
40			*
41			* @return QueryBuilder
42			*/
43			public function countCommentsQuery($post)
44			{
45			$qb = $this->createQueryBuilder('c');
46
47			return $qb
48			->select('COUNT(c.id)')
49			->where($qb->expr()->eq('c.status', ':status'))
50			->andWhere($qb->expr()->eq('c.post', ':post'))
51			->setParameters([
52			'status' => CommentInterface::STATUS_VALID,
53			'post' => $post,
54			]);
55			}
56			}
57

sonata-project / SonataNewsBundle

BasePostRepository::countCommentsQuery() A last analyzed 2020-08-28 02:03 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

BasePostRepository::countCommentsQuery() A
last analyzed 2020-08-28 02:03 UTC