/**
* Remove filter user and relationships
*
* @param int $id
* @return \Bitrix\Main\Entity\DeleteResult
* @throws \InvalidArgumentException
*/
public function removeFilterUser($id)
{
$filterUser = Model\SubscribeUserTable::getById($id)->fetch();
if ($this->isEmptyResult($filterUser)) {
throw new \InvalidArgumentException('Invalid filter user id');
}
$queryBuilder = new Entity\Query(Model\SubscribeStackTable::getEntity());
$subscribeStack = $queryBuilder->setSelect(array('ID'))->setFilter(array('FILTER_USER_ID' => $filterUser['ID']))->exec();
while ($row = $subscribeStack->fetch()) {
Model\SubscribeStackTable::delete(array('ID' => $row['ID']));
}
$result = Model\SubscribeUserTable::delete(array('ID' => $filterUser['ID']));
$queryBuilder = new Entity\Query(Model\SubscribeUserTable::getEntity());
$filterUserResult = $queryBuilder->registerRuntimeField('cnt', array('data_type' => 'integer', 'expression' => array('count(%s)', 'ID')))->setSelect(array('ID', 'cnt'))->setFilter(array('FILTER_ID' => $filterUser['FILTER_ID']))->exec()->fetch();
if ($filterUserResult['cnt'] <= 0) {
Model\SubscribeTable::delete(array('ID' => $filterUser['FILTER_ID']));
}
return $result;
}
