8889841cwp-content/plugins/mailpoet/lib/Segments/DynamicSegments/Filters/WooFilterHelper.php000064400000005571150513104460032567 0ustar00home/clixcotz/tcchp.clix.co.tzcollationChecker = $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'); } }