考试查询，保安公司查询修改

Administrator

2021-09-01 79e1c09becc6ae041537a95630a3411245501779

考试查询，保安公司查询修改

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

@@ -134,7 +134,7 @@
    <!--查询考试人员考试信息-->
    <select id="getExamDetail" resultType="org.springblade.modules.exam.vo.ExamPaperVO">
        (select
            ke.id,ke.exam_name examName,ke.exam_type examType,
            ke.id,ke.exam_name examName,ke.start_time startTime,ke.exam_type examType,
            sa.candidate_no candidateNo,sa.id applyId,
            bu.real_name realName,bu.sex,bu.cardid idCardNo
        from
@@ -156,7 +156,7 @@
        union all

        (select
            ke.id,ke.exam_name examName,ke.exam_type examType,
            ke.id,ke.exam_name examName,ke.start_time startTime,ke.exam_type examType,
            str.candidate_no candidateNo,str.id applyId,
            bu.real_name realName,bu.sex,bu.cardid idCardNo
        from

 src/main/java/org/springblade/modules/system/mapper/DeptMapper.xml

@@ -129,6 +129,7 @@
        and dept_category = 1
        AND dept.is_deleted = 0
        and dept.id !=1420222961377357825
        and dept.id !=1432625856013971457
        and dept.parent_id!=1420222961377357825
        <if test="param1!=null and param1!='' and param1!='1123598813738675201'">
            and si.jurisdiction = #{param1}

 src/main/java/org/springblade/modules/system/mapper/UserMapper.xml

@@ -367,12 +367,8 @@
    <!--根据保安员编码查询保安信息-->
    <select id="getUserInfoBySecurityNumber" resultType="org.springblade.modules.system.vo.UserVO">
        select
        bu.id,
        bu.avatar,
        bu.securitynumber securityNumber,
        bu.*,
        ifnull(DATE_FORMAT(NOW(), '%Y') - SUBSTRING( cardid,7,4),0) age,
        bu.real_name realName,
        bu.sex,
        bd.dept_name deptName
         from
         blade_user bu