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);
            }
        }
    }
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);
            }
        }
    }
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 ) ; } } }
Add required WHERE parameters.

@param QueryBuilder $qb
@param array        $options
Add required WHERE parameters .