/** * @param string $institution */ public function getByInstitutionAndSubject($institution, Subject $subject) { $qb = $this->createQueryBuilder('j'); $qb->join('j.institution', 'i', 'WITH', 'i.slug=:institution')->join('j.subjects', 's', 'WITH', 's.id=:subject')->setParameter('institution', $institution)->setParameter('subject', $subject->getId()); return $qb->getQuery()->getResult(); }
/** * @param $publisherSlug * @param Subject $subject * @return array */ public function getByPublisherAndSubject($publisherSlug, Subject $subject) { $qb = $this->createQueryBuilder('j'); $qb->join('j.publisher', 'i', 'WITH', 'i.slug = :publisherSlug')->join('j.subjects', 's', 'WITH', 's.id = :subject')->setParameter('publisherSlug', $publisherSlug)->setParameter('subject', $subject->getId()); return $qb->getQuery()->getResult(); }