<?php
require_once __DIR__ . '/../config/ScoreExplainer.php';

$id = (int)($_GET['id'] ?? 0);
if (!$id) { http_response_code(404); die('ID nenurodytas'); }

$broker = null;
if (!empty($ses_id)) {
  $bStmt = $conn->prepare("SELECT name, email, phone, avatar FROM clients WHERE client_id = ? LIMIT 1");
  $bStmt->bind_param('i', $ses_id);
  $bStmt->execute();
  $bRow = $bStmt->get_result()->fetch_assoc();
  $bStmt->close();
  if ($bRow && (!empty($bRow['name']) || !empty($bRow['email']))) {
    $broker = $bRow;
  }
}

$shareUrl = 'https://' . ($_SERVER['HTTP_HOST'] ?? 'findestate.ai') . '?p=mvp&i=9&id=' . $id;

$isSaved  = false;
$comments = [];
$today    = date('Y-m-d');
if (!empty($ses_id)) {
  $cartChk = $conn->prepare("SELECT id FROM cart WHERE user=? AND post_id=? LIMIT 1");
  $cartChk->bind_param('ii', $ses_id, $id); $cartChk->execute();
  $isSaved = (bool)$cartChk->get_result()->fetch_row(); $cartChk->close();

  $cmtRes = $conn->prepare("SELECT id, comment, reminder_date, created_at FROM estate_comments WHERE user_id=? AND post_id=? ORDER BY created_at DESC LIMIT 20");
  $cmtRes->bind_param('ii', $ses_id, $id); $cmtRes->execute();
  $comments = $cmtRes->get_result()->fetch_all(MYSQLI_ASSOC); $cmtRes->close();
}

if (($_GET['format'] ?? '') === 'json') {
  header('Content-Type: application/json; charset=utf-8');
  echo json_encode((new ScoreExplainer($conn))->explain($id), JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT);
  exit;
}

$explainer = new ScoreExplainer($conn);
$data      = $explainer->explain($id);

if (isset($data['error'])) { http_response_code(404); die(htmlspecialchars($data['error'])); }

$e       = $data['estate'];
$sc      = $data['score'];
$mkt     = $data['market'];
$comp    = $data['comparables'];

// COMPARABLES FOTO
while ($conn->more_results()) { $conn->next_result(); }
if (!empty($comp)) {
  $compIds = array_filter(array_column($comp, 'id'));
  if (!empty($compIds)) {
    $placeholders = implode(',', array_fill(0, count($compIds), '?'));
    $imgStmt = $conn->prepare("SELECT id, image_url FROM estates WHERE id IN ({$placeholders}) AND image_url IS NOT NULL AND image_url != ''");
    $imgTypes = str_repeat('i', count($compIds));
    $imgStmt->bind_param($imgTypes, ...$compIds);
    $imgStmt->execute();
    $imgResult = $imgStmt->get_result();
    $imgMap = [];
    while ($imgRow = $imgResult->fetch_assoc()) { $imgMap[$imgRow['id']] = $imgRow['image_url']; }
    $imgResult->free(); $imgStmt->close();
    $comp = array_map(function($c) use ($imgMap) { $c['image_url'] = $imgMap[$c['id'] ?? 0] ?? null; return $c; }, $comp);
  }
}

$related = $data['related'] ?? [];
$mods    = $data['modules'];
$verd    = $data['verdict'];
$mapData = $data['map_data'] ?? [];

function fe_fmt(float|int|null $n): string { return number_format((float)($n ?? 0), 0, ',', ' '); }
function fe_esc(?string $s): string { return htmlspecialchars((string)($s ?? ''), ENT_QUOTES, 'UTF-8'); }

$discColor  = match($mkt['color'] ?? 'neutral') { 'green' => 'success', 'orange' => 'warning', 'red' => 'danger', default => 'secondary' };
$confColor  = match($sc['confidence']) { 'high' => 'success', 'medium' => 'warning', default => 'danger' };
$verdColor  = match($verd['level']) { 'positive' => 'success', 'negative' => 'danger', default => 'secondary' };
$scoreColor = match(true) { $sc['value'] >= 65 => 'success', $sc['value'] >= 50 => 'info', $sc['value'] >= 35 => 'warning', default => 'danger' };

$barPct = 50;
if ($mkt['market_price'] > 0) {
  $barPct = max(5, min(95, (int)(($mkt['actual_price'] / $mkt['market_price']) * 50)));
}

$otypeIcon  = match($e['otype']) { 'apartment' => 'building', 'house' => 'home', 'land' => 'map', default => 'building' };
$otypeLabel = match($e['otype']) { 'apartment' => 'Butas', 'house' => 'Namas', 'land' => 'Sklypas', 'commercial' => 'Komercinis', default => $e['otype'] };
$statusIcons = ['chart' => 'database', 'pin' => 'map-pin', 'building' => 'building', 'signal' => 'trending-up', 'tag' => 'tag'];

$mapCenter = $mapData['center'] ?? null;
// Jei center nėra iš ScoreExplainer, bandome gauti iš estate
if (empty($mapCenter['lat']) || empty($mapCenter['lng'])) {
    $mapCenter = [
        'lat' => (float)($data['estate']['latitude']  ?? $data['estate']['lat']  ?? 0),
        'lng' => (float)($data['estate']['longitude'] ?? $data['estate']['lng']  ?? 0),
    ];
}
// Fallback į Vilnių jei visai nėra
if (empty($mapCenter['lat'])) {
    $mapCenter = ['lat' => 54.6872, 'lng' => 25.2797];
    $hasMap = false;
} else {
    $hasMap = true;
}
// $mapNearby: ScoreExplainer grąžina GeoJSON Feature masyvą.
// Paduodame tiesiai į JS — jis pats pasiims geometry.coordinates.
// Papildomai į properties pridedame 'id' ir 'price' jei jų nėra.
$mapNearbyRaw = $mapData['nearby'] ?? [];
$mapNearby = array_map(function($nr) {
    if (!isset($nr['type'])) return $nr; // jau plokščias
    // GeoJSON Feature — papildinome properties
    $p = $nr['properties'] ?? [];
    // Įsitikinome kad yra 'id' ir 'price' (popup naudoja)
    if (!isset($p['id']))    { $p['id']    = $p['estate_id'] ?? 0; }
    if (!isset($p['price'])) { $p['price'] = $p['price_eur'] ?? 0; }
    if (!isset($p['address'])){ $p['address'] = $p['title'] ?? ''; }
    if (!isset($p['image'])) { $p['image'] = $p['img'] ?? null; }
    // 'type' reiškia 'sold'/'active'
    if (!isset($p['type'])) {
        $p['type'] = !empty($p['sold']) ? 'sold' : 'active';
    }
    $nr['properties'] = $p;
    return $nr;
}, $mapNearbyRaw);
$anomaly   = !empty($data['estate']['anomaly_flag'] ?? false);

$r = 42; $circ = 2 * M_PI * $r;
$dash = $circ * ($sc['value'] / 100);
$strokeColor = match($scoreColor) { 'success' => '#2fb344', 'info' => '#0ea5e9', 'warning' => '#f59f00', default => '#d63939' };

$flagLabels = [
  'high_ceilings' => ['Aukštos lubos','success'], 'terrace_or_balcony' => ['Terasa / balkonas','success'],
  'fireplace' => ['Židinys','success'], 'solar_panels' => ['Saulės baterijos','success'],
  'renovated_recently' => ['Renovuotas per 5m.','success'], 'smart_home' => ['Smart home','success'],
  'storage_room' => ['Rūsys / sandėliukas','success'], 'parking_included' => ['Parkavimas','success'],
  'noise_issue' => ['Triukšminga aplinka','warning'], 'north_facing' => ['Langai į šiaurę','warning'],
  'needs_repair' => ['Reikalingas remontas','danger'], 'no_elevator' => ['Nėra lifto','warning'],
  'electric_only_heating' => ['Tik elektrinis šildymas','warning'], 'problematic_building' => ['Probleminė aplinka','danger'],
];
$flags    = $mkt['description_flags'] ?? [];
$hasFlags = !empty(array_filter($flags ?? [], fn($v, $k) => isset($flagLabels[$k]), ARRAY_FILTER_USE_BOTH));

