refactor：成绩管理

龚焕茏

2024-06-14 37279beff7ecc26a3b7333ad01c5274f17abd647

refactor：成绩管理

 src/main/java/com/ycl/jxkg/domain/entity/Question.java

@@ -18,7 +18,7 @@


    /**
     *     1.单选题 2.多选题 3.判断题 4.填空题 5.简答题
     *     题目类型 1.单选题 2.多选题 3.判断题 4.填空题 5.简答题 6.语音题 7.计算题 8.分析题
     */
    @TableField("question_type")
    private Integer questionType;

 src/main/java/com/ycl/jxkg/domain/vo/admin/paper/ExamPaperAnswerPageRequestVO.java

@@ -16,4 +16,6 @@

    private String userName;

    private String examName;

}

 src/main/java/com/ycl/jxkg/domain/vo/student/exampaper/ExamPaperAnswerPageResponseVO.java

@@ -48,4 +48,9 @@
     */
    private Integer suggestTime;

    /**
     * 考试名称
     */
    private String examName;

}

 src/main/resources/mapper/ExamPaperAnswerMapper.xml

@@ -92,7 +92,8 @@
        b.name AS subjectName,
        c.real_name AS userName,
        IFNULL(COUNT(d.id), 0) AS personAnswerNum,
        IFNULL(COUNT(f.id), 0) AS personTotalNum
        IFNULL(COUNT(f.id), 0) AS personTotalNum,
        t.exam_name
        FROM t_exam_paper a
        INNER JOIN t_exam t ON a.id = t.exam_paper_id AND t.status = 'finished' AND t.deleted = 0
        LEFT JOIN t_subject b ON a.subject_id = b.id
@@ -109,9 +110,12 @@
            <if test="name != null and name != ''">
                AND INSTR(a.name, #{name})
            </if>
            <if test="examName != null and examName != ''">
                AND INSTR(t.exam_name, #{examName})
            </if>
        </where>
        GROUP BY a.id
        ORDER BY a.id DESC
        GROUP BY t.id
        ORDER BY t.id DESC
    </select>

</mapper>