| 12345678910111213141516171819202122232425262728293031 |
- <?php
- namespace MailPoet\Tasks;
- if (!defined('ABSPATH')) exit;
- use MailPoet\Entities\ScheduledTaskEntity;
- use MailPoet\Models\ScheduledTaskSubscriber;
- use MailPoet\Models\Subscriber;
- class Bounce {
- public static function prepareSubscribers(ScheduledTaskEntity $task) {
- // Prepare subscribers on the DB side for performance reasons
- Subscriber::rawExecute(
- 'INSERT IGNORE INTO ' . MP_SCHEDULED_TASK_SUBSCRIBERS_TABLE . '
- (task_id, subscriber_id, processed)
- SELECT ? as task_id, s.`id` as subscriber_id, ? as processed
- FROM ' . MP_SUBSCRIBERS_TABLE . ' s
- WHERE s.`deleted_at` IS NULL
- AND s.`status` IN (?, ?)',
- [
- $task->getId(),
- ScheduledTaskSubscriber::STATUS_UNPROCESSED,
- Subscriber::STATUS_SUBSCRIBED,
- Subscriber::STATUS_UNCONFIRMED,
- ]
- );
- }
- }
|