?HAMA

Navigation

Breadcrumbs

Create

Edit File Size: 2.02 KB

/home/nshryvcy/himaltourism.com/wp-content/plugins/mailpoet/lib/Models/StatisticsNewsletters.php

Text Base64

<?php // phpcs:ignore SlevomatCodingStandard.TypeHints.DeclareStrictTypes.DeclareStrictTypesMissing

namespace MailPoet\Models;

if (!defined('ABSPATH')) exit;

use MailPoet\DI\ContainerWrapper;
use MailPoet\Entities\StatisticsOpenEntity;
use MailPoet\Entities\SubscriberEntity;
use MailPoetVendor\Doctrine\ORM\EntityManager;

/**
 * @property string|null $sentAt
 */
class StatisticsNewsletters extends Model {
  public static $_table = MP_STATISTICS_NEWSLETTERS_TABLE; // phpcs:ignore PSR2.Classes.PropertyDeclaration

public static function createMultiple(array $data) {
    $values = [];
    foreach ($data as $value) {
      if (
        !empty($value['newsletter_id']) &&
        !empty($value['subscriber_id']) &&
        !empty($value['queue_id'])
      ) {
        $values[] = $value['newsletter_id'];
        $values[] = $value['subscriber_id'];
        $values[] = $value['queue_id'];
      }
    }
    if (!count($values)) return false;
    return self::rawExecute(
      'INSERT INTO `' . self::$_table . '` ' .
      '(newsletter_id, subscriber_id, queue_id) ' .
      'VALUES ' . rtrim(
        str_repeat('(?,?,?), ', (int)(count($values) / 3)),
        ', '
      ),
      $values
    );
  }

public static function getAllForSubscriber(SubscriberEntity $subscriber) {
    $entityManager = ContainerWrapper::getInstance()->get(EntityManager::class);

return static::tableAlias('statistics')
      ->select('statistics.newsletter_id', 'newsletter_id')
      ->select('newsletter_rendered_subject')
      ->select('opens.created_at', 'opened_at')
      ->select('sent_at')
      ->join(
        SendingQueue::$_table,
        ['statistics.queue_id', '=', 'queue.id'],
        'queue'
      )
      ->leftOuterJoin(
        $entityManager->getClassMetadata(StatisticsOpenEntity::class)->getTableName(),
        'statistics.newsletter_id = opens.newsletter_id AND statistics.subscriber_id = opens.subscriber_id',
        'opens'
      )
      ->where('statistics.subscriber_id', $subscriber->getId())
      ->orderByAsc('newsletter_id');
  }
}

Exit & Reset Text mode: syntax highlighting auto-detects file type.

Name	Size	Perms	Modified	Actions
CustomField.php	3.80 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
DynamicSegmentFilter.php	2.33 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
index.php	0 B	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
MappingToExternalEntities.php	1.28 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
Model.php	13.68 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
ModelValidator.php	2.53 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
Newsletter.php	15.20 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
NewsletterOption.php	1.78 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
NewsletterOptionField.php	2.01 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
NewsletterSegment.php	406 B	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
ScheduledTask.php	4.84 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
ScheduledTaskSubscriber.php	2.92 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
Segment.php	10.93 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
SendingQueue.php	4.34 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsClicks.php	1.37 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsNewsletters.php	2.02 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsOpens.php	1.85 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsWooCommercePurchases.php	1.53 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
Subscriber.php	20.98 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
SubscriberCustomField.php	2.59 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
SubscriberSegment.php	5.29 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive

Directory Contents