<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

// ── Konfiguration aus config.ini ────────────────────────────────────────────
$config = parse_ini_file(__DIR__ . '/config.ini', true);
if ($config === false) {
    die('config.ini nicht gefunden oder nicht lesbar (' . __DIR__ . '/config.ini)');
}

define('DB_PATH',      $config['database']['path']);
define('DISPLAY_IP',   $config['modbus']['ip'] ?? '?');
define('REFRESH',      60);
define('PER_PAGE',     100);

$row        = [];
$history    = [];
$db_error   = null;
$total_rows = 0;
$page       = max(1, (int)($_GET['page'] ?? 1));

if (!extension_loaded('pdo_sqlite') && !extension_loaded('sqlite3')) {
    $db_error = 'Weder pdo_sqlite noch sqlite3 PHP-Extension ist aktiviert. '
              . 'Bitte in php.ini "extension=pdo_sqlite" oder "extension=sqlite3" aktivieren. '
              . 'Geladene Extensions: ' . implode(', ', get_loaded_extensions());
} else {
    try {
        if (!file_exists(DB_PATH)) throw new Exception('Datenbank nicht gefunden — Collector noch nicht gelaufen? (' . DB_PATH . ')');

        $offset = ($page - 1) * PER_PAGE;
        $hist_sql = 'SELECT ts, battery_soc_pct, inverter_state, battery_voltage_v,
                        internal_temp_c, mos1_temp_c, mos2_temp_c, max_cell_temp_c, min_cell_temp_c,
                        cell1_v, cell2_v, cell3_v, cell4_v, cell5_v, cell6_v, cell7_v,
                        cell8_v, cell9_v, cell10_v, cell11_v, cell12_v, cell13_v
                 FROM readings ORDER BY id DESC LIMIT ' . PER_PAGE . ' OFFSET ' . $offset;

        if (extension_loaded('pdo_sqlite')) {
            $pdo = new PDO('sqlite:' . DB_PATH, null, null, [
                PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
                PDO::ATTR_TIMEOUT            => 2,
            ]);
            $row        = $pdo->query('SELECT * FROM readings ORDER BY id DESC LIMIT 1')
                              ->fetch(PDO::FETCH_ASSOC) ?: [];
            $total_rows = (int)$pdo->query('SELECT COUNT(*) FROM readings')->fetchColumn();
            $history    = $pdo->query($hist_sql)->fetchAll(PDO::FETCH_ASSOC);
        } else {
            // Fallback: SQLite3-Klasse
            $db = new SQLite3(DB_PATH, SQLITE3_OPEN_READONLY);
            $db->busyTimeout(2000);
            $row        = $db->querySingle('SELECT * FROM readings ORDER BY id DESC LIMIT 1', true) ?: [];
            $total_rows = (int)$db->querySingle('SELECT COUNT(*) FROM readings');
            $res        = $db->query($hist_sql);
            while ($r = $res->fetchArray(SQLITE3_ASSOC)) $history[] = $r;
            $db->close();
        }
    } catch (Exception $e) {
        $db_error = $e->getMessage();
    }
}

$ts  = $row['ts'] ?? null;
$age = $ts ? (time() - strtotime($ts)) : null;

function age_str($s) {
    if ($s === null) return '—';
    if ($s < 60)    return "vor {$s} s";
    if ($s < 3600)  return 'vor ' . floor($s/60) . ' min';
    return 'vor ' . floor($s/3600) . ' h';
}

// ── Hilfsfunktionen ────────────────────────────────────────────────────────

function fv($v, int $d = 1, string $u = ''): string {
    if ($v === null || $v === '') return '<span class="na">—</span>';
    $s = number_format((float)$v, $d, ',', '');
    return $u ? htmlspecialchars("$s $u") : htmlspecialchars($s);
}

function fi($v, string $u = ''): string {
    return fv($v, 0, $u);
}

function st($v, array $map): string {
    if ($v === null) return '<span class="na">—</span>';
    return htmlspecialchars($map[(int)$v] ?? (string)(int)$v);
}

function cc($v): string {
    if ($v === null) return '';
    return (float)$v > 0 ? ' pos' : ((float)$v < 0 ? ' neg' : ' neu');
}

