<?php
// Live-Sitemap: liest publizierte Blogartikel aus Supabase und rendert die komplette sitemap.xml
header('Content-Type: application/xml; charset=utf-8');
header('Cache-Control: public, max-age=3600');

$BASE = 'https://immo-generation.ch';
$RENDER_ORIGIN = 'https://golden-standard-web.lovable.app';
$SUPABASE_URL = 'https://siwmjsdnqlsfvljwvliv.supabase.co';
$SUPABASE_ANON = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InNpd21qc2RucWxzZnZsand2bGl2Iiwicm9sZSI6ImFub24iLCJpYXQiOjE3Nzk4ODU2OTgsImV4cCI6MjA5NTQ2MTY5OH0.huHkfA3R6cTH3cZFMoIXkAJvlVM5mI235WdxRd8btGk';

$STATIC = [
  '/', '/immobilien', '/kaufen', '/mieten', '/kurzzeitvermietung', '/off-market',
  '/referenzen', '/referenzobjekte', '/bewertung', '/blog', '/dienstleistung',
  '/downloads', '/karriere', '/partnerschaft', '/sponsoring', '/suchauftrag',
  '/team', '/kontakt', '/impressum', '/datenschutz',
];
$ORTE = ['romanshorn','thurgau','arbon','amriswil'];
$SERVICES = ['immobilienbewertung-romanshorn','immobilienmakler-romanshorn','liegenschaftsverwaltung-thurgau'];

function fetch_posts($url, $anon) {
  $endpoint = $url . '/rest/v1/blog_posts?select=slug,published_at,updated_at&status=eq.published';
  $ch = curl_init($endpoint);
  curl_setopt_array($ch, [
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_TIMEOUT => 8,
    CURLOPT_HTTPHEADER => [
      'apikey: ' . $anon,
      'Authorization: Bearer ' . $anon,
      'Accept: application/json',
    ],
  ]);
  $body = curl_exec($ch);
  $code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
  curl_close($ch);
  if ($code !== 200 || !$body) return [];
  $data = json_decode($body, true);
  return is_array($data) ? $data : [];
}

function sync_post_page($root, $renderOrigin, $slug, $updatedAt) {
  if (!preg_match('/^[a-z0-9]+(?:-[a-z0-9]+)*$/', $slug)) return false;
  $dir = $root . '/blog/' . $slug;
  $file = $dir . '/index.html';
  $sourceChanged = $updatedAt ? strtotime($updatedAt) : time();
  if (is_file($file) && filemtime($file) >= $sourceChanged) return true;

  $ch = curl_init($renderOrigin . '/blog/' . rawurlencode($slug));
  curl_setopt_array($ch, [
    CURLOPT_RETURNTRANSFER => true,
    CURLOPT_FOLLOWLOCATION => true,
    CURLOPT_MAXREDIRS => 3,
    CURLOPT_TIMEOUT => 25,
    CURLOPT_HTTPHEADER => ['Accept: text/html'],
    CURLOPT_USERAGENT => 'ImmoGeneration-Plesk-Sitemap/1.0',
  ]);
  $html = curl_exec($ch);
  $code = curl_getinfo($ch, CURLINFO_HTTP_CODE);
  $type = curl_getinfo($ch, CURLINFO_CONTENT_TYPE);
  curl_close($ch);
  if ($code !== 200 || !is_string($html) || stripos((string) $type, 'text/html') === false || stripos($html, '<article') === false) {
    return false;
  }
  if (!is_dir($dir) && !mkdir($dir, 0755, true) && !is_dir($dir)) return false;
  $html = str_replace($renderOrigin, 'https://immo-generation.ch', $html);
  $html = str_replace(['src="/assets/', 'href="/assets/'], ['src="' . $renderOrigin . '/assets/', 'href="' . $renderOrigin . '/assets/'], $html);
  $temporary = $file . '.tmp';
  if (file_put_contents($temporary, $html, LOCK_EX) === false) return false;
  if (!rename($temporary, $file)) {
    @unlink($temporary);
    return false;
  }
  return true;
}

$entries = [];
foreach ($STATIC as $p) {
  $entries[] = ['loc' => $BASE . $p, 'changefreq' => 'weekly', 'priority' => $p === '/' ? '1.0' : '0.8'];
}
foreach ($ORTE as $o) {
  $entries[] = ['loc' => "$BASE/kaufen/$o", 'changefreq' => 'weekly', 'priority' => '0.7'];
  $entries[] = ['loc' => "$BASE/mieten/$o", 'changefreq' => 'weekly', 'priority' => '0.7'];
}
foreach ($SERVICES as $s) {
  $entries[] = ['loc' => "$BASE/dienstleistungen/$s", 'changefreq' => 'weekly', 'priority' => '0.7'];
}
$posts = fetch_posts($SUPABASE_URL, $SUPABASE_ANON);
foreach ($posts as $post) {
  $slug = $post['slug'] ?? null;
  if (!$slug) continue;
  sync_post_page(__DIR__, $RENDER_ORIGIN, $slug, $post['updated_at'] ?? $post['published_at'] ?? null);
  $lastmod = $post['updated_at'] ?? $post['published_at'] ?? null;
  $lastmod = $lastmod ? substr($lastmod, 0, 10) : null;
  $entries[] = [
    'loc' => "$BASE/blog/" . rawurlencode($slug),
    'lastmod' => $lastmod,
    'changefreq' => 'monthly',
    'priority' => '0.6',
  ];
}

echo '<?xml version="1.0" encoding="UTF-8"?>' . "\n";
echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">' . "\n";
foreach ($entries as $e) {
  echo "  <url>\n";
  echo "    <loc>" . htmlspecialchars($e['loc'], ENT_XML1) . "</loc>\n";
  if (!empty($e['lastmod'])) echo "    <lastmod>" . $e['lastmod'] . "</lastmod>\n";
  if (!empty($e['changefreq'])) echo "    <changefreq>" . $e['changefreq'] . "</changefreq>\n";
  if (!empty($e['priority'])) echo "    <priority>" . $e['priority'] . "</priority>\n";
  echo "  </url>\n";
}
echo '</urlset>' . "\n";