- Модуль: crm
- Путь к файлу: ~/bitrix/modules/crm/lib/activity/lightcounter/actcounterlighttimerepo.php
- Класс: Bitrix\Crm\Activity\LightCounter\ActCounterLightTimeRepo
- Вызов: ActCounterLightTimeRepo::queryLightTimeByActivityIdsTransitional
private function queryLightTimeByActivityIdsTransitional(array $activityIds): array
{
$queryBuilder = ActivityTable::query()
->addSelect('ID', 'ACTIVITY_ID')
->addSelect('LIGHT_COUNTER_AT')
->registerRuntimeField(
'',
new ReferenceField('LT',
ActCounterLightTimeTable::getEntity(),
[
'=ref.ACTIVITY_ID' => 'this.ID',
]
)
)
->registerRuntimeField(new ExpressionField(
'LIGHT_COUNTER_AT',
'COALESCE(crm_activity_lt.LIGHT_COUNTER_AT, DATE_SUB(DEADLINE, interval 15 minute))'
)
)
->whereIn('ID', $activityIds);
return $queryBuilder->fetchAll();
}