App\Repository\PropertyRepository

Complexity

Total Complexity

9

Size/Duplication

Total Lines	69
Duplicated Lines	0 %

Importance

Changes	2
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	findLimit()	0	7	1
A	__construct()	0	3	1
A	countAll()	0	8	1
A	findByFilter()	0	24	4
A	createPaginator()	0	7	1
A	findLatest()	0	8	1

<?php

declare(strict_types=1);

namespace App\Repository;

use App\Entity\Property;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\ORM\Query;
use Pagerfanta\Adapter\DoctrineORMAdapter;
use Pagerfanta\Pagerfanta;
use Symfony\Bridge\Doctrine\RegistryInterface;

/**
 * @method Property|null find($id, $lockMode = null, $lockVersion = null)
 * @method Property|null findOneBy(array $criteria, array $orderBy = null)
 * @method Property[]    findAll()
 * @method Property[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
final class PropertyRepository extends ServiceEntityRepository
{
    public function __construct(RegistryInterface $registry)
    {
        parent::__construct($registry, Property::class);
    }

    public function countAll(): int
    {
        $count = $this->createQueryBuilder('p')
            ->select('count(p.id)')
            ->getQuery()
            ->getSingleScalarResult();

        return (int) $count;
    }

    public function findLatest(int $page = 1): Pagerfanta
    {
        $qb = $this->createQueryBuilder('p')
            ->addSelect('f')
            ->leftJoin('p.photos', 'f')
            ->orderBy('p.id', 'DESC');

        return $this->createPaginator($qb->getQuery(), $page);
    }

    public function findByFilter(int $locality, int $operation, int $category, int $page = 1): Pagerfanta
    {
        $qb = $this->createQueryBuilder('p');

        $qb->Where('p.published = 1');

        // Locality
        if ($locality > 0) {
            $qb->andWhere('p.locality = '.(int) $locality);
        }

        // Operation
        if ($operation > 0) {
            $qb->andWhere('p.operation = '.(int) $operation);
        }

        // Category
        if ($category > 0) {
            $qb->andWhere('p.category = '.(int) $category);
        }

        $qb->orderBy('p.id', 'DESC');

        return $this->createPaginator($qb->getQuery(), $page);
    }

    private function findLimit(): int
    {
        $em = $this->getEntityManager();

        $query = $em->createQuery("SELECT s.items_per_page FROM App\Entity\Setting s");

        return (int) $query->getSingleScalarResult();
    }

    private function createPaginator(Query $query, int $page): Pagerfanta
    {
        $paginator = new Pagerfanta(new DoctrineORMAdapter($query));
        $paginator->setMaxPerPage($this->findLimit());
        $paginator->setCurrentPage($page);

        return $paginator;
    }
}