问题修复

zengh

2021-07-19 483603c229e627fbce22982a8204c70508688af3

问题修复

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

@@ -58,18 +58,15 @@

    <select id="selectExamPaperPage" resultType="org.springblade.modules.exam.vo.ExamPaperVO">
        SELECT
        sj.*,
        tm.id tid,
        tmxq.id as sid,tmxq.*
            *
        FROM
        ksxt_exam sj
        LEFT JOIN exam_examination_subject tm ON sj.id = tm.examination_id
        LEFT JOIN exam_subject_choices tmxq ON tm.subject_id = tmxq.id
            (SELECT
                sj.*,
                ( SELECT CASE WHEN COUNT ( * ) > 0 THEN 1 ELSE 0 END FROM sys_apply WHERE user_id = 11 ) AS show
            FROM
                ksxt_exam sj ) as s
        WHERE
        1 = 1
        <if test="paper.id !=null">
        and sj.id = #{paper.id}
        </if>
            show = 1
    </select>

    <select id="PagerSubject" resultMap="PagerSubjectAnswer">