Kreta\TaskManager\Infrastructure\Persistence\Doctrine\ORM\Organization\DoctrineORMBySlugSpecification::buildQuery()

Complexity

Conditions	1
Paths	1

Size

Total Lines	17
Code Lines	13

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	1	Features	1

<?php
    public function buildQuery(QueryBuilder $queryBuilder) : Query
    {
        return $queryBuilder
            ->select('o')
            ->from(Organization::class, 'o')
            ->leftJoin('o.organizationMembers', 'om')
            ->leftJoin('o.owners', 'ow')
            ->where($queryBuilder->expr()->like('o.slug.slug', ':slug'))
            ->andWhere(
                $queryBuilder->expr()->orX(
                    $queryBuilder->expr()->eq('om.userId', ':userId'),
                    $queryBuilder->expr()->eq('ow.userId', ':userId')
                )
            )
            ->setParameter('slug', $this->slug)
            ->getQuery();
    }
}