src/Wallabag/CoreBundle/Repository/NotificationRepository.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26

<?php

namespace Wallabag\CoreBundle\Repository;

use Doctrine\ORM\EntityRepository;

class NotificationRepository extends EntityRepository
{
    public function markAllAsReadForUser($userId)
    {
        return $this->getEntityManager()->createQueryBuilder()
        ->update('WallabagCoreBundle:Notification', 'n')
        ->set('n.read', true)
        ->where('n.user = :userId')->setParameter('userId', $userId)
        ->getQuery()
        ->getResult();
    }

    public function getBuilderForNotificationsByUser($userId)
    {
        return $this->createQueryBuilder('n')
            ->andWhere('n.user = :userId')->setParameter('userId', $userId)
            ->orderBy('n.timestamp', 'desc')
            ;
    }
}