TaskCheckListLog::logItemsChanges

public function logItemsChanges($items)
{
	$connection = Application::getConnection();
	$sqlHelper = $connection->getSqlHelper();

	$createdDate = DateTime::createFromUserTime(UI::formatDateTime(User::getTime($this->userId)));
	$createdDate = $sqlHelper->convertToDbDateTime($createdDate);

	$sql = "
		INSERT INTO b_tasks_log (TASK_ID, USER_ID, CREATED_DATE, FIELD, FROM_VALUE, TO_VALUE)
		VALUES
	";

	foreach ($items as $item)
	{
		$logFields = [
			'TASK_ID' => $this->taskId,
			'USER_ID' => $this->userId,
			'CREATED_DATE' => $createdDate,
			'FIELD' => $sqlHelper->convertToDb($item['FIELD']),
			'FROM_VALUE' => $sqlHelper->convertToDb($item['FROM_VALUE']),
			'TO_VALUE' => $sqlHelper->convertToDb($item['TO_VALUE']),
		];
		$values = implode(',', $logFields);

		$sql .= "({$values}),";
	}

	$sql = rtrim($sql, ',');

	$connection->query($sql);
}