1

13693261870

2022-10-27 dc59d63cfa8cac113c4834e6b7d90c0af61df31f

1

 data/menu.xls

Binary files differ

 src/main/java/com/lf/server/controller/show/ComprehensiveController.java

ÎļþÒÑɾ³ý

 src/main/java/com/lf/server/controller/show/InquiryController.java

@@ -7,18 +7,25 @@
import com.lf.server.aspect.SysLog;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.ctrl.ShpRecordEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.entity.sys.UserEntity;
import com.lf.server.helper.AesHelper;
import com.lf.server.helper.ClassHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.mapper.all.GeomBaseMapper;
import com.lf.server.service.data.UploaderService;
import com.lf.server.service.show.InquiryService;
import com.lf.server.service.sys.TokenService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.List;

/**
@@ -29,6 +36,17 @@
@RestController
@RequestMapping("/inquiry")
public class InquiryController extends BaseController {
    private final static int FOUR = 4;

    @Autowired
    TokenService tokenService;

    @Autowired
    UploaderService uploaderService;

    @Autowired
    InquiryService inquiryService;

    @SysLog()
    @ApiOperation(value = "查询记录数")
    @ApiImplicitParams({
@@ -118,4 +136,31 @@
            return fail(ex.getMessage(), null);
        }
    }

    @SysLog()
    @ApiOperation(value = "上传Shp文件读取第一条记录的WKT")
    @ResponseBody
    @PostMapping(value = "/uploadShp")
    public ResponseMsg<ShpRecordEntity> uploadShp(HttpServletRequest req, HttpServletResponse res) {
        try {
            UserEntity ue = tokenService.getCurrentUser(req);
            if (ue == null) {
                return fail("用户未登录", null);
            }

            List<MetaFileEntity> list = uploaderService.uploadData(null, ue, req, res);
            if (list.size() < FOUR) {
                return fail("没有找到已上传的数据或不完整", null);
            }

            ShpRecordEntity sr = inquiryService.readShpFirstRecord(list);
            if (sr != null && !StringHelper.isEmpty(sr.getWkt())) {
                sr.setWkt(AesHelper.encrypt(sr.getWkt()));
            }

            return success(sr);
        } catch (Exception ex) {
            return fail(ex.getMessage(), null);
        }
    }
}

 src/main/java/com/lf/server/controller/show/LocateController.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,74 @@
package com.lf.server.controller.show;

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.aspect.SysLog;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.bd.DlgAgnpEntity;
import com.lf.server.service.data.UploaderService;
import com.lf.server.service.show.LocateService;
import com.lf.server.service.sys.TokenService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiImplicitParam;
import io.swagger.annotations.ApiImplicitParams;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * ç»¼åˆå±•ç¤º
 * @author WWW
 */
@Api(tags = "综合展示\\定位")
@RestController
@RequestMapping("/locate")
public class LocateController extends BaseController {
    @Autowired
    TokenService tokenService;

    @Autowired
    UploaderService uploaderService;

    @Autowired
    LocateService locateService;

    @SysLog()
    @ApiOperation(value = "分页查询并返回记录数-地名地址")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "name", value = "名称", dataType = "String", paramType = "query", example = "多"),
            @ApiImplicitParam(name = "pageSize", value = "每页条数", dataType = "Integer", paramType = "query", example = "10"),
            @ApiImplicitParam(name = "pageIndex", value = "分页数（从1开始）", dataType = "Integer", paramType = "query", example = "1")
    })
    @GetMapping(value = "/selectAddrByPage")
    public ResponseMsg<List<DlgAgnpEntity>> selectAddrByPage(String name, Integer pageSize, Integer pageIndex) {
        try {
            if (pageSize < 1 || pageIndex < 1) {
                return fail("每页页数或分页数小于1", null);
            }

            Page<DlgAgnpEntity> paged = locateService.selectAddrByPage(name, pageSize, pageIndex);

            return success(paged.getTotal(), paged.getRecords());
        } catch (Exception ex) {
            return fail(ex.getMessage(), null);
        }
    }

    @SysLog()
    @ApiOperation(value = "根据ID查询WKT-地名地址")
    @ApiImplicitParams({
            @ApiImplicitParam(name = "id", value = "ID", dataType = "Integer", paramType = "query", example = "1")
    })
    @GetMapping(value = "/selectWktById")
    public ResponseMsg<String> selectWktById(Integer id) {
        try {
            String wkt = locateService.selectWktById(id);

            return success(wkt);
        } catch (Exception ex) {
            return fail(ex.getMessage(), null);
        }
    }
}

 src/main/java/com/lf/server/helper/GdalHelper.java

@@ -45,7 +45,7 @@
    }

    /**
     * èŽ·å–Shp第一条记录的WKT
     * è¯»å–Shp第一条记录的WKT
     */
    public static ShpRecordEntity readShpFirstRecord(String filePath) {
        try {

 src/main/java/com/lf/server/service/show/InquiryService.java

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,41 @@
package com.lf.server.service.show;

import com.lf.server.entity.ctrl.ShpRecordEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.helper.FileHelper;
import com.lf.server.helper.GdalHelper;
import com.lf.server.helper.StringHelper;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * æŸ¥è¯¢æœåŠ¡ç±»
 * @author WWW
 */
@Service
public class InquiryService {
    /**
     * è¯»å–Shp第一条记录的WKT
     *
     * @param list
     * @return
     */
    public ShpRecordEntity readShpFirstRecord(List<MetaFileEntity> list) {
        String fileName = null;
        for (MetaFileEntity mf : list) {
            if (mf.getName().toLowerCase().indexOf(".shp") > -1) {
                fileName = mf.getPath();
                break;
            }
        }
        if (StringHelper.isEmpty(fileName)) {
            return null;
        }

        ShpRecordEntity sr = GdalHelper.readShpFirstRecord(fileName);
        FileHelper.deleteFiles(list);

        return sr;
    }
}

 src/main/java/com/lf/server/service/show/LocateService.java

ÎļþÃû´Ó src/main/java/com/lf/server/service/show/ComprehensiveService.java ÐÞ¸Ä
@@ -4,23 +4,17 @@
import com.baomidou.mybatisplus.core.metadata.OrderItem;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.lf.server.entity.bd.DlgAgnpEntity;
import com.lf.server.entity.ctrl.ShpRecordEntity;
import com.lf.server.entity.data.MetaFileEntity;
import com.lf.server.helper.FileHelper;
import com.lf.server.helper.GdalHelper;
import com.lf.server.helper.StringHelper;
import com.lf.server.mapper.bd.DlgAgnpMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * ç»¼åˆå±•ç¤º
 * @author WWW
 */
@Service
public class ComprehensiveService {
public class LocateService {
    @Autowired
    DlgAgnpMapper dlgAgnpMapper;

@@ -39,23 +33,5 @@

    public String selectWktById(Integer id) {
        return dlgAgnpMapper.selectWktById(id);
    }

    public ShpRecordEntity readShpFirstRecord(List<MetaFileEntity> list) {
        String fileName = null;
        for (MetaFileEntity mf : list) {
            if (mf.getName().toLowerCase().indexOf(".shp") > -1) {
                fileName = mf.getPath();
                break;
            }
        }
        if (StringHelper.isEmpty(fileName)) {
            return null;
        }

        ShpRecordEntity sr = GdalHelper.readShpFirstRecord(fileName);
        FileHelper.deleteFiles(list);

        return sr;
    }
}