示例#1
0
 /**
  * @param ProjectEntity $project
  * @param Access        $access
  *
  * @return ResultEntity[]
  */
 public function findResultByProjectAndAccess(ProjectEntity $project, Access $access)
 {
     $qb = $this->_em->createQueryBuilder();
     $qb->select('r');
     $qb->from("Project\\Entity\\Result\\Result", 'r');
     $qb->join('r.type', 't');
     $qb->join('t.access', 'a');
     $qb->where('r.project = ?1');
     $qb->andWhere($qb->expr()->in('a.id', [$access->getId()]));
     $qb->setParameter(1, $project);
     return $qb->getQuery()->getResult();
 }