• Модуль: landing
  • Путь к файлу: ~/bitrix/modules/landing/lib/update/block/lastused.php
  • Класс: BitrixLandingUpdateBlockLastUsed
  • Вызов: LastUsed::massInsertBlocks
static function massInsertBlocks(int $userId): void
{
	$sql = "DELETE FROM b_landing_block_last_used WHERE USER_ID={$userId};";
	Application::getConnection()->query($sql);

	$sql = "INSERT INTO b_landing_block_last_used (USER_ID, CODE, DATE_CREATE)
				SELECT
					CREATED_BY_ID as USER_ID, CODE, MAX(DATE_CREATE) DATE_CREATE
				FROM
					b_landing_block
				WHERE
					CREATED_BY_ID={$userId}
					AND PUBLIC='N'
					AND DELETED='N'
				GROUP BY
					CODE
				ORDER BY
					DATE_CREATE DESC
			;";
	Application::getConnection()->query($sql);
}