function soc_html($pct): string {
    if ($pct === null) return '<span class="na">—</span>';
    $p   = min(100, max(0, (float)$pct));
    $col = $p >= 80 ? '#3fb950' : ($p >= 20 ? '#d29922' : '#f85149');
    $pf  = round($p);
    return '<span class="soc-wrap">'
         . '<span class="soc-bar-bg"><span class="soc-bar-fill" '
         . 'style="width:' . $pf . '%;background:' . $col . '"></span></span>'
         . $pf . ' %'
         . '</span>';
}

function inv_state($v): string {
    static $map = [0=>'Sleep',1=>'Standby',2=>'Laden',3=>'Entladen',4=>'Backup',5=>'OTA',6=>'Bypass'];
    if ($v === null) return '<span class="na">—</span>';
    $lbl = $map[(int)$v] ?? (string)(int)$v;
    $cls = match((int)$v) {
        2      => 'state-charge',
        3      => 'state-discharge',
        default=> 'state-other',
    };
    return '<span class="' . $cls . '">' . htmlspecialchars($lbl) . '</span>';
}

$R          = $row;
$total_pages = max(1, (int)ceil($total_rows / PER_PAGE));
$page        = min($page, $total_pages);

function pagination_html(int $cur, int $total, int $per): string {
    if ($total <= 1) return '';
    $offset_start = ($cur - 1) * $per + 1;
    $offset_end   = min($cur * $per, ($total - 1) * $per + /* actual */ $per);
    $html = '<div class="pagination">';
    // Prev
    if ($cur > 1) $html .= '<a href="?page=' . ($cur-1) . '">&#8249; Zurück</a>';
    else          $html .= '<span style="opacity:.35">&#8249; Zurück</span>';
    // Page window: always show first, last, current ±2, fill with dots
    $pages = [];
    for ($p = 1; $p <= $total; $p++) {
        if ($p === 1 || $p === $total || abs($p - $cur) <= 2) $pages[] = $p;
    }
    $prev = null;
    foreach ($pages as $p) {
        if ($prev !== null && $p - $prev > 1) $html .= '<span class="dots">…</span>';
        if ($p === $cur) $html .= '<span class="cur">' . $p . '</span>';
        else             $html .= '<a href="?page=' . $p . '">' . $p . '</a>';
        $prev = $p;
    }
    // Next
    if ($cur < $total) $html .= '<a href="?page=' . ($cur+1) . '">Weiter &#8250;</a>';
    else               $html .= '<span style="opacity:.35">Weiter &#8250;</span>';
    $html .= '<span class="info">Seite ' . $cur . ' / ' . $total . '</span>';
    $html .= '</div>';
    return $html;
}
?>
<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta http-equiv="refresh" content="<?= REFRESH ?>;url=?page=<?= $page ?>">
<title>Marstek Venus</title>
<style>
*, *::before, *::after { box-sizing: border-box; margin: 0; padding: 0; }

:root {
  --bg:       #0d1117;
  --surface:  #161b22;
  --surface2: #1c2128;
  --border:   #30363d;
  --text:     #e6edf3;
  --muted:    #8b949e;
  --dim:      #484f58;
  --green:    #3fb950;
  --red:      #f85149;
  --yellow:   #d29922;
  --accent:   #58a6ff;
}

body {
  background: var(--bg);
  color: var(--text);
  font-family: 'Segoe UI', system-ui, -apple-system, sans-serif;
  font-size: 14px;
  min-height: 100vh;
}

/* ── Header ── */
header {
  background: var(--surface);
  border-bottom: 1px solid var(--border);
  padding: 10px 20px;
  display: flex;
  align-items: center;
  gap: 14px;
  position: sticky;
  top: 0;
  z-index: 100;
  flex-wrap: wrap;
}

header h1 { font-size: 15px; font-weight: 600; color: var(--accent); }
.hdr-ip    { color: var(--muted); font-size: 12px; font-family: monospace; }
.hdr-ts    { color: var(--muted); font-size: 12px; }
.hdr-age   { font-size: 12px; color: var(--dim); }
.hdr-next  { margin-left: auto; font-size: 11px; color: var(--dim); }

