Chamilo\CoreBundle\Repository\MessageRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	getFromLastOneReceived()	0	21	1
A	update()	0	5	2

<?php

declare(strict_types=1);

/* For licensing terms, see /license.txt */

namespace Chamilo\CoreBundle\Repository;

use Chamilo\CoreBundle\Entity\Message;
use Chamilo\CoreBundle\Entity\User;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Common\Collections\Criteria;
use Doctrine\Persistence\ManagerRegistry;

class MessageRepository extends ServiceEntityRepository
{
    public function __construct(ManagerRegistry $registry)
    {
        parent::__construct($registry, Message::class);
    }

    public function getFromLastOneReceived(User $user, int $lastMessageId = 0)
    {
        $qb = $this->createQueryBuilder('m');

        $qb
            ->where(
                $qb->expr()->eq('m.userReceiver', $user->getId())
            )
            ->andWhere(
                $qb->expr()->eq('m.msgStatus', MESSAGE_STATUS_UNREAD)
            )
            ->andWhere(
                $qb->expr()->gt('m.id', $lastMessageId)
            )
            ->orderBy(
                'm.sendDate',
                Criteria::DESC
            )
        ;

        return $qb->getQuery()->getResult();
    }

    public function update(Message $message, $andFlush = true): void
    {
        $this->getEntityManager()->persist($message);
        if ($andFlush) {
            $this->getEntityManager()->flush();
        }
    }
}