NewsRepository::getIds() - Code Metrics - Inspection of "Sitemap #10030" - Ecodev/artisans - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 475e48...cdfb9d )

by Sam

created 2024-02-15 23:32 UTC

NewsRepository::getIds() A

↳ Parent: NewsRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	12
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
eloc	8
dl	0
loc	12
ccs	0
cts	0
cp	0
rs	10
c	0
b	0
f	0
cc	1
nc	1
nop	0
crap	2

<?php

declare(strict_types=1);

namespace Application\Repository;

use Application\Model\News;
use Application\Model\User;

use Ecodev\Felix\Repository\LimitedAccessSubQuery;

/**
 * @extends AbstractRepository<News>
 */
class NewsRepository extends AbstractRepository implements LimitedAccessSubQuery
{
    /**
     * Returns pure SQL to get ID of all objects that are accessible to given user.
     *
     * A user can access a news if at least one of the following conditions is true:
     *
     * - he is administrator
     * - the news is active
     *
     * @param null|User $user
     */
    public function getAccessibleSubQuery(?\Ecodev\Felix\Model\User $user): string
    {
        if ($user && $user->getRole() === User::ROLE_ADMINISTRATOR) {
            return '';
        }

        return 'SELECT id FROM news WHERE is_active';
    }

    public function getIds(): array
    {
        $query = $this->createQueryBuilder('news')
            ->select('news.id')
            ->where('news.date < CURRENT_TIMESTAMP()')
            ->andWhere('news.is_active = true')
            ->orderBy('news.id')
            ->getQuery();

        $result = $query->getArrayResult();

        return $result;
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Application\Repository;
6
7			use Application\Model\News;
8			use Application\Model\User;
9
10			use Ecodev\Felix\Repository\LimitedAccessSubQuery;
11
12			/**
13			* @extends AbstractRepository<News>
14			*/
15			class NewsRepository extends AbstractRepository implements LimitedAccessSubQuery
16			{
17			/**
18			* Returns pure SQL to get ID of all objects that are accessible to given user.
19			*
20			* A user can access a news if at least one of the following conditions is true:
21			*
22			* - he is administrator
23			* - the news is active
24			*
25			* @param null\|User $user
26			*/
27			public function getAccessibleSubQuery(?\Ecodev\Felix\Model\User $user): string
28			{
29			if ($user && $user->getRole() === User::ROLE_ADMINISTRATOR) {
30			return '';
31			}
32
33			return 'SELECT id FROM news WHERE is_active';
34			}
35
36			public function getIds(): array
37			{
38			$query = $this->createQueryBuilder('news')
39			->select('news.id')
40			->where('news.date < CURRENT_TIMESTAMP()')
41			->andWhere('news.is_active = true')
42			->orderBy('news.id')
43			->getQuery();
44
45			$result = $query->getArrayResult();
46
47			return $result;
48			}
49			}
50

Ecodev / artisans

Push — master ( 475e48...cdfb9d )

NewsRepository::getIds() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like