- Модуль: 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();
}