// Investicinis rodiklis
$rentalYield = null;
$rentalData  = null;
if (in_array($e['otype'], ['apartment', 'house']) && ($mkt['actual_price'] ?? 0) > 0) {
  $rOtype  = $e['otype'];
  $rCity   = $e['city']    ?? '';
  $rSize   = (float)($data['estate']['size_sqm'] ?? 0);
  $rRooms  = (int)($data['estate']['room_number'] ?? 0);
  $rLat    = (float)($mapCenter['lat'] ?? 0);
  $rLng    = (float)($mapCenter['lng'] ?? 0);
  $sizeMin = $rSize > 0 ? $rSize * 0.60 : 0;
  $sizeMax = $rSize > 0 ? $rSize * 1.40 : 99999;
  $rentalRows = [];
  foreach (['radius_1' => 1.0, 'radius_3' => 3.0, 'city' => null] as $mode => $km) {
    if (!empty($rentalRows)) break;
    if ($km !== null && $rLat && $rLng) {
      $sql = "SELECT e.price_eur AS rent_monthly, e.size_sqm,
            ROUND(6371000 * ACOS(GREATEST(-1, LEAST(1,
              COS(RADIANS(?)) * COS(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
              * COS(RADIANS(CAST(e.longitude AS DECIMAL(11,8))) - RADIANS(?))
              + SIN(RADIANS(?)) * SIN(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
            )))) AS dist_m
          FROM estates e
          WHERE e.sell_rent = 2 AND e.otype = ? AND e.done = 1
            AND e.price_eur BETWEEN 50 AND 8000
            " . ($rSize > 0 ? "AND e.size_sqm BETWEEN ? AND ?" : "") . "
            " . ($rRooms > 0 ? "AND (e.room_number = ? OR e.room_number IS NULL)" : "") . "
            AND (6371 * ACOS(GREATEST(-1, LEAST(1,
                COS(RADIANS(?)) * COS(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
                * COS(RADIANS(CAST(e.longitude AS DECIMAL(11,8))) - RADIANS(?))
                + SIN(RADIANS(?)) * SIN(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
            )))) <= ?
          ORDER BY dist_m ASC LIMIT 25";
      $st = $conn->prepare($sql);
      if (!$st) continue;
      $t = 'ddd'; $p = [$rLat, $rLng, $rLat];
      $t .= 's'; $p[] = $rOtype;
      if ($rSize > 0) { $t .= 'dd'; $p[] = $sizeMin; $p[] = $sizeMax; }
      if ($rRooms > 0) { $t .= 'i'; $p[] = $rRooms; }
      $t .= 'dddd'; $p[] = $rLat; $p[] = $rLng; $p[] = $rLat; $p[] = $km;
    } else {
      $sql = "SELECT e.price_eur AS rent_monthly, e.size_sqm, NULL AS dist_m
          FROM estates e
          WHERE e.sell_rent = 2 AND e.otype = ? AND e.city = ? AND e.done = 1
            AND e.price_eur BETWEEN 50 AND 8000
            " . ($rSize > 0 ? "AND e.size_sqm BETWEEN ? AND ?" : "") . "
          ORDER BY e.created_at DESC LIMIT 25";
      $st = $conn->prepare($sql);
      if (!$st) continue;
      $t = 'ss'; $p = [$rOtype, $rCity];
      if ($rSize > 0) { $t .= 'dd'; $p[] = $sizeMin; $p[] = $sizeMax; }
    }
    $st->bind_param($t, ...$p); $st->execute();
    $rows_tmp = $st->get_result()->fetch_all(MYSQLI_ASSOC); $st->close();
    if (count($rows_tmp) >= 3) $rentalRows = $rows_tmp;
  }
  if (count($rentalRows) >= 3) {
    $rents = array_column($rentalRows, 'rent_monthly'); sort($rents);
    $mid = (int)(count($rents) / 2);
    $medianRent = count($rents) % 2 === 0 ? ($rents[$mid-1] + $rents[$mid]) / 2 : $rents[$mid];
    $buyPrice   = (float)$mkt['actual_price'];
    $annualRent = $medianRent * 12;
    $grossYield = $buyPrice > 0 ? ($annualRent / $buyPrice) * 100 : 0;
    $netYield   = $grossYield * 0.75;
    $payback    = $annualRent > 0 ? $buyPrice / $annualRent : 0;
    $rentalData = [
      'median_rent'   => (int)round($medianRent),
      'gross_yield'   => round($grossYield, 2),
      'net_yield'     => round($netYield, 2),
      'payback_years' => round($payback, 1),
      'sample_count'  => count($rentalRows),
      'buy_price'     => $buyPrice,
      'annual_rent'   => (int)round($annualRent),
    ];
    $rentalYield = match(true) {
      $grossYield >= 7   => ['label' => 'Puikus',    'color' => 'success', 'icon' => 'trending-up'],
      $grossYield >= 5   => ['label' => 'Geras',     'color' => 'teal',    'icon' => 'trending-up'],
      $grossYield >= 3.5 => ['label' => 'Vidutinis', 'color' => 'warning', 'icon' => 'minus'],
      default            => ['label' => 'Žemas',     'color' => 'danger',  'icon' => 'trending-down'],
    };
  }
}

// ADMIN
if ($ses_id == 1) { $isAdmin = true; }
$isHidden = false;
if ($isAdmin) {
  $conn->query("ALTER TABLE estates ADD COLUMN IF NOT EXISTS `hide` TINYINT(1) NOT NULL DEFAULT 0");
  $hideRes = $conn->query("SELECT `hide` FROM estates WHERE id = $id LIMIT 1");
  if ($hideRes) { $hideRow = $hideRes->fetch_assoc(); $isHidden = (bool)($hideRow['hide'] ?? false); }
}

$ajaxUrl      = '/score_card_ajax.php';
$scoreCronUrl = 'https://data.rasknt.lt/config/score_cron.php?id=' . $id;

// Suggestions (taip pat gali dominti)
$suggestions = []; $suggestionRadius = null;
if (!empty($e['otype'])) {
  $sOtype    = $e['otype'];
  $sId       = (int)($data['estate']['id'] ?? 0);
  $sLat      = (float)($mapCenter['lat'] ?? 0);
  $sLng      = (float)($mapCenter['lng'] ?? 0);
  $sizeField = ($sOtype === 'land') ? 'land_size_are' : 'size_sqm';
  $sizeVal   = ($sOtype === 'land') ? (float)($data['estate']['land_size_are'] ?? 0) : (float)($data['estate']['size_sqm'] ?? 0);
  $sRooms    = (int)($data['estate']['room_number'] ?? 0);
  $sYear     = (int)($data['estate']['year'] ?? 0);
  $yearMin   = ($sYear > 0 && $sYear <= 2000) ? 1900 : max(1900, $sYear - 10);
  $yearMax   = ($sYear > 0 && $sYear <= 2000) ? 2000 : ($sYear > 0 ? $sYear + 10 : 2100);
  $excludeIds = [$sId];
  if (!empty($comp))    { foreach ($comp    as $c) { if (!empty($c['id']))  $excludeIds[] = (int)$c['id'];  } }
  if (!empty($related)) { foreach ($related as $r) { if (!empty($r['id']))  $excludeIds[] = (int)$r['id'];  } }
  $excludeIds = array_unique($excludeIds);
  $sizeMin = $sizeVal > 0 ? $sizeVal * 0.70 : 0;
  $sizeMax = $sizeVal > 0 ? $sizeVal * 1.30 : 99999;

  // Saugiai statome WHERE sąlygas — be tarpų problemų
  $extraWhere = '';
  if ($sizeVal > 0)  { $extraWhere .= " AND e.{$sizeField} BETWEEN ? AND ?"; }
  if ($sYear > 0)    { $extraWhere .= " AND (e.year BETWEEN ? AND ? OR e.year IS NULL)"; }
  if ($sRooms > 0 && in_array($sOtype, ['apartment','house'])) { $extraWhere .= " AND (e.room_number = ? OR e.room_number IS NULL)"; }

  foreach ([1,3,5,10] as $km) {
    if (count($suggestions) >= 15) break;
    if (!$sLat || !$sLng) break;
    $ph  = implode(',', array_fill(0, count($excludeIds), '?'));
    $sql = "SELECT e.id, e.otype, e.city, e.address, e.price_eur, e.image_url, e.url,
               e.size_sqm, e.land_size_are, e.room_number, e.year, e.build_status,
               e.findestate_score, e.deal_score, e.market_price_eur, e.is_hot_deal,
               ROUND(6371 * ACOS(GREATEST(-1, LEAST(1,
                   COS(RADIANS(?)) * COS(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
                   * COS(RADIANS(CAST(e.longitude AS DECIMAL(11,8))) - RADIANS(?))
                   + SIN(RADIANS(?)) * SIN(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
               ))), 2) AS dist_km,
               CASE WHEN e.size_sqm > 0 THEN ROUND(e.price_eur / e.size_sqm) ELSE NULL END AS price_sqm
        FROM estates e
        WHERE e.id NOT IN ({$ph})
          AND e.otype = ?
          AND e.price_eur > 0
          AND e.findestate_score IS NOT NULL
          {$extraWhere}
          AND (6371 * ACOS(GREATEST(-1, LEAST(1,
              COS(RADIANS(?)) * COS(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
              * COS(RADIANS(CAST(e.longitude AS DECIMAL(11,8))) - RADIANS(?))
              + SIN(RADIANS(?)) * SIN(RADIANS(CAST(e.latitude AS DECIMAL(10,8))))
          )))) <= ?
        ORDER BY e.findestate_score DESC, e.price_eur ASC
        LIMIT 15";
    $stmt = $conn->prepare($sql); if (!$stmt) continue;
    $types = 'ddd'; $params = [$sLat, $sLng, $sLat];
    $types .= str_repeat('i', count($excludeIds)); $params = array_merge($params, $excludeIds);
    $types .= 's'; $params[] = $sOtype;
    if ($sizeVal > 0)  { $types .= 'dd'; $params[] = $sizeMin; $params[] = $sizeMax; }
    if ($sYear > 0)    { $types .= 'ii'; $params[] = $yearMin;  $params[] = $yearMax; }
    if ($sRooms > 0 && in_array($sOtype, ['apartment','house'])) { $types .= 'i'; $params[] = $sRooms; }
    $types .= 'dddd'; $params[] = $sLat; $params[] = $sLng; $params[] = $sLat; $params[] = (float)$km;
    $stmt->bind_param($types, ...$params); $stmt->execute();
    $rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); $stmt->close();
    foreach ($rows as $row) {
      if (!isset($suggestions[$row['id']])) {
        $row['radius_km'] = $km;
        $suggestions[$row['id']] = $row;
        if (count($suggestions) >= 15) break;
      }
    }
    if (count($suggestions) >= 10) { $suggestionRadius = $km; break; }
    $suggestionRadius = $km;
  }
  if (count($suggestions) < 10 && !empty($e['city'])) {
    $alreadyFound = array_keys($suggestions);
    $excludeAll   = array_unique(array_merge($excludeIds, $alreadyFound));
    $ph    = implode(',', array_fill(0, count($excludeAll), '?'));
    $limit = 15 - count($suggestions);

    // Fallback: tik miesto filtras be koordinačių
    $extraWhereCity = '';
    if ($sizeVal > 0) { $extraWhereCity .= " AND e.{$sizeField} BETWEEN ? AND ?"; }
    if ($sYear > 0)   { $extraWhereCity .= " AND (e.year BETWEEN ? AND ? OR e.year IS NULL)"; }

    $sql   = "SELECT e.id, e.otype, e.city, e.address, e.price_eur, e.image_url, e.url,
                 e.size_sqm, e.land_size_are, e.room_number, e.year, e.build_status,
                 e.findestate_score, e.deal_score, e.market_price_eur, e.is_hot_deal,
                 NULL AS dist_km,
                 CASE WHEN e.size_sqm > 0 THEN ROUND(e.price_eur / e.size_sqm) ELSE NULL END AS price_sqm
          FROM estates e
          WHERE e.id NOT IN ({$ph})
            AND e.otype = ?
            AND e.city = ?
            AND e.price_eur > 0
            AND e.findestate_score IS NOT NULL
            {$extraWhereCity}
          ORDER BY e.findestate_score DESC, e.price_eur ASC
          LIMIT {$limit}";
    $stmt = $conn->prepare($sql);
    if ($stmt) {
      $types = str_repeat('i', count($excludeAll)) . 'ss'; $params = array_merge($excludeAll, [$sOtype, $e['city']]);
      if ($sizeVal > 0) { $types .= 'dd'; $params[] = $sizeMin; $params[] = $sizeMax; }
      if ($sYear > 0)   { $types .= 'ii'; $params[] = $yearMin;  $params[] = $yearMax; }
      $stmt->bind_param($types, ...$params); $stmt->execute();
      $rows = $stmt->get_result()->fetch_all(MYSQLI_ASSOC); $stmt->close();
      foreach ($rows as $row) { $row['radius_km'] = null; $suggestions[$row['id']] = $row; }
    }
    $suggestionRadius = null;
  }
  $suggestions = array_values($suggestions);
}

$sgMarketPrice = (float)($mkt['market_price'] ?? 0);

// Suggestions JSON
$sgJson = '[]';
if (!empty($suggestions)) {
  $sgJson = json_encode(array_map(function($s) use ($sgMarketPrice) {
    $vsPct = ($sgMarketPrice > 0 && $s['price_eur'] > 0)
      ? round(($sgMarketPrice - $s['price_eur']) / $sgMarketPrice * 100, 1)
      : null;
    $img = !empty($s['image_url'])
      ? 'https://findestate.eu/f.php?u=' . $s['image_url']
      : null;
    return [
      'id'           => (int)$s['id'],
      'address'      => mb_substr($s['address'] ?? '', 0, 45),
      'city'         => $s['city'] ?? '',
      'price'        => (float)$s['price_eur'],
      'price_sqm'    => $s['price_sqm'] ? (int)$s['price_sqm'] : null,
      'score'        => $s['findestate_score'] !== null ? round((float)$s['findestate_score'], 1) : null,
      'vs_market'    => $vsPct,
      'dist_km'      => $s['dist_km'] !== null ? (float)$s['dist_km'] : null,
      'size'         => $s['otype'] === 'land'
        ? ($s['land_size_are'] ? number_format((float)$s['land_size_are'], 0, ',', '.') . ' a'  : null)
        : ($s['size_sqm']      ? number_format((float)$s['size_sqm'],      0, ',', '.') . ' m²' : null),
      'rooms'        => $s['room_number'] ? (int)$s['room_number'] : null,
      'year'         => $s['year'] ? (int)$s['year'] : null,
      'build_status' => $s['build_status'] ?? null,
      'image'        => $img,
      'url'          => '/?p=analysis&id=' . (int)$s['id'],
      'ext_url'      => $s['url'] ?? null,
      'is_hot'       => !empty($s['is_hot_deal']),
      'land_size'    => (!empty($s['land_size_are']) && $s['land_size_are'] > 0)
        ? number_format((float)$s['land_size_are'], 0, ',', '.') . ' a'
        : null,
      'floor'        => (!empty($s['floor']) && $s['floor'] > 0) ? (int)$s['floor'] : null,
      'days_market'  => !empty($s['created_at'])
        ? (int)((time() - strtotime($s['created_at'])) / 86400)
        : null,
    ];
  }, $suggestions), JSON_UNESCAPED_UNICODE);
}
?>
<!doctype html>
<html lang="lt">
<head>
  <meta charset="utf-8"/>
  <meta name="viewport" content="width=device-width, initial-scale=1, viewport-fit=cover"/>
  <title>RaskNT · <?= fe_esc($e['address']) ?> · <?= fe_fmt($mkt['actual_price'] ?? 0) ?> €</title>
  <meta property="og:title" content="<?= fe_esc($e['address']) ?> · <?= fe_fmt($mkt['actual_price'] ?? 0) ?> €">
  <meta property="og:description" content="Rinkos vidurkis: <?= fe_fmt($mkt['market_price'] ?? 0) ?> € · <?= fe_esc($verd['text'] ?? '') ?>">
  <?php if ($e['image']): ?><meta property="og:image" content="<?= fe_esc($e['image']) ?>"><?php endif ?>
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@tabler/core@1.0.0-beta20/dist/css/tabler.min.css">
  <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/@tabler/icons-webfont@3.11.0/tabler-icons.min.css">
  <?php if ($hasMap): ?><link href='https://api.mapbox.com/mapbox-gl-js/v2.15.0/mapbox-gl.css' rel='stylesheet'><?php endif ?>
  <style>
    h2.page-title{word-break:break-word;overflow-wrap:anywhere}
    .score-ring{position:relative;display:inline-flex;align-items:center;justify-content:center}
    .score-ring svg{transform:rotate(-90deg)}
    .score-ring .score-val{position:absolute;text-align:center}
    .comp-thumb{width:48px;height:36px;object-fit:cover;border-radius:4px;cursor:zoom-in;flex-shrink:0;min-width:48px}
    .comp-thumb-ph{width:48px;height:36px;background:var(--tblr-gray-100);border-radius:4px;display:flex;align-items:center;justify-content:center;flex-shrink:0;min-width:48px}
    .price-bar-wrap{position:relative;height:8px;border-radius:4px;background:var(--tblr-gray-200);overflow:hidden}
    .price-bar-fill{height:100%;border-radius:4px;background:linear-gradient(90deg,#2fb344,#00b8c8)}
    .price-bar-marker{position:absolute;top:-3px;width:3px;height:14px;background:var(--tblr-secondary);border-radius:2px;left:50%}
    .mod-bar{height:6px;background:var(--tblr-gray-200);border-radius:3px;overflow:hidden}
    .mod-bar-fill{height:100%;border-radius:3px;transition:width 1s cubic-bezier(.4,0,.2,1)}
    .badge-sold{background:rgba(43,190,127,.12);color:#1e8a5e;border:1px solid rgba(43,190,127,.25)}
    .badge-removed{background:var(--tblr-gray-100);color:var(--tblr-secondary);border:1px solid var(--tblr-border-color)}
    .stamp-badge{display:inline-flex;align-items:center;gap:.3rem;font-size:.72rem;font-weight:600;text-transform:uppercase;letter-spacing:.07em;border-radius:6px;padding:.28rem .7rem;border:2px solid}
    .stamp-badge.hot{color:#d63939;border-color:#d63939;background:rgba(214,57,57,.06)}
    .stamp-badge.anomaly{color:#f59f00;border-color:#f59f00;background:rgba(245,159,0,.06)}
    #lightbox{display:none;position:fixed;inset:0;background:rgba(0,0,0,.88);z-index:9999;align-items:center;justify-content:center;cursor:zoom-out}
    #lightbox.open{display:flex}
    #lightbox img{max-width:92vw;max-height:88vh;border-radius:8px}
    #lightbox .lbx-close{position:absolute;top:1rem;right:1rem;width:36px;height:36px;border-radius:50%;background:rgba(255,255,255,.15);border:none;color:#fff;font-size:1.1rem;cursor:pointer;display:flex;align-items:center;justify-content:center}
    .related-thumb{width:52px;height:40px;object-fit:cover;border-radius:5px;flex-shrink:0}
    .related-thumb-ph{width:52px;height:40px;background:var(--tblr-gray-100);border-radius:5px;flex-shrink:0;display:flex;align-items:center;justify-content:center}
    #estate-map{height:380px;border-radius:0 0 8px 8px;}
    .mapboxgl-popup-content{padding:0!important;border-radius:10px!important;overflow:hidden;min-width:200px;box-shadow:0 6px 20px rgba(0,0,0,.15)!important;}

    /* ── "TAIP PAT GALI DOMINTI" kortelės ── */
    .sg-cards-grid{display:grid;grid-template-columns:repeat(4,1fr);gap:12px;padding:14px;}
    @media(max-width:1200px){.sg-cards-grid{grid-template-columns:repeat(3,1fr);}}
    @media(max-width:768px){.sg-cards-grid{grid-template-columns:repeat(2,1fr);gap:10px;padding:10px;}}
    @media(max-width:480px){.sg-cards-grid{grid-template-columns:1fr;}}
    .sg-card{background:#fff;border:0.5px solid rgba(0,0,0,.12);border-radius:10px;overflow:hidden;cursor:pointer;transition:transform .15s,box-shadow .15s;display:flex;flex-direction:column;}
    .sg-card:hover{transform:translateY(-2px);box-shadow:0 6px 20px rgba(0,0,0,.1);}
    .sg-card-img{width:100%;height:110px;object-fit:cover;background:#f1f3f5;display:block;flex-shrink:0;}
    .sg-card-img-ph{width:100%;height:110px;background:#f1f3f5;display:flex;align-items:center;justify-content:center;flex-shrink:0;}
    .sg-card-body{padding:9px 11px;flex:1;display:flex;flex-direction:column;gap:4px;}
    .sg-card-addr{font-size:12px;font-weight:600;color:#1e293b;line-height:1.3;display:-webkit-box;-webkit-line-clamp:2;-webkit-box-orient:vertical;overflow:hidden;}
    .sg-card-price{font-size:15px;font-weight:700;color:#1e293b;line-height:1.2;}
    .sg-card-sqm{font-size:11px;color:#888;font-weight:400;}
    .sg-card-meta{font-size:11px;color:#94a3b8;margin-top:2px;}
    .sg-card-badges{display:flex;align-items:center;gap:4px;flex-wrap:wrap;margin-top:4px;}
    .sg-card-score{display:inline-flex;align-items:center;justify-content:center;border-radius:5px;font-size:11px;font-weight:700;color:#fff;padding:2px 7px;}
    .sg-card-vs{font-size:10px;font-weight:600;border-radius:10px;padding:1px 6px;}
    .sg-card-hot{font-size:10px;background:#ef4444;color:#fff;border-radius:10px;padding:1px 6px;}
    .sg-card-footer{display:flex;gap:5px;padding:0 8px 8px;}
    .sg-card-btn{flex:1;padding:5px 6px;border:none;border-radius:6px;font-size:11px;font-weight:600;cursor:pointer;text-align:center;text-decoration:none;display:flex;align-items:center;justify-content:center;gap:3px;}
    .sg-card-btn-primary{background:#0054a6;color:#fff;}
    .sg-card-btn-primary:hover{background:#003d7a;color:#fff;}
    .sg-card-btn-analysis{background:#ecfdf5;color:#065f46;border:1px solid #6ee7b7!important;}
    .sg-card-btn-analysis:hover{background:#d1fae5;color:#065f46;}
    .sg-sort-bar{padding:8px 14px;border-bottom:1px solid rgba(0,0,0,.07);background:#f8f9fa;display:flex;align-items:center;gap:6px;flex-wrap:wrap;}
    .sg-pagination{padding:10px 14px;border-top:1px solid rgba(0,0,0,.07);display:flex;align-items:center;justify-content:space-between;flex-wrap:wrap;gap:8px;}

    @keyframes fadeInNote{from{opacity:0;transform:translateY(-6px)}to{opacity:1;transform:translateY(0)}}
    @media print{.no-print{display:none!important}}
    @media print{body{font-size:11pt}.card{break-inside:avoid;box-shadow:none!important;border:1px solid #dee2e6!important}#estate-map{display:none}}

    @media(max-width:576px){
      .container-xl{padding-left:.75rem;padding-right:.75rem}
      .col-lg-7,.col-lg-5{width:100%}
      .header-row{flex-direction:column!important;align-items:stretch!important}
      .header-row .col-auto{width:100%!important;display:flex;justify-content:center}
      .header-row .col-auto .card{min-width:unset!important;width:100%;max-width:320px}
      .page-title{font-size:1.1rem!important}
      .broker-row{flex-direction:column!important;gap:.75rem!important}
      .broker-row .col,.broker-row .col-auto{width:100%!important}
      .broker-share{justify-content:center!important}
      .price-cols{flex-wrap:wrap!important}
      .price-col-left,.price-col-right{width:50%!important;flex:0 0 50%!important}
      .price-col-badge{width:100%!important;flex:0 0 100%!important;display:flex;align-items:center;gap:.5rem;margin-top:.25rem}
      #estate-map{height:260px}
      .admin-bar-inner{gap:.35rem!important}
      .score-ring-card{padding:.75rem 1rem!important}
      .header-badges{gap:.35rem!important}
      .mod-item{padding:.6rem .75rem!important}
      .sg-cards-grid{grid-template-columns:1fr!important;}
      #map-type-switcher .d-none{display:none!important}
    }
    @media(min-width:577px) and (max-width:768px){
      .page-title{font-size:1.2rem!important}
      .broker-share{justify-content:flex-end}
    }
  </style>
</head>
<body class="antialiased">
<div id="lightbox">
  <button class="lbx-close" onclick="closeLightbox()">✕</button>
  <img id="lbx-img" src="" alt="">
</div>

<div class="page-wrapper"><div class="page-body"><div class="container-xl py-4">

<!-- HEADER -->
<div class="row g-3 mb-3 align-items-start header-row">
  <div class="col">
    <div class="d-flex align-items-center gap-2 mb-1 flex-wrap header-badges">
      <span class="badge bg-blue-lt"><i class="ti ti-<?= $otypeIcon ?> me-1"></i><?= $otypeLabel ?></span>
      <?php if ($e['sold']): ?><span class="badge bg-secondary-lt"><i class="ti ti-tag me-1"></i>Išimtas<?= $e['sold_date'] ? ' · '.$e['sold_date'] : '' ?></span><?php endif ?>
      <?php if ($sc['is_hot_deal'] && !$anomaly): ?><span class="stamp-badge hot"><i class="ti ti-flame"></i>Hot Deal</span><?php endif ?>
      <?php if ($anomaly): ?><span class="stamp-badge anomaly"><i class="ti ti-alert-triangle"></i>Didelė nuolaida — tikrink</span><?php endif ?>
    </div>
    <h2 class="page-title mb-1"><?= fe_esc($e['address']) ?></h2>
    <div class="text-muted mb-2"><?= fe_esc($e['city']) ?></div>
    <div class="d-flex flex-wrap gap-2">
      <?php if ($e['size']): ?><span class="badge bg-secondary-lt"><?= fe_esc($e['size']) ?></span><?php endif ?>
      <?php if ($e['rooms']): ?><span class="badge bg-secondary-lt"><?= fe_esc($e['rooms']) ?></span><?php endif ?>
      <?php if ($e['year']): ?><span class="badge bg-secondary-lt"><?= $e['year'] ?> m.</span><?php endif ?>
      <?php if ($e['floor']): ?><span class="badge bg-secondary-lt"><?= fe_esc($e['floor']) ?></span><?php endif ?>
      <?php
      // Sklypo plotas (namams dažnai trūkdavo)
      $_landAre = (float)($data['estate']['land_size_are'] ?? 0);
      if ($_landAre > 0): ?><span class="badge bg-secondary-lt"><i class="ti ti-border-all me-1"></i><?= number_format($_landAre, 0, ',', ' ') ?> a</span><?php endif ?>
      <?php
      // Dienos rinkoje
      $_createdAt = $data['estate']['created_at'] ?? $data['estate']['date_created'] ?? null;
      $_daysInMarket = $_createdAt ? (int)((time() - strtotime($_createdAt)) / 86400) : 0;
      if ($_daysInMarket > 0):
        $_daysCls = $_daysInMarket > 60 ? 'warning' : ($_daysInMarket > 30 ? 'yellow' : 'success');
      ?><span class="badge bg-<?= $_daysCls ?>-lt"><i class="ti ti-clock me-1"></i><?= $_daysInMarket ?> d. rinkoje</span><?php endif ?>
      <span class="badge bg-secondary-lt"><i class="ti ti-<?= $e['seller']==='Savininkas'?'user':'briefcase' ?> me-1"></i><?= fe_esc($e['seller']) ?></span>
      <?php if ($e['url']): ?><a href="<?= fe_esc($e['url']) ?>" target="_blank" class="btn btn-sm btn-outline-primary no-print"><i class="ti ti-eye me-1"></i>Peržiūrėti skelbimą</a><?php endif ?>
      <?php if (!empty($ses_id)): ?>
      <button id="save-btn" onclick="toggleSave()" class="btn btn-sm <?= $isSaved?'btn-danger':'btn-outline-secondary' ?> no-print">
        <i class="ti ti-<?= $isSaved?'heart-filled':'heart' ?> me-1"></i>
        <span id="save-label"><?= $isSaved?'Išsaugota':'Išsaugoti' ?></span>
      </button>
      <?php endif ?>
    </div>
  </div>
  <div class="col-auto">
    <div class="card text-center px-4 py-3 score-ring-card" style="min-width:160px;box-shadow:0 1px 8px rgba(0,0,0,.08);border:1px solid #e6e7e9;">
      <div class="score-ring mb-2">
        <svg width="100" height="100" viewBox="0 0 100 100">
          <circle cx="50" cy="50" r="<?= $r ?>" fill="none" stroke="#e9ecef" stroke-width="8"/>
          <circle cx="50" cy="50" r="<?= $r ?>" fill="none" stroke="<?= $strokeColor ?>" stroke-width="8"
            stroke-dasharray="<?= round($dash,2) ?> <?= round($circ,2) ?>" stroke-linecap="round"/>
        </svg>
        <div class="score-val">
          <div style="font-size:1.5rem;font-weight:700;line-height:1;color:<?= $strokeColor ?>"><?= number_format($sc['value'],1,',','') ?></div>
          <div style="font-size:.65rem;color:var(--tblr-secondary)">/100</div>
        </div>
      </div>
      <div class="mb-1">
        <?php for($i=1;$i<=5;$i++): ?><i class="ti ti-star<?= $i<=$sc['stars']?'-filled text-warning':' text-muted' ?>" style="font-size:.85rem"></i><?php endfor ?>
      </div>
      <span class="badge bg-<?= $confColor ?>-lt"><?= fe_esc($sc['confidence_label']) ?></span>
      <div class="text-muted mt-1" style="font-size:.72rem"><?= fe_esc($sc['confidence_note']) ?></div>
    </div>
  </div>
</div>

<!-- ADMIN JUOSTA -->
<?php if ($isAdmin): ?>
<div class="card mb-3 no-print" style="border:2px dashed #e53e3e;border-radius:10px;background:rgba(229,62,62,.03)">
  <div class="card-body py-2 px-3">
    <div class="d-flex align-items-center gap-2 flex-wrap admin-bar-inner">
      <span class="badge bg-red-lt fw-bold"><i class="ti ti-shield me-1"></i>Admin · ID: <?= $id ?></span>
      <button id="btn-rescore" onclick="adminRescore()" class="btn btn-sm btn-outline-warning"><i class="ti ti-refresh me-1"></i>Perskorinti</button>
      <button id="btn-clearscore" onclick="adminClearScore()" class="btn btn-sm btn-outline-secondary"><i class="ti ti-eraser me-1"></i>Valyti skoringą</button>
      <button id="btn-hide" onclick="adminToggleHide()" class="btn btn-sm <?= $isHidden?'btn-danger':'btn-outline-danger' ?>">
        <i class="ti ti-eye-off me-1"></i>
        <span id="btn-hide-label"><?= $isHidden?'Paslėpta — spausti rodyti':'Slėpti' ?></span>
      </button>
      <button id="btn-editcoords" onclick="adminToggleCoordEdit()" class="btn btn-sm btn-outline-info"><i class="ti ti-map-pin me-1"></i>Keisti koordinates</button>
      <a href="https://data.rasknt.lt/config/score_debug_json.php?id=<?= $id ?>" target="_blank" class="btn btn-sm btn-outline-secondary"><i class="ti ti-code me-1"></i>Debug JSON</a>
      <?php if ($isHidden): ?><span class="badge bg-danger-lt"><i class="ti ti-eye-off me-1"></i>Paslėptas</span><?php endif ?>
      <span id="admin-feedback" class="text-muted small" style="display:none"></span>
    </div>
    <div id="coord-edit-hint" style="display:none" class="mt-2 alert alert-info py-1 mb-0">
      <i class="ti ti-map-pin me-1"></i>
      <?php if ($hasMap): ?>
        Paspaukite ant žemėlapio norimoje vietoje.
      <?php else: ?>
        Koordinačių nėra. Įveskite adresą:
        <div class="d-flex gap-2 mt-1">
          <input type="text" id="coord-search-input" class="form-control form-control-sm" placeholder="Pvz.: Gedimino pr. 1, Vilnius" style="max-width:300px">
          <button onclick="adminSearchCoords()" class="btn btn-sm btn-info">Ieškoti</button>
        </div>
        <div id="coord-search-result" class="mt-1 small text-muted"></div>
      <?php endif ?>
      <button onclick="adminToggleCoordEdit()" class="btn btn-xs btn-outline-secondary ms-2">Atšaukti</button>
    </div>
  </div>
</div>
<?php endif ?>

<!-- BROKERIO KORTELĖ -->
<div class="card mb-3 no-print" style="border:2px solid var(--tblr-primary);border-radius:12px;overflow:hidden">
  <div class="card-body py-3">
    <div class="row align-items-center g-3 broker-row">
      <div class="col">
        <?php if ($broker): ?>
        <div class="d-flex align-items-center gap-3" id="broker-content">
          <?php if (!empty($broker['avatar'])): ?>
            <span class="avatar avatar-lg rounded-circle" style="background-image:url('<?= fe_esc($broker['avatar']) ?>');width:52px;height:52px;flex-shrink:0"></span>
          <?php else: ?>
            <span class="avatar avatar-lg rounded-circle bg-primary text-white" style="width:52px;height:52px;flex-shrink:0;font-size:1.2rem"><?= mb_substr($broker['name']??'B',0,1) ?></span>
          <?php endif ?>
          <div>
            <div class="fw-bold"><?= fe_esc($broker['name']??'Brokeris') ?></div>
            <div class="d-flex flex-wrap gap-2 mt-1">
              <?php if (!empty($broker['phone'])): ?><a href="tel:<?= fe_esc($broker['phone']) ?>" class="text-reset small"><i class="ti ti-phone me-1 text-primary"></i><?= fe_esc($broker['phone']) ?></a><?php endif ?>
              <?php if (!empty($broker['email'])): ?><a href="mailto:<?= fe_esc($broker['email']) ?>" class="text-reset small"><i class="ti ti-mail me-1 text-primary"></i><?= fe_esc($broker['email']) ?></a><?php endif ?>
            </div>
            <div class="d-flex gap-2 mt-2 flex-wrap">
              <a href="?p=settings" class="btn btn-xs btn-outline-secondary" style="font-size:.68rem;padding:.2rem .55rem"><i class="ti ti-edit me-1"></i>Redaguoti</a>
              <button onclick="toggleBrokerVisibility()" id="broker-hide-btn" class="btn btn-xs btn-outline-warning" style="font-size:.68rem;padding:.2rem .55rem"><i class="ti ti-eye-off me-1"></i>Slėpti</button>
            </div>
          </div>
        </div>
        <?php else: ?>
        <div class="d-flex align-items-center gap-3">
          <span class="avatar avatar-lg rounded-circle bg-primary-lt text-primary" style="width:52px;height:52px;flex-shrink:0;font-size:1.4rem"><i class="ti ti-user"></i></span>
          <div>
            <div class="fw-medium mb-1">Tavo kontaktai čia</div>
            <a href="?p=settings" class="btn btn-sm btn-primary"><i class="ti ti-upload me-1"></i>Įkelti brokerio informaciją</a>
          </div>
        </div>
        <?php endif ?>
      </div>
      <div class="col-auto">
        <div class="text-muted small mb-2 text-center fw-medium" style="font-size:.7rem;text-transform:uppercase;letter-spacing:.05em">Siųsti / Dalintis</div>
        <div class="d-flex gap-2 flex-wrap justify-content-end broker-share">
          <button onclick="copyShareLink()" class="btn btn-sm btn-icon" style="background:#6c757d;color:#fff;border:none" title="Kopijuoti nuorodą"><i class="ti ti-link fs-4"></i></button>
          <a href="https://wa.me/?text=<?= urlencode(($e['address']??'').' · '.number_format($mkt['actual_price']??0,0,',',' ').' € · '.$shareUrl) ?>" target="_blank" class="btn btn-sm btn-icon" style="background:#25D366;color:#fff;border:none"><i class="ti ti-brand-whatsapp fs-4"></i></a>
          <a href="https://www.facebook.com/sharer/sharer.php?u=<?= urlencode($shareUrl??'') ?>" target="_blank" class="btn btn-sm btn-icon" style="background:#1877F2;color:#fff;border:none"><i class="ti ti-brand-facebook fs-4"></i></a>
          <a href="mailto:?subject=<?= urlencode('NT objektas: '.($e['address']??'')) ?>&body=<?= urlencode(($e['address']??'')."\nKaina: ".number_format($mkt['actual_price']??0,0,',',' ')." €\nRaskNT: ".$shareUrl) ?>" class="btn btn-sm btn-icon" style="background:#dc3545;color:#fff;border:none"><i class="ti ti-mail fs-4"></i></a>
          <button onclick="window.print()" class="btn btn-sm btn-icon btn-secondary"><i class="ti ti-printer fs-4"></i></button>
        </div>
        <div id="copy-toast" class="text-center small text-success mt-1" style="display:none;font-size:.72rem"><i class="ti ti-check me-1"></i>Nukopijuota!</div>
      </div>
    </div>
  </div>
</div>

<!-- FOTO -->
<?php if ($e['image']): ?>
<div class="card mb-3 overflow-hidden no-print" style="cursor:zoom-in;max-height:320px" onclick="openLightbox('<?= fe_esc($e['image']) ?>')">
  <img src="<?= fe_esc($e['image']) ?>" alt="" class="card-img-top" style="max-height:320px;object-fit:cover">
  <div class="card-img-overlay d-flex align-items-end p-2"><span class="badge bg-dark-lt"><i class="ti ti-zoom-in me-1"></i>Padidinti</span></div>
</div>
<?php endif ?>

<div class="row g-3">
<!-- ============================================================ -->
<!-- KAIRĖ KOLONA -->
<!-- ============================================================ -->
<div class="col-lg-7">

<?php $noCoords = empty($mkt['has_coords']??true)||!($mkt['has_coords']??true); $lowData = ($sc['confidence']==='low')||($sc['comparables_count']<3); if ($lowData||$noCoords): ?>
<div class="alert alert-warning mb-3" style="border-left:4px solid #f59f00">
  <div class="d-flex gap-2">
    <i class="ti ti-alert-triangle text-warning" style="font-size:1.2rem;flex-shrink:0;margin-top:2px"></i>
    <div>
      <h4 class="alert-title mb-1" style="font-size:.9rem">Nepakanka duomenų tiksliai analizei</h4>
      <div class="text-body-secondary" style="font-size:.82rem">
        <?php if($noCoords): ?>Koordinatės nenustatytos — analizė pagrįsta miesto vidurkiu.
        <?php elseif($sc['comparables_count']<3): ?>Rasta tik <strong><?= $sc['comparables_count'] ?></strong> panašių objektų.
        <?php else: ?>Mažai palyginamų objektų — vertinimas apytikris.<?php endif ?>
        Rekomenduojame patikrinti rankiniu būdu.
      </div>
    </div>
  </div>
</div>
<?php endif ?>

<!-- KAINOS ANALIZĖ -->
<div class="card mb-3">
  <div class="card-header"><h3 class="card-title"><i class="ti ti-currency-euro me-2 text-primary"></i>Kainos analizė</h3></div>
  <div class="card-body">
    <div class="row g-3 mb-3 price-cols">
      <div class="col price-col-left">
        <div class="text-muted small mb-1">Kaina skelbime</div>
        <?php if($mkt['price_reduced']&&$mkt['original_price']): ?><div class="text-decoration-line-through text-muted small"><?= fe_fmt($mkt['original_price']) ?> €</div><?php endif ?>
        <div class="h2 mb-0"><?= fe_fmt($mkt['actual_price']) ?> €</div>
        <?php if($mkt['price_per_sqm']): ?><div class="text-muted small"><?= fe_fmt($mkt['price_per_sqm']) ?> €/m²</div><?php endif ?>
      </div>
      <?php if($mkt['market_price']>0): ?>
      <div class="col price-col-right">
        <div class="text-muted small mb-1">Rinkos vidurkis</div>
        <div class="h3 mb-0 text-secondary"><?= fe_fmt($mkt['market_price']) ?> €</div>
        <?php if($mkt['market_per_sqm']): ?><div class="text-muted small"><?= fe_fmt($mkt['market_per_sqm']) ?> €/m²</div><?php endif ?>
        <?php $rl=$mkt['price_range_low']??null;$rh=$mkt['price_range_high']??null;if($rl&&$rh): ?><div class="text-muted small mt-1"><i class="ti ti-arrows-horizontal me-1"></i><?= fe_fmt($rl) ?>–<?= fe_fmt($rh) ?> €</div><?php endif ?>
      </div>
      <div class="col-auto price-col-badge d-flex flex-column align-items-end justify-content-center">
        <span class="badge bg-<?= $discColor ?> fs-5 py-2 px-3"><?= $mkt['diff_pct']>=0?'−':'+' ?><?= abs($mkt['diff_pct']) ?>%</span>
        <?php if($mkt['diff_eur']!=0): ?><div class="text-muted small mt-1"><?= fe_fmt(abs($mkt['diff_eur'])) ?> €</div><?php endif ?>
        <div class="text-<?= $discColor ?> small fw-medium mt-1"><?= fe_esc($mkt['label']) ?></div>
      </div>
      <?php endif ?>
    </div>
    <?php if($mkt['market_price']>0&&$mkt['percentile']!==null): ?>
    <div class="d-flex justify-content-between small text-muted mb-1"><span>Pigiausi rinkoje</span><span>Brangiausi rinkoje</span></div>
    <div class="price-bar-wrap mb-1">
      <div class="price-bar-fill" style="width:<?= $barPct ?>%"></div>
      <div class="price-bar-marker"></div>
    </div>
    <div class="text-center text-muted small">Pigesnis nei <strong><?= $mkt['percentile'] ?>%</strong> iš <?= $sc['comparables_count'] ?> panašių objektų · <?= fe_esc($sc['radius_label']??'') ?></div>
    <?php endif ?>
  </div>
</div>

<?php
// ── Dienos rinkoje — analizė ──────────────────────────────────────
$_daysCreated = $data['estate']['created_at'] ?? null;
$_daysInMarket = $_daysCreated ? (int)((time() - strtotime($_daysCreated)) / 86400) : 0;

// Skaičiuojame rinkos vidurkį: kiek dienų panašūs objektai buvo skelbiami
$_avgDays = null;
$_avgDaysSample = 0;
if ($_daysInMarket > 0 && !empty($e['otype'])) {
    $avgSql = "SELECT AVG(DATEDIFF(COALESCE(updated_at, NOW()), created_at)) AS avg_days,
                      COUNT(*) AS cnt
               FROM estates
               WHERE otype = ? AND city = ? AND price_eur > 0
                 AND created_at > DATE_SUB(NOW(), INTERVAL 12 MONTH)
                 AND (sold = 1 OR created_at < DATE_SUB(NOW(), INTERVAL 7 DAY))
               LIMIT 1";
    $avgStmt = $conn->prepare($avgSql);
    if ($avgStmt) {
        $avgStmt->bind_param('ss', $e['otype'], $e['city']);
        $avgStmt->execute();
        $avgRow = $avgStmt->get_result()->fetch_assoc();
        $avgStmt->close();
        if ($avgRow && $avgRow['avg_days'] > 0) {
            $_avgDays = (int)round($avgRow['avg_days']);
            $_avgDaysSample = (int)$avgRow['cnt'];
        }
    }
}
?>
<?php if ($_daysInMarket > 0): ?>
<div class="card mb-3">
    <div class="card-header">
        <h3 class="card-title"><i class="ti ti-clock me-2 text-info"></i>Laikas rinkoje</h3>
        <?php if ($_avgDays): ?>
        <div class="card-options"><span class="badge bg-secondary-lt text-muted" style="font-size:.65rem;">vidurkis iš <?= $_avgDaysSample ?> obj.</span></div>
        <?php endif ?>
    </div>
    <div class="card-body">
        <div class="row g-3 text-center">
            <div class="col-6">
                <div class="text-muted small mb-1">Šis objektas</div>
                <?php
                $cls = $_daysInMarket > ($_avgDays ?: 60) ? 'danger' : ($_daysInMarket > 30 ? 'warning' : 'success');
                ?>
                <div class="h2 mb-0 text-<?= $cls ?>"><?= $_daysInMarket ?></div>
                <div class="text-muted small">dienų</div>
            </div>
            <?php if ($_avgDays): ?>
            <div class="col-6">
                <div class="text-muted small mb-1">Rinkos vidurkis</div>
                <div class="h2 mb-0 text-secondary"><?= $_avgDays ?></div>
                <div class="text-muted small">dienų</div>
            </div>
            <?php endif ?>
        </div>
        <?php if ($_avgDays): ?>
        <div class="mt-3">
            <div class="progress progress-sm">
                <div class="progress-bar bg-<?= $cls ?>" style="width:<?= min(100, (int)(($_daysInMarket / max($_avgDays, 1)) * 100)) ?>%"></div>
            </div>
            <div class="mt-2 small text-center">
            <?php if ($_daysInMarket < $_avgDays * 0.5): ?>
                <span class="text-success"><i class="ti ti-trending-up me-1"></i>Naujas objektas — mažiau nei pusė vidutinio laiko rinkoje</span>
            <?php elseif ($_daysInMarket < $_avgDays): ?>
                <span class="text-info"><i class="ti ti-clock me-1"></i>Rinkoje trumpiau nei vidurkis — geras laikas derėtis</span>
            <?php elseif ($_daysInMarket < $_avgDays * 1.5): ?>
                <span class="text-warning"><i class="ti ti-alert-circle me-1"></i>Rinkoje ilgiau nei vidurkis — pardavėjas gali būti lankstesnis</span>
            <?php else: ?>
                <span class="text-danger"><i class="ti ti-flame me-1"></i>Rinkoje <?= round($_daysInMarket / max($_avgDays,1), 1) ?>× ilgiau nei vidurkis — didelė derybų erdvė</span>
            <?php endif ?>
            </div>
        </div>
        <?php endif ?>
    </div>
</div>
<?php endif ?>

<!-- PANAŠŪS OBJEKTAI -->
<?php if(!empty($comp)): ?>
<div class="card mb-3">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-building-community me-2 text-primary"></i>Vertinami panašūs objektai</h3>
    <div class="card-options"><span class="badge bg-primary-lt"><?= count($comp) ?> objektai · <?= fe_esc($sc['radius_label']??'') ?></span></div>
  </div>
  <div class="table-responsive">
    <table class="table table-vcenter table-sm card-table table-hover">
      <thead class="table-light"><tr>
        <th style="width:56px"></th>
        <th>Adresas ir parametrai</th>
        <th class="text-end">Kaina</th>
        <th class="text-end">vs. vid.</th>
        <th class="text-end">Atstumas</th>
        <th class="text-end no-print" style="width:140px"></th>
      </tr></thead>
      <tbody>
      <?php foreach($comp as $c):
        $cOtype  = $c['otype'] ?? $e['otype'];
        $cDiffCls = $c['diff_pct']!==null ? (abs($c['diff_pct'])<=3?'secondary':($c['diff_pct']>0?'warning':'success')) : null;
        $cDist   = $c['distance_m']!==null ? ($c['distance_m']<1000?(int)$c['distance_m'].' m':number_format($c['distance_m']/1000,1,',','').' km') : '—';
        $cImg    = !empty($c['image_url']) ? 'https://findestate.eu/f.php?u='.fe_esc($c['image_url']) : null;
      ?>
      <tr>
        <td>
          <?php if($cImg): ?>
          <img src="<?= $cImg ?>" onclick="openLightbox('<?= $cImg ?>')"
            style="width:52px;height:40px;object-fit:cover;border-radius:5px;cursor:zoom-in;" alt="" loading="lazy"
            onerror="this.style.display='none';this.nextElementSibling.style.display='flex'">
          <div style="display:none;width:52px;height:40px;background:#f1f5f9;border-radius:5px;align-items:center;justify-content:center;"><i class="ti ti-photo-off text-muted" style="font-size:.7rem"></i></div>
          <?php else: ?>
          <div style="width:52px;height:40px;background:#f1f5f9;border-radius:5px;display:flex;align-items:center;justify-content:center;"><i class="ti ti-photo-off text-muted" style="font-size:.7rem"></i></div>
          <?php endif ?>
        </td>
        <td>
          <div class="fw-medium text-truncate" style="max-width:200px;font-size:.875rem;">
            <?= fe_esc($c['address']) ?>
            <?php if(($c['status']??'')==='sold'): ?><span class="badge badge-sold ms-1" style="font-size:.55rem">parduotas</span><?php endif ?>
            <?php if(($c['status']??'')==='removed'): ?><span class="badge badge-removed ms-1" style="font-size:.55rem">išimtas</span><?php endif ?>
          </div>
          <div style="display:flex;flex-wrap:wrap;gap:3px;margin-top:3px;">
            <?php
            // Kambariai
            if (!empty($c['room_number']) && $c['room_number'] > 0)
              echo '<span style="background:#f1f5f9;border-radius:3px;padding:0 5px;font-size:10px;color:#334155;">'.(int)$c['room_number'].' k.</span>';
            // Plotas m²
            if (!empty($c['size_sqm']) && $c['size_sqm'] > 0)
              echo '<span style="background:#f1f5f9;border-radius:3px;padding:0 5px;font-size:10px;color:#334155;font-weight:600;">'.fe_fmt($c['size_sqm']).' m²</span>';
            // Sklypo plotas
            if (!empty($c['land_size_are']) && $c['land_size_are'] > 0)
              echo '<span style="background:#f0fdf4;border-radius:3px;padding:0 5px;font-size:10px;color:#166534;">'.fe_fmt($c['land_size_are']).' a</span>';
            // Aukštas
            if (!empty($c['floor']) && $c['floor'] > 0 && $cOtype === 'apartment')
              echo '<span style="background:#f1f5f9;border-radius:3px;padding:0 5px;font-size:10px;color:#334155;">'.(int)$c['floor'].'-as a.</span>';
            // Metai
            if (!empty($c['year']))
              echo '<span style="background:#f8fafc;border-radius:3px;padding:0 5px;font-size:10px;color:#64748b;">'.$c['year'].' m.</span>';
            // Įrengimas
            if (!empty($c['build_status']))
              echo '<span style="background:#f8fafc;border-radius:3px;padding:0 5px;font-size:10px;color:#64748b;">'.fe_esc($c['build_status']).'</span>';
            // Dienos rinkoje
            if (!empty($c['days_listed']) && $c['days_listed'] > 0)
              echo '<span style="background:#fef9c3;border-radius:3px;padding:0 5px;font-size:10px;color:#78350f;">'.$c['days_listed'].' d.</span>';
            ?>
          </div>
        </td>
        <td class="text-end" style="white-space:nowrap;">
          <div class="fw-medium" style="font-size:.875rem;"><?= fe_fmt($c['price_eur']) ?> €</div>
          <?php if($c['price_per_sqm']): ?><div class="text-muted" style="font-size:.7rem;"><?= fe_fmt($c['price_per_sqm']) ?> €/m²</div><?php endif ?>
        </td>
        <td class="text-end">
          <?php if($cDiffCls): ?>
          <span class="badge bg-<?= $cDiffCls ?>-lt"><?= ($c['diff_pct']>0?'+':'').number_format($c['diff_pct'],1,',','') ?>%</span>
          <?php else: ?>—<?php endif ?>
        </td>
        <td class="text-end text-muted" style="font-size:.8rem;"><?= $cDist ?></td>
        <td class="text-end no-print">
          <div class="d-flex justify-content-end gap-1">
            <?php if($c['url']): ?>
            <a href="<?= fe_esc($c['url']) ?>" target="_blank" class="btn btn-xs btn-primary" style="font-size:.65rem;padding:2px 7px;" title="Atidaryti skelbimą">
              <i class="ti ti-external-link"></i>
            </a>
            <?php endif ?>
            <?php if(!empty($c['id'])): ?>
            <a href="/?p=analysis&id=<?= (int)$c['id'] ?>" class="btn btn-xs" style="font-size:.65rem;padding:2px 7px;background:#ecfdf5;color:#065f46;border:1px solid #6ee7b7;" title="Analizė">
              <i class="ti ti-chart-bar"></i>
            </a>
            <?php endif ?>
          </div>
        </td>
      </tr>
      <?php endforeach ?>
      </tbody>
    </table>
  </div>
</div>
<?php endif ?>

<!-- SUSIJĘ SKELBIMAI -->
<?php if(!empty($related)): ?>
<div class="card mb-3">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-copy me-2 text-orange"></i>Susiję skelbimai</h3>
    <div class="card-options"><span class="badge bg-orange-lt"><?= count($related) ?> portaluose</span></div>
  </div>
  <div class="table-responsive">
    <table class="table table-vcenter table-sm card-table table-hover">
      <thead class="table-light"><tr>
        <th style="width:56px"></th>
        <th>Portalas ir parametrai</th>
        <th class="text-end">Kaina</th>
        <th class="text-end">vs. šis</th>
        <th class="text-end no-print" style="width:80px"></th>
      </tr></thead>
      <tbody>
      <?php foreach($related as $rel):
        $relDays   = (int)($rel['days_in_market'] ?? 0);
        $relScore  = $rel['score'] ?? null;
        $mainPrice = $mkt['actual_price'] ?? 0;
        $relDiff   = ($mainPrice > 0 && $rel['price_eur'] > 0)
          ? round(($rel['price_eur'] - $mainPrice) / $mainPrice * 100, 1) : null;
        $relCls    = $relDiff === null ? null : ($relDiff > 2 ? 'danger' : ($relDiff < -2 ? 'success' : 'secondary'));
        $relImg    = !empty($rel['image_url']) ? 'https://findestate.eu/f.php?u='.fe_esc($rel['image_url']) : null;
      ?>
      <tr>
        <td>
          <?php if($relImg): ?>
          <img src="<?= $relImg ?>" onclick="openLightbox('<?= $relImg ?>')"
            style="width:52px;height:40px;object-fit:cover;border-radius:5px;cursor:zoom-in;" alt="" loading="lazy"
            onerror="this.style.display='none';this.nextElementSibling.style.display='flex'">
          <div style="display:none;width:52px;height:40px;background:#f1f5f9;border-radius:5px;align-items:center;justify-content:center;"><i class="ti ti-photo-off text-muted" style="font-size:.7rem"></i></div>
          <?php else: ?>
          <div style="width:52px;height:40px;background:#f1f5f9;border-radius:5px;display:flex;align-items:center;justify-content:center;"><i class="ti ti-photo-off text-muted" style="font-size:.7rem"></i></div>
          <?php endif ?>
        </td>
        <td>
          <div class="fw-medium" style="font-size:.875rem;">
            <?= fe_esc($rel['domain'] ?? '') ?>
            <?php if($rel['sold']): ?><span class="badge badge-removed ms-1" style="font-size:.55rem">išimtas</span><?php endif ?>
          </div>
          <div style="display:flex;flex-wrap:wrap;gap:3px;margin-top:3px;">
            <?php
            // Kambariai
            if (!empty($rel['room_number']) && $rel['room_number'] > 0)
              echo '<span style="background:#f1f5f9;border-radius:3px;padding:0 5px;font-size:10px;color:#334155;">'.(int)$rel['room_number'].' k.</span>';
            // Plotas m²
            if (!empty($rel['size_sqm']) && $rel['size_sqm'] > 0)
              echo '<span style="background:#f1f5f9;border-radius:3px;padding:0 5px;font-size:10px;color:#334155;font-weight:600;">'.fe_fmt($rel['size_sqm']).' m²</span>';
            // Sklypo plotas
            if (!empty($rel['land_size_are']) && $rel['land_size_are'] > 0)
              echo '<span style="background:#f0fdf4;border-radius:3px;padding:0 5px;font-size:10px;color:#166534;">'.fe_fmt($rel['land_size_are']).' a</span>';
            // Metai
            if (!empty($rel['year']))
              echo '<span style="background:#f8fafc;border-radius:3px;padding:0 5px;font-size:10px;color:#64748b;">'.$rel['year'].' m.</span>';
            // Dienos rinkoje
            if ($relDays > 0)
              echo '<span style="background:#fef9c3;border-radius:3px;padding:0 5px;font-size:10px;color:#78350f;">'.$relDays.' d.</span>';
            // Score
            if ($relScore !== null)
              echo '<span style="background:#ede9fe;border-radius:3px;padding:0 5px;font-size:10px;color:#5b21b6;">Score: '.$relScore.'</span>';
            ?>
          </div>
        </td>
        <td class="text-end" style="white-space:nowrap;">
          <div class="fw-medium" style="font-size:.875rem;"><?= fe_fmt($rel['price_eur']) ?> €</div>
        </td>
        <td class="text-end">
          <?php if($relCls): ?>
          <span class="badge bg-<?= $relCls ?>-lt"><?= ($relDiff>0?'+':'').$relDiff ?>%</span>
          <?php else: ?>—<?php endif ?>
        </td>
        <td class="text-end no-print">
          <div class="d-flex justify-content-end gap-1">
            <?php if($rel['url']): ?>
            <a href="<?= fe_esc($rel['url']) ?>" target="_blank" class="btn btn-xs btn-primary" style="font-size:.65rem;padding:2px 7px;" title="Atidaryti skelbimą">
              <i class="ti ti-external-link"></i>
            </a>
            <?php endif ?>
            <?php if(!empty($rel['id'])): ?>
            <a href="/?p=analysis&id=<?= (int)$rel['id'] ?>" class="btn btn-xs" style="font-size:.65rem;padding:2px 7px;background:#ecfdf5;color:#065f46;border:1px solid #6ee7b7;" title="Analizė">
              <i class="ti ti-chart-bar"></i>
            </a>
            <?php endif ?>
          </div>
        </td>
      </tr>
      <?php endforeach ?>
      </tbody>
    </table>
  </div>
  <div class="card-footer text-muted small"><i class="ti ti-info-circle me-1"></i>Tas pats fizinis objektas skirtinguose portaluose</div>
</div>
<?php endif ?>

<!-- VERDIKTAS -->
<div class="alert alert-<?= $verdColor ?> mb-3">
  <div class="d-flex gap-3">
    <i class="ti ti-<?= $verd['level']==='positive'?'circle-check':($verd['level']==='negative'?'alert-triangle':'info-circle') ?> alert-icon"></i>
    <div>
      <h4 class="alert-title">Vertinimo išvada</h4>
      <div class="text-body-secondary"><?= fe_esc($verd['text']) ?></div>
      <?php if(!empty($verd['signals'])): ?><ul class="mt-2 mb-0 ps-3" style="font-size:.875rem"><?php foreach($verd['signals'] as $sig): ?><li><?= fe_esc($sig) ?></li><?php endforeach ?></ul><?php endif ?>
    </div>
  </div>
</div>

<?php if($hasMap): ?>
<div class="card mb-3 no-print">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-map me-2 text-primary"></i>Aplinka žemėlapyje</h3>
    <div class="card-options"><span class="badge bg-secondary-lt"><?= count($mapNearby) ?> panašių objektų 2km spinduliu</span></div>
  </div>
  <div class="card-body p-0"><div id="estate-map"></div></div>
  <div class="card-footer text-muted small d-flex gap-3 flex-wrap">
    <span><span style="width:12px;height:12px;background:#7c3aed;border-radius:50%;display:inline-block;margin-right:4px;"></span>Šis objektas</span>
    <span><span style="width:12px;height:12px;background:<?= ['apartment'=>'#0054a6','house'=>'#2fb344','land'=>'#f59f00','commercial'=>'#9b59b6'][$e['otype']]??'#0054a6' ?>;border-radius:50%;display:inline-block;margin-right:4px;"></span>Aktyvūs</span>
    <span><span style="width:12px;height:12px;background:#94a3b8;border-radius:50%;display:inline-block;margin-right:4px;"></span>Išimti</span>
  </div>
</div>
<?php endif ?>

</div><!-- /kairė kolona -->

<!-- ============================================================ -->
<!-- DEŠINĖ KOLONA -->
<!-- ============================================================ -->
<div class="col-lg-5">

<div class="card mb-3">
  <div class="card-header"><h3 class="card-title"><i class="ti ti-adjustments me-2 text-primary"></i>Reitingo sudėtis</h3></div>
  <div class="card-body p-0">
  <?php
  $modColorMap=['deal'=>['success','#2fb344'],'quality'=>['primary','#0054a6'],'location'=>['info','#0ea5e9'],'signals'=>['warning','#f59f00'],'market'=>['secondary','#6c7a8d']];
  foreach($mods as $mi=>$mod):
    $pct=$mod['score']??0; [$modCls,$hex]=$modColorMap[$mod['key']]??['secondary','#6c7a8d'];
    $icon=$statusIcons[$mod['icon']]??'circle';
  ?>
  <div class="px-4 py-3 mod-item <?= $mi<count($mods)-1?'border-bottom':'' ?>">
    <div class="d-flex align-items-center mb-2">
      <span class="avatar avatar-xs me-2 bg-<?= $modCls ?>-lt text-<?= $modCls ?>"><i class="ti ti-<?= $icon ?>"></i></span>
      <div class="flex-fill">
        <div class="fw-medium small d-flex justify-content-between align-items-center">
          <span><?= fe_esc($mod['label']) ?></span>
          <span class="badge bg-secondary-lt ms-1"><?= fe_esc($mod['weight']) ?></span>
        </div>
        <div class="text-muted" style="font-size:.72rem"><?= fe_esc($mod['note']) ?></div>
      </div>
      <?php if($mod['score']!==null): ?><div class="ms-3 text-end" style="min-width:46px"><span class="fw-bold" style="color:<?= $hex ?>"><?= round($pct) ?></span><span class="text-muted small">/100</span></div><?php endif ?>
    </div>
    <?php if($mod['score']!==null): ?>
    <div class="mod-bar"><div class="mod-bar-fill" style="width:<?= round($pct) ?>%;background:<?= $hex ?>"></div></div>
    <?php elseif($mod['key']==='market'):
      $compN=(int)($sc['comparables_count']??0); $barW=min(100,(int)(($compN/15)*100));
      $barC=$compN>=10?'#2fb344':($compN>=5?'#f59f00':'#d63939');
      $lbl=$compN>=10?'Patikimas':($compN>=5?'Pakankamas':'Mažai duomenų');
    ?>
    <div class="mt-2">
      <div class="d-flex justify-content-between align-items-center mb-1">
        <span style="font-size:.65rem;color:var(--tblr-secondary)">0</span>
        <span style="font-size:.65rem;font-weight:600;color:<?= $barC ?>"><?= $compN ?> obj. — <?= $lbl ?></span>
        <span style="font-size:.65rem;color:var(--tblr-secondary)">15+</span>
      </div>
      <div class="mod-bar" style="height:8px"><div class="mod-bar-fill" style="width:<?= $barW ?>%;background:<?= $barC ?>;height:8px"></div></div>
    </div>
    <?php endif ?>
  </div>
  <?php endforeach ?>
  </div>
</div>

<?php if($hasFlags): ?>
<div class="card mb-3">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-sparkles me-2 text-primary"></i>Objekto ypatybės</h3>
    <div class="card-options"><span class="badge bg-secondary-lt" style="font-size:.63rem">AI analizė</span></div>
  </div>
  <div class="card-body">
    <div class="d-flex flex-wrap gap-2">
    <?php foreach($flags as $key=>$val): if(!isset($flagLabels[$key]))continue; [$label,$color]=$flagLabels[$key]; $ac=$val?$color:'secondary'; ?>
    <span class="badge bg-<?= $ac ?>-lt"><i class="ti ti-<?= $val?'check':'x' ?> me-1"></i><?= fe_esc($label) ?></span>
    <?php endforeach ?>
    </div>
  </div>
</div>
<?php endif ?>

<?php if($rentalData && $rentalYield): ?>
<div class="card mb-3">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-building-bank me-2 text-primary"></i>Investicinis rodiklis</h3>
    <div class="card-options">
      <span class="badge bg-<?= $rentalYield['color'] ?>-lt fw-medium">
        <i class="ti ti-<?= $rentalYield['icon'] ?> me-1"></i><?= fe_esc($rentalYield['label']) ?>
      </span>
    </div>
  </div>
  <div class="card-body p-0">
    <table class="table table-sm card-table">
      <tr><td class="text-muted small">Pirkimo kaina</td><td class="text-end fw-medium"><?= fe_fmt($rentalData['buy_price']) ?> €</td></tr>
      <tr><td class="text-muted small">Nuoma/mėn. <span class="text-muted" style="font-size:.65rem">(<?= $rentalData['sample_count'] ?> skelb. vidurkis)</span></td><td class="text-end fw-bold text-success"><?= fe_fmt($rentalData['median_rent']) ?> €</td></tr>
      <tr><td class="text-muted small">Metinė nuoma</td><td class="text-end fw-medium"><?= fe_fmt($rentalData['annual_rent']) ?> €</td></tr>
      <tr><td class="text-muted small fw-medium">Gross yield</td><td class="text-end"><span class="badge bg-<?= $rentalYield['color'] ?>-lt fs-6 py-1 px-2 fw-bold"><?= $rentalData['gross_yield'] ?>%</span></td></tr>
      <tr><td class="text-muted small">Net yield (~75%)</td><td class="text-end text-muted"><?= $rentalData['net_yield'] ?>%</td></tr>
      <tr><td class="text-muted small">Atsipirkimo laikotarpis</td><td class="text-end fw-medium"><?= $rentalData['payback_years'] ?> m.</td></tr>
    </table>
    <div class="px-3 pb-3 pt-1">
      <div class="d-flex justify-content-between mb-1" style="font-size:.68rem;color:var(--tblr-muted)">
        <span>0%</span><span>3.5%</span><span>5%</span><span>7%+</span>
      </div>
      <?php $bPct=min(100,($rentalData['gross_yield']/8)*100); $bColor=$rentalYield['color']==='success'?'#2fb344':($rentalYield['color']==='teal'?'#0ca678':($rentalYield['color']==='warning'?'#f59f00':'#d63939')); ?>
      <div style="height:8px;background:var(--tblr-gray-200);border-radius:4px;overflow:hidden;position:relative">
        <div style="height:100%;width:<?= $bPct ?>%;background:<?= $bColor ?>;border-radius:4px;transition:width 1s"></div>
        <div style="position:absolute;top:0;left:43.75%;width:2px;height:100%;background:rgba(0,0,0,.2)"></div>
        <div style="position:absolute;top:0;left:62.5%;width:2px;height:100%;background:rgba(0,0,0,.2)"></div>
      </div>
    </div>
  </div>
  <div class="card-footer text-muted" style="font-size:.71rem;line-height:1.5">
    <i class="ti ti-info-circle me-1"></i>Gross yield = metinė nuoma ÷ pirkimo kaina. Vilniaus rinkos vidurkis: <strong>4–5%</strong>.
    <?php if($rentalData['gross_yield']>=5): ?><span class="text-success">Šis objektas viršija rinkos vidurkį.</span>
    <?php elseif($rentalData['gross_yield']<3.5): ?><span class="text-warning">Žemiau rinkos vidurkio — rekomenduojame derėtis.</span><?php endif ?>
  </div>
</div>
<?php endif ?>

<div class="card">
  <div class="card-header"><h3 class="card-title"><i class="ti ti-info-circle me-2 text-muted"></i>Duomenys</h3></div>
  <div class="card-body p-0">
    <table class="table table-sm card-table">
      <tr><td class="text-muted small">Patikimumas</td><td class="text-end"><span class="badge bg-<?= $confColor ?>-lt"><?= fe_esc($sc['confidence_label']) ?></span></td></tr>
      <tr><td class="text-muted small">Palyginamų objektų</td><td class="text-end fw-medium"><?= $sc['comparables_count'] ?></td></tr>
      <tr><td class="text-muted small">Paieškos spindulys</td><td class="text-end fw-medium"><?= fe_esc($sc['radius_label']??'—') ?></td></tr>
      <?php if(!empty($related)): ?><tr><td class="text-muted small">Susiję portaluose</td><td class="text-end fw-medium"><?= count($related) ?></td></tr><?php endif ?>
      <tr><td class="text-muted small">Atnaujinta</td><td class="text-end fw-medium"><?= fe_esc($sc['updated_at']??'—') ?></td></tr>
      <?php if($e['seller']): ?><tr><td class="text-muted small">Pardavėjas</td><td class="text-end fw-medium"><?= fe_esc($e['seller']) ?></td></tr><?php endif ?>
      <?php if($anomaly): ?><tr class="table-warning"><td class="small fw-medium" colspan="2"><i class="ti ti-alert-triangle me-1 text-warning"></i>Kaina >30% žemiau rinkos medianos.</td></tr><?php endif ?>
    </table>
  </div>
  <?php if($e['url']): ?><div class="card-footer"><a href="<?= fe_esc($e['url']) ?>" target="_blank" class="btn btn-primary w-100"><i class="ti ti-eye me-2"></i>Peržiūrėti skelbimą</a></div><?php endif ?>
</div>

<?php if(!empty($ses_id)): ?>
<div class="card no-print mt-3" id="notes-card">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-notes me-2 text-primary"></i>Pastabos ir priminimai</h3>
    <?php if(!empty($comments)): ?><div class="card-options"><span class="badge bg-primary-lt"><?= count($comments) ?></span></div><?php endif ?>
  </div>
  <div class="card-body pb-2">
    <textarea id="note-input" class="form-control mb-2" rows="2" placeholder="Pastaba... (Ctrl+Enter — išsaugoti)" style="resize:vertical;font-size:.875rem"></textarea>
    <div class="d-flex gap-2 align-items-center mb-2 flex-wrap">
      <input type="date" id="rem-date-input" class="form-control form-control-sm" min="<?= $today ?>" style="max-width:160px">
      <button onclick="saveNote()" id="note-save-btn" class="btn btn-sm btn-primary"><i class="ti ti-star me-1"></i>Išsaugoti</button>
      <a id="gcal-btn" href="#" target="_blank" class="btn btn-sm btn-outline-secondary d-none"><i class="ti ti-brand-google me-1"></i>Kalendorius</a>
      <span id="note-feedback" class="text-success small d-none"><i class="ti ti-circle-check me-1"></i>Išsaugota!</span>
    </div>
    <div class="text-muted" style="font-size:.7rem"><i class="ti ti-info-circle me-1"></i>Komentaro išsaugojimas automatiškai prideda į išsaugotus</div>
    <div id="comments-list">
    <?php if(!empty($comments)): ?>
    <div class="border-top mt-3 pt-2">
    <?php foreach($comments as $cm):
      $isPast=!empty($cm['reminder_date'])&&$cm['reminder_date']<$today;
      $hasDt=!empty($cm['reminder_date']);
      $gcTitle=urlencode('NT apžiūra: '.($e['address']??''));
      $gcDesc=urlencode(($cm['comment']??'')."\n".$shareUrl);
      $gcLoc=urlencode($e['address']??'');
      $gcDate=$hasDt?date('Ymd',strtotime($cm['reminder_date'])):date('Ymd',strtotime('+1 day'));
      $gcUrl="https://calendar.google.com/calendar/render?action=TEMPLATE&text=$gcTitle&details=$gcDesc&location=$gcLoc&dates={$gcDate}T070000Z/{$gcDate}T080000Z";
    ?>
    <div class="py-2 border-bottom <?= $isPast?'opacity-50':'' ?>">
      <?php if($hasDt): ?>
      <div class="d-flex align-items-center gap-2 mb-1 flex-wrap">
        <span class="badge <?= $isPast?'bg-secondary-lt':'bg-danger-lt' ?>"><i class="ti ti-calendar-event me-1"></i><?= fe_esc($cm['reminder_date']) ?><?= $isPast?' · praėjo':'' ?></span>
        <a href="<?= fe_esc($gcUrl) ?>" target="_blank" class="btn btn-xs btn-outline-secondary" style="font-size:.65rem;padding:.15rem .45rem"><i class="ti ti-brand-google me-1"></i>GCal</a>
      </div>
      <?php endif ?>
      <div style="font-size:.85rem;white-space:pre-line"><?= fe_esc($cm['comment']??'') ?></div>
      <div class="text-muted" style="font-size:.65rem"><?= date('Y-m-d H:i',strtotime($cm['created_at'])) ?></div>
    </div>
    <?php endforeach ?>
    </div>
    <?php endif ?>
    </div>
  </div>
</div>
<?php endif ?>

</div><!-- /dešinė kolona -->
</div><!-- /row -->

<!-- TAIP PAT GALI DOMINTI — PILNO PLOČIO -->
<?php if(!empty($suggestions)): ?>
<div class="card mt-4" id="sg-card">
  <div class="card-header">
    <h3 class="card-title"><i class="ti ti-layout-grid me-2 text-primary"></i>Taip pat gali dominti</h3>
    <div class="card-options gap-2">
      <?php if($suggestionRadius): ?>
      <span class="badge bg-secondary-lt"><i class="ti ti-map-pin me-1"></i><?= $suggestionRadius ?> km spinduliu</span>
      <?php else: ?>
      <span class="badge bg-secondary-lt"><i class="ti ti-building me-1"></i><?= fe_esc($e['city']) ?></span>
      <?php endif; ?>
      <span class="badge bg-primary-lt"><?= count($suggestions) ?> objektai</span>
    </div>
  </div>
  <div class="sg-sort-bar">
    <span class="text-muted small me-1"><i class="ti ti-arrows-sort me-1"></i>Rūšiuoti:</span>
    <button class="btn btn-xs btn-primary sg-sort active" data-sort="score" data-dir="desc"><i class="ti ti-star me-1"></i>Score ↓</button>
    <button class="btn btn-xs btn-outline-secondary sg-sort" data-sort="price" data-dir="asc"><i class="ti ti-currency-euro me-1"></i>Kaina ↑</button>
    <button class="btn btn-xs btn-outline-secondary sg-sort" data-sort="price_sqm" data-dir="asc"><i class="ti ti-square me-1"></i>€/m² ↑</button>
    <button class="btn btn-xs btn-outline-secondary sg-sort" data-sort="vs_market" data-dir="desc"><i class="ti ti-trending-down me-1"></i>Pigiausi rinkoje</button>
    <button class="btn btn-xs btn-outline-secondary sg-sort" data-sort="days_market" data-dir="asc"><i class="ti ti-clock me-1"></i>Trumpiausiai rinkoje</button>
  </div>
  <div class="sg-cards-grid" id="sg-cards-grid" style="grid-template-columns:repeat(4,1fr);gap:12px;padding:14px;"></div>
  <div class="sg-pagination" id="sg-pagination-bar">
    <div class="text-muted small"><i class="ti ti-info-circle me-1"></i>Tas pats tipas · plotas ±30%<?= $sRooms>0?' · '.$sRooms.' kamb.':'' ?><?= $sYear>0?' · '.$yearMin.'–'.$yearMax.' m.':'' ?></div>
    <div class="d-flex gap-1" id="sg-pagination-btns"></div>
  </div>
</div>
<?php endif ?>

<div class="text-center text-muted small mt-3 no-print">RaskNT · <?= fe_esc($sc['confidence_note']) ?></div>
</div></div></div>

<script src="https://cdn.jsdelivr.net/npm/@tabler/core@1.0.0-beta20/dist/js/tabler.min.js"></script>
<?php if($hasMap): ?><script src='https://api.mapbox.com/mapbox-gl-js/v2.15.0/mapbox-gl.js'></script><?php endif ?>
<script>
// ── LIGHTBOX ──────────────────────────────────────────────────────────────────
function openLightbox(src){document.getElementById('lbx-img').src=src;document.getElementById('lightbox').classList.add('open');}
function closeLightbox(){document.getElementById('lightbox').classList.remove('open');}
document.getElementById('lightbox').addEventListener('click',function(e){if(e.target===this)closeLightbox();});
document.addEventListener('keydown',function(e){if(e.key==='Escape')closeLightbox();});

// ── MOD BAR ANIMACIJA ─────────────────────────────────────────────────────────
document.addEventListener('DOMContentLoaded',function(){
  document.querySelectorAll('.mod-bar-fill').forEach(function(b,i){
    var w=b.style.width; b.style.width='0%';
    setTimeout(function(){b.style.width=w;},200+i*100);
  });
  var ni=document.getElementById('note-input'),di=document.getElementById('rem-date-input');
  if(ni){ni.addEventListener('keydown',function(e){if((e.ctrlKey||e.metaKey)&&e.key==='Enter'){e.preventDefault();saveNote();}});ni.addEventListener('input',updateCalendarLink);}
  if(di)di.addEventListener('change',updateCalendarLink);
  updateCalendarLink();
});

// ── AJAX URL ──────────────────────────────────────────────────────────────────
var AJAX_URL = '<?= $ajaxUrl ?>?id=<?= $id ?>';

// ── CART TOGGLE ───────────────────────────────────────────────────────────────
var _isSaved = <?= $isSaved?'true':'false' ?>;
function toggleSave(){
  fetch(AJAX_URL,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=cart_toggle'})
  .then(function(r){return r.json();}).then(function(d){
    _isSaved=d.saved;
    var btn=document.getElementById('save-btn'),lbl=document.getElementById('save-label'),ico=btn.querySelector('i');
    if(d.saved){btn.className='btn btn-sm btn-danger no-print';ico.className='ti ti-heart-filled me-1';lbl.textContent='Išsaugota';}
    else{btn.className='btn btn-sm btn-outline-secondary no-print';ico.className='ti ti-heart me-1';lbl.textContent='Išsaugoti';}
  });
}

// ── NOTE SAVE ─────────────────────────────────────────────────────────────────
function saveNote(){
  var noteEl=document.getElementById('note-input'),dateEl=document.getElementById('rem-date-input');
  var note=noteEl&&noteEl.value?noteEl.value.trim():'',remDate=dateEl?dateEl.value:'';
  if(!note&&!remDate){if(noteEl)noteEl.focus();return;}
  var btn=document.getElementById('note-save-btn');
  if(btn){btn.disabled=true;btn.innerHTML='<i class="ti ti-loader-2 me-1"></i>Saugoma...';}
  fetch(AJAX_URL,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=note_save&note='+encodeURIComponent(note)+'&rem_date='+encodeURIComponent(remDate)})
  .then(function(r){return r.json();}).then(function(d){
    if(btn){btn.disabled=false;btn.innerHTML='<i class="ti ti-star-filled me-1"></i>Išsaugota';btn.className='btn btn-sm btn-warning';setTimeout(function(){btn.innerHTML='<i class="ti ti-star me-1"></i>Išsaugoti';btn.className='btn btn-sm btn-primary';},2500);}
    var fb=document.getElementById('note-feedback');
    if(fb){fb.classList.remove('d-none');setTimeout(function(){fb.classList.add('d-none');},2500);}
    if(note||remDate){
      var now=new Date();
      var ts=now.getFullYear()+'-'+String(now.getMonth()+1).padStart(2,'0')+'-'+String(now.getDate()).padStart(2,'0')+' '+String(now.getHours()).padStart(2,'0')+':'+String(now.getMinutes()).padStart(2,'0');
      var entry=document.createElement('div');entry.className='py-2 border-bottom';entry.style.animation='fadeInNote .3s ease';
      entry.innerHTML=(note?'<div style="font-size:.85rem;white-space:pre-line">'+note.replace(/</g,'&lt;')+'</div>':'')+'<div class="text-muted" style="font-size:.65rem">'+ts+'</div>';
      var wrapper=document.querySelector('#comments-list .border-top');
      if(!wrapper){wrapper=document.createElement('div');wrapper.className='border-top mt-3 pt-2';document.getElementById('comments-list').appendChild(wrapper);}
      wrapper.prepend(entry);
    }
    if(noteEl)noteEl.value='';if(dateEl)dateEl.value='';updateCalendarLink();
    if(d.saved&&!_isSaved){_isSaved=true;var hBtn=document.getElementById('save-btn');if(hBtn){hBtn.className='btn btn-sm btn-danger no-print';hBtn.querySelector('i').className='ti ti-heart-filled me-1';document.getElementById('save-label').textContent='Išsaugota';}}
  });
}

// ── CALENDAR LINK ─────────────────────────────────────────────────────────────
function updateCalendarLink(){
  var note=document.getElementById('note-input')&&document.getElementById('note-input').value?document.getElementById('note-input').value.trim():'';
  var remDate=document.getElementById('rem-date-input')?document.getElementById('rem-date-input').value:'';
  var calBtn=document.getElementById('gcal-btn');if(!calBtn)return;
  if(!note&&!remDate){calBtn.classList.add('d-none');return;}calBtn.classList.remove('d-none');
  var address=<?= json_encode($e['address']??'') ?>,price=<?= json_encode(fe_fmt($mkt['actual_price']??0).' €') ?>,shareU=<?= json_encode($shareUrl) ?>;
  var title=encodeURIComponent('NT apžiūra: '+address+' · '+price);
  var details=encodeURIComponent((note||'')+(note?'\n\n':'')+'FindEstate: '+shareU);
  var loc=encodeURIComponent(address);
  var startDt,endDt;
  if(remDate){startDt=remDate.replace(/-/g,'')+'T070000Z';endDt=remDate.replace(/-/g,'')+'T080000Z';}
  else{var t=new Date();t.setDate(t.getDate()+1);t.setHours(10,0,0,0);var e2=new Date(t.getTime()+3600000);var fmt=function(d){return d.toISOString().replace(/[-:.]/g,'').slice(0,15)+'Z';};startDt=fmt(t);endDt=fmt(e2);}
  calBtn.href='https://calendar.google.com/calendar/render?action=TEMPLATE&text='+title+'&details='+details+'&location='+loc+'&dates='+startDt+'/'+endDt;
}

// ── SHARE ─────────────────────────────────────────────────────────────────────
var SHARE_URL=<?= json_encode($shareUrl??'') ?>;
function copyShareLink(){
  var toast=document.getElementById('copy-toast');
  var doCopy=function(){if(toast){toast.style.display='block';setTimeout(function(){toast.style.display='none';},2500);}};
  if(navigator.clipboard&&window.isSecureContext)navigator.clipboard.writeText(SHARE_URL).then(doCopy).catch(function(){fallbackCopy(SHARE_URL);doCopy();});
  else{fallbackCopy(SHARE_URL);doCopy();}
}
function fallbackCopy(text){var el=document.createElement('textarea');el.value=text;el.style.position='fixed';el.style.opacity='0';document.body.appendChild(el);el.focus();el.select();try{document.execCommand('copy');}catch(e){}document.body.removeChild(el);}

// ── BROKER VISIBILITY ─────────────────────────────────────────────────────────
var brokerVisible=true;
function toggleBrokerVisibility(){
  var bc=document.getElementById('broker-content'),btn=document.getElementById('broker-hide-btn');if(!bc||!btn)return;
  brokerVisible=!brokerVisible;bc.style.opacity=brokerVisible?'1':'0.3';bc.style.filter=brokerVisible?'':'blur(4px)';bc.style.userSelect=brokerVisible?'':'none';
  btn.innerHTML=brokerVisible?'<i class="ti ti-eye-off me-1"></i>Slėpti':'<i class="ti ti-eye me-1"></i>Rodyti';
  btn.className=brokerVisible?'btn btn-xs btn-outline-warning':'btn btn-xs btn-outline-success';
}

// ── ŽEMĖLAPIS (originalus) ───────────────────────────────────────────────────
var map = null;

<?php if($hasMap): ?>
mapboxgl.accessToken = 'pk.eyJ1IjoiYW5kZXhjIiwiYSI6ImNtNzNheDRxYTA4eWEya3Nmb3ZnZDl1MDkifQ.eq5ht0Dncq4HAkuRUUrUYQ';
const mainLat=<?= (float)$mapCenter['lat'] ?>,mainLng=<?= (float)$mapCenter['lng'] ?>;
const nearbyGeoJSON={type:'FeatureCollection',features:<?= json_encode($mapNearby,JSON_UNESCAPED_UNICODE) ?>};

map=new mapboxgl.Map({container:'estate-map',style:'mapbox://styles/mapbox/streets-v12',center:[mainLng,mainLat],zoom:14});
map.addControl(new mapboxgl.NavigationControl(),'top-right');
map.addControl(new mapboxgl.FullscreenControl(),'top-right');

map.on('load',()=>{
  new mapboxgl.Marker({color:'#7c3aed',scale:1.2}).setLngLat([mainLng,mainLat])
    .setPopup(new mapboxgl.Popup({offset:25}).setHTML(`<div class="map-popup"><?php if($e['image']): ?><img src="<?= fe_esc($e['image']) ?>" alt=""><?php endif ?><div class="map-popup-body"><div class="map-popup-price"><?= fe_fmt($mkt['actual_price']) ?> €</div><div class="map-popup-addr"><?= fe_esc(mb_substr($e['address'],0,40)) ?></div></div></div>`))
    .addTo(map);
  map.addSource('nearby',{type:'geojson',data:nearbyGeoJSON});
  const otypeColors={apartment:'#0054a6',house:'#2fb344',land:'#f59f00',commercial:'#9b59b6'};
  const activeColor=otypeColors['<?= fe_esc($e['otype']??'apartment') ?>']||'#0054a6';
  // Filtruojame pagrindinį objektą iš nearby — kad nesidubliuotų su markeriumi
  const mainEstateId = <?= (int)($data['estate']['id'] ?? 0) ?>;
  map.addLayer({
    id:'nearby-points', type:'circle', source:'nearby',
    filter: ['!=', ['get', 'id'], mainEstateId],
    paint:{
      'circle-radius':['case',['==',['get','type'],'sold'],6,8],
      'circle-color':['case',['==',['get','type'],'sold'],'#94a3b8',activeColor],
      'circle-stroke-width':2,
      'circle-stroke-color':'#fff',
      'circle-opacity':['case',['==',['get','type'],'sold'],0.6,0.9]
    }
  });

  // ── Popup be dublikatų ──
  // Priežastis: Mapbox šauna click du kartus kai taškai persidengia
  // Sprendimas: debounce + lastShownId patikrinimas
  let _popup = null;
  let _lastClickTime = 0;
  let _lastShownId = null;

  function showPointPopup(e) {
    e.originalEvent.stopPropagation();

    const now = Date.now();
    if (now - _lastClickTime < 400) return; // debounce
    _lastClickTime = now;

    const f = e.features[0].properties;
    const clickLng = e.features[0].geometry.coordinates[0];
    const clickLat = e.features[0].geometry.coordinates[1];

    // Ignoruojame jei tai pagrindinis objektas (koordinatės sutampa)
    const distToMain = Math.abs(clickLng - mainLng) + Math.abs(clickLat - mainLat);
    if (distToMain < 0.00005) return;

    const featureId = String(f.id || f.estate_id || '') + '_' + String(f.price || '');

    // Jei tas pats taškas — toggle (uždaryti jei jau atidarytas)
    if (_popup) { _popup.remove(); _popup = null; }
    if (_lastShownId === featureId) { _lastShownId = null; return; }
    _lastShownId = featureId;

    const coords = e.features[0].geometry.coordinates.slice();
    const imgHtml = f.image
      ? `<img src="${f.image}" alt="" style="width:100%;height:110px;object-fit:cover;" onerror="this.style.display='none'">`
      : '';
    const urlHtml = f.url
      ? `<a href="${f.url}" target="_blank" style="display:block;background:#0054a6;color:#fff;text-align:center;padding:6px;font-size:12px;font-weight:600;text-decoration:none;">Skelbimas →</a>`
      + `<a href="/?p=analysis&id=${f.id||f.estate_id||0}" style="display:block;background:#ecfdf5;color:#065f46;border-top:1px solid #6ee7b7;text-align:center;padding:5px;font-size:11px;font-weight:600;text-decoration:none;">📊 Analizė</a>`
      : '';
    const distHtml = f.distance_m > 0
      ? (f.distance_m < 1000 ? Math.round(f.distance_m) + ' m' : (f.distance_m/1000).toFixed(1) + ' km')
      : '';
    const sqmHtml = f.price_sqm
      ? ` · ${Number(f.price_sqm).toLocaleString('lt-LT')} €/m²`
      : '';
    const soldBadge = (f.type === 'sold')
      ? '<span style="display:inline-block;background:#6b7280;color:#fff;font-size:9px;padding:1px 5px;border-radius:8px;margin-left:4px;">Parduota</span>'
      : '';

    _popup = new mapboxgl.Popup({ offset: 10, closeOnClick: true })
      .setLngLat(coords)
      .setHTML(
        `<div style="min-width:205px;font-family:sans-serif;">`
        + imgHtml
        + `<div style="padding:8px 10px;">`
        +   `<div style="font-weight:700;font-size:14px;">${Number(f.price||0).toLocaleString('lt-LT')} €${soldBadge}</div>`
        +   `<div style="font-size:11px;color:#666;margin:2px 0;">${f.address||f.title||''}</div>`
        +   `<div style="font-size:11px;color:#888;">${distHtml}${sqmHtml}</div>`
        + `</div>`
        + urlHtml
        + `</div>`
      )
      .addTo(map);

    _popup.on('close', () => { _popup = null; _lastShownId = null; });
  }

  map.on('click', 'nearby-points', showPointPopup);
  map.on('mouseenter', 'nearby-points', () => { map.getCanvas().style.cursor = 'pointer'; });
  map.on('mouseleave', 'nearby-points', () => { map.getCanvas().style.cursor = ''; });
  if(nearbyGeoJSON.features.length>0){
    const b=new mapboxgl.LngLatBounds();
    b.extend([mainLng,mainLat]);
    nearbyGeoJSON.features.forEach(f=>b.extend(f.geometry.coordinates));
    map.fitBounds(b,{padding:60,maxZoom:15});
  }
});
<?php endif ?>

// ── TAIP PAT GALI DOMINTI — KORTELIŲ GRID ────────────────────────────────────
<?php if(!empty($suggestions)): ?>
(function(){
  var SG_DATA    = <?= $sgJson ?>;
  var SG_PER_PAGE = 12;
  var sgSort = {col:'score', dir:'desc'};
  var sgPage = 1;

  function sgScoreColor(s){
    if(s===null) return '#adb5bd';
    if(s>=65) return '#2fb344';
    if(s>=50) return '#0ea5e9';
    if(s>=35) return '#f59f00';
    return '#d63939';
  }

  function sgFmtPrice(n){
    if(!n) return '—';
    return Number(n).toLocaleString('lt-LT')+' €';
  }

  function sgSorted(){
    var col=sgSort.col, dir=sgSort.dir==='asc'?1:-1;
    return SG_DATA.slice().sort(function(a,b){
      var av=a[col]!=null?a[col]:(dir>0?Infinity:-Infinity);
      var bv=b[col]!=null?b[col]:(dir>0?Infinity:-Infinity);
      return(av>bv?1:av<bv?-1:0)*dir;
    });
  }

  function sgRender(){
    var sorted=sgSorted(), total=sorted.length;
    var pages=Math.max(1,Math.ceil(total/SG_PER_PAGE));
    sgPage=Math.min(sgPage,pages);
    var slice=sorted.slice((sgPage-1)*SG_PER_PAGE, sgPage*SG_PER_PAGE);
    var grid=document.getElementById('sg-cards-grid');
    if(!grid) return;

    grid.innerHTML = slice.map(function(s){
      var sc=sgScoreColor(s.score);

      var imgHtml = s.image
        ? '<img src="'+s.image+'" class="sg-card-img" alt="" loading="lazy" onerror="this.style.display=\'none\';this.nextElementSibling.style.display=\'flex\'">'
          +'<div class="sg-card-img-ph" style="display:none;"><i class="ti ti-photo-off" style="font-size:1.2rem;color:#ccc;"></i></div>'
        : '<div class="sg-card-img-ph"><i class="ti ti-photo-off" style="font-size:1.2rem;color:#ccc;"></i></div>';

      var vsBadge='';
      if(s.vs_market!==null){
        var vc=s.vs_market>=5?'#059669':s.vs_market>=0?'#0ea5e9':s.vs_market>=-5?'#f59f00':'#dc2626';
        var vb=s.vs_market>=5?'#ecfdf5':s.vs_market>=0?'#e0f2fe':s.vs_market>=-5?'#fefce8':'#fef2f2';
        var vs=s.vs_market>0?'−':'+';
        vsBadge='<span class="sg-card-vs" style="background:'+vb+';color:'+vc+';">'+vs+Math.abs(s.vs_market)+'%</span>';
      }
      var hotBadge=s.is_hot?'<span class="sg-card-hot">🔥 HOT</span>':'';
      var scoreBadge=s.score!==null?'<span class="sg-card-score" style="background:'+sc+';">'+s.score+'</span>':'';
      // Plotas + kambariai + aukštas + sklypas
      var chips = [];
      if (s.size)      chips.push('<span style="background:#f1f5f9;border-radius:4px;padding:1px 6px;font-size:11px;color:#334155;">'+s.size+'</span>');
      if (s.land_size) chips.push('<span style="background:#f0fdf4;border-radius:4px;padding:1px 6px;font-size:11px;color:#166534;">'+s.land_size+'</span>');
      if (s.rooms)     chips.push('<span style="background:#f1f5f9;border-radius:4px;padding:1px 6px;font-size:11px;color:#334155;">'+s.rooms+' k.</span>');
      if (s.floor)     chips.push('<span style="background:#f1f5f9;border-radius:4px;padding:1px 6px;font-size:11px;color:#334155;">'+s.floor+' a.</span>');
      if (s.year)      chips.push('<span style="background:#f8fafc;border-radius:4px;padding:1px 6px;font-size:11px;color:#64748b;">'+s.year+' m.</span>');
      var sizeLine = chips.join(' ');

      // Dienos rinkoje
      var daysHtml = '';
      if (s.days_market !== null && s.days_market !== undefined) {
        var dc = s.days_market > 60 ? '#92400e' : s.days_market > 30 ? '#78350f' : '#166534';
        var db = s.days_market > 60 ? '#fef3c7' : s.days_market > 30 ? '#fef9c3' : '#f0fdf4';
        daysHtml = '<span style="background:'+db+';color:'+dc+';border-radius:4px;padding:1px 6px;font-size:10px;">'+s.days_market+'d. rinkoje</span>';
      }

      var distHtml = s.dist_km !== null
        ? (s.dist_km < 1 ? Math.round(s.dist_km * 1000) + ' m' : s.dist_km.toFixed(1) + ' km')
        : '<span style="color:#94a3b8;">' + s.city + '</span>';
      var sqmHtml = s.price_sqm
        ? '<span class="sg-card-sqm">(' + Number(s.price_sqm).toLocaleString('lt-LT') + ' €/m²)</span>'
        : '';

      var extBtn = s.ext_url
        ? '<a href="' + s.ext_url + '" target="_blank" class="sg-card-btn sg-card-btn-primary" onclick="event.stopPropagation();">'
          + '<i class="ti ti-external-link" style="font-size:12px;"></i> Skelbimas</a>'
        : '';

      return '<div class="sg-card" onclick="window.location=\'' + s.url + '\'">'
        + imgHtml
        + '<div class="sg-card-body">'
          + '<div class="sg-card-addr">' + (s.address || '') + '</div>'
          + '<div class="sg-card-price">' + sgFmtPrice(s.price) + ' ' + sqmHtml + '</div>'
          + (sizeLine ? '<div style="margin-top:4px;display:flex;flex-wrap:wrap;gap:3px;">' + sizeLine + '</div>' : '')
          + '<div class="sg-card-meta" style="margin-top:3px;display:flex;flex-wrap:wrap;align-items:center;gap:5px;">'
            + (distHtml || '')
            + (daysHtml ? daysHtml : '')
          + '</div>'
          + '<div class="sg-card-badges">' + scoreBadge + vsBadge + hotBadge + '</div>'
        + '</div>'
        + '<div class="sg-card-footer">'
          + '<a href="' + s.url + '" class="sg-card-btn sg-card-btn-analysis" onclick="event.stopPropagation();">'
            + '<i class="ti ti-chart-bar" style="font-size:12px;"></i> Analizė'
          + '</a>'
          + extBtn
        + '</div>'
        + '</div>';
    }).join('');

    // Paginacija
    var btns=document.getElementById('sg-pagination-btns');
    if(btns){
      btns.innerHTML=pages<=1?'':Array.from({length:pages},function(_,i){return i+1;}).map(function(p){
        return '<button class="btn btn-xs '+(p===sgPage?'btn-primary':'btn-outline-secondary')+'" onclick="sgGoPage('+p+')">'+p+'</button>';
      }).join('');
    }
  }

  document.querySelectorAll('.sg-sort').forEach(function(btn){
    btn.addEventListener('click',function(){
      var col=this.dataset.sort, dir=this.dataset.dir;
      var icons={score:'ti-star',price:'ti-currency-euro',price_sqm:'ti-square',vs_market:'ti-trending-down',days_market:'ti-clock'};
      var labels={score:'Score',price:'Kaina',price_sqm:'€/m²',vs_market:'Pigiausi rinkoje',days_market:'Trumpiausiai rinkoje'};
      if(sgSort.col===col){
        sgSort.dir=sgSort.dir==='asc'?'desc':'asc';
        this.dataset.dir=sgSort.dir;
        this.innerHTML='<i class="ti '+icons[col]+' me-1"></i>'+labels[col]+' '+(sgSort.dir==='asc'?'↑':'↓');
      } else {
        sgSort={col:col,dir:dir};
      }
      document.querySelectorAll('.sg-sort').forEach(function(b){b.classList.remove('active','btn-primary');b.classList.add('btn-outline-secondary');});
      this.classList.add('active','btn-primary');this.classList.remove('btn-outline-secondary');
      sgPage=1; sgRender();
    });
  });

  window.sgGoPage=function(p){
    sgPage=p; sgRender();
    var card=document.getElementById('sg-card');
    if(card) card.scrollIntoView({behavior:'smooth',block:'start'});
  };

  sgRender();
})();
<?php endif ?>

// ── ADMIN JS ──────────────────────────────────────────────────────────────────
<?php if($isAdmin): ?>
var ADMIN_AJAX='<?= $ajaxUrl ?>?id=<?= $id ?>';
var SCORE_CRON_URL='<?= $scoreCronUrl ?>';

function adminFeedback(msg,color){
  color=color||'success';
  var fb=document.getElementById('admin-feedback');if(!fb)return;
  fb.style.display='';
  fb.style.color=color==='success'?'#2fb344':color==='error'?'#d63939':'#6c757d';
  fb.innerHTML=msg;
  if(color!=='loading') setTimeout(function(){fb.style.display='none';},4000);
}

function adminRescore(){
  var btn=document.getElementById('btn-rescore');
  if(!confirm('Perskorinti šį objektą?')) return;
  btn.disabled=true;btn.innerHTML='<i class="ti ti-loader-2 me-1"></i>Skoriname...';
  adminFeedback('<i class="ti ti-loader-2 me-1"></i>Skoriname...','loading');
  fetch(SCORE_CRON_URL,{mode:'no-cors'})
    .then(function(){adminFeedback('✓ Perskorintas! Perkrauname...','success');setTimeout(function(){window.location.reload();},1500);})
    .catch(function(){adminFeedback('✓ Komanda išsiųsta. Perkrauname...','success');setTimeout(function(){window.location.reload();},2000);})
    .finally(function(){btn.disabled=false;btn.innerHTML='<i class="ti ti-refresh me-1"></i>Perskorinti';});
}

function adminClearScore(){
  if(!confirm('Išvalyti scoringo duomenis?')) return;
  var btn=document.getElementById('btn-clearscore');
  btn.disabled=true;btn.innerHTML='<i class="ti ti-loader-2 me-1"></i>Valoma...';
  fetch(ADMIN_AJAX,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=clear_score'})
  .then(function(r){return r.json();}).then(function(d){
    if(d.ok){adminFeedback('✓ Skoringas išvalytas. Perkrauname...','success');setTimeout(function(){window.location.reload();},1200);}
    else adminFeedback('✗ Klaida: '+(d.error||'nežinoma'),'error');
  }).catch(function(){adminFeedback('✗ Ryšio klaida','error');})
  .finally(function(){btn.disabled=false;btn.innerHTML='<i class="ti ti-eraser me-1"></i>Valyti skoringą';});
}

var _isHidden=<?= $isHidden?'true':'false' ?>;
function adminToggleHide(){
  var newHide=_isHidden?0:1,btn=document.getElementById('btn-hide'),label=document.getElementById('btn-hide-label');
  btn.disabled=true;
  fetch(ADMIN_AJAX,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=hide_estate&hide='+newHide})
  .then(function(r){return r.json();}).then(function(d){
    if(d.ok){_isHidden=d.hidden;
      if(_isHidden){btn.className='btn btn-sm btn-danger';label.textContent='Paslėpta — spausti rodyti';adminFeedback('✓ Paslėpta','success');}
      else{btn.className='btn btn-sm btn-outline-danger';label.textContent='Slėpti';adminFeedback('✓ Vėl rodoma','success');}
    } else adminFeedback('✗ Klaida: '+(d.error||'nežinoma'),'error');
  }).catch(function(){adminFeedback('✗ Ryšio klaida','error');})
  .finally(function(){btn.disabled=false;});
}

var _coordEditMode=false;
function adminToggleCoordEdit(){
  _coordEditMode=!_coordEditMode;
  var hint=document.getElementById('coord-edit-hint'),btn=document.getElementById('btn-editcoords');
  if(hint) hint.style.display=_coordEditMode?'':'none';
  if(btn){btn.className=_coordEditMode?'btn btn-sm btn-info':'btn btn-sm btn-outline-info';btn.innerHTML=_coordEditMode?'<i class="ti ti-x me-1"></i>Atšaukti':'<i class="ti ti-map-pin me-1"></i>Keisti koordinates';}
  if(map){
    if(_coordEditMode){map.getCanvas().style.cursor='crosshair';map.once('click',adminMapClick);}
    else{map.getCanvas().style.cursor='';map.off('click',adminMapClick);}
  }
}

function adminMapClick(e){
  var lat=e.lngLat.lat.toFixed(8),lng=e.lngLat.lng.toFixed(8);
  if(!confirm('Atnaujinti koordinates?\nLat: '+lat+'\nLng: '+lng)){if(_coordEditMode)map.once('click',adminMapClick);return;}
  adminFeedback('<i class="ti ti-loader-2 me-1"></i>Saugoma...','loading');
  fetch(ADMIN_AJAX,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=update_coords&lat='+lat+'&lng='+lng})
  .then(function(r){return r.json();}).then(function(d){
    if(d.ok){adminFeedback('✓ Koordinatės atnaujintos. Perkrauname...','success');setTimeout(function(){window.location.reload();},1500);}
    else adminFeedback('✗ Klaida: '+(d.error||'nežinoma'),'error');
  }).catch(function(){adminFeedback('✗ Ryšio klaida','error');});
  _coordEditMode=false;adminToggleCoordEdit();
}

function adminSearchCoords(){
  var q=document.getElementById('coord-search-input')&&document.getElementById('coord-search-input').value?document.getElementById('coord-search-input').value.trim():'';
  if(!q) return;
  var res=document.getElementById('coord-search-result');
  if(res) res.innerHTML='<i class="ti ti-loader-2 me-1"></i>Ieškoma...';
  fetch('https://nominatim.openstreetmap.org/search?q='+encodeURIComponent(q+', Lithuania')+'&format=json&limit=3&countrycodes=lt',{headers:{'User-Agent':'FindEstate/1.0'}})
  .then(function(r){return r.json();}).then(function(results){
    if(!results||!results.length){if(res)res.innerHTML='Nerasta.';return;}
    if(res) res.innerHTML=results.slice(0,3).map(function(r){
      return '<button class="btn btn-xs btn-outline-info me-1 mt-1" onclick="adminConfirmCoords('+r.lat+','+r.lon+',\''+r.display_name.substring(0,60).replace(/'/g,"\\'")+'\')">'
        +'<i class="ti ti-map-pin me-1"></i>'+r.display_name.substring(0,60)+'</button>';
    }).join('');
  }).catch(function(){if(res)res.innerHTML='Paieškos klaida.';});
}

function adminConfirmCoords(lat,lng,name){
  if(!confirm('Nustatyti koordinates?\n'+name+'\nLat: '+lat+'\nLng: '+lng)) return;
  adminFeedback('<i class="ti ti-loader-2 me-1"></i>Saugoma...','loading');
  fetch(ADMIN_AJAX,{method:'POST',headers:{'Content-Type':'application/x-www-form-urlencoded'},body:'action=update_coords&lat='+lat+'&lng='+lng})
  .then(function(r){return r.json();}).then(function(d){
    if(d.ok){adminFeedback('✓ Koordinatės išsaugotos. Perkrauname...','success');setTimeout(function(){window.location.reload();},1500);}
    else adminFeedback('✗ Klaida: '+(d.error||'nežinoma'),'error');
  }).catch(function(){adminFeedback('✗ Ryšio klaida','error');});
}
<?php endif ?>
</script>
</body>
</html>