const fetch = (...args) => import('node-fetch').then(({default: fetch}) => fetch(...args));

// 配置
const GRAPHQL_URL = 'http://localhost:8080/api/graphql';

// 检查登录记录的GraphQL查询
const CHECK_LOGIN_RECORDS_QUERY = `
  query {
    loginRecords: getAllLoginRecords {
      id
      userId
      wxOpenid
      wxSessionKey
      loginTime
      loginIp
      deviceInfo
      user {
        id
        username
        phone
      }
    }
  }
`;

async function checkLoginRecords() {
  console.log('🔍 检查数据库中的登录记录...\n');
  
  try {
    const response = await fetch(GRAPHQL_URL, {
      method: 'POST',
      headers: {
        'Content-Type': 'application/json',
      },
      body: JSON.stringify({
        query: CHECK_LOGIN_RECORDS_QUERY
      })
    });

    const result = await response.json();
    
    if (result.errors) {
      console.log('❌ GraphQL查询失败:', result.errors[0].message);
      return;
    }

    const records = result.data.loginRecords;
    console.log(`📊 找到 ${records.length} 条登录记录:\n`);
    
    records.forEach((record, index) => {
      console.log(`记录 ${index + 1}:`);
      console.log(`  - ID: ${record.id}`);
      console.log(`  - 用户ID: ${record.userId}`);
      console.log(`  - 微信OpenID: ${record.wxOpenid}`);
      console.log(`  - SessionKey: ${record.wxSessionKey ? record.wxSessionKey.substring(0, 10) + '...' : '无'}`);
      console.log(`  - 登录时间: ${record.loginTime}`);
      console.log(`  - 登录IP: ${record.loginIp}`);
      console.log(`  - 设备信息: ${record.deviceInfo}`);
      if (record.user) {
        console.log(`  - 用户名: ${record.user.username}`);
        console.log(`  - 手机号: ${record.user.phone || '未设置'}`);
      }
      console.log('');
    });

    // 分析数据
    const testDataRecords = records.filter(r => 
      r.wxOpenid && (r.wxOpenid.includes('test') || r.wxOpenid.includes('mock'))
    );
    
    const realDataRecords = records.filter(r => 
      r.wxOpenid && !r.wxOpenid.includes('test') && !r.wxOpenid.includes('mock')
    );

    console.log('📈 数据分析:');
    console.log(`  - 测试数据记录: ${testDataRecords.length} 条`);
    console.log(`  - 真实数据记录: ${realDataRecords.length} 条`);
    
    if (testDataRecords.length > 0) {
      console.log('\n⚠️  发现测试数据记录:');
      testDataRecords.forEach(record => {
        console.log(`  - OpenID: ${record.wxOpenid}`);
      });
    }
    
    if (realDataRecords.length > 0) {
      console.log('\n✅ 发现真实数据记录:');
      realDataRecords.forEach(record => {
        console.log(`  - OpenID: ${record.wxOpenid.substring(0, 10)}...`);
      });
    }

  } catch (error) {
    console.error('❌ 检查登录记录失败:', error.message);
  }
}

// 运行检查
checkLoginRecords();