// 检查所有参赛人的学历数据
|
const axios = require('axios');
|
|
async function checkAllEducationData() {
|
try {
|
console.log('=== 检查所有参赛人的学历数据 ===');
|
|
// 查询所有参赛人
|
const listQuery = `
|
query {
|
activityPlayerApplications(page: 1, size: 50) {
|
content {
|
id
|
playerName
|
projectName
|
}
|
totalElements
|
}
|
}
|
`;
|
|
const listResponse = await axios.post('http://localhost:8080/api/graphql', {
|
query: listQuery
|
}, {
|
headers: {
|
'Content-Type': 'application/json'
|
}
|
});
|
|
if (listResponse.data.errors) {
|
console.log('查询错误:', listResponse.data.errors);
|
return;
|
}
|
|
const applications = listResponse.data.data?.activityPlayerApplications?.content || [];
|
const total = listResponse.data.data?.activityPlayerApplications?.totalElements || 0;
|
|
console.log(`总共找到 ${total} 个参赛人，开始检查学历数据...`);
|
|
let educationStats = {
|
total: 0,
|
hasEducation: 0,
|
noEducation: 0,
|
educationTypes: {}
|
};
|
|
// 检查每个参赛人的学历
|
for (let i = 0; i < applications.length; i++) {
|
const app = applications[i];
|
|
// 查询详情
|
const detailQuery = `
|
query GetActivityPlayerDetail($id: ID!) {
|
activityPlayerDetail(id: $id) {
|
id
|
playerInfo {
|
name
|
education
|
}
|
}
|
}
|
`;
|
|
try {
|
const detailResponse = await axios.post('http://localhost:8080/api/graphql', {
|
query: detailQuery,
|
variables: { id: app.id }
|
}, {
|
headers: {
|
'Content-Type': 'application/json'
|
}
|
});
|
|
if (detailResponse.data.errors) {
|
console.log(`参赛人 ${app.id} 查询错误:`, detailResponse.data.errors);
|
continue;
|
}
|
|
const detail = detailResponse.data.data?.activityPlayerDetail;
|
if (!detail) {
|
console.log(`参赛人 ${app.id} 未找到详情`);
|
continue;
|
}
|
|
educationStats.total++;
|
const education = detail.playerInfo.education || '';
|
|
if (education && education.trim()) {
|
educationStats.hasEducation++;
|
if (educationStats.educationTypes[education]) {
|
educationStats.educationTypes[education]++;
|
} else {
|
educationStats.educationTypes[education] = 1;
|
}
|
|
console.log(`✅ 参赛人 ${detail.playerInfo.name} (ID: ${app.id}) 有学历: "${education}"`);
|
} else {
|
educationStats.noEducation++;
|
console.log(`❌ 参赛人 ${detail.playerInfo.name} (ID: ${app.id}) 学历为空`);
|
}
|
|
} catch (error) {
|
console.log(`参赛人 ${app.id} 查询失败:`, error.message);
|
}
|
}
|
|
console.log('\n=== 学历数据统计 ===');
|
console.log(`总参赛人数: ${educationStats.total}`);
|
console.log(`有学历数据: ${educationStats.hasEducation}`);
|
console.log(`无学历数据: ${educationStats.noEducation}`);
|
|
if (educationStats.hasEducation > 0) {
|
console.log('\n学历分布:');
|
Object.entries(educationStats.educationTypes).forEach(([education, count]) => {
|
console.log(` ${education}: ${count} 人`);
|
});
|
} else {
|
console.log('\n❌ 所有参赛人都没有学历数据！');
|
console.log('可能的原因:');
|
console.log('1. 用户在注册时确实没有选择学历');
|
console.log('2. 注册表单的学历字段有问题');
|
console.log('3. 数据提交时学历字段丢失');
|
console.log('4. 数据库存储时有问题');
|
}
|
|
} catch (error) {
|
console.error('检查失败:', error.message);
|
}
|
}
|
|
checkAllEducationData();
|
