Newscoop\Entity\Repository\UserTopicRepository::findByTopicAndUser PHP Метод

findByTopicAndUser() публичный Метод

Find results for user and topic
public findByTopicAndUser ( User $user, Topic $topic ) : Newscoop\Entity\UserTopic
$user Newscoop\Entity\User
$topic Newscoop\NewscoopBundle\Entity\Topic
Результат Newscoop\Entity\UserTopic
    public function findByTopicAndUser(User $user, Topic $topic)
    {
        $em = $this->getEntityManager();
        $locale = $em->getRepository("Newscoop\\NewscoopBundle\\Entity\\Topic")->getTranslatableTopicLocale($topic);
        $qb = $em->createQueryBuilder()->select(array('ut'))->from('Newscoop\\Entity\\UserTopic', 'ut')->leftJoin('ut.user', 'u')->leftJoin('ut.topic', 't')->leftJoin('t.translations', 'tt')->where('u.id = :user_id')->andWhere('t.id = :topic_id')->andWhere('tt.locale = :topic_language_id')->setParameters(array('user_id' => $user->getId(), 'topic_id' => $topic->getId(), 'topic_language_id' => $locale));
        return $qb->getQuery()->getResult();
    }