Server IP : 104.21.14.103 / Your IP : 3.16.212.27 Web Server : LiteSpeed System : Linux business53.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : giankuin ( 1871) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/proc/thread-self/root/proc/thread-self/root/home/giankuin/thietke365.net/wp-content/plugins/mailpoet/lib/Newsletter/Options/ |
Upload File : |
<?php // phpcs:ignore SlevomatCodingStandard.TypeHints.DeclareStrictTypes.DeclareStrictTypesMissing namespace MailPoet\Newsletter\Options; if (!defined('ABSPATH')) exit; use MailPoet\Doctrine\Repository; use MailPoet\Entities\NewsletterEntity; use MailPoet\Entities\NewsletterOptionEntity; use MailPoet\Entities\NewsletterOptionFieldEntity; /** * @extends Repository<NewsletterOptionEntity> */ 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(); } }