8889841cwp-content/plugins/mailpoet/lib/Segments/DynamicSegments/Filters/EmailActionClickAny.php000064400000003336150515570060033322 0ustar00home/clixcotz/tcchp.clix.co.tzentityManager = $entityManager; } public function apply(QueryBuilder $queryBuilder, DynamicSegmentFilterEntity $filter): QueryBuilder { $subscribersTable = $this->entityManager->getClassMetadata(SubscriberEntity::class)->getTableName(); $newsletterLinksTable = $this->entityManager->getClassMetadata(NewsletterLinkEntity::class)->getTableName(); $statsTable = $this->entityManager->getClassMetadata(StatisticsClickEntity::class)->getTableName(); $excludedLinks = [ '[link:subscription_unsubscribe_url]', '[link:subscription_instant_unsubscribe_url]', '[link:newsletter_view_in_browser_url]', '[link:subscription_manage_url]', ]; $queryBuilder = $queryBuilder->innerJoin( $subscribersTable, $statsTable, 'stats', "stats.subscriber_id = $subscribersTable.id" )->innerJoin( 'stats', $newsletterLinksTable, 'newsletterLinks', "stats.link_id = newsletterLinks.id AND newsletterLinks.URL NOT IN ('" . join("', '", $excludedLinks) . "')" ); return $queryBuilder; } }