<?php
$dbname = 'ey_youliftu';
$host = '127.0.0.1';
$port = 3307;
$user = 'root';
$pass = 'root';

try {
    $pdo = new PDO("mysql:host=$host;port=$port;dbname=$dbname", $user, $pass);
    $pdo->exec('SET NAMES utf8');
    
    // 检查商城开关
    $stmt = $pdo->query("SELECT * FROM ey_users_config WHERE name = 'shop_open' AND inc_type = 'shop'");
    $shopConfig = $stmt->fetch(PDO::FETCH_ASSOC);
    echo "商城开关配置: " . json_encode($shopConfig, JSON_UNESCAPED_UNICODE) . "\n\n";
    
    // 检查 users_price 字段配置
    $stmt2 = $pdo->query("SELECT * FROM ey_channelfield WHERE name = 'users_price' AND channel_id = 2 AND status = 1");
    $fieldConfigs = $stmt2->fetchAll(PDO::FETCH_ASSOC);
    echo "产品价格字段配置 (channel_id=2): " . count($fieldConfigs) . " 条\n";
    foreach ($fieldConfigs as $fc) {
        echo "  - ID: {$fc['id']}, 名称: {$fc['name']}, 显示名: {$fc['title']}, ifmain: {$fc['ifmain']}, ifeditable: {$fc['ifeditable']}, ifcontrol: {$fc['ifcontrol']}, status: {$fc['status']}\n";
    }
    
    // 检查所有模型的 users_price 字段
    echo "\n所有模型的 users_price 字段:\n";
    $stmt3 = $pdo->query("SELECT channel_id, id, title, ifmain, ifeditable, ifcontrol, status FROM ey_channelfield WHERE name = 'users_price'");
    $allFields = $stmt3->fetchAll(PDO::FETCH_ASSOC);
    foreach ($allFields as $f) {
        echo "  模型{$f['channel_id']}: ID={$f['id']}, 标题={$f['title']}, ifmain={$f['ifmain']}, ifeditable={$f['ifeditable']}, ifcontrol={$f['ifcontrol']}, status={$f['status']}\n";
    }
    
} catch (Exception $e) {
    echo "错误: " . $e->getMessage() . "\n";
}