ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / carbonbullion.com / wp-content / plugins / mailpoet / lib / Segments / DynamicSegments / Filters

<?php declare(strict_types = 1);

namespace MailPoet\Segments\DynamicSegments\Filters;

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

use MailPoet\Util\DBCollationChecker;
use MailPoetVendor\Doctrine\DBAL\Connection;
use MailPoetVendor\Doctrine\DBAL\Query\QueryBuilder;

class WooFilterHelper {
  /** @var DBCollationChecker */
  private $collationChecker;

/** @var FilterHelper */
  private $filterHelper;

public function __construct(
    DBCollationChecker $collationChecker,
    FilterHelper $filterHelper
  ) {
    $this->collationChecker = $collationChecker;
    $this->filterHelper = $filterHelper;
  }

public function defaultIncludedStatuses(): array {
    return ['wc-processing', 'wc-completed'];
  }

/**
   * @param QueryBuilder $queryBuilder
   * @param string $customerAlias
   * @return string - The alias of the joined customer lookup table
   */
  public function applyCustomerLookupJoin(QueryBuilder $queryBuilder, string $customerAlias = 'customer'): string {
    $subscribersTable = $this->filterHelper->getSubscribersTable();

$collation = $this->collationChecker->getCollateIfNeeded(
      $subscribersTable,
      'email',
      $this->customerLookupTable(),
      'email'
    );

$queryBuilder->innerJoin(
      $subscribersTable,
      $this->customerLookupTable(),
      $customerAlias,
      "$subscribersTable.email = $customerAlias.email $collation"
    );

return $customerAlias;
  }

/**
   * @param QueryBuilder $queryBuilder
   * @param string $orderStatsAlias
   * @return string - The alias of the joined order stats table
   */
  public function applyCustomerOrderJoin(QueryBuilder $queryBuilder, string $orderStatsAlias = 'orderStats'): string {
    $customerAlias = $this->applyCustomerLookupJoin($queryBuilder);

$queryBuilder->innerJoin(
      $customerAlias,
      $this->orderStatsTable(),
      $orderStatsAlias,
      "$customerAlias.customer_id = $orderStatsAlias.customer_id"
    );

return $orderStatsAlias;
  }

/**
   * @param QueryBuilder $queryBuilder
   * @param array|null $allowedStatuses
   * @return string - The alias of the joined order stats table
   */
  public function applyOrderStatusFilter(QueryBuilder $queryBuilder, array $allowedStatuses = null): string {
    if (is_null($allowedStatuses)) {
      $allowedStatuses = $this->defaultIncludedStatuses();
    }

$statusParam = $this->filterHelper->getUniqueParameterName('status');
    $orderStatsAlias = $this->applyCustomerOrderJoin($queryBuilder);
    $queryBuilder->andWhere("$orderStatsAlias.status IN (:$statusParam)");
    $queryBuilder->setParameter($statusParam, $allowedStatuses, Connection::PARAM_STR_ARRAY);
    return $orderStatsAlias;
  }

private function customerLookupTable(): string {
    return $this->filterHelper->getPrefixedTable('wc_customer_lookup');
  }

private function orderStatsTable(): string {
    return $this->filterHelper->getPrefixedTable('wc_order_stats');
  }
}

[-] WooFilterHelper.php [edit]
[-] WooCommerceMembership.php [edit]
[-] Filter.php [edit]
[-] EmailActionClickAny.php [edit]
[-] WooCommerceFirstOrder.php [edit]
[-] index.php [edit]
[+] ..
[-] EmailOpensAbsoluteCountAction.php [edit]
[-] WooCommercePurchasedWithAttribute.php [edit]
[-] WooCommerceTag.php [edit]
[-] UserRole.php [edit]
[-] WooCommerceUsedPaymentMethod.php [edit]
[-] WooCommerceSubscription.php [edit]
[-] FilterHelper.php [edit]
[-] AutomationsEvents.php [edit]
[-] WooCommerceAverageSpent.php [edit]
[-] WooCommerceProduct.php [edit]
[-] SubscriberScore.php [edit]
[-] WooCommerceSingleOrderValue.php [edit]
[-] NumberOfClicks.php [edit]
[-] WooCommerceCategory.php [edit]
[-] EmailsReceived.php [edit]
[-] EmailAction.php [edit]
[-] SubscriberSegment.php [edit]
[-] SubscriberDateField.php [edit]
[-] MailPoetCustomFields.php [edit]
[-] SubscriberTextField.php [edit]
[-] WooCommerceNumberOfReviews.php [edit]
[-] SubscriberTag.php [edit]
[-] WooCommerceCountry.php [edit]
[-] WooCommerceCustomerTextField.php [edit]
[-] WooCommerceUsedShippingMethod.php [edit]
[-] WooCommerceNumberOfOrders.php [edit]
[-] WooCommerceUsedCouponCode.php [edit]
[-] WooCommerceTotalSpent.php [edit]
[-] WooCommercePurchaseDate.php [edit]
[-] SubscriberSubscribedViaForm.php [edit]
[-] DateFilterHelper.php [edit]