How to set condition using innerJoin in createQueryBuilder?

Question

MySQL

It is necessary that if $statuses is present, innerJoin is used, and if $statuses is absent, it is not used.

$all = $this
                ->createQueryBuilder('u')
                ->select('count(u.id)')
                ->innerJoin('u.roles', 'r', 'WITH', 'r.id IN (' . $statuses . ')')
                ->getQuery()
                ->getSingleScalarResult();

Answer 1

What's the problem?

// За форматирование извиняюсь - писал всё вручную
$qb = $this->createQueryBuilder('u')->select('...');
if ($statuses) {
    $qb->innerJoin()
}
$all = $qb->getQuery()->getSingleScalarResult();

Learn PHP or something.

Answer 2

This is how it works

$qb = $this->createQueryBuilder('u')->select('...');
if ($statuses) {
    $qb = $qb->innerJoin()
}
$qb = $qb->getQuery();
$all = $qb->getSingleScalarResult();