public function findAvailableEnvironements(Environment $defaultEnv) { /** @var QueryBuilder $qb */ $qb = $this->createQueryBuilder('e'); $qb->where($qb->expr()->neq('e.id', ':defaultEnvId')); $qb->andWhere('e.managed <> 0'); $qb->orderBy('e.name', 'ASC'); $qb->setParameter('defaultEnvId', $defaultEnv->getId()); return $qb->getQuery()->getResult(); }
public function findByOuuidAndContentTypeAndEnvironnement(ContentType $contentType, $ouuid, Environment $env) { $qb = $this->createQueryBuilder('r'); $qb->join('r.environments', 'e'); $qb->where('r.ouuid = :ouuid and e.id = :envId and r.contentType = :contentTypeId'); $qb->setParameters(['ouuid' => $ouuid, 'envId' => $env->getId(), 'contentTypeId' => $contentType->getId()]); return $qb->getQuery()->getResult(); }