TaskChecklistItemHandler::updateSortIndexes

private function updateSortIndexes($recountedSortIndexes, $connection)
{
	$sqlUpdate = "UPDATE b_tasks_checklist_items SET SORT_INDEX = CASE IDn";

	foreach ($recountedSortIndexes as $id => $sortIndex)
	{
		$sqlUpdate .= "WHEN $id THEN $sortIndexn";
	}

	$sqlUpdate .= "END WHERE ID IN (".implode(', ', array_keys($recountedSortIndexes)).")";

	$connection->query($sqlUpdate);
}