<?php
/**
 * 后台 · 数据库备份与恢复
 */
$admin = current_user();
$backupDir = APP_ROOT . '/data/backups';
if (!is_dir($backupDir)) { @mkdir($backupDir, 0775, true); }
@chmod($backupDir, 0775);

$download = trim((string) input('download', ''));
if ($download !== '' && preg_match('/^backup_[0-9A-Za-z_\.-]+$/u', $download)) {
    $file = $backupDir . '/' . $download;
    if (is_file($file)) {
        audit_log('backup_download', $download);
        header('Content-Type: application/octet-stream');
        header('Content-Disposition: attachment; filename="' . basename($file) . '"');
        header('Content-Length: ' . filesize($file));
        readfile($file);
        exit;
    }
}

if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    check_csrf();
    $act = input('act');
    if ($act === 'create') {
        $name = 'backup_' . date('Ymd_His') . (DB::$driver === 'sqlite' ? '.sqlite' : '.sql');
        $file = $backupDir . '/' . $name;
        try {
            if (DB::$driver === 'sqlite') {
                $sqlitePath = $CONFIG['sqlite_path'] ?? (APP_ROOT . '/data/komorebi.sqlite');
                try {
                    DB::run('VACUUM INTO ?', [$file]);
                } catch (Exception $e) {
                    if (!@copy($sqlitePath, $file)) { throw new Exception('数据库文件复制失败'); }
                }
            } else {
                $sql = "-- 木漏茶室数据库备份 " . now() . "\nSET NAMES utf8mb4;\n";
                $tables = DB::$pdo->query('SHOW TABLES')->fetchAll(PDO::FETCH_COLUMN);
                foreach ($tables as $table) {
                    $create = DB::one('SHOW CREATE TABLE `' . $table . '`');
                    $sql .= "\nDROP TABLE IF EXISTS `" . $table . "`;\n" . ($create['Create Table'] ?? '') . ";\n";
                    $rows = DB::all('SELECT * FROM `' . $table . '` LIMIT 5000');
                    foreach ($rows as $row) {
                        $vals = [];
                        foreach ($row as $v) { $vals[] = $v === null ? 'NULL' : DB::$pdo->quote((string) $v); }
                        $sql .= 'INSERT INTO `' . $table . '` VALUES (' . implode(',', $vals) . ");\n";
                    }
                }
                if (@file_put_contents($file, $sql) === false) { throw new Exception('备份文件写入失败'); }
            }
            @chmod($file, 0600);
            audit_log('backup_create', $name);
            flash('备份已创建：' . $name);
        } catch (Exception $e) {
            flash('备份失败：' . $e->getMessage(), 'err');
        }
    } elseif ($act === 'delete') {
        $name = (string) input('name', '');
        $file = $backupDir . '/' . basename($name);
        if (is_file($file)) {
            @unlink($file);
            audit_log('backup_delete', basename($name));
            flash('备份已删除');
        }
    } elseif ($act === 'restore') {
        $name = (string) input('name', '');
        $file = $backupDir . '/' . basename($name);
        if (!is_file($file)) {
            flash('备份文件不存在', 'err');
        } else {
            try {
                if (DB::$driver === 'sqlite') {
                    if (substr($name, -7) !== '.sqlite') { throw new Exception('SQLite 站点只能恢复 .sqlite 备份'); }
                    $sqlitePath = $CONFIG['sqlite_path'] ?? (APP_ROOT . '/data/komorebi.sqlite');
                    @copy($sqlitePath, $sqlitePath . '.before-restore-' . date('YmdHis'));
                    if (!@copy($file, $sqlitePath)) { throw new Exception('恢复失败，请检查数据库文件权限'); }
                } else {
                    if (substr($name, -4) !== '.sql') { throw new Exception('MySQL 站点只能恢复 .sql 备份'); }
                    DB::$pdo->exec((string) file_get_contents($file));
                }
                audit_log('backup_restore', $name);
                flash('数据库已恢复，请立即刷新并检查内容');
            } catch (Exception $e) {
                flash('恢复失败：' . $e->getMessage(), 'err');
            }
        }
    }
    redirect(admin_url('backup'));
}

$files = glob($backupDir . '/*') ?: [];
usort($files, function ($a, $b) { return filemtime($b) <=> filemtime($a); });
?>
<section class="panel">
  <h2 class="section-title">数据库备份与恢复</h2>
  <p class="muted">备份文件保存在 <code>data/backups/</code>，仅管理员可下载。恢复会覆盖当前数据库，请先创建一份新备份。</p>
  <form method="post" class="form-card">
    <?= csrf_field() ?>
    <input type="hidden" name="act" value="create">
    <button class="btn-primary" type="submit">立即创建备份</button>
  </form>
</section>

<section class="panel">
  <h2 class="section-title">已有备份</h2>
  <?php if (!$files): ?>
    <?php empty_state('还没有备份', '建议每周至少备份一次'); ?>
  <?php else: ?>
    <div class="backup-list">
      <?php foreach ($files as $f): $name = basename($f); ?>
        <div class="backup-row">
          <div class="backup-main">
            <strong><?= e($name) ?></strong>
            <span><?= format_size((int) filesize($f)) ?> · <?= date('Y-m-d H:i:s', filemtime($f)) ?></span>
          </div>
          <div class="backup-ops">
            <a class="btn-mini" href="<?= e(admin_url('backup', ['download' => $name])) ?>">下载</a>
            <form method="post" class="inline-form" data-confirm="用这份备份覆盖当前数据库？此操作不可撤销。">
              <?= csrf_field() ?><input type="hidden" name="act" value="restore"><input type="hidden" name="name" value="<?= e($name) ?>">
              <button class="btn-mini danger" type="submit">恢复</button>
            </form>
            <form method="post" class="inline-form" data-confirm="删除这份备份？">
              <?= csrf_field() ?><input type="hidden" name="act" value="delete"><input type="hidden" name="name" value="<?= e($name) ?>">
              <button class="btn-mini ghost" type="submit">删除</button>
            </form>
          </div>
        </div>
      <?php endforeach; ?>
    </div>
  <?php endif; ?>
</section>
