Server IP : 104.21.14.103 / Your IP : 3.133.127.161 Web Server : LiteSpeed System : Linux business53.web-hosting.com 4.18.0-553.lve.el8.x86_64 #1 SMP Mon May 27 15:27:34 UTC 2024 x86_64 User : giankuin ( 1871) PHP Version : 7.4.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /proc/self/root/proc/thread-self/root/home/giankuin/thietke365.net/wp-content/plugins/mailpoet/lib/Form/Listing/ |
Upload File : |
<?php // phpcs:ignore SlevomatCodingStandard.TypeHints.DeclareStrictTypes.DeclareStrictTypesMissing namespace MailPoet\Form\Listing; if (!defined('ABSPATH')) exit; use MailPoet\Entities\FormEntity; use MailPoet\Listing\ListingDefinition; use MailPoet\Listing\ListingRepository; use MailPoetVendor\Doctrine\ORM\QueryBuilder; class FormListingRepository extends ListingRepository { public function getGroups(ListingDefinition $definition): array { $queryBuilder = clone $this->queryBuilder; $this->applyFromClause($queryBuilder); $this->applyParameters($queryBuilder, $definition->getParameters()); // total count $countQueryBuilder = clone $queryBuilder; $countQueryBuilder->select('COUNT(f) AS formCount'); $countQueryBuilder->andWhere('f.deletedAt IS NULL'); $totalCount = (int)$countQueryBuilder->getQuery()->getSingleScalarResult(); // trashed count $trashedCountQueryBuilder = clone $queryBuilder; $trashedCountQueryBuilder->select('COUNT(f) AS formCount'); $trashedCountQueryBuilder->andWhere('f.deletedAt IS NOT NULL'); $trashedCount = (int)$trashedCountQueryBuilder->getQuery()->getSingleScalarResult(); return [ [ 'name' => 'all', 'label' => __('All', 'mailpoet'), 'count' => $totalCount, ], [ 'name' => 'trash', 'label' => __('Trash', 'mailpoet'), 'count' => $trashedCount, ], ]; } protected function applySelectClause(QueryBuilder $queryBuilder) { $queryBuilder->select("PARTIAL f.{id,name,status,settings,createdAt,updatedAt,deletedAt}"); } protected function applyFromClause(QueryBuilder $queryBuilder) { $queryBuilder->from(FormEntity::class, 'f'); } protected function applyGroup(QueryBuilder $queryBuilder, string $group) { // include/exclude deleted if ($group === 'trash') { $queryBuilder->andWhere('f.deletedAt IS NOT NULL'); } else { $queryBuilder->andWhere('f.deletedAt IS NULL'); } } protected function applySorting(QueryBuilder $queryBuilder, string $sortBy, string $sortOrder) { $queryBuilder->addOrderBy("f.$sortBy", $sortOrder); } protected function applySearch(QueryBuilder $queryBuilder, string $search) { // the parent class requires this method, but forms listing doesn't currently support this feature. } protected function applyFilters(QueryBuilder $queryBuilder, array $filters) { // the parent class requires this method, but forms listing doesn't currently support this feature. } protected function applyParameters(QueryBuilder $queryBuilder, array $parameters) { // the parent class requires this method, but forms listing doesn't currently support this feature. } }