| protected buildWhere ( array $cols, string $search, $qb = null, $andx = null ) : Doctrine\ORM\Query\Expr | ||
| $cols | array | |
| $search | string | |
| return | Doctrine\ORM\Query\Expr | |
protected function buildWhere(array $cols, $search, $qb = null, $andx = null)
{
$orx = $qb->expr()->orx();
$orx->add($qb->expr()->like('s.username', $qb->expr()->literal("%{$search}%")));
$orx->add($qb->expr()->like('e.subject', $qb->expr()->literal("%{$search}%")));
$orx->add($qb->expr()->like('e.message', $qb->expr()->literal("%{$search}%")));
return $andx->add($orx);
}