考试成绩查询修改

Administrator

2021-09-22 9d8764305288a904a3d490b1689be78f9e885bd3

考试成绩查询修改

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

@@ -6,7 +6,7 @@
    <select id="selectExamScorePage" resultType="org.springblade.modules.exam.vo.ExamScoreVO">
        SELECT
        es.id,es.theory_grade theoryGrade,ifnull(learn_grade,-1) learnGrade,
        exam_name examName,bu.real_name securityName,company,exam_time examTime,
        ke.exam_name examName,bu.real_name securityName,company,es.exam_time examTime,
        all_grade allGrade,exam_end_time examEndTime,qualified,
        bd.dept_name companyName
        FROM
@@ -19,6 +19,10 @@
        blade_dept bd
        on
        bd.id = es.company
        left join
        ksxt_exam ke
        on
        ke.id = es.exam_id
        WHERE
        1=1
        <if test="examScore.examName!=null and  examScore.examName!=''">
@@ -39,6 +43,7 @@
        <if test="examScore.qualified!=null">
            and es.qualified = #{examScore.qualified}
        </if>
        order by es.id desc
    </select>

    <!--考试成绩详情信息-->