DealSumStatisticsTable::deleteByFilter

  1. Bitrix24 API (v. 23.675.0)
  2. crm
  3. DealSumStatisticsTable
  4. deleteByFilter
  • Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/statistics/entity/dealsumstatistics.php
  • Класс: Bitrix\Crm\Statistics\Entity\DealSumStatisticsTable
  • Вызов: DealSumStatisticsTable::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');
	}

	$semanticID = isset($filter['SEMANTIC_ID']) ? $filter['SEMANTIC_ID'] : array();
	if(!is_array($semanticID))
	{
		$semanticID = $semanticID !== '' ? array($semanticID) : array();
	}

	if(!empty($semanticID))
	{
		$semantics = implode("','", $semanticID);
		Main\Application::getConnection()->queryExecute(
			"DELETE FROM b_crm_deal_sum_stat WHERE OWNER_ID = {$ownerID} AND STAGE_SEMANTIC_ID IN('{$semantics}')");
	}
	else
	{
		Main\Application::getConnection()->queryExecute("DELETE FROM b_crm_deal_sum_stat WHERE OWNER_ID = {$ownerID}");
	}
}

Добавить комментарий