20230221@xingjs@提交官网一张图相关内容接口

xing

2023-02-21 9ca3c6ef60688f0231b75698afaafc10b12435a7

20230221@xingjs@提交官网一张图相关内容接口

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

@@ -1,6 +1,7 @@
package com.lf.server.controller.show;


import com.lf.server.annotation.SysLog;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.service.show.OneMapService;
@@ -23,7 +24,7 @@

@Api(tags = "管网一张图")
@RestController
@RequestMapping("/one_Map")
@RequestMapping("/one_map")
public class OneMapController extends BaseController {

    @Autowired
@@ -43,10 +44,11 @@
     * 项目类别
     * Project category
     */
    @SysLog()
    @ApiOperation(value = "项目类别")
    @GetMapping("/countProjectCategory")
    public ResponseMsg<Object> projectCategoryConut() {
        List<String> resList = aMapOfPipelineService.projectCategoryConut();
    public ResponseMsg<Object> projectCategoryCount() {
        List<String> resList = aMapOfPipelineService.projectCategoryCount();
        return success(resList);
    }

@@ -54,10 +56,11 @@
     * 项目位置分布接口
     * Project location
     */
    @SysLog()
    @ApiOperation(value = "项目位置分布接口")
    @GetMapping("/countProjectLocation")
    public ResponseMsg<Object> projectLocationConut() {
        List<String> resList = aMapOfPipelineService.projectLocationConut();
    public ResponseMsg<Object> projectLocationCount() {
        List<String> resList = aMapOfPipelineService.projectLocationCount();
        return success(resList);
    }

@@ -66,10 +69,11 @@
     * 国家维度-数量统计
     * Country dimension
     */
    @SysLog()
    @ApiOperation(value = "国家维度-数量统计")
    @GetMapping("/conutCountryDimension")
    public ResponseMsg<Object> countryDimensionConut() {
        List<String> resList = aMapOfPipelineService.countryDimensionConut();
    @GetMapping("/countCountryDimension")
    public ResponseMsg<Object> countryDimensionCount() {
        List<String> resList = aMapOfPipelineService.countryDimensionCount();
        return success(resList);
    }

@@ -77,10 +81,11 @@
     * 省维度-数量统计
     * Province dimension - quantity
     */
    @SysLog()
    @ApiOperation(value = "省维度-数量统计")
    @GetMapping("/conutProvinceDimension")
    public ResponseMsg<Object> provinceDimensionConut() {
        List<String> resList = aMapOfPipelineService.provinceDimensionConut();
    @GetMapping("/countProvinceDimension")
    public ResponseMsg<Object> provinceDimensionCount() {
        List<String> resList = aMapOfPipelineService.provinceDimensionCount();
        return success(resList);
    }

@@ -92,10 +97,11 @@
     * 数据存储
     * data storage
     */
    @SysLog()
    @ApiOperation(value = "数据存储统计")
    @GetMapping("/countDataStorage")
    public ResponseMsg<Object> dataStorageConut() {
        List<String> resList = aMapOfPipelineService.dataStorageConut();
    public ResponseMsg<Object> dataStorageCount() {
        List<String> resList = aMapOfPipelineService.dataStorageCount();
        return success(resList);
    }

@@ -104,10 +110,11 @@
     * 文件格式维度-文件个数
     * File format dimension
     */
    @SysLog()
    @ApiOperation(value = "文件格式维度-文件个数")
    @GetMapping("/conutFileFormat")
    public ResponseMsg<Object> fileFormatConut() {
        List<String> resList = aMapOfPipelineService.fileFormatConut();
    @GetMapping("/countFileFormat")
    public ResponseMsg<Object> fileFormatCount() {
        List<String> resList = aMapOfPipelineService.fileFormatCount();
        return success(resList);
    }

@@ -116,10 +123,11 @@
     * 数据申请
     * Data application
     */
    @SysLog()
    @ApiOperation(value = "数据申请")
    @GetMapping("/conutDataApply")
    public ResponseMsg<Object> dataApplyConut() {
        List<String> resList = aMapOfPipelineService.dataApplyConut();
    @GetMapping("/countDataApply")
    public ResponseMsg<Object> dataApplyCount() {
        List<String> resList = aMapOfPipelineService.dataApplyCount();
        return success(resList);
    }

@@ -128,10 +136,11 @@
     * 访问次数
     * Number of visits
     */
    @SysLog()
    @ApiOperation(value = "访问次数")
    @GetMapping("/conutDataVisit")
    public ResponseMsg<Object> dataVisitConut() {
        List<String> resList = aMapOfPipelineService.dataVisitConut();
    @GetMapping("/countDataVisit")
    public ResponseMsg<Object> dataVisitCount() {
        List<String> resList = aMapOfPipelineService.dataVisitCount();
        return success(resList);
    }

@@ -141,10 +150,11 @@
     * 访问次数
     * Number of visits
     */
    @SysLog()
    @ApiOperation(value = "访问次数")
    @GetMapping("data_visit1")
    public ResponseMsg<Object> dataVisitConut1() {
        List<String> resList = aMapOfPipelineService.dataVisitConut();
        List<String> resList = aMapOfPipelineService.dataVisitCount();
        return success(resList);
    }


 src/main/java/com/lf/server/mapper/show/OneMapMapper.java

@@ -16,56 +16,56 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectCategoryConut();
    public List<String> projectCategoryCount();

    /**
     * 项目位置conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectLocationConut();
    public List<String> projectLocationCount();

    /**
     * 国家维度conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> countryDimensionConut();
    public List<String> countryDimensionCount();

    /**
     * 省维conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> provinceDimensionConut();
    public List<String> provinceDimensionCount();

    /**
     * 数据存储conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataStorageConut();
    public List<String> dataStorageCount();

    /**
     * 文件格式conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> fileFormatConut();
    public List<String> fileFormatCount();

    /**
     * 数据申请conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataApplyConut();
    public List<String> dataApplyCount();

    /**
     * 数据访问conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataVisitConut();
    public List<String> dataVisitCount();


}

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

@@ -15,8 +15,8 @@
    /**
     * 项目类别conut
     */
    public List<String> projectCategoryConut() {
        return aMapOfPipelineMapper.projectCategoryConut();
    public List<String> projectCategoryCount() {
        return aMapOfPipelineMapper.projectCategoryCount();
    }

    /**
@@ -24,16 +24,16 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectLocationConut() {
        return aMapOfPipelineMapper.projectLocationConut();
    public List<String> projectLocationCount() {
        return aMapOfPipelineMapper.projectLocationCount();
    }


    /**
     * 国家维度conut
     */
    public List<String> countryDimensionConut() {
        return aMapOfPipelineMapper.countryDimensionConut();
    public List<String> countryDimensionCount() {
        return aMapOfPipelineMapper.countryDimensionCount();
    }


@@ -42,8 +42,8 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> provinceDimensionConut() {
        return aMapOfPipelineMapper.provinceDimensionConut();
    public List<String> provinceDimensionCount() {
        return aMapOfPipelineMapper.provinceDimensionCount();
    }

    /**
@@ -51,8 +51,8 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataStorageConut() {
        return aMapOfPipelineMapper.dataStorageConut();
    public List<String> dataStorageCount() {
        return aMapOfPipelineMapper.dataStorageCount();
    }

    /**
@@ -60,8 +60,8 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> fileFormatConut() {
        return aMapOfPipelineMapper.fileFormatConut();
    public List<String> fileFormatCount() {
        return aMapOfPipelineMapper.fileFormatCount();
    }

    /**
@@ -69,12 +69,12 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataApplyConut() {
        return aMapOfPipelineMapper.dataApplyConut();
    public List<String> dataApplyCount() {
        return aMapOfPipelineMapper.dataApplyCount();
    }

    public List<String> dataVisitConut() {
        return aMapOfPipelineMapper.dataVisitConut();
    public List<String> dataVisitCount() {
        return aMapOfPipelineMapper.dataVisitCount();
    }



 src/main/resources/mapper/show/OneMapMapper.xml

@@ -6,45 +6,45 @@


    <!--  项目类别 select * from bs.bs_project;  -->
    <select id="projectCategoryConut" resultType="java.util.Map">
    <select id="projectCategoryCount" resultType="java.util.Map">
        select projtype,count(*) from bs.bs_project group by projtype;
    </select>


    <!--  项目位置分布 select a.*,st_astext(geom) from bs.bs_project a  -->
    <select id="projectLocationConut" resultType="java.util.Map">
    <select id="projectLocationCount" resultType="java.util.Map">
        select a.*,st_astext(geom) from bs.bs_project a;
    </select>

    <!--  项目类别 国家维度-数量  -->
    <select id="countryDimensionConut" resultType="java.util.Map">
    <select id="countryDimensionCount" resultType="java.util.Map">
        select country,count(*) from bs.bs_project group by country;
    </select>

    <!--  项目类别 省维度-数量  -->
    <select id="provinceDimensionConut" resultType="java.util.Map">
    <select id="provinceDimensionCount" resultType="java.util.Map">
        select province,count(*) from bs.bs_project where country like '%中国%' group by province ;
    </select>

    <!--  数据统计 数据存储  -->
    <select id="dataStorageConut" resultType="java.util.Map">
    <select id="dataStorageCount" resultType="java.util.Map">
        select name "名称", (select count(*) from lf.sys_meta b where b.dircode like a.code || '%') "文件数",
               (select count(sizes) from lf.sys_meta b where b.dircode like a.code || '%') "数量(MB)"
        from lf.sys_dir a where id > 1 and pid = 0;
    </select>

    <!--  数据统计 文件格式维度-文件个数  -->
    <select id="fileFormatConut" resultType="java.util.Map">
    <select id="fileFormatCount" resultType="java.util.Map">
        select type,count(*),count(sizes) from lf.sys_meta group by type;
    </select>

    <!--  数据统计 数据申请  -->
    <select id="dataApplyConut" resultType="java.util.Map">
    <select id="dataApplyCount" resultType="java.util.Map">
        select * from lf.sys_apply a inner join lf.sys_user b on a.userid = b.id;
    </select>

    <!--  数据统计 访问统计  -->
    <select id="dataVisitConut" resultType="java.util.Map">
    <select id="dataVisitCount" resultType="java.util.Map">
        select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
    </select>