- Модуль: support
- Путь к файлу: ~/bitrix/modules/support/classes/general/search.php
- Класс: CSupportSearch
- Вызов: CSupportSearch::ReindexMessages
static function ReindexMessages($firstID, $periodS = 8)
{
global $DB;
$firstID = intval( $firstID);
$err_mess = (self::err_mess()) . "
Function: reindexMessages
Line: ";
$endTime = time() + $periodS;
$strSql = "
SELECT
T.SITE_ID,
TM.ID,
TM.MESSAGE
FROM
b_ticket T
INNER JOIN b_ticket_message TM
ON T.ID = TM.TICKET_ID
AND TM.ID > $firstID
AND TM.IS_LOG = 'N'
ORDER BY TM.ID";
$res = $DB->Query($strSql, false, $err_mess.__LINE__);
$lastID = 0;
while($cs = $res->Fetch())
{
if(time() > $endTime) return $lastID;
self::WriteWordsInTable($cs["ID"], $cs["SITE_ID"], $cs["MESSAGE"]);
$lastID = intval($cs["ID"]);
}
return -1;
}