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 'SELECT id FROM message WHERE recipient_id = ' . $user->getId();
}
return '-1';
* @return Message[]
public function getAllMessageToSend(): array
$qb = $this->createQueryBuilder('message')
->where('message.dateSent IS NULL');
return $qb->getQuery()->getResult();
Ecodev /
my-ichtus
