- Модуль: im
- Путь к файлу: ~/bitrix/modules/im/classes/general/im_notify.php
- Класс: CIMNotify
- Вызов: CIMNotify::DeleteByModule
static function DeleteByModule($moduleId, $moduleEvent = '')
{
global $DB;
$moduleId = (string)$moduleId;
if ($moduleId == '')
return false;
$sqlEvent = '';
$sqlEventRead = '';
$moduleEvent = (string)$moduleEvent;
if ($moduleEvent <> '')
{
$sqlEvent = " AND NOTIFY_EVENT = '".$DB->ForSQL($moduleEvent)."'";
$sqlEventRead = " AND M.NOTIFY_EVENT = '".$DB->ForSQL($moduleEvent)."'";
}
$strSql = "DELETE U FROM b_im_message M INNER JOIN b_im_message_unread U ON M.ID = U.MESSAGE_ID WHERE M.NOTIFY_MODULE = '".$DB->ForSQL($moduleId)."'".$sqlEvent;
$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
$strSql = "DELETE V FROM b_im_message M INNER JOIN b_im_message_viewed V ON M.ID = V.MESSAGE_ID WHERE M.NOTIFY_MODULE = '".$DB->ForSQL($moduleId)."'".$sqlEvent;
$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
$strSql = "DELETE FROM b_im_message WHERE NOTIFY_MODULE = '".$DB->ForSQL($moduleId)."'".$sqlEvent;
$DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
return true;
}