feat: 成绩查询增加年龄查询返回

钟日健

2026-06-01 62eb499b0c969f246d3245d1429a97da4de1ce28

feat: 成绩查询增加年龄查询返回

 src/main/java/org/springblade/modules/exam/mapper/ExamScoreMapper.xml

@@ -72,6 +72,7 @@
            ke.exam_name examName,date_format(ke.start_time,'%Y-%m-%d') startTime,date_format(ke.end_time,'%Y-%m-%d %H:%i:%s') endTime,
            str.is_exam isExam,
            bu.real_name securityName,company,bu.account,bu.sex,bu.paper_time paperTime,bu.securitynumber securityNumber,bu.avatar,
            ifnull(TIMESTAMPDIFF(YEAR, SUBSTRING(bu.cardid, 7, 8), CURDATE()),0) AS age,
            bd.dept_name companyName,bu.user_type isPaper,bud.unit_name unitName
        from
            exam_score es

 src/main/java/org/springblade/modules/exam/vo/ExamScoreVO.java

@@ -156,4 +156,9 @@

    //签到情况
    private String state;

    /**
     * 年龄
     */
    private Integer age;
}