package com.rongyichuang;
|
|
import org.junit.jupiter.api.Test;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.boot.test.context.SpringBootTest;
|
import org.springframework.jdbc.core.JdbcTemplate;
|
import org.springframework.test.context.ActiveProfiles;
|
|
import java.util.List;
|
import java.util.Map;
|
|
@SpringBootTest
|
@ActiveProfiles("test")
|
public class CheckUserPermissionTest {
|
|
@Autowired
|
private JdbcTemplate jdbcTemplate;
|
|
@Test
|
public void checkUserJudgePermission() {
|
System.out.println("=== 检查用户ID=2的评委权限 ===");
|
|
try {
|
// 先查看用户表结构
|
String describeUserSql = "DESCRIBE t_user";
|
List<Map<String, Object>> userTableStructure = jdbcTemplate.queryForList(describeUserSql);
|
System.out.println("用户表结构:");
|
for (Map<String, Object> column : userTableStructure) {
|
System.out.println("字段: " + column.get("Field") + ", 类型: " + column.get("Type"));
|
}
|
|
// 1. 检查用户ID=2是否关联了评委记录
|
String userJudgeSql = "SELECT u.id as user_id, u.phone, j.id as judge_id, j.name as judge_name " +
|
"FROM t_user u LEFT JOIN t_judge j ON u.id = j.user_id WHERE u.id = 2";
|
List<Map<String, Object>> userJudgeData = jdbcTemplate.queryForList(userJudgeSql);
|
|
System.out.println("\n用户评委关联数据:");
|
for (Map<String, Object> row : userJudgeData) {
|
System.out.println("用户ID: " + row.get("user_id") +
|
", 手机号: " + row.get("phone") +
|
", 评委ID: " + row.get("judge_id") +
|
", 评委姓名: " + row.get("judge_name"));
|
}
|
|
// 2. 如果有评委记录，检查评委的活动权限
|
if (!userJudgeData.isEmpty() && userJudgeData.get(0).get("judge_id") != null) {
|
Long judgeId = ((Number) userJudgeData.get(0).get("judge_id")).longValue();
|
|
String activityJudgeSql = "SELECT aj.activity_id, aj.judge_id, aj.state, a.name as activity_name " +
|
"FROM t_activity_judge aj " +
|
"LEFT JOIN t_activity a ON aj.activity_id = a.id " +
|
"WHERE aj.judge_id = ?";
|
List<Map<String, Object>> activityJudgeData = jdbcTemplate.queryForList(activityJudgeSql, judgeId);
|
|
System.out.println("\n评委活动权限数据:");
|
for (Map<String, Object> row : activityJudgeData) {
|
System.out.println("活动ID: " + row.get("activity_id") +
|
", 活动名称: " + row.get("activity_name") +
|
", 评委ID: " + row.get("judge_id") +
|
", 状态: " + row.get("state"));
|
}
|
|
if (activityJudgeData.isEmpty()) {
|
System.out.println("❌ 评委ID=" + judgeId + " 没有任何活动的评审权限");
|
}
|
} else {
|
System.out.println("❌ 用户ID=2 没有关联评委记录");
|
}
|
|
// 3. 检查所有活动的信息
|
String allActivitiesSql = "SELECT id, name, state FROM t_activity ORDER BY id";
|
List<Map<String, Object>> allActivities = jdbcTemplate.queryForList(allActivitiesSql);
|
|
System.out.println("\n所有活动信息:");
|
for (Map<String, Object> row : allActivities) {
|
System.out.println("活动ID: " + row.get("id") +
|
", 活动名称: " + row.get("name") +
|
", 状态: " + row.get("state"));
|
}
|
|
// 4. 检查所有评委信息
|
String allJudgesSql = "SELECT id, name, user_id FROM t_judge ORDER BY id";
|
List<Map<String, Object>> allJudges = jdbcTemplate.queryForList(allJudgesSql);
|
|
System.out.println("\n所有评委信息:");
|
for (Map<String, Object> row : allJudges) {
|
System.out.println("评委ID: " + row.get("id") +
|
", 评委姓名: " + row.get("name") +
|
", 用户ID: " + row.get("user_id"));
|
}
|
|
} catch (Exception e) {
|
System.out.println("检查权限时发生异常: " + e.getMessage());
|
e.printStackTrace();
|
}
|
}
|
}
|
