Azine\EmailBundle\Entity\Repositories\SentEmailRepository

Complexity

Total Complexity

5

Size/Duplication

Total Lines	41
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Test Coverage

Coverage

0%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	search()	0	29	4
A	getTotalCount()	0	8	1

<?php

namespace Azine\EmailBundle\Entity\Repositories;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;

/**
 * SentEmailRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class SentEmailRepository extends EntityRepository
{
    public function search($searchParams = [])
    {
        $queryBuilder = $this->createQueryBuilder('e');

        if (empty($searchParams)) {
            return $queryBuilder;
        }

        $searchAttributes = [
            'recipients',
            'template',
            'sent',
            'variables',
            'token'
        ];

        foreach ($searchAttributes as $attribute) {
            if (empty($searchParams[$attribute])) {
                continue;
            }

            $attributeValue = $searchParams[$attribute];

            $queryBuilder->andWhere('e.'.$attribute.' LIKE :'.$attribute)
                ->setParameter(':'.$attribute, '%'.$attributeValue.'%');
        }

        return $queryBuilder;
    }

    public function getTotalCount(QueryBuilder $queryBuilder)
    {
        $queryBuilder = clone $queryBuilder;

        return $queryBuilder->select(
            'COUNT(e)'
        )->getQuery()->getSingleScalarResult();
    }
}