• Модуль: crm
  • Путь к файлу: ~/bitrix/modules/crm/lib/update/order/dealgenerator.php
  • Класс: Bitrix\Crm\Update\Order\DealGenerator
  • Вызов: DealGenerator::getUnbindingActiveOrders
static function getUnbindingActiveOrders() : Main\ORM\Query\Result
{
	$query = new Main\Entity\Query(Sale\Internals\OrderTable::getEntity());
	$query->registerRuntimeField('',
		new Main\Entity\ReferenceField(
			'ENTITY_BINDING',
			Crm\Binding\OrderEntityTable::getEntity(),
			[
				'=ref.ORDER_ID' => 'this.ID',
			],
			[
				'join_type' => 'LEFT'
			]
		)
	);
	$query
		->setSelect(['ID'])
		->whereNotIn(
			'STATUS_ID',
			[
				Crm\Order\OrderStatus::getFinalStatus(),
				Crm\Order\OrderStatus::getFinalUnsuccessfulStatus()
			]
		)
		->whereNull('ENTITY_BINDING.ORDER_ID')
		->setLimit(self::MAX_ORDERS_FOR_STEP)
	;

	return $query->exec();
}