Merge branch 'master' of http://192.168.20.39:8989/r/LFServer

13693261870

2023-02-21 1d2bfa85cee5e1cc81e726797936cb4581464de0

Merge branch 'master' of http://192.168.20.39:8989/r/LFServer

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

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,162 @@
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;
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("/oneMap")
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
     */
    @SysLog()
    @ApiOperation(value = "项目类别")
    @GetMapping("/countProjectCategory")
    public ResponseMsg<Object> projectCategoryCount() {
        List<String> resList = aMapOfPipelineService.projectCategoryCount();
        return success(resList);
    }

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


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

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


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

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

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

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

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


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


}

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

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

import java.io.Serializable;

/**
 * å®˜ç½‘一张图实体
 *
 * @author xing
 * @date 2023/02/20
 */
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> projectCategoryCount();

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

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

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

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

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

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

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


}

 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> projectCategoryCount() {
        return aMapOfPipelineMapper.projectCategoryCount();
    }

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


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


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

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

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

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

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


}

 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="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="projectLocationCount" resultType="java.util.Map">
        select a.*,st_astext(geom) from bs.bs_project a;
    </select>

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

    <!--  é¡¹ç›®ç±»åˆ« çœç»´åº¦-数量  -->
    <select id="provinceDimensionCount" resultType="java.util.Map">
        select province,count(*) from bs.bs_project where country like '%中国%' group by province ;
    </select>

    <!--  æ•°æ®ç»Ÿè®¡ æ•°æ®å­˜å‚¨  -->
    <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="fileFormatCount" resultType="java.util.Map">
        select type,count(*),count(sizes) from lf.sys_meta group by type;
    </select>

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




</mapper>