hgraca / explicit-architecture-php

    /**

     * @return User[]

     */

    public function findAllByCommentId(

        CommentId $commentId,

        array $orderByList = ['id' => 'DESC'],

        int $maxResults = null

    ): ResultCollectionInterface {

        $this->dqlQueryBuilder->create(User::class);

        $this->dqlQueryBuilder->innerJoin(Comment::class, 'Comment', Join::WITH, 'Comment.authorId = User.id')

            ->where('Comment.id = :comment')

            ->setParameter('comment', $commentId);

        foreach ($orderByList as $property => $direction) {

            $this->dqlQueryBuilder->orderBy('User.' . $property, $direction);

        }

        if ($maxResults) {

            $this->dqlQueryBuilder->setMaxResults($maxResults);

        }

        return $this->queryService->query($this->dqlQueryBuilder->build());

    }

    /**

     * @return User[]

    /**

     * @return User[]

     */

    public function findAllByPostId(

        PostId $postId,

        array $orderByList = ['id' => 'DESC'],

        int $maxResults = null

    ): ResultCollectionInterface {

        $this->dqlQueryBuilder->create(User::class);

        $this->dqlQueryBuilder->innerJoin(Post::class, 'Post', Join::WITH, 'Post.authorId = User.id')

            ->where('Post.id = :post')

            ->setParameter('post', $postId);

        foreach ($orderByList as $property => $direction) {

            $this->dqlQueryBuilder->orderBy('User.' . $property, $direction);

        }

        if ($maxResults) {

            $this->dqlQueryBuilder->setMaxResults($maxResults);

        }

        return $this->queryService->query($this->dqlQueryBuilder->build());

    }

}