• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/statistics/entity/dealchannelstatistics.php
  • Класс: Bitrix\Crm\Statistics\Entity\DealChannelStatisticsTable
  • Вызов: DealChannelStatisticsTable::deleteByFilter
static function deleteByFilter(array $filter)
{
	$ownerID = isset($filter['OWNER_ID']) ? (int)$filter['OWNER_ID'] : 0;
	if($ownerID <= 0)
	{
		throw new Main\ArgumentException('Owner ID must be greater than zero.', 'ownerID');
	}

	$channelTypeID = isset($filter['CHANNEL_TYPE_ID']) ? $filter['CHANNEL_TYPE_ID'] : array();
	if(!is_array($channelTypeID))
	{
		$channelTypeID = $channelTypeID > 0 ? array($channelTypeID) : array();
	}

	if(!empty($channelTypeID))
	{
		$channelTypeIDs = implode(',', $channelTypeID);
		Main\Application::getConnection()->queryExecute(
			"DELETE FROM b_crm_deal_channel_stat WHERE OWNER_ID = {$ownerID} AND CHANNEL_TYPE_ID IN({$channelTypeIDs})");
	}
	else
	{
		Main\Application::getConnection()->queryExecute("DELETE FROM b_crm_deal_channel_stat WHERE OWNER_ID = {$ownerID}");
	}
}