AppBundle\Entity\Repository\NodeAccessRepository::findBookmarksByUserId()

Complexity

Conditions	1
Paths	1

Size

Total Lines	16
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function findBookmarksByUserId($userId)
    {
        $query = $this->createQueryBuilder('na')
            ->select('na', 'n', 'bc')
            ->innerJoin('na.node', 'n')
            ->leftJoin('na.bookmarkCategory', 'bc')
            ->where('na.userId = :userId AND na.bookmark = :bookmark')
            ->orderBy('n.name', 'ASC')
            ->setParameters([
                'bookmark' => NodeAccess::BOOKMARK_YES,
                'userId' => $userId,
            ])
            ->getQuery();

        return $query->getResult();
    }
}