Lines 100.00% 35 / 35
Methods 100.00% 5 / 5
Classes 100.00% 1 / 1
Name Lines Methods CRAP
 __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
21final 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}