findSame

AddressRubricRepository.php

    public function findSame($entity)
    {
        $qb = $this->getEntityManager()->createQueryBuilder();
        $qb
            ->select('ar')
            ->from('AppAddressBundle:AddressRubric', 'ar')
            ->where('ar.address = :address')
            ->andWhere('ar.rubric = :rubric')
            ->andWhere('ar.id != :id')
            ->setParameter('address', $entity->getAddress())
            ->setParameter('rubric', $entity->getRubric())
            ->setParameter('id', $entity)
        ;

        if ($tariff = $entity->getTariff()) {
            $qb
                ->andWhere('ar.tariff = :tariff')
                ->setParameter('tariff', $tariff)
            ;
        } else {
            $qb
                ->andWhere('ar.tariff is null')
            ;
        }
        $qb->setMaxResults(1);

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