- Модуль: imopenlines
- Путь к файлу: ~/bitrix/modules/imopenlines/lib/integrations/report/statistic.php
- Класс: BitrixImOpenLinesIntegrationsReportStatistic
- Вызов: Statistic::getSessionsFrom
private function getSessionsFrom($lastId)
{
$query = new Query(SessionTable::getEntity());
$query->addSelect('ID');
$query->addSelect('DATE_CREATE', 'DATE');
$query->addSelect('OPERATOR_ID');
$query->addSelect('CONFIG_ID', 'OPEN_LINE_ID');
$query->addSelect('SOURCE', 'SOURCE_ID');
$query->addSelect('VOTE', 'MARK');
$query->addSelect('STATUS');
$query->addSelect('CHAT_ID');
$query->addSelect('START_ID');
$query->addSelect('QUEUE_HISTORY');
$query->addSelect('TIME_FIRST_ANSWER');
$query->setLimit(self::SESSION_TO_STATISTIC_PER_ITERATION);
$query->where('ID', '>', $lastId);
// $query->where('DATE', '>', $this->getStatisticStartTime());
return $query->exec()->fetchAll();
}