<?php
/**
 * 简单开启订单管理模块的脚本
 * 直接操作数据库来开启会员中心和商城中心
 */

// 数据库配置
$db_config = [
    'host' => '127.0.0.1',
    'dbname' => '2024_11_11_01',
    'username' => 'travel_user',
    'password' => '9b0e4191aa1faf39',
    'charset' => 'utf8'
];

echo "开始配置订单管理模块...\n";

try {
    // 创建数据库连接
    $pdo = new PDO(
        "mysql:host={$db_config['host']};dbname={$db_config['dbname']};charset={$db_config['charset']}",
        $db_config['username'],
        $db_config['password'],
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
    
    echo "✓ 数据库连接成功\n";

    // 1. 开启会员中心开关 (web_users_switch)
    echo "1. 开启会员中心开关...\n";
    $stmt = $pdo->prepare("SELECT * FROM ey_config WHERE name = 'web_users_switch' AND inc_type = 'web'");
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        // 更新现有记录
        $stmt = $pdo->prepare("UPDATE ey_config SET value = '1' WHERE name = 'web_users_switch' AND inc_type = 'web'");
        $stmt->execute();
        echo "   ✓ 会员中心开关已更新为开启状态\n";
    } else {
        // 插入新记录
        $stmt = $pdo->prepare("INSERT INTO ey_config (name, value, inc_type, lang) VALUES ('web_users_switch', '1', 'web', 'cn')");
        $stmt->execute();
        echo "   ✓ 会员中心开关已创建并开启\n";
    }

    // 2. 开启商城中心 (shop_open)
    echo "2. 开启商城中心...\n";
    $stmt = $pdo->prepare("SELECT * FROM ey_users_config WHERE name = 'shop_open' AND inc_type = 'shop'");
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        // 更新现有记录
        $stmt = $pdo->prepare("UPDATE ey_users_config SET value = '1' WHERE name = 'shop_open' AND inc_type = 'shop'");
        $stmt->execute();
        echo "   ✓ 商城中心已更新为开启状态\n";
    } else {
        // 插入新记录
        $stmt = $pdo->prepare("INSERT INTO ey_users_config (name, value, inc_type, lang) VALUES ('shop_open', '1', 'shop', 'cn')");
        $stmt->execute();
        echo "   ✓ 商城中心已创建并开启\n";
    }

    // 3. 开启支付功能 (pay_open)
    echo "3. 开启支付功能...\n";
    $stmt = $pdo->prepare("SELECT * FROM ey_users_config WHERE name = 'pay_open' AND inc_type = 'pay'");
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        // 更新现有记录
        $stmt = $pdo->prepare("UPDATE ey_users_config SET value = '1' WHERE name = 'pay_open' AND inc_type = 'pay'");
        $stmt->execute();
        echo "   ✓ 支付功能已更新为开启状态\n";
    } else {
        // 插入新记录
        $stmt = $pdo->prepare("INSERT INTO ey_users_config (name, value, inc_type, lang) VALUES ('pay_open', '1', 'pay', 'cn')");
        $stmt->execute();
        echo "   ✓ 支付功能已创建并开启\n";
    }

    // 4. 开启会员投稿功能 (users_open_release)
    echo "4. 开启会员投稿功能...\n";
    $stmt = $pdo->prepare("SELECT * FROM ey_users_config WHERE name = 'users_open_release' AND inc_type = 'users'");
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        // 更新现有记录
        $stmt = $pdo->prepare("UPDATE ey_users_config SET value = '1' WHERE name = 'users_open_release' AND inc_type = 'users'");
        $stmt->execute();
        echo "   ✓ 会员投稿功能已更新为开启状态\n";
    } else {
        // 插入新记录
        $stmt = $pdo->prepare("INSERT INTO ey_users_config (name, value, inc_type, lang) VALUES ('users_open_release', '1', 'users', 'cn')");
        $stmt->execute();
        echo "   ✓ 会员投稿功能已创建并开启\n";
    }

    // 5. 开启会员升级功能 (level_member_upgrade)
    echo "5. 开启会员升级功能...\n";
    $stmt = $pdo->prepare("SELECT * FROM ey_users_config WHERE name = 'level_member_upgrade' AND inc_type = 'level'");
    $stmt->execute();
    $result = $stmt->fetch(PDO::FETCH_ASSOC);
    
    if ($result) {
        // 更新现有记录
        $stmt = $pdo->prepare("UPDATE ey_users_config SET value = '1' WHERE name = 'level_member_upgrade' AND inc_type = 'level'");
        $stmt->execute();
        echo "   ✓ 会员升级功能已更新为开启状态\n";
    } else {
        // 插入新记录
        $stmt = $pdo->prepare("INSERT INTO ey_users_config (name, value, inc_type, lang) VALUES ('level_member_upgrade', '1', 'level', 'cn')");
        $stmt->execute();
        echo "   ✓ 会员升级功能已创建并开启\n";
    }

    echo "\n✅ 配置完成！\n";
    echo "现在你可以登录后台管理系统，应该能看到以下模块：\n";
    echo "- 会员中心\n";
    echo "- 商城中心\n";
    echo "- 订单管理\n";
    echo "\n访问路径：\n";
    echo "- 后台登录：http://你的域名/login.php\n";
    echo "- 订单管理：后台管理 → 更多功能 → 订单管理\n";
    echo "- 商城订单：后台管理 → 商城中心 → 商城订单\n";
    echo "- 会员订单：后台管理 → 会员中心 → 会员订单\n";
    echo "\n注意：如果仍然看不到订单管理，请清除浏览器缓存并重新登录后台。\n";

} catch (Exception $e) {
    echo "❌ 配置过程中出现错误：\n";
    echo $e->getMessage() . "\n";
    echo "请检查数据库连接和文件权限。\n";
}
?>