Нет описания

Bounce.php 849B

12345678910111213141516171819202122232425262728293031
  1. <?php
  2. namespace MailPoet\Tasks;
  3. if (!defined('ABSPATH')) exit;
  4. use MailPoet\Entities\ScheduledTaskEntity;
  5. use MailPoet\Models\ScheduledTaskSubscriber;
  6. use MailPoet\Models\Subscriber;
  7. class Bounce {
  8. public static function prepareSubscribers(ScheduledTaskEntity $task) {
  9. // Prepare subscribers on the DB side for performance reasons
  10. Subscriber::rawExecute(
  11. 'INSERT IGNORE INTO ' . MP_SCHEDULED_TASK_SUBSCRIBERS_TABLE . '
  12. (task_id, subscriber_id, processed)
  13. SELECT ? as task_id, s.`id` as subscriber_id, ? as processed
  14. FROM ' . MP_SUBSCRIBERS_TABLE . ' s
  15. WHERE s.`deleted_at` IS NULL
  16. AND s.`status` IN (?, ?)',
  17. [
  18. $task->getId(),
  19. ScheduledTaskSubscriber::STATUS_UNPROCESSED,
  20. Subscriber::STATUS_SUBSCRIBED,
  21. Subscriber::STATUS_UNCONFIRMED,
  22. ]
  23. );
  24. }
  25. }