for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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');
}
$count = $dq->getQuery()->getSingleScalarResult();
return $count;
public function getUnreadNotifications(DatabaseNotifiableInterface $user)
return $this->findBy([
'notifiable' => $user,
'readAt' => null,
]);
irishdan /
NotificationBundle
