1.保安员证编码

tangzy

2021-07-15 a9f394b28bb124732b7465d8e0880dfd3078b1ef

1.保安员证编码

 src/main/java/org/springblade/modules/system/entity/User.java

@@ -158,6 +158,10 @@
     * 行政区域id
     */
    private String jurisdiction;
    /**
     * 保安员证编码
     */
    private String securitynumber;




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

@@ -37,6 +37,8 @@
        <result column="registered" property="registered"/>
        <result column="rtime" property="rtime"/>
        <result column="hold" property="hold"/>
        <result column="jurisdiction" property="jurisdiction"/>
        <result column="securitynumber" property="securitynumber"/>
    </resultMap>

    <select id="selectUserPage" resultMap="userResultMap">
@@ -75,6 +77,9 @@
        <if test="user.userType!=null and user.userType != ''">
            and bu.user_type = #{user.userType}
        </if>
          <if test="user.securitynumber!=null and user.securitynumber != ''">
            and bu.securitynumber = #{user.securitynumber}
        </if>
        <if test="deptIdList!=null and deptIdList.size>0">
            and bu.id in (
                SELECT