From 71726a1cb05790d6841595ef7daef5173f2cddfa Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期三, 29 三月 2023 09:43:11 +0800
Subject: [PATCH] 1
---
src/main/java/com/lf/server/service/data/MetaService.java | 190 +++++++++++++++++++++++++++++++++++++++++------
1 files changed, 166 insertions(+), 24 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 c6d0098..0430656 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.helper.PathHelper;
import com.lf.server.helper.StringHelper;
+import com.lf.server.helper.WebHelper;
import com.lf.server.mapper.data.MetaMapper;
+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.Collections;
import java.util.List;
/**
@@ -15,53 +24,73 @@
@Service
public class MetaService implements MetaMapper {
@Autowired
+ PathHelper pathHelper;
+
+ @Autowired
MetaMapper metaMapper;
- @Override
- public Integer selectCount(Integer depid, Integer dirid, String name) {
- name = StringHelper.getLikeStr(name);
+ private final static Log log = LogFactory.getLog(MetaService.class);
- return metaMapper.selectCount(depid, dirid, name);
+ @Override
+ public Integer selectCount(String depcode, String dircode, Integer verid, String name) {
+ depcode = StringHelper.getRightLike(depcode);
+ dircode = StringHelper.getRightLike(dircode);
+ name = StringHelper.getLikeUpperStr(name);
+
+ return metaMapper.selectCount(depcode, dircode, verid, name);
}
@Override
- public List<MetaEntity> selectByPage(Integer depid, Integer dirid, String name, Integer limit, Integer offset) {
- name = StringHelper.getLikeStr(name);
+ public List<MetaEntity> selectByPage(String depcode, String dircode, Integer verid, String name, Integer limit, Integer offset) {
+ depcode = StringHelper.getRightLike(depcode);
+ dircode = StringHelper.getRightLike(dircode);
+ name = StringHelper.getLikeUpperStr(name);
- return metaMapper.selectByPage(depid, dirid, name, limit, offset);
+ return metaMapper.selectByPage(depcode, dircode, verid, name, limit, offset);
}
@Override
- public Integer selectMetasForCount(Integer depid, String dirs, String name) {
- name = StringHelper.getLikeStr(name);
+ public Integer selectMetasForCount(String depcode, String dirs, String name) {
+ depcode = StringHelper.getRightLike(depcode);
+ name = StringHelper.getLikeUpperStr(name);
- return metaMapper.selectMetasForCount(depid, dirs, name);
+ return metaMapper.selectMetasForCount(depcode, dirs, name);
}
@Override
- public List<MetaEntity> selectMetasForPage(Integer depid, String dirs, String name, Integer limit, Integer offset) {
- name = StringHelper.getLikeStr(name);
+ public List<MetaEntity> selectMetasForPage(String depcode, String dirs, String name, Integer limit, Integer offset) {
+ depcode = StringHelper.getRightLike(depcode);
+ name = StringHelper.getLikeUpperStr(name);
- return metaMapper.selectMetasForPage(depid, dirs, name, limit, offset);
+ return metaMapper.selectMetasForPage(depcode, dirs, name, limit, offset);
}
@Override
public Integer selectCountForUpload(String name, Integer createUser, String types) {
- name = StringHelper.getLikeStr(name);
+ name = StringHelper.getLikeUpperStr(name);
return metaMapper.selectCountForUpload(name, createUser, types);
}
@Override
public List<MetaEntity> selectByPageForUpload(String name, Integer createUser, String types, Integer limit, Integer offset) {
- name = StringHelper.getLikeStr(name);
+ name = StringHelper.getLikeUpperStr(name);
return metaMapper.selectByPageForUpload(name, createUser, types, limit, offset);
}
@Override
- public List<MetaEntity> selectAll() {
- return metaMapper.selectAll();
+ public Integer selectCountByPid(Integer metaid, String name) {
+ name = StringHelper.getLikeUpperStr(name);
+
+ return metaMapper.selectCountByPid(metaid, name);
+ }
+
+ @Override
+ public List<MetaEntity> selectPageByPid(Integer metaid, String name, Integer limit, Integer offset) {
+ name = StringHelper.getLikeUpperStr(name);
+
+ return metaMapper.selectPageByPid(metaid, name, limit, offset);
}
@Override
@@ -72,6 +101,11 @@
@Override
public MetaEntity selectByGuid(String guid, String tab) {
return metaMapper.selectByGuid(guid, tab);
+ }
+
+ @Override
+ public List<MetaEntity> selectByIdsForTab(String ids) {
+ return metaMapper.selectByIdsForTab(ids);
}
@Override
@@ -95,13 +129,8 @@
}
@Override
- public Integer delete(int id) {
- return metaMapper.delete(id);
- }
-
- @Override
- public Integer deletes(List<Integer> ids) {
- return metaMapper.deletes(ids);
+ public Integer deletes(String sql, String ids) {
+ return metaMapper.deletes(sql, ids);
}
@Override
@@ -113,4 +142,117 @@
public Integer updates(List<MetaEntity> list) {
return metaMapper.updates(list);
}
+
+ /**
+ * 鍒犻櫎鍏冩暟鎹�
+ */
+ public Integer deletes(List<Integer> list) {
+ String ids = StringHelper.join(list, ",");
+
+ String sql = null;
+ List<MetaEntity> metas = selectByIdsForTab(ids);
+ if (null != metas && metas.size() > 0) {
+ sql = getDelTabsSql(metas);
+ }
+
+ return deletes(sql, ids);
+ }
+
+ /**
+ * 鑾峰彇鍒犻櫎琛ㄨ褰昐QL
+ */
+ public String getDelTabsSql(List<MetaEntity> metas) {
+ List<String> list = getTabDeletes(metas, metas.get(0).getTab());
+ addCascadDeletes(list);
+ addAttachDeletes(list);
+ Collections.reverse(list);
+
+ return StringHelper.join(list, ";");
+ }
+
+ private List<String> getTabDeletes(List<MetaEntity> metas, String tab) {
+ List<String> list = new ArrayList<>();
+
+ List<String> pids = new ArrayList<>();
+ for (MetaEntity me : metas) {
+ 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 list;
+ }
+
+ /**
+ * 娣诲姞绾ц仈鍒犻櫎
+ */
+ private void addCascadDeletes(List<String> list) {
+ int i = 0, c = list.size();
+ while (i < c) {
+ String str = list.get(i);
+ if (str.contains("bs.m_pipelinepoint ")) {
+ list.add(str.replace("bs.m_pipelinepoint ", "bs.m_pipesegment "));
+ list.add(str.replace("bs.m_pipelinepoint ", "bs.m_pipeline "));
+ }
+ if (str.contains("bs.s_explorationpoint ")) {
+ list.add(str.replace("bs.s_explorationpoint ", "bs.s_surveyworksite "));
+ }
+
+ i++;
+ }
+ }
+
+ /**
+ * 娣诲姞闄勪欢鍒犻櫎
+ */
+ private void addAttachDeletes(List<String> list) {
+ int i = 0, c = list.size();
+ while (i < c) {
+ String str = list.get(i);
+ String tab = str.substring("delete from ".length(), str.indexOf(" where "));
+ String select = str.replace("delete ", "select eventid ");
+
+ list.add(String.format("delete from lf.sys_attach where tab='%s' and tab_guid in (%s)", tab, select));
+
+ i++;
+ }
+ }
+
+ /**
+ * 鏌ョ湅鏂囦欢
+ */
+ 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