- Модуль: tasks
- Путь к файлу: ~/bitrix/modules/tasks/lib/update/taskchecklistconverter.php
- Класс: BitrixTasksUpdateTaskCheckListConverter
- Вызов: TaskCheckListConverter::insertTreeConnections
static function insertTreeConnections($items)
{
$connection = Application::getConnection();
$entityItemsTreeTableName = static::$entityItemsTreeTableName;
$sql = "INSERT INTO {$entityItemsTreeTableName} (PARENT_ID, CHILD_ID, LEVEL)
VALUES ";
foreach ($items as $key => $item)
{
if ($key)
{
$sql .= ",";
}
$sql .= "(" . $item['PARENT_ID'] . "," . $item['PARENT_ID'] . ",0),";
$sql .= "(" . $item['PARENT_ID'] . ",";
$sql .= implode(", 1),(" . $item['PARENT_ID'] . ",", $item['ITEMS']);
$sql .= ", 1)";
}
$connection->query($sql);
}