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

xing

2023-02-21 ab69ebc575d4d9225d15e0e174ebd9978cf1c217

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

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

@@ -4,6 +4,7 @@
import com.lf.server.annotation.SysLog;
import com.lf.server.controller.all.BaseController;
import com.lf.server.entity.all.ResponseMsg;
import com.lf.server.entity.bs.MpipelineEntity;
import com.lf.server.service.show.OneMapService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
@@ -32,8 +33,8 @@
    OneMapService aMapOfPipelineService;



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

    /**
     * 项目类别
     * Project category
@@ -158,8 +159,21 @@
    @SysLog()
    @ApiOperation(value = "项目工程巡视")
    @GetMapping("/countProjectTour")
    public ResponseMsg<Object> countProjectTour() {
        return success("hello! 您已经成功访问-项目工程巡视");
    public ResponseMsg<Object> countProjectTour(MpipelineEntity mpipelineEntity) {
        List<String> resList = aMapOfPipelineService.countProjectTour(mpipelineEntity);
        return success("hello! 您已经成功访问-项目工程巡视", resList);
    }

    /**
     * 项目工程巡视列表
     * Project inspection tour
     */
    @SysLog()
    @ApiOperation(value = "项目工程巡视列表")
    @GetMapping("/selectProjectTour")
    public ResponseMsg<Object> selectProjectTour() {
        List<String> resList = aMapOfPipelineService.selectProjectTour();
        return success(resList);
    }



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

@@ -1,5 +1,6 @@
package com.lf.server.mapper.show;

import com.lf.server.entity.bs.MpipelineEntity;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;
@@ -77,6 +78,20 @@
    public List<String> countProjectDisplay();

    /**
     * 统计项目参观
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> countProjectTour(MpipelineEntity mpipelineEntity);

    /**
     * 选择项目参观列表
     *
     * @return {@link List}<{@link String}>
     */
    public List<String> selectProjectTour();

    /**
     * 统计项目类型
     *
     * @return {@link List}<{@link String}>

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

@@ -1,5 +1,6 @@
package com.lf.server.service.show;

import com.lf.server.entity.bs.MpipelineEntity;
import com.lf.server.mapper.show.OneMapMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -102,6 +103,26 @@
    }

    /**
     * 统计项目参观
     *
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> countProjectTour(MpipelineEntity mpipelineEntity) {
        return aMapOfPipelineMapper.countProjectTour(mpipelineEntity);
    }

    /**
     * 选择项目参观列表
     *
     * @return {@link List}<{@link String}>
     */
    @Override
    public List<String> selectProjectTour() {
        return aMapOfPipelineMapper.selectProjectTour();
    }

    /**
     * 统计项目类型
     *
     * @return {@link List}<{@link String}>

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

@@ -53,6 +53,19 @@
        select PROJNAME,* from bs.bs_project WHERE PROJNAME IS NOT NULL;
    </select>

    <!--  工程巡视  -->
    <select id="countProjectTour" resultType="java.util.Map">
        SELECT st_astext(geom) AS wkt,* FROM bs.m_pipeline
        <where>
            <if test="pipename != null  and pipename != ''"> and pipename = #{pipename}</if>
        </where>
    </select>

    <!--  工程巡视列表  -->
    <select id="selectProjectTour" resultType="java.util.Map">
        SELECT DISTINCT pipename  FROM bs.m_pipeline;
    </select>


    <!--  统计项目类型 1  -->
    <select id="countProjectType1" resultType="java.util.Map">