From d12b5b41ee33e7eb57f3c3fe00f4fae53eb93388 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期五, 06 一月 2023 09:25:44 +0800
Subject: [PATCH] 1.6
---
src/main/java/com/lf/server/service/data/DataLoaderService.java | 91 ++++++++++++++++++---------------------------
1 files changed, 37 insertions(+), 54 deletions(-)
diff --git a/src/main/java/com/lf/server/service/data/DataLoaderService.java b/src/main/java/com/lf/server/service/data/DataLoaderService.java
index 6846f09..92ce8e9 100644
--- a/src/main/java/com/lf/server/service/data/DataLoaderService.java
+++ b/src/main/java/com/lf/server/service/data/DataLoaderService.java
@@ -3,7 +3,6 @@
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;
import com.lf.server.helper.*;
import com.lf.server.mapper.all.BasicMapper;
import com.lf.server.mapper.all.GeomBaseMapper;
@@ -26,9 +25,6 @@
public class DataLoaderService extends BaseUploadService {
@Autowired
MetaService metaService;
-
- @Autowired
- MetaFileService metaFileService;
private final static String XLS = ".xls";
@@ -100,8 +96,8 @@
getGdbFiles(f.getName(), subPath, list);
continue;
}
- if (!fileName.contains(ZIP)) {
- //
+ if (fileName.contains(ZIP)) {
+ // 鏆傛椂涓嶅疄鐜�
}
}
@@ -208,14 +204,14 @@
/**
* 鎻掑叆鏂囦欢
*/
- public void insertFiles(MetaEntity entity, List<MetaFileEntity> list, List<TabMapperEntity> tabList) {
+ public void insertFiles(MetaEntity entity, List<MetaEntity> list, List<TabMapperEntity> tabList) {
try {
String temp = pathHelper.getConfig().getTempPath();
- String root = pathHelper.getConfig().getUploadPath();
+ String upload = pathHelper.getUploadFullPath();
- for (MetaFileEntity mf : list) {
+ for (MetaEntity mf : list) {
File file = new File(temp + File.separator + mf.getPath());
- File newFile = new File(root + File.separator + mf.getGuid());
+ File newFile = new File(upload + File.separator + mf.getGuid());
String type = getType(mf.getName().toLowerCase());
if (null == type) {
@@ -230,7 +226,7 @@
continue;
}
- MetaFileEntity old = metaFileService.selectByGuid(mf.getGuid());
+ MetaEntity old = metaService.selectByGuid(mf.getGuid());
String filePath = null == old ? newFile.getPath() : old.getPath();
int count = 0;
@@ -242,27 +238,22 @@
case "shp":
case "gdb":
case "mdb":
- insertDb(type, temp, mf, tab);
+ insertDb(type, temp, entity, tab);
break;
// case "xls":
default:
- insertXls(temp, mf, tab);
+ insertXls(temp, entity, mf, tab);
break;
}
if (0 == tab.getRows()) {
continue;
}
- MetaEntity me = createMetaEntity(entity, mf, tab.getTab(), tab.getRows());
+ MetaEntity me = createMetaEntity(entity, mf, tab.getTab(), tab.getRows(), filePath);
if (metaService.insert(me) == 0) {
continue;
}
- MetaFileEntity mfe = createMetaFileEntity(me, mf, filePath);
- if (metaFileService.insert(mfe) == 0) {
- metaService.delete(me.getId());
- continue;
- }
count += tab.getRows();
}
@@ -280,7 +271,7 @@
/**
* 鑾峰彇 Tabs
*/
- private List<TabMapperEntity> getTabs(MetaFileEntity mfe, List<TabMapperEntity> tabs) {
+ private List<TabMapperEntity> getTabs(MetaEntity mfe, List<TabMapperEntity> tabs) {
List<TabMapperEntity> list = new ArrayList<>();
for (TabMapperEntity tab : tabs) {
if (!tab.getFileName().equals(mfe.getName()) || StringHelper.isEmpty(tab.getEntity())) {
@@ -316,17 +307,20 @@
/**
* 鍒涘缓鍏冩暟鎹疄浣�
*/
- private MetaEntity createMetaEntity(MetaEntity entity, MetaFileEntity mf, String tab, int rows) {
+ private MetaEntity createMetaEntity(MetaEntity entity, MetaEntity mf, String tab, int rows, String filePath) {
MetaEntity me = new MetaEntity();
- me.setDepid(entity.getDepid());
+ me.setEventid(StringHelper.getGuid());
me.setDirid(entity.getDirid());
+ me.setDepid(entity.getDepid());
me.setVerid(entity.getVerid());
- me.setType(getType(mf.getName().toLowerCase()));
- me.setGather(entity.getGather());
- me.setBatch(entity.getBatch());
- me.setDescr(entity.getDescr());
me.setName(mf.getName());
+ me.setType(getType(mf.getName().toLowerCase()));
+ me.setGuid(entity.getGuid());
+ me.setPath(FileHelper.getRelativePath(filePath));
me.setSizes(mf.getSizes());
+ me.setBstab(tab);
+ me.setBsrows(rows);
+ // me.setMdtab()
me.setCreateTime(entity.getCreateTime());
me.setCreateUser(entity.getCreateUser());
@@ -334,25 +328,9 @@
}
/**
- * 鍒涘缓鍏冩暟鎹枃浠跺疄浣�
- */
- private MetaFileEntity createMetaFileEntity(MetaEntity me, MetaFileEntity entity, String filePath) {
- MetaFileEntity mfe = new MetaFileEntity();
- mfe.setName(entity.getName());
- mfe.setMetaid(me.getId());
- mfe.setGuid(entity.getGuid());
- mfe.setSizes(entity.getSizes());
- mfe.setPath(FileHelper.getRelativePath(filePath));
- mfe.setCreateUser(me.getCreateUser());
- mfe.setCreateTime(me.getCreateTime());
-
- return mfe;
- }
-
- /**
* 鎻掑叆Excel
*/
- private void insertXls(String root, MetaFileEntity mf, TabMapperEntity tab) {
+ private void insertXls(String root, MetaEntity me, MetaEntity mf, TabMapperEntity tab) {
BasicMapper basicMapper = ClassHelper.getBasicMapper(tab.getEntity());
if (null == basicMapper) {
return;
@@ -369,7 +347,7 @@
if (list.isEmpty()) {
return;
}
- setCreateInfo(list, mf);
+ setCreateInfo(list, me);
int rows = 0;
for (int i = 0, c = list.size(); i < c; i++) {
@@ -386,16 +364,21 @@
/**
* 璁剧疆鍒涘缓淇℃伅
*/
- private <T> void setCreateInfo(List<T> list, MetaFileEntity mf) {
+ private <T> void setCreateInfo(List<T> list, MetaEntity me) {
try {
- for (T t : list) {
- Field cuField = t.getClass().getDeclaredField("createuser");
- cuField.setAccessible(true);
- cuField.set(t, mf.getCreateUser());
+ if (!(list.get(0) instanceof BaseEntity)) {
+ return;
+ }
- Field ctField = t.getClass().getDeclaredField("createtime");
- ctField.setAccessible(true);
- ctField.set(t, mf.getCreateTime());
+ for (T t : list) {
+ BaseEntity be = (BaseEntity) t;
+ be.setEventid(StringHelper.getGuid());
+ be.setParentid(me.getEventid());
+ be.setCreateuser(me.getCreateUser());
+ be.setCreatetime(me.getCreateTime());
+ be.setDirid(me.getDirid());
+ be.setDepid(me.getDepid());
+ be.setVerid(me.getVerid());
}
} catch (Exception ex) {
log.error(ex.getMessage(), ex);
@@ -431,7 +414,7 @@
/**
* 鎻掑叆DB
*/
- private void insertDb(String type, String root, MetaFileEntity mf, TabMapperEntity tab) {
+ private void insertDb(String type, String root, MetaEntity me, TabMapperEntity tab) {
BasicMapper basicMapper = ClassHelper.getBasicMapper(tab.getEntity());
if (null == basicMapper) {
return;
@@ -462,7 +445,7 @@
if (null == list || list.isEmpty()) {
return;
}
- setCreateInfo(list, mf);
+ setCreateInfo(list, me);
int rows = basicMapper.insertBatch(list);
tab.setTab(tabName);
--
Gitblit v1.9.3