JK\NotificationBundle\Repository\NotificationRepository::findUnread()

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function findUnread(string $ownerId = null): Collection
    {
        $queryBuilder = $this
            ->createQueryBuilder('notification')
            ->where('notification.read = :read')
            ->setParameter('read', false)
            ->addOrderBy('notification.updatedAt', 'desc')
            ->addOrderBy('notification.id', 'desc')
        ;

        if ($ownerId) {
            $queryBuilder
                ->andWhere('notification.ownerId = :owner_id')
                ->setParameter('owner_id', $ownerId)
            ;
        }

        return new ArrayCollection($queryBuilder->getQuery()->getResult());
    }