<?php
include 'protect.php';
include 'db.php';
require_once __DIR__ . '/database_backup_helpers.php';

if ($_SERVER['REQUEST_METHOD'] !== 'POST') {
    header('Location: export_form.php');
    exit;
}

$redirect = 'export_form.php';

try {
    $confirmText = strtoupper(trim((string) ($_POST['confirm_restore_text'] ?? '')));
    if ($confirmText !== 'RESTORE') {
        throw new RuntimeException('Type RESTORE to confirm that you want to overwrite this store database.');
    }

    $upload = appRestoreSqlFromUpload($_FILES['restore_backup_file'] ?? []);
    restoreCurrentAppDatabase($conn, (string) ($upload['sql'] ?? ''));

    $_SESSION['export_backup_flash'] = [
        'type' => 'ok',
        'message' => 'Database restored successfully from ' . (string) ($upload['original_name'] ?? 'backup file') . '.',
    ];
} catch (Throwable $e) {
    $_SESSION['export_backup_flash'] = [
        'type' => 'err',
        'message' => $e->getMessage(),
    ];
}

header('Location: ' . $redirect);
exit;