1

13693261870

2022-11-20 99ef95714f6b3ea5040901a3d1b26ab5e92101a1

1

 src/main/java/com/lf/server/config/InitConfig.java

@@ -95,7 +95,7 @@
    private void testMybatisPlus() {
        String s1 = locateService.selectWktById(1);

        String tabName = baseQueryService.getTabName(dlgAgnpMapper);
        String tabName = BaseQueryService.getTabName(dlgAgnpMapper);
        List<String> list0 = dlgAgnpMapper.selectFieldFuzzy(tabName, "name", "%县%");

        DlgAgnpEntity dlg = dlgAgnpMapper.selectById(1);

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

@@ -108,7 +108,7 @@
                return fail("查询对象不存在", null);
            }

            String tab = baseQueryService.getTabName(baseMapper);
            String tab = BaseQueryService.getTabName(baseMapper);
            if (StringHelper.isNull(tab)) {
                return fail("查询对象不存在", null);
            }
@@ -139,7 +139,7 @@
                return fail("查询对象不存在", null);
            }

            String tab = baseQueryService.getTabName(baseMapper);
            String tab = BaseQueryService.getTabName(baseMapper);
            if (StringHelper.isNull(tab)) {
                return fail("查询对象不存在", null);
            }
@@ -217,7 +217,7 @@
                return fail("查询对象不存在", null);
            }

            String tabName = baseQueryService.getTabName(baseMapper);
            String tabName = BaseQueryService.getTabName(baseMapper);
            if (tabName == null) {
                return null;
            }
@@ -244,7 +244,7 @@
                return fail("查询对象不存在", null);
            }

            String tabName = baseQueryService.getTabName(baseMapper);
            String tabName = BaseQueryService.getTabName(baseMapper);
            if (tabName == null) {
                return null;
            }

 src/main/java/com/lf/server/mapper/all/GeomBaseMapper.java

@@ -32,11 +32,11 @@
    /**
     * 更新空间位置
     *
     * @param tab  表名
     * @param gid  GID
     * @param geom 空间位置
     * @param tab 表名
     * @param gid GID
     * @param wkt WKT
     * @return 影响行数
     */
    @Update("update ${tab} set geom = ST_GeomFromText('${geom}') where gid = #{gid}")
    public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("geom") String geom);
    @Update("update ${tab} set geom = ST_GeomFromText('${wkt}') where gid = #{gid}")
    public Integer updateGeom(@Param("tab") String tab, @Param("gid") Integer gid, @Param("wkt") String wkt);
}

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

@@ -170,7 +170,7 @@
     * @param basicMapper Mapper
     * @return 表名
     */
    public String getTabName(BasicMapper basicMapper) {
    public static String getTabName(BasicMapper basicMapper) {
        String className = ClassHelper.getClassName(basicMapper);
        if (tabMap.containsKey(className)) {
            return tabMap.get(className);
@@ -185,7 +185,7 @@
     * @param className Mapper类名
     * @return 表名
     */
    private String getTabName(String className) {
    private static String getTabName(String className) {
        Class clazz = ClassHelper.getEntityClass(className);
        if (clazz == null) {
            return null;

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

@@ -1,6 +1,8 @@
package com.lf.server.service.data;

import com.baomidou.mybatisplus.annotation.TableName;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.lf.server.entity.all.BaseEntity;
import com.lf.server.entity.ctrl.TabMapperEntity;
import com.lf.server.entity.data.MetaEntity;
import com.lf.server.entity.data.MetaFileEntity;
@@ -8,6 +10,7 @@
import com.lf.server.helper.ExcelHelper;
import com.lf.server.helper.FileHelper;
import com.lf.server.mapper.all.GeomBaseMapper;
import com.lf.server.service.all.BaseQueryService;
import com.lf.server.service.all.BaseUploadService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -223,16 +226,23 @@
    /**
     * 设置创建信息
     */
    @SuppressWarnings("AlibabaRemoveCommentedCode")
    private <T> void setCreateInfo(List<T> list, MetaFileEntity mfe) {
        try {
            for (T t : list) {
                Field cuField = t.getClass().getDeclaredField("createUser");
                /*Field cuField = t.getClass().getDeclaredField("createUser");
                cuField.setAccessible(true);
                cuField.set(t, mfe.getCreateUser());

                Field ctField = t.getClass().getDeclaredField("createTime");
                ctField.setAccessible(true);
                ctField.set(t, mfe.getCreateTime());
                ctField.set(t, mfe.getCreateTime());*/

                if (t instanceof BaseEntity) {
                    BaseEntity be = (BaseEntity) t;
                    be.setCreateUser(mfe.getCreateUser());
                    be.setCreateTime(mfe.getCreateTime());
                }
            }
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);
@@ -244,6 +254,7 @@
     */
    private <T> void updateGeom(GeomBaseMapper geomBaseMapper, List<T> list) {
        try {
            String tabName = BaseQueryService.getTabName(geomBaseMapper);
            for (T t : list) {
                Field xField = t.getClass().getDeclaredField("x");
                xField.setAccessible(true);
@@ -253,13 +264,11 @@
                yField.setAccessible(true);
                double y = (double) yField.get(t);

                BaseEntity baseEntity = (BaseEntity) t;
                Integer gid = baseEntity.getGid();

                String wkt = String.format("POINT(%f %f)", x, y);

                Field gField = t.getClass().getDeclaredField("geom");
                gField.setAccessible(true);
                gField.set(t, wkt);

                //Integer gid=
                geomBaseMapper.updateGeom(tabName, gid, wkt);
            }
        } catch (Exception ex) {
            log.error(ex.getMessage(), ex);

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

@@ -36,7 +36,7 @@
    }

    public String selectWktById(Integer id) {
        String tab = baseQueryService.getTabName(dlgAgnpMapper);
        String tab = BaseQueryService.getTabName(dlgAgnpMapper);
        if (StringHelper.isNull(tab)) {
            return null;
        }