| protected addWhereActivity ( Doctrine\DBAL\Query\QueryBuilder $qb, array $options ) | ||
| $qb | Doctrine\DBAL\Query\QueryBuilder | |
| $options | array | |
protected function addWhereActivity(QueryBuilder $qb, $options)
{
if (empty($options)) {
return;
}
foreach ($options as $columnName => $option) {
if (is_array($options[$columnName])) {
$qb->andWhere($this->buildWhereOr($qb, $columnName, $option));
} elseif (!empty($options[$columnName])) {
$qb->andWhere("{$columnName} = :{$columnName}")->setParameter($columnName, $option);
}
}
}