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

xing

2023-02-21 af4568c1d9a1ba86252ed088cb5eecb01218aa86

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

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

@@ -191,16 +191,16 @@


    /**
     * 项目工程类型
     * Project type
     * 工程项目目录
     * Project Catalog
     */
    /*@SysLog()
    @ApiOperation(value = "项目工程类型")
    @GetMapping("/countProjectType")
    public ResponseMsg<Object> countProjectType() {
        List<String> resList = aMapOfPipelineService.countProjectType1();
    @SysLog()
    @ApiOperation(value = "工程项目目录")
    @GetMapping("/selectProjectType")
    public ResponseMsg<Object> selectProjectType1() {
        List<String> resList = aMapOfPipelineService.selectProjectType1();
        return success(resList);
    }*/
    }

    /**
     * 根据表名查询表字段信息

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

@@ -103,7 +103,7 @@
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> countProjectType1();
    public List<String> selectProjectType1();

    /**
     * 查询表信息

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

@@ -138,8 +138,8 @@
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> countProjectType1() {
        return aMapOfPipelineMapper.countProjectType1();
    public List<String> selectProjectType1() {
        return aMapOfPipelineMapper.selectProjectType1();
    }



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

@@ -73,13 +73,13 @@


    <!--  统计项目类型 1  -->
    <select id="countProjectType1" resultType="java.util.Map">
    <select id="selectProjectType1" resultType="java.util.Map">
        select (select string_agg(code, ',') from lf.sys_dir where name = a.name) "key", name "value" from lf.sys_dir a
        where name in ('测量（ESV）', '勘察（EGE）', '地灾（EGD）', '洞库（EGD）') group by name order by name;
    </select>

    <!--  统计项目类型 2  -->
    <select id="countProjectType2" resultType="java.util.Map">
    <select id="selectProjectType2" resultType="java.util.Map">
        select modular1,count(*) from lf.sys_operate group by modular1 order by modular1;
    </select>