IrishDan\NotificationBundle\Repository\NotificationRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getNotificationsCount()	0	19	3
A	getUnreadNotifications()	0	7	1

<?php

namespace IrishDan\NotificationBundle\Repository;

use Doctrine\ORM\EntityRepository;
use IrishDan\NotificationBundle\DatabaseNotifiableInterface;

class NotificationRepository extends EntityRepository implements DatabaseNotificationRepositoryInterface
{
    public function getNotificationsCount(DatabaseNotifiableInterface $user, $status = '')
    {
        $dq = $this->createQueryBuilder('n')
            ->select('count(n.id)')
            ->andWhere('n.notifiable = ' . $user->getId());

        switch ($status) {
            case 'read':
                $dq->andWhere('n.readAt IS NOT NULL');
                break;
            case 'unread':
                $dq->andWhere('n.readAt IS NULL');
                break;
        }

        $count = $dq->getQuery()->getSingleScalarResult();

        return $count;
    }

    public function getUnreadNotifications(DatabaseNotifiableInterface $user)
    {
        return $this->findBy([
            'notifiable' => $user,
            'readAt' => null,
        ]);
    }
}