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

try {
    $pdo = db();
    $pdo->beginTransaction();

    echo "Cleaning up demo data...\n";

    // 1. Delete Order Items (Child of Orders)
    $pdo->exec("DELETE FROM order_items");
    echo "- Deleted order items.\n";

    // 2. Delete Orders (Child of Outlets, Users, Tables)
    $pdo->exec("DELETE FROM orders");
    echo "- Deleted orders.\n";

    // 3. Delete Tables (Child of Areas)
    $pdo->exec("DELETE FROM tables");
    echo "- Deleted tables.\n";

    // 4. Delete Areas (Child of Outlets)
    $pdo->exec("DELETE FROM areas");
    echo "- Deleted areas.\n";

    // 5. Delete Outlets
    $pdo->exec("DELETE FROM outlets");
    echo "- Deleted outlets.\n";

    // Optional: Reset auto-increment (MySQL specific)
    $pdo->exec("ALTER TABLE outlets AUTO_INCREMENT = 1");
    $pdo->exec("ALTER TABLE orders AUTO_INCREMENT = 1");

    $pdo->commit();
    echo "✅ Demo data cleared successfully.\n";

} catch (Exception $e) {
    $pdo->rollBack();
    echo "❌ Error clearing data: " . $e->getMessage() . "\n";
}