OrderFilter::prepareOrderSourceFilter

  1. Bitrix24 API (v. 23.675.0)
  2. crm
  3. OrderFilter
  4. prepareOrderSourceFilter
  • Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/deal/orderfilter.php
  • Класс: Bitrix\Crm\Deal\OrderFilter
  • Вызов: OrderFilter::prepareOrderSourceFilter
static function prepareOrderSourceFilter(array $orderSource): array
{
	$sql = self::convertEnumToSql($orderSource);

	return [
		"TYPE" => "WHERE",
		"SQL" => "EXISTS (
			SELECT bstpo.ID FROM " . TradingPlatform\OrderTable::getTableName() . " bstpo
			INNER JOIN " . Binding\OrderEntityTable::getTableName() . " bcod ON bcod.ORDER_ID = bstpo.ORDER_ID
			WHERE bstpo.TRADING_PLATFORM_ID IN ({$sql}) AND bcod.OWNER_ID = " . \CCrmDeal::TABLE_ALIAS . ".ID AND bcod.OWNER_TYPE_ID=".\CCrmOwnerType::Deal."
		)"
	];
}

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