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