?HAMA

Navigation

Breadcrumbs

Create

Edit File Size: 1.37 KB

/home/nshryvcy/himaltourism.com/wp-content/plugins/mailpoet/lib/Statistics/StatisticsUnsubscribesRepository.php

Text Base64

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

namespace MailPoet\Statistics;

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

use MailPoet\Doctrine\Repository;
use MailPoet\Entities\StatisticsUnsubscribeEntity;
use MailPoetVendor\Carbon\Carbon;

/**
 * @extends Repository<StatisticsUnsubscribeEntity>
 */
class StatisticsUnsubscribesRepository extends Repository {
  protected function getEntityClassName() {
    return StatisticsUnsubscribeEntity::class;
  }

public function getTotalForMonths(int $forMonths): int {
    $from = (new Carbon())->subMonths($forMonths);
    $count = $this->entityManager->createQueryBuilder()
      ->select('count(stats.id)')
      ->from(StatisticsUnsubscribeEntity::class, 'stats')
      ->andWhere('stats.createdAt >= :dateTime')
      ->setParameter('dateTime', $from)
      ->getQuery()
      ->getSingleScalarResult();

return intval($count);
  }

public function getCountPerMethodForMonths(int $forMonths): array {
    $from = (new Carbon())->subMonths($forMonths);
    return $this->entityManager->createQueryBuilder()
      ->select('count(stats.id) as count, stats.method as method')
      ->from(StatisticsUnsubscribeEntity::class, 'stats')
      ->andWhere('stats.createdAt >= :dateTime')
      ->groupBy('stats.method')
      ->setParameter('dateTime', $from)
      ->getQuery()
      ->getResult();
  }
}

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

Name	Size	Perms	Modified	Actions
Track DIR	-	drwxr-xr-x	2023-04-04 05:35:40	Edit Download recursive recursive
GATracking.php	3.26 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
StatisticsBouncesRepository.php	390 B	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsClicksRepository.php	3.19 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsFormsRepository.php	1.16 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsOpensRepository.php	3.95 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsUnsubscribesRepository.php	1.37 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
StatisticsWooCommercePurchasesRepository.php	3.40 KB	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive
UserAgentsRepository.php	701 B	lrw-r--r--	2023-04-04 05:35:40	Edit Download recursive recursive

Directory Contents