Chamilo\CoreBundle\Repository\Node\AccessUrlRepository

Complexity

Total Complexity

10

Size/Duplication

Total Lines	117
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	getFirstId()	0	11	2
A	findByUser()	0	11	1
A	__construct()	0	3	1
A	getUserActivePortals()	0	11	1
A	getUrlList()	0	6	1
A	exists()	0	8	1
A	getOnlyLoginAccessUrl()	0	3	1
A	isUrlActiveForUser()	0	17	1
A	findAll()	0	3	1

<?php

declare(strict_types=1);

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

namespace Chamilo\CoreBundle\Repository\Node;

use Chamilo\CoreBundle\Entity\AccessUrl;
use Chamilo\CoreBundle\Entity\User;
use Chamilo\CoreBundle\Repository\ResourceRepository;
use Doctrine\ORM\NonUniqueResultException;
use Doctrine\ORM\NoResultException;
use Doctrine\ORM\QueryBuilder;
use Doctrine\Persistence\ManagerRegistry;

class AccessUrlRepository extends ResourceRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, AccessUrl::class);
    }

    /**
     * Select the first access_url ID in the list as a default setting for
     * the creation of new users.
     */
    public function getFirstId(): int
    {
        $qb = $this->createQueryBuilder('a');
        $qb->select('MIN (a.id)');

        $q = $qb->getQuery();

        try {
            return (int) $q->getSingleScalarResult();
        } catch (NonUniqueResultException|NoResultException $e) {
            return 0;
        }
    }

    /**
     * @return array<int, AccessUrl>
     */
    public function findByUser(User $user): array
    {
        /** @var QueryBuilder $qb */
        $qb = $this->createQueryBuilder('url');

        return $qb
            ->join('url.users', 'users')
            ->where($qb->expr()->eq('users.user', ':user'))
            ->setParameter('user', $user->getId())
            ->getQuery()
            ->getResult()
        ;
    }

    public function getUserActivePortals(User $user): QueryBuilder
    {
        /** @var QueryBuilder $qb */
        $qb = $this->createQueryBuilder('url');

        return $qb
            ->join('url.users', 'users')
            ->where($qb->expr()->eq('users.user', ':user'))
            ->andWhere($qb->expr()->eq('url.active', true))
            ->andWhere($qb->expr()->neq('url.isLoginOnly', true))
            ->setParameter('user', $user->getId())
        ;
    }

    public function getOnlyLoginAccessUrl(): ?AccessUrl
    {
        return $this->findOneBy(['isLoginOnly' => true]);
    }

    /**
     * @throws NonUniqueResultException
     * @throws NoResultException
     */
    public function exists(string $url): bool
    {
        return $this->createQueryBuilder('a')
            ->select('COUNT(a.id)')
            ->where('a.url = :url')
            ->setParameter('url', $url)
            ->getQuery()
            ->getSingleScalarResult() > 0
        ;
    }

    /**
     * @return array<int, string>
     */
    public function getUrlList(): array
    {
        return $this->createQueryBuilder('a')
            ->select('a.url')
            ->getQuery()
            ->getSingleColumnResult()
        ;
    }

    /**
     * @throws NonUniqueResultException
     * @throws NoResultException
     */
    public function isUrlActiveForUser(AccessUrl $url, User $user): bool
    {
        $qb = $this->getOrCreateQueryBuilder(null, 'a');

        $count = $qb
            ->select('COUNT(a.id)')
            ->join('a.users', 'u')
            ->where($qb->expr()->eq('a.id', ':url'))
            ->andWhere($qb->expr()->eq('u.user', ':user'))
            ->andWhere($qb->expr()->eq('a.active', 1))
            ->setParameter('url', $url->getId())
            ->setParameter('user', $user->getId())
            ->getQuery()
            ->getSingleScalarResult()
        ;

        return $count > 0;
    }

    /**
     * @return array<int, AccessUrl>
     */
    public function findAll(string $orientation = 'ASC'): array
    {
        return parent::findBy([], ['url' => $orientation]); // TODO: Change the autogenerated stub
    }
}