• Модуль: 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);
}