1

13693261870

2023-03-24 e26af85e049516e6ce2b082bc2bc90bf71643e95

1

 data/db_cx.sql

@@ -33,12 +33,9 @@
select count(*) from bd.b_borehole -- 357824
select * from bd.b_borehole limit 10;

select * from lf.sys_layer order by id desc;
select * from lf.sys_publish
select length('a31a2492-66f0-430a-875b-24eb6f4752c2')
select * from bs.g_unstable_slope
select * from lf.sys_fme_log order by id desc

select * from lf.sys_dir where name='地灾点'
select * from lf.sys_dir where pid=0 and id>0 order by id




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

@@ -132,7 +132,7 @@
            }

            Page<Object> page = new Page<>(pageIndex, pageSize);
            page.addOrder(OrderItem.asc("gid"));
            page.addOrder(OrderItem.desc("gid"));
            IPage<Object> paged = baseMapper.selectPage(page, wrapper);

            return success(paged.getTotal(), paged.getRecords());

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

@@ -193,7 +193,7 @@
            wrapper.eq("parentid", meta.getEventid());

            Page<Object> page = new Page<>(pageIndex, pageSize);
            page.addOrder(OrderItem.asc("gid"));
            page.addOrder(OrderItem.desc("gid"));
            IPage<Object> paged = baseMapper.selectPage(page, wrapper);

            return success(paged.getTotal(), paged.getRecords());

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

@@ -98,7 +98,7 @@
            }

            Page<BsprojectEntity> page = new Page<>(pageIndex, pageSize);
            page.addOrder(OrderItem.asc("gid"));
            page.addOrder(OrderItem.desc("gid"));
            Page paged = bsprojectMapper.selectPage(page, wrapper);

            return success(paged.getTotal(), paged.getRecords());

 src/main/java/com/lf/server/controller/data/upload/QueryController.java

@@ -233,7 +233,7 @@
            wrapper.eq("parentid", meta.getEventid());

            Page<Object> page = new Page<>(pageIndex, pageSize);
            page.addOrder(OrderItem.asc("gid"));
            page.addOrder(OrderItem.desc("gid"));
            IPage<Object> paged = baseMapper.selectPage(page, wrapper);

            return success(paged.getTotal(), paged.getRecords());

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

@@ -149,7 +149,7 @@
            wrapper.eq("parentid", meta.getEventid());

            Page<Object> page = new Page<>(pageIndex, pageSize);
            page.addOrder(OrderItem.asc("gid"));
            page.addOrder(OrderItem.desc("gid"));
            IPage<Object> paged = baseMapper.selectPage(page, wrapper);

            return success(paged.getTotal(), paged.getRecords());

 src/main/java/com/lf/server/service/all/TestService.java

@@ -157,7 +157,7 @@
        // 页数 / 每页记录数
        Page<DlgagnpEntity> page = new Page<>(1, 10);
        // 升序排序
        page.addOrder(OrderItem.asc("gid"));
        page.addOrder(OrderItem.desc("gid"));
        // 分页：Wrapper查询条件
        Page<DlgagnpEntity> userPage = dlgagnpMapper.selectPage(page, null);
        // 总页数 / 总记录数：325 / 3247

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

@@ -24,7 +24,7 @@

    public Page<DlgagnpEntity> selectAddrByPage(String name, Integer pageSize, Integer pageIndex) {
        Page<DlgagnpEntity> paging = new Page<>(pageIndex, pageSize);
        paging.addOrder(OrderItem.asc("gid"));
        paging.addOrder(OrderItem.desc("gid"));

        QueryWrapper<DlgagnpEntity> wrapper = null;
        if (!StringHelper.isEmpty(name)) {

 src/main/resources/application.yml

@@ -151,6 +151,7 @@
  #fmeUrl: http://192.168.20.205:88/
  # 出图服务
  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
  # 瓦片地址