for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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();
Ecodev /
my-ichtus
