App\Repository\AbstractRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	25
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getCount()	0	7	1
A	search()	0	12	2

<?php

namespace App\Repository;

use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;

abstract class AbstractRepository extends ServiceEntityRepository
{
    public const CACHE_TTL = 60*60*24;

    public function getCount()
    {
        $qb = $this->createQueryBuilder('u');
        $query = $qb->select($qb->expr()->count('u'))->getQuery();

        return $query->getSingleScalarResult();
    }

    public function search(array $fields, string $query): array
    {
        $qb = $this->createQueryBuilder('e');

        foreach ($fields as $field) {
            $qb->orWhere("e.$field LIKE :query")
                ->setParameter('query', "%$query%");
        }


        return $qb->getQuery()->getResult();
    }
}