成绩审查查询修改

Administrator

2021-11-14 57af844cb484b49fed612adbb35f388b1831aef2

成绩审查查询修改

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

@@ -27,6 +27,10 @@
        on
            ssar.create_user = bu1.id
        left join
            blade_dept bt1
        on
            bu1.dept_id = bt1.id
        left join
            exam_score es
        on
            es.id = ssar.exam_score_id
@@ -34,10 +38,21 @@
            ksxt_exam ke
        on
            ke.id = es.exam_id
        left join
            sys_information si
        on
            si.departmentid = bt.id
        left join
            sys_jurisdiction sj
        on
            sj.id = si.jurisdiction
        WHERE
            1=1
        and bu.status = 1
        and bu.is_deleted = 0
        <if test="scoreAuditRecords.jurisdiction!=null and scoreAuditRecords.jurisdiction!='' and scoreAuditRecords.jurisdiction!='1372091709474910209'">
            and (sj.id=#{scoreAuditRecords.jurisdiction} or sj.parent_id=#{scoreAuditRecords.jurisdiction})
        </if>
        <if test="scoreAuditRecords.deptName!=null and  scoreAuditRecords.deptName!=''">
            and bt.dept_name like concat('%', #{scoreAuditRecords.deptName},'%')
        </if>
@@ -53,6 +68,9 @@
        <if test="scoreAuditRecords.examName!=null and  scoreAuditRecords.examName!=''">
            and ke.exam_name like concat('%', #{scoreAuditRecords.examName},'%')
        </if>
        <if test="scoreAuditRecords.trainUnitId!=null and  scoreAuditRecords.trainUnitId!=''">
            and bt1.id = #{scoreAuditRecords.trainUnitId}
        </if>
        <if test="scoreAuditRecords.status!=null">
            and ssar.status = #{scoreAuditRecords.status}
        </if>

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

@@ -61,4 +61,14 @@
     */
    private String examName;

    /**
     * 辖区
     */
    private String jurisdiction;

    /**
     * 申请人部门id
     */
    private String trainUnitId;

}