8889841cPK[„ûÝÝNewsletterOptionsRepository.phpnu„[µü¤ */ class NewsletterOptionsRepository extends Repository { protected function getEntityClassName() { return NewsletterOptionEntity::class; } /** * @return NewsletterOptionEntity[] */ public function findWelcomeNotificationsForSegments(array $segmentIds): array { return $this->entityManager->createQueryBuilder() ->select('no') ->from(NewsletterOptionEntity::class, 'no') ->join('no.newsletter', 'n') ->join('no.optionField', 'nof') ->where('n.deletedAt IS NULL') ->andWhere('n.type = :typeWelcome') ->andWhere('nof.name = :nameSegment') ->andWhere('no.value IN (:segmentIds)') ->setParameter('typeWelcome', NewsletterEntity::TYPE_WELCOME) ->setParameter('nameSegment', NewsletterOptionFieldEntity::NAME_SEGMENT) ->setParameter('segmentIds', $segmentIds) ->getQuery()->getResult(); } /** * @return NewsletterOptionEntity[] */ public function findAutomaticEmailsForSegments(array $segmentIds): array { return $this->entityManager->createQueryBuilder() ->select('no') ->from(NewsletterOptionEntity::class, 'no') ->join('no.newsletter', 'n') ->join('no.optionField', 'nof') ->where('n.deletedAt IS NULL') ->andWhere('n.type = :typeAutomatic') ->andWhere('nof.name = :nameSegment') ->andWhere('no.value IN (:segmentIds)') ->setParameter('typeAutomatic', NewsletterEntity::TYPE_AUTOMATIC) ->setParameter('nameSegment', NewsletterOptionFieldEntity::NAME_SEGMENT) ->setParameter('segmentIds', $segmentIds) ->getQuery()->getResult(); } } PK[Îã index.phpnu„[µü¤ */ class NewsletterOptionFieldsRepository extends Repository { protected function getEntityClassName() { return NewsletterOptionFieldEntity::class; } } PK[„ûÝÝNewsletterOptionsRepository.phpnu„[µü¤PK[Îã ,index.phpnu„[µü¤PK[Ž";ôÝÝ$kNewsletterOptionFieldsRepository.phpnu„[µü¤PK œ