/* ── Refresh-Balken ── */
#progress-wrap { height: 2px; background: var(--border); }
#progress-bar  {
  height: 100%;
  background: var(--accent);
  transition: width 1s linear;
}

/* ── Grid ── */
.main {
  padding: 16px 20px;
  display: grid;
  grid-template-columns: repeat(auto-fill, minmax(430px, 1fr));
  gap: 14px;
}

/* ── Karten ── */
.card { background: var(--surface); border: 1px solid var(--border); border-radius: 8px; overflow: hidden; }

.card-header {
  padding: 8px 14px;
  background: var(--surface2);
  border-bottom: 1px solid var(--border);
  font-size: 11px;
  font-weight: 600;
  letter-spacing: .6px;
  text-transform: uppercase;
  color: var(--muted);
}

/* ── Tabelle ── */
table { width: 100%; border-collapse: collapse; }
tr    { border-bottom: 1px solid var(--border); }
tr:last-child { border-bottom: none; }
td { padding: 6px 14px; vertical-align: middle; white-space: nowrap; }

td.label  { color: var(--muted); }
td.value  { font-family: 'Consolas', 'SF Mono', monospace; font-size: 15px; font-weight: 600; }
td.unit   { color: var(--dim); font-size: 11px; }

/* Farben */
.na  { color: var(--dim); }
.pos { color: var(--green); }
.neg { color: var(--red); }
.neu { color: var(--muted); }

.state-charge    { color: var(--green); font-weight: 600; }
.state-discharge { color: var(--red);   font-weight: 600; }
.state-other     { color: var(--muted); }

/* SOC */
.soc-wrap    { display: inline-flex; align-items: center; gap: 6px; }
.soc-bar-bg  { display: inline-block; width: 52px; height: 7px; background: var(--border); border-radius: 4px; overflow: hidden; }
.soc-bar-fill{ height: 100%; border-radius: 4px; }

/* Zellspannungen Grid */
.cell-grid {
  display: grid;
  grid-template-columns: repeat(4, 1fr);
  gap: 6px;
  padding: 10px 14px;
}
.cell-item {
  background: var(--surface2);
  border: 1px solid var(--border);
  border-radius: 5px;
  padding: 6px 8px;
  text-align: center;
}
.cell-label { font-size: 10px; color: var(--dim); }
.cell-value { font-size: 14px; font-weight: 600; font-family: monospace; color: var(--text); }

/* Fehler-Banner */
.error-banner {
  margin: 20px;
  padding: 14px 18px;
  background: #2d1515;
  border: 1px solid var(--red);
  border-radius: 8px;
  color: var(--red);
}

/* ── History-Tabelle ── */
.history-card {
  grid-column: 1 / -1;
}
.history-table td, .history-table th {
  padding: 5px 12px;
  text-align: right;
  font-size: 12px;
  font-family: monospace;
}
.history-table th {
  text-align: right;
  color: var(--muted);
  font-weight: 400;
  font-size: 11px;
  border-bottom: 1px solid var(--border);
}
.history-table td:first-child,
.history-table th:first-child { text-align: left; }
.history-table tr:hover td { background: var(--surface2); }

footer {
  text-align: center;
  padding: 14px;
  color: var(--dim);
  font-size: 11px;
  border-top: 1px solid var(--border);
  margin-top: 4px;
}

