Completed
Push — develop ( 1fc957...5b3409 )
by Marek
10:45
created

NodeAccessRepository   A

Complexity

Total Complexity 1

Size/Duplication

Total Lines 24
Duplicated Lines 0 %

Coupling/Cohesion

Components 0
Dependencies 2

Importance

Changes 1
Bugs 0 Features 0
Metric Value
wmc 1
c 1
b 0
f 0
lcom 0
cbo 2
dl 0
loc 24
rs 10

1 Method

Rating   Name   Duplication   Size   Complexity  
A findBookmarksByUserId() 0 16 1
1
<?php
2
namespace AppBundle\Entity\Repository;
3
4
use AppBundle\Entity\NodeAccess;
5
6
class NodeAccessRepository extends AbstractEntityRepository
7
{
8
    /**
9
     * @param int $userId
10
     *
11
     * @return NodeAccess[]
12
     */
13
    public function findBookmarksByUserId($userId)
14
    {
15
        $query = $this->createQueryBuilder('na')
16
            ->select('na', 'n', 'bc')
17
            ->innerJoin('na.node', 'n')
18
            ->leftJoin('na.bookmarkCategory', 'bc')
19
            ->where('na.userId = :userId AND na.bookmark = :bookmark')
20
            ->orderBy('n.name', 'ASC')
21
            ->setParameters([
22
                'bookmark' => NodeAccess::BOOKMARK_YES,
23
                'userId' => $userId,
24
            ])
25
            ->getQuery();
26
27
        return $query->getResult();
28
    }
29
}
30