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

xing

2023-02-21 593ded3205553e24003e8bd95753cc9b88013a1b

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

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

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


import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.service.show.OneMapService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * ç®¡ç½‘一张图
 * aFigurePipelineNetwork
 *
 * @author xing
 * @date 2023/02/13
 */

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

    @Autowired
    OneMapService aMapOfPipelineService;

    //@SysLog()
    @GetMapping("/hello")
    public ResponseMsg<Object> hello() {
        System.out.println("log = " + log);
        return success("hello! æ‚¨å·²ç»æˆåŠŸè®¿é—®", 1);
    }


    //============[项目统计 project Statistics]==================

    /**
     * é¡¹ç›®ç±»åˆ«
     * Project category
     */
    @ApiOperation(value = "项目类别")
    @GetMapping("/countProjectCategory")
    public ResponseMsg<Object> projectCategoryConut() {
        List<String> resList = aMapOfPipelineService.projectCategoryConut();
        return success(resList);
    }

    /**
     * é¡¹ç›®ä½ç½®åˆ†å¸ƒæŽ¥å£
     * Project location
     */
    @ApiOperation(value = "项目位置分布接口")
    @GetMapping("/countProjectLocation")
    public ResponseMsg<Object> projectLocationConut() {
        List<String> resList = aMapOfPipelineService.projectLocationConut();
        return success(resList);
    }


    /**
     * å›½å®¶ç»´åº¦-数量统计
     * Country dimension
     */
    @ApiOperation(value = "国家维度-数量统计")
    @GetMapping("/conutCountryDimension")
    public ResponseMsg<Object> countryDimensionConut() {
        List<String> resList = aMapOfPipelineService.countryDimensionConut();
        return success(resList);
    }

    /**
     * çœç»´åº¦-数量统计
     * Province dimension - quantity
     */
    @ApiOperation(value = "省维度-数量统计")
    @GetMapping("/conutProvinceDimension")
    public ResponseMsg<Object> provinceDimensionConut() {
        List<String> resList = aMapOfPipelineService.provinceDimensionConut();
        return success(resList);
    }


    //============[数据统计 data Statistics]==================

    /**
     * æ•°æ®ç»Ÿè®¡
     * æ•°æ®å­˜å‚¨
     * data storage
     */
    @ApiOperation(value = "数据存储统计")
    @GetMapping("/countDataStorage")
    public ResponseMsg<Object> dataStorageConut() {
        List<String> resList = aMapOfPipelineService.dataStorageConut();
        return success(resList);
    }

    /**
     * æ•°æ®ç»Ÿè®¡
     * æ–‡ä»¶æ ¼å¼ç»´åº¦-文件个数
     * File format dimension
     */
    @ApiOperation(value = "文件格式维度-文件个数")
    @GetMapping("/conutFileFormat")
    public ResponseMsg<Object> fileFormatConut() {
        List<String> resList = aMapOfPipelineService.fileFormatConut();
        return success(resList);
    }

    /**
     * æ•°æ®ç»Ÿè®¡
     * æ•°æ®ç”³è¯·
     * Data application
     */
    @ApiOperation(value = "数据申请")
    @GetMapping("/conutDataApply")
    public ResponseMsg<Object> dataApplyConut() {
        List<String> resList = aMapOfPipelineService.dataApplyConut();
        return success(resList);
    }

    /**
     * æ•°æ®ç»Ÿè®¡
     * è®¿é—®æ¬¡æ•°
     * Number of visits
     */
    @ApiOperation(value = "访问次数")
    @GetMapping("/conutDataVisit")
    public ResponseMsg<Object> dataVisitConut() {
        List<String> resList = aMapOfPipelineService.dataVisitConut();
        return success(resList);
    }


    /**
     * æ•°æ®ç»Ÿè®¡
     * è®¿é—®æ¬¡æ•°
     * Number of visits
     */
    @ApiOperation(value = "访问次数")
    @GetMapping("data_visit1")
    public ResponseMsg<Object> dataVisitConut1() {
        List<String> resList = aMapOfPipelineService.dataVisitConut();
        return success(resList);
    }


}

 src/main/java/com/lf/server/entity/show/OneMapEntity.java

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

import java.io.Serializable;

public class OneMapEntity implements Serializable {
    private static final long serialVersionUID = 1L;





}

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

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


import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import java.util.List;

@Mapper
@Repository
public interface OneMapMapper {


    /**
     * é¡¹ç›®ç±»åˆ«conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectCategoryConut();

    /**
     * é¡¹ç›®ä½ç½®conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectLocationConut();

    /**
     * å›½å®¶ç»´åº¦conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> countryDimensionConut();

    /**
     * çœç»´conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> provinceDimensionConut();

    /**
     * æ•°æ®å­˜å‚¨conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataStorageConut();

    /**
     * æ–‡ä»¶æ ¼å¼conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> fileFormatConut();

    /**
     * æ•°æ®ç”³è¯·conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataApplyConut();

    /**
     * æ•°æ®è®¿é—®conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataVisitConut();


}

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

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

import com.lf.server.mapper.show.OneMapMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class OneMapService implements OneMapMapper {

    @Autowired
    OneMapMapper aMapOfPipelineMapper;

    /**
     * é¡¹ç›®ç±»åˆ«conut
     */
    public List<String> projectCategoryConut() {
        return aMapOfPipelineMapper.projectCategoryConut();
    }

    /**
     * é¡¹ç›®ä½ç½®conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> projectLocationConut() {
        return aMapOfPipelineMapper.projectLocationConut();
    }


    /**
     * å›½å®¶ç»´åº¦conut
     */
    public List<String> countryDimensionConut() {
        return aMapOfPipelineMapper.countryDimensionConut();
    }


    /**
     * çœç»´conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> provinceDimensionConut() {
        return aMapOfPipelineMapper.provinceDimensionConut();
    }

    /**
     * æ•°æ®å­˜å‚¨conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataStorageConut() {
        return aMapOfPipelineMapper.dataStorageConut();
    }

    /**
     * æ–‡ä»¶æ ¼å¼conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> fileFormatConut() {
        return aMapOfPipelineMapper.fileFormatConut();
    }

    /**
     * æ•°æ®ç”³è¯·conut
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> dataApplyConut() {
        return aMapOfPipelineMapper.dataApplyConut();
    }

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


}

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,54 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.lf.server.mapper.show.OneMapMapper">


    <!--  é¡¹ç›®ç±»åˆ« select * from bs.bs_project;  -->
    <select id="projectCategoryConut" 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 a.*,st_astext(geom) from bs.bs_project a;
    </select>

    <!--  é¡¹ç›®ç±»åˆ« å›½å®¶ç»´åº¦-数量  -->
    <select id="countryDimensionConut" resultType="java.util.Map">
        select country,count(*) from bs.bs_project group by country;
    </select>

    <!--  é¡¹ç›®ç±»åˆ« çœç»´åº¦-数量  -->
    <select id="provinceDimensionConut" 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 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 type,count(*),count(sizes) from lf.sys_meta group by type;
    </select>

    <!--  æ•°æ®ç»Ÿè®¡ æ•°æ®ç”³è¯·  -->
    <select id="dataApplyConut" 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 modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
    </select>




</mapper>