- Модуль: voximplant
- Путь к файлу: ~/bitrix/modules/voximplant/lib/model/user.php
- Класс: BitrixVoximplantModelUserTable
- Вызов: UserTable::getMap
static function getMap()
{
$result = parent::getMap();
$result[] = new ExpressionField(
'IS_BUSY',
'case when exists (
select
'x'
from
b_voximplant_call c
inner join b_voximplant_call_user cu on cu.CALL_ID = c.CALL_ID
where
c.LAST_PING > date_sub(now(), interval 7 minute)
AND c.STATUS in ('waiting', 'connecting', 'connected')
AND cu.USER_ID = %s
AND
(
cu.STATUS = 'connected'
OR
cu.INSERTED > date_sub(now(), interval 2 minute)
)
) then 'Y' else 'N' end',
['ID'],
['data_type' => 'boolean', 'values' => ['N', 'Y']]
);
return $result;
}