- Модуль: crm
- Путь к файлу: ~/bitrix/modules/crm/lib/kanban/queries/queryentityactivitycounter.php
- Класс: Bitrix\Crm\Kanban\Queries\QueryEntityActivityCounter
- Вызов: QueryEntityActivityCounter::queryIncomingActivities
public function queryIncomingActivities(int $entityTypeId, array $entityIds, array $activitiesIds): array
{
return IncomingChannelTable::getList([
'select' => [
'ACTIVITY_ID',
'OWNER_ID' => 'BINDING.OWNER_ID',
],
'filter' => [
'BINDING.OWNER_TYPE_ID' => $entityTypeId,
'@BINDING.OWNER_ID' => $entityIds,
'@ACTIVITY_ID' => $activitiesIds,
'=COMPLETED' => 'N',
],
'runtime' => [
new ReferenceField(
'BINDING',
ActivityBindingTable::class,
Join::on('this.ACTIVITY_ID', 'ref.ACTIVITY_ID'),
['join_type' => 'INNER']
)
]
])->fetchAll();
}