blob: 6d6938ae88a8691a7b98ac5562b74ad4ca49f98e (
plain) (
tree)
|
|
<?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')
;
}
}
|