<?php
// 检查 eyoucms 商城功能配置

require_once __DIR__ . '/thinkphp/base.php';

$db_config = [
    'type'  => 'mysql',
    'hostname'  => '127.0.0.1',
    'database'  => '2024_11_11_01',
    'username'  => 'travel_user',
    'password'  => '9b0e4191aa1faf39',
    'hostport'  => '3306',
    'charset'   => 'utf8',
    'prefix'    => 'ey_',
];

// 连接数据库
try {
    $pdo = new PDO(
        "mysql:host={$db_config['hostname']};dbname={$db_config['database']};charset={$db_config['charset']}",
        $db_config['username'],
        $db_config['password'],
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
} catch (PDOException $e) {
    die('数据库连接失败：' . $e->getMessage());
}

echo "==============================================\n";
echo "       EYOUCMS 商城功能配置检查\n";
echo "==============================================\n\n";

// 1. 检查商城开关
echo "1. 商城开关配置 (shop_open):\n";
$stmt = $pdo->query("SELECT * FROM ey_users_config WHERE name = 'shop_open' AND inc_type = 'shop'");
$shopConfig = $stmt->fetch(PDO::FETCH_ASSOC);
if ($shopConfig) {
    $status = $shopConfig['value'] == 1 ? '✓ 已开启' : '✗ 未开启';
    echo "   状态: $status\n";
    echo "   值: {$shopConfig['value']}\n";
} else {
    echo "   状态: ✗ 未配置\n";
}
echo "\n";

// 2. 检查商城相关配置
echo "2. 商城相关配置:\n";
$stmt = $pdo->query("SELECT * FROM ey_users_config WHERE inc_type = 'shop'");
$allShopConfigs = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach ($allShopConfigs as $config) {
    echo "   - {$config['name']} = {$config['value']}\n";
}
echo "\n";

// 3. 检查产品价格字段
echo "3. 产品价格字段配置 (users_price):\n";
$stmt = $pdo->query("SELECT cf.*, c.channel_name FROM ey_channelfield cf LEFT JOIN ey_channeltype c ON cf.channel_id = c.id WHERE cf.name = 'users_price'");
$priceFields = $stmt->fetchAll(PDO::FETCH_ASSOC);
if (!empty($priceFields)) {
    foreach ($priceFields as $field) {
        $status = $field['status'] == 1 ? '✓' : '✗';
        echo "   $status 模型[{$field['channel_id']}]{$field['channel_name']}: {$field['title']} (ifmain={$field['ifmain']}, ifeditable={$field['ifeditable']})\n";
    }
} else {
    echo "   ✗ 未找到 users_price 字段配置\n";
}
echo "\n";

// 4. 检查商城订单表
echo "4. 商城订单表 (ey_shop_order):\n";
$stmt = $pdo->query("SHOW TABLES LIKE 'ey_shop_order'");
if ($stmt->rowCount() > 0) {
    echo "   ✓ 订单表存在\n";
    $stmt2 = $pdo->query("SELECT COUNT(*) as total FROM ey_shop_order");
    $count = $stmt2->fetch(PDO::FETCH_ASSOC);
    echo "   订单数量: {$count['total']}\n";
} else {
    echo "   ✗ 订单表不存在\n";
}
echo "\n";

// 5. 检查商城订单详情表
echo "5. 商城订单详情表 (ey_shop_order_details):\n";
$stmt = $pdo->query("SHOW TABLES LIKE 'ey_shop_order_details'");
if ($stmt->rowCount() > 0) {
    echo "   ✓ 订单详情表存在\n";
} else {
    echo "   ✗ 订单详情表不存在\n";
}
echo "\n";

// 6. 检查购物车表
echo "6. 商城购物车表 (ey_shop_cart):\n";
$stmt = $pdo->query("SHOW TABLES LIKE 'ey_shop_cart'");
if ($stmt->rowCount() > 0) {
    echo "   ✓ 购物车表存在\n";
} else {
    echo "   ✗ 购物车表不存在\n";
}
echo "\n";

// 7. 检查会员中心是否显示商城入口
echo "7. 商城入口检查:\n";
echo "   前台会员中心会显示商城菜单（当 shop_open=1 且会员级别>1时）\n";
echo "   菜单包括：购物车、收货地址、我的订单、售后等\n";
echo "\n";

echo "==============================================\n";
echo "                    使用说明\n";
echo "==============================================\n";
echo "\n";
echo "【开启商城】\n";
echo "1. 登录后台 → 会员中心 → 会员配置 → 商城配置\n";
echo "2. 将 'shop_open' 设置为 1 开启商城\n";
echo "\n";
echo "【产品设置价格】\n";
echo "1. 添加/编辑产品时，设置 'users_price' 字段为产品价格\n";
echo "2. 确保产品模型已启用价格字段\n";
echo "\n";
echo "【商城功能】\n";
echo "- 产品展示和购买\n";
echo "- 购物车管理\n";
echo "- 收货地址管理\n";
echo "- 订单管理\n";
echo "- 支付集成（支持多种支付方式）\n";
echo "- 售后服务\n";
echo "\n";
echo "【支付配置】\n";
echo "1. 后台 → 会员中心 → 支付方式\n";
echo "2. 配置支付宝、微信支付、Stripe等\n";
echo "\n";