const mysql = require('mysql2/promise');

// 数据库连接配置
const dbConfig = {
  host: '139.155.104.10',
  port: 3306,
  user: 'ryc',
  password: 'KiYap3E8X8RLcM6T',
  database: 'ryc',
  connectTimeout: 60000,
  acquireTimeout: 60000,
  timeout: 60000
};

async function verifyBirthdayData() {
  let connection;
  
  try {
    console.log('连接数据库...');
    connection = await mysql.createConnection(dbConfig);
    
    // 查询最近的报名记录及其关联的用户信息
    const query = `
      SELECT 
        ap.id as registration_id,
        ap.project_name,
        ap.description as registration_description,
        p.name as player_name,
        p.phone as player_phone,
        p.gender,
        p.education,
        p.introduction,
        u.id as user_id,
        u.name as user_name,
        u.phone as user_phone,
        u.birthday,
        ap.create_time
      FROM t_activity_player ap
      LEFT JOIN t_player p ON ap.player_id = p.id
      LEFT JOIN t_user u ON p.user_id = u.id
      WHERE ap.id IN (25, 26)
      ORDER BY ap.create_time DESC
      LIMIT 5
    `;
    
    console.log('查询最近的报名记录...');
    const [rows] = await connection.execute(query);
    
    if (rows.length > 0) {
      console.log('\n✅ 找到报名记录:');
      rows.forEach((row, index) => {
        console.log(`\n--- 记录 ${index + 1} ---`);
        console.log(`报名ID: ${row.registration_id}`);
        console.log(`选手姓名: ${row.player_name}`);
        console.log(`选手电话: ${row.player_phone}`);
        console.log(`性别: ${row.gender === 0 ? '男' : '女'}`);
        console.log(`学历: ${row.education}`);
        console.log(`项目名称: ${row.project_name}`);
        console.log(`报名描述: ${row.registration_description}`);
        console.log(`用户ID: ${row.user_id}`);
        console.log(`用户姓名: ${row.user_name}`);
        console.log(`用户电话: ${row.user_phone}`);
        console.log(`生日: ${row.birthday}`);
        console.log(`报名时间: ${row.create_time}`);
        
        if (row.birthday) {
          console.log('✅ 生日字段已正确保存到用户表');
        } else {
          console.log('❌ 生日字段未保存到用户表');
        }
      });
    } else {
      console.log('❌ 未找到报名记录');
    }
    
  } catch (error) {
    console.error('❌ 数据库查询失败:', error.message);
  } finally {
    if (connection) {
      await connection.end();
      console.log('\n数据库连接已关闭');
    }
  }
}

verifyBirthdayData();