protected function insert($userId, HistoryEntry $entry, UserSettings $userSettings)
{
/** @var \PDOStatement $stmt */
try {
$sql = 'INSERT IGNORE INTO `*PREFIX*sipgate_history` SET userId=:userId, status=:status, tos=:tos, time=:time, localUri=:localUri, remoteUri=:remoteUri, remotePhoneNumber=:remotePhoneNumber, localPhoneNumber=:localPhoneNumber';
$stmt = $this->db->prepare($sql);
$stmt->bindValue(':userId', $userId, \PDO::PARAM_STR);
$stmt->bindValue(':status', $entry->getStatus(), \PDO::PARAM_STR);
$stmt->bindValue(':tos', $entry->getTypeOfService(), \PDO::PARAM_STR);
$stmt->bindValue(':time', $entry->getTime()->format('Y-m-d H:i:s'), \PDO::PARAM_STR);
$stmt->bindValue(':localUri', $entry->getLocalUri(), \PDO::PARAM_STR);
$stmt->bindValue(':remoteUri', $entry->getRemoteUri(), \PDO::PARAM_STR);
$stmt->bindValue(':remotePhoneNumber', $entry->getRemotePhoneNumber($userSettings->getDefaultCountryCode()), \PDO::PARAM_STR);
$stmt->bindValue(':localPhoneNumber', $entry->getLocalPhoneNumber($userSettings->getDefaultCountryCode()), \PDO::PARAM_STR);
$stmt->execute();
return $stmt->rowCount();
} catch (DbException $e) {
$this->logger->error('Error inserting into database: %s', $e->getMessage());
}
}
