管道基础大数据平台系统开发-【后端】-Server
上一版本: f3ae9fea | 补丁 | 提交 | 忽略空白
1
13693261870
2023-04-19 7d824c1e0b6fdd5ddb5d2cd783839895c416c75a 
1
已重命名5个文件
已修改3个文件
49 ■■■■■ 文件已修改
data/db_cx.sql 3 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/controller/all/PermsController.java 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/controller/data/LayerController.java 8 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/entity/data/LayerEntity.java 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/mapper/data/LayerMapper.java 4 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/java/com/lf/server/service/data/LayerService.java 6 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/application.yml 12 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
src/main/resources/mapper/data/LayerMapper.xml 10 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 
 data/db_cx.sql


@@ -40,8 +40,7 @@


select sizes,ceil(sizes) from lf.sys_meta order by id desc limit 100


select * from lf.sys_publish order by id desc;


select * from lf.sys_meta where type in ('tif', 'tiff', 'img', 'png', 'jpg') order by type






select fn_get_fullname(a.depcode, 1) depName, fn_get_fullname(a.dircode, 2) dirName, a.* from lf.sys_meta a order by id desc limit 10;










 src/main/java/com/lf/server/controller/all/PermsController.java


@@ -2,11 +2,11 @@




import com.lf.server.annotation.SysLog;


import com.lf.server.entity.all.*;


import com.lf.server.entity.sys.LayerEntity;


import com.lf.server.entity.data.LayerEntity;


import com.lf.server.entity.sys.MenuEntity;


import com.lf.server.entity.sys.UserEntity;


import com.lf.server.service.all.PermsService;


import com.lf.server.service.sys.LayerService;


import com.lf.server.service.data.LayerService;


import com.lf.server.service.sys.MenuService;


import com.lf.server.service.sys.TokenService;


import io.swagger.annotations.Api;




 src/main/java/com/lf/server/controller/data/LayerController.java


ÎļþÃû´Ó src/main/java/com/lf/server/controller/sys/LayerController.java ÐÞ¸Ä


@@ -1,11 +1,11 @@


package com.lf.server.controller.sys;


package com.lf.server.controller.data;




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.sys.LayerEntity;


import com.lf.server.entity.data.LayerEntity;


import com.lf.server.entity.sys.UserEntity;


import com.lf.server.service.sys.LayerService;


import com.lf.server.service.data.LayerService;


import com.lf.server.service.sys.TokenService;


import io.swagger.annotations.Api;


import io.swagger.annotations.ApiImplicitParam;


@@ -21,7 +21,7 @@


 * å›¾å±‚管理


 * @author WWW


 */


@Api(tags = "运维管理\\图层管理")


@Api(tags = "数据管理\\图层管理")


@RestController


@RequestMapping("/layer")


public class LayerController extends BaseController {




 src/main/java/com/lf/server/entity/data/LayerEntity.java


ÎļþÃû´Ó src/main/java/com/lf/server/entity/sys/LayerEntity.java ÐÞ¸Ä


@@ -1,4 +1,4 @@


package com.lf.server.entity.sys;


package com.lf.server.entity.data;




import java.io.Serializable;


import java.sql.Timestamp;




 src/main/java/com/lf/server/mapper/data/LayerMapper.java


ÎļþÃû´Ó src/main/java/com/lf/server/mapper/sys/LayerMapper.java ÐÞ¸Ä


@@ -1,6 +1,6 @@


package com.lf.server.mapper.sys;


package com.lf.server.mapper.data;




import com.lf.server.entity.sys.LayerEntity;


import com.lf.server.entity.data.LayerEntity;


import org.apache.ibatis.annotations.Mapper;


import org.springframework.stereotype.Repository;






 src/main/java/com/lf/server/service/data/LayerService.java


ÎļþÃû´Ó src/main/java/com/lf/server/service/sys/LayerService.java ÐÞ¸Ä


@@ -1,8 +1,8 @@


package com.lf.server.service.sys;


package com.lf.server.service.data;




import com.lf.server.entity.sys.LayerEntity;


import com.lf.server.entity.data.LayerEntity;


import com.lf.server.helper.StringHelper;


import com.lf.server.mapper.sys.LayerMapper;


import com.lf.server.mapper.data.LayerMapper;


import org.springframework.beans.factory.annotation.Autowired;


import org.springframework.stereotype.Service;






 src/main/resources/application.yml


@@ -41,8 +41,8 @@


  datasource:


    name: prod


    # JDBC åŸºæœ¬é…ç½® &currentSchema=public


    url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true


    #url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true


    #url: jdbc:postgresql://103.85.165.99:5433/langfang?useAffectedRows=true


    url: jdbc:postgresql://192.168.20.205:5433/langfang?useAffectedRows=true


    #url: jdbc:postgresql://127.0.0.1:5433/langfang?useAffectedRows=true


    username : postgres


    password: Postgres!_14_Lf


@@ -147,11 +147,11 @@


  # IIS的主机地址


  iisHost: 127.0.0.1


  # FME服务地址


  fmeUrl: http://103.85.165.99:8051/


  #fmeUrl: http://192.168.20.205:88/


  #fmeUrl: http://103.85.165.99:8051/


  fmeUrl: http://192.168.20.205:88/


  # å‡ºå›¾æœåŠ¡


  #exportServer: http://127.0.0.1/ExportMap


  exportServer: http://103.85.165.99:8050/ExportMap


  exportServer: http://127.0.0.1/ExportMap


  #exportServer: http://103.85.165.99:8050/ExportMap


  # Gdal驱动目录


  gdal_path: E:\terrait\TianJin\Zip\release-1928-x64-dev\release-1928-x64\bin


  # ç“¦ç‰‡åœ°å€




 src/main/resources/mapper/data/LayerMapper.xml


ÎļþÃû´Ó src/main/resources/mapper/sys/LayerMapper.xml ÐÞ¸Ä


@@ -1,6 +1,6 @@


<?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.sys.LayerMapper">


<mapper namespace="com.lf.server.mapper.data.LayerMapper">


    <select id="selectCount" resultType="java.lang.Integer">


        select count(*) from lf.sys_layer


        <where>


@@ -10,7 +10,7 @@


        </where>


    </select>




    <select id="selectByPage" resultType="com.lf.server.entity.sys.LayerEntity">


    <select id="selectByPage" resultType="com.lf.server.entity.data.LayerEntity">


        select * from lf.sys_layer


        <where>


            <if test="cnName != null">


@@ -21,17 +21,17 @@


        limit #{limit} offset #{offset}


    </select>




    <select id="selectAll" resultType="com.lf.server.entity.sys.LayerEntity">


    <select id="selectAll" resultType="com.lf.server.entity.data.LayerEntity">


        select (select ns from lf.sys_dict b where b.field = 'gid' and b.tab = a.en_name) "ns", a.*


        from lf.sys_layer a


        order by id;


    </select>




    <select id="selectById" resultType="com.lf.server.entity.sys.LayerEntity">


    <select id="selectById" resultType="com.lf.server.entity.data.LayerEntity">


        select * from lf.sys_layer where id = #{id}


    </select>




    <insert id="insert" parameterType="com.lf.server.entity.sys.LayerEntity">


    <insert id="insert" parameterType="com.lf.server.entity.data.LayerEntity">


        insert into lf.sys_layer


        (pid,cn_name,en_name,url,test_url,type,icon,level,order_num,is_show,create_user,create_time,bak,serve_type,data_type,elev,is_project)


        values