Lines
100.00%
35 / 35
Functions and Methods
100.00%
5 / 5
Classes and Traits
100.00%
1 / 1
| Name | Lines | Functions and Methods | CRAP | Classes and Traits | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| DistrictRepository | 100.00% | 35 / 35 | 100.00% | 5 / 5 | 17 | 100.00% | 1 / 1 | |||
| __construct | 100.00% | 1 / 1 | 100.00% | 1 / 1 | 1 | |||||
| get | 100.00% | 5 / 5 | 100.00% | 1 / 1 | 2 | |||||
| listWithPagination | 100.00% | 8 / 8 | 100.00% | 1 / 1 | 1 | |||||
| createDqlQuery | 100.00% | 10 / 10 | 100.00% | 1 / 1 | 4 | |||||
| dqlOrderBy | 100.00% | 11 / 11 | 100.00% | 1 / 1 | 9 | |||||
| 1 | <?php | |
| 2 | ||
| 3 | declare(strict_types=1); | |
| 4 | ||
| 5 | namespace Districts\Editor\Infrastructure\Doctrine; | |
| 6 | ||
| 7 | use Districts\Core\Domain\District; | |
| 8 | use Districts\Core\Infrastructure\NotFoundInRepositoryException; | |
| 9 | use Districts\Editor\Domain\DistrictFilter\Filter; | |
| 10 | use Districts\Editor\Domain\DistrictOrdering; | |
| 11 | use Districts\Editor\Domain\DistrictOrderingField; | |
| 12 | use Districts\Editor\Domain\DistrictRepository as DistrictRepositoryInterface; | |
| 13 | use Districts\Editor\Domain\OrderingDirection; | |
| 14 | use Districts\Editor\Domain\PaginatedResult; | |
| 15 | use Districts\Editor\Domain\Pagination; | |
| 16 | use Doctrine\ORM\EntityManager; | |
| 17 | use Doctrine\ORM\Query; | |
| 18 | use Doctrine\ORM\Tools\Pagination\Paginator; | |
| 19 | use Traversable; | |
| 20 | ||
| 21 | final readonly class DistrictRepository implements DistrictRepositoryInterface | |
| 22 | { | |
| 23 | public function __construct( | |
| 24 | private EntityManager $entityManager, | |
| 25 | ) { | |
| 26 | } | |
| 27 | ||
| 28 | public function get(int $id): District | |
| 29 | { | |
| 30 | $ormRepository = $this->entityManager->getRepository(District::class); | |
| 31 | $district = $ormRepository->find($id); | |
| 32 | if ($district === null) { | |
| 33 | throw new NotFoundInRepositoryException(); | |
| 34 | } | |
| 35 | return $district; | |
| 36 | } | |
| 37 | ||
| 38 | /** | |
| 39 | * @return PaginatedResult<District> | |
| 40 | */ | |
| 41 | public function listWithPagination( | |
| 42 | DistrictOrdering $order, | |
| 43 | Pagination $pagination, | |
| 44 | ?Filter $filter = null, | |
| 45 | ): PaginatedResult { | |
| 46 | $query = $this->createDqlQuery($order, $filter); | |
| 47 | $query->setFirstResult(($pagination->pageNumber - 1) * $pagination->pageSize); | |
| 48 | $query->setMaxResults($pagination->pageSize); | |
| 49 | $paginator = new Paginator($query); | |
| 50 | /** @var District[] $districts */ | |
| 51 | $districts = iterator_to_array($paginator); | |
| 52 | $recordsTotal = count($paginator); | |
| 53 | $pageCount = intval(ceil($recordsTotal / $pagination->pageSize)); | |
| 54 | return new PaginatedResult($pagination, $pageCount, $recordsTotal, $districts); | |
| 55 | } | |
| 56 | ||
| 57 | /** | |
| 58 | * @phpstan-ignore missingType.generics | |
| 59 | */ | |
| 60 | private function createDqlQuery( | |
| 61 | DistrictOrdering $order, | |
| 62 | ?Filter $filter = null, | |
| 63 | ): Query { | |
| 64 | $queryBuilder = $this->entityManager->createQueryBuilder(); | |
| 65 | $queryBuilder->select("d, c")->from(District::class, "d")->join("d.city", "c"); | |
| 66 | if ($filter !== null) { | |
| 67 | $dqlFilter = DistrictFilter::fromDomainFilter($filter); | |
| 68 | $queryBuilder->where($dqlFilter->where); | |
| 69 | foreach ($dqlFilter->parameters as $name => $value) { | |
| 70 | $queryBuilder->setParameter($name, $value); | |
| 71 | } | |
| 72 | } | |
| 73 | foreach ($this->dqlOrderBy($order) as [$field, $direction]) { | |
| 74 | $queryBuilder->addOrderBy($field, $direction); | |
| 75 | } | |
| 76 | return $queryBuilder->getQuery(); | |
| 77 | } | |
| 78 | ||
| 79 | /** | |
| 80 | * @return Traversable<array{0: string, 1: string}> | |
| 81 | */ | |
| 82 | private function dqlOrderBy(DistrictOrdering $order): Traversable | |
| 83 | { | |
| 84 | $fields = match ($order->field) { | |
| 85 | DistrictOrderingField::FullName => ["c.name", "d.name.name"], | |
| 86 | DistrictOrderingField::CityName => ["c.name"], | |
| 87 | DistrictOrderingField::DistrictName => ["d.name.name"], | |
| 88 | DistrictOrderingField::Area => ["d.area.area"], | |
| 89 | DistrictOrderingField::Population => ["d.population.population"], | |
| 90 | }; | |
| 91 | $direction = match ($order->direction) { | |
| 92 | OrderingDirection::Asc => "ASC", | |
| 93 | OrderingDirection::Desc => "DESC", | |
| 94 | }; | |
| 95 | foreach ($fields as $field) { | |
| 96 | yield [$field, $direction]; | |
| 97 | } | |
| 98 | } | |
| 99 | } |