From b2e4845b84b23aa3f9cc01141c74a8a27c56c17a Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 13 三月 2023 10:52:39 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/data/MetaService.java | 62 ++++++++++++++++++++++++++++++-
1 files changed, 60 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/lf/server/service/data/MetaService.java b/src/main/java/com/lf/server/service/data/MetaService.java
index 03ae908..1274a36 100644
--- a/src/main/java/com/lf/server/service/data/MetaService.java
+++ b/src/main/java/com/lf/server/service/data/MetaService.java
@@ -1,11 +1,20 @@
package com.lf.server.service.data;
+import com.lf.server.entity.all.StaticData;
import com.lf.server.entity.data.MetaEntity;
+import com.lf.server.entity.sys.AttachEntity;
+import com.lf.server.helper.PathHelper;
import com.lf.server.helper.StringHelper;
+import com.lf.server.helper.WebHelper;
import com.lf.server.mapper.data.MetaMapper;
+import com.lf.server.service.all.UploadAttachService;
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import javax.servlet.http.HttpServletResponse;
+import java.io.File;
import java.util.ArrayList;
import java.util.List;
@@ -16,7 +25,12 @@
@Service
public class MetaService implements MetaMapper {
@Autowired
+ PathHelper pathHelper;
+
+ @Autowired
MetaMapper metaMapper;
+
+ private final static Log log = LogFactory.getLog(MetaService.class);
@Override
public Integer selectCount(String depcode, String dircode, Integer verid, String name) {
@@ -148,12 +162,56 @@
/**
* 鑾峰彇鍒犻櫎琛ㄨ褰昐QL
*/
- private String getDelTabsSql(List<MetaEntity> metas) {
+ public String getDelTabsSql(List<MetaEntity> metas) {
List<String> list = new ArrayList<>();
+ String tab = metas.get(0).getTab();
+
+ List<String> pids = new ArrayList<>();
for (MetaEntity me : metas) {
- list.add(String.format("delete from %s where parentid='%s'", me.getTab(), me.getEventid()));
+ if (tab.equals(me.getTab())) {
+ pids.add("'" + me.getEventid() + "'");
+ } else {
+ list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
+
+ pids.clear();
+ tab = me.getTab();
+ pids.add("'" + me.getEventid() + "'");
+ }
+ }
+
+ if (pids.size() > 0) {
+ list.add(String.format("delete from %s where parentid in (%s)", tab, StringHelper.join(pids, ",")));
}
return StringHelper.join(list, ";");
}
+
+ /**
+ * 鏌ョ湅鏂囦欢
+ */
+ public void downloadForView(String guid, boolean inline, HttpServletResponse res) {
+ try {
+ if (StringHelper.isEmpty(guid)) {
+ WebHelper.writeStr2Page(res, StaticData.NO_FILE);
+ return;
+ }
+
+ MetaEntity me = selectByGuid(guid, null);
+ if (me == null) {
+ WebHelper.writeStr2Page(res, StaticData.NO_FILE);
+ return;
+ }
+
+ String filePath = pathHelper.getConfig().getUploadPath() + File.separator + me.getPath();
+ File file = new File(filePath);
+ if (!file.exists() || file.isDirectory()) {
+ WebHelper.writeJson2Page(res, "鏂囦欢涓嶅瓨鍦�");
+ }
+
+ WebHelper.download(filePath, me.getName(), inline, res);
+ } catch (Exception ex) {
+ WebHelper.writeJson2Page(res, "鏂囦欢涓嬭浇鍑洪敊");
+ log.error(ex.getMessage(), ex);
+ }
+ }
}
--
Gitblit v1.9.3