/* ── Pagination ── */
.pagination {
  display: flex;
  align-items: center;
  gap: 4px;
  padding: 10px 14px;
  flex-wrap: wrap;
  border-top: 1px solid var(--border);
}
.pagination a, .pagination span {
  display: inline-flex;
  align-items: center;
  justify-content: center;
  min-width: 32px;
  height: 28px;
  padding: 0 8px;
  border-radius: 5px;
  font-size: 12px;
  font-family: monospace;
  text-decoration: none;
  border: 1px solid var(--border);
  background: var(--surface2);
  color: var(--text);
  white-space: nowrap;
}
.pagination a:hover { background: var(--border); color: var(--accent); }
.pagination .cur    { background: var(--accent); color: #0d1117; border-color: var(--accent); font-weight: 700; }
.pagination .dots   { border: none; background: none; color: var(--dim); }
.pagination .info   { margin-left: auto; border: none; background: none; color: var(--muted); font-family: sans-serif; font-size: 11px; }
</style>
</head>
<body>

<header>
  <h1>Marstek Venus</h1>
  <span class="hdr-ip"><?= htmlspecialchars(DISPLAY_IP) ?></span>
  <?php if ($ts): ?>
    <span class="hdr-ts"><?= htmlspecialchars($ts) ?></span>
    <span class="hdr-age">(<?= age_str($age) ?>)</span>
  <?php endif; ?>
  <span class="hdr-next">Refresh in <span id="countdown"><?= REFRESH ?></span> s</span>
</header>
<div id="progress-wrap"><div id="progress-bar" style="width:100%"></div></div>

<?php if ($db_error): ?>
<div class="error-banner"><?= htmlspecialchars($db_error) ?></div>
<?php else: ?>

<div class="main">

  <!-- Live / Echtzeit -->
  <div class="card">
    <div class="card-header">Live / Echtzeit</div>
    <table><tbody>
      <tr><td class="label">Akku Leistung</td>
          <td class="value<?= cc($R['battery_power_w'] ?? null) ?>"><?= fi($R['battery_power_w'] ?? null, 'W') ?></td></tr>
      <tr><td class="label">AC Leistung</td>
          <td class="value<?= cc($R['ac_power_w'] ?? null) ?>"><?= fi($R['ac_power_w'] ?? null, 'W') ?></td></tr>
      <tr><td class="label">Akku Spannung</td>
          <td class="value"><?= fv($R['battery_voltage_v'] ?? null, 2, 'V') ?></td></tr>
      <tr><td class="label">Akku Strom</td>
          <td class="value<?= cc($R['battery_current_a'] ?? null) ?>"><?= fv($R['battery_current_a'] ?? null, 1, 'A') ?></td></tr>
      <tr><td class="label">Ladezustand (SOC)</td>
          <td class="value"><?= soc_html($R['battery_soc_pct'] ?? null) ?></td></tr>
      <tr><td class="label">Kapazität</td>
          <td class="value"><?= fv($R['battery_capacity_kwh'] ?? null, 3, 'kWh') ?></td></tr>
      <tr><td class="label">Inverter Status</td>
          <td class="value"><?= inv_state($R['inverter_state'] ?? null) ?></td></tr>
    </tbody></table>
  </div>

  <!-- Netz / AC -->
  <div class="card">
    <div class="card-header">Netz / AC</div>
    <table><tbody>
      <tr><td class="label">AC Spannung</td>
          <td class="value"><?= fv($R['ac_voltage_v'] ?? null, 1, 'V') ?></td></tr>
      <tr><td class="label">AC Strom</td>
          <td class="value<?= cc($R['ac_current_a'] ?? null) ?>"><?= fv($R['ac_current_a'] ?? null, 2, 'A') ?></td></tr>
      <tr><td class="label">AC Frequenz</td>
          <td class="value"><?= fv($R['ac_frequency_hz'] ?? null, 2, 'Hz') ?></td></tr>
    </tbody></table>
  </div>

  <!-- Temperatur & Zellwerte -->
  <div class="card">
    <div class="card-header">Temperatur &amp; Zellwerte</div>
    <table><tbody>
      <tr><td class="label">Innentemperatur</td>
          <td class="value"><?= fv($R['internal_temp_c'] ?? null, 1, '°C') ?></td></tr>
      <tr><td class="label">MOS1 Temperatur</td>
          <td class="value"><?= fv($R['mos1_temp_c'] ?? null, 1, '°C') ?></td></tr>
      <tr><td class="label">MOS2 Temperatur</td>
          <td class="value"><?= fv($R['mos2_temp_c'] ?? null, 1, '°C') ?></td></tr>
      <tr><td class="label">Max. Zelltemperatur</td>
          <td class="value"><?= fv($R['max_cell_temp_c'] ?? null, 1, '°C') ?></td></tr>
      <tr><td class="label">Min. Zelltemperatur</td>
          <td class="value"><?= fv($R['min_cell_temp_c'] ?? null, 1, '°C') ?></td></tr>
      <tr><td class="label">Max. Zellspannung</td>
          <td class="value"><?= fv($R['max_cell_voltage_v'] ?? null, 3, 'V') ?></td></tr>
      <tr><td class="label">Min. Zellspannung</td>
          <td class="value"><?= fv($R['min_cell_voltage_v'] ?? null, 3, 'V') ?></td></tr>
    </tbody></table>
  </div>

  <!-- Energie-Zähler -->
  <div class="card">
    <div class="card-header">Energie-Zähler</div>
    <table><tbody>
      <tr><td class="label">Gesamt Laden</td>
          <td class="value pos"><?= fv($R['total_charge_kwh'] ?? null, 1, 'kWh') ?></td></tr>
      <tr><td class="label">Gesamt Entladen</td>
          <td class="value neg"><?= fv($R['total_discharge_kwh'] ?? null, 1, 'kWh') ?></td></tr>
      <tr><td class="label">Heute Laden</td>
          <td class="value pos"><?= fv($R['daily_charge_kwh'] ?? null, 2, 'kWh') ?></td></tr>
      <tr><td class="label">Heute Entladen</td>
          <td class="value neg"><?= fv($R['daily_discharge_kwh'] ?? null, 2, 'kWh') ?></td></tr>
      <tr><td class="label">Monat Laden</td>
          <td class="value pos"><?= fv($R['monthly_charge_kwh'] ?? null, 1, 'kWh') ?></td></tr>
      <tr><td class="label">Monat Entladen</td>
          <td class="value neg"><?= fv($R['monthly_discharge_kwh'] ?? null, 1, 'kWh') ?></td></tr>
      <tr><td class="label">Ladezyklen</td>
          <td class="value"><?= fi($R['cycle_count'] ?? null) ?></td></tr>
    </tbody></table>
  </div>

  <!-- Zellspannungen Modul 1 -->
  <div class="card">
    <div class="card-header">Zellspannungen — Modul 1</div>
    <div class="cell-grid">
      <?php for ($i = 1; $i <= 13; $i++):
        $v = $R["cell{$i}_v"] ?? null;
        $disp = $v !== null ? number_format((float)$v, 3, ',', '') . ' V' : '—';
      ?>
      <div class="cell-item">
        <div class="cell-label">Z<?= $i ?></div>
        <div class="cell-value"><?= htmlspecialchars($disp) ?></div>
      </div>
      <?php endfor; ?>
    </div>
  </div>

  <!-- MPPT Solar -->
  <div class="card">
    <div class="card-header">MPPT / Solar</div>
    <table><tbody>
      <?php foreach ([1,2,3,4] as $n): ?>
      <tr><td class="label">MPPT<?= $n ?> Spannung</td>
          <td class="value"><?= fv($R["mppt{$n}_voltage_v"] ?? null, 1, 'V') ?></td></tr>
      <tr><td class="label">MPPT<?= $n ?> Strom</td>
          <td class="value"><?= fv($R["mppt{$n}_current_a"] ?? null, 1, 'A') ?></td></tr>
      <tr><td class="label">MPPT<?= $n ?> Leistung</td>
          <td class="value pos"><?= fv($R["mppt{$n}_power_w"] ?? null, 0, 'W') ?></td></tr>
      <?php endforeach; ?>
    </tbody></table>
  </div>

  <!-- Diagnose -->
  <div class="card">
    <div class="card-header">Diagnose / Firmware</div>
    <table><tbody>
      <tr><td class="label">WiFi Signal</td>
          <td class="value"><?= fi($R['wifi_signal_dbm'] ?? null, 'dBm') ?></td></tr>
    </tbody></table>
  </div>

  <!-- Konfiguration -->
  <div class="card">
    <div class="card-header">Konfiguration</div>
    <table><tbody>
      <tr><td class="label">Arbeitsmodus</td>
          <td class="value"><?= st($R['work_mode'] ?? null, [0=>'Manuell',1=>'Anti-Einspeisung',2=>'Handelsmodus']) ?></td></tr>
      <tr><td class="label">Erzwungener Modus</td>
          <td class="value"><?= st($R['force_mode'] ?? null, [0=>'Standby',1=>'Laden',2=>'Entladen']) ?></td></tr>
      <tr><td class="label">Max. Ladeleistung</td>
          <td class="value"><?= fi($R['max_charge_w'] ?? null, 'W') ?></td></tr>
      <tr><td class="label">Max. Entladeleistung</td>
          <td class="value"><?= fi($R['max_discharge_w'] ?? null, 'W') ?></td></tr>
    </tbody></table>
  </div>

  <!-- Verlauf -->
  <?php if ($history): ?>
  <div class="card history-card">
    <div class="card-header">
      Letzte Messungen
      <?php if ($total_rows): ?>
        <span style="font-weight:400;color:var(--dim);margin-left:8px"><?= number_format($total_rows, 0, ',', '.') ?> Einträge gesamt</span>
      <?php endif; ?>
    </div>
    <?= pagination_html($page, $total_pages, PER_PAGE) ?>
    <table class="history-table"><thead>
      <tr>
        <th>Zeitstempel</th>
        <th>SOC</th>
        <th>Status</th>
        <th>Innen °C</th>
        <th>MOS1 °C</th>
        <th>MOS2 °C</th>
        <th>Max Z. °C</th>
        <th>Min Z. °C</th>
        <th>Spannung V</th>
        <?php for ($i=1;$i<=13;$i++): ?><th>Z<?=$i?> V</th><?php endfor; ?>
      </tr>
    </thead><tbody>
      <?php
      $inv_map = [0=>'Sleep',1=>'Standby',2=>'Laden',3=>'Entladen',4=>'Backup',5=>'OTA',6=>'Bypass'];
      foreach ($history as $h): ?>
      <tr>
        <td><?= htmlspecialchars(substr($h['ts'], 0, 19)) ?></td>
        <td><?= $h['battery_soc_pct'] !== null ? number_format($h['battery_soc_pct'],0,',','').' %' : '—' ?></td>
        <td><?= $h['inverter_state'] !== null ? htmlspecialchars($inv_map[(int)$h['inverter_state']] ?? (string)$h['inverter_state']) : '—' ?></td>
        <td><?= $h['internal_temp_c']    !== null ? number_format($h['internal_temp_c'],1,',','')    : '—' ?></td>
        <td><?= $h['mos1_temp_c']        !== null ? number_format($h['mos1_temp_c'],1,',','')        : '—' ?></td>
        <td><?= $h['mos2_temp_c']        !== null ? number_format($h['mos2_temp_c'],1,',','')        : '—' ?></td>
        <td><?= $h['max_cell_temp_c']    !== null ? number_format($h['max_cell_temp_c'],1,',','')    : '—' ?></td>
        <td><?= $h['min_cell_temp_c']    !== null ? number_format($h['min_cell_temp_c'],1,',','')    : '—' ?></td>
        <td><?= $h['battery_voltage_v'] !== null ? number_format($h['battery_voltage_v'],2,',','') : '—' ?></td>
        <?php for ($i=1;$i<=13;$i++): ?>
        <td><?= $h["cell{$i}_v"] !== null ? number_format($h["cell{$i}_v"],3,',','') : '—' ?></td>
        <?php endfor; ?>
      </tr>
      <?php endforeach; ?>
    </tbody></table>
    <?= pagination_html($page, $total_pages, PER_PAGE) ?>
  </div>
  <?php endif; ?>

</div><!-- .main -->
<?php endif; ?>

<footer>Marstek Venus — Daten aus SQLite · Aktualisierung alle <?= REFRESH ?> s</footer>

<script>
// Countdown-Timer
let secs = <?= REFRESH ?>;
const el  = document.getElementById('countdown');
const bar = document.getElementById('progress-bar');
bar.style.width = '0%';

setInterval(() => {
  secs--;
  if (secs < 0) secs = 0;
  if (el)  el.textContent = secs;
  if (bar) bar.style.width = (((<?= REFRESH ?> - secs) / <?= REFRESH ?>) * 100) + '%';
}, 1000);
</script>
</body>
</html>
