1

13693261870

2023-02-25 ec17edbc0d74fc08dadbe723278ff8f07841dc30

1

 src/main/java/com/lf/server/controller/all/CrdsController.java

@@ -37,10 +37,13 @@

    @SysLog()
    @ApiOperation(value = "查询项目")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "西")
    })
    @GetMapping(value = "/selectProject")
    public ResponseMsg<List<DirEntity>> selectProject() {
    public ResponseMsg<List<DirEntity>> selectProject(String name) {
        try {
            List<DirEntity> list = dirService.selectProject();
            List<DirEntity> list = dirService.selectProject(name);

            return success(list);
        } catch (Exception ex) {

 src/main/java/com/lf/server/controller/all/FmeItController.java

@@ -261,10 +261,13 @@

    @SysLog()
    @ApiOperation(value = "查询项目")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "西")
    })
    @GetMapping(value = "/selectProject")
    public ResponseMsg<List<DirEntity>> selectProject() {
    public ResponseMsg<List<DirEntity>> selectProject(String name) {
        try {
            List<DirEntity> list = dirService.selectProject();
            List<DirEntity> list = dirService.selectProject(name);

            return success(list);
        } catch (Exception ex) {

 src/main/java/com/lf/server/controller/data/ProjectController.java

@@ -67,10 +67,13 @@

    @SysLog()
    @ApiOperation(value = "查询项目")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "西")
    })
    @GetMapping(value = "/selectProject")
    public ResponseMsg<List<DirEntity>> selectProject() {
    public ResponseMsg<List<DirEntity>> selectProject(String name) {
        try {
            List<DirEntity> list = dirService.selectProject();
            List<DirEntity> list = dirService.selectProject(name);

            return success(list);
        } catch (Exception ex) {

 src/main/java/com/lf/server/entity/all/StaticData.java

@@ -140,14 +140,9 @@
    public final static String TIFF = ".tiff";

    /**
     * WMTS
     * admin
     */
    public final static String WMTS = "WMTS";

    /**
     * GetCapabilities
     */
    public final static String CAPABILITY = "GetCapabilities";
    public final static String ADMIN = "admin";

    /**
     * 版本号

 src/main/java/com/lf/server/interceptor/AuthInterceptor.java

@@ -52,43 +52,53 @@
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) {
        // noinspection AlibabaRemoveCommentedCode
        try {
            // 非方法 或 无需授权，无需拦截
            // 1.非方法 或 无需授权，无需拦截
            if (!(handler instanceof HandlerMethod) || noNeedAuth(request)) {
                return true;
            }

            // 获取令牌
            // 2.获取令牌
            String token = WebHelper.getToken(request);
            if (StringHelper.isNull(token)) {
                return WebHelper.write2Page(response, NO_TOKEN);
            }

            // 获取IP，检查黑名单，检查白名单，检查IP一致性
            String ip = WebHelper.getIpAddress(request);
            if (StringHelper.isEmpty(ip)) {
                return WebHelper.write2Page(response, IP_NULL);
            }
            if (!checkBlackList(ip, request)) {
                return WebHelper.write2Page(response, BLACK_LIST);
            }
            if (!checkWhiteList(ip, request)) {
                if (!checkIpSource(ip, token)) {
                    return WebHelper.write2Page(response, ILLEGAL_TOKEN);
                }
            }

            // 获取用户令牌
            // 3.获取用户令牌
            UserEntity ue = sysService.tokenService.getCurrentUser(request);
            if (ue == null) {
                return WebHelper.write2Page(response, NO_LOGIN);
            }

            // 检查用户ID是否禁用
            // 4.获取IP
            String ip = WebHelper.getIpAddress(request);
            if (StringHelper.isEmpty(ip)) {
                return WebHelper.write2Page(response, IP_NULL);
            }

            // 5.检查黑名单
            if (!checkBlackList(ip, request)) {
                return WebHelper.write2Page(response, BLACK_LIST);
            }

            // 6.admin跳过权限检测
            if (StaticData.ADMIN.equals(ue.getUid())) {
                return true;
            }

            // 7.检查白名单
            if (!checkWhiteList(ip, request)) {
                // 检查IP一致性
                if (!checkIpSource(ip, token)) {
                    return WebHelper.write2Page(response, ILLEGAL_TOKEN);
                }
            }

            // 8.检查用户ID是否禁用
            if (sysService.tokenService.isUidDisable(ue)) {
                return WebHelper.write2Page(response, USER_LOCK);
            }

            // 权限校验
            // 9.权限校验
            if (!checkPerms(ue, request)) {
                System.out.println("无权限访问：" + request.getRequestURI().toLowerCase());
                return WebHelper.write2Page(response, NO_AUTH);

 src/main/java/com/lf/server/mapper/data/DirMapper.java

@@ -96,9 +96,10 @@
    /**
     * 查询项目
     *
     * @param name
     * @return
     */
    public List<DirEntity> selectProject();
    public List<DirEntity> selectProject(String name);

    /**
     * 递归查询

 src/main/java/com/lf/server/service/data/DirService.java

@@ -1,6 +1,7 @@
package com.lf.server.service.data;

import com.lf.server.entity.data.DirEntity;
import com.lf.server.helper.StringHelper;
import com.lf.server.mapper.data.DirMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -69,8 +70,10 @@
    }

    @Override
    public List<DirEntity> selectProject() {
        return dirMapper.selectProject();
    public List<DirEntity> selectProject(String name) {
        name = StringHelper.getLikeStr(name);

        return dirMapper.selectProject(name);
    }

    @Override

 src/main/resources/mapper/data/DirMapper.xml

@@ -17,7 +17,15 @@
    </select>

    <select id="selectProject" resultType="com.lf.server.entity.data.DirEntity">
        select a.*, fn_get_fullname(a.code, 2) fullName from lf.sys_dir a where pid = 0 and id > 1 order by order_num;
        select a.*, fn_get_fullname(a.code, 2) fullName
        from lf.sys_dir a
        <where>
            pid = 0
            <if test="name != null">
                and name like #{name}
            </if>
        </where>
        order by order_num;
    </select>

    <select id="selectDirRecursive" resultType="com.lf.server.entity.data.DirEntity">