<?php
/**
 * Koordinaten-Korrekturen aus dem Audit vom 2026-04-19.
 * Quelle: OSM/Nominatim, manuell gegengeprüft.
 */
require_once __DIR__ . '/config/app.php';
require_once __DIR__ . '/config/db.php';

$corrections = [
    ['zwischenwasser', 47.28160, 9.66390, 'Zwischenwasser (Laternsertal, Bez. Feldkirch)'],
    ['soelden',        46.96660, 11.00730, 'Sölden (Ötztal, Bez. Imst)'],
    ['hintertux',      47.11500, 11.68250, 'Hintertux (Tux, Bez. Schwaz)'],
    ['laterns',        47.27040, 9.76590,  'Laterns (Bez. Feldkirch)'],
    ['fontanella',     47.24750, 9.90880,  'Fontanella (Großes Walsertal, Bez. Bludenz)'],
];

$db = getDB();
$stmt = $db->prepare("UPDATE geo_waypoints SET lat=?, lon=? WHERE wp_key=?");
$log = [];
foreach ($corrections as [$key, $lat, $lon, $note]) {
    $before = $db->prepare("SELECT lat, lon FROM geo_waypoints WHERE wp_key=?");
    $before->execute([$key]);
    $old = $before->fetch();
    $stmt->execute([$lat, $lon, $key]);
    $log[] = [
        'wp_key' => $key,
        'note' => $note,
        'old' => $old ? [(float)$old['lat'], (float)$old['lon']] : null,
        'new' => [$lat, $lon],
        'rows_updated' => $stmt->rowCount(),
    ];
}

header('Content-Type: application/json; charset=utf-8');
echo json_encode(['ok' => true, 'applied' => count($log), 'log' => $log], JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT);