UserAttributeRepository::setEmptyValueWhereAttributeNameIn()

Complexity

Conditions	2
Paths	2

Size

Total Lines	18
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function setEmptyValueWhereAttributeNameIn(
        array $attributeNames,
        array $users = [],
        array $forbiddenUsers = [Constant::USER_ID_ADMIN, Constant::USER_ID_ANONYMOUS]
    ) {
        $qb = $this->createQueryBuilder('a')
            ->set('a.value', '\'\'')
            ->where('a.name IN (:attributeNames)')
            ->setParameter('attributeNames', $attributeNames);
        if (!empty($users)) {
            $qb->andWhere('a.user IN (:users)')
                ->setParameter('users', $users);
        }
        $qb->andWhere('a.user NOT IN (:forbidden_users)')
            ->setParameter('forbidden_users', $forbiddenUsers);

        return $qb->getQuery()->execute();
    }
}