RestApi
1 month ago
LogHandler.php
10 months ago
LogListingRepository.php
1 month ago
LogRepository.php
2 weeks ago
LoggerFactory.php
10 months ago
LogsDownload.php
2 weeks ago
PluginVersionProcessor.php
3 years ago
index.php
3 years ago
LogListingRepository.php
79 lines
| 1 | <?php declare(strict_types = 1); |
| 2 | |
| 3 | namespace MailPoet\Logging; |
| 4 | |
| 5 | if (!defined('ABSPATH')) exit; |
| 6 | |
| 7 | |
| 8 | use MailPoet\Entities\LogEntity; |
| 9 | use MailPoet\Listing\ListingDateRangeFilterTrait; |
| 10 | use MailPoet\Listing\ListingRepository; |
| 11 | use MailPoetVendor\Doctrine\ORM\QueryBuilder; |
| 12 | |
| 13 | class LogListingRepository extends ListingRepository { |
| 14 | use ListingDateRangeFilterTrait; |
| 15 | |
| 16 | protected function applySelectClause(QueryBuilder $queryBuilder) { |
| 17 | $queryBuilder->select('PARTIAL l.{id,name,level,message,createdAt}'); |
| 18 | } |
| 19 | |
| 20 | protected function applyFromClause(QueryBuilder $queryBuilder) { |
| 21 | $queryBuilder->from(LogEntity::class, 'l'); |
| 22 | } |
| 23 | |
| 24 | protected function applyGroup(QueryBuilder $queryBuilder, string $group) { |
| 25 | // Logs listing does not support groups. |
| 26 | } |
| 27 | |
| 28 | private const SORTABLE_FIELDS = [ |
| 29 | 'created_at' => 'createdAt', |
| 30 | 'name' => 'name', |
| 31 | 'id' => 'id', |
| 32 | ]; |
| 33 | |
| 34 | protected function applySorting(QueryBuilder $queryBuilder, string $sortBy, string $sortOrder) { |
| 35 | // Whitelist the column to keep arbitrary input out of the DQL ORDER BY. |
| 36 | $field = self::SORTABLE_FIELDS[$sortBy] ?? 'createdAt'; |
| 37 | $queryBuilder->addOrderBy("l.$field", $sortOrder); |
| 38 | if ($field !== 'id') { |
| 39 | $queryBuilder->addOrderBy('l.id', $sortOrder); |
| 40 | } |
| 41 | } |
| 42 | |
| 43 | protected function applySearch(QueryBuilder $queryBuilder, string $search, array $parameters) { |
| 44 | $search = trim($search); |
| 45 | if ($search === '') { |
| 46 | return; |
| 47 | } |
| 48 | |
| 49 | // LOCATE() keeps SQL wildcard characters literal for admin log searches. |
| 50 | $queryBuilder |
| 51 | ->andWhere('(LOCATE(:search, l.name) > 0 OR LOCATE(:search, l.message) > 0)') |
| 52 | ->setParameter('search', $search); |
| 53 | } |
| 54 | |
| 55 | protected function applyFilters(QueryBuilder $queryBuilder, array $filters) { |
| 56 | $this->applyDateRangeFilter($queryBuilder, 'l.createdAt', $filters); |
| 57 | if (!empty($filters['name']) && is_array($filters['name'])) { |
| 58 | $queryBuilder |
| 59 | ->andWhere('l.name IN (:names)') |
| 60 | ->setParameter('names', array_values($filters['name'])); |
| 61 | } |
| 62 | if (!empty($filters['level']) && is_array($filters['level'])) { |
| 63 | $levels = []; |
| 64 | foreach ($filters['level'] as $level) { |
| 65 | if (is_numeric($level)) { |
| 66 | $levels[] = (int)$level; |
| 67 | } |
| 68 | } |
| 69 | $queryBuilder |
| 70 | ->andWhere('l.level IN (:levels)') |
| 71 | ->setParameter('levels', $levels); |
| 72 | } |
| 73 | } |
| 74 | |
| 75 | protected function applyParameters(QueryBuilder $queryBuilder, array $parameters) { |
| 76 | // Logs listing does not support additional parameters. |
| 77 | } |
| 78 | } |
| 79 |