Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
primogenial
/
languages
/
wp-content-20241001222009
/
plugins
/
mailpoet
/
lib
/
Subscribers
:
SubscriberIPsRepository.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php namespace MailPoet\Subscribers; if (!defined('ABSPATH')) exit; use MailPoet\Doctrine\Repository; use MailPoet\Entities\SubscriberIPEntity; use MailPoetVendor\Carbon\Carbon; /** * @extends Repository<SubscriberIPEntity> */ class SubscriberIPsRepository extends Repository { protected function getEntityClassName() { return SubscriberIPEntity::class; } public function findOneByIPAndCreatedAtAfterTimeInSeconds(string $ip, int $seconds): ?SubscriberIPEntity { return $this->entityManager->createQueryBuilder() ->select('sip') ->from(SubscriberIPEntity::class, 'sip') ->where('sip.ip = :ip') ->andWhere('sip.createdAt >= :timeThreshold') ->setParameter('ip', $ip) ->setParameter('timeThreshold', (new Carbon())->subSeconds($seconds)) ->setMaxResults(1) ->getQuery() ->getOneOrNullResult(); } public function getCountByIPAndCreatedAtAfterTimeInSeconds(string $ip, int $seconds): int { return $this->entityManager->createQueryBuilder() ->select('COUNT(sip)') ->from(SubscriberIPEntity::class, 'sip') ->where('sip.ip = :ip') ->andWhere('sip.createdAt >= :timeThreshold') ->setParameter('ip', $ip) ->setParameter('timeThreshold', (new Carbon())->subSeconds($seconds)) ->getQuery() ->getSingleScalarResult(); } public function deleteCreatedAtBeforeTimeInSeconds(int $seconds): int { return (int)$this->entityManager->createQueryBuilder() ->delete() ->from(SubscriberIPEntity::class, 'sip') ->where('sip.createdAt < :timeThreshold') ->setParameter('timeThreshold', (new Carbon())->subSeconds($seconds)) ->getQuery() ->execute(); } }