1.用户

tangzy

2021-08-27 24e69c8f1b5531f2076e156107d595de62e889e5

1.用户

 src/main/java/org/springblade/modules/system/controller/UserController.java

@@ -651,5 +651,17 @@
    }


    /**
     * 保安员信息
     * @param user
     * @return
     */
    @GetMapping("/seleL")
    public R seleL(String type,String deptid, String jurisdiction) {
        List<Map<String, Object>> list = userService.seleL(type,deptid, jurisdiction);
        return R.data(list);
    }



}

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

@@ -131,6 +131,7 @@
    UserVO getUserAgeById(@Param("userId") Long userId);

    List<Map<String, Object>> selectUser();
    List<Map<String, Object>> seleL(String type,String deptid,String jurisdiction);

    /**
     * 根据保安员编码查询保安信息

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

@@ -392,4 +392,23 @@
        bu.dept_id = bd.id
        where bu.id = #{user.id}
    </select>

    <select id="seleL" resultType="java.util.HashMap">
        SELECT
            *
        FROM
            blade_user where 1=1
        <if test="type!=null and type=='1'.toString()">
            and role_id='1414840172333842433' and `status`=1 AND is_deleted=0
        </if>
        <if test="type!=null and type=='2'.toString()">
            and role_id='1412226235153731586' and `status`=1 AND is_deleted=0
        </if>
        <if test="deptid!=null and deptid!=''">
            and dept_id=#{deptid}
        </if>
        <if test="jurisdiction!=null and jurisdiction!=''">
            and jurisdiction=#{jurisdiction}
        </if>
    </select>
</mapper>

 src/main/java/org/springblade/modules/system/service/IUserService.java

@@ -298,4 +298,5 @@
     * @return
     */
    UserVO getUserDetails(User user);
    List<Map<String, Object>> seleL(String type,String deptid,String jurisdiction);
}

 src/main/java/org/springblade/modules/system/service/impl/UserServiceImpl.java

@@ -618,4 +618,9 @@
    public UserVO getUserDetails(User user) {
        return baseMapper.getUserDetails(user);
    }

    @Override
    public List<Map<String, Object>> seleL(String type,String deptid, String jurisdiction) {
        return baseMapper.seleL(type,deptid, jurisdiction);
    }
}