Application\Repository\MessageRepository

Complexity

Total Complexity

3

Size/Duplication

Total Lines	28
Duplicated Lines	0 %

Test Coverage

Coverage

44.44%

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getAccessibleSubQuery()	0	7	2
A	getAllMessageToSend()	0	7	1

<?php

declare(strict_types=1);

namespace Application\Repository;

use Application\Model\Message;
use Application\Model\User;

class MessageRepository extends AbstractRepository implements LimitedAccessSubQueryInterface
{
    /**
     * Returns pure SQL to get ID of all objects that are accessible to given user.
     *
     * @param null|User $user
     *
     * @return string
     */
    public function getAccessibleSubQuery(?User $user): string
    {
        if (!$user) {
            return '-1';
        }

        return 'SELECT id FROM message WHERE recipient_id = ' . $user->getId();
    }

    /**
     * @return Message[]
     */
    public function getAllMessageToSend(): array
    {
        $qb = $this->createQueryBuilder('message')
            ->where('message.dateSent IS NULL')
            ->addOrderBy('message.id');

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