Dominikzogg\EnergyCalculator\Repository\ComestibleRepository

Complexity

Total Complexity

6

Size/Duplication

Total Lines	58
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	5

Importance

Changes	6
Bugs	1	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	getQueryBuilderForFilterForm()	0	16	3
A	searchComestibleOfUser()	0	8	1
A	searchComestibleOfUserQb()	0	15	2

<?php

namespace Dominikzogg\EnergyCalculator\Repository;

use Doctrine\ORM\QueryBuilder;
use Dominikzogg\EnergyCalculator\Entity\Comestible;
use Dominikzogg\EnergyCalculator\Entity\User;

class ComestibleRepository extends AbstractRepository
{
    /**
     * @param  array        $filterData
     * @return QueryBuilder
     */
    public function getQueryBuilderForFilterForm(array $filterData = array())
    {
        $qb = $this->createQueryBuilder('c');

        if (isset($filterData['user'])) {
            $this->addEqualFilter($qb, 'c', 'user', $filterData['user']);
        }

        if (isset($filterData['name'])) {
            $this->addLikeFilter($qb, 'c', 'name', $filterData['name']);
        }

        $qb->addOrderBy('c.name', 'ASC');

        return $qb;
    }

    /**
     * @param  User         $user
     * @param  string|null  $search
     * @return Comestible[]
     */
    public function searchComestibleOfUser(User $user, $search = null)
    {
        return $this
            ->searchComestibleOfUserQb($user, $search)
            ->getQuery()
            ->getResult()
        ;
    }

    /**
     * @param  User         $user
     * @param  string|null  $search
     * @return QueryBuilder
     */
    public function searchComestibleOfUserQb(User $user, $search = null)
    {
        $qb = $this->createQueryBuilder('c');
        $qb->where($qb->expr()->eq('c.user', ':user'));
        $qb->setParameter('user', $user->getId());

        if (null !== $search) {
            $qb->andWhere($qb->expr()->like('c.name', ':name'));
            $qb->setParameter('name', '%'.$search.'%');
        }

        $qb->orderBy('c.name');

        return $qb;
    }
}